Search Results rcv_transactions_n1

Overview

APPS.PA_PO_INTEGRATION_UTILS is a utility package body in Oracle E-Business Suite that supports the integration between Oracle Purchasing (PO) and Oracle Projects (PA). Its principal purpose is to enforce the business rules that govern when project information can be added to, or changed on, a purchase order distribution, and to validate that the associated receipts have been correctly interfaced to Projects. The package sits at the boundary between procurement execution and project cost collection, ensuring that commitment and actual cost data flow consistently into the Projects subsystem. The header comment (PAPOUTLB.pls, version 120.8) confirms the object is a long-standing component of the Projects suite, and the presence of an "noship" designation indicates it is an internal, non-shipped support object invoked by other application code rather than exposed to end users directly.

Key Procedures and Functions

• PA_USER_PO_ACCESS_CHECK — Determines whether a given user is permitted to access a purchase order in the context of project-related processing. It centralizes the access guard logic so that downstream routines can validate user privilege before allowing project information to be touched.
• PA_USER_PO_ACCESS_PROJ — Companion access routine that resolves the project context for a user's purchase order access, supporting the same authorization checks at the project level.
• ALLOW_PROJECT_INFO_CHANGE — The core validation function. Per its documented comment, it checks whether the sum of receipts interfaced to Projects for a purchase order distribution is zero; if the sum is zero it returns 'Y', otherwise 'N'. It additionally returns 'N' when any un-interfaced line to Projects exists (referencing bug 4049925). The implementation queries RCV_TRANSACTIONS and RCV_RECEIVING_SUB_LEDGER, filtering on PA_ADDITION_FLAG in ('Y','I') and specific destination/transaction type combinations (EXPENSE, RETURN TO VENDOR, RETURN TO RECEIVING), with adjustments tracked against bugs 4049925 and 4630478.
• GETPOLINENUM — Retrieves the associated purchase order line number, used by callers that must display or validate PO line context alongside project information.
• UPDATE_PA_ADDITION_FLG — Updates the PA additional flag that marks whether receipts have been added to Projects, maintaining the interface status flags consumed by the Projects cost collection process.
• VALIDATE_NOVATION_PROJECTS — Validates project information during novation processing, ensuring that project references remain consistent when a contract or award is novated.

Tables Accessed

The package reads and writes across the Purchasing, Receiving, HR, Trading Community, and Projects schemas. PO_DISTRIBUTIONS_ALL is central to the distribution-level checks, while RCV_TRANSACTIONS and RCV_RECEIVING_SUB_LEDGER (referenced in the function body) provide the receipt and sub-ledger data used to compute interfaced amounts. FND_USER and HR_ALL_ORGANIZATION_UNITS support user and organization resolution for access checks; HZ_PARTIES and PA_CI_SUPPLIER_DETAILS support party and supplier context; MTL_SYSTEM_ITEMS supplies item validation; and OKC_DELIVERABLES and OKC_RESP_PARTIES_TL provide contract deliverable and responsibility data. The Projects-side tables — PA_BUDGETARY_CONTROLS, PA_BUDGETARY_CONTROL_OPTIONS, PA_BUDGET_ENTRY_METHODS, PA_BUDGET_LINES, PA_BUDGET_TYPES, PA_BUDGET_VERSIONS, and PA_CONTROL_ITEMS — are used to evaluate budgetary control and control-item rules before permitting project information changes.

Usage Notes

PA_PO_INTEGRATION_UTILS is an internal utility rather than a public API; the ETRM classification records it as "OTHER" and notes it is referenced by three other packages. It is typically invoked from Purchasing and Projects forms, from the receipt-to-Projects interface concurrent programs, and from custom extensions that must replicate the same validation rules when updating project information on PO distributions. Because ALLOW_PROJECT_INFO_CHANGE evaluates interfaced receipt balances, callers should invoke it before any update to project information and honor a returned 'N' as a hard block. Direct modification of the package is not supported.