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
- 5087 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 r the various types of reports
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
How we can migrate the 6i report to 10g reports. What steps need to reuired?
can i use lexical variable in formula column
Name the different triggers associated with oracle forms having a master-detail relationship.
What is a Navigable item?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
How to change maximise or minimise the window in forms
What is a list item?
How do you call other Oracle Products from Oracle Forms?
What is the difference between flex mode and confined mode?
What SYNCHRONIZE procedure does ?
Oracle General 
