Search Results lp_currency_code

Overview

IGI_IGIGITSR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and registered in ETRM under the API classification OTHER. It is an auto-generated XML Publisher (BI Publisher) report package produced by Oracle Reports-to-XML conversion, as indicated by the _XMLP_PKG suffix and the $Header line referencing source file IGIGITSRS.pls. The package supports the concurrent program bearing the same base name (IGIGITSR), which is associated with the Oracle Grants/IGI (International Governmental/Institutional) product family. Its business purpose is to provide the server-side PL/SQL layer that supplies parameters, computed formula values, and repeated-group data to an XML Publisher report template at runtime. The package is not a general-purpose API; it is tightly coupled to a single report definition and is regenerated whenever the underlying Oracle Report source is modified.

Key Procedures and Functions

The package exposes five documented procedures and functions, all of which follow the standard XML Publisher report package pattern.

• BEFOREREPORT — Executed once at the start of report execution, before any data is fetched. It is used to initialize package-level state, resolve profile options, and prepare the runtime environment for the report query.
• AFTERREPORT — Executed once after the report data has been processed. It is typically used to perform cleanup, release resources, and finalize any report-level global values.
• CF_DATA_FOUNDFORMULA — A column formula function that determines whether data exists for a given report row, taking a line number as its input. It returns a numeric indicator used by the report layout to conditionally render sections or display a "no data found" message.
• RP_DATA_FOUND_P — A getter function that returns the value of the package-level RP_DATA_FOUND variable to the report layout, indicating whether the report query returned any records.
• RP_REPORT_TITLE_P — A getter function that returns the package-level RP_REPORT_TITLE variable, supplying the dynamically determined report title to the XML template.

The package also declares public variables including P_CONC_REQUEST_ID, P_RUN_AOL, P_DEBUG_SWITCH, P_SET_OF_BOOKS_ID, P_PERIOD_FROM, P_PERIOD_TO, P_CHARGE_CENTER, and LP_CURRENCY_CODE, which hold concurrent request context and report parameter values.

Tables Accessed

ETRM documents two referenced tables, both accessed through APPS synonyms:

• FND_CONCURRENT_PROGRAMS_TL — The concurrent program definitions table, queried to retrieve the translated program name and description for the report title and header information.
• FND_CONCURRENT_REQUESTS — The concurrent requests table, queried to resolve the current request identifier, request parameters, and execution context associated with P_CONC_REQUEST_ID.

These accesses are read-only metadata lookups supporting report execution context; the package does not write to these tables.

Usage Notes

IGI_IGIGITSR_XMLP_PKG is invoked exclusively by the Oracle EBS concurrent manager when the associated XML Publisher concurrent program is submitted. It is not referenced by any other PL/SQL package (documented as referenced by 0 packages), and it is not intended for direct invocation from forms or custom code. Because the package is auto-generated, customizations should be applied to the underlying report definition or template rather than to the package body, as regeneration will overwrite manual edits. It is available in both EBS 12.1.1 and 12.2.2; the documented $Header line confirms the source file was last shipped at version 120.0.12010000.1. Administrators troubleshooting report output should verify concurrent program registration and template assignment rather than modifying package logic.