Search Results cp_valid_curr_code_p

Overview

JL_JLCOFAAR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM API taxonomy as OTHER. The package name follows the standard Oracle Reports XML Publisher (XMLP) integration convention, in which the suffix _XMLP_PKG designates the server-side PL/SQL library bound to an Oracle Report used simultaneously as a data source for an XML Publisher (BI Publisher) template. In this case the report family "JLCOFAAR" belongs to the Oracle Assets globalizations module (JL prefix), specifically the Company of Assets Appraisal Report. The package supplies report-level parameters, formatting formulas, and data validation logic consumed when the report is executed from the Concurrent Programs interface, Controllers, or the Oracle Assets responsibility.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, consistent with Oracle's standard security posture for report integration packages. It exposes twelve documented procedures and functions, several of which are wrapper getter functions generated automatically by Oracle Reports for report-level parameters (the _P naming convention).

Key Procedures and Functions

• BEFOREREPORT — Report-level pre-processing function invoked before the report query executes; initializes report state and default parameter values.
• AFTERREPORT — Post-report cleanup function executed after report output is produced.
• GET_BASE_CURR_DATA — Retrieves base currency data from the system, populating report globals such as company name and currency status.
• RAISE_ORA_ERR — Raises an Oracle error using a named message, typically sourced from the FND message dictionary.
• RAISE_ERR — General-purpose error-raising procedure for report-level validation failures.
• CURRENCY_VALIDATION — Validates the currency code entered or defaulted for the report run.
• CF_1FORMULA — Report formula column returning a numeric value (for example a count or summary).
• CF_2FORMULA — Formula column accepting a status code and returning a numeric value.
• CF_3FORMULA — Formula column accepting a status description and returning a character value.
• C_COMPANY_NAME_P — Getter for the report global C_COMPANY_NAME.
• C_STATUS_P — Getter for the report global C_STATUS. This is the object the user searched for; it returns the VARCHAR2 report status string maintained by the package.
• CP_VALID_CURR_CODE_P — Getter for CP_VALID_CURR_CODE, the validated currency code flag.

The package also declares report-global variables including P_END_OF_REPORT, P_NO_DATA_FOUND, P_CONC_REQUEST_ID, P_APPRAISAL_ID, P_ALL_ROWS, and P_MIN_PRECISION (defaulted to 2).

Tables Accessed

• FA_SYSTEM_CONTROLS — Read for Assets system setup, including the base currency used by GET_BASE_CURR_DATA.
• FND_CURRENCIES — Read to validate currency codes during CURRENCY_VALIDATION.
• JL_CO_FA_APPRAISALS — The primary appraisal header table for the Company of Assets globalization, driving report selection.
• JL_CO_FA_ASSET_APPRS — Appraisal detail lines joined to the header to produce report rows.

Usage Notes

JL_JLCOFAAR_XMLP_PKG is invoked only through the Oracle Reports runtime engine when the Company of Assets Appraisal Report concurrent program is submitted. Oracle Reports automatically calls BEFOREREPORT and AFTERREPORT, and the XML Publisher integration layer references the getter functions (including C_STATUS_P) and formula columns during template generation. The package is not referenced by any other PL/SQL package in the ETRM repository, confirming it is a terminal report-support library rather than a reusable API. Customizations should avoid modifying the package directly; instead, extensions should be implemented through XML Publisher template or data-definition changes to preserve upgrade integrity across EBS 12.1.1 and 12.2.2.