Search Results oke_funding_util_pkg




Overview
Explore in AI Chat

Overview

OKE_FUNDING_UTIL_PKG is a PL/SQL package body owned by the APPS schema within Oracle E-Business Suite, operating in the Oracle Knowledge Enterprise / Project Contracts (OKE) module. Its purpose is to provide utility and validation logic for funding sources and funding allocations associated with project contracts and agreements. In Oracle EBS transactions involving funded projects, the OKE module tracks funding pools, source amounts, allocation limits, and party-level funding commitments. OKEFUNDINGUTILPKG centralizes the validation and lookup routines that the funding APIs and concurrent processes rely upon to enforce business rules before data is committed. The package is classified as an OTHER API in the ETRM metadata and is currently in VALID status. It is referenced by five other database objects, indicating that it serves as a shared utility layer rather than an entry-point API.

Key Procedures and Functions

The package exposes approximately twenty-five documented procedures and functions. These cluster into logical groups:

  • Source Pool Validation: VALIDATESOURCEPOOLAMOUNT and VALIDATESOURCEPOOLDATE verify that a funding source pool amount and its effective date meet defined constraints.
  • Allocation Source Validation: VALIDATEALLOCSOURCEAMOUNT, VALIDATEALLOCSOURCELIMIT, VALIDATEALLOCSOURCEDATE, VALIDATESOURCEALLOCAMOUNT, VALIDATESOURCEALLOClIMIT, and VALIDATESOURCEALLOCDATE validate allocation amounts, limits, and dates against the underlying funding source.
  • Pool Party Validation: VALIDATEPOOLPARTYDATE and VALIDATEPOOLPARTYAMOUNT check party-level funding commitments for valid dates and amounts.
  • General Validation: VALIDATESTARTENDDATE ensures date range consistency; VALIDATEHARDLIMIT enforces hard funding limits; ALLOCATIONEXIST and CHECKAGREEMENTEXIST check for the existence of allocations and agreements respectively.
  • Lookup Utilities: GETCONVERSIONRATE retrieves currency conversion rates; GETPROJECTCURRENCY returns the currency of a project; GETOWNEDBY returns the owning party; GETAGREEMENTINFO returns agreement details.
  • Miscellaneous: MULTICUSTOMER determines whether multiple customers are associated with a funding arrangement; SAVEUSERPROFILE persists profile-related information.

Tables Accessed

The package reads and writes several core tables through APPS synonyms:

  • OKEKFUNDINGSOURCES — stores funding source definitions.
  • OKEK_FUND_ALLOCATIONS — stores allocation records against funding sources.
  • OKEPOOLPARTIES — maps funding pool parties.
  • PAAGREEMENTSALL, PAPROJECTSALL, PAPROJECTCUSTOMERS, PAIMPLEMENTATIONSALL — Projects module tables providing agreement, project, customer, and implementation context.
  • FNDCURRENCIES, FNDUSER — currency and user reference data.
  • PLITBLM — a PL/SQL table type used internally for bulk operations.

Usage Notes

OKEFUNDINGUTILPKG is not intended to be called directly by end users. It is invoked indirectly through the OKE funding public API (OKEFUNDINGPUB) and related forms and concurrent programs during funding source entry, allocation processing, and contract validation. Developers writing custom extensions may call its lookup functions such as GETPROJECTCURRENCY and GETCONVERSIONRATE, but should treat validation procedures as internal. Because the body depends on FNDAPI, FNDPROFILE, GLCURRENCYAPI, and OKEAPI, any customization must preserve those dependencies. The package has no downstream dependents listed beyond the five referencing objects, so its internal logic can be extended without broad impact, provided existing signatures remain unchanged.