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_LOAN_PUB dependencies on LNS_FIN_UTILS

Line 871: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term

867: END IF;
868: ELSIF P_Loan_Details_Rec.loan_term is NOT NULL
869: AND P_Loan_Details_Rec.loan_term_period is NOT NULL
870: AND l_product_rec.max_loan_term is NOT NULL
871: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
872: ,P_Loan_Details_Rec.loan_term_period
873: ,'DAYS')
874: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
875: ,l_product_rec.loan_term_period

Line 874: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term

870: AND l_product_rec.max_loan_term is NOT NULL
871: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
872: ,P_Loan_Details_Rec.loan_term_period
873: ,'DAYS')
874: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
875: ,l_product_rec.loan_term_period
876: ,'DAYS')) OR
877: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
878: ,P_Loan_Details_Rec.loan_term_period

Line 877: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term

873: ,'DAYS')
874: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
875: ,l_product_rec.loan_term_period
876: ,'DAYS')) OR
877: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
878: ,P_Loan_Details_Rec.loan_term_period
879: ,'DAYS')
880: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.max_loan_term
881: ,l_product_rec.max_loan_term_period

Line 880: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.max_loan_term

876: ,'DAYS')) OR
877: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
878: ,P_Loan_Details_Rec.loan_term_period
879: ,'DAYS')
880: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.max_loan_term
881: ,l_product_rec.max_loan_term_period
882: ,'DAYS')))
883: THEN
884: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_BETWEEN'

Line 891: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term

887: ,p_token3=>l_product_rec.max_loan_term || ' ' || l_product_rec.max_loan_term_period);
888: ELSIF P_Loan_Details_Rec.loan_term is NOT NULL
889: AND P_Loan_Details_Rec.loan_term_period is NOT NULL
890: AND l_product_rec.max_loan_term is NULL
891: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
892: ,P_Loan_Details_Rec.loan_term_period
893: ,'DAYS')
894: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
895: ,l_product_rec.loan_term_period

Line 894: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term

890: AND l_product_rec.max_loan_term is NULL
891: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
892: ,P_Loan_Details_Rec.loan_term_period
893: ,'DAYS')
894: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
895: ,l_product_rec.loan_term_period
896: ,'DAYS'))
897: THEN
898: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_GREATER'

Line 1564: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term

1560: END IF;
1561: ELSIF P_Loan_Details_Rec.open_loan_term is NOT NULL
1562: AND P_Loan_Details_Rec.open_loan_term_period is NOT NULL
1563: AND l_product_rec.open_max_loan_term is NOT NULL
1564: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
1565: ,P_Loan_Details_Rec.open_loan_term_period
1566: ,'DAYS')
1567: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
1568: ,l_product_rec.open_loan_term_period

Line 1567: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term

1563: AND l_product_rec.open_max_loan_term is NOT NULL
1564: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
1565: ,P_Loan_Details_Rec.open_loan_term_period
1566: ,'DAYS')
1567: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
1568: ,l_product_rec.open_loan_term_period
1569: ,'DAYS')) OR
1570: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
1571: ,P_Loan_Details_Rec.open_loan_term_period

Line 1570: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term

1566: ,'DAYS')
1567: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
1568: ,l_product_rec.open_loan_term_period
1569: ,'DAYS')) OR
1570: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
1571: ,P_Loan_Details_Rec.open_loan_term_period
1572: ,'DAYS')
1573: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_max_loan_term
1574: ,l_product_rec.open_max_loan_term_period

Line 1573: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_max_loan_term

1569: ,'DAYS')) OR
1570: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
1571: ,P_Loan_Details_Rec.open_loan_term_period
1572: ,'DAYS')
1573: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_max_loan_term
1574: ,l_product_rec.open_max_loan_term_period
1575: ,'DAYS')))
1576: THEN
1577: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_BETWEEN'

Line 1584: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term

1580: ,p_token3=>l_product_rec.open_max_loan_term || ' ' || l_product_rec.open_max_loan_term_period);
1581: ELSIF P_Loan_Details_Rec.open_loan_term is NOT NULL
1582: AND P_Loan_Details_Rec.open_loan_term_period is NOT NULL
1583: AND l_product_rec.open_max_loan_term is NULL
1584: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
1585: ,P_Loan_Details_Rec.open_loan_term_period
1586: ,'DAYS')
1587: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
1588: ,l_product_rec.open_loan_term_period

Line 1587: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term

1583: AND l_product_rec.open_max_loan_term is NULL
1584: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
1585: ,P_Loan_Details_Rec.open_loan_term_period
1586: ,'DAYS')
1587: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
1588: ,l_product_rec.open_loan_term_period
1589: ,'DAYS'))
1590: THEN
1591: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_GREATER'

Line 1628: lns_fin_utils.getNextDate(p_date => P_Loan_Details_Rec.open_loan_start_date

1624: END;
1625: END IF;
1626:
1627: P_Loan_Details_Rec.open_first_payment_date :=
1628: lns_fin_utils.getNextDate(p_date => P_Loan_Details_Rec.open_loan_start_date
1629: ,p_interval_type => P_Loan_Details_Rec.loan_payment_frequency
1630: ,p_direction => 1);
1631:
1632: P_Loan_Details_Rec.open_maturity_date :=

Line 1633: lns_fin_utils.getMaturityDate(

1629: ,p_interval_type => P_Loan_Details_Rec.loan_payment_frequency
1630: ,p_direction => 1);
1631:
1632: P_Loan_Details_Rec.open_maturity_date :=
1633: lns_fin_utils.getMaturityDate(
1634: p_term => P_Loan_Details_Rec.open_loan_term,
1635: p_term_period => P_Loan_Details_Rec.open_loan_term_period,
1636: p_frequency => P_Loan_Details_Rec.loan_payment_frequency,
1637: p_start_date => P_Loan_Details_Rec.open_loan_start_date);

Line 1702: lns_fin_utils.getMaturityDate(

1698:
1699: END IF;
1700:
1701: P_Loan_Details_Rec.maturity_date :=
1702: lns_fin_utils.getMaturityDate(
1703: p_term => P_Loan_Details_Rec.loan_term,
1704: p_term_period => P_Loan_Details_Rec.loan_term_period,
1705: p_frequency => P_Loan_Details_Rec.loan_payment_frequency,
1706: p_start_date => P_Loan_Details_Rec.loan_start_date

Line 1718: P_Loan_Details_Rec.first_payment_date := lns_fin_utils.getNextDate(p_date=> P_Loan_Details_Rec.loan_start_date

1714: ELSIF (P_Loan_Details_Rec.first_payment_date > P_Loan_Details_Rec.maturity_date) THEN
1715: LogErrors(p_message_name => 'LNS_PAYMENT_START_DATE_ERROR1');
1716: END IF;
1717: ELSE
1718: P_Loan_Details_Rec.first_payment_date := lns_fin_utils.getNextDate(p_date=> P_Loan_Details_Rec.loan_start_date
1719: ,p_interval_type => P_Loan_Details_Rec.loan_payment_frequency
1720: ,p_direction => 1);
1721: END IF;
1722:

Line 2521: lns_fin_utils.getnumberinstallments(LnsLoanHeaders.LOAN_ID)) END_INSTALLMENT_NUMBER,

2517: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
2518: 'SUBMIT_FOR_APPROVAL',0,
2519: 'TERM_CONVERSION',0,
2520: 'BILL_WITH_INSTALLMENT',1,
2521: lns_fin_utils.getnumberinstallments(LnsLoanHeaders.LOAN_ID)) END_INSTALLMENT_NUMBER,
2522:
2523: NULL NUMBER_OF_PAYMENTS,
2524: LnsFees.BILLING_OPTION,
2525: NULL CREATED_BY,

Line 2865: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

2861: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
2862: l_rate_open_rec lns_rate_schedules%ROWTYPE;
2863: l_participant_rec LNS_PARTICIPANTS_PUB.loan_participant_rec_type;
2864: l_custom_tbl lns_custom_pub.custom_tbl;
2865: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2866: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2867: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2868: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
2869: l_open_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

Line 2869: l_open_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

2865: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2866: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2867: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2868: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
2869: l_open_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2870: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2871: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2872: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2873:

Line 2870: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

2866: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2867: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2868: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
2869: l_open_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2870: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2871: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2872: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2873:
2874: /*-----------------------------------------------------------------------+

Line 2871: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

2867: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2868: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
2869: l_open_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2870: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2871: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2872: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2873:
2874: /*-----------------------------------------------------------------------+
2875: | Cursor Declarations |

Line 2872: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

2868: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
2869: l_open_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2870: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2871: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2872: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2873:
2874: /*-----------------------------------------------------------------------+
2875: | Cursor Declarations |
2876: +-----------------------------------------------------------------------*/

Line 3478: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

3474: else
3475: l_pay_in_arrears_bool := false;
3476: end if;
3477:
3478: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
3479: p_loan_start_date => P_Loan_Details_Rec.open_loan_start_date
3480: ,p_loan_maturity_date => P_Loan_Details_Rec.open_maturity_date
3481: ,p_first_pay_date => P_Loan_Details_Rec.open_first_payment_date
3482: ,p_num_intervals => null

Line 3490: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

3486: l_open_freq_schedule_tbl(1).COMPONENT := 'PRIN_INT';
3487: l_open_freq_schedule_tbl(1).PERIOD_BEGIN_DATE := P_Loan_Details_Rec.open_first_payment_date;
3488: l_open_freq_schedule_tbl(1).FREQUENCY := P_Loan_Details_Rec.loan_payment_frequency;
3489:
3490: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
3491: p_loan_start_date => P_Loan_Details_Rec.open_loan_start_date,
3492: p_loan_maturity_date => P_Loan_Details_Rec.open_maturity_date,
3493: p_freq_schedule_tbl => l_open_freq_schedule_tbl);
3494:

Line 3546: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

3542: else
3543: l_prin_pay_in_arrears_bool := false;
3544: end if;
3545:
3546: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
3547: p_loan_start_date => P_Loan_Details_Rec.loan_start_date
3548: ,p_loan_maturity_date => P_Loan_Details_Rec.maturity_date
3549: ,p_int_first_pay_date => P_Loan_Details_Rec.first_payment_date
3550: ,p_int_num_intervals => null

Line 3566: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

3562: l_prin_freq_schedule_tbl(1).COMPONENT := 'PRIN';
3563: l_prin_freq_schedule_tbl(1).PERIOD_BEGIN_DATE := P_Loan_Details_Rec.PRIN_FIRST_PAY_DATE;
3564: l_prin_freq_schedule_tbl(1).FREQUENCY := P_Loan_Details_Rec.PRIN_PAYMENT_FREQUENCY;
3565:
3566: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
3567: p_loan_start_date => P_Loan_Details_Rec.loan_start_date,
3568: p_loan_maturity_date => P_Loan_Details_Rec.maturity_date,
3569: p_prin_freq_schedule_tbl => l_prin_freq_schedule_tbl,
3570: p_int_freq_schedule_tbl => l_int_freq_schedule_tbl);

Line 3582: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

3578: else
3579: l_pay_in_arrears_bool := false;
3580: end if;
3581:
3582: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
3583: p_loan_start_date => P_Loan_Details_Rec.loan_start_date
3584: ,p_loan_maturity_date => P_Loan_Details_Rec.maturity_date
3585: ,p_first_pay_date => P_Loan_Details_Rec.first_payment_date
3586: ,p_num_intervals => null

Line 3594: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

3590: l_freq_schedule_tbl(1).COMPONENT := 'PRIN_INT';
3591: l_freq_schedule_tbl(1).PERIOD_BEGIN_DATE := P_Loan_Details_Rec.first_payment_date;
3592: l_freq_schedule_tbl(1).FREQUENCY := P_Loan_Details_Rec.loan_payment_frequency;
3593:
3594: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
3595: p_loan_start_date => P_Loan_Details_Rec.loan_start_date,
3596: p_loan_maturity_date => P_Loan_Details_Rec.maturity_date,
3597: p_freq_schedule_tbl => l_freq_schedule_tbl);
3598: