Results for “get_day_count”

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

Overview

OKL_STREAM_GENERATOR_PVT is a private PL/SQL package body in the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, part of the Enterprise Contracts and Transactions (ETRM) family. Its principal business function is the generation of payment and accounting streams that drive lease and finance contract cash flows, billing schedules, accrual entries, and present-value computations. The package operates on contract headers, line items, rate parameters, and party payment data stored in the OKC and OKL schema tables, applying date arithmetic, day-count conventions, and rounding rules to produce stream headers and elements consumed by downstream accounting and billing engines.

The user search term "get_stream_header" maps directly to the documented procedure GET_STREAM_HEADER, the entry point through which header-level stream attributes (currency, organization, dates, and deal type) are assembled before individual stream elements are generated.

Key Procedures and Functions

The package exposes 25 documented procedures and functions. Notable members include:

• GET_STREAM_HEADER — resolves and returns the header context for a stream, including contract identifiers, currency, authoring organization, and date boundaries.
• GET_STREAM_ELEMENTS — retrieves the line-level stream components that make up the detailed schedule.
• GET_ACCRUAL_ELEMENTS — returns accrual-related elements used for revenue and cost recognition entries.
• GENERATE_CASH_FLOWS, GENERATE_STREAMS — the core routines that build cash flow and payment stream records.
• GEN_VAR_INT_SCHEDULE — generates variable-interest schedules for contracts with floating or variable rates.
• CREATE_PV_STREAMS, CREATE_DISB_STREAMS — create present-value and disbursement streams respectively.
• GET_SCHED_PRINCIPAL_BAL, GET_PRESENT_VALUE — compute scheduled principal balances and present values.
• GET_STY_DETAILS, GET_DAY_COUNT, GET_MONTHS_FACTOR, ADD_MONTHS_NEW, GET_SEL_DATE, GET_NEXT_BILLING_DATE — utility routines for stream-type lookup, day-count computation, month factoring, date shifting, date selection, and next billing date determination.
• GENERATE_QUOTE_STREAMS, GENERATE_STREAMS_FOR_IA, PROSP_ADJ_ACC_STRMS — specialized generators for quotes, interest-accrual streams, and prospective adjustment accounting streams.

Tables Accessed

The package references the following tables through APPS synonyms:

• OKC_K_HEADERS_B, OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_TL — contract header base, all-organization, and translation tables supplying authoring organization, currency, and descriptive data.
• OKC_K_LINES_B, OKC_K_ITEMS — contractual line items that feed stream element generation.
• OKC_LINE_STYLES_B, OKC_STATUSES_B — line style and status lookups; a documented cursor checks for active SOLD_SERVICE lines excluding HOLD, TERMINATED, EXPIRED, and CANCELLED statuses.
• OKC_RULES_B, OKC_RULE_GROUPS_B — rules and rule groups governing payment and rollover behavior (for example, the LALEVL/LASLL/LASLH categories).
• OKL_K_HEADERS, OKL_K_LINES — lease-specific header and line extensions holding deal type and term duration.
• OKL_K_RATE_PARAMS — rate parameters used in interest and present-value calculations.
• OKL_PARTY_PAYMENT_HDR, OKL_PARTY_PAYMENT_DTLS — party payment header and detail records driving disbursement and billing streams.
• OKL_POOLS — pool definitions used in financing and interest computations.

Usage Notes

OKL_STREAM_GENERATOR_PVT is a private (PVT) package and is not intended for direct external invocation. It is referenced by 25 other packages within the OKL and OKC family, which act as public APIs and are in turn invoked by Oracle Lease Management forms, concurrent programs, and internal processing flows. Typical invocation points include lease booking and amendment processes, stream and cash flow regeneration programs, accrual and accounting generation routines, quote-to-contract conversion, and period-end processing. Custom extensions should call the documented public wrapper packages rather than this private body. Because the package manipulates rounding rules, currency, and day-count conventions across multiple organizations, any regeneration must respect setup captured in OKL_SYS_ACCT_OPTS and the system-level accounting options to preserve posting accuracy.