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.12020000.2 2012/08/07 12:51:06 racheruv ship $ */
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.12020000.2 2012/08/07 12:51:06 racheruv ship $ */
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.12020000.2 2012/08/07 12:51:06 racheruv ship $ */
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 14: , a11 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
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin
18: if a0 is not null and a0.count > 0 then

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

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

Line 45: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 47: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 49: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 50: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 55: , a11 out nocopy JTF_NUMBER_TABLE

51: , a7 out nocopy JTF_VARCHAR2_TABLE_300
52: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if t is null or t.count = 0 then

Line 60: a0 := JTF_NUMBER_TABLE();

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

Line 61: a1 := JTF_NUMBER_TABLE();

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

Line 63: a3 := JTF_NUMBER_TABLE();

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

Line 65: a5 := JTF_NUMBER_TABLE();

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

Line 66: a6 := JTF_NUMBER_TABLE();

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

Line 71: a11 := JTF_NUMBER_TABLE();

67: a7 := JTF_VARCHAR2_TABLE_300();
68: a8 := JTF_VARCHAR2_TABLE_2000();
69: a9 := JTF_VARCHAR2_TABLE_2000();
70: a10 := JTF_VARCHAR2_TABLE_100();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();

Line 73: a0 := JTF_NUMBER_TABLE();

69: a9 := JTF_VARCHAR2_TABLE_2000();
70: a10 := JTF_VARCHAR2_TABLE_100();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();

Line 74: a1 := JTF_NUMBER_TABLE();

70: a10 := JTF_VARCHAR2_TABLE_100();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();

Line 76: a3 := JTF_NUMBER_TABLE();

72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_300();

Line 78: a5 := JTF_NUMBER_TABLE();

74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_300();
81: a8 := JTF_VARCHAR2_TABLE_2000();
82: a9 := JTF_VARCHAR2_TABLE_2000();

Line 79: a6 := JTF_NUMBER_TABLE();

75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_300();
81: a8 := JTF_VARCHAR2_TABLE_2000();
82: a9 := JTF_VARCHAR2_TABLE_2000();
83: a10 := JTF_VARCHAR2_TABLE_100();

Line 84: a11 := JTF_NUMBER_TABLE();

80: a7 := JTF_VARCHAR2_TABLE_300();
81: a8 := JTF_VARCHAR2_TABLE_2000();
82: a9 := JTF_VARCHAR2_TABLE_2000();
83: a10 := JTF_VARCHAR2_TABLE_100();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: a1.extend(t.count);
88: a2.extend(t.count);

Line 166: , p4_a0 JTF_NUMBER_TABLE

162: , p3_a36 VARCHAR2
163: , p3_a37 VARCHAR2
164: , p3_a38 NUMBER
165: , p3_a39 VARCHAR2
166: , p4_a0 JTF_NUMBER_TABLE
167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 167: , p4_a1 JTF_NUMBER_TABLE

163: , p3_a37 VARCHAR2
164: , p3_a38 NUMBER
165: , p3_a39 VARCHAR2
166: , p4_a0 JTF_NUMBER_TABLE
167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE

Line 169: , p4_a3 JTF_NUMBER_TABLE

165: , p3_a39 VARCHAR2
166: , p4_a0 JTF_NUMBER_TABLE
167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE
172: , p4_a6 JTF_NUMBER_TABLE
173: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 171: , p4_a5 JTF_NUMBER_TABLE

167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE
172: , p4_a6 JTF_NUMBER_TABLE
173: , p4_a7 JTF_VARCHAR2_TABLE_300
174: , p4_a8 JTF_VARCHAR2_TABLE_2000
175: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 172: , p4_a6 JTF_NUMBER_TABLE

168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE
172: , p4_a6 JTF_NUMBER_TABLE
173: , p4_a7 JTF_VARCHAR2_TABLE_300
174: , p4_a8 JTF_VARCHAR2_TABLE_2000
175: , p4_a9 JTF_VARCHAR2_TABLE_2000
176: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 177: , p4_a11 JTF_NUMBER_TABLE

173: , p4_a7 JTF_VARCHAR2_TABLE_300
174: , p4_a8 JTF_VARCHAR2_TABLE_2000
175: , p4_a9 JTF_VARCHAR2_TABLE_2000
176: , p4_a10 JTF_VARCHAR2_TABLE_100
177: , p4_a11 JTF_NUMBER_TABLE
178: , p5_a0 VARCHAR2
179: , p5_a1 NUMBER
180: , p5_a2 VARCHAR2
181: , p5_a3 VARCHAR2

Line 192: , p6_a0 JTF_NUMBER_TABLE

188: , p5_a10 NUMBER
189: , p5_a11 NUMBER
190: , p5_a12 NUMBER
191: , p5_a13 NUMBER
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE

Line 194: , p6_a2 JTF_NUMBER_TABLE

190: , p5_a12 NUMBER
191: , p5_a13 NUMBER
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE

Line 195: , p6_a3 JTF_NUMBER_TABLE

191: , p5_a13 NUMBER
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE

Line 196: , p6_a4 JTF_NUMBER_TABLE

192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 197: , p6_a5 JTF_NUMBER_TABLE

193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 198: , p6_a6 JTF_NUMBER_TABLE

194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_VARCHAR2_TABLE_100
202: , p7_a0 VARCHAR2

Line 199: , p6_a7 JTF_NUMBER_TABLE

195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_VARCHAR2_TABLE_100
202: , p7_a0 VARCHAR2
203: , p7_a1 NUMBER

Line 216: , p8_a0 JTF_NUMBER_TABLE

212: , p7_a10 NUMBER
213: , p7_a11 NUMBER
214: , p7_a12 NUMBER
215: , p7_a13 NUMBER
216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE

Line 218: , p8_a2 JTF_NUMBER_TABLE

214: , p7_a12 NUMBER
215: , p7_a13 NUMBER
216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE

Line 219: , p8_a3 JTF_NUMBER_TABLE

215: , p7_a13 NUMBER
216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE

Line 220: , p8_a4 JTF_NUMBER_TABLE

216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 221: , p8_a5 JTF_NUMBER_TABLE

217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100
225: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 222: , p8_a6 JTF_NUMBER_TABLE

218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100
225: , p8_a9 JTF_VARCHAR2_TABLE_100
226: , x_fee_id out nocopy NUMBER

Line 223: , p8_a7 JTF_NUMBER_TABLE

219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100
225: , p8_a9 JTF_VARCHAR2_TABLE_100
226: , x_fee_id out nocopy NUMBER
227: , x_return_status out nocopy VARCHAR2

Line 559: , p4_a0 JTF_NUMBER_TABLE

555: , p3_a36 VARCHAR2
556: , p3_a37 VARCHAR2
557: , p3_a38 NUMBER
558: , p3_a39 VARCHAR2
559: , p4_a0 JTF_NUMBER_TABLE
560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 560: , p4_a1 JTF_NUMBER_TABLE

556: , p3_a37 VARCHAR2
557: , p3_a38 NUMBER
558: , p3_a39 VARCHAR2
559: , p4_a0 JTF_NUMBER_TABLE
560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE

Line 562: , p4_a3 JTF_NUMBER_TABLE

558: , p3_a39 VARCHAR2
559: , p4_a0 JTF_NUMBER_TABLE
560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE
565: , p4_a6 JTF_NUMBER_TABLE
566: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 564: , p4_a5 JTF_NUMBER_TABLE

560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE
565: , p4_a6 JTF_NUMBER_TABLE
566: , p4_a7 JTF_VARCHAR2_TABLE_300
567: , p4_a8 JTF_VARCHAR2_TABLE_2000
568: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 565: , p4_a6 JTF_NUMBER_TABLE

561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE
565: , p4_a6 JTF_NUMBER_TABLE
566: , p4_a7 JTF_VARCHAR2_TABLE_300
567: , p4_a8 JTF_VARCHAR2_TABLE_2000
568: , p4_a9 JTF_VARCHAR2_TABLE_2000
569: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 570: , p4_a11 JTF_NUMBER_TABLE

566: , p4_a7 JTF_VARCHAR2_TABLE_300
567: , p4_a8 JTF_VARCHAR2_TABLE_2000
568: , p4_a9 JTF_VARCHAR2_TABLE_2000
569: , p4_a10 JTF_VARCHAR2_TABLE_100
570: , p4_a11 JTF_NUMBER_TABLE
571: , p5_a0 VARCHAR2
572: , p5_a1 NUMBER
573: , p5_a2 VARCHAR2
574: , p5_a3 VARCHAR2

Line 585: , p6_a0 JTF_NUMBER_TABLE

581: , p5_a10 NUMBER
582: , p5_a11 NUMBER
583: , p5_a12 NUMBER
584: , p5_a13 NUMBER
585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE

Line 587: , p6_a2 JTF_NUMBER_TABLE

583: , p5_a12 NUMBER
584: , p5_a13 NUMBER
585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE

Line 588: , p6_a3 JTF_NUMBER_TABLE

584: , p5_a13 NUMBER
585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE

Line 589: , p6_a4 JTF_NUMBER_TABLE

585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 590: , p6_a5 JTF_NUMBER_TABLE

586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100
594: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 591: , p6_a6 JTF_NUMBER_TABLE

587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100
594: , p6_a9 JTF_VARCHAR2_TABLE_100
595: , p7_a0 VARCHAR2

Line 592: , p6_a7 JTF_NUMBER_TABLE

588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100
594: , p6_a9 JTF_VARCHAR2_TABLE_100
595: , p7_a0 VARCHAR2
596: , p7_a1 NUMBER

Line 609: , p8_a0 JTF_NUMBER_TABLE

605: , p7_a10 NUMBER
606: , p7_a11 NUMBER
607: , p7_a12 NUMBER
608: , p7_a13 NUMBER
609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE

Line 611: , p8_a2 JTF_NUMBER_TABLE

607: , p7_a12 NUMBER
608: , p7_a13 NUMBER
609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE

Line 612: , p8_a3 JTF_NUMBER_TABLE

608: , p7_a13 NUMBER
609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE

Line 613: , p8_a4 JTF_NUMBER_TABLE

609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 614: , p8_a5 JTF_NUMBER_TABLE

610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100
618: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 615: , p8_a6 JTF_NUMBER_TABLE

611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100
618: , p8_a9 JTF_VARCHAR2_TABLE_100
619: , x_return_status out nocopy VARCHAR2

Line 616: , p8_a7 JTF_NUMBER_TABLE

612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100
618: , p8_a9 JTF_VARCHAR2_TABLE_100
619: , x_return_status out nocopy VARCHAR2
620: , x_msg_count out nocopy NUMBER

Line 822: , p5_a0 JTF_NUMBER_TABLE

818: , p4_a36 VARCHAR2
819: , p4_a37 VARCHAR2
820: , p4_a38 NUMBER
821: , p4_a39 VARCHAR2
822: , p5_a0 JTF_NUMBER_TABLE
823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 823: , p5_a1 JTF_NUMBER_TABLE

819: , p4_a37 VARCHAR2
820: , p4_a38 NUMBER
821: , p4_a39 VARCHAR2
822: , p5_a0 JTF_NUMBER_TABLE
823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE

Line 825: , p5_a3 JTF_NUMBER_TABLE

821: , p4_a39 VARCHAR2
822: , p5_a0 JTF_NUMBER_TABLE
823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE
828: , p5_a6 JTF_NUMBER_TABLE
829: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 827: , p5_a5 JTF_NUMBER_TABLE

823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE
828: , p5_a6 JTF_NUMBER_TABLE
829: , p5_a7 JTF_VARCHAR2_TABLE_300
830: , p5_a8 JTF_VARCHAR2_TABLE_2000
831: , p5_a9 JTF_VARCHAR2_TABLE_2000

Line 828: , p5_a6 JTF_NUMBER_TABLE

824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE
828: , p5_a6 JTF_NUMBER_TABLE
829: , p5_a7 JTF_VARCHAR2_TABLE_300
830: , p5_a8 JTF_VARCHAR2_TABLE_2000
831: , p5_a9 JTF_VARCHAR2_TABLE_2000
832: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 833: , p5_a11 JTF_NUMBER_TABLE

829: , p5_a7 JTF_VARCHAR2_TABLE_300
830: , p5_a8 JTF_VARCHAR2_TABLE_2000
831: , p5_a9 JTF_VARCHAR2_TABLE_2000
832: , p5_a10 JTF_VARCHAR2_TABLE_100
833: , p5_a11 JTF_NUMBER_TABLE
834: , p6_a0 VARCHAR2
835: , p6_a1 NUMBER
836: , p6_a2 VARCHAR2
837: , p6_a3 VARCHAR2

Line 848: , p7_a0 JTF_NUMBER_TABLE

844: , p6_a10 NUMBER
845: , p6_a11 NUMBER
846: , p6_a12 NUMBER
847: , p6_a13 NUMBER
848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE

Line 850: , p7_a2 JTF_NUMBER_TABLE

846: , p6_a12 NUMBER
847: , p6_a13 NUMBER
848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE

Line 851: , p7_a3 JTF_NUMBER_TABLE

847: , p6_a13 NUMBER
848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE

Line 852: , p7_a4 JTF_NUMBER_TABLE

848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100

Line 853: , p7_a5 JTF_NUMBER_TABLE

849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100
857: , p7_a9 JTF_VARCHAR2_TABLE_100

Line 854: , p7_a6 JTF_NUMBER_TABLE

850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100
857: , p7_a9 JTF_VARCHAR2_TABLE_100
858: , p8_a0 VARCHAR2

Line 855: , p7_a7 JTF_NUMBER_TABLE

851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100
857: , p7_a9 JTF_VARCHAR2_TABLE_100
858: , p8_a0 VARCHAR2
859: , p8_a1 NUMBER

Line 872: , p9_a0 JTF_NUMBER_TABLE

868: , p8_a10 NUMBER
869: , p8_a11 NUMBER
870: , p8_a12 NUMBER
871: , p8_a13 NUMBER
872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE

Line 874: , p9_a2 JTF_NUMBER_TABLE

870: , p8_a12 NUMBER
871: , p8_a13 NUMBER
872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE

Line 875: , p9_a3 JTF_NUMBER_TABLE

871: , p8_a13 NUMBER
872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE

Line 876: , p9_a4 JTF_NUMBER_TABLE

872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100

Line 877: , p9_a5 JTF_NUMBER_TABLE

873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100
881: , p9_a9 JTF_VARCHAR2_TABLE_100

Line 878: , p9_a6 JTF_NUMBER_TABLE

874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100
881: , p9_a9 JTF_VARCHAR2_TABLE_100
882: , x_fee_id out nocopy NUMBER

Line 879: , p9_a7 JTF_NUMBER_TABLE

875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100
881: , p9_a9 JTF_VARCHAR2_TABLE_100
882: , x_fee_id out nocopy NUMBER
883: , x_return_status out nocopy VARCHAR2