Search Results set_constants

Overview

CEFC_VIEW_CONST is a global constants package in the Oracle E-Business Suite APPS schema, delivered as part of the Enterprise Taxation and Regulatory Management (ETRM) module. Its source header (cefcvies.pls, version 120.0, dated 2002/08/24) indicates it originated in the Oracle Cash and Treasury / Cash Forecasting (CEFC) product area and remains shipped in EBS 12.1.1 and 12.2.2. The package is classified as an API of type OTHER and is a pure PL/SQL specification with no body. It maintains a set of module-level global variables that hold session-scoped context for cash forecast views, and exposes paired SET and GET accessors for each variable. A single aggregate setter, SET_CONSTANTS, initialises the entire set of values in one call.

In practice, CEFC_VIEW_CONST provides the shared runtime context that the Cash Forecasting view engine uses when rendering and querying forecast data. Callers populate the package state once, and downstream packages, forms, or view logic read the values back through the GET functions instead of passing long parameter lists. The package is referenced by 8 other packages, confirming its role as a central, dependency-light access point.

Key Procedures and Functions

Fifteen documented procedures and functions are defined. Each value has a dedicated setter and getter, and generic RESTRICT_REFERENCES pragmas are attached to the getters (WNDS, RNDS, WNPS).

• SET_HEADER_ID / GET_HEADER_ID — Stores and returns the header identifier common to the forecast view context. This is the object the user searched for; GET_HEADER_ID returns a NUMBER and is a read-only function.
• SET_ROWID / GET_ROWID — Stores and returns a row identifier (VARCHAR2) used to track a specific row in the current view.
• SET_START_PERIOD_NAME / GET_START_PERIOD_NAME — Stores and returns the starting accounting period name (VARCHAR2).
• SET_PERIOD_SET_NAME / GET_PERIOD_SET_NAME — Stores and returns the accounting period set name (VARCHAR2).
• SET_START_DATE / GET_START_DATE — Stores and returns the effective start date (DATE) of the forecast or view range.
• SET_MIN_COL / GET_MIN_COL — Stores and returns the minimum column index (NUMBER) for the visible view range.
• SET_MAX_COL / GET_MAX_COL — Stores and returns the maximum column index (NUMBER) for the visible view range.
• SET_CONSTANTS — Initialises header id, period set name, start period, start date, and optional minimum and maximum column values in a single call. The min/max column parameters carry DEFAULT NULL, so callers may supply only the core context.

Tables Accessed

The package is documented as referencing two tables through APPS synonyms:

• CE_FORECAST_HEADERS — the header table for cash forecasts, the source of the forecast header identifier held by the package.
• GL_PERIODS — the General Ledger period definition table, supporting the period set and start period context.

Because the package exposes only accessors and a specification with no body shown, table access is likely performed by the caller or surrounding view logic rather than by these routines themselves; the constants package exists to hold the values resolved from those tables.

Usage Notes

CEFC_VIEW_CONST is invoked by forms, concurrent programs, and custom code that need consistent cash forecasting context. The typical pattern is to call SET_CONSTANTS once during initialisation, then invoke GET_HEADER_ID (and the other getters) wherever the header, period, date, or column range is required. The PRAGMA RESTRICT_REFERENCES declarations make the getters safe for use in SQL and PL/SQL contexts that require purity guarantees. Because state is held in package-level variables, the values are session-scoped: any calling session must set them before reading. The absence of a body in the documented specification and the low version number indicate this is mature, stable, and rarely modified code, so customisations should treat it as a read-mostly context holder and avoid altering the shipped specification.