Search Results p_sum_date_and_bucket
Overview
APPS.RLM_RLMDMSIQ_XMLP_PKG is the PL/SQL package associated with an Oracle EBS XML Publisher (BI Publisher) concurrent program in the Order Management / Release Management (RLM) module. The suffix _XMLP_PKG indicates that the package was generated by the Oracle XML Publisher data template framework and serves as the data source wrapper for a concurrent program. Based on the naming convention and the documented parameter list, the program appears to be a "DM SIQ" (Demand Management / Shipment Information Query, or similar reporting variant) extract that reports order, shipment, item, forecast, and cumulative quantity information against customer and ship-to/ship-from organization criteria.
The package declares a set of public variables that correspond directly to the concurrent program's parameters: P_SHIP_FROM_ORG_ID, P_CUSTOMER_ID, P_SHIP_TO_ORG_ID, P_DELIVER_TO_ORG_ID, P_FROM_SHIP_DATE, P_TO_SHIP_DATE, P_CUST_OR_INV_ITEM, P_FROM_ITEM_ID, P_TO_ITEM_ID, P_FROM_ORDER, P_TO_ORDER, and several status/behavior selectors such as P_REQ_FIRM_FORECAST_BOTH, P_INCL_CANCEL_LINES, P_SHIP_UNSHIP_BOTH, P_SUM_DATE_AND_BUCKET, and P_INCL_CURR_RES_AUTHZNS. These defaults drive query construction during the BEFOREREPORT trigger, which binds the parameter values into WHERE clauses (P_WHERE_CLAUSE1, P_WHERE_CLAUSE2) before the XML data template executes.
Key Procedures and Functions
The package exposes 27 documented procedures and functions. They fall into two groups: XML Publisher "group function" formula callbacks and the report initialization routine.
- BEFOREREPORT — the standard XML Publisher before-report trigger; it initializes parameter state and prepares the WHERE clause fragments used by the report query.
- CUSTOMER_NUMBERFORMULA and CUSTOMER_NAMEFORMULA — format the customer number and customer name on the report output.
- SHIP_FROM_CODEFORMULA and SHIP_FROM_NAMEFORMULA — the ship-from code and ship-from name display formulas. The user's search term "ship_from_nameformula" corresponds directly to this documented function.
- CUSTOMER_ITEM_NUMBERFORMULA, CUSTOMER_ITEM_DESCFORMULA, CONCATENATED_SEGMENTSFORMULA, and DESCRIPTIONFORMULA — resolve the customer item number, description, and inventory item concatenated segment description for the report lines.
- SHIP_TO_LOCATIONFORMULA, SHIP_TO_NAMEFORMULA, INTMED_SHIP_TO_LOCATIONFORMUL, and INTMED_SHIP_TO_NAMEFORMULA — resolve final and intermediate ship-to location and name values.
- BUCKET_TYPE_CODEFORMULA, FCST_BUCKET_TYPE_CODEFORMULA, CF_SCHED_TYPE, and CF_SCHED_TYPE_2 — resolve the forecast bucket type code and schedule type descriptors.
- CUM_START_DATEFORMULA, CUM_QTYFORMULA, and LAST_CUM_QTY_UPDATE_DATEFORMU — format the cumulative start date, cumulative quantity, and last cumulative quantity update date for the cumulative demand reporting section.
Tables Accessed
- HZ_CUST_ACCOUNTS, HZ_PARTIES — customer account and party name/number data.
- HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTY_SITES — ship-to and deliver-to site, location, and site-use data.
- MTL_CUSTOMER_ITEMS — customer item number and description cross-reference.
- MTL_SYSTEM_ITEMS_KFV — inventory item description and concatenated segment information.
- RLM_CUST_ITEM_CUM_KEYS — cumulative demand keys that support the CUM_QTY and CUM_START_DATE columns.
Usage Notes
This package is invoked exclusively as the data source of the associated XML Publisher concurrent program. It is not a public API and is not referenced by any other package. The BEFOREREPORT routine runs when the concurrent request is submitted; the remaining formulas are evaluated by XML Publisher as it renders each report row and group. The trailing "FORMULA" naming pattern is characteristic of XML Publisher "formula columns" defined in the RTF or XSL-FO template, allowing display logic to be centralized in PL/SQL rather than embedded in the template. Because the package header was last modified with a "noship" marker, customization should be avoided; behavior should be controlled through the concurrent program parameters. The "ship_from_nameformula" lookup should be understood as the display formula for the ship-from organization name, populated from the ship-from organization identifier passed in P_SHIP_FROM_ORG_ID.