Search Results po_fed_field_functions




Overview
Explore in AI Chat

Overview

APPS.PO_FED_FIELD_FUNCTIONS is a PL/SQL package in the Oracle E-Business Suite Purchasing (PO) module that serves the federal government extension of Oracle Procurement. Its principal business role is to populate and default the various federal-specific fields mandated by the Federal Acquisition Regulation (FAR) and related acquisition reporting requirements, covering information such as contracting office addresses, buyer and priority program designations, competitive sourcing data, item classification details, shipping information, and vendor customer designations. Rather than exposing these attributes through a single monolithic routine, the package is organized into a large set of narrowly scoped functions and procedures that the Purchasing user interface and business logic layers invoke independently. The object is registered in the APPS schema and confirmed with a VALID status, and it is documented in the ETRM as an API classified as OTHER. The package is referenced by five other packages, including PO_UDA_DEFAULTING_PKG, PO_AUTO_HEADER_PROCESS_PVT, PO_MULTI_MOD_PVT, PO_MULTI_MOD_VALIDATIONS, and PON_UDA_PKG, which indicates that it is deeply embedded in document defaulting, validation, and multi-organization modification flows rather than being an isolated utility.

Key Procedures and Functions

The documented interface exposes thirty-two procedures and functions. These are logically grouped as follows:

Parameter lists are not reproduced here; each routine is named according to the federal attribute block it services.

Tables Accessed

The package reads from a broad set of APPS synonyms reflecting the entities needed for federal defaulting and validation:

Usage Notes

PO_FED_FIELD_FUNCTIONS is invoked implicitly rather than directly by end users. It is called when the Purchasing forms or the AutoCreate process default federal fields onto requisitions, purchase orders, and purchase order releases; when multi-organization modifications and their validations run; and when User Defined Attribute defaulting logic executes through PO_UDA_DEFAULTING_PKG, PON_UDA_PKG, and PO_MULTI_MOD_PVT. Because the ETRM classifies it as OTHER rather than as a public API, custom code should treat it as an internal dependency and prefer supported extension points. Sites implementing federal acquisition reporting or the federal procurement extensions will see this package exercised routinely during document entry, document validation, and concurrent document processing.