Search Results p_process_date_from

Overview

The APPS.RLM_COMP_SCH_TO_DEMAND_SV package is a server-side PL/SQL component within the Oracle E-Business Suite Release Management (RLM) module. Its name denotes its primary purpose: comparing or compiling schedule data to demand. In the context of Oracle EBS 12.1.1 and 12.2.2, this package supports the order-to-shipment lifecycle by correlating customer scheduling agreements, shipment schedules, and demand records. It is classified under the APPS schema as a VALID database object and is listed with an API classification of OTHER, indicating it is an internal processing unit rather than a formally published public API. It bridges the gap between high-level schedule headers and lines and the granular demand records that must be matched, sequenced, and converted into actionable shipping or delivery instructions. The package therefore plays a supporting role in orchestration for RLM schedule-to-demand processing flows, particularly those driven by concurrent programs and the RLM XML Publisher reporting layer.

Key Procedures and Functions

The documented metadata identifies three procedures or functions by name within the package interface. Because the parameter lists are not exposed in the available metadata, parameter signatures are intentionally omitted here. The documented entry points relate to the package's core role of transforming schedule data into demand records and coordinating temporary matching structures. Their purpose centers on preparing and reconciling the temporary match tables (RLM_MATCH_SETUP_TEMP, RLM_SEQ_MATCH_TEMP, and RLM_COMP_SCHED_TO_DEMAND_TEMP) prior to final persistence into schedule and demand tables. No parameter-level detail is documented, so consumers should not assume specific signatures; only the functional intent of comparison, sequencing, and demand generation can be inferred reliably.

Tables Accessed

The package references a defined set of APPS synonyms. Customer and party master data are read from HZ_CUST_ACCOUNTS and HZ_PARTIES, supplying account-level and party-level identity required to attribute demand to the correct customer. Item master information is drawn from MTL_SYSTEM_ITEMS_B and MTL_CUSTOMER_ITEMS, linking internal inventory items to customer item numbers. Schedule definitions reside in RLM_SCHEDULE_HEADERS and RLM_SCHEDULE_LINES_ALL, which provide the authoritative schedule records being compared against demand. Working data is staged in RLM_COMP_SCHED_TO_DEMAND_TEMP, RLM_MATCH_SETUP_TEMP, and RLM_SEQ_MATCH_TEMP. Delivery classification is resolved via RLM_SHIP_DELIVERY_CODES. Utility objects DUAL and the PL/SQL table type PLITBLM support singleton queries and in-memory collections respectively.

Usage Notes

This package is invoked as internal processing logic rather than through a direct user-facing form. Its documented referencer RLM_RLMDMCOM_XMLP_PKG indicates it is called from the RLM XML Publisher concurrent program layer, and the package references itself, confirming recursive or modular internal usage. Typical invocation occurs during schedule-to-demand comparison or compilation runs launched as concurrent programs from the RLM responsibility. Custom extensions should avoid direct calls unless the caller fully understands the temporary table lifecycle, since the package depends on staging tables that are populated and consumed within a single processing window. Because only three procedures are documented and parameter lists are unavailable, integrators should treat the package as a black-box dependency of the XML Publisher program rather than a supported public API.