Search Results cp_sec_name_p




Overview
Explore in AI Chat

Overview

IGI_IGISLSSG_XMLP_PKG is an Oracle E-Business Suite XML Publisher (XMLP) report package body owned by the APPS schema. It belongs to the IGI (Oracle Grants/Contracts and Public Sector) product family and supports the generation of a styled report output. The package follows the standard Oracle Reports-to-XML Publisher conversion pattern in which the original Oracle Reports trigger logic is preserved in a PL/SQL package whose functions are called during report execution. In EBS 12.1.1 and 12.2.2, such packages are registered as the report's PL/SQL body and are invoked by the concurrent processing engine through FND_GLOBAL request context initialization.

The source header indicates the file is IGISLSSGB.pls, version 120.0.12010000.1, last checked in on 2008/07/29, consistent with the R12 release cycle. The package is classified as OTHER in the ETRM metadata, meaning it is a supporting report package rather than a public API with a formal interface contract.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

  • BEFOREREPORT — Initializes package state at report start. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID and applies NVL defaults ('%') to the P_GROUP_TYPE and P_GROUP_NAME parameters so that missing bind values are treated as wildcards.
  • AFTERREPORT — Post-report cleanup hook. In this implementation it performs no action and simply returns TRUE.
  • CF_2FORMULA — A report formula column trigger accepting a section name parameter. It stores the passed value in the package variable CP_SEC_NAME and returns 1, allowing the report layout to reference the section name.
  • CF_1FORMULA — The parallel formula trigger for process names. It assigns the incoming procedure name to CP_PRC_NAME and returns 1.
  • CP_PRC_NAME_P — Accessor function returning the value of the CP_PRC_NAME package variable for use elsewhere in the report.
  • CP_SEC_NAME_P — Accessor function returning the value of the CP_SEC_NAME package variable.
  • F_DATE_ENABLED1FORMATTRIGGER — Format trigger for the section date columns. It compares enabled, disabled, and removed date values against their corresponding _AU (audit) values, treating NULLs as SYSDATE. It returns 'N' when all three pairs match and 'Y' otherwise, controlling conditional display of changed records.
  • F_PRC_DT_ENABLED_AU1FORMATTRIG — The equivalent format trigger for process date columns, applying the same comparison logic across PROC_DT_ENABLED, PROC_DT_DISABLED, and PROC_DT_REMOVED versus their audit counterparts.

Tables Accessed

The ETRM metadata records no table references for this package, either directly or through APPS synonyms. This is consistent with the exposed source, which performs only parameter initialization and date-comparison logic without issuing any SQL. All data retrieval for the underlying report is handled by the report's data model and its associated SQL query, not by this package body.

Usage Notes

This package is not an application programming interface. It is invoked exclusively by the Oracle Reports/XML Publisher runtime during execution of the associated IGI concurrent program. BEFOREREPORT and AFTERREPORT are called automatically around report generation; CF_1FORMULA and CF_2FORMULA are called from formula columns in the report layout; the two format-trigger functions are called as conditional display conditions for date fields; and the two _P accessor functions supply stored values to layout elements. The ETRM metadata records no packages referencing this object, confirming it has no downstream dependents. Customizations should avoid modifying this package directly, as it is a shipped, version-controlled object; the supported approach is to copy and extend the report definition under a custom application, or to register a custom package if the underlying query must be altered.