Results for “okl_open_int_pub”
40 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_OPEN_INT_PUB is a public PL/SQL API package owned by APPS in Oracle EBS 12.1.1 / 12.2.2. It serves the Oracle Lease and Finance Management (OKL) product line, specifically the Open Interest functionality. The Open Interest concept in OKL allows a lessor to hold a residual interest in a leased asset after the lease term ends, with the customer or a third party retaining an "open" obligation over that interest. This package exposes the business logic required to create, maintain, and validate those Open Interest records from outside the OKL schema.
The package is classified as PUB in the ETRM metadata, meaning its procedures are intended for external invocation by forms, concurrent programs, or custom code. It is built as an AUTHID CURRENT_USER package, so it executes with the privileges of the calling session rather than the owner, and it relies on the OKC_API package for standard message list handling, return status tokens, and error constants. The header declares a set of global constants (G_PKG_NAME, G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLERRM_TOKEN, G_SQLCODE_TOKEN) and a package exception G_EXCEPTION_HALT_VALIDATION used to signal validation failures that should stop processing.
The package subtypes oinv_rec_type and oinv_tbl_type from OKL_OIN_PVT, indicating a private worker package (_PVT) that holds the actual implementation, while the public package acts as the supported interface layer.
Key Procedures and Functions
The ETRM metadata documents 10 procedures/functions. The principal entry points are:
- INSERT_OPEN_INT — Creates new Open Interest records. It is overloaded to accept either a single record (
p_oinv_rec) or a table of records (p_oinv_tbl), returning the created record(s) with any generated identifiers. It follows the standard OKC API signature withp_api_version,p_init_msg_list, and the standardx_return_status,x_msg_count, andx_msg_dataout parameters. - LOCK_OPEN_INT — Acquires a lock on Open Interest record(s) to support concurrency control, also overloaded for single record and table input.
- UPDATE_OPEN_INT — Modifies existing Open Interest records.
- DELETE_OPEN_INT — Removes Open Interest records.
- VALIDATE_OPEN_INT — Performs business-rule validation on Open Interest data prior to persistence, allowing callers to reject invalid data before an insert or update.
Because the source excerpt is truncated, full parameter lists for the later procedures are not reproduced here; their presence and primary purpose are stated based on the documented procedure inventory.
Tables Accessed
The ETRM metadata lists the referenced table via APPS synonym as PLITBLM. This is a multi-purpose technical table commonly used within EBS to hold temporary or process-specific row data, and OKL's Open Interest processing utilizes it as part of its data handling logic.
Usage Notes
OKL_OPEN_INT_PUB is typically invoked from the Oracle Lease and Finance Management forms that manage Open Interest, from concurrent programs that batch-process Open Interest records, and from custom extensions or integrations that need to create or maintain Open Interest data programmatically. The package is referenced by three other packages according to the metadata, confirming it is a supported dependency in the OKL API layer.
Callers should initialize the message list appropriately via p_init_msg_list, check x_return_status after every call, and drain messages using the standard OKC API message retrieval routines. Because the package is AUTHID CURRENT_USER, the calling application must have the necessary object privileges on the underlying tables and worker packages.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1