Search Results ad_apps_private

Overview

The SYSTEM.AD_APPS_PRIVATE package body is an internal Oracle E-Business Suite utility that supports the AD (Applications DBA) product's schema and object maintenance operations. It is owned by the SYSTEM schema rather than the APPS schema, reflecting its role as a low-level tool invoked during patching, cloning, and edition-based redefinition (EBR) activities. The package status is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments. Its principal responsibility is to generate and manage DDL against the APPS schema and its associated Oracle user, including the creation of private database objects, grants, synonyms, and editioning constructs. Although classified as an OTHER API, it is a foundational dependency for numerous higher-level AD utilities, with the metadata recording that it is referenced by thirteen other packages.

Key Procedures and Functions

The package exposes thirty-seven documented procedures and functions. While parameter lists are not published, the naming conventions indicate distinct functional groupings.

Edition management: IS_EDITION_ENABLED reports whether edition-based redefinition is active, and DO_ARRAY_ASSIGNMENT_PATCH_EDN applies array assignments within an editioning context.
DDL execution: DO_APPS_DDL, DO_APPS_ARRAY_DDL, CHECK_FOR_APPS_DDL, and DO_ARRAY_ASSIGNMENT perform and validate DDL against the APPS schema.
Object copying and comparison: COPY_VIEW, COPY_HUGE_VIEW, COPY_CODE, COMPARE_VIEW_TEXT, and COMPARE_CODE replicate and diff database objects.
Schema and security: CHECK_IF_SCHEMA_EXISTS, CREATE_GRANTS_AND_SYNONYMS, GET_APPS_SCHEMA_NAME, CREATE_SYNONYMS, COPY_ODD_SYNONYMS, CREATE_BASE_GS, CREATE_GS, CREATE_SPECIAL_VIEWS, and DROP_OBJECT manage user existence, grants, synonyms, and named views.

Tables Accessed

The package queries and maintains a broad set of data dictionary views, referenced through APPS synonyms. These include DBA_OBJECTS, DBA_DEPENDENCIES, DBA_EDITIONING_VIEWS, DBA_QUEUES, DBA_QUEUE_TABLES, DBA_SEQUENCES, DBA_SOURCE, DBA_SYNONYMS, DBA_TABLES, DBA_TAB_COLUMNS, DBA_USERS, and DBA_VIEWS. Access to these views is required for dependency analysis, object existence checks, and DDL generation. The package further relies on DBMS_AQADM, DBMS_OUTPUT, DBMS_SQL, DBMS_SYS_SQL, and STANDARD for dynamic SQL and Advanced Queuing support.

Usage Notes

AD_APPS_PRIVATE is not intended for direct invocation by end users or custom developers. It is called internally by AD patching infrastructure, AutoConfig, and cloning utilities, and by the thirteen packages that depend on it. Typical invocation occurs during patch application, schema synchronization, and EBR upgrade tasks. Developers inspecting object dependencies or diagnosing synonym and grant failures may reference it, but custom code should rely on supported AD APIs rather than calling this private package directly.

PACKAGE BODY: SYSTEM.AD_APPS_PRIVATE 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_APPS_PRIVATE, status:VALID,
PACKAGE: SYSTEM.AD_APPS_PRIVATE 12.2.2
owner:SYSTEM, object_type:PACKAGE, object_name:AD_APPS_PRIVATE, status:VALID,
PACKAGE BODY: SYSTEM.AD_APPS_PRIVATE 12.2.2
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_APPS_PRIVATE, status:VALID,
PACKAGE: SYSTEM.AD_APPS_PRIVATE 12.1.1
owner:SYSTEM, object_type:PACKAGE, object_name:AD_APPS_PRIVATE, status:VALID,
SYNONYM: PUBLIC.DBA_OBJECTS 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_OBJECTS, status:VALID,
SYNONYM: PUBLIC.DBA_OBJECTS 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_OBJECTS, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
SYNONYM: SYSTEM.FND_ORACLE_USERID 12.1.1
owner:SYSTEM, object_type:SYNONYM, object_name:FND_ORACLE_USERID, status:VALID,
SYNONYM: PUBLIC.DBA_SEQUENCES 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_SEQUENCES, status:VALID,
SYNONYM: PUBLIC.DBA_SEQUENCES 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_SEQUENCES, status:VALID,
SYNONYM: PUBLIC.DBA_DEPENDENCIES 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_DEPENDENCIES, status:VALID,
SYNONYM: PUBLIC.DBA_VIEWS 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_VIEWS, status:VALID,
SYNONYM: PUBLIC.DBA_QUEUES 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_QUEUES, status:VALID,
PACKAGE: SYSTEM.AD_MLS 12.1.1
owner:SYSTEM, object_type:PACKAGE, object_name:AD_MLS, status:VALID,
PACKAGE: SYSTEM.AD_MLS 12.2.2
owner:SYSTEM, object_type:PACKAGE, object_name:AD_MLS, status:VALID,
PACKAGE BODY: SYSTEM.AD_INST 12.2.2
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_INST, status:VALID,
SYNONYM: PUBLIC.DBA_QUEUE_TABLES 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_QUEUE_TABLES, status:VALID,
PACKAGE BODY: SYSTEM.AD_INST 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_INST, status:VALID,
PACKAGE BODY: APPS.AD_PARALLEL_UPDATES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AD_PARALLEL_UPDATES_PKG, status:VALID,
SYNONYM: PUBLIC.DBA_SOURCE 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_SOURCE, status:VALID,
SYNONYM: PUBLIC.DBA_QUEUES 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_QUEUES, status:VALID,
PACKAGE BODY: APPS.OE_INSTALL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_INSTALL, status:VALID,
SYNONYM: PUBLIC.DBA_QUEUE_TABLES 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_QUEUE_TABLES, status:VALID,
PACKAGE BODY: SYSTEM.AD_DDL 12.2.2
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_DDL, status:VALID,
PACKAGE BODY: SYSTEM.AD_PARALLEL_COMPILE_PKG 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_PARALLEL_COMPILE_PKG, status:VALID,
PACKAGE BODY: APPS.OE_INSTALL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_INSTALL, status:VALID,
PACKAGE BODY: SYSTEM.AD_MLS 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_MLS, status:VALID,
PACKAGE BODY: SYSTEM.AD_DDL 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_DDL, status:VALID,
PACKAGE BODY: SYSTEM.AD_MLS 12.2.2
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_MLS, status:VALID,
SYNONYM: PUBLIC.DBA_SYNONYMS 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_SYNONYMS, status:VALID,
SYNONYM: PUBLIC.DBA_DEPENDENCIES 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_DEPENDENCIES, status:VALID,
SYNONYM: PUBLIC.DBA_SYNONYMS 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_SYNONYMS, status:VALID,
SYNONYM: PUBLIC.DBA_VIEWS 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_VIEWS, status:VALID,
SYNONYM: PUBLIC.DBA_SOURCE 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_SOURCE, status:VALID,
PACKAGE BODY: APPS.AD_PARALLEL_UPDATES_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AD_PARALLEL_UPDATES_PKG, status:VALID,
PACKAGE BODY: SYSTEM.AD_INVOKER 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_INVOKER, status:VALID,
PACKAGE BODY: SYSTEM.AD_INVOKER 12.2.2
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_INVOKER, status:VALID,
PACKAGE BODY: SYSTEM.AD_CLONE_UTILS 12.2.2
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_CLONE_UTILS, status:VALID,
PACKAGE BODY: SYSTEM.AD_CLONE_UTILS 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_CLONE_UTILS, status:VALID,
SYNONYM: PUBLIC.DBA_EDITIONING_VIEWS 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_EDITIONING_VIEWS, status:VALID,
SYNONYM: SYSTEM.FND_ORACLE_USERID 12.2.2
owner:SYSTEM, object_type:SYNONYM, object_name:FND_ORACLE_USERID, status:VALID,
SYNONYM: PUBLIC.DBA_USERS 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBA_USERS, status:VALID,
PACKAGE BODY: APPS.HZ_COMMON_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_COMMON_PUB, status:VALID,