Search Results rlm_replace_sv




Overview
Explore in AI Chat

Overview

RLM_REPLACE_SV is a server-side PL/SQL package in the Oracle E-Business Suite Release Management (RLM) module. Its documented purpose is to contain all server-side code for the DSP (Demand Scheduling/Planning) sweeper program. Specifically, it implements the logic that compares replacement schedule lines submitted through the RLM interface tables and determines whether the incoming schedule records qualify for sweeper processing. The package header carries the identifier RLMDPSWS.pls, version 120.1, and is owned by the APPS schema, with an API classification of OTHER, indicating it is an internal supporting package rather than a public, supported open interface API.

The name RLM_REPLACE_SV reflects its focus on replacement schedules: incoming customer demand that replaces or supersedes existing scheduled lines. The sweeper program evaluates these replacement requests to identify dropped items and to decide whether a warning should be raised to the user. The package also defines a global PL/SQL collection used to retain ship-from, ship-to, and customer item context from previously eligible replacement schedule lines so that current lines can be compared against them.

Key Procedures and Functions

The ETRM metadata documents five procedures/functions in this package. Two are visible in the source excerpt:

  • CompareReplaceSched — The documented top-level procedure for the sweeper program. It accepts a schedule record from the RLM interface headers structure, a warning-dropped-items indicator, and returns a status flag. It orchestrates the comparison of the current replacement schedule against previously retained schedule lines and determines the outcome of sweeper processing.
  • IsWarningNeeded — A documented function that returns FALSE when the current schedule does not meet the criteria for running the sweeper program. It acts as a gate or eligibility check before the heavier comparison logic is executed, using the same interface header record and warning indicator as inputs.

The remaining three documented units are named in the metadata but not detailed in the excerpt. Consistent with the package's stated purpose, they support the sweeper program's comparison and warning-generation workflow. No parameter lists beyond those shown are documented, so they are not reproduced here.

The package also declares global debug constants (C_SDEBUG, C_DEBUG, C_TDEBUG) mapped to the RLM core debug levels, and a PL/SQL record type list_rec_type — the object the user searched for. list_rec_type captures ship_from_org_id, ship_to_address_id, customer_item_id, and order_number for eligible replacement schedule lines, and is used as the row type of the associative array list_tbl, indexed by BINARY_INTEGER, held in the global g_list_tbl.

Tables Accessed

The package references the following tables through APPS synonyms:

Usage Notes

RLM_REPLACE_SV is an internal package, not a public API, and is not intended for direct invocation by customers or third-party integrations. It is normally called by the DSP sweeper concurrent program or by RLM forms logic that submits replacement schedule processing. It is referenced by two other packages within the RLM module. Because the package relies on global state (g_list_tbl) and on interface header records, callers should execute it within the standard concurrent request or form session context where those tables are populated. Any customization should avoid redefining list_rec_type or the debug constants, since dependent RLM packages may rely on the published declarations.