Search Results po_ame_approvals_s

Overview

PO_SOURCING_PVT is a private (PVT classification) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It encapsulates the internal business logic that supports Oracle Sourcing and the procurement document creation/drafting flow within the Purchasing module. The "PVT" suffix denotes private scope: the package is not a published public API and is not intended for direct third-party or custom invocation. Instead, it functions as an internal service layer called by other purchasing packages — most notably PO_CORE_S, PO_GA_PVT, and the negotiation/sourcing stack — to build, validate, and persist purchasing document headers, including draft headers and interface staging records.

The package mediates between the Oracle Sourcing subsystem (auctions and bid headers) and the standard Purchasing document model. It also participates in the Creating Purchasing Documents from a Sourcing Award flow, where a sourcing award must be transformed into a standard purchase order. Its presence in dependency chains involving PO_AME_APPROVALS_S ties it to the approval routing setup: submission of a newly created or drafted document can trigger approval assignment derived from the AME (Approval Management Engine) approval rules table.

Key Procedures and Functions

CREATE_CPA — Creates a purchase document (a "CPA," or Client Purchase Agreement, in Sourcing context). This routine encapsulates the header construction logic, populating document style, terms, operating unit assignments, currency/financials defaults, and approval-related setup. It is the principal entry point for generating a sourcing-originated document record.
DELETE_INTERFACE_HEADER — Removes a staging/interim header record from the purchasing documents interface (PO_HEADERS_INTERFACE). It supports cleanup of failed or rolled-back document creation attempts, ensuring the interface tables remain consistent when a sourcing-to-PO conversion is aborted.

No public parameter lists are documented for these two procedures. Their internal signatures should be treated as implementation-private and subject to change across point releases.

Tables Accessed

PO_HEADERS / PO_HEADERS_ALL and PO_HEADERS_DRAFT_ALL — the primary document and draft document header stores.
PO_HEADERS_INTERFACE — staging table used for bulk or deferred header creation and cleanup by DELETE_INTERFACE_HEADER.
PON_AUCTION_HEADERS_ALL and PON_BID_HEADERS — sourcing/negotiation source records from which purchase documents are derived.
PO_AME_APPROVALS_S — approval assignment records that drive AME-based approval routing for the created document.
PO_DOC_STYLE_HEADERS, PO_SYSTEM_PARAMETERS, PO_GA_ORG_ASSIGNMENTS — document style, system defaults, and operating-unit/org assignment configuration.
AP_TERMS, GL_SETS_OF_BOOKS, GL_PERIOD_STATUSES, FINANCIALS_SYSTEM_PARAMETERS, ORG_FREIGHT — terms, ledger/period validation, financial defaults, and freight configuration.
PO_PRINT_FORM_FORMATS — print/formatting defaults.

Usage Notes

PO_SOURCING_PVT is invoked exclusively from within the APPS schema by other private purchasing packages and by the Oracle Sourcing and Purchasing UI flows. It is not referenced by any external database object and exposes no public API contract. Typical invocation paths include the Sourcing "Create Purchase Order" / award-to-PO action and the internal document-creation chain that terminates in approval submission via PO_AME_APPROVALS_S. Because it is a private package, customization should not call it directly; supported extension points are the public PO_HEADERS_PKG_S and PO_CORE_S APIs. Any reliance on its two internal procedures carries upgrade risk between 12.1.1 and 12.2.2.

SEQUENCE: PO.PO_AME_APPROVALS_S 12.2.2
owner:PO, object_type:SEQUENCE, object_name:PO_AME_APPROVALS_S, status:VALID,
SYNONYM: APPS.PO_AME_APPROVALS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_AME_APPROVALS_S, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PO_SOURCING_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SOURCING_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PO_MULTI_MOD_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_MULTI_MOD_PVT, status:VALID,
PACKAGE BODY: APPS.PO_AME_WF_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_AME_WF_PVT, status:VALID,
PACKAGE BODY: APPS.PO_AUTOCREATE_POSTPROC_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_AUTOCREATE_POSTPROC_PVT, status:VALID,
PACKAGE BODY: APPS.PO_COPYDOC_S1 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_COPYDOC_S1, status:VALID,
PACKAGE BODY: APPS.PO_PDOI_POSTPROC_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_PDOI_POSTPROC_PVT, status:VALID,
PACKAGE BODY: APPS.PO_REQAPPROVAL_INIT1 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_REQAPPROVAL_INIT1, status:VALID,
PACKAGE BODY: APPS.PO_DRAFTS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DRAFTS_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_AME_APPROVALS_S 12.2.2
APPS.PO_DRAFTS_PVT dependencies on PO_AME_APPROVALS_S 12.2.2
APPS.PO_AME_WF_PVT dependencies on PO_AME_APPROVALS_S 12.2.2
APPS.PO_SOURCING_PVT dependencies on PO_AME_APPROVALS_S 12.2.2
APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_AME_APPROVALS_S 12.2.2
APPS.PO_MULTI_MOD_PVT dependencies on PO_AME_APPROVALS_S 12.2.2
APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_AME_APPROVALS_S 12.2.2
APPS.PO_COPYDOC_S1 dependencies on PO_AME_APPROVALS_S 12.2.2
12.2.2 DBA Data 12.2.2