Search Results ams_act_access_s

Overview

APPS.AMS_ACCESS_PVT is a private (PVT) PL/SQL package body within the Oracle E-Business Suite Advanced Marketing (AMS) module. Its principal business function is to govern access control and security over marketing entities — campaigns, events, offers, deliverables, and funds — by evaluating a user's relationship to the owning resource group or owner. The package enforces record-level privilege rules such as view, update, and administrative access, and it validates whether a specific function or item should be available to the current user. It also maintains a denormalized access cache in AMS_ACT_ACCESS_DENORM, which allows the application to resolve access decisions efficiently without repeatedly traversing the underlying security tables.

Key Procedures and Functions

• CREATE_ACCESS, UPDATE_ACCESS, DELETE_ACCESS — maintain the access records that define which users or groups may act upon a marketing object.
• LOCK_ACCESS — acquires a lock on an access record to serialize concurrent modifications.
• VALIDATE_ACCESS, CHECK_ACCESS_RECORD, CHECK_ACCESS_ITEMS — validate the consistency and completeness of access definitions and referenced items.
• CHECK_VIEW_ACCESS, CHECK_UPDATE_ACCESS, CHECK_ADMIN_ACCESS — determine whether the current user holds view, update, or administrative privileges on a given object.
• CHECK_OWNER, CHECK_FUNCTION_SECURITY — verify object ownership and confirm whether the user may invoke a protected function.
• INIT_ACCESS_REC, COMPLETE_ACCESS_REC — initialize and finalize an access record during processing, consistent with the FND_API PL/SQL API pattern.
• UPDATE_OBJECT_OWNER — reassign ownership of a marketing object.
• GET_SOURCE_CODE — retrieve source-code information from the AMS_SOURCE_CODES reference table.

Tables Accessed

The package reads and writes AMS_ACT_ACCESS and its sequence AMS_ACT_ACCESS_S, and it maintains the denormalized cache in AMS_ACT_ACCESS_DENORM. Object context is drawn from AMS_CAMPAIGNS_ALL_B, AMS_EVENT_HEADERS_ALL_B, AMS_EVENT_OFFERS_ALL_B, OZF_FUNDS_ALL_B, OZF_OFFERS, AMS_DELIVERABLES_VL, and AMS_CAMPAIGN_SCHEDULES_VL. Source-code lookups reference AMS_SOURCE_CODES. Group-based access is resolved through JTF_RS_GROUPS_DENORM and JTF_RS_GROUP_MEMBERS. Utility and framework calls are made through AMS_UTILITY_PVT, AMS_ACCESS_DENORM_PVT, FND_API, FND_FUNCTION, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, and JTF_PLSQL_API; DUAL and PLITBLM (PL/SQL index-by table) are also referenced.

Usage Notes

AMS_ACCESS_PVT is a private implementation package and therefore is not intended to be called directly by external customizations; the public-facing entry points of the AMS security architecture expose the equivalent functionality. It is invoked by Oracle Marketing forms and supporting packages whenever a user views or edits a campaign, event, offer, deliverable, or fund. The package is referenced by roughly thirty other database objects, indicating its central role in the AMS security layer. The metadata records no object that depends upon AMS_ACCESS_PVT in turn, confirming its position at a leaf of the dependency hierarchy. The package was documented as VALID under EBS 12.2.2 with sixteen documented procedures and functions, and it relies exclusively on APPS synonyms and standard SYS constructs such as DUAL, STANDARD, and PLITBLM.