Search Results draft_changes_exist

Overview

APPS.PO_PRICE_DIFF_DRAFT_PVT is a private PL/SQL package within the Oracle Purchasing module that manages draft changes made to price differential definitions. A price differential in Oracle EBS represents an adjustment applied to a purchase order or agreement price, and the drafting mechanism allows users to stage modifications to existing price differential records without immediately committing them to the base tables. This package encapsulates the logic required to detect, evaluate, and ultimately apply those staged modifications. Because it is classified as a PVT (private) API rather than a public API, it is intended for internal use by other Purchasing packages and is not directly callable from external customizations. The package header is versioned at 120.2, with a build stamp indicating a 2005 origin, and it is documented in ETRM for both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

• DRAFT_CHANGES_EXIST – Checks whether draft changes exist in the draft table for a given draft identifier, or for a draft identifier combined with a specific price differential identifier. When only the draft identifier is supplied, the function returns a true indication if any draft row exists for that draft. When the full primary key is supplied, the result is scoped to that individual price differential record. The function returns a collection of flags, one per input entry, using FND_API.G_TRUE and FND_API.G_FALSE to signal the presence or absence of draft changes. This makes it suitable for bulk evaluation of multiple drafts or price differential records in a single call.
• APPLY_CHANGES – Applies the staged draft changes to the underlying price differential data, committing the modifications represented in the draft table to the permanent records. This function is the counterpart to DRAFT_CHANGES_EXIST, invoked once the caller has confirmed that pending drafts warrant application.

A third documented routine rounds out the package. The source excerpt shows DRAFT_CHANGES_EXIST operating on PO_TBL_NUMBER and PO_TBL_VARCHAR1 collection types, consistent with the PL/SQL table-based bulk interface style used throughout Oracle Purchasing APIs.

Tables Accessed

• PO_PRICE_DIFF_DRAFT – The primary draft table holding staged price differential changes. The package reads this table to determine whether drafts exist and writes to it when applying changes.
• PO_SESSION_GT – A global temporary session table used to hold intermediate working data during processing.
• DUAL – Used for simple single-row evaluations and control-flow checks.
• PLITBLM – The PL/SQL table-to-index translation facility, supporting the bulk collection parameters.

Usage Notes

PO_PRICE_DIFF_DRAFT_PVT is invoked indirectly by two other packages, which call into it during price differential draft processing. Typical invocation occurs when a user edits price differential information through the Purchasing forms and the application must determine whether draft records already exist before persisting new changes, or when a confirmation step applies those drafts to the operational tables. Because the package is a PVT API, developers should not call it directly from custom code; instead, they should identify the calling public interfaces. The function's bulk-array signature makes it well suited for processing multiple records in concurrent or batch contexts, though it is primarily associated with online form-driven workflows. All error handling follows the standard PO_LOG and FND_API conventions, with the package base name registered through PO_LOG.get_package_base for diagnostic tracing.