Results for “check_admin_access”
32 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.AMS_ACCESS_PVT_W_NEW package is a private PL/SQL API belonging to the Oracle Marketing (AMS) module of Oracle E-Business Suite. Its name indicates that it serves as a generated or wrapper-level private interface for managing "Access" records, which in the AMS schema govern entitlement and permission constructs used by marketing campaigns, lists, and related objects. The package exposes a set of business logic entry points that create, modify, and validate access definitions while enforcing the standard EBS API conventions for message handling, validation levels, and transactional control.
The _W_NEW suffix reflects an internal naming pattern used by EBS tooling (such as the Forms-based business object to API generator) to distinguish a particular generation or wrapper variant of the underlying private package. The presence of p_api_version, p_init_msg_list, p_commit, and the x_return_status, x_msg_count, and x_msg_data out parameters confirms conformance to the Oracle Application Object Library (AOL) API standard.
Key Procedures and Functions
The documented metadata lists eight procedures or functions. The principal public-facing operations are:
- CREATE_ACCESS — Creates a new Access record. Accepts the standard AOL API control parameters plus a wide set of positional attributes (
p7_a0throughp7_a16) that map to the target table columns, and returns the newly generated identifier viax_access_id. - UPDATE_ACCESS — Modifies an existing Access record, accepting the same control parameters and positional attributes used by the create operation, but without returning a new identifier.
- VALIDATE_ACCESS — Performs validation of a proposed or existing Access record without committing changes. Uses a
p6_a0throughp6_a16positional attribute set and reports outcomes through the standard message parameters. - CHECK_ACCESS_ITEMS — Inspects the attribute values supplied on an Access record to confirm that required items are present and consistent before further processing proceeds.
- CHECK_ACCESS_RECORD — Verifies the existence and integrity of an Access record as a whole, typically used before an update or delete.
- INIT_ACCESS_REC — Initializes the in-memory Access record structure, ensuring default values are set before population begins.
- COMPLETE_ACCESS_REC — Finalizes the record structure after attributes have been populated, prior to persistence.
- CHECK_ADMIN_ACCESS — Evaluates administrative access permissions, likely gating whether the calling session is permitted to perform the requested operation.
Tables Accessed
The ETRM metadata excerpt does not enumerate specific tables accessed via APPS synonyms. Based on the procedure semantics, the package reads from and writes to the AMS Access base table (historically AMS_ACCESS in the AMS schema) and its associated attribute or translation tables. Supporting lookups involving administrative permissions are performed by CHECK_ADMIN_ACCESS. Because the object is a private (_PVT_) package, direct table access is confined to the owning schema and exposed to callers only through these procedures.
Usage Notes
As a private package, AMS_ACCESS_PVT_W_NEW is not intended for direct invocation by customer code. It is normally called by the public AMS Access API, by generated Forms logic, or by concurrent programs and other AMS packages that require Access record maintenance. The ETRM metadata notes that it is referenced by zero other packages in the documented scope, indicating that it sits at the leaf of the current call hierarchy.
When invoked, callers must supply a valid p_api_version, control initialization with p_init_msg_list, and manage transaction boundaries through p_commit. Oracle EBS 12.1.1 and 12.2.2 maintain this package under the APPS schema with the same behavioral contract; no online patching considerations alter its callable interface, though standard ADOP file system differences apply to its deployment location.
-
PACKAGE: APPS.ARI_UTILITIES 12.1.1
-
PACKAGE: APPS.ARI_UTILITIES 12.2.2
-
PACKAGE: APPS.AMS_ACCESS_PVT 12.1.1
-
PACKAGE: APPS.AMS_ACCESS_PVT 12.2.2
-
PACKAGE: APPS.ARI_UTILITIES 12.1.1
-
PACKAGE: APPS.ARI_UTILITIES 12.2.2