Search Results rp_report_title




Overview
Explore in AI Chat

Overview

IGI_IGIGITSR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the OTHER API category. Its name follows the standard XML Publisher (XMLP) generated package convention, indicating that it is the auto-generated library produced when the concurrent program IGI_IGIGITSR (an Oracle Grants / IGI module report) was converted to an XML Publisher report definition. The suffix "XMLP_PKG" combined with the "BEFORE REPORT" and "AFTER REPORT" DML trigger functions confirms that the package implements the report-level triggers and formula columns required by the Oracle Reports to XML Publisher bridge.

The package is essentially a thin control layer. It does not perform grants accounting logic itself; instead it establishes session context for the concurrent request, resolves report title and ledger currency for the report layout, and exposes global state variables to the report's data model and template. This is the standard contract expected by the FND SRWINIT / FND SRWEXIT integration used by XML Publisher concurrent programs.

Key Procedures and Functions

  • BEFOREREPORT — The before-report trigger. When P_RUN_AOL is 'Y' it captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, populates LP_CURRENCY_CODE from GL_SETS_OF_BOOKS for the passed set of books, and resolves RP_REPORT_TITLE from FND_CONCURRENT_PROGRAMS_TL joined to FND_CONCURRENT_REQUESTS. It also honours the P_DEBUG_SWITCH diagnostic flag.
  • AFTERREPORT — The after-report trigger. It issues a ROLLBACK to ensure no uncommitted work persists, emits a debug message when P_DEBUG_SWITCH = 'Y', and invokes the FND SRWEXIT user exit when P_RUN_AOL = 'Y' to release the concurrent manager context.
  • CF_DATA_FOUNDFORMULA — A formula column function. It inspects a supplied line number (IT_LINE_NUM); when the value is NULL it sets the global RP_DATA_FOUND to 'N', otherwise to 'Y'. This drives the report's "no data found" branching logic in the XML template.
  • RP_DATA_FOUND_P — A PL/SQL function returning VARCHAR2 that simply returns the current value of the RP_DATA_FOUND global variable. This is the object referenced by the search term "rp_data_found_p" and acts as the accessor used by the report layout to test whether rows were returned.
  • RP_REPORT_TITLE_P — A PL/SQL function returning VARCHAR2 that exposes the RP_REPORT_TITLE global populated during BEFOREREPORT, allowing the XML template to print the concurrent program's translated name.

Tables Accessed

  • FND_CONCURRENT_PROGRAMS_TL — Read during BEFOREREPORT to retrieve the translated USER_CONCURRENT_PROGRAM_NAME for the running request, which becomes the report title. The LANGUAGE column is filtered against USERENV('LANG').
  • FND_CONCURRENT_REQUESTS — Read to identify the current concurrent request and to join back to the program definition using PROGRAM_APPLICATION_ID and CONCURRENT_PROGRAM_ID.
  • GL_SETS_OF_BOOKS — Referenced to resolve CURRENCY_CODE for the ledger identified by P_SET_OF_BOOKS_ID, supplying the functional currency used in report amounts.

Usage Notes

The package is invoked exclusively by the Oracle Reports/XML Publisher runtime for the IGI_IGIGITSR concurrent program. BEFOREREPORT and AFTERREPORT are called automatically at report execution boundaries; they are not intended for direct invocation from forms or custom code. The RP_DATA_FOUND_P and RP_REPORT_TITLE_P functions are referenced as data source columns within the report definition and by the XML template's conditional formatting, particularly for suppressing output sections when no rows are returned. Because the package is auto-generated and shipped under the $Header directive IGIGITSRB.pls, it should be treated as read-only and regenerated through the XML Publisher administrator interface rather than edited manually. No other packages in the EBS instance reference this package.