Search Results get_object_id_for_ag_type

Overview

APPS.EGO_EXT_FWK_PUB is the public API package that underpins the Oracle E-Business Suite extensibility framework, which powers attribute groups, user-defined attributes, and extensible flexfields across the product master data model. The package resides in the APPS schema and is classified as a PUB (public) API, indicating it is intended for supported invocation by forms, concurrent programs, and custom extension code. Its principal business role is to provide programmatic access to metadata and structural services that govern how attributes and attribute groups are defined, validated, manipulated, and rendered within Ego-based entities such as items, change orders, and user attribute models.

The framework retrieves attribute group definitions, verifies whether attributes carry data, resolves underlying database columns and tables, determines privileges governing attribute group visibility, and gathers change history from the associated audit tables. Through these operations, the package abstracts the complex internal schema so that dependent Oracle modules and customer extensions can interact with the extensibility model through a stable, documented interface. Metadata confirms the package is VALID in the APPS schema and is both dependent upon and depended upon by a wide set of Ego and inventory packages.

Key Procedures and Functions

The package exposes 118 documented procedures and functions. Representative entries include:

• GET_PRIVILEGE_FOR_ATTR_GROUP — Returns the privilege information associated with a given attribute group, supporting access control and visibility decisions.
• GET_ATTR_GROUP_ID_FROM_PKS — Resolves an attribute group identifier from its primary key components.
• CREATE_ATTRIBUTE_GROUP / COPY_ATTRIBUTE_GROUP — Provide programmatic creation and duplication of attribute group definitions.
• DOES_ATTR_HAVE_DATA — Determines whether an attribute currently holds data, useful before modification or deletion.
• IS_COLUMN_INDEXED — Indicates whether a backing database column is indexed.
• GET_AVAILABLE_ATTRDBCOL / GET_AVAILABLE_ATTRDBCOLS — Return available attribute database columns for assignment.
• GET_ATTR_CHANGES_TABLE, GET_ATTR_CHANGES_B_TABLE, GET_ATTR_CHANGES_TL_TABLE — Return the change-tracking table names associated with attributes.
• GET_TABLE_NAME / GET_TL_TABLE_NAME — Return base and translation table names for attribute storage.
• GET_OBJECT_ID_FROM_NAME / GET_OBJECT_ID_FOR_AG_TYPE — Resolve object identifiers from names or attribute group types.
• GET_CLASS_MEANING, GET_PK_COLUMNS — Return class meanings and primary key column lists.
• GET_APPLICATION_OWNER / GET_ORACLE_USERNAME — Return ownership and session username context.
• CHECK_SUPPORTED_ATTR_USAGES — Validates whether specified attribute usages are supported.

Tables Accessed

The package operates over the Ego extensibility schema through APPS synonyms, including EGO_ATTR_GROUPS_S, EGO_ATTR_GROUP_DL, EGO_ATTRS_S, EGO_ACTIONS_B, EGO_ACTIONS_DL, EGO_ACTIONS_S, EGO_ACTIONS_TL, EGO_ACTION_DISPLAYS_B, EGO_ACTION_GROUPS_B, EGO_ACTION_GROUPS_S, EGO_ACTION_GROUPS_TL, EGO_ACTN_GRP_ENTRIES_B and EGO_ASSOCS_S. These tables hold attribute group definitions, attribute definitions, action and display metadata, associations, and translated descriptions. The package also references EGO_VS_VALUES_DISP_ORDER and FND_FLEX_VALUE_SETS for value set and display ordering lookups, and relies on FND_API for standard API error handling and messaging conventions.

Usage Notes

EGO_EXT_FWK_PUB is accessed internally by numerous Oracle packages, including EGO_ITEM_PVT, EGO_ITEM_BULKLOAD_PKG, EGO_ITEM_COMPARE_PKG, EGO_UPLOAD_PUB, EGO_GTIN_PVT, EGO_USER_ATTRS_DATA_PVT, EGO_USER_ATTRS_COMMON_PVT, EGO_USER_ATTRS_BULK_PVT, EGO_ITEM_USER_ATTRS_CP_PUB, EGO_IMPORT_BATCH_COMPARE_PVT, EGO_USER_ATTRS_CP_PUB, INV_EGO_REVISION_VALIDATE and CZ_APC_GRP. It is invoked during item attribute bulk loading, item comparison, import batch processing, revision validation, and user attribute maintenance, as well as by extension forms that manage attribute groups and actions. Custom code should treat it as a supported public interface for attribute group and attribute metadata operations, leveraging FND_API conventions for returns.