Search Results p_ca_set_of_books_id

Overview

APPS.PA_PACRCIPF_XMLP_PKG is the generated PL/SQL package body that supports an Oracle Projects XML Publisher (BI Publisher) concurrent report. The package naming convention identifies it as a report package (XMLP_PKG) belonging to the Projects application (PA_), and the source header indicates it was authored in early 2008 under the original file PACRCIPFB.pls. Its principal role is to supply the runtime binding logic required by the report's data model: formatting the currency display, resolving lookup and reference values, populating report-level bind parameters, and constructing the dynamic WHERE clause used by the underlying report query.

The package is closely tied to Oracle Projects and General Ledger integration. Its most notable customization hook is the currency formatting formula, which reads the functional currency defined on a set of books. This establishes the direct relationship between the report and the report parameter "p_ca_set_of_books_id" — the user-specified set of books identifier that drives currency resolution and, by extension, the monetary presentation of the report output.

Key Procedures and Functions

• CF_FORMAT_MASKFORMULA — A character-returning formula function that queries GL_SETS_OF_BOOKS for the CURRENCY_CODE associated with the set of books identified by p_ca_set_of_books_id, then returns that currency code. This value acts as the format mask basis for currency columns displayed in the report.
• BEFOREREPORT — The pre-report trigger function. It retrieves the "NO_DATA_FOUND" message text from PA_LOOKUPS, conditionally enables debug behavior based on p_debug_mode, and resolves derived parameters such as the project number (from PA_PROJECTS_ALL) when p_project_id is supplied and the project organization name (from HR_ALL_ORGANIZATION_UNITS_TL) when p_project_org is supplied. It returns TRUE on success and handles exceptions by raising a generic application error.
• AFTERREPORT — The post-report trigger. In this body it performs no substantive work (the legacy SRW exit call is commented out) and serves as the report completion stub.
• AFTERPFORM — A parameter form post-processing hook, invoked after the report parameter form is submitted, typically used to populate dependent parameters.
• C_WHERE_P — A character-returning function that supplies the dynamically constructed WHERE clause applied to the report's main query.
• CP_1_P — A character-returning accessor for the CP_1 package variable, exposing a resolved report value to the data model.
• CP_PROJ_ORG_NAME_P — A character-returning accessor returning the CP_PROJ_ORG_NAME package variable, populated in BEFOREREPORT from HR_ALL_ORGANIZATION_UNITS_TL.
• CP_NO_DATA_FOUND_P — A character-returning accessor returning the CP_NO_DATA_FOUND package variable, populated in BEFOREREPORT from PA_LOOKUPS.

Tables Accessed

• GL_SETS_OF_BOOKS — Read by CF_FORMAT_MASKFORMULA to resolve CURRENCY_CODE from p_ca_set_of_books_id. This is the primary link between the search term and the package.
• PA_PROJECTS_ALL — Read by BEFOREREPORT to derive SEGMENT1 (the project number) from p_project_id.
• HR_ALL_ORGANIZATION_UNITS_TL — Read by BEFOREREPORT to resolve the translated organization NAME for p_project_org, filtered by the session language.
• PA_LOOKUPS — Read by BEFOREREPORT to fetch the NO_DATA_FOUND message meaning.
• FA_DEPRN_PERIODS — Listed among referenced tables via APPS synonyms, supporting period-related logic in the report data model.

Usage Notes

This package is not invoked directly by application forms. It is executed by the Oracle EBS concurrent manager when the associated XML Publisher report is run, with the report engine calling BEFOREREPORT before query execution and AFTERREPORT on completion. The p_ca_set_of_books_id parameter is supplied by the user at submission time and is central to currency formatting; callers must therefore ensure it resolves to a valid, accessible set of books or the format mask formula will raise NO_DATA_FOUND. Custom code should not call these procedures independently, as their signatures are regenerated and may change on patch application.