Search Results po_partial_funding_pkg




Overview
Explore in AI Chat

Overview

APPS.PO_PARTIAL_FUNDING_PKG is a PL/SQL package in Oracle E-Business Suite that supports partial funding on purchasing documents. It is used to determine whether a document participates in funding controls, to recalculate funded values at the header and distribution level, and to reconcile funding information across approvals, changes, and renegotiations. The package is defined with AUTHID CURRENT_USER, indicating it executes with the privileges of the calling schema. It is part of the broader Procurement and Contingent Liability Management (CLM) control framework, which constrains commitments and obligations against available funds. In Oracle EBS 12.1.1 and 12.2.2, the package is most relevant when purchasing documents such as purchase orders and requisitions must be evaluated for funding eligibility and funded-value computation.

Key Procedures and Functions

  • IS_CLM_DOCUMENT — returns whether a given document type and document level identifier correspond to a CLM-controlled document. This is the function most directly associated with the search term "is_clm_document," and it gates other funding-related logic.
  • IS_CLM_ENABLED — returns whether CLM functionality is enabled in the current environment.
  • IS_ACRN_ENABLED — returns whether Account Classification Reference Number (ACRN) processing is enabled for the specified organization, an indicator tied to project-based funding controls.
  • RECALCULATE_PF_ATTRIBUTES — recalculates partial funding attributes for a given document header, refreshing stored funded values after changes.
  • UPDT_FUNDING_INFO — updates funding information for a document based on the document type, header, and optional draft identifier, returning a status.
  • GET_CHANGE_IN_FUNDS — computes the change in funded value for a distribution, supporting incremental funding adjustments during modifications.
  • UPDT_FUNDS_SPLIT — updates funding information when a requisition line is split, ensuring funded amounts remain aligned.
  • GET_FUNDED_VALUE — returns the funded value for a document at the header, line, shipment, or distribution level.

Tables Accessed

The package reads and may write to the following tables through APPS synonyms:

Usage Notes

The package is invoked from purchasing forms, approval workflows, and internal concurrent or PL/SQL processes that manage partial funding. It is referenced by 13 other packages, indicating it is a shared dependency rather than a standalone API. Custom code should not call funding-update routines directly unless it replicates the standard approval flow, since misaligned funded values can corrupt funding controls. IS_CLM_DOCUMENT is typically called first to confirm that a document is subject to CLM before proceeding with funding calculations. Because behavior depends on system parameters, document styles, and organization setup, testing must span both 12.1.1 and 12.2.2 environments.