Answer / hari

else if body is not correct.

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?

can u call procedure or function is sq l query in reports

1 Answers  

---

What are the built_ins used the display the LOV?

1 Answers  

---

what is a package n what r the packages availbla in report

0 Answers   Convergys,

---

What is pop list?

2 Answers  

---

What are Most Common types of Complex master-detail relationships?

1 Answers  

---

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

0 Answers   Access Info,

---

Can you attach an lov to a field at design time?

1 Answers  

---

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   TCS,

---

In what sequence do triggers get fired by oracle forms?

0 Answers  

---

Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?

1 Answers  

---

how i build a report

1 Answers  

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

0 Answers  

---