Search Results p_run_period

Overview

PA_PACCINTG_XMLP_PKG is an Oracle Application Object Library (AOL) reporting package that supports the Project Accounting transaction interface and cost integration concurrent programs within Oracle E-Business Suite. In the context of EBS 12.1.1 and 12.2.2, this package is generated and registered for the XML Publisher (BI Publisher) report that extracts, formats, and reports on project transaction interface data prior to its import into Project Accounting transaction tables. The package operates with AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the calling schema (typically APPS or an associated user). Its source header confirms generation from a report definition file (PACCINTGS.pls) and reflects the standard structure produced by the Oracle Reports or XML Publisher concurrent program framework, where global package-level variables hold concurrent program parameters and internal functions handle before-report, after-report, and formula-column logic.

Key Procedures and Functions

The package exposes the following documented program units:

• BEFOREREPORT — Standard report initialization function invoked immediately before the report executes. It sets up package state such as initialized parameters and derived values.
• GET_COMPANY_NAME — Retrieves the company (legal entity) name, populating the C_COMPANY_NAME global used as a report header attribute.
• PROCESS_FAILED_RUN — Handles error and failure processing for a concurrent program run, typically invoked from AFTERREPORT or failure logic to mark the run status and clean up interface control rows.
• AFTERREPORT — Post-report cleanup and status-update function executed after the report completes.
• CF_FORMAT_MASKFORMULA — A formula-column function (the "CF_" prefix denotes a computed/formula column in the report definition) that returns a VARCHAR2 format mask string. This is the unit matched by the user's search term "cf_format_maskformula." It supplies the format mask used to render a report value — most commonly the mask applied to the run period or date fields based on the period/date format configured in the implementation.
• C_COMPANY_NAME_P — Public accessor returning the C_COMPANY_NAME global variable.
• CP_RET_STS_P — Public accessor returning CP_RET_STS, the concurrent program return status global.

Tables Accessed

The package queries the following APPS synonyms, all of which are documented in the ETRM metadata:

• GL_PERIOD_STATUSES — Used to validate the run period parameter (P_RUN_PERIOD) and to determine period status, supporting the format mask logic in CF_FORMAT_MASKFORMULA.
• PA_IMPLEMENTATIONS — Provides implementation-level settings, including period/date format configuration and organizational defaults.
• PA_ALLOC_RUNS_ALL and PA_TRANSACTION_XFACE_CONTROL — Track the concurrent request run and interface control records that PROCESS_FAILED_RUN and AFTERREPORT use to update run status and clean up failed interface batches.
• PA_PROJECTS_ALL — Resolves project number parameters (P_FROM_PROJ_NUM, P_TO_PROJ_NUM) to project identifiers (P_FROM_PROJECT_ID, P_TO_PROJECT_ID).
• PA_TRANSACTION_INTERFACE and PA_TRANSACTION_SOURCES — Supply the transaction interface rows and their source definitions reported by the concurrent program.

Usage Notes

PA_PACCINTG_XMLP_PKG is invoked exclusively through its associated concurrent program and XML Publisher report definition; it is not an independent API and is referenced by no other packages (per the documented "Referenced by 0 other packages" attribute). The framework binds the public global variables (P_CONC_REQUEST_ID, P_RUN_ID, mode flags such as P_MODE, P_DEBUG_MODE, P_AUTO_RELEASE, and P_STORE_SRC_DET) from the concurrent program's parameters. Custom code should avoid calling the internal report units directly, as they depend on report-framework state; instead, organizations extending cost integration reports should clone the report definition or overlay the package rather than modify it in place. Because the package is AUTHID CURRENT_USER and queries APPS synonyms, responsibility and MOAC (multi-org) security context must be established by the invoking concurrent program before execution.