Search Results update_coll_for_hdr_only_msg

Overview

CLN_ACK_PO_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the CLN (Supply Chain Collaboration / Collaborative Planning) product family and is classified under the generic API classification "OTHER" in the ETRM repository. The package encapsulates the business logic required to process purchase order acknowledgements received from suppliers through the collaboration messaging framework. In a typical EBS deployment, trading partners respond to transmitted purchase orders with acknowledgement documents that confirm receipt, accept, reject, or propose changes to order headers and lines. CLN_ACK_PO_PKG is the server-side component that parses, validates, and applies those inbound acknowledgement payloads against the collaborative planning data model.

The package is documented as VALID in both 12.1.1 and 12.2.2 environments, and its dependency list is minimal, referencing only SYS.STANDARD. Within the APPS schema, it is self-referencing, meaning internal procedures call one another rather than exposing a broad public API surface. It is not referenced by any other documented package, which indicates it is intended as a top-level processing unit invoked directly by the collaboration infrastructure.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

• PROCESS_HEADER — drives processing of the header-level portion of an inbound purchase order acknowledgement.
• PROCESS_HEADER_LINES — handles acknowledgement processing for the line-level detail associated with a header.
• LOAD_CHANGES — loads detected changes from the acknowledgement payload into the collaboration staging/change structures.
• ACKPO_ERROR_HANDLER — centralised error handling routine invoked when validation or processing failures occur.
• PROCESS_HEADER_RN — a variant of header processing, typically used in a renegotiation or response-notification context.
• PROCESS_HEADER_LINES_RN — the line-level counterpart to PROCESS_HEADER_RN.
• CLN_GET_PO_ACK_CODE_RN — a function that derives the appropriate acknowledgement code for a given response-notification scenario.
• UPDATE_COLL_FOR_HDR_ONLY_MSG — updates collaboration records when the acknowledgement contains only a header-level message with no line detail.

Tables Accessed

Access is performed through APPS synonyms. The package touches the following documented tables:

• CLN_COLL_HIST_HDR — the collaboration history header table, used to record and track acknowledgement status against the collaboration record.
• CLN_GENERIC_S — a generic sequence used to generate surrogate keys during processing.
• ECX_TP_HEADERS — the e-Commerce Gateway trading partner header table, used to resolve partner context for the inbound message.
• WF_PARAMETER_LIST_T — the Oracle Workflow parameter list type, used to pass structured parameters through the workflow/notification layer.
• DUAL — the standard single-row pseudo-table for scalar evaluation.
• PLITBLM — the PL/SQL integer table type used for array-style processing of message lines.

Usage Notes

CLN_ACK_PO_PKG is not exposed through a standard EBS form. It is invoked from the collaboration/XML Gateway processing stack when an inbound purchase order acknowledgement is received and must be applied to the collaborative planning repository. Because it is not referenced by any other documented package, direct invocation from custom code should be treated as an unsupported extension point; any bespoke integration should call the package only after confirming the current signature in the target release. Its error handler and sequence usage suggest it is designed to run within a defined transaction boundary, and callers should preserve that boundary to maintain data integrity in CLN_COLL_HIST_HDR and related collaboration records.