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_REP_UTILS dependencies on LNS_AMORT_SCHEDS_GT

Line 1022: type INSTALLMENT_NUMBER_tab_t is table of lns_amort_scheds_gt.INSTALLMENT_NUMBER%TYPE

1018: l_return_status VARCHAR2(10);
1019: l_msg_count NUMBER;
1020: l_msg_data VARCHAR2(32767);
1021:
1022: type INSTALLMENT_NUMBER_tab_t is table of lns_amort_scheds_gt.INSTALLMENT_NUMBER%TYPE
1023: index by pls_integer;
1024: v_INSTALLMENT_NUMBER INSTALLMENT_NUMBER_tab_t;
1025: type DUE_DATE_tab_t is table of lns_amort_scheds_gt.DUE_DATE%TYPE
1026: index by pls_integer;

Line 1025: type DUE_DATE_tab_t is table of lns_amort_scheds_gt.DUE_DATE%TYPE

1021:
1022: type INSTALLMENT_NUMBER_tab_t is table of lns_amort_scheds_gt.INSTALLMENT_NUMBER%TYPE
1023: index by pls_integer;
1024: v_INSTALLMENT_NUMBER INSTALLMENT_NUMBER_tab_t;
1025: type DUE_DATE_tab_t is table of lns_amort_scheds_gt.DUE_DATE%TYPE
1026: index by pls_integer;
1027: v_DUE_DATE DUE_DATE_tab_t;
1028: type PRINCIPAL_AMOUNT_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_AMOUNT%TYPE
1029: index by pls_integer;

Line 1028: type PRINCIPAL_AMOUNT_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_AMOUNT%TYPE

1024: v_INSTALLMENT_NUMBER INSTALLMENT_NUMBER_tab_t;
1025: type DUE_DATE_tab_t is table of lns_amort_scheds_gt.DUE_DATE%TYPE
1026: index by pls_integer;
1027: v_DUE_DATE DUE_DATE_tab_t;
1028: type PRINCIPAL_AMOUNT_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_AMOUNT%TYPE
1029: index by pls_integer;
1030: v_PRINCIPAL_AMOUNT PRINCIPAL_AMOUNT_tab_t;
1031: type INTEREST_AMOUNT_tab_t is table of lns_amort_scheds_gt.INTEREST_AMOUNT%TYPE
1032: index by pls_integer;

Line 1031: type INTEREST_AMOUNT_tab_t is table of lns_amort_scheds_gt.INTEREST_AMOUNT%TYPE

1027: v_DUE_DATE DUE_DATE_tab_t;
1028: type PRINCIPAL_AMOUNT_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_AMOUNT%TYPE
1029: index by pls_integer;
1030: v_PRINCIPAL_AMOUNT PRINCIPAL_AMOUNT_tab_t;
1031: type INTEREST_AMOUNT_tab_t is table of lns_amort_scheds_gt.INTEREST_AMOUNT%TYPE
1032: index by pls_integer;
1033: v_INTEREST_AMOUNT INTEREST_AMOUNT_tab_t;
1034: type FEE_AMOUNT_tab_t is table of lns_amort_scheds_gt.FEE_AMOUNT%TYPE
1035: index by pls_integer;

Line 1034: type FEE_AMOUNT_tab_t is table of lns_amort_scheds_gt.FEE_AMOUNT%TYPE

1030: v_PRINCIPAL_AMOUNT PRINCIPAL_AMOUNT_tab_t;
1031: type INTEREST_AMOUNT_tab_t is table of lns_amort_scheds_gt.INTEREST_AMOUNT%TYPE
1032: index by pls_integer;
1033: v_INTEREST_AMOUNT INTEREST_AMOUNT_tab_t;
1034: type FEE_AMOUNT_tab_t is table of lns_amort_scheds_gt.FEE_AMOUNT%TYPE
1035: index by pls_integer;
1036: v_FEE_AMOUNT FEE_AMOUNT_tab_t;
1037: type OTHER_AMOUNT_tab_t is table of lns_amort_scheds_gt.OTHER_AMOUNT%TYPE
1038: index by pls_integer;

Line 1037: type OTHER_AMOUNT_tab_t is table of lns_amort_scheds_gt.OTHER_AMOUNT%TYPE

1033: v_INTEREST_AMOUNT INTEREST_AMOUNT_tab_t;
1034: type FEE_AMOUNT_tab_t is table of lns_amort_scheds_gt.FEE_AMOUNT%TYPE
1035: index by pls_integer;
1036: v_FEE_AMOUNT FEE_AMOUNT_tab_t;
1037: type OTHER_AMOUNT_tab_t is table of lns_amort_scheds_gt.OTHER_AMOUNT%TYPE
1038: index by pls_integer;
1039: v_OTHER_AMOUNT OTHER_AMOUNT_tab_t;
1040: type BEGIN_BALANCE_tab_t is table of lns_amort_scheds_gt.BEGIN_BALANCE%TYPE
1041: index by pls_integer;

Line 1040: type BEGIN_BALANCE_tab_t is table of lns_amort_scheds_gt.BEGIN_BALANCE%TYPE

1036: v_FEE_AMOUNT FEE_AMOUNT_tab_t;
1037: type OTHER_AMOUNT_tab_t is table of lns_amort_scheds_gt.OTHER_AMOUNT%TYPE
1038: index by pls_integer;
1039: v_OTHER_AMOUNT OTHER_AMOUNT_tab_t;
1040: type BEGIN_BALANCE_tab_t is table of lns_amort_scheds_gt.BEGIN_BALANCE%TYPE
1041: index by pls_integer;
1042: v_BEGIN_BALANCE BEGIN_BALANCE_tab_t;
1043: type END_BALANCE_tab_t is table of lns_amort_scheds_gt.END_BALANCE%TYPE
1044: index by pls_integer;

Line 1043: type END_BALANCE_tab_t is table of lns_amort_scheds_gt.END_BALANCE%TYPE

1039: v_OTHER_AMOUNT OTHER_AMOUNT_tab_t;
1040: type BEGIN_BALANCE_tab_t is table of lns_amort_scheds_gt.BEGIN_BALANCE%TYPE
1041: index by pls_integer;
1042: v_BEGIN_BALANCE BEGIN_BALANCE_tab_t;
1043: type END_BALANCE_tab_t is table of lns_amort_scheds_gt.END_BALANCE%TYPE
1044: index by pls_integer;
1045: v_END_BALANCE END_BALANCE_tab_t;
1046: type TOTAL_tab_t is table of lns_amort_scheds_gt.TOTAL%TYPE
1047: index by pls_integer;

Line 1046: type TOTAL_tab_t is table of lns_amort_scheds_gt.TOTAL%TYPE

1042: v_BEGIN_BALANCE BEGIN_BALANCE_tab_t;
1043: type END_BALANCE_tab_t is table of lns_amort_scheds_gt.END_BALANCE%TYPE
1044: index by pls_integer;
1045: v_END_BALANCE END_BALANCE_tab_t;
1046: type TOTAL_tab_t is table of lns_amort_scheds_gt.TOTAL%TYPE
1047: index by pls_integer;
1048: v_TOTAL TOTAL_tab_t;
1049: type INTEREST_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.INTEREST_CUMULATIVE%TYPE
1050: index by pls_integer;

Line 1049: type INTEREST_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.INTEREST_CUMULATIVE%TYPE

1045: v_END_BALANCE END_BALANCE_tab_t;
1046: type TOTAL_tab_t is table of lns_amort_scheds_gt.TOTAL%TYPE
1047: index by pls_integer;
1048: v_TOTAL TOTAL_tab_t;
1049: type INTEREST_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.INTEREST_CUMULATIVE%TYPE
1050: index by pls_integer;
1051: v_INTEREST_CUMULATIVE INTEREST_CUMULATIVE_tab_t;
1052: type PRINCIPAL_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_CUMULATIVE%TYPE
1053: index by pls_integer;

Line 1052: type PRINCIPAL_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_CUMULATIVE%TYPE

1048: v_TOTAL TOTAL_tab_t;
1049: type INTEREST_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.INTEREST_CUMULATIVE%TYPE
1050: index by pls_integer;
1051: v_INTEREST_CUMULATIVE INTEREST_CUMULATIVE_tab_t;
1052: type PRINCIPAL_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_CUMULATIVE%TYPE
1053: index by pls_integer;
1054: v_PRINCIPAL_CUMULATIVE PRINCIPAL_CUMULATIVE_tab_t;
1055: type FEES_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.FEES_CUMULATIVE%TYPE
1056: index by pls_integer;

Line 1055: type FEES_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.FEES_CUMULATIVE%TYPE

1051: v_INTEREST_CUMULATIVE INTEREST_CUMULATIVE_tab_t;
1052: type PRINCIPAL_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.PRINCIPAL_CUMULATIVE%TYPE
1053: index by pls_integer;
1054: v_PRINCIPAL_CUMULATIVE PRINCIPAL_CUMULATIVE_tab_t;
1055: type FEES_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.FEES_CUMULATIVE%TYPE
1056: index by pls_integer;
1057: v_FEES_CUMULATIVE FEES_CUMULATIVE_tab_t;
1058: type OTHER_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.OTHER_CUMULATIVE%TYPE
1059: index by pls_integer;

Line 1058: type OTHER_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.OTHER_CUMULATIVE%TYPE

1054: v_PRINCIPAL_CUMULATIVE PRINCIPAL_CUMULATIVE_tab_t;
1055: type FEES_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.FEES_CUMULATIVE%TYPE
1056: index by pls_integer;
1057: v_FEES_CUMULATIVE FEES_CUMULATIVE_tab_t;
1058: type OTHER_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.OTHER_CUMULATIVE%TYPE
1059: index by pls_integer;
1060: v_OTHER_CUMULATIVE OTHER_CUMULATIVE_tab_t;
1061: type RATE_ID_tab_t is table of lns_amort_scheds_gt.RATE_ID%TYPE
1062: index by pls_integer;

Line 1061: type RATE_ID_tab_t is table of lns_amort_scheds_gt.RATE_ID%TYPE

1057: v_FEES_CUMULATIVE FEES_CUMULATIVE_tab_t;
1058: type OTHER_CUMULATIVE_tab_t is table of lns_amort_scheds_gt.OTHER_CUMULATIVE%TYPE
1059: index by pls_integer;
1060: v_OTHER_CUMULATIVE OTHER_CUMULATIVE_tab_t;
1061: type RATE_ID_tab_t is table of lns_amort_scheds_gt.RATE_ID%TYPE
1062: index by pls_integer;
1063: v_RATE_ID RATE_ID_tab_t;
1064: type SOURCE_tab_t is table of lns_amort_scheds_gt.SOURCE%TYPE
1065: index by pls_integer;

Line 1064: type SOURCE_tab_t is table of lns_amort_scheds_gt.SOURCE%TYPE

1060: v_OTHER_CUMULATIVE OTHER_CUMULATIVE_tab_t;
1061: type RATE_ID_tab_t is table of lns_amort_scheds_gt.RATE_ID%TYPE
1062: index by pls_integer;
1063: v_RATE_ID RATE_ID_tab_t;
1064: type SOURCE_tab_t is table of lns_amort_scheds_gt.SOURCE%TYPE
1065: index by pls_integer;
1066: v_SOURCE SOURCE_tab_t;
1067: type GRAND_TOTAL_FLAG_tab_t is table of lns_amort_scheds_gt.GRAND_TOTAL_FLAG%TYPE
1068: index by pls_integer;

Line 1067: type GRAND_TOTAL_FLAG_tab_t is table of lns_amort_scheds_gt.GRAND_TOTAL_FLAG%TYPE

1063: v_RATE_ID RATE_ID_tab_t;
1064: type SOURCE_tab_t is table of lns_amort_scheds_gt.SOURCE%TYPE
1065: index by pls_integer;
1066: v_SOURCE SOURCE_tab_t;
1067: type GRAND_TOTAL_FLAG_tab_t is table of lns_amort_scheds_gt.GRAND_TOTAL_FLAG%TYPE
1068: index by pls_integer;
1069: v_GRAND_TOTAL_FLAG GRAND_TOTAL_FLAG_tab_t;
1070:
1071: --Bug5262505 --karamach

Line 1524: FROM lns_amort_scheds_gt agt

1520: )
1521: )
1522: )
1523: )
1524: FROM lns_amort_scheds_gt agt
1525: where agt.loan_id = lh.loan_id
1526: ) -- end of AMORTIZATION
1527: ), XMLFormat.createformat('ROWSET')).getClobVal()
1528: from

Line 1630: insert into lns_amort_scheds_gt

1626: v_SOURCE(j) := l_amort_tbl(j).SOURCE;
1627: v_GRAND_TOTAL_FLAG(j) := l_amort_tbl(j).GRAND_TOTAL_FLAG;
1628: END LOOP;
1629: FORALL j in v_INSTALLMENT_NUMBER.first..v_INSTALLMENT_NUMBER.last
1630: insert into lns_amort_scheds_gt
1631: (
1632: LOAN_ID
1633: ,INSTALLMENT_NUMBER
1634: ,DUE_DATE