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
- 5382 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 |
How you define procure to pay?
What is a text list?
What is the difference between BPA AND Contract What are documents and test cases u followed
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What is system.coordination_operation?
Identify package function from the following ?
What do you understand by oracle forms and why are they required?
What is a window?
What is AppCore and AppCore2 ?
Could u tell me, u work as a support & maintenace when sub ledger and gl is mismatch, then how do u match with the both side/
Name of the functions used to get/set canvas properties?
what u write in Ctl file
Oracle General 
