Search Results p_incl_cancel_lines

Overview

RLM_RLMDMSIQ_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body that supports the Report Management subsystem for Release Management (RLM). The package serves as the backend implementation for an Oracle Reports executable driven by a concurrent program, providing the data-cursor logic, formula columns, and before-report initialization needed to produce a Demand Supply Inquiry (DMSIQ) report. The naming convention (XMLP_PKG) indicates that the report is executed through the Oracle XML Publisher engine and that the package is auto-generated as a report trigger container within the APPS schema. Its primary purpose is to resolve organizational context, ship-to and ship-from trading partner attributes, customer identity, item information, and cumulative forecast scheduling data so that the runtime report layout can render meaningful values.

Key Procedures and Functions

• BEFOREREPORT — Initializes the report run. It captures the concurrent request ID via FND_GLOBAL, resolves the current operating unit using MO_GLOBAL.GET_CURRENT_ORG_ID, sets multi-org policy context when an organization ID is supplied, retrieves the operating unit name with FND_ACCESS_CONTROL_UTIL.GET_ORG_NAME, and populates cursor-derived package variables for ship-from and customer context.
• CUSTOMER_NUMBERFORMULA, CUSTOMER_NAMEFORMULA — Derive and format the customer account number and party name for display in the report.
• SHIP_FROM_CODEFORMULA, SHIP_FROM_NAMEFORMULA — Resolve the shipping organization's code and descriptive name.
• CUSTOMER_ITEM_NUMBERFORMULA, CUSTOMER_ITEM_DESCFORMULA — Return the customer-facing item number and item description.
• CONCATENATED_SEGMENTSFORMULA, DESCRIPTIONFORMULA — Expose the concatenated accounting/flexfield segments and associated description text.
• BUCKET_TYPE_CODEFORMULA, FCST_BUCKET_TYPE_CODEFORMULA — Return forecast bucket type codes used in cumulative demand grouping.
• SHIP_TO_LOCATIONFORMULA, SHIP_TO_NAMEFORMULA — Resolve the ship-to location code and ship-to party name.
• INTMED_SHIP_TO_LOCATIONFORMUL, INTMED_SHIP_TO_NAMEFORMULA — Return the intermediate (intransit) ship-to location and name, used in multi-leg shipment scenarios.
• CUM_START_DATEFORMULA, CUM_QTYFORMULA, LAST_CUM_QTY_UPDATE_DATEFORMU — Surface cumulative start date, cumulative quantity, and the last cumulative quantity update timestamp.
• CF_SCHED_TYPE, CF_SCHED_TYPE_2 — Return the forecast/schedule type used to distinguish scheduling classifications in the report output.

Tables Accessed

The package reads Oracle Trade Management and inventory tables to resolve report values. HZ_CUST_ACCOUNTS and HZ_PARTIES provide customer account and party identity. HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, and HZ_CUST_SITE_USES_ALL supply ship-to site usage and location code information, with the cursor filtering on SITE_USE_CODE = 'SHIP_TO' and STATUS = 'A'. HZ_LOCATIONS and HZ_PARTY_SITES provide address and party-site linkage. MTL_CUSTOMER_ITEMS and MTL_SYSTEM_ITEMS_KFV resolve customer item numbers and concatenated item flexfield values. ORG_ORGANIZATION_DEFINITIONS supplies the ship-from organization code, and RLM_CUST_ITEM_CUM_KEYS underpins the cumulative quantity key structure referenced by the CUM_QTY and CUM_START_DATE formulas.

Usage Notes

This package is invoked automatically when the associated concurrent program runs the RLM Demand Supply Inquiry report. It is not called directly by other packages, as indicated by a dependency count of zero. Administrators and developers inspecting the parameter p_incl_cancel_lines use this package to understand whether canceled order or schedule lines are included in the report's driving query. The BEFOREREPORT logic also confirms that the report honors multi-org security via MO_GLOBAL policy context, so callers must supply the correct operating unit parameters for accurate results. Custom code should not call the formula functions directly; instead, extend the underlying report definition if alternate presentation is required.