Results for “oke_k_fund_allocations_s”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKE_ALLOCATION_PVT is a private (PVT) PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Enterprise Contracts (OKE/OKC) module, specifically the funding allocation functionality of Oracle Project Contracts. In the context of Oracle EBS 12.1.1 and 12.2.2, this package implements the business logic that links contract funding sources to project funding records — that is, it manages how a contract's funding is distributed or "allocated" across a project's funding structures.

The package exists primarily to support the OKE_K_FUND_ALLOCATIONS table, which stores the allocation records that tie a contract line's funding source to a project funding entry. Rather than exposing these operations directly to end users, OKC_ALLOCATION_PVT provides the internal add, update, delete, and query services used by the public funding allocation API (OKE_FUNDINGALLOCATION_PVT) and by the contracts forms and concurrent programs that maintain funding. The name the user searched for, OKE_K_FUND_ALLOCATIONS_S, is the database sequence used to generate primary keys for the allocation records this package manipulates.

Key Procedures and Functions

The documented package exposes four procedures/functions:

• ADD_ALLOCATION — Creates a new funding allocation record, populating the OKE_K_FUND_ALLOCATIONS row from the supplied allocation details and generating the primary key from the OKE_K_FUND_ALLOCATIONS_S sequence.
• UPDATE_ALLOCATION — Modifies an existing allocation record, applying changes to allocation amounts, percentages, or associated project funding references.
• DELETE_ALLOCATION — Removes an allocation record, reversing the link between the contract funding source and the project funding entry.
• GET_ALLOCATION_TBL — Retrieves a collection (table) of allocation records, typically used to populate the funding allocation block in the contracts form or to drive downstream processing.

Each routine adheres to the OKE API conventions, including the FND_API error-handling framework (FND_API and FND_GLOBAL for message and session context).

Tables Accessed

The package reads from and writes to the following documented tables via APPS synonyms:

• OKE_K_FUND_ALLOCATIONS and its sequence OKE_K_FUND_ALLOCATIONS_S — the primary allocation store and key generator.
• OKE_K_FUNDING_SOURCES, OKE_K_HEADERS, OKE_K_LINES (plus _V views and OKC_K_LINES_B, OKC_K_VERS_NUMBERS) — contract header, line, and funding source context for each allocation.
• PA_PROJECTS_ALL, PA_PROJECT_TYPES_ALL, PA_PROJECT_CUSTOMERS, PA_PROJECT_FUNDINGS, PA_TASKS, PA_AGREEMENTS_ALL, and PA_FIN_STRUCTURES_LINKS_V — project-side funding and agreement data that the allocation reconciles against.
• HZ_CUST_ACCOUNTS — customer account validation for the associated contract party.
• GL_DAILY_CONVERSION_TYPES and FND_LOOKUP_VALUES — currency conversion type and lookup validations.

Usage Notes

OKE_ALLOCATION_PVT is a private API and is not intended for direct invocation by custom code; external integration should use OKC_ALLOCATION_PUB or the funding allocation public APIs instead. It is invoked internally by the Oracle Contracts form (funding allocation block), by concurrent programs that process funding, and by OKE_FUNDINGALLOCATION_PVT and OKE_FUNDING_UTIL_PKG. The package is referenced by four other packages and does not itself reference a public interface, confirming its role as an internal utility supporting project funding allocation across contract versions in both 12.1.1 and 12.2.2.