Answer / malleswar

The trigger can be used to dynamically change the
formatting attributes of the object. Format triggers are
PL/SQL functions executed before the object is
formatted.The function must return a Boolean value (TRUE or
FALSE). Depending on whether the function returns TRUE or
FALSE, the current instance of the object is included or
excluded from the report output. You can access format
triggers from the Object Navigator, the Property Palette,
or the PL/SQL Editor.

Answer / samaresh

A format trigger can fire multiple times for a given
object, whenever Reports Builder attempts to format the
object. Consider the case where Reports Builder starts to
format the object at the bottom of a page. If the object
does not fit on the page, Reports Builder stops formatting
and reformats on the following page. In this case, the
format trigger will fire twice. It is therefore not
advisable to do any kind of "persistence" operation, such
as logging, in this trigger.


The Reports Builder SRW built-in package contains PL/SQL
procedures with which you can quickly change the format
attributes of an object.
These include procedures to:
change the border pattern and color of an object change the
interior pattern and color of an object change the font
size, style, weight, spacing, and justification of a field
or boilerplate text change the format mask of a field
access a field's value

Answer / muneer

ANS 1 IS CORRECT
THAKS MALLESH

MUNEER

Answer / ramesh babu v

It formats the data before displaying output data.It is the
pl/sql function and it returns the boolean
values(TRUE/FALSE).If return TRUE the layout displays.

what are the default arguments for pl/sql program?

1 Answers  

---

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  

---

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,

---

What do you understand by a set of books?

0 Answers  

---

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,

---

wht is format triger?

4 Answers  

---

Which module is not in multiorg

6 Answers   HCL, Wipro,

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,

---

what are the receipt types in Po?

2 Answers   Evosys, UST,

---

where do u specify in org_id?

2 Answers  

---

what is global tempory table?

1 Answers   BirlaSoft,

---