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: );

Line 75: , a21 out nocopy JTF_VARCHAR2_TABLE_100

71: , a17 out nocopy JTF_NUMBER_TABLE
72: , a18 out nocopy JTF_NUMBER_TABLE
73: , a19 out nocopy JTF_NUMBER_TABLE
74: , a20 out nocopy JTF_NUMBER_TABLE
75: , a21 out nocopy JTF_VARCHAR2_TABLE_100
76: , a22 out nocopy JTF_VARCHAR2_TABLE_100
77: , a23 out nocopy JTF_VARCHAR2_TABLE_100
78: , a24 out nocopy JTF_NUMBER_TABLE
79: , a25 out nocopy JTF_NUMBER_TABLE

Line 76: , a22 out nocopy JTF_VARCHAR2_TABLE_100

72: , a18 out nocopy JTF_NUMBER_TABLE
73: , a19 out nocopy JTF_NUMBER_TABLE
74: , a20 out nocopy JTF_NUMBER_TABLE
75: , a21 out nocopy JTF_VARCHAR2_TABLE_100
76: , a22 out nocopy JTF_VARCHAR2_TABLE_100
77: , a23 out nocopy JTF_VARCHAR2_TABLE_100
78: , a24 out nocopy JTF_NUMBER_TABLE
79: , a25 out nocopy JTF_NUMBER_TABLE
80: , a26 out nocopy JTF_NUMBER_TABLE

Line 77: , a23 out nocopy JTF_VARCHAR2_TABLE_100

73: , a19 out nocopy JTF_NUMBER_TABLE
74: , a20 out nocopy JTF_NUMBER_TABLE
75: , a21 out nocopy JTF_VARCHAR2_TABLE_100
76: , a22 out nocopy JTF_VARCHAR2_TABLE_100
77: , a23 out nocopy JTF_VARCHAR2_TABLE_100
78: , a24 out nocopy JTF_NUMBER_TABLE
79: , a25 out nocopy JTF_NUMBER_TABLE
80: , a26 out nocopy JTF_NUMBER_TABLE
81: );

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

102: , a8 out nocopy JTF_NUMBER_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
104: );
105:
106: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
107: , a1 JTF_NUMBER_TABLE
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: );

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

107: , a1 JTF_NUMBER_TABLE
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: );

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

137:
138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
140:
141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
143:
144: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
145: , a1 JTF_VARCHAR2_TABLE_100

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

138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
140:
141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
143:
144: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
145: , a1 JTF_VARCHAR2_TABLE_100
146: , a2 JTF_NUMBER_TABLE

Line 145: , a1 JTF_VARCHAR2_TABLE_100

141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
143:
144: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
145: , a1 JTF_VARCHAR2_TABLE_100
146: , a2 JTF_NUMBER_TABLE
147: , a3 JTF_NUMBER_TABLE
148: , a4 JTF_VARCHAR2_TABLE_300
149: , a5 JTF_NUMBER_TABLE

Line 150: , a6 JTF_VARCHAR2_TABLE_100

146: , a2 JTF_NUMBER_TABLE
147: , a3 JTF_NUMBER_TABLE
148: , a4 JTF_VARCHAR2_TABLE_300
149: , a5 JTF_NUMBER_TABLE
150: , a6 JTF_VARCHAR2_TABLE_100
151: , a7 JTF_NUMBER_TABLE
152: , a8 JTF_VARCHAR2_TABLE_100
153: , a9 JTF_VARCHAR2_TABLE_100
154: );

Line 152: , a8 JTF_VARCHAR2_TABLE_100

148: , a4 JTF_VARCHAR2_TABLE_300
149: , a5 JTF_NUMBER_TABLE
150: , a6 JTF_VARCHAR2_TABLE_100
151: , a7 JTF_NUMBER_TABLE
152: , a8 JTF_VARCHAR2_TABLE_100
153: , a9 JTF_VARCHAR2_TABLE_100
154: );
155: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 153: , a9 JTF_VARCHAR2_TABLE_100

149: , a5 JTF_NUMBER_TABLE
150: , a6 JTF_VARCHAR2_TABLE_100
151: , a7 JTF_NUMBER_TABLE
152: , a8 JTF_VARCHAR2_TABLE_100
153: , a9 JTF_VARCHAR2_TABLE_100
154: );
155: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_VARCHAR2_TABLE_100
157: , a2 out nocopy JTF_NUMBER_TABLE

Line 156: , a1 out nocopy JTF_VARCHAR2_TABLE_100

152: , a8 JTF_VARCHAR2_TABLE_100
153: , a9 JTF_VARCHAR2_TABLE_100
154: );
155: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_VARCHAR2_TABLE_100
157: , a2 out nocopy JTF_NUMBER_TABLE
158: , a3 out nocopy JTF_NUMBER_TABLE
159: , a4 out nocopy JTF_VARCHAR2_TABLE_300
160: , a5 out nocopy JTF_NUMBER_TABLE

Line 161: , a6 out nocopy JTF_VARCHAR2_TABLE_100

157: , a2 out nocopy JTF_NUMBER_TABLE
158: , a3 out nocopy JTF_NUMBER_TABLE
159: , a4 out nocopy JTF_VARCHAR2_TABLE_300
160: , a5 out nocopy JTF_NUMBER_TABLE
161: , a6 out nocopy JTF_VARCHAR2_TABLE_100
162: , a7 out nocopy JTF_NUMBER_TABLE
163: , a8 out nocopy JTF_VARCHAR2_TABLE_100
164: , a9 out nocopy JTF_VARCHAR2_TABLE_100
165: );

Line 163: , a8 out nocopy JTF_VARCHAR2_TABLE_100

159: , a4 out nocopy JTF_VARCHAR2_TABLE_300
160: , a5 out nocopy JTF_NUMBER_TABLE
161: , a6 out nocopy JTF_VARCHAR2_TABLE_100
162: , a7 out nocopy JTF_NUMBER_TABLE
163: , a8 out nocopy JTF_VARCHAR2_TABLE_100
164: , a9 out nocopy JTF_VARCHAR2_TABLE_100
165: );
166:
167: procedure shiftloandates(p_loan_id NUMBER

Line 164: , a9 out nocopy JTF_VARCHAR2_TABLE_100

160: , a5 out nocopy JTF_NUMBER_TABLE
161: , a6 out nocopy JTF_VARCHAR2_TABLE_100
162: , a7 out nocopy JTF_NUMBER_TABLE
163: , a8 out nocopy JTF_VARCHAR2_TABLE_100
164: , a9 out nocopy JTF_VARCHAR2_TABLE_100
165: );
166:
167: procedure shiftloandates(p_loan_id NUMBER
168: , p_new_start_date DATE

Line 362: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100

358: procedure calculatepayoff(p_api_version NUMBER
359: , p_init_msg_list VARCHAR2
360: , p_loan_id NUMBER
361: , p_payoff_date DATE
362: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
363: , p4_a1 out nocopy JTF_NUMBER_TABLE
364: , p4_a2 out nocopy JTF_NUMBER_TABLE
365: , p4_a3 out nocopy JTF_NUMBER_TABLE
366: , x_return_status out nocopy VARCHAR2

Line 468: , p3_a7 JTF_VARCHAR2_TABLE_100

464: , p3_a3 JTF_NUMBER_TABLE
465: , p3_a4 JTF_NUMBER_TABLE
466: , p3_a5 JTF_NUMBER_TABLE
467: , p3_a6 JTF_NUMBER_TABLE
468: , p3_a7 JTF_VARCHAR2_TABLE_100
469: , p3_a8 JTF_VARCHAR2_TABLE_100
470: , p3_a9 JTF_VARCHAR2_TABLE_100
471: ) return number;
472: procedure amortizeeploan(p0_a0 NUMBER

Line 469: , p3_a8 JTF_VARCHAR2_TABLE_100

465: , p3_a4 JTF_NUMBER_TABLE
466: , p3_a5 JTF_NUMBER_TABLE
467: , p3_a6 JTF_NUMBER_TABLE
468: , p3_a7 JTF_VARCHAR2_TABLE_100
469: , p3_a8 JTF_VARCHAR2_TABLE_100
470: , p3_a9 JTF_VARCHAR2_TABLE_100
471: ) return number;
472: procedure amortizeeploan(p0_a0 NUMBER
473: , p0_a1 NUMBER

Line 470: , p3_a9 JTF_VARCHAR2_TABLE_100

466: , p3_a5 JTF_NUMBER_TABLE
467: , p3_a6 JTF_NUMBER_TABLE
468: , p3_a7 JTF_VARCHAR2_TABLE_100
469: , p3_a8 JTF_VARCHAR2_TABLE_100
470: , p3_a9 JTF_VARCHAR2_TABLE_100
471: ) return number;
472: procedure amortizeeploan(p0_a0 NUMBER
473: , p0_a1 NUMBER
474: , p0_a2 VARCHAR2

Line 568: , p1_a7 JTF_VARCHAR2_TABLE_100

564: , p1_a3 JTF_NUMBER_TABLE
565: , p1_a4 JTF_NUMBER_TABLE
566: , p1_a5 JTF_NUMBER_TABLE
567: , p1_a6 JTF_NUMBER_TABLE
568: , p1_a7 JTF_VARCHAR2_TABLE_100
569: , p1_a8 JTF_VARCHAR2_TABLE_100
570: , p1_a9 JTF_VARCHAR2_TABLE_100
571: , p_based_on_terms VARCHAR2
572: , p_installment_number NUMBER

Line 569: , p1_a8 JTF_VARCHAR2_TABLE_100

565: , p1_a4 JTF_NUMBER_TABLE
566: , p1_a5 JTF_NUMBER_TABLE
567: , p1_a6 JTF_NUMBER_TABLE
568: , p1_a7 JTF_VARCHAR2_TABLE_100
569: , p1_a8 JTF_VARCHAR2_TABLE_100
570: , p1_a9 JTF_VARCHAR2_TABLE_100
571: , p_based_on_terms VARCHAR2
572: , p_installment_number NUMBER
573: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 570: , p1_a9 JTF_VARCHAR2_TABLE_100

566: , p1_a5 JTF_NUMBER_TABLE
567: , p1_a6 JTF_NUMBER_TABLE
568: , p1_a7 JTF_VARCHAR2_TABLE_100
569: , p1_a8 JTF_VARCHAR2_TABLE_100
570: , p1_a9 JTF_VARCHAR2_TABLE_100
571: , p_based_on_terms VARCHAR2
572: , p_installment_number NUMBER
573: , p4_a0 out nocopy JTF_NUMBER_TABLE
574: , p4_a1 out nocopy JTF_DATE_TABLE

Line 594: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100

590: , p4_a17 out nocopy JTF_NUMBER_TABLE
591: , p4_a18 out nocopy JTF_NUMBER_TABLE
592: , p4_a19 out nocopy JTF_NUMBER_TABLE
593: , p4_a20 out nocopy JTF_NUMBER_TABLE
594: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
595: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
596: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
597: , p4_a24 out nocopy JTF_NUMBER_TABLE
598: , p4_a25 out nocopy JTF_NUMBER_TABLE

Line 595: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100

591: , p4_a18 out nocopy JTF_NUMBER_TABLE
592: , p4_a19 out nocopy JTF_NUMBER_TABLE
593: , p4_a20 out nocopy JTF_NUMBER_TABLE
594: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
595: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
596: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
597: , p4_a24 out nocopy JTF_NUMBER_TABLE
598: , p4_a25 out nocopy JTF_NUMBER_TABLE
599: , p4_a26 out nocopy JTF_NUMBER_TABLE

Line 596: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100

592: , p4_a19 out nocopy JTF_NUMBER_TABLE
593: , p4_a20 out nocopy JTF_NUMBER_TABLE
594: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
595: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
596: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
597: , p4_a24 out nocopy JTF_NUMBER_TABLE
598: , p4_a25 out nocopy JTF_NUMBER_TABLE
599: , p4_a26 out nocopy JTF_NUMBER_TABLE
600: );

Line 697: , p1_a7 JTF_VARCHAR2_TABLE_100

693: , p1_a3 JTF_NUMBER_TABLE
694: , p1_a4 JTF_NUMBER_TABLE
695: , p1_a5 JTF_NUMBER_TABLE
696: , p1_a6 JTF_NUMBER_TABLE
697: , p1_a7 JTF_VARCHAR2_TABLE_100
698: , p1_a8 JTF_VARCHAR2_TABLE_100
699: , p1_a9 JTF_VARCHAR2_TABLE_100
700: , p_based_on_terms VARCHAR2
701: , p_installment_number NUMBER

Line 698: , p1_a8 JTF_VARCHAR2_TABLE_100

694: , p1_a4 JTF_NUMBER_TABLE
695: , p1_a5 JTF_NUMBER_TABLE
696: , p1_a6 JTF_NUMBER_TABLE
697: , p1_a7 JTF_VARCHAR2_TABLE_100
698: , p1_a8 JTF_VARCHAR2_TABLE_100
699: , p1_a9 JTF_VARCHAR2_TABLE_100
700: , p_based_on_terms VARCHAR2
701: , p_installment_number NUMBER
702: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 699: , p1_a9 JTF_VARCHAR2_TABLE_100

695: , p1_a5 JTF_NUMBER_TABLE
696: , p1_a6 JTF_NUMBER_TABLE
697: , p1_a7 JTF_VARCHAR2_TABLE_100
698: , p1_a8 JTF_VARCHAR2_TABLE_100
699: , p1_a9 JTF_VARCHAR2_TABLE_100
700: , p_based_on_terms VARCHAR2
701: , p_installment_number NUMBER
702: , p4_a0 out nocopy JTF_NUMBER_TABLE
703: , p4_a1 out nocopy JTF_DATE_TABLE

Line 723: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100

719: , p4_a17 out nocopy JTF_NUMBER_TABLE
720: , p4_a18 out nocopy JTF_NUMBER_TABLE
721: , p4_a19 out nocopy JTF_NUMBER_TABLE
722: , p4_a20 out nocopy JTF_NUMBER_TABLE
723: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
724: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
725: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
726: , p4_a24 out nocopy JTF_NUMBER_TABLE
727: , p4_a25 out nocopy JTF_NUMBER_TABLE

Line 724: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100

720: , p4_a18 out nocopy JTF_NUMBER_TABLE
721: , p4_a19 out nocopy JTF_NUMBER_TABLE
722: , p4_a20 out nocopy JTF_NUMBER_TABLE
723: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
724: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
725: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
726: , p4_a24 out nocopy JTF_NUMBER_TABLE
727: , p4_a25 out nocopy JTF_NUMBER_TABLE
728: , p4_a26 out nocopy JTF_NUMBER_TABLE

Line 725: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100

721: , p4_a19 out nocopy JTF_NUMBER_TABLE
722: , p4_a20 out nocopy JTF_NUMBER_TABLE
723: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
724: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
725: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
726: , p4_a24 out nocopy JTF_NUMBER_TABLE
727: , p4_a25 out nocopy JTF_NUMBER_TABLE
728: , p4_a26 out nocopy JTF_NUMBER_TABLE
729: );

Line 754: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100

750: , p3_a17 out nocopy JTF_NUMBER_TABLE
751: , p3_a18 out nocopy JTF_NUMBER_TABLE
752: , p3_a19 out nocopy JTF_NUMBER_TABLE
753: , p3_a20 out nocopy JTF_NUMBER_TABLE
754: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
755: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
756: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
757: , p3_a24 out nocopy JTF_NUMBER_TABLE
758: , p3_a25 out nocopy JTF_NUMBER_TABLE

Line 755: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100

751: , p3_a18 out nocopy JTF_NUMBER_TABLE
752: , p3_a19 out nocopy JTF_NUMBER_TABLE
753: , p3_a20 out nocopy JTF_NUMBER_TABLE
754: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
755: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
756: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
757: , p3_a24 out nocopy JTF_NUMBER_TABLE
758: , p3_a25 out nocopy JTF_NUMBER_TABLE
759: , p3_a26 out nocopy JTF_NUMBER_TABLE

Line 756: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100

752: , p3_a19 out nocopy JTF_NUMBER_TABLE
753: , p3_a20 out nocopy JTF_NUMBER_TABLE
754: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
755: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
756: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
757: , p3_a24 out nocopy JTF_NUMBER_TABLE
758: , p3_a25 out nocopy JTF_NUMBER_TABLE
759: , p3_a26 out nocopy JTF_NUMBER_TABLE
760: );

Line 857: , p1_a7 JTF_VARCHAR2_TABLE_100

853: , p1_a3 JTF_NUMBER_TABLE
854: , p1_a4 JTF_NUMBER_TABLE
855: , p1_a5 JTF_NUMBER_TABLE
856: , p1_a6 JTF_NUMBER_TABLE
857: , p1_a7 JTF_VARCHAR2_TABLE_100
858: , p1_a8 JTF_VARCHAR2_TABLE_100
859: , p1_a9 JTF_VARCHAR2_TABLE_100
860: , p2_a0 out nocopy JTF_NUMBER_TABLE
861: , p2_a1 out nocopy JTF_DATE_TABLE

Line 858: , p1_a8 JTF_VARCHAR2_TABLE_100

854: , p1_a4 JTF_NUMBER_TABLE
855: , p1_a5 JTF_NUMBER_TABLE
856: , p1_a6 JTF_NUMBER_TABLE
857: , p1_a7 JTF_VARCHAR2_TABLE_100
858: , p1_a8 JTF_VARCHAR2_TABLE_100
859: , p1_a9 JTF_VARCHAR2_TABLE_100
860: , p2_a0 out nocopy JTF_NUMBER_TABLE
861: , p2_a1 out nocopy JTF_DATE_TABLE
862: , p2_a2 out nocopy JTF_DATE_TABLE

Line 859: , p1_a9 JTF_VARCHAR2_TABLE_100

855: , p1_a5 JTF_NUMBER_TABLE
856: , p1_a6 JTF_NUMBER_TABLE
857: , p1_a7 JTF_VARCHAR2_TABLE_100
858: , p1_a8 JTF_VARCHAR2_TABLE_100
859: , p1_a9 JTF_VARCHAR2_TABLE_100
860: , p2_a0 out nocopy JTF_NUMBER_TABLE
861: , p2_a1 out nocopy JTF_DATE_TABLE
862: , p2_a2 out nocopy JTF_DATE_TABLE
863: , p2_a3 out nocopy JTF_DATE_TABLE

Line 881: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100

877: , p2_a17 out nocopy JTF_NUMBER_TABLE
878: , p2_a18 out nocopy JTF_NUMBER_TABLE
879: , p2_a19 out nocopy JTF_NUMBER_TABLE
880: , p2_a20 out nocopy JTF_NUMBER_TABLE
881: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
882: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
883: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
884: , p2_a24 out nocopy JTF_NUMBER_TABLE
885: , p2_a25 out nocopy JTF_NUMBER_TABLE

Line 882: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100

878: , p2_a18 out nocopy JTF_NUMBER_TABLE
879: , p2_a19 out nocopy JTF_NUMBER_TABLE
880: , p2_a20 out nocopy JTF_NUMBER_TABLE
881: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
882: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
883: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
884: , p2_a24 out nocopy JTF_NUMBER_TABLE
885: , p2_a25 out nocopy JTF_NUMBER_TABLE
886: , p2_a26 out nocopy JTF_NUMBER_TABLE

Line 883: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100

879: , p2_a19 out nocopy JTF_NUMBER_TABLE
880: , p2_a20 out nocopy JTF_NUMBER_TABLE
881: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
882: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
883: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
884: , p2_a24 out nocopy JTF_NUMBER_TABLE
885: , p2_a25 out nocopy JTF_NUMBER_TABLE
886: , p2_a26 out nocopy JTF_NUMBER_TABLE
887: );

Line 912: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100

908: , p3_a17 out nocopy JTF_NUMBER_TABLE
909: , p3_a18 out nocopy JTF_NUMBER_TABLE
910: , p3_a19 out nocopy JTF_NUMBER_TABLE
911: , p3_a20 out nocopy JTF_NUMBER_TABLE
912: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
913: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
914: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
915: , p3_a24 out nocopy JTF_NUMBER_TABLE
916: , p3_a25 out nocopy JTF_NUMBER_TABLE

Line 913: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100

909: , p3_a18 out nocopy JTF_NUMBER_TABLE
910: , p3_a19 out nocopy JTF_NUMBER_TABLE
911: , p3_a20 out nocopy JTF_NUMBER_TABLE
912: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
913: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
914: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
915: , p3_a24 out nocopy JTF_NUMBER_TABLE
916: , p3_a25 out nocopy JTF_NUMBER_TABLE
917: , p3_a26 out nocopy JTF_NUMBER_TABLE

Line 914: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100

910: , p3_a19 out nocopy JTF_NUMBER_TABLE
911: , p3_a20 out nocopy JTF_NUMBER_TABLE
912: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
913: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
914: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
915: , p3_a24 out nocopy JTF_NUMBER_TABLE
916: , p3_a25 out nocopy JTF_NUMBER_TABLE
917: , p3_a26 out nocopy JTF_NUMBER_TABLE
918: , x_return_status out nocopy VARCHAR2

Line 948: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100

944: , p5_a17 out nocopy JTF_NUMBER_TABLE
945: , p5_a18 out nocopy JTF_NUMBER_TABLE
946: , p5_a19 out nocopy JTF_NUMBER_TABLE
947: , p5_a20 out nocopy JTF_NUMBER_TABLE
948: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
949: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
950: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
951: , p5_a24 out nocopy JTF_NUMBER_TABLE
952: , p5_a25 out nocopy JTF_NUMBER_TABLE

Line 949: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100

945: , p5_a18 out nocopy JTF_NUMBER_TABLE
946: , p5_a19 out nocopy JTF_NUMBER_TABLE
947: , p5_a20 out nocopy JTF_NUMBER_TABLE
948: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
949: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
950: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
951: , p5_a24 out nocopy JTF_NUMBER_TABLE
952: , p5_a25 out nocopy JTF_NUMBER_TABLE
953: , p5_a26 out nocopy JTF_NUMBER_TABLE

Line 950: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100

946: , p5_a19 out nocopy JTF_NUMBER_TABLE
947: , p5_a20 out nocopy JTF_NUMBER_TABLE
948: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
949: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
950: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
951: , p5_a24 out nocopy JTF_NUMBER_TABLE
952: , p5_a25 out nocopy JTF_NUMBER_TABLE
953: , p5_a26 out nocopy JTF_NUMBER_TABLE
954: , x_return_status out nocopy VARCHAR2

Line 991: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

987: , p5_a24 out nocopy NUMBER
988: , p5_a25 out nocopy NUMBER
989: , p5_a26 out nocopy NUMBER
990: , p6_a0 out nocopy JTF_NUMBER_TABLE
991: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a2 out nocopy JTF_NUMBER_TABLE
993: , p6_a3 out nocopy JTF_NUMBER_TABLE
994: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
995: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 996: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

992: , p6_a2 out nocopy JTF_NUMBER_TABLE
993: , p6_a3 out nocopy JTF_NUMBER_TABLE
994: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
995: , p6_a5 out nocopy JTF_NUMBER_TABLE
996: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
997: , p6_a7 out nocopy JTF_NUMBER_TABLE
998: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
999: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1000: , x_return_status out nocopy VARCHAR2

Line 998: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

994: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
995: , p6_a5 out nocopy JTF_NUMBER_TABLE
996: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
997: , p6_a7 out nocopy JTF_NUMBER_TABLE
998: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
999: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1000: , x_return_status out nocopy VARCHAR2
1001: , x_msg_count out nocopy NUMBER
1002: , x_msg_data out nocopy VARCHAR2

Line 999: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

995: , p6_a5 out nocopy JTF_NUMBER_TABLE
996: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
997: , p6_a7 out nocopy JTF_NUMBER_TABLE
998: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
999: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1000: , x_return_status out nocopy VARCHAR2
1001: , x_msg_count out nocopy NUMBER
1002: , x_msg_data out nocopy VARCHAR2
1003: );

Line 1035: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

1031: , p3_a24 out nocopy NUMBER
1032: , p3_a25 out nocopy NUMBER
1033: , p3_a26 out nocopy NUMBER
1034: , p4_a0 out nocopy JTF_NUMBER_TABLE
1035: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p4_a2 out nocopy JTF_NUMBER_TABLE
1037: , p4_a3 out nocopy JTF_NUMBER_TABLE
1038: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1039: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 1040: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

1036: , p4_a2 out nocopy JTF_NUMBER_TABLE
1037: , p4_a3 out nocopy JTF_NUMBER_TABLE
1038: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1039: , p4_a5 out nocopy JTF_NUMBER_TABLE
1040: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p4_a7 out nocopy JTF_NUMBER_TABLE
1042: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1044: , x_return_status out nocopy VARCHAR2

Line 1042: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

1038: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1039: , p4_a5 out nocopy JTF_NUMBER_TABLE
1040: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p4_a7 out nocopy JTF_NUMBER_TABLE
1042: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1044: , x_return_status out nocopy VARCHAR2
1045: , x_msg_count out nocopy NUMBER
1046: , x_msg_data out nocopy VARCHAR2

Line 1043: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

1039: , p4_a5 out nocopy JTF_NUMBER_TABLE
1040: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p4_a7 out nocopy JTF_NUMBER_TABLE
1042: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1044: , x_return_status out nocopy VARCHAR2
1045: , x_msg_count out nocopy NUMBER
1046: , x_msg_data out nocopy VARCHAR2
1047: );