Search Results cf_trans_qtyformula

Overview

GME_GMEBCHPL_XMLP_PKG is an Oracle Applications (APPS) PL/SQL package that supports the Oracle Process Manufacturing (OPM/GME) "Batch Planning" style BI Publisher/XML Publisher concurrent report. It belongs to the GME (Process Manufacturing) module and is classified as a report-support package (API classification OTHER). Its core role is to hold report-level global variables and to expose the report trigger and group/column formula functions that XML Publisher invokes during report execution. In EBS releases 12.1.1 and 12.2.2 this package is deployed in the APPS schema and is generated with a build header dated 2007, indicating it has remained stable across the 11i-to-R12 upgrade path.

The package is anchored on a header number of parameters: the p_code, from_batch/to_batch, from_whse/to_whse, from_date/to_date, sort_by, org_id and concurrent request ID, plus cached character forms of the date, batch, warehouse and sort ranges. These globals are populated by the report's Before Report trigger and then reused by the many formula functions.

Key Procedures and Functions

• CF_TRANS_QTYFORMULA — the entry most frequently searched (matched on "cf_trans_qtyformula"). It is a column formula that converts or formats the transaction quantity value supplied to it, returning a NUMBER to the report layout.
• CF_SUM_TRANS_QTYFORMULA, CF_SUM_TRANS_QTY2FORMULA, CF_TRANS_QTY2FORMULA — sibling quantity formulas applying the same conversion/rounding logic to the summary and secondary quantity columns.
• CF_BATCHRANGEFORMULA, CF_WHSERANGEFORMULA, CF_DATERANGEFORMULA, CF_SORTBYFORMULA — produce the display strings for the batch, warehouse, date and sort-by range parameters shown in the report header.
• CF_ACTUAL_START_DATEFORMULA — normalises the actual start date for presentation.
• CF_PLAN_QTY2FORMULA and CF_INV_PLAN_QTYFORMULA — convert planned quantities and inventory planned quantities using item unit-of-measure information (item_um, item_um2, item_um4, item_id), performing UOM conversion for the reported quantities.
• CF_CONTEXTORGFORMULA — returns the operating unit / org context character used for multi-org security in the report query.
• SORTRETCFFORMULA — derives the sort return key for the report's group ordering.
• AFTERPFORM, BEFOREREPORT, AFTERREPORT — the standard report triggers; BEFOREREPORT validates/defaults the parameter globals, AFTERPFORM runs after the parameter form, and AFTERREPORT performs post-processing.
• HEADER — builds header-level report output.
• CP_BATCHRANGE_P, CP_WHSERANGE_P, CP_DATERANGE_P, CP_SORTBY_P — accessor functions returning the cached range/sort parameter values.

Tables Accessed

• MTL_PARAMETERS — the inventory organisation parameters table, read via an APPS synonym to resolve organisation-level attributes (such as default UOM/primary UOM context) used by the quantity and UOM-conversion formulas.
• DUAL — used for single-row computations, default assignments and SYSDATE-derived values.

No other tables are documented as directly referenced by this package's own body; the main report query supplies the transaction and batch data, and the package operates primarily on those values.

Usage Notes

This package is not a general-purpose API and is not referenced by any other documented package. It is invoked exclusively by the XML Publisher concurrent report that owns it, which generates the report output for batch planning/listing. Customisations should avoid modifying the package directly, since it is regenerated by the underlying .pls source (GMEBCHPLS.pls) during patching. External code that needs the same transaction quantity formatting behaviour (the CF_TRANS_QTYFORMULA logic) should replicate that arithmetic rather than call the package, as the functions are report-scoped and rely on globals populated only within the report execution cycle.