Search Results g_ps_to_be_processed

Overview

APPS.EGO_CHANGE_USER_ATTRS_PUB is a public PL/SQL package in Oracle E-Business Suite that supports the Engineering Change Order (ECO) user-attribute import process. Its role is to move user-defined attribute data staged in the Engineering Change Order interface tables into the base Engineering Change Order tables, converting staged interface rows into live change order and change line attribute records. The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the package owner.

The package is oriented around a staging-to-production loading model. Interface rows carry a PROCESS_STATUS value that tracks their state, and the package exposes named constants that define those states: G_PS_TO_BE_PROCESSED (value 1, set by the caller to indicate a row should be processed), G_PS_IN_PROCESS (2, set by the bulkloader while processing), G_PS_ERROR (3, set when a row fails), and G_PS_SUCCESS (4, set when a row loads successfully). Because rows sharing the same ROW_IDENTIFIER are processed as one logical unit, an error status on one row can reflect a failure originating in a different row with the same identifier.

Key Procedures and Functions

• PROCESS_CHANGE_USER_ATTRS_DATA — The primary import driver. It processes all interface table rows belonging to a passed-in data set identifier. It accepts standard concurrent program parameters (ERRBUF, RETCODE) plus a data set ID, a debug level from 0 to 3, and a purge flag indicating whether successfully processed rows should be deleted from the data set.
• GET_CURRENT_DATA_SET_ID — Returns the current data set identifier, used by callers and the bulk loader to establish the scope of rows being processed in a run.
• PROCESS_CHANGE_USER_ATTRS — Handles processing of change-order-level user attribute data from the interface into the base change tables.
• PROCESS_CHANGE_LINE_USER_ATTRS — Handles processing of change-line-level user attribute data, applying the corresponding attribute values to individual change lines.
• CHECK_DELETE_ASSOCIATIONS — Validates or manages delete associations, ensuring that related records are handled consistently when attribute data is removed or replaced.

Tables Accessed

The package reads and writes through APPS synonyms against both interface and base tables. The interface tables ENG_CHG_USR_ATR_INTERFACE (change user attributes) and the associated change-line interface structures hold the staged rows identified by data set. Base tables include ENG_ENGINEERING_CHANGES and ENG_CHANGE_LINES, which receive the validated attribute data. Sequence objects EGO_IUA_DATA_SET_ID_S and ENG_CUA_DATA_SET_ID_S supply data set identifiers. Setup and reference tables such as FND_USER, FND_FORM_FUNCTIONS, and MTL_PARAMETERS are consulted for validation and defaults, while DUAL and PLITBLM support generic PL/SQL operations.

Usage Notes

The package is typically invoked from the Engineering Change Order import concurrent program, which passes the data set ID to PROCESS_CHANGE_USER_ATTRS_DATA after a caller (often a custom loader or a form-based staging routine) has inserted interface rows and marked them with G_PS_TO_BE_PROCESSED. Debug output is controlled through the debug level parameter, and successful interface rows may be purged based on the purge flag. Because the package is classified as PUBLIC and references APPS synonyms, it is a supported integration point for custom code that populates the change order interface tables and then triggers the import. Standard EBS error handling applies: failed rows are flagged with G_PS_ERROR for review and correction before reprocessing.