Please tell me what is wrong in the below query:
(Very Urgent)
=================================================
function BeforePForm return boolean is
begin
if :from_invoice_date is null OR :to_invoice_date is
null then
aiv.PERIOD_NMAE:=:gl_period
elsif :gl_period is null then
aiv.INVOICE_DATE between :from_invoice_date
and :to_invoice_date
end if;
return (TRUE);
end;
Answer Posted / sudipta santra
The function will be like that:-
function BeforePForm return boolean is
begin
if :from_invoice_date is null OR :to_invoice_date is null
then
aiv.PERIOD_NMAE:=:gl_period
elsif :gl_period is null or aiv.INVOICE_DATE between
:from_invoice_date and :to_invoice_date then
aiv.PERIOD_NMAE:=<insert value>
end if;
return (TRUE);
end;
Like that way it will be solved. In else part the assigned
value should be fixed how it would between two range of date?
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the new features introduced in oracle form services in 11g release 2?
What is an oracle report? List its various types.
a text item is there what r the different types of triggers associated with it
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is the difference between BPA AND Contract What are documents and test cases u followed
Why oracle forms required?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
Is it possible to execute a dynamic sql from forms?
What do you understand by lov and how can it be used?
Can we invoke one form from another in a multi-forms application?
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
what are the oracle forms services components include?
what is a package n what r the packages availbla in report
What do you understand by oracle forms?
what are bind variables?