Search Results dp_all_orgs

Overview

ENG_ENGRCNDR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS that supports the Engineering Change Notice (ECN) related concurrent program reports produced through Oracle XML Publisher. The underlying source header (ENGRCNDRS.pls) identifies it as a report-supporting package, and the extensive collection of global variables and helper functions it exposes confirms this role. The package exists to supply an XML Publisher report template with runtime query parameters, formatted display values, and derived data values that the report's SQL and layout cannot generate on their own. Its scope is confined to the engineering change management area of Oracle Manufacturing/Engineering, specifically the reporting of change notices against revised items.

Key Procedures and Functions

The package exposes nineteen documented program units. They fall into two functional groups: XML Publisher before/after execution hooks and value-formatting helper functions.

• BEFOREREPORT — Runs before the report query executes; initializes the package's global variables from the concurrent request parameters and returns a boolean to signal success or failure.
• AFTERREPORT — Runs after the report completes; performs any cleanup or post-processing required by the report template.
• BEFOREPFORM and AFTERPFORM — Formatting hooks executed before and after each report page, used to control page-level presentation such as headers or page-break behaviour.
• BETWEENPAGE — Invoked between page breaks, allowing the template to emit repeating or transitional content across pages.
• GET_REV — Returns the revision for a given revised item identifier. This is the function matching the user's search term and is the primary mechanism by which the report displays item revision values.
• LATEST_REV — Returns the latest available revision for a revised item, allowing the report to distinguish the current revision from historical ones.
• LIMIT_CHANGE_NOTICES — Returns a character value controlling whether the change notice list is constrained, tied to the associated C_LIMIT_CHANGE_NOTICES global.
• GET_NAME, GET_REQ_NAME, GET_ITEM_TYPE — Return descriptive text for names, request names, and item types respectively, so the report can present readable labels rather than raw codes.
• OPTIONAL_DISPFORMULA, COSTED_DISPFORMULA, CHECK_ATP_DISPFORMULA, MUTUALLY_EXCLUSIVE_DISPFORMULA, REQUIRED_TO_SHIP_DISPFORMULA, REQUIRED_FOR_REVENUE_DISPFORMU, INCLUDE_ON_SHIP_DISPFORMULA, QUANTITY_RELATED_DISPFORMULA — A family of display-formula functions that convert numeric or boolean attribute flags on change order lines into the human-readable terms defined by the P_YES/P_NO globals.

Tables Accessed

The package reads from a small, focused set of APPS synonyms:

• MTL_ITEM_REVISIONS — The primary source for revision lookup, supporting GET_REV and LATEST_REV.
• BOM_LISTS and BOM_LISTS_S — Bill of material list data associated with the revised items being reported.
• HZ_PARTIES — Party information used to resolve requester or ownership names displayed on the change notice.
• MTL_PARAMETERS — Organization-level manufacturing parameters, used in conjunction with the P_ORG_ID parameter to scope the report to the correct inventory organization.
• PLITBLM and DUAL — PL/SQL table and single-row utility access used for internal computation and value derivation.

Usage Notes

ENG_ENGRCNDR_XMLP_PKG is not called by any other package; ETRM records zero referencing packages. Its invocation path is therefore exclusively through the concurrent program infrastructure. When the Engineering Change Notice XML Publisher report is submitted, the concurrent manager executes the package's BEFOREREPORT function, which populates the global parameters (organization, notice range, date range, structure numbers, flexdata fields, and debug flag) before the report's data model runs. The report query then calls the helper functions — GET_REV and LATEST_REV for revision display, the DISPFORMULA functions for attribute presentation, and the name-resolution functions for descriptive labels — while the page hooks BEFOREPFORM, BETWEENPAGE, and AFTERPFORM manage layout. The package supports a debug mode through P_DEBUG, and the P_ALL_ORGS / DP_ALL_ORGS and P_ORG_HIERARCHY globals indicate that the report can be run across all organizations or restricted by organization hierarchy. Customizations should be avoided in favour of the supported report template, since the package is flagged noship and is an internal report-support artifact rather than a public API.