Search Results c_eng_flag_whereformula

Overview

APPS.BOM_BOMRDDEL_XMLP_PKG is the Oracle E-Business Suite PL/SQL package that supports the BOM Report Delivery Deletion concurrent program in Oracle Bills of Material. The package encapsulates the report-level logic for XML Publisher concurrent program BOMRDDEL, which performs bulk deletion of bill of material structures and their associated routing, component, and operation data based on parameter-driven selection criteria. It is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the invoking schema rather than the package owner, and its header is tracked under the BOMRDDELS.pls source file.

The package exposes a set of global package-level variables that mirror the concurrent program parameter list. These include P_LANGUAGE, P_GROUP_FROM and P_GROUP_TO (item range), P_ORGANIZATION_ID, P_CONC_REQUEST_ID, and an extensive set of flag variables: P_ITEM_FLAG, P_BILL_FLAG, P_ROUT_FLAG, P_COMP_FLAG, P_OPER_FLAG, P_BR_FLAG, P_IBR_FLAG, P_PEND_STATUS_FLAG, P_CHECK_STATUS_FLAG, P_ERROR_STATUS_FLAG, P_DEL_STATUS_FLAG, P_TRACE_FLAG, and P_OPTIMIZER_CODE, together with the P_BOM_OR_ENG and P_DEBUG control values. These variables govern what entity types the report selects and how messages are formatted for output.

Key Procedures and Functions

The package contains twelve documented program units. BEFOREREPORT and AFTERREPORT are the standard XML Publisher report triggers, invoked at the start and end of report execution to initialize state and finalize output. BEFOREPFORM serves the pre-format trigger role.

The WHERE_GROUP, WHERE_TYPE, WHERE_TYPE1, WHERE_ENTITY_STATUS, and WHERE_SUB_ENTITY_STATUS functions build dynamic WHERE clause fragments used by the report query. C_ENG_FLAG_WHEREFORMULA returns an additional where-formula string tied to the engineering-change flag.

The message functions produce descriptive output for the report. GET_MESSAGE accepts an ENTITY_MESSAGE parameter and returns a formatted string. GET_MESSAGE2 and GET_MESSAGE3 return message text without a documented input parameter. GET_MESSAGE3, the object most commonly located by users searching for it, returns a message value used in the report output; the original GET_MESSAGE (no parameter) is retained as a commented line in the header, indicating it was superseded in a later revision.

Tables Accessed

The ETRM metadata for this package does not itemize direct table references; the documented objects are the public variables and program units only. In practice, the deletion report and its supporting package operate over Bills of Material entities through APPS synonyms such as BOM_BILL_OF_MATERIALS, BOM_STRUCTURES_B, BOM_COMPONENTS_B, BOM_OPERATIONAL_ROUTINGS, and related inventory item and status views. Deleted and checked-out entities are evaluated against pending, check, error, and delete status flags exposed as package globals.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is registered against the BOM Report Delivery Deletion XML Publisher concurrent program and is executed by the Oracle Reports/XML Publisher runtime when that program is submitted. ETRM records zero inbound package references, confirming it is a leaf-level support package rather than a shared library.

Because the source header is marked "noship" and carries a 2007 revision tag, the package should be treated as internal and version-specific to the BOMRDDEL program. Customizations should target the concurrent program parameters rather than the package itself.