APPS.LNS_EXT_LOAN_PUB dependencies on LNS_FIN_UTILS

Line 1406: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

1402: l_pay_calc_method varchar2(30);
1403: l_amortization_frequency varchar2(30);
1404: l_customized VARCHAR2(1);
1405:
1406: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
1407:
1408: /*-----------------------------------------------------------------------+
1409: | Cursor Declarations |
1410: +-----------------------------------------------------------------------*/

Line 1571: l_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1567: end if;
1568:
1569: else
1570:
1571: l_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1572: p_period_number => P_NEW_TERM_REC.OLD_TERM
1573: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1574: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1575:

Line 1576: l_ext_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1572: p_period_number => P_NEW_TERM_REC.OLD_TERM
1573: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1574: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1575:
1576: l_ext_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1577: p_period_number => P_NEW_TERM_REC.EXT_TERM
1578: ,p_period_type1 => P_NEW_TERM_REC.EXT_TERM_PERIOD
1579: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1580:

Line 1585: l_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1581: P_NEW_TERM_REC.NEW_TERM := l_term1 + l_ext_term1;
1582:
1583: P_NEW_TERM_REC.NEW_BALLOON_TYPE := P_NEW_TERM_REC.EXT_BALLOON_TYPE;
1584: if P_NEW_TERM_REC.EXT_BALLOON_TYPE = 'TERM' then
1585: l_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1586: p_period_number => P_NEW_TERM_REC.OLD_AMORT_TERM
1587: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1588: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1589:

Line 1590: l_ext_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(

1586: p_period_number => P_NEW_TERM_REC.OLD_AMORT_TERM
1587: ,p_period_type1 => P_NEW_TERM_REC.OLD_TERM_PERIOD
1588: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1589:
1590: l_ext_am_term1 := LNS_FIN_UTILS.intervalsInPeriod(
1591: p_period_number => P_NEW_TERM_REC.EXT_AMORT_TERM
1592: ,p_period_type1 => P_NEW_TERM_REC.EXT_TERM_PERIOD
1593: ,p_period_type2 => P_NEW_TERM_REC.NEW_TERM_PERIOD);
1594:

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

1600: end if;
1601:
1602: end if;
1603:
1604: P_NEW_TERM_REC.NEW_MATURITY_DATE := lns_fin_utils.getMaturityDate(
1605: p_term => P_NEW_TERM_REC.NEW_TERM,
1606: p_term_period => P_NEW_TERM_REC.NEW_TERM_PERIOD,
1607: p_frequency => l_loan_payment_frequency,
1608: p_start_date => l_loan_start_date);

Line 1628: l_intervals := lns_fin_utils.intervalsInPeriod(P_NEW_TERM_REC.NEW_TERM

1624: else
1625: l_prin_pay_in_arrears_bool := false;
1626: end if;
1627:
1628: l_intervals := lns_fin_utils.intervalsInPeriod(P_NEW_TERM_REC.NEW_TERM
1629: ,P_NEW_TERM_REC.NEW_TERM_PERIOD
1630: ,l_loan_payment_frequency);
1631:
1632: l_prin_intervals := lns_fin_utils.intervalsInPeriod(P_NEW_TERM_REC.NEW_TERM

Line 1632: l_prin_intervals := lns_fin_utils.intervalsInPeriod(P_NEW_TERM_REC.NEW_TERM

1628: l_intervals := lns_fin_utils.intervalsInPeriod(P_NEW_TERM_REC.NEW_TERM
1629: ,P_NEW_TERM_REC.NEW_TERM_PERIOD
1630: ,l_loan_payment_frequency);
1631:
1632: l_prin_intervals := lns_fin_utils.intervalsInPeriod(P_NEW_TERM_REC.NEW_TERM
1633: ,P_NEW_TERM_REC.NEW_TERM_PERIOD
1634: ,l_prin_payment_frequency);
1635:
1636: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_intervals: ' || l_intervals);

Line 1639: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

1635:
1636: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_intervals: ' || l_intervals);
1637: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_prin_intervals: ' || l_prin_intervals);
1638:
1639: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
1640: p_loan_start_date => l_loan_start_date
1641: ,p_loan_maturity_date => P_NEW_TERM_REC.NEW_MATURITY_DATE
1642: ,p_int_first_pay_date => l_first_payment_date
1643: ,p_int_num_intervals => l_intervals

Line 1655: P_NEW_TERM_REC.NEW_INSTALLMENTS := round(LNS_FIN_UTILS.intervalsInPeriod(

1651: P_NEW_TERM_REC.NEW_INSTALLMENTS := l_payment_tbl.count;
1652:
1653: else
1654:
1655: P_NEW_TERM_REC.NEW_INSTALLMENTS := round(LNS_FIN_UTILS.intervalsInPeriod(
1656: p_period_number => P_NEW_TERM_REC.NEW_TERM
1657: ,p_period_type1 => P_NEW_TERM_REC.NEW_TERM_PERIOD
1658: ,p_period_type2 => l_loan_payment_frequency));
1659: