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
- 5059 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 the order of the triggers fired once the form is opened?
i want print character reports in 10g application reports pl help me my id is yoga.roh@gmail.com
What are the unrestricted procedures used to change the popup screen position during run time ?
Can you truncate a table in a procedure in Oracle Forms?
How you define procure to pay?
What is an User Exits ?
What is a matrix report and how many minimum groups are required to prepare the same?
If two groups are not linked in the data model editor, What is the hierarchy between them?
What are the trigger associated with image items?
What is forms_DDL?
List the editors availables in forms 4.0?
What is the Maximum allowed length of Record group Column?
Oracle General 
