Search Results update_terms

Overview

PO_INTERFACE_S2 is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema, declared with AUTHID CURRENT_USER and owned by the APPS account. Within the Purchasing module, it functions as a supporting interface utility that resolves and propagates sourcing, document header, and terms information during the creation and manipulation of purchasing documents. Typical callers include the Purchasing interface and document-generation flows that must translate a requisition or source document into a purchase order, or that must carry forward attributes such as terms, vendor site, ship-via, FOB, freight, and currency when lines or headers are added to an existing document. The package is documented under API classification OTHER in ETRM for EBS 12.2.2, and its header references the 2003 POXBWP2S.pls revision, consistent with the long-lived code base shared by 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes four documented program units. Parameters are not reproduced here; purposes follow the ETRM metadata.

• GET_SOURCE_INFO — Resolves the source document information for a given requisition line, vendor, and currency, returning source header and source line identifiers. It supports the requisition-to-purchase-order mapping used when an interface process must determine the originating requisition context.
• GET_DOC_HEADER_INFO — Retrieves header-level attributes of an existing document that a new line or document is being added to. Outputs include the add-to type, vendor, vendor site, currency code, terms identifier, ship-via, FOB, freight, and shipping control. It allows downstream logic to inherit header defaults rather than requiring them explicitly.
• IS_REQ_IN_POOL — A Boolean function that tests whether a requisition line participates in a pooling arrangement, typically associated with the Services procurement flow. Callers use the result to decide whether pooling-related processing applies.
• UPDATE_TERMS — The procedure most relevant to the "update_terms" search. Given a new purchase order identifier, it updates terms information on the purchase order. This procedure is invoked after a PO has been created or copied, to ensure the terms identifier on the header reflects the intended sourcing or vendor terms.

Tables Accessed

The package references the following tables through APPS synonyms:

• PO_HEADERS / PO_HEADERS_ALL — Read and updated to obtain and set document header attributes, including terms and vendor information.
• PO_LINES / PO_LINES_ALL — Accessed for line-level detail needed to correlate requisition lines to purchase order lines.
• PO_REQUISITION_LINES / PO_REQUISITION_LINES_ALL — Read to identify requisition context, including whether lines are in a pool and their source linkage.
• PO_GA_ORG_ASSIGNMENTS — Referenced for organization assignment information relevant to sourcing and document ownership.

Usage Notes

PO_INTERFACE_S2 is not a standalone user-facing program; it is invoked programmatically. The ETRM metadata indicates it is referenced by two other packages. Typical invocation occurs from Purchasing interface and document-generation logic, from concurrent programs that import requisitions or create purchase orders, and from custom PL/SQL that builds POs from requisitions. UPDATE_TERMS in particular is called after a PO identifier is known, to synchronize terms on the newly created or copied document. Because the package is declared AUTHID CURRENT_USER and references APPS synonyms, callers should execute it within the APPS schema context or with appropriate synonym and privilege configuration. Direct modification of its source is not supported; the documented interface should be used as published.