Results for “pqh_pqubgten_xmlp_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.PQH_PQUBGTEN_XMLP_PKG package body is the report logic container generated by Oracle XML Publisher (BI Publisher) for the Oracle E-Business Suite concurrent program associated with Position Budget Analysis. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher concurrent programs generate a PL/SQL package whose body wraps the data model query and supplies the before-report and after-report hooks required by the XML Publisher runtime. This package, identified by the module code POSITION_BUDGET_ANALYSIS, prepares the parameter values and derived report attributes needed before the extract query executes, then formats the output rendered by the Publisher engine.

The $Header comment identifies the source as PQUBGTENB.pls, version 120.3, dated 28-Feb-2008, indicating a non-shipped (Noship) source object under the APPS schema. The package is classified as OTHER in the ETRM registry and is not invoked by any other PL/SQL package.

Key Procedures and Functions

• BEFOREREPORT — The primary initialization function. It stores the effective date in display format, decodes the business group name, sets the report title from the PQH_REPORT_TITLES lookup (code PQHWSUBE), resolves organization structure and starting organization names, resolves the entity and unit-of-measure meanings, and calls pqh_budget_analysis_pkg.get_entity to prime the analysis data.
• AFTERREPORT — Post-processing hook executed after the report data is fetched.
• BEFOREPFORM — Pre-formats data before report rendering.
• CP_SYSDATEFORMULA and CF_AMOUNT_FORMAT_MASKFORMULA — Lexical/formula functions supplying the system date and the amount format mask to the template.
• CP_SYSDATE_P — Returns the current (truncated) system date for the report header.
• CP_NO_DATA_P — Flags whether the report returned no data.
• CP_BG_NAME_P — Exposes the decoded business group name.
• CP_UOM_P — Exposes the decoded unit-of-measure description.
• CP_ENTITY_NAME_P — Exposes the decoded budget entity name.
• CP_ORG_STRUCTURE_NAME_P — Exposes the organization structure name.
• CP_START_ORG_NAME_P — Exposes the starting organization name.
• CP_REPORT_TITLE_P — Exposes the report title resolved from the PQH_REPORT_TITLES lookup, which is the value surfaced in response to the search term "pqh_report_titles."

Tables Accessed

• FND_SESSIONS — Standard EBS session context used by the XML Publisher runtime.
• PER_ORGANIZATION_STRUCTURES — Read to resolve the organization structure name from p_org_structure_id.
• PQH_PROCESS_LOG — Queried against module code POSITION_BUDGET_ANALYSIS to check whether the report process has logged an entry for the current batch.
• DUAL — Used by the current-date cursor to return trunc(sysdate).

Usage Notes

This package is invoked exclusively by the XML Publisher concurrent program engine when the Position Budget Analysis report is submitted. The BEFOREREPORT function runs before the data extract, and AFTERREPORT runs after. The CP_* functions act as XML Publisher data-model lexicals referenced by the report template, making derived values such as the report title, business group, entity, unit of measure, and organization names available to the layout. Custom code should not call these functions directly, as they depend on runtime parameters bound by the concurrent manager. The package is documented as referenced by zero other packages, confirming its role as a report-level artifact rather than a reusable API.