Search Results cp_sysdate

Overview

PQH_PQUBGTEN_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. It is a report-support package generated to back the XML Publisher (BI Publisher) concurrent program PQUBGTEN, which produces the "Business Group Tenure" or equivalent establishment/tenure report within the Oracle Human Resources (PQH) product family. The package is declared with AUTHID CURRENT_USER, meaning that at runtime it executes with the privileges of the invoking user rather than the definer, and it relies on APPS synonyms to reach the underlying base tables.

Its principal responsibility is to hold report parameters, expose derived global (CP_) variables, and execute BeforeReport, AfterReport, and BeforePForm trigger logic used by the XML Publisher report template. As a generated "XMLP" package, it is not intended as a general-purpose business API; it is bound to a single report definition and is regenerated whenever that report is edited in the XML Publisher administration UI.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, principally report trigger entry points and accessor ("_p") functions for report globals.

• BEFOREREPORT — Fires before the report query executes; initializes package state and sets up data retrieval.
• AFTERREPORT — Fires after report processing completes; used for cleanup or post-processing.
• BEFOREPFORM — Trigger executed before the report's parameter form is displayed.
• CP_SYSDATEFORMULA — Returns a date used to seed the CP_SYSDATE global, typically the current system date.
• CF_AMOUNT_FORMAT_MASKFORMULA — Accepts a unit of measure and returns a character format mask, controlling numeric formatting in the report output.
• CP_NO_DATA_P — Accessor returning the CP_No_Data flag indicating whether the report produced no rows.
• CP_SYSDATE_P — Accessor returning the CP_SYSDATE date global.
• CP_BG_NAME_P — Accessor returning the business group name.
• CP_UOM_P — Accessor returning the unit of measure; this is the object matched by the "cp_uom_p" search term.
• CP_ENTITY_NAME_P — Accessor returning the entity name associated with the report parameters.
• CP_ORG_STRUCTURE_NAME_P — Accessor returning the organization structure name.
• CP_START_ORG_NAME_P — Accessor returning the name of the starting organization.
• CP_REPORT_TITLE_P — Accessor returning the formatted report title.

Tables Accessed

The package references four documented tables through APPS synonyms:

• FND_SESSIONS — Read to identify the current application session and concurrent request context.
• PER_ORGANIZATION_STRUCTURES — Provides organization hierarchy information used to resolve the organization structure and starting organization parameters.
• PQH_PROCESS_LOG — Used for logging report execution activity within the HR process framework.
• DUAL — Used for scalar expression evaluation and for retrieving the current system date.

Usage Notes

This package is invoked indirectly by the Oracle Reports/XML Publisher runtime when the associated concurrent program is submitted from the Submit Requests form or from an HR responsibility menu. Because it is generated code and classified as "OTHER," it is not supported for direct invocation from custom PL/SQL, and it is referenced by zero other packages in the ETRM repository. Customizations should be made through the XML Publisher report definition rather than by altering the package. The presence of P_CONC_REQUEST_ID confirms the standard concurrent program integration pattern, allowing the package to bind request parameters and enable diagnostic output via the concurrent manager log.