Search Results c_planned_org_codeformula

Overview

MRP_MRPRPPIT_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the XML Publisher (BI Publisher) report "MRPRPPIT" — the Planned Item / Inventory Turns report used in the Oracle Advanced Planning and MRP product family. In the EBS 12.1.1 and 12.2.2 releases, XML Publisher conversion replaced the earlier Oracle Reports RDF architecture, and each converted report receives a generated PL/SQL package (the _XMLP_PKG suffix) that holds the report's global parameters, formula columns, and before/after report triggers. This package, defined with AUTHID CURRENT_USER as declared in the header source file MRPRPPITS.pls, therefore acts as the server-side container for the report logic and its supporting data-manipulation routines.

Key Procedures and Functions

The package exposes eight documented program units. The formula functions are invoked by the XML Publisher engine to derive runtime values for the report layout. C_PLANNED_ORG_CODEFORMULA resolves the planned organization code from a numeric organization identifier and serves as the lookup the user searched for; C_COST_TYPEFORMULA returns the cost type display value; and C_P_MULTI_ORGFORMULA resolves the multi-organization flag used to drive report formatting. C_BEGIN_INV_D2FORMULA formats the beginning inventory D2 column value. BEFOREREPORT initializes global parameters, including the concurrent request ID and organization context, prior to execution, while AFTERREPORT performs post-processing and cleanup. The two procedural workhorses are MRP_WEEKS_MONTHS, which computes the week and period buckets (related to the P_WEEKS, P_PERIODS, P_PERIODS_ACTUAL, and P_START_DATE globals), and MRP_CALCULATE_INVENTORY_TURNS, which computes the inventory-turn metrics for the specified organization, query, designators, and cost type. These procedures are declared with argument lists internal to the package; they are not public APIs.

Tables Accessed

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

• CST_COST_TYPES — supplies cost type definitions used by C_COST_TYPEFORMULA and MRP_CALCULATE_INVENTORY_TURNS.
• MRP_FORM_QUERY_S — stores the query identifier and parameter sets created by the report, keyed by the P_QUERY_ID global.
• MRP_PLANS — provides the plan and organization context, including planned organization codes.
• MTL_PARAMETERS — supplies organization code and inventory organization attributes.
• DUAL — used for single-row formula evaluations and date or numeric derivation.

Usage Notes

This package is generated and maintained by Oracle and is not part of the public EBS API surface. It is invoked indirectly when a user runs the MRPRPPIT report from the MRP responsibility or as a concurrent program; XML Publisher calls BEFOREREPORT, then the formula functions on each row and column, then AFTERREPORT. The MRP_WEEKS_MONTHS and MRP_CALCULATE_INVENTORY_TURNS procedures also store intermediate results in MRP_FORM_QUERY_S, which other reporting logic can read. Because the package uses AUTHID CURRENT_USER and references APPS synonyms, customizations should never modify it directly; instead, apply corrections via the supported XML Publisher template mechanism. In 12.2.2 the same package exists unchanged, and version history in the header (MRPRPPITS.pls 120.2, 2007) confirms stability across the 12.x line. ETRM records zero other packages referencing this object, confirming its status as a leaf report-support package rather than a shared API.