Search Results copy_attachment

Overview

PO_AUTOCREATE_POSTPROC_PVT is a private PL/SQL package in the APPS schema that performs the post-processing phase of the Oracle Purchasing Autocreate workflow. Autocreate converts approved requisition lines into purchase order, blanket, or contract documents. While the requisition selection and matching logic is handled elsewhere, PO_AUTOCREATE_POSTPROC_PVT is responsible for the transactional work that follows: manufacturing the draft document into an actual PO or blanket, deriving defaults, calculating tax, propagating attachments, and converting funding information into distribution lines. Its API classification is PVT, indicating that it is an internal helper package not intended for direct customer invocation; it is called by the public-facing autocreate packages.

The package depends on PO_AUTOCREATE_PARAMS and PO_AUTOCREATE_TYPES, the latter being the subject of the user's search term "po_autocreate_types." PO_AUTOCREATE_TYPES supplies the shared record and collection type definitions used to shuttle autocreate context between the driver package, the post-processing package, and the document-creation routines.

Key Procedures and Functions

ETRM documents seven procedures and functions within this package (signatures are not published, so only purposes are described):

• PROCESS — The main entry point that orchestrates the full post-processing flow for a given autocreate run, invoking the individual document-creation and enrichment steps in the required sequence.
• CREATE_STANDARD_PO — Creates a standard purchase order from the autocreated draft, applying header, line, and distribution defaults.
• CREATE_BLANKET — Creates a blanket purchase agreement from the draft where the sourcing result calls for a blanket rather than a standard order.
• CALCULATE_TAX — Computes and applies tax amounts to the resulting document lines after creation.
• COPY_ATTACHMENT — Copies attachments from the source requisition or draft to the newly created document, preserving supporting documentation.
• CONVERT_FUND_TO_INFO_SLIN — Converts funding information into an informational service line on the document, supporting budgetary and encumbrance visibility.
• CREATE_DOC_FROM_DRAFT_CHECK — Validates whether a draft is eligible for conversion into a document before creation proceeds.

Tables Accessed

The package reads and writes the core Purchasing draft and header tables: PO_DRAFTS, PO_HEADERS_DRAFT_ALL, and PO_HEADERS_ALL hold the draft and resulting document structures, while PO_HEADERS_INTERFACE is used where interface processing applies. PO_DISTRIBUTIONS_DRAFT_ALL and PO_DISTRIBUTIONS_ALL carry distribution and funding detail. Attachment processing draws on FND_ATTACHED_DOCUMENTS and FND_DOCUMENTS_TL. Document style defaults come from PO_DOC_STYLE_HEADERS. Supplier and user context are resolved through PO_VENDORS, FND_USER, and PER_PEOPLE_EXTRA_INFO. Approval integration uses PO_AME_APPROVALS_S, and sourcing exhibits use PON_AUCTION_EXHIBIT_DETAILS, PO_EXHIBIT_DETAILS, and PO_EXHIBIT_DETAILS_S.

Usage Notes

PO_AUTOCREATE_POSTPROC_PVT is not invoked directly by end users. It is called by PO_AUTOCREATE_PVT and PO_AUTO_HEADER_PROCESS_PVT, which drive it during the Purchasing Autocreate concurrent program and related document-creation flows. Customizations that need to alter autocreate output should normally extend the public autocreate APIs or the Autocreate workflow rather than calling this private package, because its procedures rely on the PO_AUTOCREATE_TYPES structures and PO_AUTOCREATE_PARAMS session context being populated by the caller. In both 12.1.1 and 12.2.2 the package is VALID in APPS; source inspection should always be performed against the specific patch level in use.