Search Results cp_select_all_p




Overview
Explore in AI Chat

Overview

IGI_IGIGBUCC_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the OTHER API category. Its name embeds the XMLP designator, confirming that it supports an Oracle XML Publisher (BI Publisher) concurrent report rather than a forms-based or general-purpose API. The IGI prefix associates the package with the public-sector and grants accounting modules delivered alongside Oracle Financials, and the surrounding naming convention (IGIGBUCC) points to a budget or code combination control report. The package implements the standard XML Publisher report lifecycle: a before-report hook, an after-report hook, several report-specific formula functions callable from the report template, and getter functions that expose package-level bind variables to the report data model.

Key Procedures and Functions

The package exposes seven documented program units, all functions.

  • BEFOREREPORT — performs report initialization. When the report is executed through the concurrent manager, it captures the concurrent request identifier through FND_GLOBAL and prepares the report environment. Debug tracing is conditional on a debug switch parameter. Errors are converted into a generic application error so that the report aborts cleanly.
  • AFTERREPORT — performs report teardown, releasing the report environment when running under the concurrent manager. It returns a Boolean completion indicator to the report engine.
  • CF_UPDATEFORMULA — a declared formula function that updates a single general ledger code combination record, setting the balanced-budget indicator flag for the supplied code combination. It runs as an autonomous transaction and commits independently of the caller, so the update is durable even if the surrounding report logic subsequently rolls back. It returns a status number.
  • CF_NO_DATA_FOUNDFORMULA — assigns the incoming value to the package variable CP_NO_DATA_FOUND. This is the routine directly associated with the parameter the user searched for, and it supplies the literal text the report displays when the query returns no rows.
  • CP_SELECT_ALL_P — returns the value of the CP_SELECT_ALL package variable for use by the report data model.
  • CP_WHERE_FLEX_P — returns the value of the CP_WHERE_FLEX package variable, which carries a dynamically assembled WHERE clause fragment used by the report query.
  • CP_NO_DATA_FOUND_P — returns the value of the CP_NO_DATA_FOUND package variable, exposing the no-data message to the report layout and parameters.

Tables Accessed

The only documented table reference is GL_CODE_COMBINATIONS, accessed through an APPS synonym. It is touched exclusively by CF_UPDATEFORMULA, which updates the IGI_BALANCED_BUDGET_FLAG column to 'Y' for the code combination identified by the supplied CODE_COMBINATION_ID. This flag marks the account as meeting the balanced-budget validation criteria applied by the associated report. No other tables are read or written by this package; the remaining functions operate solely on package variables and built-in calls.

Usage Notes

The package is invoked by an XML Publisher concurrent program, not directly by users or by other application code. The report engine calls BEFOREREPORT before the data model executes, then evaluates the CP_xxx getter and CF_xxx formula functions while generating output, and finally calls AFTERREPORT. The CP_NO_DATA_FOUND parameter, set by CF_NO_DATA_FOUNDFORMULA and retrieved by CP_NO_DATA_FOUND_P, allows the report definition to display a configurable message when the driving query yields no records; this is the customary resolution point when a report appears to complete without output. Because CF_UPDATEFORMULA commits autonomously, each invocation persists independently of the report transaction, which means an aborted run may still have marked code combinations as balanced. No other packages in the documented inventory reference this package, and the source header records a 120.0.12010000.1 version, indicating the object is stable and unchanged across the 12.1.1 and 12.2.2 releases.