Search Results pon_line_delete_wf_s

Overview

PON_CLM_CLO_UTIL_PKG is a utility package body in the APPS schema that supports Oracle E-Business Suite sourcing and negotiation functionality, specifically the Oracle Sourcing (PON) module and its integration with Oracle Purchasing document drafting. The package name incorporates "CLM" and "CLO," referencing contract line management and change line order processing, as well as "UTIL" for utility. It provides the shared plumbing used when sourcing lines, contract lines, or draft purchasing document lines must be copied, renumbered, redefaulted, or removed during online editing sessions. It is classified under the generic "OTHER" API category rather than as a formal public interface, which reflects its internal, utility-oriented nature. The package is marked VALID in the ETRM 12.2.2 catalog and is not referenced by any other database object, indicating it is called directly rather than through a layered API stack.

Key Procedures and Functions

The package exposes eight documented programs. DELETE_SINGLE_LINE removes a single line from a sourcing or draft document, handling dependent rows and triggering downstream cleanup. SEND_LINE_DELETED_NOTIF transmits a workflow notification when a line deletion occurs, interfacing with the Workflow engine to inform the affected buyer or supplier. COPY_LINES duplicates one or more lines within a document, commonly used for rapid entry of similar negotiation lines. COPY_CLIN performs contract line item number copying, preserving the CLIN structure across draft documents. COPY_AND_CREATE_OPTION combines line duplication with the creation of an option line, supporting sourcing constructs that offer alternate quantities or terms. POPULATE_CROSSLINK_MAP builds a mapping between original and copied line identifiers so downstream references remain consistent. REDEFAULT_TX reapplies default tax and attribute values to lines, typically after a copy or attribute change. CALCULATEDATES computes derived date fields, such as effective or expiration dates, based on negotiation rules and calendar logic.

Tables Accessed

The package operates across the sourcing and purchasing draft data model. PON_AUCTION_HEADERS_ALL, PON_AUCTION_SHIPMENTS_ALL, and PON_AUCTION_ITEM_PRICES_ALL hold the negotiation header, shipment, and pricing rows that are the primary targets of copy and delete operations. PON_ATTRIBUTE_SCORES and PON_AUCTION_ATTRIBUTES supply scoring and attribute context. PON_PRICE_ELEMENTS, PON_PRICE_DIFFERENTIALS, and PON_BACKING_REQUISITIONS carry pricing components and requisition linkage. On the purchasing side, PO_HEADERS_DRAFT_ALL, PO_LINES_DRAFT_ALL, PO_DISTRIBUTIONS_DRAFT_ALL, and PO_DRAFTS store the draft document hierarchy. PON_LINE_DELETE_WF_S, referenced by the user query term "pon_line_delete_wf_s," is the workflow status table used to track the line-deletion notification lifecycle. FND_USER and PER_ALL_PEOPLE_F resolve operator and approver identities. PON_AUC_PAYMENTS_SHIPMENTS and its sequence PON_AUC_PAYMENTS_SHIPMENTS_S1 support payment shipment numbering.

Usage Notes

PON_CLM_CLO_UTIL_PKG is invoked principally from Oracle Sourcing and Purchasing forms during interactive line maintenance: deleting a negotiation line, copying lines, or applying defaults. Because it calls FND_API, FND_MESSAGE, FND_LOG, and WF_ENGINE, it participates in the standard EBS error-handling and workflow infrastructure, allowing notifications and logging to be captured. The package is referenced by three other packages, confirming it acts as a shared utility layer for higher-level sourcing programs. Customizations that add or delete negotiation lines should route through this package rather than issuing direct DML, so that workflow events, crosslink maps, and date recalculations remain synchronized. It should not be called from external systems without validating the draft document context, since copy and delete operations assume an active editing session.