Search Results source_blanket_line

Overview

PO_INTERFACE_S is a public PL/SQL package owned by the APPS schema that participates in the Purchasing interface layer of Oracle E-Business Suite. Its role is to support the programmatic creation and maintenance of purchasing documents — requisitions, purchase orders, blanket agreements, and related distribution records — during batch and online processing. The package operates as a server-side utility that bridges inbound interface data with the core Purchasing tables, and it is classified as an "OTHER" API rather than a formal, fully documented public interface. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

The dependency listing confirms that PO_INTERFACE_S depends only on SYS and STANDARD at the database level, meaning it relies on Oracle built-in packages rather than a large internal hierarchy. It is referenced by several significant Purchasing and Inventory components, including INV_PO_THIRD_PARTY_STOCK_MDTR, PON_AUCTION_CREATE_PO_PKG, PO_AUTOCREATE_DOC, and by itself.

Key Procedures and Functions

ETRM documents eight procedures and functions within PO_INTERFACE_S. The principal entry point is CREATE_DOCUMENTS, which drives the construction of purchasing documents from source data. SOURCE_BLANKET_LINE resolves and returns blanket agreement line information, typically as part of auto-creation or sourcing logic that selects eligible blanket lines for new orders.

The remaining documented procedures address distribution-level maintenance. UPDATE_AWARD_DISTRIBUTIONS revises award distribution rows associated with purchasing documents. CALIBRATE_LAST_DIST_QUANTITY adjusts the quantity on the final distribution of a document, a common requirement when rounding or balancing quantity across multiple distributions. CALIBRATE_LAST_DIST_AMOUNT performs the analogous adjustment for the monetary amount on the last distribution. Parameter signatures are not enumerated in the ETRM metadata; parameter lists should not be assumed.

Tables Accessed

The package reads and writes a broad set of APPS synonyms. Setup and profile tables include FINANCIALS_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMS_ALL, and AP_PRODUCT_SETUP, which supply ledger, currency, and purchasing control options. FND_APPLICATION and FND_CURRENCIES provide application and currency validation.

Tax-related access spans AP_TAX_CODES, GL_TAX_OPTION_ACCOUNTS, and GL_DAILY_RATES, supporting tax determination and currency conversion on purchasing lines. GL_PERIOD_STATUSES is consulted to validate open accounting periods. Attachment handling uses FND_ATTACHED_DOCUMENTS and FND_DOCUMENTS_TL.

Organization and location data come from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL, and HZ_LOCATIONS, supporting ship-to, bill-to, and operating unit resolution during document creation.

Usage Notes

PO_INTERFACE_S is typically invoked by concurrent programs and other server-side packages rather than directly from Oracle Forms. The reference chain shows that PO_AUTOCREATE_DOC and PON_AUCTION_CREATE_PO_PKG call into it, indicating use during the Purchasing auto-create cycle and auction-to-order conversion. INV_PO_THIRD_PARTY_STOCK_MDTR also references it, extending its reach to third-party inventory processing.

Because the package is not a documented formal API, custom code calling it directly should treat it as an internal component: signatures and behavior may change between point releases and patches. Validation steps — exchange rates, tax codes, period status, and distribution balancing — are embedded in its procedures, so callers should ensure the required setup tables are populated before invocation. Testing should be performed after applying Purchasing or Financials patches, since dependency changes are not always highlighted in release notes.