Search Results g_entity_eco_revision

Overview

APPS.ENG_GLOBALS is a shared PL/SQL specification package in Oracle E-Business Suite that centralizes global constants, session-level control records, and utility routines used throughout the Oracle Engineering (ENG) product modules. It is declared with AUTHID CURRENT_USER, meaning its unqualified references to database objects resolve under the privileges of the invoking session rather than the package owner. The specification carries a header indicating maintenance through patch level 120.0.12010000.2 dated 2009/11/12, which aligns with the Oracle EBS 12.1.1 code line and remains compatible with the 12.2.2 technology stack.

The package's primary business role is to provide a single, consistent vocabulary for engineering change management processing. It defines entity type constants such as G_ENTITY_ECO, G_ENTITY_ECO_REVISION, G_ENTITY_REVISED_ITEM, and G_ENTITY_REV_COMPONENT; change management type codes including G_CHANGE_REQUEST and G_CHANGE_ORDER; and operation constants such as G_OPR_CREATE, G_OPR_UPDATE, G_OPR_DELETE, G_OPR_LOCK, and G_OPR_CANCEL. It also publishes a Control_Rec_Type record type used to control whether a given operation is permitted, along with a maximum defaulting iteration threshold of five and a launch-import counter for concurrent processing.

Key Procedures and Functions

The package exposes 74 documented procedures and functions. Those most relevant to general engineering processing include:

• INIT_SYSTEM_INFO_REC — initializes the system information record used to track session-level engineering context.
• GET_SYSTEM_INFORMATION / SET_SYSTEM_INFORMATION — retrieve and assign values in that system information record.
• INIT_CONTROL_REC / INIT_WHO_REC / INIT_WHO_REC_ENTITY_DETAILS — initialize operation control and audit ("who") records, including entity-level detail.
• INIT_PROCESS_NAME / GET_PROCESS_NAME — establish and retrieve the identifier of the currently executing process.
• ADD_REQUEST / GET_REQUEST_STATUS / GET_UNPROCESSED_REQUEST / CLEAR_REQUEST_TABLE — manage the request staging table used to submit and poll engineering processing requests.
• CHECK_APPROVED_FOR_PROCESS / SET_REQUEST_FOR_APPROVAL — enforce approval gating before a change may be processed.
• TRANSACTION_TYPE_VALIDITY — validate whether a transaction type is permitted for the current operation.
• GET_ECO_ASSEMBLY_TYPE / ECO_CANNOT_UPDATE / GET_PLM_OR_ERP_CHANGE — determine engineering change order assembly classification, detect non-updatable ECO conditions, and resolve whether a change originates in PLM or ERP.
• SET_BILL_SEQUENCE_ID / GET_BILL_SEQUENCE_ID — set and retrieve the bill sequence identifier maintained in the package's global state, used to track bill of material sequencing during engineering change processing. This pair is the routine most commonly targeted by callers searching for bill sequence handling in the ENG schema.

Tables Accessed

Through APPS synonyms, the package references BOM_OPERATIONAL_ROUTINGS and its _S shadow table, BOM_OPERATION_RESOURCES, BOM_OPERATION_SEQUENCES, and BOM_SUB_OPERATION_RESOURCES for routing and resource context. Engineering change data is drawn from ENG_CHANGE_ORDER_TYPES, ENG_CHANGE_TYPE_PROCESSES, ENG_ENGINEERING_CHANGES, ENG_REVISED_ITEMS, and ENG_REVISED_OPERATIONS. Item and revision context comes from MTL_SYSTEM_ITEMS, MTL_RTG_ITEM_REVISIONS, and MTL_PARAMETERS. DUAL and the PL/SQL table PLITBLM support scalar queries and in-memory collection handling.

Usage Notes

ENG_GLOBALS is called from Engineering forms, concurrent programs, and the APIs of dependent packages; ETRM records it as referenced by 25 other packages. Custom code should treat the published constants as read-only, avoid altering global state without reinitializing the control and system information records, and respect the AUTHID CURRENT_USER behavior when granting execution rights.