Search Results lot_no_p

Overview

APPS.GMI_GMILTGEN_XMLP_PKG is an Oracle EBS Oracle Process Manufacturing (OPM) package that underpins the Lot Genealogy XML Publisher report (GMILTGEN). Its $Header comment (GMILTGENS.pls 120.0, dated 2007/12/21) reflects the original source file from which the package is generated. In Oracle EBS 12.1.1 and 12.2.2, this package serves as the report logic container: it declares the bind/global variables that carry user-entered and derived values into the XML Publisher (BI Publisher) data template and hosts the PL/SQL functions that produce calculated columns at report execution time.

The business function is quality and lot traceability reporting for process manufacturing. The package exposes the report parameters — including item, lot, sublot, source flag, location flag, view-by mode and the QC flag — and assembles descriptive attributes such as item description, grade, inventory class, shelf life, retest interval and lot creation type. Critically for the user search term "qc_specformula," the package includes a documented function, QC_SPECFORMULA, which drives the display of specifications and QC result data for a lot, drawing on OPM quality tables. A companion set of "*_P" procedures (HEADER, ITEM_DESC_P, LOT_NO_P, SUBLOT_NO_P, INV_TYPE_P, SHELF_LIFE_P, INV_CLASS_P, GRADE_P, RETEST_INTERVAL_P, LOT_CREATION_TYPE_P, LOT_CREATION_TYPE_DESC_P) populates the report's formatted output columns.

Key Procedures and Functions

The package documents 48 procedures and functions. Principal groupings include:

• AFTERPFORM / AFTERREPORT — XML Publisher report hooks executed after the parameter form and after the report run respectively; these control report-level setup and cleanup behavior.
• ITEM_NOFORMULA, I_ITEM_NOFORMULA, DOC_NOFORMULA, CF_1FORMULA — lexically "formula" functions invoked from the BI Publisher template to render item numbers, document numbers and formatted date output.
• QC_SPECFORMULA — the function corresponding to the "qc_specformula" search term; it resolves and formats quality specification content for the report, reading the OPM specification and result tables.
• UOMFORMULA and IND_KEY2FORMULA — unit-of-measure and industry-key formatting functions used within the report template.
• HEADER, ITEM_DESC_P, LOT_NO_P, SUBLOT_NO_P, INV_TYPE_P, SHELF_LIFE_P, INV_CLASS_P, GRADE_P, RETEST_INTERVAL_P, LOT_CREATION_TYPE_P, LOT_CREATION_TYPE_DESC_P — procedures that select and assign lot-level attribute values used to render the report's descriptive columns.

Parameter lists are declared for the formula functions (for example, ITEM_NOFORMULA accepts item and lot identifiers; I_ITEM_NOFORMULA additionally receives a flag and level number), but the metadata supplied here does not fully document every signature; descriptions above are therefore limited to purpose.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• Quality management: GMD_QC_TESTS_B, GMD_RESULTS, GMD_SAMPLES, GMD_SPEC_RESULTS, GMD_SPEC_TESTS_B — source data for QC_SPECFORMULA and specification/result display.
• Lot and inventory: GMI_LOT_TRACE, GMI_LOT_TRACE_ID_S, IC_LOTS_MST, IC_ITEM_MST, IC_ADJS_JNL, IC_CYCL_HDR, IC_JRNL_MST — lot genealogy, item master and inventory transaction details.
• Order and costing context: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OP_BILL_LAD — sales order and bill-of-material/recipe references used for traceability reporting.

Usage Notes

GMI_GMILTGEN_XMLP_PKG is invoked as the report logic for the OPM Lot Genealogy (GMILTGEN) XML Publisher concurrent program; the AFTERPFORM and AFTERREPORT hooks fire automatically at report runtime. The formula functions are called from the XML data template. The package is referenced by 0 other packages, confirming it is a leaf-level report module rather than a shared library. It should not be called directly from forms; any custom code extension should target the standard report registration instead.