Search Results delete_forecasts




Overview
Explore in AI Chat

Overview

XTR_FORECAST_HEADERS_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM (Enterprise Treasury and Risk Management) product family. Its stated purpose in the source header is to group all procedures and functions required for table-level handling of the CE_FORECAST_HEADERS table, the repository for forecast header definitions used by the Treasury cash forecasting feature set within Oracle Cash Management and ETRM. The package was originally created by C. Kawamoto on 07.10.96, and the current header revision ($Header: xtrfhdrs.pls 120.1 2005/06/29) reflects a long-lived, stable code line carried forward into EBS 12.1.1 and 12.2.2 without structural change.

The package declares AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the calling session rather than as the defining APPS owner. This is consistent with many EBS internal packages and means callers must themselves possess the necessary object privileges, typically granted through standard APPS responsibility grants. The API classification in ETRM documentation is OTHER, indicating it is not a supported public business API in the same sense as the standard Cash Management application programming interfaces; it is instead an internal table-handling utility layer.

Key Procedures and Functions

  • CHECK_UNIQUE — Verifies the uniqueness of a forecast record before insertion, preventing duplicate forecast header names or identifiers from being committed.
  • INSERT_ROW — Inserts a new forecast header row into CE_FORECAST_HEADERS, populating the forecast name, description, aging type, overdue transaction handling flag, cutoff period, transaction calendar, treasury template, WHO audit columns, and the fifteen descriptive flexfield attribute columns.
  • LOCK_ROW — Acquires a row-level lock on the specified CE_FORECAST_HEADERS record, supporting concurrency control during update or delete operations.
  • UPDATE_ROW — Applies modifications to an existing forecast header row.
  • DELETE_ROW — Removes a single forecast header row.
  • DELETE_FORECASTS — Performs deletion of forecast data. This is the procedure most frequently associated with the search term "delete_forecasts", and it is the entry point used when forecast records must be purged in bulk.

Tables Accessed

  • CE_FORECAST_HEADERS — The primary table for which this package provides insert, update, lock, delete, and uniqueness-check behavior.
  • CE_FORECAST_HEADERS_S — The corresponding sequence/identifier support table used when generating forecast header primary keys.
  • CE_FORECAST_ROWS — Forecast detail lines associated with each header; accessed during deletion to maintain referential consistency.
  • XTR_FORECAST_PERIODS — Period definitions belonging to a forecast.
  • XTR_EXTERNAL_CASHFLOWS — External cashflow records linked to forecast headers.

Usage Notes

Because ETRM documentation lists zero packages referencing XTR_FORECAST_HEADERS_PKG, it is not a dependency of other APPS packages; it is invoked directly from Oracle Forms (the Cash Forecasts setup and maintenance windows), from concurrent programs that create or purge forecast definitions, and from custom PL/SQL that manages forecast headers programmatically. Practitioners searching for "delete_forecasts" should note that DELETE_FORECASTS is an internal procedure and carries no documented public API compatibility guarantee across releases; callers should validate behavior against their specific 12.1.1 or 12.2.2 instance before relying on it in production code.