Results for “prosp_adj_acc_strms”

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

Overview

OKL_STREAM_GENERATOR_PVT is a private (PVT) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, released under the APPS schema with AUTHID CURRENT_USER. Its principal business function is the generation of cash flow streams and payment schedules for lease and loan contracts. Leasing contracts require the systematic derivation of dated cash flows, accrual entries, interest schedules, and present-value calculations across the contract term. This package encapsulates the algorithms that translate contract terms — principal, rate, frequency, structure, and arrears indicators — into concrete stream records stored in the OKL tables. It is designated private, meaning it is intended for internal consumption by other OKL packages and APIs rather than direct invocation by external integrations. The header comment indicates a version lineage extending through 2009 (120.17), reflecting long-standing stability in the 12.1.1 and 12.2.2 code lines. The package spec declares numerous application-level constants derived from OKL_API and defines three PL/SQL collection types: cash_flow_rec and cash_flow_tbl for dated cash flow amounts, payment_rec_type and payment_tbl_type for payment schedule components, and rate_rec_type for IRR and yield metrics.

Key Procedures and Functions

The package exposes twenty-five documented procedures and functions, grouped by function:

• Date and period utilities: GET_MONTHS_FACTOR, ADD_MONTHS_NEW, GET_SEL_DATE, GET_DAY_COUNT, GET_NEXT_BILLING_DATE — perform date arithmetic, day-count conventions, and billing cycle derivation.
• Stream retrieval: GET_STREAM_HEADER, GET_STREAM_ELEMENTS, GET_ACCRUAL_ELEMENTS — fetch and return stream header and line-level element data for a contract.
• Stream generation: GENERATE_CASH_FLOWS, GENERATE_STREAMS, GEN_VAR_INT_SCHEDULE, CREATE_PV_STREAMS, CREATE_DISB_STREAMS, GENERATE_QUOTE_STREAMS, GENERATE_STREAMS_FOR_IA, PROSP_ADJ_ACC_STRMS — build cash flows, variable interest schedules, present-value streams, disbursement streams, quotation streams, and prospective adjustment accrual streams.
• Balance and valuation: GET_SCHED_PRINCIPAL_BAL, GET_PRESENT_VALUE — return scheduled principal balance and compute present value.
• Style and structure: GET_STY_DETAILS — resolve line style attributes controlling stream behavior.

Tables Accessed

The package references contract and rule data through APPS synonyms. Core contract structures are OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_B, OKC_K_HEADERS_TL, OKC_K_ITEMS, and OKC_K_LINES_B, providing header, item, and line context. OKC_LINE_STYLES_B and OKC_STATUSES_B supply style and status lookups, while OKC_RULES_B and OKC_RULE_GROUPS_B deliver rule definitions governing stream generation. OKL-specific tables include OKL_K_HEADERS, OKL_K_LINES, OKL_K_RATE_PARAMS, OKL_POOLS, OKL_PARTY_PAYMENT_HDR, and OKL_PARTY_PAYMENT_DTLS, holding lease header, rate parameter, pool, and party payment detail data. These are read to resolve contract terms and written where generated stream and payment records must be persisted.

Usage Notes

As a private package, OKL_STREAM_GENERATOR_PVT is invoked internally by other OKL packages — the metadata records that it is referenced by twenty-five other packages. It is typically called during contract booking, stream regeneration, quotation pricing, present-value computation, and prospective adjustment processing. It is not exposed directly to Oracle Forms or concurrent programs; those layers call higher-level public APIs (such as OKL_API-based wrappers) that in turn invoke this generator. Customizations should avoid direct calls and instead rely on the supported public entry points, since the private interface may change between patch levels. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the calling schema, an important consideration when troubleshooting privilege-related errors in custom code.