Search Results add_owner_privilege

Overview

AMW_LOAD_AP_DATA is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM catalog as an "OTHER" API. Its name associates it with the Audit Management Workbench (AMW) module, and specifically with the loading of audit procedure data from the AP interface tables. The package source header carries the revision marker $Header: amwaplds.pls 120.0 2005/05/31, indicating it was authored and last revised in 2005 and shipped unchanged through the 12.1.1 and 12.2.2 releases. The body declares AUTHID CURRENT_USER, so all unqualified object references execute with the privileges of the invoking user rather than the package owner, a common pattern for shared APPS-layer utilities.

Functionally, the package performs three related duties in the audit data load cycle: it generates audit procedure records from staged interface rows, it marks interface rows with validation or load errors, and it manages the function-level security privileges that govern who may execute and access the generated audit procedures. The embedded comments dated 03.01.2005 credit developer "npanandi" and explicitly state that the owner privilege routine was added "for data security" and that the check routine validates access to an audit procedure.

Key Procedures and Functions

• CREATE_AUDIT_PROCEDURES — the primary load routine. It accepts an error buffer, a return code, a batch identifier, and a user identifier, and is responsible for transforming staged interface data into audit procedure definitions.
• UPDATE_INTERFACE_WITH_ERROR — a diagnostic routine that writes an error message back to a specific interface row, identified by table name and interface ID, so that failed records remain visible for correction and reprocessing.
• ADD_OWNER_PRIVILEGE — grants an owner-level function privilege on an audit procedure object to a grantee, supporting instance-set and indexed instance value parameters for row-level data security plus user, start-date, and end-date parameters. This is the routine associated with the search term "add_owner_privilege".
• CHECK_FUNCTION — a validation function that tests whether a user holds the required access privilege for a named function against a specific audit procedure instance, returning a VARCHAR2 result.

Tables Accessed

The ETRM metadata documents references to AMW_AP_INTERFACE, AMW_AUDIT_PROCEDURES_B, AMW_AUDIT_PROCEDURES_TL, FND_COMPILED_MENU_FUNCTIONS, FND_FORM_FUNCTIONS, FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, and FND_USER, all through APPS synonyms. AMW_AP_INTERFACE is the staging table read during the load and updated by UPDATE_INTERFACE_WITH_ERROR. AMW_AUDIT_PROCEDURES_B and its translation table AMW_AUDIT_PROCEDURES_TL hold the resulting audit procedure definitions. The remaining FND tables supply the security model: FND_FORM_FUNCTIONS and FND_COMPILED_MENU_FUNCTIONS define the function under which the audit procedure is registered, while FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, and FND_USER resolve which responsibilities and users are entitled to that function.

Usage Notes

The package is invoked indirectly, typically from concurrent programs or form logic that drives the audit procedure load rather than from an end-user screen. Custom code should call CREATE_AUDIT_PROCEDURES with a valid batch identifier and capture the ERRBUF and RETCODE out parameters to detect failures. Grant and access checks should route through ADD_OWNER_PRIVILEGE and CHECK_FUNCTION respectively so that AMW data security remains consistent with the standard FND function model. Because the interface header is dated 2005 and shows no later revision, the behavior is identical in 12.1.1 and 12.2.2, and no other packages are documented as referencing it.