Search Results oke_fundsource_pvt




Overview
Explore in AI Chat

Overview

OKE_FUNDSOURCE_PVT is a private PL/SQL package in the APPS schema that encapsulates the core funding-source and funding-allocation logic used by Oracle E-Business Suite's Project Contracts (OKE) module. In the Oracle EBS 12.1.1 and 12.2.2 environments, this package sits beneath the public funding APIs and acts as the transactional engine that creates, maintains, and removes funding records attached to contract headers and funding pools. Its "PVT" designation indicates it is an internal implementation package rather than a published interface; it is not intended for direct customer invocation, and its procedures are reached only through the higher-level public packages that wrap them.

Functionally, the package manages the relationship between a contract or project and the organizations, customers, and project agreements that finance it. It resolves currency conversions, validates lookup values, and writes to both the base tables (OKE_K_FUNDING_SOURCES, OKE_K_FUND_ALLOCATIONS, OKE_K_HEADERS) and the corresponding _S (sequence) table used by the OKE entity framework. In this respect it is a supporting component for funding distribution across projects administered in Oracle Projects.

Key Procedures and Functions

  • CREATE_FUNDING — Inserts a new funding record, establishing the funding source for a contract or project and populating the associated allocation and sequence-table rows.
  • UPDATE_FUNDING — Modifies an existing funding record, applying changes to funding amounts, source party, currency, conversion type, or related allocation details.
  • DELETE_FUNDING — Removes a funding record and its dependent allocation/sequence data, maintaining referential integrity with the contract header.
  • FETCH_CREATE_FUNDING — Retrieves the attributes required to populate or validate a funding record prior to insertion, typically supporting the create flow and UI defaulting.
  • GET_FUNDING_REC — Returns a single funding record (or its key attributes) for a given funding identifier, used for query and display purposes.

Six documented procedures/functions exist in total, with the operations above forming the documented set. Parameter lists are deliberately not reproduced here; consult the package specification for exact signatures.

Tables Accessed

Tables are reached through APPS synonyms. The OKE base tables — OKE_K_FUNDING_SOURCES, OKE_K_FUNDING_SOURCES_S, OKE_K_FUND_ALLOCATIONS, and OKE_K_HEADERS — are the primary read/write targets. OKC_K_HEADERS_B and OKC_K_PARTY_ROLES_B supply contract header and party-role context. PA_PROJECTS_ALL, PA_AGREEMENTS_ALL, and PA_IMPLEMENTATIONS_ALL provide Oracle Projects information for funding distributions and implementation checks. HR_ALL_ORGANIZATION_UNITS and HZ_CUST_ACCOUNTS resolve the funding organization and customer account. FND_CURRENCIES, FND_LOOKUP_VALUES, and GL_DAILY_CONVERSION_TYPES support currency and lookup validation, while OKE_POOL_PARTIES supports funding-pool party resolution.

Usage Notes

OKE_FUNDSOURCE_PVT is invoked indirectly. The dependency metadata shows it is referenced by OKE_AGREEMENT_PVT, OKE_FUNDING_PUB, OKE_VERSION_PVT, and internally by itself, meaning funding operations initiated through the Project Contracts forms, the OKE public funding API, or versioning logic ultimately call these private routines. Custom code should target OKE_FUNDING_PUB or the documented public APIs rather than this package, since Oracle may change private signatures during patching or upgrades. In 12.2.2 the package is VALID and remains an active internal component of the OKE funding chain.