Search Results cf_intransit_calc_basisformula
Overview
The APPS.RLM_RLMDMCOM_XMLP_PKG package is a PL/SQL package that belongs to the Oracle E-Business Suite Release Management (RLM) product family. Its naming conventions—specifically the _XMLP_PKG suffix—identify it as the generated PL/SQL package that underpins an Oracle XML Publisher (BI Publisher) concurrent program report. In the RLM context, this report is associated with demand management and commitment reporting (the "DMCOM" fragment suggests a Demand Management/Commitment report).
The package serves as the server-side data model for the corresponding XML Publisher report template, providing the PL/SQL functions that populate report parameters, perform report-level initialization and cleanup, and drive the conditional formatting and value-derivation logic that the layout template references. It is owned by the APPS schema and is documented as VALID in the ETRM metadata for both 12.1.1 and 12.2.2.
Key Procedures and Functions
The package exposes 24 documented procedures and functions:
- BEFOREREPORT — the standard XML Publisher before-report trigger, executed to set up session context and any package-level state before the report query runs.
- AFTERREPORT — the corresponding after-report trigger, used for cleanup or final calculations once the report data set has been produced.
- CF_*FORMULA functions — a set of "column formula" functions returning derived values for report columns: CF_SHIP_FROM_ORG_IDFORMULA, CF_SHIP_TOFORMULA, CF_PRE_HORIZON_DISP_CODEFORMUL, CF_INTRANSIT_CALC_BASISFORMULA, CF_MATCH_SEQFORMULA, CF_ORDERNUMFORMULA, CF_CUSTOMER_NUMBER_MEANFORMULA, CF_FROZEN_FLAGFORMULA, CF_TIME_UOM_CODEFORMULA, and CF_EXCLUDE_NONWORKDAYSFORMULA.
- IS_SEQUENCED / IS_NON_SEQUENCED — predicate functions that determine sequencing behavior for the scheduling logic.
- CP_* procedures — a set of "concurrent program" or column-population helper procedures: CP_SEQ_MATCH_LABEL_P, CP_SEQ_COLUMN_P, CP_P_SCHEDULE_TYPE_P, CP_P_SHIP_TO_P, CP_P_SEQ_MATCH_LABEL_P, and CP_P_DEMAND_TYPE_P. These populate and format parameter-driven values used by the layout.
No parameter lists are documented; purposes are inferred from naming and RLM report conventions.
Tables Accessed
The package references the following tables through APPS synonyms:
- OE_ORDER_HEADERS — source of order header data for the report's order-level attributes.
- HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_PARTIES — the Trading Community Architecture (TCA) tables used to resolve customer number, ship-to address, and party name details.
- RLM_SCHEDULE_HEADERS_ALL — the RLM schedule header table, providing schedule and sequencing information central to the report.
Usage Notes
This package is invoked exclusively as the data model of its associated Oracle XML Publisher concurrent program; it is not intended for direct ad-hoc invocation. It is registered in the concurrent program definitions, and its IS_SEQUENCED / IS_NON_SEQUENCED predicates conditionally control which report logic paths execute.
Because the RLM_RLMDMCOM_XMLP_PKG is referenced by zero other packages, it functions as a terminal, self-contained report package. Customizations should avoid modifying the generated package directly; instead, extend behavior via report template modifications or the supported RLM extension points, since the package body may be regenerated on patch application.