Search Results set_in_service_thru_date

Overview

APPS.PA_PAXCPGAL_XMLP_PKG is the generated PL/SQL package body that implements the Oracle XML Publisher (BI Publisher) concurrent program report known internally as PAXCPGAL — the Project Assets "Capital Event / Generate Asset Lines" style report used in Oracle Projects. Its role is to supply the report template with cover-page values, initialization logic, and runtime substitution values before the XML output is rendered. The package header declares the program's input parameters and formula columns, while this body supplies the executable logic for the report's before-report, after-report, and formula hooks. It is an auto-generated XMLP wrapper package, indicated by the _XMLP_PKG suffix and the standard header comment ($Header: PAXCPGALB.pls 120.2 2008/01/03). In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is bound to the concurrent program definition, so it is executed by the Concurrent Manager whenever the associated report is submitted.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, separated into report lifecycle hooks and formula columns:

• GET_COVER_PAGE_VALUES — Returns a BOOLEAN indicating whether cover-page parameter values were successfully retrieved; it simply returns TRUE and traps exceptions by returning FALSE.
• BEFOREREPORT — The principal initialization routine. It resolves the NO_DATA_FOUND message from PA_LOOKUPS, obtains the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, resolves the reporting currency through PA_CURRENCY, calls PA_FAXFACE.SET_IN_SERVICE_THRU_DATE, derives the period end date, and processes the capital event identifier. A local INIT_FAILURE exception aborts the report if prerequisite setup is incomplete.
• GET_COMPANY_NAME — Retrieves the company (organization) name used in report headers; its failure raises INIT_FAILURE from BEFOREREPORT.
• UNASSIGNEDFORMULA and CF_RET_UNASSIGNEDFORMULA — Formula columns returning the "Unassigned" display value for report rows lacking an assigned entity.
• CF_FORMAT_MASKFORMULA — Formula column supplying a formatting mask applied to displayed numeric values.
• CURR_CODEFORMULA and CURR_CODE_P — Formula column and parameter/placeholder exposing the functional currency code resolved at runtime (CURR_CODE).
• AFTERREPORT — Post-report cleanup hook executed after XML generation.
• C_COMPANY_NAME_HEADER_P, C_NO_DATA_FOUND_P, C_DUMMY_DATA_P, C_RETCODE_P — Placeholder parameters bound to the report's XML data model, surfacing the company name header, the localized no-data-found message, a dummy data placeholder, and the return/status code.

Tables Accessed

Documented access is read-only and limited to configuration and reference data:

• PA_CAPITAL_EVENTS — Read to resolve CAPITAL_EVENT_NUMBER from the submitted P_CAPITAL_EVENT_ID, driving the report's capital event context.
• PA_IMPLEMENTATIONS — Supplies installation/organization configuration used during initialization.
• PA_PERIODS — Used to obtain MAX(END_DATE) not exceeding the user's through date, establishing the period end used for asset line generation.
• PA_REPORTING_EXCEPTIONS — Supports reporting-exception handling logic.
• DUAL — Utility selects that materialize the concurrent request ID, through dates, and currency values into package variables.
• PA_LOOKUPS — Queried for LOOKUP_TYPE 'MESSAGE' and LOOKUP_CODE 'NO_DATA_FOUND' to localize the empty-result message.

Usage Notes

The package is not intended for direct invocation. It is called by the Concurrent Manager through the PAXCPGAL concurrent program registration, using the standard XML Publisher lifecycle: FND SRWINIT initialization, BEFOREREPORT for value resolution, formula columns during row processing, and AFTERREPORT for cleanup. Because BEFOREREPORT raises INIT_FAILURE when GET_COMPANY_NAME fails, submitters should confirm company/organization setup and valid period parameters before running. The absence of any dependent packages and its APPS-schema ownership mean customizations should target the underlying report definition rather than this generated body, which is regenerated and overwritten during patching.