Search Results rlm_schedule_lines_s

Overview

APPS.RLM_AD_SV is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It forms part of the Oracle Advanced Pricing / order management family of "RLM" server-side packages, which are used for schedule line and scheduling interface processing. Specifically, RLM_AD_SV supplies validation and helper logic over scheduling data, manipulating schedule headers and lines as well as the interface (staging) tables that feed them. The package's status is VALID, and it is documented in the ETRM (E-Business Suite Technical Reference Manual) with an API classification of OTHER, indicating internal utility rather than a formally published open interface.

The object name suffix "_SV" and its tight coupling with RLM_CORE_SV and RLM_MESSAGE_SV demonstrate that it operates as a subordinate server-side unit: RLM_CORE_SV provides core scheduling services, while RLM_MESSAGE_SV delivers message/error handling. RLM_AD_SV is not referenced by any other database object; it is invoked directly by application code or concurrent processing rather than from other packages. This confirms its role as a top-level internal utility in the schedule line lifecycle.

Key Procedures and Functions

The packaged interface documents three procedures or functions, identified as NAME (the metadata does not enumerate each argument list or full signature). The individual routines are understood to perform the following functions:

• NAME — The primary documented routine, executed against schedule line and interface data to validate and apply a record's contents before persistence. It relies on FND_GLOBAL and FND_PROFILE to resolve session and profile-option context (for example, the current user and operating unit).
• NAME — The second routine handles message generation and error reporting by delegating to RLM_MESSAGE_SV, allowing validation failures and warnings to be surfaced through the standard ETRM message framework.
• NAME — The third routine supports core scheduling operations by calling RLM_CORE_SV, applying the business rules that govern schedule headers and lines before insertion or update.

Because the ETRM metadata is limited to routine names, parameters and exact behavior are not documented here and should not be assumed. All three routines share the package-level dependency footprint described below.

Tables Accessed

The package reads and writes through APPS synonyms for the following objects:

• RLM_SCHEDULE_HEADERS_ALL and RLM_SCHEDULE_HEADERS_S — the schedule header base table and its sequence/identifier helper, used to establish the scheduling header context.
• RLM_SCHEDULE_LINES_ALL, RLM_SCHEDULE_LINES, and RLM_SCHEDULE_LINES_S — the schedule line entities central to this package, including the base table, view/interface variant, and sequence source used to generate line identifiers.
• RLM_INTERFACE_HEADERS_ALL, RLM_INTERFACE_LINES_ALL, and RLM_INTERFACE_LINES — the interface/staging tables that hold inbound schedule data prior to validation and downstream processing.
• DUAL — used for scalar expression evaluation, a common PL/SQL pattern.

These tables indicate the package straddles both the live schedule structures and their associated interface staging structures, validating and moving interface content into the schedule tables.

Usage Notes

RLM_AD_SV is invoked indirectly by EBS scheduling functionality rather than through a documented concurrent program or form. Its callers rely on the packaged validation and messaging routines during schedule line processing and interface loading. Typical entry points include order scheduling flows, Advanced Pricing schedule maintenance, and any custom PL/SQL that stages records in the RLM interface tables. Because it depends on FND_GLOBAL and FND_PROFILE, the package must run within a properly initialized EBS session, and because it emits messages via RLM_MESSAGE_SV, errors are reported through the standard message dictionary. Customizations should reference the package through its APPS synonym and observe the sequence generators (RLM_SCHEDULE_HEADERS_S, RLM_SCHEDULE_LINES_S) when inserting new schedule records.