Search Results po_price_adj_draft_pkg




Overview
Explore in AI Chat

Overview

The APPS.PO_PRICE_ADJ_DRAFT_PKG package body is a core Oracle E-Business Suite purchasing component that manages draft (uncommitted) price adjustment records before they are synchronized into the transactional purchasing tables. It operates in the Oracle Purchasing module and supports the draft-edit workflow that allows buyers to stage, modify, and version price adjustment definitions without immediately affecting active purchase orders, releases, and quotations. The package is owned by the APPS schema and carries a VALID status in both EBS 12.1.1 and 12.2.2. Its documented API classification is OTHER, meaning it is an internal utility package rather than a published public API; it is called by other Purchasing programs rather than exposed directly to external integrations.

Key Procedures and Functions

ETRM documents seven subprograms in this package body, of which the following are named in the metadata excerpt:

  • DELETE_ROWS — Removes price adjustment draft rows, typically invoked when a draft is discarded or superseded, keeping the draft tables consistent with the current editing session.
  • SYNC_DRAFT_FROM_TXN — Copies the current transactional price adjustment data into the draft tables, establishing the baseline a user then edits. This is the mechanism that seeds a draft from the committed transaction.
  • MERGE_CHANGES — Reconciles and applies the edits captured in the draft tables, merging changed rows so that the draft reflects the intended end state before commit processing.
  • LOCK_DRAFT_RECORD — Acquires a lock on the draft row to prevent concurrent modification by another session, enforcing serialized editing.
  • LOCK_TRANSACTION_RECORD — Acquires a lock on the underlying transactional record, protecting it from simultaneous update while draft changes are pending.

Two additional subprograms are counted in the documented total of seven but not individually named in the excerpt; their behavior is inferred from the package's overall draft-management role. No parameter lists are asserted, consistent with the documented scope.

Tables Accessed

The package reads and writes the following APPS tables, accessed through synonyms:

Supporting dependencies include PO_LOG, PO_MESSAGE_S, FND_API, PO_PRICE_ADJ_DRAFT_PVT, PO_TBL_NUMBER, and PO_TBL_VARCHAR1, indicating the package uses the standard EBS logging, message, and API error-handling infrastructure together with private helper logic in PO_PRICE_ADJ_DRAFT_PVT.

Usage Notes

PO_PRICE_ADJ_DRAFT_PKG is an internal implementation package and is not intended for direct customer invocation. It is referenced by four other packages and is not referenced by any standalone database object, confirming that its consumers are sibling Purchasing packages. It is typically driven by the Price Adjustment and Purchasing forms and by concurrent programs that manage draft price adjustments, where the sequence is normally: lock the relevant records, seed the draft from the transaction, allow edits, merge changes, then delete obsolete draft rows. Because the package relies on PO_MESSAGE_S and PO_LOG, errors surface through the standard EBS message stack rather than raw exceptions. Customizations should call the higher-level PO_PRICE_ADJ_DRAFT_PVT or public Purchasing APIs rather than this body directly, as its signature and internal sequence are subject to change across patch levels.