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
- 6272 Views
- TCS, I also Faced
- E-Mail Answers
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
List out the oracle forms configuration files?
Is it possible to have multiple layouts in a report?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
if u want to delete all these detail block etc what will happen in form
what is tripstop report?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
what is difference between group above and group left report
What is a user exit program in oracle reports?
Can we invoke one form from another in a multi-forms application?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
if some data is not transfered where it will get stored
Explain the various types of oracle report?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
