eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_EXT_LOAN_PUB dependencies on LNS_FIN_UTILS

Line 1398: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

1394: l_pay_calc_method varchar2(30);
1395: l_amortization_frequency varchar2(30);
1396: l_customized VARCHAR2(1);
1397:
1398: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
1399: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1400: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1401: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1402:

Line 1399: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

1395: l_amortization_frequency varchar2(30);
1396: l_customized VARCHAR2(1);
1397:
1398: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
1399: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1400: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1401: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1402:
1403: /*-----------------------------------------------------------------------+

Line 1400: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

1396: l_customized VARCHAR2(1);
1397:
1398: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
1399: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1400: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1401: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1402:
1403: /*-----------------------------------------------------------------------+
1404: | Cursor Declarations |

Line 1401: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

1397:
1398: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
1399: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1400: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1401: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
1402:
1403: /*-----------------------------------------------------------------------+
1404: | Cursor Declarations |
1405: +-----------------------------------------------------------------------*/

Line 1566: l_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1562: end if;
1563:
1564: else
1565:
1566: l_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1567: p_period_number => P_NEW_TERM_REC.OLD_TERM
1568: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1569: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1570:

Line 1571: l_ext_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1567: p_period_number => P_NEW_TERM_REC.OLD_TERM
1568: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1569: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1570:
1571: l_ext_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1572: p_period_number => P_NEW_TERM_REC.EXT_TERM
1573: ,p_period_type1 => P_NEW_TERM_REC.EXT_TERM_PERIOD
1574: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1575:

Line 1580: l_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1576: P_NEW_TERM_REC.NEW_TERM := l_term1 + l_ext_term1;
1577:
1578: P_NEW_TERM_REC.NEW_BALLOON_TYPE := P_NEW_TERM_REC.EXT_BALLOON_TYPE;
1579: if P_NEW_TERM_REC.EXT_BALLOON_TYPE = 'TERM' then
1580: l_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1581: p_period_number => P_NEW_TERM_REC.OLD_AMORT_TERM
1582: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1583: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1584:

Line 1585: l_ext_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1581: p_period_number => P_NEW_TERM_REC.OLD_AMORT_TERM
1582: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1583: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1584:
1585: l_ext_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1586: p_period_number => P_NEW_TERM_REC.EXT_AMORT_TERM
1587: ,p_period_type1 => P_NEW_TERM_REC.EXT_TERM_PERIOD
1588: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1589:

Line 1599: P_NEW_TERM_REC.NEW_MATURITY_DATE := lns_fin_utils.getMaturityDate(

1595: end if;
1596:
1597: end if;
1598:
1599: P_NEW_TERM_REC.NEW_MATURITY_DATE := lns_fin_utils.getMaturityDate(
1600: p_term => P_NEW_TERM_REC.NEW_TERM,
1601: p_term_period => P_NEW_TERM_REC.NEW_TERM_PERIOD,
1602: p_frequency => l_loan_payment_frequency,
1603: p_start_date => l_loan_start_date);

Line 1623: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

1619: else
1620: l_prin_pay_in_arrears_bool := false;
1621: end if;
1622:
1623: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
1624: p_loan_start_date => l_loan_start_date
1625: ,p_loan_maturity_date => P_NEW_TERM_REC.NEW_MATURITY_DATE
1626: ,p_int_first_pay_date => l_first_payment_date
1627: ,p_int_num_intervals => l_intervals

Line 1635: l_int_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

1631: ,p_prin_num_intervals => l_prin_intervals
1632: ,p_prin_interval_type => l_prin_payment_frequency
1633: ,p_prin_pay_in_arrears => l_prin_pay_in_arrears_bool);
1634: */
1635: l_int_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
1636: P_LOAN_ID => P_NEW_TERM_REC.LOAN_ID,
1637: P_PHASE => 'TERM',
1638: P_COMPONENT => 'INT');
1639:

Line 1640: l_prin_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

1636: P_LOAN_ID => P_NEW_TERM_REC.LOAN_ID,
1637: P_PHASE => 'TERM',
1638: P_COMPONENT => 'INT');
1639:
1640: l_prin_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
1641: P_LOAN_ID => P_NEW_TERM_REC.LOAN_ID,
1642: P_PHASE => 'TERM',
1643: P_COMPONENT => 'PRIN');
1644:

Line 1645: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

1641: P_LOAN_ID => P_NEW_TERM_REC.LOAN_ID,
1642: P_PHASE => 'TERM',
1643: P_COMPONENT => 'PRIN');
1644:
1645: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
1646: p_loan_start_date => l_loan_start_date,
1647: p_loan_maturity_date => P_NEW_TERM_REC.NEW_MATURITY_DATE,
1648: p_prin_freq_schedule_tbl => l_prin_freq_schedule_tbl,
1649: p_int_freq_schedule_tbl => l_int_freq_schedule_tbl);

Line 1661: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

1657: else
1658: l_pay_in_arrears_bool := false;
1659: end if;
1660:
1661: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
1662: p_loan_start_date => l_loan_start_date
1663: ,p_loan_maturity_date => P_NEW_TERM_REC.NEW_MATURITY_DATE
1664: ,p_first_pay_date => l_first_payment_date
1665: ,p_num_intervals => null

Line 1670: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

1666: ,p_interval_type => l_loan_payment_frequency
1667: ,p_pay_in_arrears => l_pay_in_arrears_bool);
1668: */
1669:
1670: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
1671: P_LOAN_ID => P_NEW_TERM_REC.LOAN_ID,
1672: P_PHASE => 'TERM',
1673: P_COMPONENT => 'PRIN_INT');
1674:

Line 1675: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

1671: P_LOAN_ID => P_NEW_TERM_REC.LOAN_ID,
1672: P_PHASE => 'TERM',
1673: P_COMPONENT => 'PRIN_INT');
1674:
1675: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
1676: p_loan_start_date => l_loan_start_date,
1677: p_loan_maturity_date => P_NEW_TERM_REC.NEW_MATURITY_DATE,
1678: p_freq_schedule_tbl => l_freq_schedule_tbl);
1679: