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.

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

---

Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

6 Answers   Tech Mahindra,

---

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

---

Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

0 Answers  

---

difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,

---

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

---

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  

---

what is repeting frame?

3 Answers   TCS,

---