Results for “frequency_schedule_tbl”
1 result
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
LNS_FIN_UTILS is a financial calculation utility package owned by the APPS schema within the Oracle E-Business Suite Leasing (LNS) module. Its classification in the ETRM repository is OTHER, indicating it functions as a shared library of financial primitives rather than a transactional API. The package is declared with AUTHID CURRENT_USER, meaning that its unqualified object references resolve through the privileges of the invoking session, and it relies on APPS synonyms to reach the underlying LNS base tables.
The business purpose of LNS_FIN_UTILS is to centralize the date arithmetic, day-count convention handling, interest rate conversion, and amortization schedule generation logic required by leasing and loan contracts. The PL/SQL specification declares public data types including DATE_TBL, PAYMENT_SCHEDULE, PAYMENT_SCHEDULE_TBL, FREQUENCY_SCHEDULE, and FREQUENCY_SCHEDULE_TBL, which are used to pass structured payment and frequency information between the package and its callers. Because these types are exposed in the specification, other packages can consume them directly when constructing or interpreting loan schedules.
Key Procedures and Functions
The package exposes twenty-six documented procedures and functions, which fall into several functional groupings.
- Date and calendar utilities: GETNEXTDATE returns the next date according to an interval type and direction. GETDAYCOUNT computes the number of days between two dates under a specified day-count method. DAYSINYEAR returns the number of days in a year based on a year-count method. JULIAN_DATE converts a date to its Julian representation. ISLEAPYEAR determines whether a given year is a leap year. INTERVALSINPERIOD counts the number of intervals occurring between two period types.
- Payment schedule construction: BUILDPAYMENTSCHEDULE, BUILDSIPPAYMENTSCHEDULE, and BUILDPAYMENTSCHEDULEEXT generate payment schedules from loan parameters such as start date, maturity date, first payment date, number of intervals, and whether payments are made in arrears. GETPAYMENTSCHEDULE retrieves an existing schedule, while GETAMORTSCHEDCSV produces an amortization schedule in CSV format. GETINSTALLMENTDATE and GETNUMBERINSTALLMENTS derive installment timing and counts, and GETNEXTINSTALLMENTAFTERDATE and GETNEXTINSTFORDISBURSEMENT locate the next installment relative to a given date or disbursement event.
- Rate and maturity calculations: GETMATURITYDATE derives the maturity date of a loan. GETACTIVERATE and GETRATEFORDATE return the applicable interest rate for a given context or date. CONVERTRATE performs rate conversion, and CONVERTPERIOD converts between period conventions.
Tables Accessed
LNS_FIN_UTILS references a defined set of LNS tables through APPS synonyms. LNS_LOAN_HEADERS_ALL supplies the primary loan header terms. LNS_TERMS provides contractual term definitions. LNS_DISB_HEADERS and LNS_DISB_LINES hold disbursement header and line details consumed by the disbursement-related installment functions. LNS_INT_RATE_LINES, LNS_RATE_SCHEDULES, and LNS_FREQ_SCHEDULES support rate lookup and frequency determination. LNS_CUSTOM_PAYMNT_SCHEDS stores custom payment schedules that may override or supplement standard schedules. Utility dependencies include DBMS_LOB for large object handling (notably for CSV amortization output), DUAL for single-row arithmetic, and PLITBLM for PL/SQL table maintenance.
Usage Notes
This package is normally invoked indirectly. It is referenced by fourteen other packages, indicating that it serves as a foundational layer for higher-level leasing APIs and business logic rather than being called directly from Oracle Forms or concurrent programs. Typical invocation paths include loan origination processing, payment schedule recalculation, and amortization reporting where a calling package needs consistent date, day-count, rate, or schedule behavior. Custom extensions should call the documented public functions rather than reimplementing day-count or schedule logic, ensuring that leap-year handling, interval arithmetic, and rate conversion remain consistent with the standard LNS calculation model.
-
PACKAGE: APPS.LNS_FIN_UTILS 12.2.2