Search Results m_2formattrigger

Overview

JA_JAINCINI_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner. It is a report-logic package generated to support an Oracle Reports XML Publisher (XMLP) report, specifically the JAINCINI report associated with Oracle's India Localization (JA) product family. The package supplies the PL/SQL functions referenced by the report's formula columns and format triggers, and it exposes a set of package-level variables that carry runtime parameters into the report query.

The public variables P_ORG_ID, P_LOC_ID, P_INVOICE_NO, P_CUSTOMER_ID, P_ORDER, and P_CONC_REQUEST_ID correspond to the report's input parameters, including the organization identifier, location identifier, invoice number, customer identifier, sort order, and the concurrent request ID. These values are populated by the report's Before Report trigger and reused by the various formula and format trigger functions throughout the report execution. Within EBS, the package participates in concurrent processing, since P_CONC_REQUEST_ID ties the invoked report to a row in the FND_CONCURRENT_REQUESTS table.

Key Procedures and Functions

The package documents twelve functions, which fall into three logical groups.

• CF_2FORMULA — a formula function that accepts a sum of duty and returns a VARCHAR2 value, typically used to format or convert a duty amount for display in the report layout.
• CONVERT_NUMBER — converts an integer input into its word or formatted character representation, a common requirement in Indian localization reports for printing amounts in words alongside numerals.
• CF_3FORMULA — returns a NUMBER value, usually computed from invoice or tax amounts for use in a numeric report column.
• CF_4FORMULA — accepts the result of CF_3 and returns a VARCHAR2, indicating a dependent calculation that formats or transforms the numeric output of CF_3FORMULA.
• CF_5FORMULA — returns a VARCHAR2, another computed display value within the report layout.
• CF_6FORMULA — returns a VARCHAR2 value used as an additional computed column.
• CF_7FORMULA — returns a DATE value, likely a derived or formatted date such as an invoice or delivery date.
• BEFOREREPORT — the report's Before Report trigger, returning BOOLEAN; it initializes parameters and prepares the query environment prior to report execution.
• AFTERREPORT — the After Report trigger, returning BOOLEAN, used for post-execution cleanup or finalization.
• M_3_GRPFR1FORMATTRIGGER — a format trigger on the M_3_GRPFR1 group within the report layout. Format triggers return a BOOLEAN that Oracle Reports evaluates to decide whether a given group or frame should be displayed, allowing conditional suppression or rendering of report sections.
• M_1FORMATTRIGGER — a format trigger associated with report group M_1, controlling conditional display of that group.
• M_2FORMATTRIGGER — a format trigger associated with report group M_2, performing the same conditional rendering role.

The M_x format triggers are auto-generated naming conventions produced by Oracle Reports when a format trigger is defined on a repeating frame or group at a given margin position. They give the report developer programmatic control over visibility of individual layout groups.

Tables Accessed

The package reads from six tables through APPS synonyms, each supporting the report's query and validation logic:

• FND_CONCURRENT_PROGRAMS — resolves the concurrent program definition associated with the report execution.
• FND_CONCURRENT_REQUESTS — links the runtime invocation to its concurrent request record, consistent with the P_CONC_REQUEST_ID parameter.
• JAI_CMN_INVENTORY_ORGS — provides inventory organization information for the India localization, enabling organization-specific reporting.
• RA_CUSTOMER_TRX_ALL — supplies customer transaction (invoice) header data for the report output.
• RA_CUSTOMER_TRX_LINES_ALL — supplies invoice line detail, from which duty, tax, and amount values used by the CF_x formulas are derived.
• WSH_NEW_DELIVERIES — provides delivery information, typically for reports that reconcile invoices against shipments or deliveries.

No documented tables are written to by this package; it functions solely as a read-and-compute layer for report generation.

Usage Notes

JA_JAINCINI_XMLP_PKG is not intended for direct invocation by application forms or by custom PL/SQL code. It is invoked by the Oracle Reports runtime when the associated JAINCINI report executable runs as a concurrent program. The report engine calls BEFOREREPORT during initialization, executes the report query, evaluates the CF_x formula functions as each row is fetched, and evaluates the M_x format triggers at each layout group boundary to determine visibility. AFTERREPORT runs at completion.

The package is version-labeled 120.1 with a header dated 2007 and marked "noship," indicating it is distributed as part of the India Localization patch set rather than as a standalone shipping product. The AUTHID CURRENT_USER setting means the executing user must hold the necessary privileges on the underlying tables. Because the package is referenced by zero other PL/SQL packages, it has no downstream programmatic dependents; its only consumer is the associated XML Publisher report definition. Modifications are normally made by regenerating the report in Oracle Reports Builder, which recreates the package body, so direct manual edits to the package are discouraged.