Search Results p_organization_code

Overview

APPS.ENG_ECO_PUB is a public PL/SQL package in Oracle E-Business Suite that implements the business logic for Engineering Change Order (ECO) processing. It operates within the Oracle Engineering module and serves as the programmatic interface for creating and validating engineering change orders, revisions, and revised item associations. The package exposes a PL/SQL API classified as PUB, meaning it is sanctioned for external invocation by other Oracle EBS modules, forms, and custom extensions.

The package body carries a header revision tag indicating a long maintenance history: initial development in 2000 for ECO enhancement, followed by engineering change enhancements in 2002 that added functions such as Does_ChangeLine_Have_Same_ECO, Does_People_Have_Same_ECO, and a reworked Process_Eco supporting new entities. A later revision in December 2002 removed people processing from the package, leaving item and revision validation as the core concerns. This lineage explains why the package centers on validating that revised items and ECO revisions share consistent ECO names and organization codes before committing change activity.

Key Procedures and Functions

• PROCESS_ECO — The single documented public procedure in this package. It is the primary entry point for processing an engineering change order against the schemas and entity collections defined by the package types. Invoking PROCESS_ECO drives the validation and persistence of the ECO header along with its associated revised items and revisions, orchestrating the checks exposed by the helper functions described below.
• Does_Rev_Have_Same_ECO — A private helper function that inspects a collection of ECO revision records and returns a Boolean indicating whether every entry shares the same ECO name and organization code. It explicitly compares each record's organization_code against the controlling p_organization_code parameter, making it the routine most directly associated with the user's search term.
• Does_Item_Have_Same_ECO — A parallel helper that performs the same consistency check across a collection of revised item records, again keyed on ECO name and p_organization_code.

Tables Accessed

• ENG_ENGINEERING_CHANGES — The base ECO header table, holding change notice identifiers, status, and organizational context.
• ENG_CHANGE_ORDER_TYPES and ENG_CHANGE_ORDER_TYPES_TL — Define valid change order type classifications and their translated descriptions, used to validate or default the type assigned to a new ECO.
• ENG_AUTO_NUMBER_ECN — Supplies automatic numbering for engineering change notice identifiers when the configured numbering scheme requires it.
• PLITBLM — A generic PL/SQL index-by table synonym often referenced in Oracle EBS APIs for bulk collection plumbing.

Usage Notes

ENG_ECO_PUB is referenced by 33 other packages, confirming its role as a shared service within Oracle Engineering and adjacent modules such as Bills of Material and Inventory. It is typically invoked from the Engineering Change Order forms, from concurrent programs that mass-process ECOs, and from custom code performing bulk or unattended ECO creation. When an application needs to p_organization_code-scope an ECO operation, this package's validation routines enforce that all revisions and items submitted in a single call belong to the same organization, preventing cross-organization change contamination. Developers should always supply a valid organization code and ECO name, since the helpers compare these against collection contents using NVL semantics and will reject a batch on the first mismatch.