Search Results set_aside

Overview

APPS.PO_FED_FIELD_FUNCTIONS is a federal-specific PL/SQL package body within the Oracle Purchasing (PO) application. It encapsulates the field-derivation and address-handling logic used by Oracle EBS federal deployments, particularly where legislative mandates, funding, and supplier-designation requirements apply. The package exposes a broad set of "XD," "XLE," and "XPD" wrapper entry points that are paired with the standard Purchasing interface tables and forms. Its central business purpose is to resolve and populate address, contact, item, shipping, sourcing, and competitive-information attributes as they flow through requisition, purchasing, and supplier-related business objects. The address_xd reference, which appears in the excerpt and matching user search, is a directly invoked routine used by pr_addressdef and po_addressdef to derive address and contact details in federal document flows.

Key Procedures and Functions

• PR_ADDRESSDEF / PO_ADDRESSDEF — Federal address derivations for requisitions and purchase orders. They call ADDRESS_XD to populate location, address code, contact, and XML address/contact detail strings. PR_ADDRESSDEF initializes the address type from a hidden input and passes requisition context ('REQUISITIONS') to ADDRESS_XD.
• ADDRESS_XD — The core address-derivation routine invoked from within the address-definition wrappers.
• PO_ADDRESSES_XSC, PR_ADDRESSES_XSC, PR_ADDRESSES_XPD, PO_ADDRESSES_XPD, ADDRESSES_XLE — Address-handling entries aligned with Purchasing and Requisitioning document flows.
• BU_PRI_PRJ_INF_XLE, PR_BU_PRI_PRJ_INF_XPD, PO_BU_PRI_PRJ_INF_XPD — Business-unit and primary-project information derivations.
• FED_CUST_DESG_XLE, PO_FED_CUST_DESG_XPD — Federal customer-designation logic for purchasing documents.
• ADD_ITEM_INFO_XLE, ADD_ITEM_INFO_XD — Additional item information derivation.
• SHIP_INFO_XD, SHIP_INFO_XLE — Shipping information derivation and validation.
• PR_SOURCING_INFO_REQ_XPD — Sourcing information for requisitions.
• COMPETITIVE_INFO_XD, COMPETITIVE_INFO_XV — Competitive-information derivation and validation.
• DERIVE_INSP_ACCP_ADRS_DTLS — Derives inspection and acceptance address details from a given source.

Tables Accessed

The package reads from and writes to the following APPS-synonymed tables:

• AP_SUPPLIER_SITES_ALL, FV_CCR_VENDORS, HZ_PARTIES — Supplier site, CCR vendor, and party/address resolution.
• HR_LOCATIONS_ALL, HR_LOCATION_EXTRA_INFO, FND_TERRITORIES_TL — Location, extended location attributes, and territory/country descriptions.
• AP_CHECKS_ALL, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_PAYMENTS_ALL — Payment and invoice data for federal funding and acceptance determination.
• MTL_SYSTEM_ITEMS_TL — Item descriptions for item-information derivations.
• PER_ALL_PEOPLE_F, PER_PEOPLE_EXTRA_INFO, FND_USER — Contact and user resolution for address/contact detail population.
• FND_LOOKUP_VALUES — Reference lookup codes for federal address and designation types.

Usage Notes

PO_FED_FIELD_FUNCTIONS is invoked primarily from Oracle Purchasing and iProcurement forms and from federal-specific concurrent programs that populate the interface tables. It is referenced by five other packages, and its procedures are exposed for form-level and programmatic invocation. The address routines (PR_ADDRESSDEF, PO_ADDRESSDEF, ADDRESS_XD) are typically called when users enter or modify requisition or purchase-order addresses and contacts, while the project, sourcing, shipping, and competitive-information routines support federal compliance data collection. Custom code should reuse these public procedures rather than re-implementing derivation logic.