Search Results cf_delete_transformula

Overview

APPS.GME_GMEBCHYV_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite XML Publisher concurrent program GMEBCHYV. In the Process Manufacturing (OPM) module, this report is commonly identified as the Batch Yield Variance report, and the package encapsulates the report's data selection, formula columns, and layout trigger logic that XML Publisher invokes at runtime.

The package's core purpose is to compute and compare actual versus planned batch consumption and yield values at the material, formula, and batch level. It exposes a set of public formula functions that map directly to the XML Publisher report's computed columns, along with report-level triggers (BEFOREREPORT, AFTERREPORT, HEADER) and a set of global variables that carry parameter and range values through the report's execution. The package is flagged in ETRM as API classification OTHER, meaning it is not a public integration API; it is intended solely for report execution.

Key Procedures and Functions

The documented procedures and functions fall into several functional groups.

• Range and display formulas: CF_BATCHRANGEFORMULA, CF_DATERANGEFORMULA, and CF_ITEM_RANGE build the human-readable batch, date, and item ranges displayed in the report header, drawing on the BATCHUM, FROMBATCH/TOBATCH, FROMDATE/TODATE, and FROMITEM/TOITEM globals.
• Cost and quantity formulas: CF_ACCTG_COST2FORMULA, CF_ACCTNG_COST1FORMULA, CF_FORMULA_QTY, CF_PLAN_QTY_ITEMUMFORMULA, and CF_ACTUAL_QTY_UMFORMULA compute the accounting cost, planned quantity, formula quantity, and actual quantity figures used in each report line.
• Variance calculations: CF_QUANTITY_VARIANCE, CF_VALUE_VARIANCE, and CF_VARIANCE_PCT derive quantity, value, and percentage variances between actual and planned amounts.
• UOM and transformation helpers: CF_UOMFORMULA, CF_DELETE_TRANSFORMULA, and CF_CONTEXT_ORGFORMULA resolve unit-of-measure conversions and organizational context.
• Report triggers: BEFOREREPORT, AFTERREPORT, and HEADER initialize globals, set up the report context, and control header output.
• Parameter globals: BATCHUM_P, CP_ITEM_COST_P, and CP_BATCHRANGE_P hold parameter/global values referenced throughout the package.

The package also declares globals including P_CODE, FROMBATCH, TOBATCH, FROMDATE, TODATE, FROMITEM, TOITEM, CURR_CODE, NONBLOCKSQL, P_CONC_REQUEST_ID, P_ORG_ID, BATCHUM, CP_ITEM_COST, CP_BATCHRANGE, CP_DATERANGE, and CP_ITEMRANGE.

Tables Accessed

• GME_MATERIAL_DETAILS / FM_MATL_DTL: source of actual material consumption and transaction detail feeding the actual quantity and cost formulas.
• GME_SCALE_DETAIL: provides scale and batch sizing information used in formula quantities.
• GMD_RECIPE_VALIDITY_RULES: supplies recipe validity context required by CF_FORMULA_QTY and CF_PLAN_QTY_ITEMUMFORMULA.
• MTL_SYSTEM_ITEMS_B: item master attributes (UOM, descriptions) for item range and UOM conversion logic.
• MTL_PARAMETERS: organization-level defaults such as currency and inventory parameters.
• FND_DUAL: used to evaluate expressions and single-row selections.
• PLITBLM: EBS-standard PL/SQL table for list handling within report logic.

Usage Notes

GME_GMEBCHYV_XMLP_PKG is invoked exclusively through the XML Publisher concurrent program GMEBCHYV. It is referenced by zero other packages, confirming that it is not called from custom code or other APIs. The package is registered under the APPS schema and is regenerated whenever the underlying report definition changes; direct modification of the package body is not supported and would be overwritten on patching.