Search Results igc_cc_access_s

Overview

IGC_CC_ACCESS_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the IGC product family, which supports the Contracts Core (formerly Contracts Commitment) functionality used within Oracle Enterprise Asset Management and related contract administration flows. The package provides the programmatic interface for managing access-level records associated with contracts and contract groups. Its API classification is listed as OTHER, indicating it is an internal utility package rather than a formally published public API, though it remains callable from other PL/SQL units and from forms-based transactions.

The package encapsulates the standard insert, update, delete, and locking behavior for the IGC_CC_ACCESS entity, together with validation logic for uniqueness and access-level retrieval. By centralizing these operations, the package helps ensure that contract access control records are created and maintained consistently, regardless of whether the request originates from a form, a concurrent program, or custom extension code.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within this package body. Their purposes are as follows:

• INSERT_ROW — Creates a new access record for a contract or contract group, assigning the initial access level and related attributes.
• UPDATE_ROW — Modifies an existing access record, allowing changes to access level or associated group/user assignments.
• LOCK_ROW — Acquires a row-level lock on an access record to prevent concurrent modification during a transaction.
• DELETE_ROW — Removes an access record, typically invoked when a contract-group association or access grant is revoked.
• CHECK_UNIQUE — Validates that the combination of contract, group, and user identifiers does not already exist, enforcing the uniqueness rule for access assignments.
• GET_ACCESS_LEVEL — Retrieves the access level for a given contract or group, supporting authorization decisions elsewhere in the application.

Tables Accessed

The package reads and writes three tables through APPS synonyms:

• IGC_CC_ACCESS — The primary entity table storing access records, holding the access level and the relationships between contracts, groups, and users. INSERT_ROW, UPDATE_ROW, DELETE_ROW, and GET_ACCESS_LEVEL all operate against this table.
• IGC_CC_ACCESS_S — The sequence used to generate primary key values for new rows inserted into IGC_CC_ACCESS.
• IGC_CC_GROUP_USERS — Stores the association between groups and users, referenced during uniqueness checking and access-level resolution to confirm that a user belongs to the relevant group.

Usage Notes

As an internal package, IGC_CC_ACCESS_PKG is typically invoked indirectly. Oracle Forms built on the IGC_CC_ACCESS base table call these procedures to perform transactional inserts, updates, and deletes, including the conditional LOCK_ROW call issued when a record is modified. The ETRM dependency data confirms the package is referenced by three other database objects, indicating it is reused by higher-level contract or access-management packages rather than called directly by end users.

The package depends on standard EBS infrastructure: FND_API, FND_MESSAGE, FND_MSG_PUB, and APP_EXCEPTION, which it uses for error handling and message retrieval. Custom code that needs to maintain contract access records should invoke these procedures rather than issuing direct DML, so that locking, uniqueness validation, and exception handling remain consistent. The package body is valid and does not reference any object outside the registered dependency list, which limits the risk of compilation issues following upgrades or patches.