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;
Answers were Sorted based on User's Feedback
Answer / 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 |
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
What are the built-ins used for Getting cell values?
What do you mean by a block in forms4.0?
Is it possible to insert comments into sql statements return in the data model editor?
What are the default parameter that appear at run time in the parameter screen?
What are the ways to monitor the performance of the report?
I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.
all steps of bitmap report?
What is an Alert?
Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com
how to send sms to mobile phone from oracle forms.
What are different types of modules available in oracle form?