DBA Data[Home] [Help]

APPS.LNS_FINANCIALS_W dependencies on JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE

Line 21: , a7 out nocopy JTF_VARCHAR2_TABLE_100

17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:

Line 22: , a8 out nocopy JTF_VARCHAR2_TABLE_100

18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE

Line 23: , a9 out nocopy JTF_VARCHAR2_TABLE_100

19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_DATE_TABLE

Line 47: , a21 JTF_VARCHAR2_TABLE_100

43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE

Line 48: , a22 JTF_VARCHAR2_TABLE_100

44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE

Line 49: , a23 JTF_VARCHAR2_TABLE_100

45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE

Line 91: , a21 out nocopy JTF_VARCHAR2_TABLE_100

87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE

Line 92: , a22 out nocopy JTF_VARCHAR2_TABLE_100

88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE

Line 93: , a23 out nocopy JTF_VARCHAR2_TABLE_100

89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE

Line 138: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100

134: , a8 out nocopy JTF_NUMBER_TABLE
135: , a9 out nocopy JTF_DATE_TABLE
136: );
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );

Line 143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100

139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_NUMBER_TABLE
147: );

Line 173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);

169:
170: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
171: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
172:
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100

Line 174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);

170: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
171: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
172:
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE

Line 177: , a1 JTF_VARCHAR2_TABLE_100

173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE

Line 182: , a6 JTF_VARCHAR2_TABLE_100

178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );

Line 184: , a8 JTF_VARCHAR2_TABLE_100

180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , a9 JTF_VARCHAR2_TABLE_100

181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE

Line 188: , a1 out nocopy JTF_VARCHAR2_TABLE_100

184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE

Line 193: , a6 out nocopy JTF_VARCHAR2_TABLE_100

189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
197: );

Line 195: , a8 out nocopy JTF_VARCHAR2_TABLE_100

191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
197: );
198:
199: procedure shiftloandates(p_loan_id NUMBER

Line 196: , a9 out nocopy JTF_VARCHAR2_TABLE_100

192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
197: );
198:
199: procedure shiftloandates(p_loan_id NUMBER
200: , p_new_start_date DATE

Line 408: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100

404: procedure calculatepayoff(p_api_version NUMBER
405: , p_init_msg_list VARCHAR2
406: , p_loan_id NUMBER
407: , p_payoff_date DATE
408: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
409: , p4_a1 out nocopy JTF_NUMBER_TABLE
410: , p4_a2 out nocopy JTF_NUMBER_TABLE
411: , p4_a3 out nocopy JTF_NUMBER_TABLE
412: , x_return_status out nocopy VARCHAR2

Line 521: , p3_a7 JTF_VARCHAR2_TABLE_100

517: , p3_a3 JTF_NUMBER_TABLE
518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
524: ) return number;
525: procedure amortizeeploan(p0_a0 NUMBER

Line 522: , p3_a8 JTF_VARCHAR2_TABLE_100

518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
524: ) return number;
525: procedure amortizeeploan(p0_a0 NUMBER
526: , p0_a1 NUMBER

Line 523: , p3_a9 JTF_VARCHAR2_TABLE_100

519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
524: ) return number;
525: procedure amortizeeploan(p0_a0 NUMBER
526: , p0_a1 NUMBER
527: , p0_a2 VARCHAR2

Line 628: , p1_a7 JTF_VARCHAR2_TABLE_100

624: , p1_a3 JTF_NUMBER_TABLE
625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
632: , p_installment_number NUMBER

Line 629: , p1_a8 JTF_VARCHAR2_TABLE_100

625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
632: , p_installment_number NUMBER
633: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 630: , p1_a9 JTF_VARCHAR2_TABLE_100

626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
632: , p_installment_number NUMBER
633: , p4_a0 out nocopy JTF_NUMBER_TABLE
634: , p4_a1 out nocopy JTF_DATE_TABLE

Line 654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100

650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE

Line 655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100

651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE

Line 656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100

652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE

Line 780: , p1_a7 JTF_VARCHAR2_TABLE_100

776: , p1_a3 JTF_NUMBER_TABLE
777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
784: , p_installment_number NUMBER

Line 781: , p1_a8 JTF_VARCHAR2_TABLE_100

777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
784: , p_installment_number NUMBER
785: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 782: , p1_a9 JTF_VARCHAR2_TABLE_100

778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
784: , p_installment_number NUMBER
785: , p4_a0 out nocopy JTF_NUMBER_TABLE
786: , p4_a1 out nocopy JTF_DATE_TABLE

Line 806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100

802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE

Line 807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100

803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE

Line 808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100

804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE

Line 853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100

849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE

Line 854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100

850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE

Line 855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100

851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE

Line 980: , p2_a7 JTF_VARCHAR2_TABLE_100

976: , p2_a3 JTF_NUMBER_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE

Line 981: , p2_a8 JTF_VARCHAR2_TABLE_100

977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE

Line 982: , p2_a9 JTF_VARCHAR2_TABLE_100

978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE
986: , p3_a3 out nocopy JTF_DATE_TABLE

Line 1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100

1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE

Line 1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100

1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE

Line 1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100

1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE

Line 1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100

1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE

Line 1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100

1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE

Line 1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100

1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE

Line 1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100

1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE

Line 1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100

1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE

Line 1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100

1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE

Line 1178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

1174: , p5_a40 out nocopy VARCHAR2
1175: , p5_a41 out nocopy NUMBER
1176: , p5_a42 out nocopy VARCHAR2
1177: , p6_a0 out nocopy JTF_NUMBER_TABLE
1178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187: , x_return_status out nocopy VARCHAR2

Line 1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187: , x_return_status out nocopy VARCHAR2
1188: , x_msg_count out nocopy NUMBER
1189: , x_msg_data out nocopy VARCHAR2

Line 1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187: , x_return_status out nocopy VARCHAR2
1188: , x_msg_count out nocopy NUMBER
1189: , x_msg_data out nocopy VARCHAR2
1190: );

Line 1238: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

1234: , p3_a40 out nocopy VARCHAR2
1235: , p3_a41 out nocopy NUMBER
1236: , p3_a42 out nocopy VARCHAR2
1237: , p4_a0 out nocopy JTF_NUMBER_TABLE
1238: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247: , x_return_status out nocopy VARCHAR2

Line 1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247: , x_return_status out nocopy VARCHAR2
1248: , x_msg_count out nocopy NUMBER
1249: , x_msg_data out nocopy VARCHAR2

Line 1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247: , x_return_status out nocopy VARCHAR2
1248: , x_msg_count out nocopy NUMBER
1249: , x_msg_data out nocopy VARCHAR2
1250: );

Line 1370: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100

1366: , p_init_msg_list VARCHAR2
1367: , p_loan_id NUMBER
1368: , p_date DATE
1369: , p_reason VARCHAR2
1370: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1371: , p5_a1 out nocopy JTF_NUMBER_TABLE
1372: , p5_a2 out nocopy JTF_NUMBER_TABLE
1373: , p5_a3 out nocopy JTF_NUMBER_TABLE
1374: , x_return_status out nocopy VARCHAR2