Search Results c_where_p

Overview

APPS.PA_PACRCIPF_XMLP_PKG is a report-generator support package in Oracle EBS Projects (Oracle Projects) that backs the Capitalized Interest Project/PACRCIPF concurrent report. Its identifier follows the naming convention used by Oracle Reports XML Publisher (BI Publisher) report definitions in Release 12, where a report's PL/SQL library is packaged as a <REPORT_CODE>_XMLP_PKG with an associated specification and body. The suffix "XMLP" indicates the report was migrated to the XML Publisher engine typical of 12.1.1 and 12.2.2.

Functionally, the package concerns capitalized interest processing for capital projects. Capitalized interest represents the borrowing cost that a project may capitalize on assets under construction. The report exposes parameters such as period range (P_FROM_PERIOD, P_TO_PERIOD), project type and number, project organization, class category and class code, capital event identifier, chart of accounts, set of books, and an MRC set-of-books type. These parameters drive extraction of capitalizable cost and depreciation-period data against the specified project and ledger criteria.

The package holds shared package-level state used by the report's formula columns and data model. The variable C_WHERE is initialized to the tautology ''1''=''1'', a common pattern for a dynamically-assembled WHERE clause fragment built at runtime on the basis of user parameter selections. This is directly relevant to the search term "c_where_p": the token corresponds to the function C_WHERE_p, the package's public accessor for the C_WHERE value, and also to the internal C_WHERE variable itself.

Key Procedures and Functions

• CF_FORMAT_MASKFORMULA — a report formula function that computes a format mask, typically a numeric or date display pattern used by the report layout.
• BeforeReport — the standard report trigger fired before the report's data queries execute; used to initialize package state and validation.
• AfterReport — the standard report trigger fired after report output completes, used for post-processing and cleanup.
• AfterPForm — the standard report trigger executed after the parameter form is accepted; used to derive dependent parameters or defaults.
• C_WHERE_p — public accessor returning the varchsr2 value of C_WHERE, the dynamic WHERE-clause fragment controlled by the report's parameter selections.
• CP_1_p — public accessor for the numeric package variable CP_1, a derived control value.
• CP_PROJ_ORG_NAME_p — public accessor returning the project organization name, resolved from HR organization data for display on the report.
• CP_NO_DATA_FOUND_p — public accessor returning a message string used to signal that no qualifying data was located.

Tables Accessed

• FA_DEPRN_PERIODS — the depreciation period calendar used to validate or bound the period range applied against capitalized interest calculations.
• HR_ALL_ORGANIZATION_UNITS_TL — the translated organization name table, used to resolve the project organization name displayed by the report.
• PA_PROJECTS_ALL — the primary Oracle Projects project table, from which project number, type, organization, and related attributes are retrieved for the report criteria and output.

Usage Notes

This package is not an application programming interface and is classified as OTHER. It is invoked indirectly when the associated concurrent program or report definition is run from the Projects responsibility, or through standard report submission using FND_REQUEST.SUBMIT_REQUEST. The parameter form supplies the values mapped to the package globals; the report triggers (BeforeReport, AfterPForm, AfterReport) then initialize and finalize state. Custom code should not call these functions directly, as their signatures and semantics are tied to the report definition and are subject to change between releases. The package references no other packages and is referenced by none, confirming its role as a leaf-level report artifact.