Search Results p_session_id

Overview

EGO_PUB_WS_AG is a PL/SQL package body owned by APPS that supports metadata exploder behavior within the Oracle Product Information Management (PIM) and Product Lifecycle Management (PLM) public web services layer. Its header, sourced from EGOPAGB.pls (version 120.8.12020000.2), identifies it as a "packaged procedure for the PLM metadata exploders." The package classifies as an API of type OTHER under ETRM 12.2.2 and is designed to validate attribute group identifiers and names, preprocess inbound attribute group payloads, and explode attribute group metadata into the entity and parameter structures consumed by the EGO web service framework.

The user query term p_session_id reflects the package's reliance on a session identifier convention. The visible Validate_Attribute_Group function accepts p_session_id NUMBER as its first parameter, which confirms that the metadata exploders carry a caller session context through the attribute group processing chain. This identifier is used to correlate inbound web service calls with their persisted batch, entity, and parameter records.

Key Procedures and Functions

• CREATE_PARAMS_ATTRIBUTE_GROUP — Creates the parameter-level records associated with an attribute group during the exploder workflow, persisting parameter metadata into the EGO_PUB_WS_PARAMS and related batch entities tables.
• PREPROCESS_INPUT_ATTRGROUP — Normalizes and validates inbound attribute group input before explosion. The visible Validate_Attribute_Group logic (which maps SOAPUI placeholder values such as '?' and '-1' to NULL) is representative of this preprocessing behavior.
• EXPLODE_ATTRIBUTE_GROUP — Drives the actual explosion of an attribute group definition into its constituent entities, identifiers, and parameters, using the metadata registry tables to resolve name and ID mappings.

The public Validate_Attribute_Group function accepts either an attribute group ID or name, returning TRUE when valid, deriving the missing identifier, and returning both values through OUT NOCOPY parameters. It queries EGO_ATTR_GROUPS_V to resolve the ATTR_GROUP_NAME from ATTR_GROUP_ID.

Tables Accessed

• EGO_PUB_WS_CONFIG, EGO_PUB_WS_ENTITIES, EGO_PUB_WS_ENTITIES_S, EGO_PUB_WS_INPUT_IDENTIFIERS, EGO_PUB_WS_PARAMS — Core web service metadata registry storing entity, identifier, and parameter definitions consumed during explosion.
• EGO_PUB_BAT_ENTS_B, EGO_PUB_BAT_PARAMS_B — Batch entity and parameter base tables written during CREATE_PARAMS_ATTRIBUTE_GROUP.
• EGO_FND_DF_COL_USGS_EXT, EGO_FND_DSC_FLX_CTX_EXT, EGO_VALUE_SET_EXT — Extension tables supporting descriptive flexfield column usages, contexts, and value set metadata.
• FND_DESCR_FLEX_COLUMN_USAGES, FND_FLEX_VALUE_SETS — Standard FND flexfield definition tables read for attribute resolution.
• DBMS_SQL, DBMS_UTILITY, DUAL — Dynamic SQL and utility packages used for generic metadata queries.

Usage Notes

EGO_PUB_WS_AG is invoked indirectly through the EGO public web services interface, typically as part of attribute group creation and update flows driven by external PLM integrations. It is referenced by one other package in the ETRM dependency graph, indicating it functions as a supporting component rather than a top-level entry point. Customizations should avoid modifying this APPS-owned package directly; instead, extend behavior through the documented public procedures or wrapper code that passes a valid p_session_id to maintain session-level consistency across batch entity and parameter writes.