Search Results p_all_rows

Overview

APPS.JL_JLCOFAAR_XMLP_PKG is a PL/SQL package body that acts as the report logic container for the Oracle E-Business Suite (EBS) Fixed Asset appraisal report associated with the JL (localizations) module. In Oracle EBS 12.1.1 and 12.2.2, packages bearing the _XMLP_PKG suffix are generated by Oracle Reports/XML Publisher to house the report-level PL/SQL constructs—report triggers (BeforeReport, AfterReport), formula columns, and user-defined parameter validation routines—that previously lived inside an Oracle Reports (.rdf) report definition. The JLCOFAAR report prints asset appraisal information and requires currency validation of the appraisal records before the report executes. This package encapsulates those business rules so the report can be published through the XML Publisher/BI Publisher concurrent program framework while preserving the original Reports PL/SQL behavior.

Key Procedures and Functions

• BEFOREREPORT — The canonical Oracle Reports BeforeReport trigger. It orchestrates report setup: it calls CURRENCY_VALIDATION and GET_BASE_CURR_DATA, then returns TRUE to allow report execution to continue.
• GET_BASE_CURR_DATA — Loads base report data, principally the company name from FA_SYSTEM_CONTROLS into the C_COMPANY_NAME package variable, and derives the C_STATUS filter string based on the P_ALL_ROWS parameter. It also sets the default P_MIN_PRECISION value.
• AFTERREPORT — The AfterReport trigger. It performs no substantive work but retains the exception handler that raises a program abort condition if an unexpected error occurs at report completion.
• RAISE_ORA_ERR / RAISE_ERR — Error-handling procedures that load a message name from the JL message dictionary via FND_MESSAGE.SET_NAME and FND_MESSAGE.GET, then raise an application error to abort the report with an appropriate message.
• CURRENCY_VALIDATION — Declares a cursor over JL_CO_FA_APPRAISALS to select the distinct currency codes associated with the appraisal identified by P_APPRAISAL_ID. It provides the validation basis for the report's currency handling.
• CF_1FORMULA, CF_2FORMULA, CF_3FORMULA — Oracle Reports formula columns carried into the package. These compute derived display values used within the report layout.
• C_COMPANY_NAME_P, C_STATUS_P, CP_VALID_CURR_CODE_P — Accessor functions that expose package-level state to the report engine. C_COMPANY_NAME_P returns the company name, C_STATUS_P returns the status filter clause, and CP_VALID_CURR_CODE_P returns the validated currency code that corresponds to the user's search term "cp_valid_curr_code." This is the documented mechanism by which the report references the validated currency.

Tables Accessed

• FA_SYSTEM_CONTROLS — Read in GET_BASE_CURR_DATA to retrieve the company name (FS.COMPANY_NAME) for header display.
• FND_CURRENCIES — Referenced in currency validation logic to confirm that the appraisal currency codes are defined and enabled within the application currency repository.
• JL_CO_FA_APPRAISALS — The principal appraisal table; CURRENCY_VALIDATION selects DISTINCT CURRENCY_CODE from it filtered by APPRAISAL_ID.
• JL_CO_FA_ASSET_APPRS — The asset appraisal detail table supplying report rows; the C_STATUS filter references its status column to exclude voided or posted appraisals.

Usage Notes

JL_JLCOFAAR_XMLP_PKG is invoked automatically by the XML Publisher report engine when the JLCOFAAR report is submitted as a concurrent program from the Fixed Assets or localizations responsibility. It is not a general-purpose API: the ETRM metadata records zero packages referencing it, so custom code should not call its procedures directly. The report parameter P_APPRAISAL_ID drives currency validation, while P_ALL_ROWS controls whether all appraisal rows or only active ones are printed. Because the package is regenerated whenever the underlying report definition is reuploaded, modifications should be applied to the source report definition rather than patched into the package body.