Search Results cp_report_name

Overview

APPS.CSI_CSIINVDR_XMLP_PKG is the generated PL/SQL package body that supports the Oracle EBS concurrent program "IB - INV Discrepancy Report" (Inventory Discrepancy Report). This report belongs to the CSI (Inventory) product family and is implemented as an Oracle Reports (XML Publisher / SRW-based) concurrent program. The package body is auto-generated by Oracle Reports when a report is registered as a concurrent program, and it implements the standard report trigger entry points (BEFOREREPORT and AFTERREPORT) together with user-defined report parameters required by the report layout. Its primary business function is to initialize the report runtime context, resolve the operating unit's ledger and the concurrent program name, expose those values to the report layout as bind parameters, and cleanly terminate the report execution context.

Key Procedures and Functions

• BEFOREREPORT — The "Before Report" trigger function. It sets P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID, then resolves CP_COMPANY_NAME from GL_SETS_OF_BOOKS (set of books id = 1) and CP_REPORT_NAME from the concurrent program name joined through FND_CONCURRENT_REQUESTS. On NO_DATA_FOUND for the report name it defaults to 'IB - INV Discrepancy Report'. Returns Boolean to signal whether the report should proceed.
• AFTERREPORT — The "After Report" trigger function. It performs the standard SRW exit (SRW.USER_EXIT('FND SRWEXIT')) cleanup and returns TRUE to indicate successful completion.
• CP_REPORT_NAME_P — A packaged function that returns the value of the CP_REPORT_NAME global, making the resolved concurrent program name available to the report definition for display in the report header.
• CP_COMPANY_NAME_P — A packaged function that returns the value of the CP_COMPANY_NAME global, exposing the ledger/company name for display in the report layout.

Notably, the user search term "cp_report_name_p" corresponds directly to the documented function CP_REPORT_NAME_P, which drives the report title displayed on the output.

Tables Accessed

• GL_SETS_OF_BOOKS — Read to obtain the ledger name (SOB.NAME) that is exposed via CP_COMPANY_NAME. The query uses a hardcoded SET_OF_BOOKS_ID = 1, a legacy pattern typical of older CSI reports.
• FND_CONCURRENT_REQUESTS (APPS synonym) — Read together with FND_CONCURRENT_PROGRAMS_VL to retrieve USER_CONCURRENT_PROGRAM_NAME for the current request id, populating CP_REPORT_NAME.
• FND_CONCURRENT_PROGRAMS_VL — Joined to the above to supply the human-readable program name.

Usage Notes

This package body is invoked automatically whenever the "IB - INV Discrepancy Report" concurrent program is executed; it is not intended for direct invocation from custom code. In Oracle EBS 12.1.1 and 12.2.2, the SRW-specific calls (FND SRWINIT, FND SRWEXIT, SRW.MESSAGE) have been commented out and replaced with NULL, reflecting the transition to XML Publisher-based reporting, where the standard Reports initialization/cleanup is handled by the BI Publisher engine rather than SRW built-ins. The ETRM metadata records no other packages referencing this object, and no inbound dependencies, confirming its role as a leaf-level report support package. No custom parameter lists should be assumed for the documented functions; their signatures are dictated by the Report Builder trigger convention.