Search Results rlm_ad_sv




Overview
Explore in AI Chat

Overview

RLM_AD_SV is a server-side PL/SQL package in the Oracle EBS Applications (APPS) schema that encapsulates the archival logic for the Oracle Release Management (RLM) demand and scheduling entities. Declared with AUTHID CURRENT_USER, the package executes under the privileges of the invoking session rather than the defining schema, which is consistent with its role as a shared server-side utility invoked from multiple EBS entry points. The package header carries the source revision identifier RLMDPARS.pls 115.6, dated 2002/12/23, and was originally authored by user ANVERMA, with design references pointing to the specification document rlmdlar.rtf.

The business purpose of RLM_AD_SV is to move requisition and schedule data from the RLM interface staging area into the permanent RLM schedule tables. This archival step is a prerequisite for downstream order scheduling, demand visibility, and supplier collaboration flows within Release Management. The package exposes a narrow, purpose-built API surface consisting of three documented program units, all classified as OTHER in the ETRM registry for release 12.2.2.

Key Procedures and Functions

  • Archive_Demand — The top-level entry point for the archival operation. It orchestrates the archiving of demand by delegating to the header and line archival routines, effectively archiving the full schedule structure (headers and lines) associated with an interface header. It returns a BOOLEAN status.
  • Archive_Headers — Archives the header information of the schedule and, as part of that processing, writes back the newly generated schedule identifier into the RLM interface headers record. It returns a BOOLEAN status and surfaces the generated schedule identifier to the caller.
  • Archive_Lines — Archives the schedule line detail corresponding to the archived header. This routine completes the header-to-line archival chain initiated by Archive_Demand.

All three program units are documented solely by name in the ETRM registry; parameter signatures should be confirmed against the installed package specification in the target environment.

Tables Accessed

The package operates across two logical table families, resolved through APPS synonyms:

The read/write pattern is transactional: interface rows are read, mapped to schedule entities, and persisted to the schedule tables, with the interface header updated to reflect the resulting schedule.

Usage Notes

RLM_AD_SV is referenced by one other documented package within the RLM module, indicating it is called programmatically rather than directly by end users. In practice it is invoked from concurrent programs, internal RLM processing logic, or custom extensions that need to promote interface-staged demand into RLM schedule tables. The BOOLEAN return values make it unsuitable for direct SQL invocation but appropriate for PL/SQL callers and concurrent program wrappers. The package is present in both 12.1.1 and 12.2.2; behavior is consistent across releases.