Search Results cp_grp_name_p

Overview

IGI_IGISLSTL_XMLP_PKG is an Oracle E-Business Suite XML Publisher (BI Publisher) report package owned by the APPS schema. Its name follows the standard XMLP report package convention, indicating that it supports the IGISLSTL report — an Oracle Grants/IGI (Intellectual Property, Grants and Financial Aid) listing report, most likely a security group or table listing extract. The package body provides the server-side PL/SQL logic required by the XML Publisher report definition: initializing global parameters before the report runs, finalizing after execution, populating a computed report column, and exposing that column value through a public accessor.

The package is classified as OTHER in the ETRM metadata, and its header comment ($Header: IGISLSTLB.pls 120.0.12010000.1 2008/07/29) confirms it originates from the R12 code line. The body is deliberately minimal — it contains no business rules beyond parameter defaulting and a single column formula — reflecting the standard structure of generated XMLP report packages in Release 12.1.1 and 12.2.2.

Key Procedures and Functions

The package comprises four documented program units:

• BEFOREREPORT — Fires prior to report execution. It captures the concurrent request ID from FND_GLOBAL.CONC_REQUEST_ID and applies NVL-based wildcard defaulting ("%") to the security group and table name parameters so that omitted report parameters are interpreted as "match all". This is the standard initialization entry point invoked by the XML Publisher engine.
• AFTERREPORT — Executes after the report completes. In this package it simply returns TRUE; no post-processing cleanup or audit logic is performed.
• CF_1FORMULA — A computed-column formula function that receives the SLS_SECURITY_GROUP value from the report query, assigns it to the package-level variable CP_GRP_NAME, and returns 1. The parameter is echoed into the report layout via this global variable.
• CP_GRP_NAME_P — A public accessor function that returns the current value of the CP_GRP_NAME package variable. This is the function the user searched for. It is named using the XML Publisher convention of appending "_P" to a package variable to create a callable getter, allowing the report template to reference the security group name without direct variable access.

Tables Accessed

No tables are referenced directly by this package body. All data retrieval for the report is performed by the report's SQL query (defined in the accompanying XML Publisher data model), not by the PL/SQL package. The package only manipulates parameter values and a local package variable. The ETRM metadata confirms that no APPS synonyms are referenced by this package, and it is not referenced by any other packages.

Usage Notes

IGI_IGISLSTL_XMLP_PKG is invoked exclusively by the Oracle XML Publisher runtime when the IGISLSTL concurrent program is submitted. BEFOREREPORT and AFTERREPORT are called automatically by the XMLP engine at the start and end of report execution respectively. CF_1FORMULA is called from the report's data template for the computed column that carries the security group name. CP_GRP_NAME_P is available for reference from the report layout, typically to display the security group selection in the report header.

The package contains no custom business logic beyond parameter defaulting; all substantive filtering is driven by the report SQL using the P_SECURITY_GROUP_T and P_TABLE_NAME_T wildcarded parameters. Because the package holds no persistent state and performs no DML, it carries no transaction or locking considerations. Customizations should be applied to the report data model and template rather than to this package body.