Search Results is_clm_po

Overview

APPS.AP_CLM_PVT_PKG is the private helper package body for the Oracle Payables Commitment Less Management (CLM) integration in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business responsibility is to determine whether a given Purchasing document — a purchase order, purchase order line, line location, or distribution — participates in a funds commitment and control workflow, and to retrieve the associated funding information required by downstream Payables processing. The package abstracts the CLM franchise logic so that calling modules do not need to understand the underlying commitment control configuration. The header comment identifies the file as apclmpfb.pls with a version stamp of 120.0.12010000.5 dated 2010/03/23, confirming its long-standing presence across the 11i and R12 code lines.

Key Procedures and Functions

• IS_CLM_INSTALLED — Returns a flag indicating whether the CLM functionality is currently installed and enabled in the environment. Callers use this as a guard before attempting any deeper CLM-specific logic, avoiding unnecessary processing when the feature set is inactive.
• IS_CLM_PO — Determines whether the supplied Purchasing entity is a CLM-controlled purchase order. The implementation delegates to PO_CLM_INTG_GRP.IS_CLM_PO, passing the purchase order header identifier and returning 'Y' or 'N' (default 'N'). The function declares a local constant naming the API, a debug buffer, and a return variable initialised to 'N'. Exceptions are trapped in a WHEN OTHERS handler that prints diagnostic information rather than propagating the error. As documented, the function accepts a purchase order header identifier, purchase order line identifier, line location identifier, and distribution identifier, all defaulted to NULL.
• GET_FUNDING_INFO — The procedure most frequently searched by users. It supplies funding information for a Payables or Purchasing entity, forming the bridge between the CLM commitment records and Payables payment and invoice processing. No parameter list is documented in the ETRM extract; the procedure should be referenced by name and its interface obtained from the live database rather than assumed.

Tables Accessed

• PO_DISTRIBUTIONS_ALL — The distribution-level expense records from Purchasing. CLM logic interrogates distributions to associate funding and commitment data at the most granular accounting level.
• PO_LINE_LOCATIONS and PO_LINE_LOCATIONS_ALL — Shipment and schedule lines that carry quantity and price context. These are read to resolve the Purchasing document hierarchy when validating whether a location qualifies as CLM-controlled.

Usage Notes

The package is classified as OTHER in the ETRM repository, meaning it is an internal private API rather than a formally published public interface. It is referenced by three other packages, indicating that other Payables or Purchasing components depend on its CLM evaluation and funding lookup results. It is therefore normally invoked indirectly — from concurrent programs, forms, or custom PL/SQL that already holds a Purchasing context — rather than by end users. Developers diagnosing funding or commitment errors should trace calls into AP_CLM_PVT_PKG and confirm that IS_CLM_INSTALLED and IS_CLM_PO return the expected values before examining GET_FUNDING_INFO output. Because of its private status, direct dependencies on this package should be treated as upgrade-sensitive across 12.1.1 and 12.2.2.