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 706: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term

702: AND P_Loan_Details_Rec.loan_term_period is NOT NULL
703: AND l_product_rec.max_loan_term is NOT NULL
704: AND (l_product_rec.open_to_term_flag = 'Y'
705: OR l_product_rec.multiple_funding_flag = 'N')
706: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
707: ,P_Loan_Details_Rec.loan_term_period
708: ,'DAYS')
709: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
710: ,l_product_rec.loan_term_period

Line 709: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term

705: OR l_product_rec.multiple_funding_flag = 'N')
706: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
707: ,P_Loan_Details_Rec.loan_term_period
708: ,'DAYS')
709: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
710: ,l_product_rec.loan_term_period
711: ,'DAYS')) OR
712: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
713: ,P_Loan_Details_Rec.loan_term_period

Line 712: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term

708: ,'DAYS')
709: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
710: ,l_product_rec.loan_term_period
711: ,'DAYS')) OR
712: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
713: ,P_Loan_Details_Rec.loan_term_period
714: ,'DAYS')
715: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.max_loan_term
716: ,l_product_rec.max_loan_term_period

Line 715: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.max_loan_term

711: ,'DAYS')) OR
712: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
713: ,P_Loan_Details_Rec.loan_term_period
714: ,'DAYS')
715: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.max_loan_term
716: ,l_product_rec.max_loan_term_period
717: ,'DAYS'))) THEN
718: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_BETWEEN'
719: ,p_token1=>

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

726: AND P_Loan_Details_Rec.loan_term_period is NOT NULL
727: AND l_product_rec.max_loan_term is NULL
728: AND (l_product_rec.open_to_term_flag = 'Y'
729: OR l_product_rec.multiple_funding_flag = 'N')
730: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
731: ,P_Loan_Details_Rec.loan_term_period
732: ,'DAYS')
733: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
734: ,l_product_rec.loan_term_period

Line 733: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term

729: OR l_product_rec.multiple_funding_flag = 'N')
730: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.loan_term
731: ,P_Loan_Details_Rec.loan_term_period
732: ,'DAYS')
733: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.loan_term
734: ,l_product_rec.loan_term_period
735: ,'DAYS')) THEN
736: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_GREATER'
737: ,p_token1=>

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

783: ELSIF P_Loan_Details_Rec.open_loan_term is NOT NULL
784: AND P_Loan_Details_Rec.open_loan_term_period is NOT NULL
785: AND l_product_rec.open_max_loan_term is NOT NULL
786: AND l_product_rec.multiple_funding_flag = 'Y'
787: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
788: ,P_Loan_Details_Rec.open_loan_term_period
789: ,'DAYS')
790: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
791: ,l_product_rec.open_loan_term_period

Line 790: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term

786: AND l_product_rec.multiple_funding_flag = 'Y'
787: AND ((LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
788: ,P_Loan_Details_Rec.open_loan_term_period
789: ,'DAYS')
790: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
791: ,l_product_rec.open_loan_term_period
792: ,'DAYS')) OR
793: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
794: ,P_Loan_Details_Rec.open_loan_term_period

Line 793: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term

789: ,'DAYS')
790: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
791: ,l_product_rec.open_loan_term_period
792: ,'DAYS')) OR
793: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
794: ,P_Loan_Details_Rec.open_loan_term_period
795: ,'DAYS')
796: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_max_loan_term
797: ,l_product_rec.open_max_loan_term_period

Line 796: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_max_loan_term

792: ,'DAYS')) OR
793: (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
794: ,P_Loan_Details_Rec.open_loan_term_period
795: ,'DAYS')
796: > LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_max_loan_term
797: ,l_product_rec.open_max_loan_term_period
798: ,'DAYS'))) THEN
799: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_BETWEEN'
800: ,p_token1=>

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

806: ELSIF P_Loan_Details_Rec.open_loan_term is NOT NULL
807: AND P_Loan_Details_Rec.open_loan_term_period is NOT NULL
808: AND l_product_rec.open_max_loan_term is NULL
809: AND l_product_rec.multiple_funding_flag = 'Y'
810: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
811: ,P_Loan_Details_Rec.open_loan_term_period
812: ,'DAYS')
813: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
814: ,l_product_rec.open_loan_term_period

Line 813: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term

809: AND l_product_rec.multiple_funding_flag = 'Y'
810: AND (LNS_FIN_UTILS.intervalsinperiod(P_Loan_Details_Rec.open_loan_term
811: ,P_Loan_Details_Rec.open_loan_term_period
812: ,'DAYS')
813: < LNS_FIN_UTILS.intervalsinperiod(l_product_rec.open_loan_term
814: ,l_product_rec.open_loan_term_period
815: ,'DAYS')) THEN
816: LogErrors(p_message_name=>'LNS_LCREATE_ATTR_NOT_GREATER'
817: ,p_token1=>

Line 1303: lns_fin_utils.getMaturityDate(

1299:
1300:
1301: g_loan_rec.open_maturity_date := CASE l_product_rec.multiple_funding_flag
1302: WHEN 'Y' THEN
1303: lns_fin_utils.getMaturityDate(
1304: p_term => g_loan_rec.open_loan_term,
1305: p_term_period => g_loan_rec.open_loan_term_period,
1306: p_frequency => g_term_rec.amortization_frequency,
1307: p_start_date => g_loan_rec.open_loan_start_date

Line 1320: lns_fin_utils.getMaturityDate(

1316: nvl(P_Loan_Details_Rec.loan_start_date,sysdate)
1317: END;
1318:
1319: g_loan_rec.loan_maturity_date :=
1320: lns_fin_utils.getMaturityDate(
1321: p_term => g_loan_rec.loan_term,
1322: p_term_period => g_loan_rec.loan_term_period,
1323: p_frequency => g_term_rec.amortization_frequency,
1324: p_start_date => g_loan_rec.loan_start_date

Line 1330: ELSE lns_fin_utils.getNextDate(p_date=> g_loan_rec.loan_start_date

1326:
1327: g_term_rec.open_first_payment_date :=
1328: CASE l_product_rec.multiple_funding_flag
1329: WHEN 'N' THEN null
1330: ELSE lns_fin_utils.getNextDate(p_date=> g_loan_rec.loan_start_date
1331: ,p_interval_type =>
1332: g_term_rec.loan_payment_frequency
1333: ,p_direction => 1)
1334: END;

Line 1411: Lns_Fin_Utils.intervalsInPeriod(p_period_number=> g_loan_rec.loan_term

1407: g_rate_term_rec.interest_only_flag := 'N';
1408: g_rate_term_rec.floating_flag := 'N';
1409: g_rate_term_rec.begin_installment_number := 1;
1410: g_rate_term_rec.end_installment_number :=
1411: Lns_Fin_Utils.intervalsInPeriod(p_period_number=> g_loan_rec.loan_term
1412: ,p_period_type1 => g_loan_rec.loan_term_period
1413: ,p_period_type2 => g_term_rec.amortization_frequency);
1414: g_rate_term_rec.start_date_active := sysdate;
1415: -- Who Columns

Line 1444: Lns_Fin_Utils.intervalsInPeriod(p_period_number=> g_loan_rec.open_loan_term

1440: g_rate_open_rec.interest_only_flag := 'N';
1441: g_rate_open_rec.floating_flag := 'N';
1442: g_rate_open_rec.begin_installment_number := 1;
1443: g_rate_open_rec.end_installment_number :=
1444: Lns_Fin_Utils.intervalsInPeriod(p_period_number=> g_loan_rec.open_loan_term
1445: ,p_period_type1 => g_loan_rec.open_loan_term_period
1446: ,p_period_type2 => g_term_rec.amortization_frequency);
1447: g_rate_open_rec.start_date_active := sysdate;
1448: