Search Results p_sort_order

Overview

The APPS.IBC_COMPOUND_RELATIONS_PKG package body is the table handler for the IBC_COMPOUND_RELATIONS table, which stores compound relationship definitions used by Oracle iSupport and related interaction-center self-service modules. A compound relation associates a content item with an attribute type and content type, and records the related sub-item version and a display sort order. The package encapsulates the standard Oracle E-Business Suite table-handler idiom: primary-key generation, concurrency locking, DML maintenance, and seed-data loading for multi-language localization. The documented version header (120.1, dated 2005-07-29) shows the object originated in 2002 for the 11i codebase and was subsequently adjusted for Release 12 localization standards under bug 4411674, making it applicable to both 12.1.1 and 12.2.2 environments. The package's modification history also records adoption of the FND_API.G_MISS_XXX missing-value convention and the later addition of the p_subitem_version_id parameter across its APIs.

Key Procedures and Functions

• INSERT_ROW — Creates a new row in IBC_COMPOUND_RELATIONS. It accepts the compound relation identifier as an IN OUT parameter and, when that value is NULL or FND_API.G_MISS_NUM, derives a new key from the sequence IBC_COMPOUND_RELATIONS_S1. It returns the generated ROWID to the caller. Notably, this procedure accepts the p_sort_order parameter, which populates the SORT_ORDER column that governs the ordering in which related content items are presented to end users.
• LOCK_ROW — Obtains a row-level lock for the specified compound relation so that concurrent updates do not overwrite one another.
• UPDATE_ROW — Applies modifications to an existing compound relation record, including changes to the sort order and sub-item version.
• DELETE_ROW — Removes a referenced compound relation record from the table.
• LOAD_ROW — Loads a single row from an external or seed source, honoring the FND_API.G_MISS_XXX conventions for each attribute.
• LOAD_SEED_ROW — Introduced for R12 localization; loads seed data translated for a target language so that compound relation definitions remain consistent across installed languages.

Tables Accessed

The package operates against the IBC_COMPOUND_RELATIONS table through an APPS synonym, inserting, updating, locking, and deleting rows that define content-to-sub-item associations. It reads the sequence IBC_COMPOUND_RELATIONS_S1 to generate primary keys when the caller does not supply one. DUAL is referenced solely to support sequence retrieval within the PL/SQL cursor that supplies the surrogate key.

Usage Notes

This package is a server-side API and is not intended for direct user invocation. It is typically called by the Oracle iSupport Setup and Administration user interfaces, concurrent programs that load or migrate compound relation seed data, and custom extensions that need to maintain compound relations programmatically. Because the sort order parameter (p_sort_order) directly controls end-user display sequencing, callers should supply a deterministic value, and developers searching for "p_sort_order" should recognize that the INSERT_ROW and UPDATE_ROW routines are the supported entry points. Only one other package in the ETRM repository references this package, indicating a narrowly scoped dependency chain.