Search Results f_date_enabled1formattrigger

Overview

IGI_IGISLSST_XMLP_PKG is an Oracle Application Object Library (AOL) generated report package belonging to the APPS schema within Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is owned by the APPS schema and classified under the ETRM as an API of type OTHER, reflecting its role as a supporting program unit for an Oracle Reports or BI Publisher based concurrent program rather than as a public integration interface. The package encapsulates the server-side PL/SQL logic that drives the IGISLSST report, which resides in the IGI (Oracle iLearning / product-suite) namespace. The embedded header comment referencing IGISLSSTS.pls and the 2008 application developer release indicates the package has been preserved unchanged across release upgrades.

Packages of this class are not intended for direct invocation by external consumers. They are bound to a report definition through Oracle Reports trigger and formula constructs, and they provide the data query, formatting, and lifecycle hooks that the runtime engine calls during execution. The parameters declared at package scope, including P_OWNER, P_OWNER_T, P_TABLE_NAME, P_TABLE_NAME_T, P_CONC_REQUEST_ID, and CP_OWNER, operate as persistent variable slots that carry report parameters and derived values across the report execution cycle.

Key Procedures and Functions

The documented program units within this package are:

• BEFOREREPORT — A Boolean-returning function executed automatically before the report body is processed. It performs initialization of package state and report-level parameters. A return value of TRUE allows the report to continue.
• AFTERREPORT — A Boolean-returning function executed after the report completes, used for cleanup and final processing of report-level state.
• CF_1FORMULA — A numeric-returning formula function that accepts an OWNER argument. Functions named with the CF_ prefix are generated by Oracle Reports to back a formula column; this one computes a derived numeric value for the report output based on the supplied OWNER.
• CP_OWNER_P — A string-returning function that exposes the value of the CP_OWNER package variable, supplying the report with the current owner context.
• F_DATE_ENABLED1FORMATTRIGGER — A string-returning format-trigger function that accepts six DATE parameters: DATE_DISABLED2, DATE_ENABLED2, DATE_REMOVED2, DATE_DISABLED_AU, DATE_ENABLED_AU, and DATE_REMOVED_AU. It returns the display string used for the report's DATE_ENABLED1 field. The presence of an _AU suffix suggests audit-column variants of the enabled, disabled, and removed dates, and the logic evaluates these inputs to produce a conditional, formatted presentation of the date field.

Tables Accessed

The ETRM metadata for this package records no referenced tables through APPS synonyms. This is typical of generated XML Publisher or Oracle Reports PL/SQL packages, where the data retrieval is defined in the report's query rather than in the PL/SQL package. The package's scope variables P_TABLE_NAME and P_TABLE_NAME_T indicate that a target table name is resolved and passed at runtime, and the report itself reads from the underlying IGI schema objects. Because the metadata lists no documented dependencies, the authoritative source for the actual table references is the report definition associated with IGISLSST.

Usage Notes

IGI_IGISLSST_XMLP_PKG is invoked exclusively by the Oracle Reports or BI Publisher runtime engine when the associated IGISLSST concurrent program is submitted from the Standard Concurrent Programs form or via the concurrent manager. The report engine calls BEFOREREPORT when execution begins, CF_1FORMULA and F_DATE_ENABLED1FORMATTRIGGER during data rendering, and AFTERREPORT at completion. The value P_CONC_REQUEST_ID is populated from the FND_CONCURRENT_REQUESTS context, and CP_OWNER is derived from the OWNER parameter or session. External packages do not reference this package, so it should not be called from custom code. The user query term f_date_enabled1formattrigger corresponds to the format-trigger function described above and is best understood as a generated artifact tied to the DATE_ENABLED1 field of the IGISLSST report layout.