Results for “p_flexdata”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_IGIPSIAP_XMLP_PKG is an Oracle E-Business Suite package body owned by the APPS schema. It supports the Oracle Grants/IGI "SIA" (Sponsored Projects/Institutional Accounting) reporting framework, specifically the XML Publisher concurrent report identified by the IGIPSIAP module prefix. The package encapsulates the report-level PL/SQL logic that Oracle Reports and BI Publisher concurrent programs require: initialization of the report session, resolution of the "flexfield" (key flexfield accounting segment) range entered by the user, construction of dynamic WHERE clauses used by the report's data query, validation that the SIA product is actually installed, and a clean shutdown sequence after output generation.

The object is classified under ETRM as OTHER, meaning it is not a public API and is intended for internal use by the concurrent report and its associated XML Publisher data template. The search term "p_flexdata" reflects the historical parameter naming used in this report family. The excerpt shows that the original P_FLEXDATA / P_FLEXDATA_TO parameters were superseded by P_FLEXFIELD_FROM and P_FLEXFIELD_TO, with the older CONV_FLEX_LOW / CONV_FLEX_HIGH calls commented out in favor of CONV_WHERE-based logic.

Key Procedures and Functions

• AFTERREPORT — The report teardown hook. It is where the FND SRWEXIT user exit historically ran to close the report session; in this version that call is disabled and the function simply returns TRUE to signal successful completion.
• BEFOREREPORT — The principal routine. It accepts the flexfield low and high range parameters (P_FLEXFIELD_FROM, P_FLEXFIELD_TO) as IN OUT NOCOPY values, initializes the report environment, derives the dynamic predicate fragments P_WHERE and P_WHERE1, and concatenates them into P_WHERES. It also queries the IGI_LOOKUPS description of the SIA lookup and calls IGI_GEN.IS_REQ_INSTALLED to confirm the SIA product is installed, raising IGI_GEN_PROD_NOT_INSTALLED through FND_MESSAGE/APP_EXCEPTION if it is not.
• CONV_FLEX_LOW — A conversion helper that transforms a flexfield range string into its "low" comparison form. It is documented in the package but its invocation is commented out in the current BEFOREREPORT body.
• CONV_WHERE1 — Companion helper used to build the "high" side of the flexfield range predicate. Together with CONV_WHERE (called for the low side) it produces the SQL fragment assigned to P_WHERES.

Tables Accessed

The package reads IGI_LOOKUPS, the IGI lookup repository, filtered on LOOKUP_TYPE = 'GCC_DESCRIPTION' and UPPER(LOOKUP_CODE) = 'SIA', to retrieve a human-readable DESCRIPTION for the SIA product. That description is then passed as the OPTION_NAME token into the IGI_GEN_PROD_NOT_INSTALLED message so the user sees which product is missing. No other base tables are documented as directly accessed by this package body; the substantive report data is fetched by the external report query that consumes the P_WHERES predicate assembled here.

Usage Notes

This package is invoked implicitly by the IGI Sponsored Projects / SIA XML Publisher concurrent program during the BeforeReport and AfterReport trigger phases. It is not intended for direct invocation by forms or custom code, and it is not referenced by any other packaged API according to ETRM. Because BEFOREREPORT raises APP_EXCEPTION when the SIA product is absent, the report fails fast with a localized FND_MESSAGE rather than producing an empty or misleading output. The commented-out SRW.MESSAGE and SRW.REFERENCE directives indicate the report migrated from a classic Oracle Reports 6i SRW environment to the XML Publisher runtime while retaining the original report trigger architecture. Developers extending this report should treat the P_FLEXFIELD_FROM/TO parameters as the supported flexfield range interface and avoid relying on the legacy P_FLEXDATA naming, which no longer drives the WHERE-clause construction.