Results for “p_high_cat”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.MRP_MRPRPSST_XMLP_PKG is the generated package body that supports the Oracle E-Business Suite concurrent report program "MRPRPSST" (the MPS/MRP Schedule Status report, sometimes referenced as the Schedule Status/Supply-Demand report). Like all _XMLP_PKG bodies, it is auto-generated by the Oracle Reports-to-XML Publisher migration utility and exists to supply the runtime PL/SQL logic that XML Publisher templates cannot express natively. The package supplies formula columns, before/after-report triggers, lexical WHERE and ORDER BY construction, and multi-organization context resolution required by the report layout. It operates within the Oracle Inventory/MRP planning schema and references planning, item-master, and category-set tables through APPS synonyms.
Key Procedures and Functions
The package exposes seventeen documented procedures and functions. The report-lifecycle entry points are BEFOREREPORT and AFTERREPORT; the latter performs the SRW user exit cleanup (FND SRWEXIT) that closes the Reports runtime context.
Formula functions perform numeric and look-up derivation for report columns. C_PERIOD_DELTAFORMULA computes the difference between actual and scheduled quantities, rounded to the quantity precision. C_SCHED_COSTFORMULA, C_PERIOD_DELTA_COSTFORMULA, C_PERIOD_DELTA_CUM_COSTFORMULA, and C_ACTUAL_COSTFORMULA each multiply their respective quantity or delta values by an item cost, rounded to the report precision parameter.
Descriptive look-up functions translate coded values into display meanings. C_SCHED_VERSIONFORMULA resolves the schedule level meaning from MRP_SCHEDULE_LEVEL, and C_SORTFORMULA resolves the data-select meaning from MRP_DATA_SELECT, both via MFG_LOOKUPS.
Flexfield and parameter-driven functions include C_CAT_SETFORMULA (category set), C_CATEGORY_FROMFORMULA and C_CATEGORY_WHEREFORMULA (category selection SQL fragments), C_P_MULTIORG_MPSFORMULA, C_P_REPORT_MULTIORGFORMULA, and C_P_USE_MULTIORG_PLANFORMULA (multi-organization parameter resolution), and C_ORDER_BYFORMULA (dynamic sort clause generation). MRP_WEEKS_MONTHS builds the time-bucket calendar used in the report's period columns.
Tables Accessed
The package reads MRP_FORM_QUERY_S, which stores saved report query definitions and drives the dynamic query and sort behaviour. MRP_SCHEDULE_DESIGNATORS supplies schedule designator data used to resolve the schedule version and level displayed. MTL_CATEGORY_SETS and its associated structures provide the category set flexfield definitions used by the category-related formulas. MTL_PARAMETERS supplies inventory organization defaults, including the organization context required for multi-org report execution. In addition, look-up resolution accesses MFG_LOOKUPS, as shown in the documented source for C_SCHED_VERSIONFORMULA and C_SORTFORMULA.
Usage Notes
This package is invoked implicitly when the MRPRPSST concurrent report is submitted from the MRP/MPS responsibility; users do not call it directly. Because the search term p_high_cat relates to a category range parameter, note that the category-selection formulas (C_CAT_SETFORMULA, C_CATEGORY_FROMFORMULA, C_CATEGORY_WHEREFORMULA) construct the lexical SQL that enforces low/high category ranges supplied on the report parameter form. The package is not referenced by any other package, so customization should be performed through a copy or by regenerating via the XML Publisher migration utility rather than editing the shipped body.