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 is a package n what r the packages availbla in report
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Explain how can you use the same lov for 2 columns?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
Name the different triggers associated with oracle forms having a master-detail relationship.
What do you understand by lov?
In what situation u create the BPA.
How can we expand Parameter Form Canvas on Reports 6i?
What is the difference between flex mode and confined mode?
What is responsibility and how u attach How to create user and how u attach with responsibility.
Explain how one can iterate through items and records in a specified block?
What is the difference between BPA AND Contract What are documents and test cases u followed
Explain the different levels at which oracle form services interact.
what is oracle forms?
why the Ctl file u put only in bin folder why not in other folder