Search Results g_log_head

Overview

PO_SOURCING_GRP is a group-type PL/SQL package body in the APPS schema that serves as a high-level orchestration wrapper for the Oracle E-Business Suite sourcing and procurement workflow. In Oracle EBS 12.1.1 and 12.2.2, the "GRP" classification denotes a grouping package that coordinates calls across lower-level private APIs and public interfaces rather than exposing granular column-level operations. PO_SOURCING_GRP is tightly coupled to PO_SOURCING_PVT, the private sourcing engine, and handles the interface-oriented and auction-related operations that fall outside the core transactional logic. Its documented status is VALID, confirming that the compiled body is deployment-current in the environment inventoried by ETRM. The package encapsulates the creation of sourcing-related header records and the cleanup of staging/interface data, providing a controlled entry point for concurrent programs, forms, and custom extensions that need to manipulate sourcing structures without directly touching base tables.

Key Procedures and Functions

The ETRM documentation identifies two public entry points within PO_SOURCING_GRP:

• CREATE_CPA — Creates a CPA (Cost Plus Award / sourcing agreement) header record. This routine drives header creation logic coordinated with PO_SOURCING_PVT and the PO headers structures, and it returns status through the FND_API / FND_MSG_PUB message stack. It is the primary write path published by this package.
• DELETE_INTERFACE_HEADER — Removes or purges a header row from the sourcing interface staging table, PO_HEADERS_INTERFACE. This procedure supports interface cleanup, retry handling, and error recovery in sourcing data loads.

Both procedures follow the standard Oracle EBS API conventions: a p_ prefix for parameters, x_ prefix for out parameters, and reliance on FND_MSG_PUB for message retrieval. Parameter lists are not included in the documented metadata and are therefore not reproduced here.

Tables Accessed

PO_SOURCING_GRP references four base tables through APPS synonyms:

• PON_AUCTION_HEADERS_ALL — Auction header storage for negotiation/sourcing events; read/written in support of auction-integrated sourcing.
• PON_BID_HEADERS — Supplier bid headers linked to auction events, supporting bid comparison and award.
• PO_HEADERS_ALL — The core purchasing document header table, including CPAs and agreements; the target of CREATE_CPA output.
• PO_HEADERS_INTERFACE — The sourcing interface staging table; populated by external loads and purged by DELETE_INTERFACE_HEADER.

Additional dependencies include FND_API, FND_MSG_PUB, PO_DEBUG, PO_SOURCING_PVT, and the STANDARD package. No other database object references PO_SOURCING_GRP, indicating a top-of-stack consumer package.

Usage Notes

PO_SOURCING_GRP is typically invoked from the Sourcing and Procurement forms and from concurrent programs that create CPAs or manage interface staging data. Custom code should call CREATE_CPA rather than inserting directly into PO_HEADERS_ALL, ensuring validations, defaults, and message handling remain consistent. DELETE_INTERFACE_HEADER is appropriate for cleanup routines following failed or duplicate interface loads. Because the package depends on PO_SOURCING_PVT for core logic, any modifications to sourcing business rules should be reviewed against both packages to avoid divergence. Callers should always inspect the FND_MSG_PUB stack after invocation to confirm success or capture diagnostics.