Search Results chv_item_orders_pkg_s1

Overview

CHV_ITEM_ORDERS_PKG_S1 is a server-side PL/SQL table handler package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its documented purpose is to act as the table handler for Supplier Scheduling horizontal schedules, specifically for the CHV_ITEM_ORDERS table. Supplier Scheduling is part of the EBS Supply Chain Management suite and supports the communication of firm and planned order requirements to suppliers through schedule documents. The horizontal schedule model represents requirements laid out across a time-phased horizon for a given schedule and schedule item combination.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer. This is consistent with Oracle Application Object Library conventions for packages that are called from forms, concurrent programs, or other PL/SQL APIs operating inside the APPS environment. The package header carries a version marker of 115.0 dated 17-JUL-1999 and references an original creation in 1996, indicating that the object is legacy code carried forward through successive EBS releases. It is a thin, single-purpose handler rather than a broad business API.

Key Procedures and Functions

The documented interface exposes a single procedure:

• delete_row — The only documented procedure or function in the package. It is described as the table handler responsible for deleting rows from the CHV item orders table. Its parameters are the schedule identifier and the schedule item identifier, which together identify the horizontal schedule row to be removed. The documented parameter names are X_Schedule_Id and X_Schedule_Item_Id. No other procedures or functions are documented for this package.

Because the package header declares only this procedure, the package is best understood as a narrow delete operation wrapped in a named PL/SQL unit. No insert, update, or query procedures are documented in the ETRM metadata. The procedure name is listed in metadata under the placeholder NAME, and the excerpt confirms the actual routine is delete_row.

Tables Accessed

The only documented table referenced through an APPS synonym is CHV_ITEM_ORDERS. This is the base table that stores horizontal schedule line records for Supplier Scheduling. The table is keyed in part by the schedule identifier and schedule item identifier, which correspond directly to the two parameters of delete_row. The procedure writes to this table in the sense of removing rows; the metadata does not document any read operations, although a table handler of this type may internally validate existence before deletion.

Because CHV_ITEM_ORDERS is accessed through an APPS synonym, any invocation must occur in a context where the APPS synonyms are visible and the calling user has appropriate privileges on the underlying object.

Usage Notes

CHV_ITEM_ORDERS_PKG_S1 is an internal implementation package rather than a user-facing API. It is typically invoked from the Supplier Scheduling forms or from other PL/SQL modules that manage horizontal schedule data. The metadata records that the package is referenced by one other package, which suggests it participates in a small dependency chain rather than being called directly by external custom code.

Given its AUTHID CURRENT_USER declaration and its role as a delete handler, customizations should avoid calling delete_row directly unless the surrounding transaction logic, concurrency handling, and validation performed by the original calling module are fully understood. Deletion of horizontal schedule rows can affect supplier communication and planning results, so direct invocation should be treated as a privileged operation. From a support perspective, the package is stable legacy code and is unlikely to be extended; the documented interface and the single referenced table remain the authoritative facts for impact analysis.