Search Results okl_data_src_fnctns_pub




Overview
Explore in AI Chat

Overview

OKL_DATA_SRC_FNCTNS_PUB is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, with a status of VALID under Oracle Lease and Finance Management (OLFM/ETRM). Its name—Data Source Functions—indicates that it manages the metadata definitions for "data sources" or "data source functions" used by the OKL product suite. These definitions drive how lease and finance records pull or populate attribute values from various underlying sources. The package is classified as a public API (PUB), meaning it is intended for external invocation by forms, concurrent programs, or custom code, rather than being strictly private.

As a package body, it implements the interface declared in the corresponding package specification OKL_DATA_SRC_FNCTNS_PUB, delegating the bulk of the business logic to the private package OKL_DSF_PVT, which it references as a dependency. This layered design keeps the public surface stable while encapsulating implementation detail.

Key Procedures and Functions

The documented public interface contains eleven procedures/functions, including the standard multi-language support routine and the core CRUD plus validation operations:

  • ADD_LANGUAGE — Loads translated language rows for data source function metadata, supporting multi-language (MLS) installations.
  • INSERT_DATA_SRC_FNCTNS — Creates a new data source function definition record.
  • LOCK_DATA_SRC_FNCTNS — Acquires a row-level lock on an existing data source function record to serialize concurrent modification.
  • UPDATE_DATA_SRC_FNCTNS — Modifies attributes of an existing data source function definition.
  • DELETE_DATA_SRC_FNCTNS — Removes a data source function definition record.
  • VALIDATE_DATA_SRC_FNCTNS — Applies business validation rules to ensure the definition is consistent and usable before it is persisted or activated.

These routines follow the standard EBS API pattern, returning status and message information through the FND_API and FND_MSG_PUB infrastructure rather than raising unhandled exceptions. Parameter lists are not reproduced here; callers should consult the package specification for exact argument signatures.

Tables Accessed

Per the documented metadata, the only table accessed through APPS synonyms is PLITBLM. Within the EBS API framework, PLITBLM is the standard interface table that serves as the temporary message/error repository used by FND_MSG_PUB and OKC_API for accumulating the message stack across API calls. It is not a domain table of the OLFM data model. The package therefore persists its actual data source function definitions through routines implemented in OKL_DSF_PVT, while PLITBLM provides the transaction-scoped bookkeeping of validation and error messages.

Usage Notes

OKL_DATA_SRC_FNCTNS_PUB operates within the standard Oracle EBS API framework, depending on FND_API, FND_MSG_PUB, OKC_API, and its private counterpart OKL_DSF_PVT. It is the entry point for creating, maintaining, and validating data source function definitions, and is not referenced by any database object in the metadata—meaning it is invoked at runtime from the application layer rather than from triggers or other PL/SQL components. Typical callers include the OLFM setup forms that maintain data source function metadata, concurrent programs that load or migrate such definitions, and customer extension code that programmatically manages these records.

Because it is a public API, callers should supply the standard API parameters (such as p_init_msg_list, x_return_status, and x_msg_count) and inspect the returned status rather than relying on exceptions. It is referenced by three other packages, underscoring its role as a reusable, supported interface within the APPS schema. Always invoke the PUBLIC wrapper rather than calling OKL_DSF_PVT directly, so that validation, message handling, and locking semantics are consistently applied across EBS 12.1.1 and 12.2.2.