Search Results create_gs
Overview
SYSTEM.AD_APPS_PRIVATE is a low-level Oracle E-Business Suite infrastructure package that performs the physical and dictionary-level work required to construct and maintain the APPS schema. Its header carries the revision identifier $Header: adaprs.pls 120.0 2005/05/25 11:44:44 appldev noship $, reflecting an early AD utility lineage that has been preserved across release 12.1.1 and 12.2.2. The package is not intended for direct use by application or customer code; it is a building block consumed by the AD driver and patch-processing infrastructure. Its principal responsibilities are the creation, comparison, and repair of database objects (views, synonyms, grants, sequences, and queue objects) within the APPS schema, together with the detection of the APPS schema name and the management of editioning behaviour introduced by the AD online patching model.
The package also declares package-level types and constants used to implement special handling. A PL/SQL associative array type, TableNameType, indexes object names by binary integer, and global variables such as error_buf, is_mls, and is_mc carry state for multi-lingual and multi-currency processing. Constants including ign_select_part1, ign_select_part2, ign_select_part3, ign_schema_select_part1, ign_schema_select_part2, and ign_schema_select_part3 assemble SQL fragments that identify installation groups and product schemas from FND_PRODUCT_INSTALLATIONS and FND_ORACLE_USERID. The comments explicitly note that the last WHERE condition of the schema query is deliberately omitted and appended later.
Key Procedures and Functions
The ETRM documentation catalogues 37 procedures and functions. Representative members include:
- CREATE_GRANTS_AND_SYNONYMS — the procedure referenced in the search term; it generates the object grants and APPS synonyms required for installed products and schemas.
- IS_EDITION_ENABLED — determines whether database editioning is active, governing online-patching behaviour.
- DO_APPS_DDL, DO_APPS_ARRAY_DDL, DO_ARRAY_ASSIGNMENT, DO_ARRAY_ASSIGNMENT_PATCH_EDN — execute DDL against the APPS schema, including array-based and edition-aware assignment operations.
- CHECK_FOR_APPS_DDL, CHECK_IF_SCHEMA_EXISTS — validate the existence and readiness of the APPS schema and target schemas.
- GET_APPS_SCHEMA_NAME — returns the current APPS schema identifier.
- DROP_OBJECT — removes objects as part of rebuild or cleanup operations.
- COPY_VIEW, COPY_HUGE_VIEW, COPY_CODE, COMPARE_VIEW_TEXT, COMPARE_CODE — recreate and compare source text for views and PL/SQL code, ensuring the APPS copies match their base definitions.
- CREATE_BASE_GS, CREATE_GS, CREATE_SYNONYMS, COPY_ODD_SYNONYMS, CREATE_SPECIAL_VIEWS — construct grants and synonyms, handle exceptions, and materialise special views.
Tables Accessed
The package queries data dictionary views through APPS synonyms, including 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. These supply object inventories, dependency chains, editioning metadata, source text, and column definitions used to drive object creation and comparison. It also invokes DBMS_SQL, DBMS_OUTPUT, and DBMS_AQADM for dynamic SQL, diagnostics, and advanced queueing administration.
Usage Notes
AD_APPS_PRIVATE is invoked indirectly by AD utilities and concurrent programs that rebuild the APPS schema during patching, and is referenced by 13 other packages. The header comments indicate that its special-object tracking tables are consulted principally within CREATE_GRANTS_AND_SYNONYMS and in advrfapp.sql. Custom code should not call this package directly, because its interfaces are unsupported and version-sensitive across 12.1.1 and 12.2.2.