Search Results f_gprc_dt_enabled_au1formattri




Overview
Explore in AI Chat

Overview

IGI_IGISLSSA_XMLP_PKG is an Oracle Application Object Library PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an OTHER API. The name follows the standard XML Publisher (XMLP) concurrent program support package convention used throughout Oracle E-Business Suite: the core identifier IGI_IGISLSSA identifies a report belonging to the IGI (Internal Controls Manager / Governance, Risk, and Compliance) product family, while the _XMLP_PKG suffix indicates that the package serves as the PL/SQL data definition and formatting layer for a BI Publisher report template.

The package's principal responsibility is to supply parameter values, derive display strings, and resolve before/after report logic for the IGISLSSA report. The three "SSA" report context variables — process name, group name, and table name — are managed both in their raw and translated forms, indicating that the report presents audit or security configuration data in a user-facing, locale-aware format. The presence of a concurrent request ID variable confirms that the package is intended for execution within a concurrent manager session.

Key Procedures and Functions

  • AFTERREPORT — Boolean function invoked by the XML Publisher engine after the report data model completes; used for post-report housekeeping or final flag setting.
  • BEFOREREPORT — Boolean function invoked before the report runs; used to initialize variables and prepare session context.
  • CF_1FORMULA — Group-for-table name formula; accepts a group/table name argument and returns a numeric value, typically a formatting or lookup result for the report column.
  • CF_2FORMULA — Group-for-process name formula; parallel logic for the process dimension.
  • CF_3FORMULA — Process-for-table name formula; resolves the process associated with a table entry.
  • CP_GRP_NAME_P — Returns the group name parameter value as VARCHAR2.
  • CP_PRC_NAME_P — Returns the process name parameter value as VARCHAR2.
  • CP_TAB_NAME_P — Returns the table name parameter value as VARCHAR2.
  • F_GTAB_DT_ENABLED_AU1FORMATTRI — Formats the group/table enable, disable, and removal date attributes for display.
  • F_GPRC_DT_ENABLED_AU1FORMATTRI — Formats the group/process enable, disable, and removal date attributes for display.
  • F_PTAB_DT_ENABLED_AU1FORMATTRI — Formats the process/table enable, disable, and removal date attributes for display.

Tables Accessed

The ETRM metadata does not document any base tables referenced directly through APPS synonyms for this package. In practice, packages of this class rely on the report's underlying query, defined in the accompanying .rdf or data template, rather than embedding SQL in the package body. The package itself primarily manipulates the declared package-level variables (P_PROCESS_NAME, P_GROUP_NAME, P_TABLE_NAME and their _T counterparts, P_CONC_REQUEST_ID, CP_GRP_NAME, CP_PRC_NAME, CP_TAB_NAME) and computes formatted output strings from parameters passed into the formulas. Any table access would therefore be indirect, occurring through the report query or through the functions receiving data as IN parameters.

Usage Notes

IGI_IGISLSSA_XMLP_PKG is invoked automatically by the Oracle XML Publisher concurrent program runtime when the IGISLSSA report is submitted. The before/after report hooks and CF_* formulas are referenced from the report template's group and data model triggers rather than called directly by application code. The ETRM metadata records zero packages referencing this package, confirming that it is not a shared utility API; customizations should avoid direct calls and instead extend the report definition. When troubleshooting, the most commonly searched identifier is p_process_name_t, the translated process name variable used to pass locale-specific process labels into the report output.