Search Results send_line_deleted_notif

Overview

PON_CLM_CLO_UTIL_PKG is an Oracle E-Business Suite PL/SQL utility package owned by the APPS schema and classified as an "OTHER" API within the sourcing (PON) module. Its role is to provide the shared, low-level line-manipulation logic behind Oracle Sourcing (negotiation) line management — specifically for the creation, copying, and deletion of negotiation lines, including CLINs (contract line items), SLINs (sub-line items), and their associated options. The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than the definer. It is a dependent, internal utility rather than a self-contained public business API: the ETRM metadata records that it is referenced by three other packages, which is consistent with its use as a common service layer consumed by higher-level negotiation APIs and the Sourcing user interface. Because the procedures operate directly on draft negotiation data (PON_AUCTION_* and PO_DRAFTS/PO_DISTRIBUTIONS_DRAFT_ALL), the package is most relevant to in-progress auctions and RFQs before they are finalized.

Key Procedures and Functions

• DELETE_SINGLE_LINE — Deletes a given negotiation line identified by auction header and line number. The procedure also removes all options attached to that line; if the line is a CLIN, the entire set of dependent SLINs is deleted as well. It returns a result status, error code, error message, and the count of lines deleted.
• COPY_AND_CREATE_OPTION — Invoked when creating an option for either an SLIN or a CLIN. It copies the base line, creates a new line, and returns the new line number so that the user can be routed to the line editor to supply option-specific information.
• COPY_CLIN — Copies a CLIN or SLIN; where the source is a CLIN, the complete line hierarchy is reproduced. It tracks the maximum line number used and returns status and error information.
• POPULATE_CROSSLINK_MAP — Builds the cross-link mapping used to maintain relationships between copied or re-created negotiation lines.
• SEND_LINE_DELETED_NOTIF — Dispatches the workflow notification associated with a line deletion, consistent with the PON_LINE_DELETE_WF_S table reference.
• COPY_LINES — Performs bulk copying of negotiation lines.
• REDEFAULT_TX — Re-applies tax defaulting logic to affected lines.
• CALCULATEDATES — Performs date calculations for negotiation lines.

Tables Accessed

The package reads and writes the core negotiation and draft structures. PON_AUCTION_HEADERS_ALL, PON_ATTRIBUTE_SCORES, PON_AUCTION_ATTRIBUTES, PON_AUCTION_ITEM_PRICES_ALL, PON_AUCTION_SHIPMENTS_ALL, and PON_AUC_PAYMENTS_SHIPMENTS (including sequence PON_AUC_PAYMENTS_SHIPMENTS_S1) support line, price, attribute, shipment, and payment detail. PON_PRICE_ELEMENTS, PON_PRICE_DIFFERENTIALS, and PON_BACKING_REQUISITIONS hold pricing and requisition reference data. PO_DRAFTS and PO_DISTRIBUTIONS_DRAFT_ALL represent the draft purchasing documents that mirror the negotiation. PON_LINE_DELETE_WF_S supports line-deletion workflow. FND_USER and PER_ALL_PEOPLE_F supply user and person information for notifications and ownership.

Usage Notes

PON_CLM_CLO_UTIL_PKG is normally invoked indirectly — from the Oracle Sourcing line-management forms, from the higher-level negotiation APIs that call it, or from line-deletion workflow — rather than being called directly by end users. Customizations should not call DELETE_SINGLE_LINE in isolation, because the deletion of a CLIN cascades to its SLINs and options and must be coordinated with the workflow notification and cross-link map maintenance handled by the companion procedures. Because the package writes to draft (PO_DRAFTS) and auction staging tables and runs AUTHID CURRENT_USER, it should only be executed within an APPS-privileged session inside a controlled transaction, with the returned result, error code, and error message inspected before commit. Behavior is consistent across EBS 12.1.1 and 12.2.2, though the 12.2.x file header indicates maintenance updates to the utility logic.