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
- 6181 Views
- TCS, I also Faced
- E-Mail Answers
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 a record Group?
How i call Reports from Forms10g.
what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)
What is lexical reference?How can it be created?
To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
What is a Query Record Group?
What is WHEN-Database-record trigger?
why the Ctl file u put only in bin folder why not in other folder
What is a Navigable item?
what are the new features introduced in oracle form services in 11g release 2?
What are the Coordination Properties in a Master-Detail relationship?
What are the two repeating frame always associated with matrix object?
Oracle General 
