Results for “currency_code_p”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.JL_JLBRPICR_XMLP_PKG is the PL/SQL package body that supports the JL_BRPICR Oracle EBS report — a Brazilian localization (JL = Latin American/Brazil) report used for Accounts Payable interest and collection reporting. The "XMLP" suffix in the package name indicates this is the XML Publisher (Oracle BI Publisher) backing package associated with the concurrent program definition. In the Oracle EBS 12.1.1 and 12.2.2 architecture, report-specific PL/SQL packages are registered as the "executable" for concurrent programs and provide the pre-report and post-report logic that XML Publisher data templates and RTF layouts rely on for their parameters and output.

The package manages two report-level global values — the company (set of books) name header and the functional currency code — that are populated at runtime and exposed to the report layout via PL/SQL getter functions. It also performs cleanup of a temporary staging table after the report completes. The overall business purpose is to allow the Brazilian Payables Interest/Collection report (JL_BR_AP_INT_COLLECTION based processing) to display the correct company name and currency in its header section, and to purge temporary data linked to the current concurrent request's file control identifier.

Key Procedures and Functions

• BEFOREREPORT — Executed before the report layout renders. It captures the concurrent request ID into P_CONC_REQUEST_ID, queries GL_SETS_OF_BOOKS using P_SET_OF_BOOKS_ID to derive the set of books name (truncated to 30 characters) and the currency code, and assigns these to the package globals C_COMPANY_NAME_HEADER and CURRENCY_CODE. Errors are suppressed so report execution continues even if the set of books lookup fails.
• AFTERREPORT — Executed after the report completes. It deletes rows from the temporary table JL_BR_AP_INT_COLLECTION_TMP filtered by the P_FILE_CONTROL parameter, removing the staging data associated with the just-run request. Exceptions during the delete are silently handled to avoid disrupting report completion.
• C_COMPANY_NAME_HEADER_P — A getter function that returns the C_COMPANY_NAME_HEADER package global. This is the function referenced by the user's search term and is typically called from the report's XML/data template to place the company name in the report header.
• CURRENCY_CODE_P — A getter function returning the CURRENCY_CODE global so the report layout can display the set of books' functional currency.

Tables Accessed

• GL_SETS_OF_BOOKS — Read in BEFOREREPORT to obtain the set of books NAME and CURRENCY_CODE for the given P_SET_OF_BOOKS_ID. This drives the company header and currency displayed on the report output.
• JL_BR_AP_INT_COLLECTION_TMP — Accessed in AFTERREPORT, where rows matching the request's P_FILE_CONTROL value are deleted. This is the Brazilian localization temporary table that stages AP interest/collection data during report execution, and is cleared afterward to avoid stale data accumulation across concurrent requests.

Usage Notes

This package is invoked exclusively through the Oracle EBS Concurrent Manager as the PL/SQL executable registered against the JL_BRPICR concurrent program. It is not called directly by forms or custom code; the report's parameter form passes P_SET_OF_BOOKS_ID and P_FILE_CONTROL, and the XML Publisher engine calls BEFOREREPORT and AFTERREPORT at the appropriate lifecycle points. Because the package is designed for XML Publisher, replace any legacy SRW.USER_EXIT calls (commented out in the source) with the standard SRW SRWINIT/SRWEXIT equivalents only when running in character-mode Reports; XML Publisher execution does not require them. Function getters C_COMPANY_NAME_HEADER_P and CURRENCY_CODE_P are referenced from the data template or RTF layout to resolve header fields. No other packages reference this object, so changes should be limited to report-specific maintenance.