Search Results ego_functions_s

Overview

APPS.EGO_FUNCTIONS_BULKLOAD_PVT is a private PL/SQL package body in the Oracle E-Business Suite (EBS) that supports bulk import of extensible attribute function metadata into the EGO (Enterprise Governance/Attribute) repository. Its object name carries the "PVT" classification, marking it as an internal, non-public API that is not intended for direct customer invocation. It underpins the bulkload capability by which function definitions and their associated function parameters are staged in interface tables, validated, and then transacted into the base EGO metadata tables. Because the package name embeds the string "ego_functions_s," it is frequently surfaced when technicians search the data dictionary for the EGO_FUNCTIONS_S sequence and the surrounding function-loading infrastructure.

Key Procedures and Functions

The package body exposes sixteen documented procedures and functions organized into two logical groups: functions and function parameters.

• IMPORT_FUNCTIONS_INTF — Entry point that imports staged function rows from the interface into the processing pipeline.
• DELETE_PROCESSED_FUNCTIONS — Removes already-processed function records from the interface table after successful load.
• INITIALIZE_FUNCTIONS — Sets up internal control structures and working state for a functions batch.
• CONSTRUCT_FUNCTION — Builds the in-memory record representation of a function for validation and transaction.
• VALIDATE_FUNCTION — Applies business and referential validation rules to a single constructed function.
• TRANSACT_FUNCTION — Commits a validated function into the base EGO tables.
• PROCESS_FUNCTIONS — Orchestrates the end-to-end load of a functions batch.
• UPDATE_INTFC_FUNCTIONS — Writes back status and error information to the interface table.
• BULK_VALIDATE_FUNCTIONS — Performs set-based validation across many function rows.
• INITIALIZE_FUNC_PARAMS — Establishes working state for a function-parameter batch.
• CONSTRUCT_FUNC_PARAM — Assembles the in-memory representation of a function parameter.
• VALIDATE_FUNC_PARAM — Validates a single function parameter.
• TRANSACT_FUNC_PARAM — Writes a validated parameter to the base tables.
• PROCESS_FUNC_PARAMS — Coordinates the parameter load cycle.
• UPDATE_INTFC_FUNC_PARAMS — Persists status and error details for parameter rows.
• BULK_VALIDATE_FUNC_PARAMS — Performs set-based validation of parameters.

Tables Accessed

The package reads and writes a defined set of EGO metadata tables through APPS synonyms. Staging occurs in EGO_FUNCTIONS_INTERFACE and EGO_FUNC_PARAMS_INTERFACE. Base storage targets include EGO_FUNCTIONS_B, EGO_FUNCTIONS_S, EGO_FUNCTIONS_TL, EGO_FUNC_PARAMS_B, EGO_FUNC_PARAMS_S, and EGO_FUNC_PARAMS_TL, with related action metadata in EGO_ACTIONS_B, EGO_ACTION_DISPLAYS_B, and EGO_MAPPINGS_B. Reference and error data are drawn from FND_LANGUAGES, FND_LOOKUP_VALUES, FND_NEW_MESSAGES, and MTL_INTERFACE_ERRORS.

Usage Notes

Because this is a private (PVT) package body, it is invoked internally by EBS bulkload concurrent programs and supporting packages rather than called directly from forms or custom code. It is not referenced by any database object, but it references peer utilities such as EGO_METADATA_BULKLOAD_PVT, EGO_METADATA_PUB, ERROR_HANDLER, and FND_API. Customizations should always target the public EGO_METADATA_PUB API or populate the interface tables directly, allowing this private package to perform validation and transaction.