Search Results get_pay_item_prev_submitted

Overview

POS_WC_CREATE_UPDATE_PVT is a private PL/SQL package in the Oracle E-Business Suite Purchasing module (APPS schema), associated with the Worker's Compensation (WC) purchasing and approval functionality. In EBS 12.1.1 and 12.2.2, the package encapsulates the internal business logic used to create, update, and approve Worker's Compensation purchase order records. As a PVT (private) classified API, it is not intended for direct external invocation; it is consumed by other Purchasing packages, forms, and workflow-enabled processes that manage the WC purchasing lifecycle. The package coordinates approval routing, tracks order and pay item progress, and interfaces with receiving and workflow tables, ensuring that WC-related documents move correctly through the approval and receipting chain.

Key Procedures and Functions

The package exposes functions and procedures that support the WC document lifecycle. Notable members include:

• DRAFT_EXISTS_FOR_PO — A function that determines whether a draft WC record already exists for a given purchase order header, preventing duplicate processing.
• GET_PO_INFO — A procedure that returns ordered and approved quantities for a PO header, along with status and message outputs.
• GET_WC_TOTAL_REQUESTED — A function returning the total requested quantity for a WC record at a specified stage.
• GET_PAY_ITEM_PROGRESS — A procedure that returns the completion progress of a WC pay item for a given stage.
• GET_PAY_ITEM_PREV_SUBMITTED — A procedure that returns the previously submitted quantity for a WC pay item relative to a corresponding PO pay item.
• COMPLETE_WC_APPROVAL_WF_BLOCK — A procedure that finalizes a WC approval workflow block, returning status and messages.
• START_APPROVAL_WORKFLOW — The procedure of primary interest for this search. It initiates the approval workflow for a WC header, using the WC header identifier as input and returning a status and message. This is the documented entry point for launching the WC approval process programmatically.
• INSERT_CORRECTIONS_INTO_RTI — Inserts correction records into the receiving transactions interface.
• LAUNCH_RTP_IMMEDIATE — Triggers immediate return-to-purchasing processing.
• GET_WC_HISTORY and GET_WC_CORRECTION_HISTORY — Retrieve historical and correction history for WC records.

Tables Accessed

The package references several core tables through APPS synonyms. Purchasing tables such as PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL provide the order, line, shipment, and distribution context required for approval and progress calculations. Receiving tables including RCV_HEADERS_INTERFACE, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, RCV_TRANSACTIONS, RCV_TRANSACTIONS_INTERFACE, and RCV_TRANSACTIONS_INTERFACE_S support correction and receipt processing. PO_WF_ITEMKEY_S supports workflow item key tracking, while FND_USER resolves user context, MTL_UNITS_OF_MEASURE supplies unit-of-measure conversions, and DUAL/PLITBLM serve as utility references.

Usage Notes

Because POS_WC_CREATE_UPDATE_PVT is classified as a private API, it is typically invoked indirectly through Purchasing forms, concurrent programs, or higher-level public APIs rather than called directly by custom code. START_APPROVAL_WORKFLOW is most commonly triggered when a WC document is submitted for approval, interoperating with Oracle Workflow. Customizations should prefer supported public APIs to avoid conflicts with internal logic, as private package signatures may change between releases.