Search Results store_supplier_request

Overview

PO_CHG_REQUEST_GRP is an Oracle EBS PL/SQL package owned by the APPS schema and classified as an API group (GRP) module. It serves the Purchasing module by supporting the supplier-initiated change request workflow, in which suppliers submit requests to modify existing purchase orders through Oracle Supplier Network or a comparable collaboration channel. The package encapsulates the server-side processing logic that validates, stores, and applies supplier change requests against purchasing documents, and it handles the acknowledgement cycle that notifies suppliers of acceptance or rejection.

The package is documented as VALID in ETRM for both 12.1.1 and 12.2.2, with the same set of six documented program units. It depends on the POS_CHG_REC_TBL record type and the STANDARD package, indicating a conventional EBS API design that raises standard application exceptions and returns status on an OUT parameter rather than relying solely on exceptions.

Key Procedures and Functions

• INITIALIZE_CHN_ACK_INBOUND — Establishes the context required for processing an inbound change request acknowledgement message, preparing any global or session-level state used by later steps in the same session.
• VALIDATE_HEADER — Performs header-level validation on the inbound change request, confirming that the referenced purchasing document and request attributes are consistent and eligible for processing.
• STORE_SUPPLIER_REQUEST — Persists the supplier-submitted change request data into the PO_CHANGE_REQUESTS staging structures for subsequent review and processing.
• PROCESS_SUPPLIER_REQUEST — Applies the stored change request against the purchasing document, driving the update of purchase order headers, lines, shipments, and releases as appropriate.
• ACKNOWLEDGE_PO — Generates and records the acknowledgement of the purchase order or the change request outcome, closing the communication loop with the supplier.
• WINDUP_CHN_ACK_INBOUND — Finalises the inbound acknowledgement process, releasing or committing session state and completing bookkeeping.

Tables Accessed

The package reads and writes purchasing base tables through APPS synonyms: PO_CHANGE_REQUESTS for the change request staging records; PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_RELEASES_ALL for the live purchasing document; and their archive counterparts PO_HEADERS_ARCHIVE_ALL and PO_LINE_LOCATIONS_ARCHIVE_ALL for version history. FINANCIALS_SYSTEM_PARAMS_ALL supplies operating unit and financials setup defaults, while FND_USER provides requesting user context. PLITBLM is the standard EBS line-level table used by the application for temporary or working line data. Together these references confirm the package's role as the write-back layer for supplier change requests.

Usage Notes

PO_CHG_REQUEST_GRP is referenced by three other packages — CLN_ACK_PO_PKG, CLN_PO_CHANGE_ORDER, and CLN_PO_CHG_ORDER_STATUS — which are part of the clean-up and inbound processing framework for supplier collaboration. It is therefore invoked indirectly rather than directly from a form. Typical invocation paths include the concurrent programs that read inbound XML or flat-file change request payloads and the supplier collaboration inbound processing stack that orchestrates validation through acknowledgement. Custom code should not call the individual procedures in isolation, because they assume shared session state established by INITIALIZE_CHN_ACK_INBOUND and completed by WINDUP_CHN_ACK_INBOUND; any extension should instead use the documented EBS change request APIs or the calling wrapper packages listed in the ETRM dependency data.