Search Results igi_igigbucc_xmlp_pkg

Overview

IGI_IGIGBUCC_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It is the generated support package for an Oracle Reports (XML Publisher / concurrent program) executable associated with the IGI (Intellectual Property / Government, Education and Healthcare, formerly "IGI") product family — specifically the "BUCC" (Budgetary Control / Commitment Control) report. Its purpose is to supply the runtime bind parameters, SELECT and WHERE fragments, and helper formulas required by the underlying RDF/XML report, and to provide before/after trigger logic that the Reports engine invokes at report execution time. The package does not contain general business logic; it is a thin database-side shell that exposes report parameters and formats the flexfield concatenation used to display accounting code combinations.

Key Procedures and Functions

• BEFOREREPORT — Boolean function invoked automatically before the report body runs. It performs pre-execution setup such as deriving parameter defaults and initialising the shared package globals (for example the concatenated flexfield SELECT string and the WHERE clause).
• AFTERREPORT — Boolean function invoked after report completion. It handles post-processing/cleanup and returns control status to the Reports engine.
• CF_UPDATEFORMULA — Formula column helper taking a code combination identifier, used to resolve/refresh a derived column value during report formatting.
• CF_NO_DATA_FOUNDFORMULA — Formula column helper that evaluates a "no data found" indicator and converts it to the numeric result expected by the report layout.
• CP_SELECT_ALL_P — Returns the CP_SELECT_ALL string, the concatenation of SEGMENT1 through SEGMENT30 joined by hyphens to render the full accounting flexfield.
• CP_WHERE_FLEX_P — Returns the CP_WHERE_FLEX string, the flexfield filter applied to the report query (defaulting to a SEGMENT3 range).
• CP_NO_DATA_FOUND_P — Returns the CP_NO_DATA_FOUND flag, allowing the report to branch when the query returns no rows.

The package also exposes public variables including P_MIN_FLEX and P_MAX_FLEX (1000 characters each). P_MAX_FLEX is the upper bound of the accounting flexfield range passed by the concurrent program; together with P_MIN_FLEX it constrains the code combination selection. Additional globals include P_SET_OF_BOOKS_ID, P_CONC_REQUEST_ID, P_COA_ID, P_DEBUG_SWITCH and P_RUN_AOL.

Tables Accessed

The only documented table reference is GL_CODE_COMBINATIONS (accessed through the APPS synonym). This table supplies the SEGMENT1–SEGMENT30 columns concatenated in CP_SELECT_ALL and used to evaluate the CP_WHERE_FLEX predicate, and it provides the code combination identifiers passed to CF_UPDATEFORMULA. Given the report parameters P_SET_OF_BOOKS_ID and P_COA_ID, the package effectively filters code combinations to a specific ledger and chart of accounts.

Usage Notes

This package is not intended for direct invocation by application code; it is referenced by the concurrent program definition that runs the IGI budgetary control report. Users launch it from the Submit Request screen, supplying P_MIN_FLEX/P_MAX_FLEX, ledger and chart of accounts parameters. Because the package uses AUTHID CURRENT_USER, it executes with the privileges of the calling schema. Customisations should avoid modifying the package directly, since it is regenerated from the report source and carries a header indicating an APPLDEV-shipped version; extensions are better implemented by wrapping the concurrent program or by substituting a custom copy. No other packages reference it.