Results for “create_streams”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.OKL_ACCRUAL_SEC_PUB package body is a public API wrapper within the Oracle Lease and Finance Management (OKL) application module of Oracle E-Business Suite. It belongs to the accrual securitization functional area, which governs the generation and cancellation of accounting streams associated with securitized lease contracts. Securitization in lease management involves converting lease receivables into marketable financial instruments; the accrual streams generated by this package represent the periodic accrual entries that must be recorded against those securitized contracts. The package is classified as a PUB (public) API, indicating that it is a supported integration point intended to be called by external programs, forms, and concurrent processes rather than solely within the internal private layer.
As a thin public wrapper, OKL_ACCRUAL_SEC_PUB does not itself contain the core business logic. Instead, it delegates processing to the private package OKL_ACCRUAL_SEC_PVT while providing standardized API error handling consistent with the Oracle Applications Framework PL/SQL API conventions defined in FND_API and FND_MSG_PUB. This separation of public and private layers is the standard ETRM architectural pattern, ensuring that the internal implementation can evolve without breaking documented, supported entry points.
Key Procedures and Functions
Two documented procedures are exposed by this package:
- CREATE_STREAMS — Establishes the accrual securitization streams for a lease contract identified by the supplied contract/holder reference parameter (
p_khr_id). It accepts the standard API parameters (p_api_version,p_init_msg_list) and returns the standard outcome parameters (x_return_status,x_msg_count,x_msg_data). Internally it invokes the corresponding procedure inOKL_ACCRUAL_SEC_PVTand translates the private-layer return status into the appropriateFND_APIexception. - CANCEL_STREAMS — Cancels accrual securitization streams for lease contracts. In addition to the standard API signature and the contract reference, it accepts a cancellation date (
p_cancel_date) that determines the effective point from which streams are reversed or terminated. LikeCREATE_STREAMS, it delegates to the private package and applies the same standardized exception handling.
Tables Accessed
The ETRM metadata for this package lists no directly referenced tables via APPS synonyms. This is expected: because OKL_ACCRUAL_SEC_PUB is a pass-through wrapper, all SQL and DML activity is performed inside OKL_ACCRUAL_SEC_PVT. The underlying private package writes accrual stream records to the OKL stream and accrual tables and reads lease contract header and line data. Consumers should treat OKL_ACCRUAL_SEC_PUB as a transactional API rather than a query interface. No direct table grants or synonyms need be considered when invoking the public layer.
Usage Notes
This package is typically invoked during securitization processing, either from the Lease Management forms when a user initiates stream generation or cancellation, or from concurrent programs that batch-process accruals across portfolios of securitized contracts. Because it is a documented PUB API, custom code may also call it directly, provided callers adhere to the standard contract: initialize the message list as required, pass a valid p_khr_id, and inspect x_return_status for FND_API.G_RET_STS_SUCCESS before proceeding. Any error or unexpected error condition is captured automatically through FND_MSG_PUB.Count_and_get, so callers should retrieve and log messages on failure. The metadata indicates the package is referenced by zero other packages within ETRM, confirming that it is an entry point rather than a shared internal dependency. Note the header comment records a 2003 creation date and a "noship" designation, meaning the package ships with the application but is not exposed on the standard shipping manifest of dependent objects.