Interested to Buy Any Domain ? << Click Here >> for more details...
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;
- 2 Answers
- 6093 Views
- TCS, I also Faced
- E-Mail Answers
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
Can we invoke one form from another in a multi-forms application?
In what sequence do triggers get fired by oracle forms?
where do u put the report file
What do we mean by record group in oracle forms?
how do u compile a form i.e .fmb file in Unix or in dos
how do u place it in required folder
Name the different triggers supported by oracle reports and their firing order.
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
what are bind variables?
what are the oracle forms services components include?
a text item is there what r the different types of triggers associated with it
What do you understand by lov and how can it be used?
What is a user exit program in oracle reports?
hiding item in report how like that properly,thats manually but at runtime i want to do
What is an oracle report?
