Search Results cp_ret_sts

Overview

APPS.PA_PACCINTG_XMLP_PKG is the packaged body behind the Oracle Projects concurrent program that reconciles and reports on the Project Accounting transaction interface, the staging area through which unposted expenditures, usage, and miscellaneous transactions are collected before being cost-distributed and transferred into GL. The package drives the XML Publisher report "PA_PACCINTG" (Project Accounting Interface Validation / AutoAccounting Integration listing). It executes in the standard Oracle Reports and concurrent manager context, resolving request-level parameters such as P_MODE, P_AUTO_RELEASE, P_STORE_SRC_DET, P_FROM_PROJECT_ID, P_TO_PROJECT_ID, and P_EXP_ITEM_DATE at runtime.

The name PA_PACCINTG reflects the integration between PA transaction interface processing and AutoAccounting rules, allowing users to review interface rows, the transaction sources from which they originated, and the period and implementation context in which they were loaded. It is a report-oriented package, classified as OTHER in the ETRM directory, and it is not referenced by any other package in the application, indicating it is a terminal reporting component rather than a shared utility.

Key Procedures and Functions

• BEFOREREPORT — The primary initialization routine. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, defaults P_MODE to 'G' and P_AUTO_RELEASE and P_STORE_SRC_DET to 'N' when null, reads the PA_DEBUG_MODE profile option and enables SQL_TRACE when set to 'Y', calls PA_ALLOC_RUN.INIT_WHO_COLS, and resolves project numbers and the period end date for the reporting window. This is the routine most relevant to the user's search term "p_auto_release," since the defaulting logic for that parameter lives here.
• GET_COMPANY_NAME — Retrieves the operating unit / company name used as the report header, returning a boolean success indicator consumed by BEFOREREPORT.
• PROCESS_FAILED_RUN — Handles the failure path, logging or trapping errors when report initialization or execution does not complete successfully.
• AFTERREPORT — Post-report cleanup routine, invoked after the report body completes.
• CF_FORMAT_MASKFORMULA — A format trigger returning the mask string applied to a report field (typically the project number or masked identifier).
• C_COMPANY_NAME_P — A function returning the company name value to the XML template.
• CP_RET_STS_P — A function returning the CP_RET_STS status variable, which is initialized to 'S' in BEFOREREPORT.

Tables Accessed

• PA_PROJECTS_ALL — Sourced to derive SEGMENT1 (the project number) for both P_FROM_PROJECT_ID and P_TO_PROJECT_ID.
• PA_IMPLEMENTATIONS and GL_PERIOD_STATUSES — Joined to determine the default period end date (P_EXP_ITEM_DATE) when the user does not supply one.
• PA_TRANSACTION_INTERFACE and PA_TRANSACTION_XFACE_CONTROL — The interface staging and control tables that form the central data source of the report.
• PA_TRANSACTION_SOURCES — Supplies source-name descriptions, gated by P_STORE_SRC_DET.
• PA_ALLOC_RUNS_ALL — Consulted in the context of allocation run processing that flows into the interface.

Usage Notes

The package is invoked exclusively through the "PA_PACCINTG" concurrent program and its associated Oracle Reports / XML Publisher definition. It is not called from Oracle Forms or from other PL/SQL APIs. In Oracle EBS 12.1.1 and 12.2.2 it runs under the APPS schema with the standard FND SRWINIT-equivalent initialization now handled natively inside BEFOREREPORT. Parameters such as p_auto_release default to 'N' when omitted, so submissions relying on that flag must supply it explicitly when auto-release behavior is required. Administrators debugging report behavior can set the PA_DEBUG_MODE profile option to 'Y' to enable SQL trace for the session.