Search Results update_change_response

Overview

APPS.PO_CHANGE_RESPONSE_PVT is a private PL/SQL package within the Oracle E-Business Suite Purchasing module that supports the change-order response lifecycle for purchase orders, releases, and their associated document lines and shipments. In Oracle EBS 12.1.1 and 12.2.2 the package is declared with AUTHID CURRENT_USER, meaning that its unqualified references to PO tables are resolved through APPS synonyms under the privileges of the calling session. The package is not intended for direct customer use; it encapsulates internal processing logic invoked by other Purchasing deliverables when a supplier or buyer responds to a change request issued against an existing purchasing document.

Its principal business responsibilities are to determine whether a change is still outstanding against a given document, to detect partial acknowledgements of change requests, to relocate accepted change information back onto the purchase order or release, and to manage the acceptance and rollback of supplier responses. These capabilities underpin the supplier acceptance and change-order workflows used by the Purchasing and iSupplier applications.

Key Procedures and Functions

• CheckPartialAck — evaluates whether a change request group has been partially acknowledged for a specified purchase order header or release, returning an indicator to the caller. Used to decide whether further supplier response is outstanding.
• CheckChangePending — determines whether an unresolved change exists for a given purchase order header or release, returning a flag that drives downstream processing such as document revision or approval.
• get_distribution_count — a function returning the number of distributions associated with a document line location, taking the request level and the line location and its parent line location as inputs. This is the object most frequently located by developers searching the ETRM metadata.
• MoveChangeToPO — applies an accepted change request group to the purchase order or release, optionally launching approvals and supporting mass update of releases.
• update_change_response — records the outcome of a supplier or buyer response, including status, responder, reason, request level, group, line location, and split or cancellation flags.
• roll_back_acceptance — reverses a prior acceptance for a change request group, restoring the document to its pre-acceptance state.

Tables Accessed

The package reads and writes core Purchasing tables accessed through APPS synonyms. PO_CHANGE_REQUESTS and PO_CHG_REQUEST_SEQ store the change requests themselves and their sequence values. PO_DISTRIBUTIONS and PO_DISTRIBUTIONS_ALL hold the distribution records counted by get_distribution_count. PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, and PO_RELEASES_ALL supply the document, shipment, and release context. PO_DOCUMENT_TYPES_ALL_B provides document type information, and PLITBLM is used as a PL/SQL index-by table for bulk processing of line identifiers.

Usage Notes

PO_CHANGE_RESPONSE_PVT is an internal private package and is referenced by at least two other packages in the APPS schema. It is typically invoked indirectly from Purchasing and iSupplier Portal forms, from change-order and supplier-acceptance concurrent programs, and from wrapper code in the purchasing change response APIs. Because the package is classified as PVT and is not a published public API, customizations should avoid calling it directly; instead developers should rely on supported public interfaces and treat this package as subject to change between releases.