Search Results rlm_cust_item_terms




Overview
Explore in AI Chat

Overview

RLM_SETUP_TERMS_SV is a server-side PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its classification within the ETRM repository is "OTHER," indicating it is an internal supporting package rather than a published public API. The "SV" suffix follows the Oracle Applications naming convention for server-side validation and setup logic. In Oracle EBS 12.1.1 and 12.2.2, this package belongs to the transportation and trade management domain associated with Oracle Transportation Management/Global Trade Management integration and the Release Management (RLM) module. Specifically, it is responsible for resolving and validating customer-level setup terms—item terms and ship-to terms—used in the execution of release management and trade compliance transactions. The package is currently VALID in both releases and depends on core RLM packages, including RLM_CORE_SV, RLM_DP_SV, RLM_MESSAGE_SV, and RLM_TPA_SV, none of which it modifies. It is not referenced by any other database object, which confirms its role as a terminal, internally invoked component within the RLM package stack.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within this package. The documented object list exposes a single named identifier ("NAME"), reflecting the repository's limited disclosure of signature-level detail. The remaining procedures are not individually enumerated in the available metadata excerpt. The package's evident functional intent is the retrieval, validation, and persistence of customer setup terms, coordinated through the message-handling services of RLM_MESSAGE_SV and the parameter-access services of RLM_CORE_SV. Because the full parameter lists are not documented, no argument signatures are asserted here; consumers should inspect the package specification for exact callable interfaces before invoking any procedure directly.

Tables Accessed

  • RLM_CUST_ITEM_TERMS — stores customer-level term attributes applied at the item detail level; read and written as part of term setup maintenance.
  • RLM_CUST_SHIPTO_TERMS — stores customer ship-to level terms; read and written for ship-to-specific configuration.
  • ECE_TP_GROUP — trading partner group definition used to resolve the partner hierarchy associated with the customer.
  • ECE_TP_HEADERS — trading partner header records providing partner identity and context for term resolution.
  • HZ_CUST_ACCOUNTS — the TCA customer account registry, used to validate the account referenced in setup terms.
  • HZ_CUST_ACCT_SITES — TCA customer account sites, used to validate ship-to addresses tied to ship-to terms.

Usage Notes

This package is invoked indirectly. It is referenced by nine other APPS packages and is not exposed to any database object outside that dependency set, so it is not intended for direct custom-code invocation. Typical invocation occurs through RLM setup and release management flows, including OTM/GTM-related forms and concurrent programs that create or maintain customer item and ship-to terms. It also depends on FND_PROFILE for site and user-level profile option lookups, and on the STANDARD SYS package for standard PL/SQL runtime services. Customizations should extend or replace behavior via the documented public RLM APIs rather than by modifying this package body, since it is a validated, Oracle-supplied object whose internal calls are chained to RLM_CORE_SV, RLM_DP_SV, RLM_MESSAGE_SV, and RLM_TPA_SV.