Search Results get_access_level

Overview

IGC_CC_ACCESS_PKG is a PL/SQL package owned by the APPS schema that forms part of the Oracle E-Business Suite contracts core (IGC) module infrastructure. It is delivered with a valid status in both Oracle EBS 12.1.1 and 12.2.2 and is classified under the generic API category (OTHER) rather than as a formal public interface. The package encapsulates the data access and validation logic governing access-level definitions within the contracts core schema, providing a controlled layer between the base tables that store access records and the higher-level packages, views, and forms that consume them.

Functionally, the package supports the maintenance of access control records — the rows that determine which users or groups may view or manipulate contract-related data. It follows the standard EBS table-handler pattern, centralizing insert, update, delete, and locking behavior so that concurrent modifications and uniqueness requirements are enforced consistently across all callers.

Key Procedures and Functions

The ETRM documentation records six documented program units within IGC_CC_ACCESS_PKG:

• INSERT_ROW — Creates a new access record, applying the package's defaulting and validation rules before persisting the row.
• UPDATE_ROW — Modifies an existing access record, typically after the row has been locked.
• LOCK_ROW — Acquires a row-level lock to serialize concurrent maintenance of a specific access record, preventing lost updates.
• DELETE_ROW — Removes an access record from the underlying tables.
• CHECK_UNIQUE — Validates that a proposed access definition does not duplicate an existing one, supporting the uniqueness constraints enforced by the package.
• GET_ACCESS_LEVEL — A query function that retrieves the access level associated with a given access definition, used by callers that need to evaluate a user's or group's privileges.

Parameter lists are not enumerated in the available metadata; callers should inspect the package specification in the database for exact signatures.

Tables Accessed

The package operates on three tables, referenced through APPS synonyms:

• IGC_CC_ACCESS — The primary table holding access-level definitions maintained through INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
• IGC_CC_ACCESS_S — The corresponding sequence or secondary table used to generate and store the unique identifiers for access records.
• IGC_CC_GROUP_USERS — The group-to-user mapping table consulted when resolving which users inherit an access level, particularly in support of GET_ACCESS_LEVEL and CHECK_UNIQUE.

Usage Notes

IGC_CC_ACCESS_PKG is referenced by at least three other packages, including IGC_CC_COMMON_UTILS_PVT and IGC_CC_COPY_PKG, as well as by the IGC_CC_HEADERS_V view. It therefore functions as a shared internal service rather than an end-user entry point. The package itself depends on FND_API and the SYS STANDARD package, consistent with standard EBS PL/SQL conventions.

In practice, the package is invoked indirectly from contracts core forms and concurrent programs that maintain access definitions, and from custom code that must create, lock, copy, or query access records without bypassing validation. Because it is not classified as a public API, extensions and integrations should favor the supported contracts APIs and treat IGC_CC_ACCESS_PKG as an internal implementation detail that may change between releases.