Search Results set_min_col




Overview
Explore in AI Chat

Overview

CEFC_VIEW_CONST is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Cash Forecasting (CEFC) module and is classified under the ETRM API classification "OTHER," indicating that it is an internal implementation package rather than a published, externally supported API. The package functions as a session-scoped state container for the Cash Forecasting user interface. Its single named public procedure, SET_CONSTANTS, together with a series of paired setter/getter routines, maintains package-level global variables (prefixed "pg_" in the source) that hold context values needed to render forecast information within an Oracle Forms session. The header comment block dates the original creation to August 1996 by user "bcarrol," and the current source header (RCS revision 120.1, dated 2002/11/12) confirms the object is a long-standing, stable component that has remained essentially unchanged across the 11i and R12 application generations.

Key Procedures and Functions

The documented interface exposes fifteen named program units organized as paired accessors plus one aggregating initialization routine:

  • SET_CONSTANTS — The primary documented entry point. It initializes the package-global variables in a single invocation, establishing the session context for the Cash Forecasting view.
  • SET_HEADER_ID / GET_HEADER_ID — Store and retrieve the forecast header identifier, anchoring downstream logic to a specific cash forecast definition.
  • SET_START_PERIOD_NAME / GET_START_PERIOD_NAME — Store and retrieve the starting accounting period name used to define the forecast display or calculation horizon.
  • SET_PERIOD_SET_NAME / GET_PERIOD_SET_NAME — Store and retrieve the accounting period set name, which qualifies how the start period is interpreted across ledgers.
  • SET_START_DATE / GET_START_DATE — Store and retrieve the start date. This is the accessor pair most directly associated with the user search term "set_start_date"; it caches the beginning date of the forecast window for reuse throughout a session.
  • SET_ROWID / GET_ROWID — Store and retrieve a ROWID value, typically identifying the currently selected or processed forecast row.
  • SET_MIN_COL / GET_MIN_COL and SET_MAX_COL / GET_MAX_COL — Store and retrieve the minimum and maximum column boundaries, which govern the displayed date/period range of the forecast grid.

The "pg_" prefix and the absence of a package specification in the excerpt indicate these variables are private to the package body, exposed only through the documented setter and getter programs.

Tables Accessed

The package references two tables through APPS synonyms:

  • CE_FORECAST_HEADERS — The Cash Forecasting forecast header table. It supplies or validates the header identifier and the period set / start period context that the package caches.
  • GL_PERIODS — The General Ledger period definition table. It is consulted to resolve period names and period set names into the date boundaries and column ranges stored by the MIN_COL and MAX_COL accessors.

Usage Notes

CEFC_VIEW_CONST is an internal support package invoked by Cash Forecasting forms and by eight other PL/SQL packages within the CEFC module. A form typically calls SET_CONSTANTS during query or initialization, then consumes the cached values through the GET_* functions while the user navigates forecast periods and rows. Because the package is classified as OTHER and private, it is not part of Oracle's supported public API; customizations should avoid direct dependency where possible and instead rely on the documented Cash Forecasting APIs. The presence of SET_START_DATE and GET_START_DATE explains why a search for "set_start_date" surfaces this object.