Search Results po_clm_intg_grp




Overview
Explore in AI Chat

Overview

PO_CLM_INTG_GRP is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The suffix "GRP" identifies it as a group or utility-layer package within the Oracle Procurement module family, distinguished from the standard public APIs that carry the "API" classification. Its documented status is VALID, and it is referenced by 52 other database objects, indicating that it occupies a central position in the dependency graph of purchasing and sourcing components.

The business function of PO_CLM_INTG_GRP is to support the Contract Lifecycle Management (CLM) integration points within Oracle Purchasing. The procedure names collectively describe a facility that identifies whether Oracle CLM is installed, determines whether a given purchasing document is governed by CLM contract terms, and surfaces the funding information associated with those documents. This package therefore acts as the decision layer that Oracle Purchasing uses to decide whether CLM-specific validation, funding, and rendering logic must be applied to a transaction.

Key Procedures and Functions

  • IS_CLM_INSTALLED — Determines whether the Oracle CLM integration is active in the current environment. This acts as a gating check so that CLM-dependent logic is bypassed in installations where the feature has not been licensed or configured.
  • IS_CLM_PO — Evaluates a given purchase order to determine whether it falls under CLM processing, allowing downstream code to branch between standard and CLM-aware behavior.
  • IS_CLM_DOCUMENT — Provides a more general document-level test, identifying whether the document under consideration is a CLM-managed document rather than a conventional purchasing document.
  • GET_FUNDING_INFO — Retrieves funding information associated with the document, supplying the amounts and references required by the funding validation and display logic elsewhere in the procurement flow.
  • HIDE_NONFUNDED — Supports the UI and validation layer by determining whether non-funded lines or distributions should be suppressed from display or further processing.

Tables Accessed

The package reads and writes the core Oracle Purchasing tables through APPS synonyms. PO_HEADERS_ALL, PO_LINES_ALL, and PO_LINE_LOCATIONS_ALL supply the document header, line, and shipment/schedule detail used to classify a document and resolve its funding source. PO_DISTRIBUTIONS_ALL holds the accounting distributions examined during funding evaluation. PO_DOC_STYLE_HEADERS identifies the document style, which is relevant when deciding whether CLM rules apply. The requisition-side tables — PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, and PO_REQ_DISTRIBUTIONS_ALL — extend the same CLM determination and funding logic to the sourcing and requisition stage, where CLM-controlled demand frequently originates.

Usage Notes

PO_CLM_INTG_GRP is not a user-facing API. It is invoked internally by Oracle Purchasing forms, by concurrent programs that process purchasing documents, and by other PL/SQL packages that must make CLM-aware decisions. Because 52 objects reference it, customizations that modify or wrap this package carry a wide blast radius and should be undertaken only with full dependency analysis. The package depends on FND_API and FND_PROFILE for error handling and profile-option resolution, and on PO_CORE_S and PO_LOG for core purchasing utilities and logging. The documented API classification GRP indicates that Oracle does not support direct external calls to these procedures; implementers requiring CLM-aware behavior should rely on the supported purchasing APIs and let PO_CLM_INTG_GRP be invoked through the standard transaction flow.