DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_FEE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_lease_quote_fee_pvt_w as
2: /* $Header: OKLEQUFB.pls 120.6 2006/03/16 10:09:26 asawanka noship $ */
3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package body okl_lease_quote_fee_pvt_w as
2: /* $Header: OKLEQUFB.pls 120.6 2006/03/16 10:09:26 asawanka noship $ */
3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLEQUFB.pls 120.6 2006/03/16 10:09:26 asawanka noship $ */
3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100

Line 42: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

38: end loop;
39: end if;
40: end if;
41: end rosetta_table_copy_in_p24;
42: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a1 out nocopy JTF_NUMBER_TABLE

39: end if;
40: end if;
41: end rosetta_table_copy_in_p24;
42: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE

Line 45: , a3 out nocopy JTF_NUMBER_TABLE

41: end rosetta_table_copy_in_p24;
42: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 47: , a5 out nocopy JTF_NUMBER_TABLE

43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_300
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

Line 48: , a6 out nocopy JTF_NUMBER_TABLE

44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_300
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: a0 := JTF_NUMBER_TABLE();

53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();

Line 58: a1 := JTF_NUMBER_TABLE();

54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();

Line 60: a3 := JTF_NUMBER_TABLE();

56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_300();

Line 62: a5 := JTF_NUMBER_TABLE();

58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_300();
65: a8 := JTF_VARCHAR2_TABLE_2000();
66: a9 := JTF_VARCHAR2_TABLE_2000();

Line 63: a6 := JTF_NUMBER_TABLE();

59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_300();
65: a8 := JTF_VARCHAR2_TABLE_2000();
66: a9 := JTF_VARCHAR2_TABLE_2000();
67: a10 := JTF_VARCHAR2_TABLE_100();

Line 69: a0 := JTF_NUMBER_TABLE();

65: a8 := JTF_VARCHAR2_TABLE_2000();
66: a9 := JTF_VARCHAR2_TABLE_2000();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();

Line 70: a1 := JTF_NUMBER_TABLE();

66: a9 := JTF_VARCHAR2_TABLE_2000();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();

Line 72: a3 := JTF_NUMBER_TABLE();

68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_300();

Line 74: a5 := JTF_NUMBER_TABLE();

70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_300();
77: a8 := JTF_VARCHAR2_TABLE_2000();
78: a9 := JTF_VARCHAR2_TABLE_2000();

Line 75: a6 := JTF_NUMBER_TABLE();

71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_300();
77: a8 := JTF_VARCHAR2_TABLE_2000();
78: a9 := JTF_VARCHAR2_TABLE_2000();
79: a10 := JTF_VARCHAR2_TABLE_100();

Line 158: , p4_a0 JTF_NUMBER_TABLE

154: , p3_a35 VARCHAR2
155: , p3_a36 VARCHAR2
156: , p3_a37 VARCHAR2
157: , p3_a38 NUMBER
158: , p4_a0 JTF_NUMBER_TABLE
159: , p4_a1 JTF_NUMBER_TABLE
160: , p4_a2 JTF_VARCHAR2_TABLE_100
161: , p4_a3 JTF_NUMBER_TABLE
162: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 159: , p4_a1 JTF_NUMBER_TABLE

155: , p3_a36 VARCHAR2
156: , p3_a37 VARCHAR2
157: , p3_a38 NUMBER
158: , p4_a0 JTF_NUMBER_TABLE
159: , p4_a1 JTF_NUMBER_TABLE
160: , p4_a2 JTF_VARCHAR2_TABLE_100
161: , p4_a3 JTF_NUMBER_TABLE
162: , p4_a4 JTF_VARCHAR2_TABLE_100
163: , p4_a5 JTF_NUMBER_TABLE

Line 161: , p4_a3 JTF_NUMBER_TABLE

157: , p3_a38 NUMBER
158: , p4_a0 JTF_NUMBER_TABLE
159: , p4_a1 JTF_NUMBER_TABLE
160: , p4_a2 JTF_VARCHAR2_TABLE_100
161: , p4_a3 JTF_NUMBER_TABLE
162: , p4_a4 JTF_VARCHAR2_TABLE_100
163: , p4_a5 JTF_NUMBER_TABLE
164: , p4_a6 JTF_NUMBER_TABLE
165: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 163: , p4_a5 JTF_NUMBER_TABLE

159: , p4_a1 JTF_NUMBER_TABLE
160: , p4_a2 JTF_VARCHAR2_TABLE_100
161: , p4_a3 JTF_NUMBER_TABLE
162: , p4_a4 JTF_VARCHAR2_TABLE_100
163: , p4_a5 JTF_NUMBER_TABLE
164: , p4_a6 JTF_NUMBER_TABLE
165: , p4_a7 JTF_VARCHAR2_TABLE_300
166: , p4_a8 JTF_VARCHAR2_TABLE_2000
167: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 164: , p4_a6 JTF_NUMBER_TABLE

160: , p4_a2 JTF_VARCHAR2_TABLE_100
161: , p4_a3 JTF_NUMBER_TABLE
162: , p4_a4 JTF_VARCHAR2_TABLE_100
163: , p4_a5 JTF_NUMBER_TABLE
164: , p4_a6 JTF_NUMBER_TABLE
165: , p4_a7 JTF_VARCHAR2_TABLE_300
166: , p4_a8 JTF_VARCHAR2_TABLE_2000
167: , p4_a9 JTF_VARCHAR2_TABLE_2000
168: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 183: , p6_a0 JTF_NUMBER_TABLE

179: , p5_a10 NUMBER
180: , p5_a11 NUMBER
181: , p5_a12 NUMBER
182: , p5_a13 NUMBER
183: , p6_a0 JTF_NUMBER_TABLE
184: , p6_a1 JTF_DATE_TABLE
185: , p6_a2 JTF_NUMBER_TABLE
186: , p6_a3 JTF_NUMBER_TABLE
187: , p6_a4 JTF_NUMBER_TABLE

Line 185: , p6_a2 JTF_NUMBER_TABLE

181: , p5_a12 NUMBER
182: , p5_a13 NUMBER
183: , p6_a0 JTF_NUMBER_TABLE
184: , p6_a1 JTF_DATE_TABLE
185: , p6_a2 JTF_NUMBER_TABLE
186: , p6_a3 JTF_NUMBER_TABLE
187: , p6_a4 JTF_NUMBER_TABLE
188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE

Line 186: , p6_a3 JTF_NUMBER_TABLE

182: , p5_a13 NUMBER
183: , p6_a0 JTF_NUMBER_TABLE
184: , p6_a1 JTF_DATE_TABLE
185: , p6_a2 JTF_NUMBER_TABLE
186: , p6_a3 JTF_NUMBER_TABLE
187: , p6_a4 JTF_NUMBER_TABLE
188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE
190: , p6_a7 JTF_NUMBER_TABLE

Line 187: , p6_a4 JTF_NUMBER_TABLE

183: , p6_a0 JTF_NUMBER_TABLE
184: , p6_a1 JTF_DATE_TABLE
185: , p6_a2 JTF_NUMBER_TABLE
186: , p6_a3 JTF_NUMBER_TABLE
187: , p6_a4 JTF_NUMBER_TABLE
188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE
190: , p6_a7 JTF_NUMBER_TABLE
191: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 188: , p6_a5 JTF_NUMBER_TABLE

184: , p6_a1 JTF_DATE_TABLE
185: , p6_a2 JTF_NUMBER_TABLE
186: , p6_a3 JTF_NUMBER_TABLE
187: , p6_a4 JTF_NUMBER_TABLE
188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE
190: , p6_a7 JTF_NUMBER_TABLE
191: , p6_a8 JTF_VARCHAR2_TABLE_100
192: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 189: , p6_a6 JTF_NUMBER_TABLE

185: , p6_a2 JTF_NUMBER_TABLE
186: , p6_a3 JTF_NUMBER_TABLE
187: , p6_a4 JTF_NUMBER_TABLE
188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE
190: , p6_a7 JTF_NUMBER_TABLE
191: , p6_a8 JTF_VARCHAR2_TABLE_100
192: , p6_a9 JTF_VARCHAR2_TABLE_100
193: , p7_a0 VARCHAR2

Line 190: , p6_a7 JTF_NUMBER_TABLE

186: , p6_a3 JTF_NUMBER_TABLE
187: , p6_a4 JTF_NUMBER_TABLE
188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE
190: , p6_a7 JTF_NUMBER_TABLE
191: , p6_a8 JTF_VARCHAR2_TABLE_100
192: , p6_a9 JTF_VARCHAR2_TABLE_100
193: , p7_a0 VARCHAR2
194: , p7_a1 NUMBER

Line 207: , p8_a0 JTF_NUMBER_TABLE

203: , p7_a10 NUMBER
204: , p7_a11 NUMBER
205: , p7_a12 NUMBER
206: , p7_a13 NUMBER
207: , p8_a0 JTF_NUMBER_TABLE
208: , p8_a1 JTF_DATE_TABLE
209: , p8_a2 JTF_NUMBER_TABLE
210: , p8_a3 JTF_NUMBER_TABLE
211: , p8_a4 JTF_NUMBER_TABLE

Line 209: , p8_a2 JTF_NUMBER_TABLE

205: , p7_a12 NUMBER
206: , p7_a13 NUMBER
207: , p8_a0 JTF_NUMBER_TABLE
208: , p8_a1 JTF_DATE_TABLE
209: , p8_a2 JTF_NUMBER_TABLE
210: , p8_a3 JTF_NUMBER_TABLE
211: , p8_a4 JTF_NUMBER_TABLE
212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE

Line 210: , p8_a3 JTF_NUMBER_TABLE

206: , p7_a13 NUMBER
207: , p8_a0 JTF_NUMBER_TABLE
208: , p8_a1 JTF_DATE_TABLE
209: , p8_a2 JTF_NUMBER_TABLE
210: , p8_a3 JTF_NUMBER_TABLE
211: , p8_a4 JTF_NUMBER_TABLE
212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE
214: , p8_a7 JTF_NUMBER_TABLE

Line 211: , p8_a4 JTF_NUMBER_TABLE

207: , p8_a0 JTF_NUMBER_TABLE
208: , p8_a1 JTF_DATE_TABLE
209: , p8_a2 JTF_NUMBER_TABLE
210: , p8_a3 JTF_NUMBER_TABLE
211: , p8_a4 JTF_NUMBER_TABLE
212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE
214: , p8_a7 JTF_NUMBER_TABLE
215: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 212: , p8_a5 JTF_NUMBER_TABLE

208: , p8_a1 JTF_DATE_TABLE
209: , p8_a2 JTF_NUMBER_TABLE
210: , p8_a3 JTF_NUMBER_TABLE
211: , p8_a4 JTF_NUMBER_TABLE
212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE
214: , p8_a7 JTF_NUMBER_TABLE
215: , p8_a8 JTF_VARCHAR2_TABLE_100
216: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 213: , p8_a6 JTF_NUMBER_TABLE

209: , p8_a2 JTF_NUMBER_TABLE
210: , p8_a3 JTF_NUMBER_TABLE
211: , p8_a4 JTF_NUMBER_TABLE
212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE
214: , p8_a7 JTF_NUMBER_TABLE
215: , p8_a8 JTF_VARCHAR2_TABLE_100
216: , p8_a9 JTF_VARCHAR2_TABLE_100
217: , x_fee_id out nocopy NUMBER

Line 214: , p8_a7 JTF_NUMBER_TABLE

210: , p8_a3 JTF_NUMBER_TABLE
211: , p8_a4 JTF_NUMBER_TABLE
212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE
214: , p8_a7 JTF_NUMBER_TABLE
215: , p8_a8 JTF_VARCHAR2_TABLE_100
216: , p8_a9 JTF_VARCHAR2_TABLE_100
217: , x_fee_id out nocopy NUMBER
218: , x_return_status out nocopy VARCHAR2

Line 545: , p4_a0 JTF_NUMBER_TABLE

541: , p3_a35 VARCHAR2
542: , p3_a36 VARCHAR2
543: , p3_a37 VARCHAR2
544: , p3_a38 NUMBER
545: , p4_a0 JTF_NUMBER_TABLE
546: , p4_a1 JTF_NUMBER_TABLE
547: , p4_a2 JTF_VARCHAR2_TABLE_100
548: , p4_a3 JTF_NUMBER_TABLE
549: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 546: , p4_a1 JTF_NUMBER_TABLE

542: , p3_a36 VARCHAR2
543: , p3_a37 VARCHAR2
544: , p3_a38 NUMBER
545: , p4_a0 JTF_NUMBER_TABLE
546: , p4_a1 JTF_NUMBER_TABLE
547: , p4_a2 JTF_VARCHAR2_TABLE_100
548: , p4_a3 JTF_NUMBER_TABLE
549: , p4_a4 JTF_VARCHAR2_TABLE_100
550: , p4_a5 JTF_NUMBER_TABLE

Line 548: , p4_a3 JTF_NUMBER_TABLE

544: , p3_a38 NUMBER
545: , p4_a0 JTF_NUMBER_TABLE
546: , p4_a1 JTF_NUMBER_TABLE
547: , p4_a2 JTF_VARCHAR2_TABLE_100
548: , p4_a3 JTF_NUMBER_TABLE
549: , p4_a4 JTF_VARCHAR2_TABLE_100
550: , p4_a5 JTF_NUMBER_TABLE
551: , p4_a6 JTF_NUMBER_TABLE
552: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 550: , p4_a5 JTF_NUMBER_TABLE

546: , p4_a1 JTF_NUMBER_TABLE
547: , p4_a2 JTF_VARCHAR2_TABLE_100
548: , p4_a3 JTF_NUMBER_TABLE
549: , p4_a4 JTF_VARCHAR2_TABLE_100
550: , p4_a5 JTF_NUMBER_TABLE
551: , p4_a6 JTF_NUMBER_TABLE
552: , p4_a7 JTF_VARCHAR2_TABLE_300
553: , p4_a8 JTF_VARCHAR2_TABLE_2000
554: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 551: , p4_a6 JTF_NUMBER_TABLE

547: , p4_a2 JTF_VARCHAR2_TABLE_100
548: , p4_a3 JTF_NUMBER_TABLE
549: , p4_a4 JTF_VARCHAR2_TABLE_100
550: , p4_a5 JTF_NUMBER_TABLE
551: , p4_a6 JTF_NUMBER_TABLE
552: , p4_a7 JTF_VARCHAR2_TABLE_300
553: , p4_a8 JTF_VARCHAR2_TABLE_2000
554: , p4_a9 JTF_VARCHAR2_TABLE_2000
555: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 570: , p6_a0 JTF_NUMBER_TABLE

566: , p5_a10 NUMBER
567: , p5_a11 NUMBER
568: , p5_a12 NUMBER
569: , p5_a13 NUMBER
570: , p6_a0 JTF_NUMBER_TABLE
571: , p6_a1 JTF_DATE_TABLE
572: , p6_a2 JTF_NUMBER_TABLE
573: , p6_a3 JTF_NUMBER_TABLE
574: , p6_a4 JTF_NUMBER_TABLE

Line 572: , p6_a2 JTF_NUMBER_TABLE

568: , p5_a12 NUMBER
569: , p5_a13 NUMBER
570: , p6_a0 JTF_NUMBER_TABLE
571: , p6_a1 JTF_DATE_TABLE
572: , p6_a2 JTF_NUMBER_TABLE
573: , p6_a3 JTF_NUMBER_TABLE
574: , p6_a4 JTF_NUMBER_TABLE
575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE

Line 573: , p6_a3 JTF_NUMBER_TABLE

569: , p5_a13 NUMBER
570: , p6_a0 JTF_NUMBER_TABLE
571: , p6_a1 JTF_DATE_TABLE
572: , p6_a2 JTF_NUMBER_TABLE
573: , p6_a3 JTF_NUMBER_TABLE
574: , p6_a4 JTF_NUMBER_TABLE
575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE
577: , p6_a7 JTF_NUMBER_TABLE

Line 574: , p6_a4 JTF_NUMBER_TABLE

570: , p6_a0 JTF_NUMBER_TABLE
571: , p6_a1 JTF_DATE_TABLE
572: , p6_a2 JTF_NUMBER_TABLE
573: , p6_a3 JTF_NUMBER_TABLE
574: , p6_a4 JTF_NUMBER_TABLE
575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE
577: , p6_a7 JTF_NUMBER_TABLE
578: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 575: , p6_a5 JTF_NUMBER_TABLE

571: , p6_a1 JTF_DATE_TABLE
572: , p6_a2 JTF_NUMBER_TABLE
573: , p6_a3 JTF_NUMBER_TABLE
574: , p6_a4 JTF_NUMBER_TABLE
575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE
577: , p6_a7 JTF_NUMBER_TABLE
578: , p6_a8 JTF_VARCHAR2_TABLE_100
579: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 576: , p6_a6 JTF_NUMBER_TABLE

572: , p6_a2 JTF_NUMBER_TABLE
573: , p6_a3 JTF_NUMBER_TABLE
574: , p6_a4 JTF_NUMBER_TABLE
575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE
577: , p6_a7 JTF_NUMBER_TABLE
578: , p6_a8 JTF_VARCHAR2_TABLE_100
579: , p6_a9 JTF_VARCHAR2_TABLE_100
580: , p7_a0 VARCHAR2

Line 577: , p6_a7 JTF_NUMBER_TABLE

573: , p6_a3 JTF_NUMBER_TABLE
574: , p6_a4 JTF_NUMBER_TABLE
575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE
577: , p6_a7 JTF_NUMBER_TABLE
578: , p6_a8 JTF_VARCHAR2_TABLE_100
579: , p6_a9 JTF_VARCHAR2_TABLE_100
580: , p7_a0 VARCHAR2
581: , p7_a1 NUMBER

Line 594: , p8_a0 JTF_NUMBER_TABLE

590: , p7_a10 NUMBER
591: , p7_a11 NUMBER
592: , p7_a12 NUMBER
593: , p7_a13 NUMBER
594: , p8_a0 JTF_NUMBER_TABLE
595: , p8_a1 JTF_DATE_TABLE
596: , p8_a2 JTF_NUMBER_TABLE
597: , p8_a3 JTF_NUMBER_TABLE
598: , p8_a4 JTF_NUMBER_TABLE

Line 596: , p8_a2 JTF_NUMBER_TABLE

592: , p7_a12 NUMBER
593: , p7_a13 NUMBER
594: , p8_a0 JTF_NUMBER_TABLE
595: , p8_a1 JTF_DATE_TABLE
596: , p8_a2 JTF_NUMBER_TABLE
597: , p8_a3 JTF_NUMBER_TABLE
598: , p8_a4 JTF_NUMBER_TABLE
599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE

Line 597: , p8_a3 JTF_NUMBER_TABLE

593: , p7_a13 NUMBER
594: , p8_a0 JTF_NUMBER_TABLE
595: , p8_a1 JTF_DATE_TABLE
596: , p8_a2 JTF_NUMBER_TABLE
597: , p8_a3 JTF_NUMBER_TABLE
598: , p8_a4 JTF_NUMBER_TABLE
599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE
601: , p8_a7 JTF_NUMBER_TABLE

Line 598: , p8_a4 JTF_NUMBER_TABLE

594: , p8_a0 JTF_NUMBER_TABLE
595: , p8_a1 JTF_DATE_TABLE
596: , p8_a2 JTF_NUMBER_TABLE
597: , p8_a3 JTF_NUMBER_TABLE
598: , p8_a4 JTF_NUMBER_TABLE
599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE
601: , p8_a7 JTF_NUMBER_TABLE
602: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 599: , p8_a5 JTF_NUMBER_TABLE

595: , p8_a1 JTF_DATE_TABLE
596: , p8_a2 JTF_NUMBER_TABLE
597: , p8_a3 JTF_NUMBER_TABLE
598: , p8_a4 JTF_NUMBER_TABLE
599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE
601: , p8_a7 JTF_NUMBER_TABLE
602: , p8_a8 JTF_VARCHAR2_TABLE_100
603: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 600: , p8_a6 JTF_NUMBER_TABLE

596: , p8_a2 JTF_NUMBER_TABLE
597: , p8_a3 JTF_NUMBER_TABLE
598: , p8_a4 JTF_NUMBER_TABLE
599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE
601: , p8_a7 JTF_NUMBER_TABLE
602: , p8_a8 JTF_VARCHAR2_TABLE_100
603: , p8_a9 JTF_VARCHAR2_TABLE_100
604: , x_return_status out nocopy VARCHAR2

Line 601: , p8_a7 JTF_NUMBER_TABLE

597: , p8_a3 JTF_NUMBER_TABLE
598: , p8_a4 JTF_NUMBER_TABLE
599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE
601: , p8_a7 JTF_NUMBER_TABLE
602: , p8_a8 JTF_VARCHAR2_TABLE_100
603: , p8_a9 JTF_VARCHAR2_TABLE_100
604: , x_return_status out nocopy VARCHAR2
605: , x_msg_count out nocopy NUMBER

Line 804: , p5_a0 JTF_NUMBER_TABLE

800: , p4_a35 VARCHAR2
801: , p4_a36 VARCHAR2
802: , p4_a37 VARCHAR2
803: , p4_a38 NUMBER
804: , p5_a0 JTF_NUMBER_TABLE
805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_100
807: , p5_a3 JTF_NUMBER_TABLE
808: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 805: , p5_a1 JTF_NUMBER_TABLE

801: , p4_a36 VARCHAR2
802: , p4_a37 VARCHAR2
803: , p4_a38 NUMBER
804: , p5_a0 JTF_NUMBER_TABLE
805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_100
807: , p5_a3 JTF_NUMBER_TABLE
808: , p5_a4 JTF_VARCHAR2_TABLE_100
809: , p5_a5 JTF_NUMBER_TABLE

Line 807: , p5_a3 JTF_NUMBER_TABLE

803: , p4_a38 NUMBER
804: , p5_a0 JTF_NUMBER_TABLE
805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_100
807: , p5_a3 JTF_NUMBER_TABLE
808: , p5_a4 JTF_VARCHAR2_TABLE_100
809: , p5_a5 JTF_NUMBER_TABLE
810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 809: , p5_a5 JTF_NUMBER_TABLE

805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_100
807: , p5_a3 JTF_NUMBER_TABLE
808: , p5_a4 JTF_VARCHAR2_TABLE_100
809: , p5_a5 JTF_NUMBER_TABLE
810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_VARCHAR2_TABLE_300
812: , p5_a8 JTF_VARCHAR2_TABLE_2000
813: , p5_a9 JTF_VARCHAR2_TABLE_2000

Line 810: , p5_a6 JTF_NUMBER_TABLE

806: , p5_a2 JTF_VARCHAR2_TABLE_100
807: , p5_a3 JTF_NUMBER_TABLE
808: , p5_a4 JTF_VARCHAR2_TABLE_100
809: , p5_a5 JTF_NUMBER_TABLE
810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_VARCHAR2_TABLE_300
812: , p5_a8 JTF_VARCHAR2_TABLE_2000
813: , p5_a9 JTF_VARCHAR2_TABLE_2000
814: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 829: , p7_a0 JTF_NUMBER_TABLE

825: , p6_a10 NUMBER
826: , p6_a11 NUMBER
827: , p6_a12 NUMBER
828: , p6_a13 NUMBER
829: , p7_a0 JTF_NUMBER_TABLE
830: , p7_a1 JTF_DATE_TABLE
831: , p7_a2 JTF_NUMBER_TABLE
832: , p7_a3 JTF_NUMBER_TABLE
833: , p7_a4 JTF_NUMBER_TABLE

Line 831: , p7_a2 JTF_NUMBER_TABLE

827: , p6_a12 NUMBER
828: , p6_a13 NUMBER
829: , p7_a0 JTF_NUMBER_TABLE
830: , p7_a1 JTF_DATE_TABLE
831: , p7_a2 JTF_NUMBER_TABLE
832: , p7_a3 JTF_NUMBER_TABLE
833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE

Line 832: , p7_a3 JTF_NUMBER_TABLE

828: , p6_a13 NUMBER
829: , p7_a0 JTF_NUMBER_TABLE
830: , p7_a1 JTF_DATE_TABLE
831: , p7_a2 JTF_NUMBER_TABLE
832: , p7_a3 JTF_NUMBER_TABLE
833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE

Line 833: , p7_a4 JTF_NUMBER_TABLE

829: , p7_a0 JTF_NUMBER_TABLE
830: , p7_a1 JTF_DATE_TABLE
831: , p7_a2 JTF_NUMBER_TABLE
832: , p7_a3 JTF_NUMBER_TABLE
833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100

Line 834: , p7_a5 JTF_NUMBER_TABLE

830: , p7_a1 JTF_DATE_TABLE
831: , p7_a2 JTF_NUMBER_TABLE
832: , p7_a3 JTF_NUMBER_TABLE
833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100

Line 835: , p7_a6 JTF_NUMBER_TABLE

831: , p7_a2 JTF_NUMBER_TABLE
832: , p7_a3 JTF_NUMBER_TABLE
833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100
839: , p8_a0 VARCHAR2

Line 836: , p7_a7 JTF_NUMBER_TABLE

832: , p7_a3 JTF_NUMBER_TABLE
833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100
839: , p8_a0 VARCHAR2
840: , p8_a1 NUMBER

Line 853: , p9_a0 JTF_NUMBER_TABLE

849: , p8_a10 NUMBER
850: , p8_a11 NUMBER
851: , p8_a12 NUMBER
852: , p8_a13 NUMBER
853: , p9_a0 JTF_NUMBER_TABLE
854: , p9_a1 JTF_DATE_TABLE
855: , p9_a2 JTF_NUMBER_TABLE
856: , p9_a3 JTF_NUMBER_TABLE
857: , p9_a4 JTF_NUMBER_TABLE

Line 855: , p9_a2 JTF_NUMBER_TABLE

851: , p8_a12 NUMBER
852: , p8_a13 NUMBER
853: , p9_a0 JTF_NUMBER_TABLE
854: , p9_a1 JTF_DATE_TABLE
855: , p9_a2 JTF_NUMBER_TABLE
856: , p9_a3 JTF_NUMBER_TABLE
857: , p9_a4 JTF_NUMBER_TABLE
858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE

Line 856: , p9_a3 JTF_NUMBER_TABLE

852: , p8_a13 NUMBER
853: , p9_a0 JTF_NUMBER_TABLE
854: , p9_a1 JTF_DATE_TABLE
855: , p9_a2 JTF_NUMBER_TABLE
856: , p9_a3 JTF_NUMBER_TABLE
857: , p9_a4 JTF_NUMBER_TABLE
858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE
860: , p9_a7 JTF_NUMBER_TABLE

Line 857: , p9_a4 JTF_NUMBER_TABLE

853: , p9_a0 JTF_NUMBER_TABLE
854: , p9_a1 JTF_DATE_TABLE
855: , p9_a2 JTF_NUMBER_TABLE
856: , p9_a3 JTF_NUMBER_TABLE
857: , p9_a4 JTF_NUMBER_TABLE
858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE
860: , p9_a7 JTF_NUMBER_TABLE
861: , p9_a8 JTF_VARCHAR2_TABLE_100

Line 858: , p9_a5 JTF_NUMBER_TABLE

854: , p9_a1 JTF_DATE_TABLE
855: , p9_a2 JTF_NUMBER_TABLE
856: , p9_a3 JTF_NUMBER_TABLE
857: , p9_a4 JTF_NUMBER_TABLE
858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE
860: , p9_a7 JTF_NUMBER_TABLE
861: , p9_a8 JTF_VARCHAR2_TABLE_100
862: , p9_a9 JTF_VARCHAR2_TABLE_100

Line 859: , p9_a6 JTF_NUMBER_TABLE

855: , p9_a2 JTF_NUMBER_TABLE
856: , p9_a3 JTF_NUMBER_TABLE
857: , p9_a4 JTF_NUMBER_TABLE
858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE
860: , p9_a7 JTF_NUMBER_TABLE
861: , p9_a8 JTF_VARCHAR2_TABLE_100
862: , p9_a9 JTF_VARCHAR2_TABLE_100
863: , x_fee_id out nocopy NUMBER

Line 860: , p9_a7 JTF_NUMBER_TABLE

856: , p9_a3 JTF_NUMBER_TABLE
857: , p9_a4 JTF_NUMBER_TABLE
858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE
860: , p9_a7 JTF_NUMBER_TABLE
861: , p9_a8 JTF_VARCHAR2_TABLE_100
862: , p9_a9 JTF_VARCHAR2_TABLE_100
863: , x_fee_id out nocopy NUMBER
864: , x_return_status out nocopy VARCHAR2