Search Results date_enabled2




Overview
Explore in AI Chat

Overview

IGI_IGISLSST_XMLP_PKG is a report-support package in the APPS schema belonging to the Oracle E-Business Suite 12.1.1 / 12.2.2 ETRM (E-Business Tax and related IGI) product family. The name pattern IGI_..._XMLP_PKG identifies it as the PL/SQL companion body generated for an Oracle XML Publisher (BI Publisher) concurrent report. The package encapsulates the server-side logic that a report definition invokes at runtime: it captures report parameters, normalizes optional input values, exposes computed return values back to the report layout, and supplies conditional formatting logic for the report's data model.

The package serves no standalone business transaction. Instead it is the procedural glue behind a listing report whose subject is tracked by the CP_OWNER value, as reflected in the user's search term. The body is intentionally small, containing only report-lifecycle entry points and one formatting trigger.

Key Procedures and Functions

  • BEFOREREPORT — Executes once before the report data model runs. It assigns the current concurrent request ID from FND_GLOBAL.CONC_REQUEST_ID to the packaged variable P_CONC_REQUEST_ID, and applies the NVL wildcard pattern '%' to the owner and table-name parameters. This converts null user input into a "match all" filter, which is essential because XML Publisher reports commonly pass blank parameters that would otherwise cause an empty result set.
  • AFTERREPORT — Executes after the report completes. In this version it contains only a null; statement and returns TRUE. It is present to satisfy the XML Publisher report interface contract and to provide a defined hook for post-processing, even though no post-processing logic is currently implemented.
  • CF_1FORMULA — A report formula function that accepts an OWNER value, assigns it to CP_OWNER, and returns the constant 1. This is the direct source of the CP_OWNER reference being sought: the report passes a row-level owner into this formula so that the current row's owner is retained in a package variable for later use by other formatting or output columns.
  • CP_OWNER_P — A getter function that returns the current value of CP_OWNER. It allows the report layout or a dependent column to read the most recently assigned owner without re-deriving it from the query.
  • F_DATE_ENABLED1FORMATTRIGGER — A conditional formatting trigger that compares six date values: the current values DATE_DISABLED2, DATE_ENABLED2, and DATE_REMOVED2 against their audit copies (DATE_DISABLED_AU, DATE_ENABLED_AU, DATE_REMOVED_AU). It initializes a local P_DATE to SYSDATE and uses NVL so that null dates compare as equal. When all three pairs match, it returns 'N'; otherwise it returns 'Y'. The result drives conditional highlighting of rows whose enable/disable/removal dates were changed after the audit baseline was captured.

Tables Accessed

The documented ETRM metadata records no directly referenced tables for this package. All date and owner values arrive as function arguments supplied by the report query, and the only external call is to the FND_GLOBAL API to obtain the concurrent request ID. Data retrieval is therefore handled by the XML Publisher data model rather than by hard-coded SQL inside this body.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is registered as the report-level PL/SQL package for an Oracle XML Publisher concurrent program and is executed by the Oracle Reports/XML Publisher runtime during submission. BEFOREREPORT and AFTERREPORT fire automatically at the start and end of each run; CF_1FORMULA and CP_OWNER_P are invoked from within the report layout to populate and expose the CP_OWNER value; and F_DATE_ENABLED1FORMATTRIGGER is called as a format trigger to control conditional display. The metadata confirms the package is referenced by zero other packages, underscoring its self-contained, report-specific role. When troubleshooting report output or searching source for CP_OWNER, this body is the authoritative location.