Search Results c_date_format

Overview

The PL/SQL package body APPS.IGI_IGIRTAUD_XMLP_PKG supports the Oracle E-Business Suite report commonly identified as the Internal Controls (IGI) audit-related XML Publisher concurrent program. In the Oracle EBS 12.1.1 and 12.2.2 releases, packages bearing the _XMLP_PKG suffix act as the server-side program unit that the XML Publisher (BI Publisher) engine invokes at report execution time. This package provides the mandatory BEFOREREPORT and AFTERREPORT handlers that initialize the runtime environment before the report data model runs and release resources afterward. The package belongs to the IGI (International Governmental/Public Sector) product family owned by APPS and is classified as an "OTHER" API, meaning it is not a public, supported extension point but rather an internal component consumed by the concurrent manager. Its distinctive feature is the handling of date parameters through the C_DATE_FORMAT conversion variable, which converts the character date parameters supplied by the concurrent program into Oracle DATE values for use in the report query.

Key Procedures and Functions

• BEFOREREPORT — The initialization function, returning a BOOLEAN success flag. It captures the concurrent request identifier via FND_GLOBAL.CONC_REQUEST_ID into P_CONC_REQUEST_ID, assigns the literal 'DD-MON-YYYY' to the local C_DATE_FORMAT variable, and converts the incoming character parameters P_DATE_LOW and P_DATE_HIGH into the DATE variables CP_DATE_LOW and CP_DATE_HIGH. The function then verifies that the Internal Controls feature is installed using IGI_GEN.IS_REQ_INSTALLED('INS'). If the feature is not installed it raises the message IGI_INS_IS_DISABLED and returns FALSE; otherwise it returns TRUE. A WHEN OTHERS exception handler returns FALSE on any error.
• AFTERREPORT — The teardown function, also returning a BOOLEAN. It performs the standard post-report cleanup, historically via the SRW.USER_EXIT('FND SRWEXIT') call (now commented out in the extracted source) and returns TRUE, with an exception handler returning FALSE on failure.

Tables Accessed

The documented metadata lists no direct table references issued through APPS synonyms. The package operates purely on PL/SQL package variables, global application context (through FND_GLOBAL), and message lookup calls. Data retrieval is delegated to the report's declarative query, not to this program unit. Consequently, no INSERT, UPDATE, DELETE, or SELECT statements against application tables are attributed to this package.

Usage Notes

This package is invoked indirectly by the concurrent manager when the associated XML Publisher report is submitted. The user-facing parameters P_DATE_LOW and P_DATE_HIGH are entered on the concurrent program submission form as text, and the C_DATE_FORMAT variable controls how they are interpreted — originally ISO-style DD-MON-YYYY. This is significant for developers because changing the format string would alter how operators must type the date range. The package is not called from Oracle Forms or custom code; the SRW references appearing as comments confirm the report was migrated from an older Oracle Reports (SRW) implementation to the XML Publisher engine while preserving the SRW init/exit hooks as no-ops. Because the final line in the extracted source closes with END IGI_IGIRTAUD_XMLP_PKG while the header shows additional nested declarations, the excerpt is a partial view of the full package body. No other APPS packages reference this unit, confirming it is a leaf-level, report-specific component. Administrators troubleshooting the report should verify that the 'INS' Internal Controls module is registered and that operators supply dates in the documented format.