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 it possible to have multiple layouts in a report?

801

---

Can we invoke one form from another in a multi-forms application?

864

---

What do you understand by oracle forms and why are they required?

763

---

if u want to delete all these detail block etc what will happen in form

1726

---

In what situation u create the BPA.

1964

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

1819

---

difference between global n context sensitive segments?

2434

---

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

2058

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2058

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2144

---

what are bind variables?

802

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1054

---

How to create Drill down report?

1890

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1661

---

what is difference between group above and group left report

3575

---