APPS.OKL_LEASE_QUOTE_SERVICE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p17(t out nocopy okl_lease_quote_service_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_lease_quote_service_pvt_w as
2: /* $Header: OKLEQUSB.pls 120.2 2006/02/13 07:28:44 asawanka noship $ */
3: procedure rosetta_table_copy_in_p17(t out nocopy okl_lease_quote_service_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_service_pvt_w as
2: /* $Header: OKLEQUSB.pls 120.2 2006/02/13 07:28:44 asawanka noship $ */
3: procedure rosetta_table_copy_in_p17(t out nocopy okl_lease_quote_service_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: OKLEQUSB.pls 120.2 2006/02/13 07:28:44 asawanka noship $ */
3: procedure rosetta_table_copy_in_p17(t out nocopy okl_lease_quote_service_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_p17(t okl_lease_quote_service_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_p17;
42: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_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_p17;
42: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_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_p17;
42: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_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 145: , p4_a0 JTF_NUMBER_TABLE

141: , p3_a22 NUMBER
142: , p3_a23 VARCHAR2
143: , p3_a24 VARCHAR2
144: , p3_a25 VARCHAR2
145: , p4_a0 JTF_NUMBER_TABLE
146: , p4_a1 JTF_NUMBER_TABLE
147: , p4_a2 JTF_VARCHAR2_TABLE_100
148: , p4_a3 JTF_NUMBER_TABLE
149: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 146: , p4_a1 JTF_NUMBER_TABLE

142: , p3_a23 VARCHAR2
143: , p3_a24 VARCHAR2
144: , p3_a25 VARCHAR2
145: , p4_a0 JTF_NUMBER_TABLE
146: , p4_a1 JTF_NUMBER_TABLE
147: , p4_a2 JTF_VARCHAR2_TABLE_100
148: , p4_a3 JTF_NUMBER_TABLE
149: , p4_a4 JTF_VARCHAR2_TABLE_100
150: , p4_a5 JTF_NUMBER_TABLE

Line 148: , p4_a3 JTF_NUMBER_TABLE

144: , p3_a25 VARCHAR2
145: , p4_a0 JTF_NUMBER_TABLE
146: , p4_a1 JTF_NUMBER_TABLE
147: , p4_a2 JTF_VARCHAR2_TABLE_100
148: , p4_a3 JTF_NUMBER_TABLE
149: , p4_a4 JTF_VARCHAR2_TABLE_100
150: , p4_a5 JTF_NUMBER_TABLE
151: , p4_a6 JTF_NUMBER_TABLE
152: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 150: , p4_a5 JTF_NUMBER_TABLE

146: , p4_a1 JTF_NUMBER_TABLE
147: , p4_a2 JTF_VARCHAR2_TABLE_100
148: , p4_a3 JTF_NUMBER_TABLE
149: , p4_a4 JTF_VARCHAR2_TABLE_100
150: , p4_a5 JTF_NUMBER_TABLE
151: , p4_a6 JTF_NUMBER_TABLE
152: , p4_a7 JTF_VARCHAR2_TABLE_300
153: , p4_a8 JTF_VARCHAR2_TABLE_2000
154: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 151: , p4_a6 JTF_NUMBER_TABLE

147: , p4_a2 JTF_VARCHAR2_TABLE_100
148: , p4_a3 JTF_NUMBER_TABLE
149: , p4_a4 JTF_VARCHAR2_TABLE_100
150: , p4_a5 JTF_NUMBER_TABLE
151: , p4_a6 JTF_NUMBER_TABLE
152: , p4_a7 JTF_VARCHAR2_TABLE_300
153: , p4_a8 JTF_VARCHAR2_TABLE_2000
154: , p4_a9 JTF_VARCHAR2_TABLE_2000
155: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 170: , p6_a0 JTF_NUMBER_TABLE

166: , p5_a10 NUMBER
167: , p5_a11 NUMBER
168: , p5_a12 NUMBER
169: , p5_a13 NUMBER
170: , p6_a0 JTF_NUMBER_TABLE
171: , p6_a1 JTF_DATE_TABLE
172: , p6_a2 JTF_NUMBER_TABLE
173: , p6_a3 JTF_NUMBER_TABLE
174: , p6_a4 JTF_NUMBER_TABLE

Line 172: , p6_a2 JTF_NUMBER_TABLE

168: , p5_a12 NUMBER
169: , p5_a13 NUMBER
170: , p6_a0 JTF_NUMBER_TABLE
171: , p6_a1 JTF_DATE_TABLE
172: , p6_a2 JTF_NUMBER_TABLE
173: , p6_a3 JTF_NUMBER_TABLE
174: , p6_a4 JTF_NUMBER_TABLE
175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE

Line 173: , p6_a3 JTF_NUMBER_TABLE

169: , p5_a13 NUMBER
170: , p6_a0 JTF_NUMBER_TABLE
171: , p6_a1 JTF_DATE_TABLE
172: , p6_a2 JTF_NUMBER_TABLE
173: , p6_a3 JTF_NUMBER_TABLE
174: , p6_a4 JTF_NUMBER_TABLE
175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE
177: , p6_a7 JTF_NUMBER_TABLE

Line 174: , p6_a4 JTF_NUMBER_TABLE

170: , p6_a0 JTF_NUMBER_TABLE
171: , p6_a1 JTF_DATE_TABLE
172: , p6_a2 JTF_NUMBER_TABLE
173: , p6_a3 JTF_NUMBER_TABLE
174: , p6_a4 JTF_NUMBER_TABLE
175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE
177: , p6_a7 JTF_NUMBER_TABLE
178: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 175: , p6_a5 JTF_NUMBER_TABLE

171: , p6_a1 JTF_DATE_TABLE
172: , p6_a2 JTF_NUMBER_TABLE
173: , p6_a3 JTF_NUMBER_TABLE
174: , p6_a4 JTF_NUMBER_TABLE
175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE
177: , p6_a7 JTF_NUMBER_TABLE
178: , p6_a8 JTF_VARCHAR2_TABLE_100
179: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 176: , p6_a6 JTF_NUMBER_TABLE

172: , p6_a2 JTF_NUMBER_TABLE
173: , p6_a3 JTF_NUMBER_TABLE
174: , p6_a4 JTF_NUMBER_TABLE
175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE
177: , p6_a7 JTF_NUMBER_TABLE
178: , p6_a8 JTF_VARCHAR2_TABLE_100
179: , p6_a9 JTF_VARCHAR2_TABLE_100
180: , p7_a0 VARCHAR2

Line 177: , p6_a7 JTF_NUMBER_TABLE

173: , p6_a3 JTF_NUMBER_TABLE
174: , p6_a4 JTF_NUMBER_TABLE
175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE
177: , p6_a7 JTF_NUMBER_TABLE
178: , p6_a8 JTF_VARCHAR2_TABLE_100
179: , p6_a9 JTF_VARCHAR2_TABLE_100
180: , p7_a0 VARCHAR2
181: , p7_a1 NUMBER

Line 194: , p8_a0 JTF_NUMBER_TABLE

190: , p7_a10 NUMBER
191: , p7_a11 NUMBER
192: , p7_a12 NUMBER
193: , p7_a13 NUMBER
194: , p8_a0 JTF_NUMBER_TABLE
195: , p8_a1 JTF_DATE_TABLE
196: , p8_a2 JTF_NUMBER_TABLE
197: , p8_a3 JTF_NUMBER_TABLE
198: , p8_a4 JTF_NUMBER_TABLE

Line 196: , p8_a2 JTF_NUMBER_TABLE

192: , p7_a12 NUMBER
193: , p7_a13 NUMBER
194: , p8_a0 JTF_NUMBER_TABLE
195: , p8_a1 JTF_DATE_TABLE
196: , p8_a2 JTF_NUMBER_TABLE
197: , p8_a3 JTF_NUMBER_TABLE
198: , p8_a4 JTF_NUMBER_TABLE
199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE

Line 197: , p8_a3 JTF_NUMBER_TABLE

193: , p7_a13 NUMBER
194: , p8_a0 JTF_NUMBER_TABLE
195: , p8_a1 JTF_DATE_TABLE
196: , p8_a2 JTF_NUMBER_TABLE
197: , p8_a3 JTF_NUMBER_TABLE
198: , p8_a4 JTF_NUMBER_TABLE
199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE
201: , p8_a7 JTF_NUMBER_TABLE

Line 198: , p8_a4 JTF_NUMBER_TABLE

194: , p8_a0 JTF_NUMBER_TABLE
195: , p8_a1 JTF_DATE_TABLE
196: , p8_a2 JTF_NUMBER_TABLE
197: , p8_a3 JTF_NUMBER_TABLE
198: , p8_a4 JTF_NUMBER_TABLE
199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE
201: , p8_a7 JTF_NUMBER_TABLE
202: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 199: , p8_a5 JTF_NUMBER_TABLE

195: , p8_a1 JTF_DATE_TABLE
196: , p8_a2 JTF_NUMBER_TABLE
197: , p8_a3 JTF_NUMBER_TABLE
198: , p8_a4 JTF_NUMBER_TABLE
199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE
201: , p8_a7 JTF_NUMBER_TABLE
202: , p8_a8 JTF_VARCHAR2_TABLE_100
203: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 200: , p8_a6 JTF_NUMBER_TABLE

196: , p8_a2 JTF_NUMBER_TABLE
197: , p8_a3 JTF_NUMBER_TABLE
198: , p8_a4 JTF_NUMBER_TABLE
199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE
201: , p8_a7 JTF_NUMBER_TABLE
202: , p8_a8 JTF_VARCHAR2_TABLE_100
203: , p8_a9 JTF_VARCHAR2_TABLE_100
204: , x_service_id out nocopy NUMBER

Line 201: , p8_a7 JTF_NUMBER_TABLE

197: , p8_a3 JTF_NUMBER_TABLE
198: , p8_a4 JTF_NUMBER_TABLE
199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE
201: , p8_a7 JTF_NUMBER_TABLE
202: , p8_a8 JTF_VARCHAR2_TABLE_100
203: , p8_a9 JTF_VARCHAR2_TABLE_100
204: , x_service_id out nocopy NUMBER
205: , x_return_status out nocopy VARCHAR2

Line 381: , p4_a0 JTF_NUMBER_TABLE

377: , p3_a22 NUMBER
378: , p3_a23 VARCHAR2
379: , p3_a24 VARCHAR2
380: , p3_a25 VARCHAR2
381: , p4_a0 JTF_NUMBER_TABLE
382: , p4_a1 JTF_NUMBER_TABLE
383: , p4_a2 JTF_VARCHAR2_TABLE_100
384: , p4_a3 JTF_NUMBER_TABLE
385: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 382: , p4_a1 JTF_NUMBER_TABLE

378: , p3_a23 VARCHAR2
379: , p3_a24 VARCHAR2
380: , p3_a25 VARCHAR2
381: , p4_a0 JTF_NUMBER_TABLE
382: , p4_a1 JTF_NUMBER_TABLE
383: , p4_a2 JTF_VARCHAR2_TABLE_100
384: , p4_a3 JTF_NUMBER_TABLE
385: , p4_a4 JTF_VARCHAR2_TABLE_100
386: , p4_a5 JTF_NUMBER_TABLE

Line 384: , p4_a3 JTF_NUMBER_TABLE

380: , p3_a25 VARCHAR2
381: , p4_a0 JTF_NUMBER_TABLE
382: , p4_a1 JTF_NUMBER_TABLE
383: , p4_a2 JTF_VARCHAR2_TABLE_100
384: , p4_a3 JTF_NUMBER_TABLE
385: , p4_a4 JTF_VARCHAR2_TABLE_100
386: , p4_a5 JTF_NUMBER_TABLE
387: , p4_a6 JTF_NUMBER_TABLE
388: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 386: , p4_a5 JTF_NUMBER_TABLE

382: , p4_a1 JTF_NUMBER_TABLE
383: , p4_a2 JTF_VARCHAR2_TABLE_100
384: , p4_a3 JTF_NUMBER_TABLE
385: , p4_a4 JTF_VARCHAR2_TABLE_100
386: , p4_a5 JTF_NUMBER_TABLE
387: , p4_a6 JTF_NUMBER_TABLE
388: , p4_a7 JTF_VARCHAR2_TABLE_300
389: , p4_a8 JTF_VARCHAR2_TABLE_2000
390: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 387: , p4_a6 JTF_NUMBER_TABLE

383: , p4_a2 JTF_VARCHAR2_TABLE_100
384: , p4_a3 JTF_NUMBER_TABLE
385: , p4_a4 JTF_VARCHAR2_TABLE_100
386: , p4_a5 JTF_NUMBER_TABLE
387: , p4_a6 JTF_NUMBER_TABLE
388: , p4_a7 JTF_VARCHAR2_TABLE_300
389: , p4_a8 JTF_VARCHAR2_TABLE_2000
390: , p4_a9 JTF_VARCHAR2_TABLE_2000
391: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 406: , p6_a0 JTF_NUMBER_TABLE

402: , p5_a10 NUMBER
403: , p5_a11 NUMBER
404: , p5_a12 NUMBER
405: , p5_a13 NUMBER
406: , p6_a0 JTF_NUMBER_TABLE
407: , p6_a1 JTF_DATE_TABLE
408: , p6_a2 JTF_NUMBER_TABLE
409: , p6_a3 JTF_NUMBER_TABLE
410: , p6_a4 JTF_NUMBER_TABLE

Line 408: , p6_a2 JTF_NUMBER_TABLE

404: , p5_a12 NUMBER
405: , p5_a13 NUMBER
406: , p6_a0 JTF_NUMBER_TABLE
407: , p6_a1 JTF_DATE_TABLE
408: , p6_a2 JTF_NUMBER_TABLE
409: , p6_a3 JTF_NUMBER_TABLE
410: , p6_a4 JTF_NUMBER_TABLE
411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE

Line 409: , p6_a3 JTF_NUMBER_TABLE

405: , p5_a13 NUMBER
406: , p6_a0 JTF_NUMBER_TABLE
407: , p6_a1 JTF_DATE_TABLE
408: , p6_a2 JTF_NUMBER_TABLE
409: , p6_a3 JTF_NUMBER_TABLE
410: , p6_a4 JTF_NUMBER_TABLE
411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE
413: , p6_a7 JTF_NUMBER_TABLE

Line 410: , p6_a4 JTF_NUMBER_TABLE

406: , p6_a0 JTF_NUMBER_TABLE
407: , p6_a1 JTF_DATE_TABLE
408: , p6_a2 JTF_NUMBER_TABLE
409: , p6_a3 JTF_NUMBER_TABLE
410: , p6_a4 JTF_NUMBER_TABLE
411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE
413: , p6_a7 JTF_NUMBER_TABLE
414: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 411: , p6_a5 JTF_NUMBER_TABLE

407: , p6_a1 JTF_DATE_TABLE
408: , p6_a2 JTF_NUMBER_TABLE
409: , p6_a3 JTF_NUMBER_TABLE
410: , p6_a4 JTF_NUMBER_TABLE
411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE
413: , p6_a7 JTF_NUMBER_TABLE
414: , p6_a8 JTF_VARCHAR2_TABLE_100
415: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 412: , p6_a6 JTF_NUMBER_TABLE

408: , p6_a2 JTF_NUMBER_TABLE
409: , p6_a3 JTF_NUMBER_TABLE
410: , p6_a4 JTF_NUMBER_TABLE
411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE
413: , p6_a7 JTF_NUMBER_TABLE
414: , p6_a8 JTF_VARCHAR2_TABLE_100
415: , p6_a9 JTF_VARCHAR2_TABLE_100
416: , p7_a0 VARCHAR2

Line 413: , p6_a7 JTF_NUMBER_TABLE

409: , p6_a3 JTF_NUMBER_TABLE
410: , p6_a4 JTF_NUMBER_TABLE
411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE
413: , p6_a7 JTF_NUMBER_TABLE
414: , p6_a8 JTF_VARCHAR2_TABLE_100
415: , p6_a9 JTF_VARCHAR2_TABLE_100
416: , p7_a0 VARCHAR2
417: , p7_a1 NUMBER

Line 430: , p8_a0 JTF_NUMBER_TABLE

426: , p7_a10 NUMBER
427: , p7_a11 NUMBER
428: , p7_a12 NUMBER
429: , p7_a13 NUMBER
430: , p8_a0 JTF_NUMBER_TABLE
431: , p8_a1 JTF_DATE_TABLE
432: , p8_a2 JTF_NUMBER_TABLE
433: , p8_a3 JTF_NUMBER_TABLE
434: , p8_a4 JTF_NUMBER_TABLE

Line 432: , p8_a2 JTF_NUMBER_TABLE

428: , p7_a12 NUMBER
429: , p7_a13 NUMBER
430: , p8_a0 JTF_NUMBER_TABLE
431: , p8_a1 JTF_DATE_TABLE
432: , p8_a2 JTF_NUMBER_TABLE
433: , p8_a3 JTF_NUMBER_TABLE
434: , p8_a4 JTF_NUMBER_TABLE
435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE

Line 433: , p8_a3 JTF_NUMBER_TABLE

429: , p7_a13 NUMBER
430: , p8_a0 JTF_NUMBER_TABLE
431: , p8_a1 JTF_DATE_TABLE
432: , p8_a2 JTF_NUMBER_TABLE
433: , p8_a3 JTF_NUMBER_TABLE
434: , p8_a4 JTF_NUMBER_TABLE
435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE
437: , p8_a7 JTF_NUMBER_TABLE

Line 434: , p8_a4 JTF_NUMBER_TABLE

430: , p8_a0 JTF_NUMBER_TABLE
431: , p8_a1 JTF_DATE_TABLE
432: , p8_a2 JTF_NUMBER_TABLE
433: , p8_a3 JTF_NUMBER_TABLE
434: , p8_a4 JTF_NUMBER_TABLE
435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE
437: , p8_a7 JTF_NUMBER_TABLE
438: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 435: , p8_a5 JTF_NUMBER_TABLE

431: , p8_a1 JTF_DATE_TABLE
432: , p8_a2 JTF_NUMBER_TABLE
433: , p8_a3 JTF_NUMBER_TABLE
434: , p8_a4 JTF_NUMBER_TABLE
435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE
437: , p8_a7 JTF_NUMBER_TABLE
438: , p8_a8 JTF_VARCHAR2_TABLE_100
439: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 436: , p8_a6 JTF_NUMBER_TABLE

432: , p8_a2 JTF_NUMBER_TABLE
433: , p8_a3 JTF_NUMBER_TABLE
434: , p8_a4 JTF_NUMBER_TABLE
435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE
437: , p8_a7 JTF_NUMBER_TABLE
438: , p8_a8 JTF_VARCHAR2_TABLE_100
439: , p8_a9 JTF_VARCHAR2_TABLE_100
440: , x_return_status out nocopy VARCHAR2

Line 437: , p8_a7 JTF_NUMBER_TABLE

433: , p8_a3 JTF_NUMBER_TABLE
434: , p8_a4 JTF_NUMBER_TABLE
435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE
437: , p8_a7 JTF_NUMBER_TABLE
438: , p8_a8 JTF_VARCHAR2_TABLE_100
439: , p8_a9 JTF_VARCHAR2_TABLE_100
440: , x_return_status out nocopy VARCHAR2
441: , x_msg_count out nocopy NUMBER

Line 614: , p5_a0 JTF_NUMBER_TABLE

610: , p4_a22 NUMBER
611: , p4_a23 VARCHAR2
612: , p4_a24 VARCHAR2
613: , p4_a25 VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_NUMBER_TABLE
618: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 615: , p5_a1 JTF_NUMBER_TABLE

611: , p4_a23 VARCHAR2
612: , p4_a24 VARCHAR2
613: , p4_a25 VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_NUMBER_TABLE
618: , p5_a4 JTF_VARCHAR2_TABLE_100
619: , p5_a5 JTF_NUMBER_TABLE

Line 617: , p5_a3 JTF_NUMBER_TABLE

613: , p4_a25 VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_NUMBER_TABLE
618: , p5_a4 JTF_VARCHAR2_TABLE_100
619: , p5_a5 JTF_NUMBER_TABLE
620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 619: , p5_a5 JTF_NUMBER_TABLE

615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_NUMBER_TABLE
618: , p5_a4 JTF_VARCHAR2_TABLE_100
619: , p5_a5 JTF_NUMBER_TABLE
620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_VARCHAR2_TABLE_300
622: , p5_a8 JTF_VARCHAR2_TABLE_2000
623: , p5_a9 JTF_VARCHAR2_TABLE_2000

Line 620: , p5_a6 JTF_NUMBER_TABLE

616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_NUMBER_TABLE
618: , p5_a4 JTF_VARCHAR2_TABLE_100
619: , p5_a5 JTF_NUMBER_TABLE
620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_VARCHAR2_TABLE_300
622: , p5_a8 JTF_VARCHAR2_TABLE_2000
623: , p5_a9 JTF_VARCHAR2_TABLE_2000
624: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 639: , p7_a0 JTF_NUMBER_TABLE

635: , p6_a10 NUMBER
636: , p6_a11 NUMBER
637: , p6_a12 NUMBER
638: , p6_a13 NUMBER
639: , p7_a0 JTF_NUMBER_TABLE
640: , p7_a1 JTF_DATE_TABLE
641: , p7_a2 JTF_NUMBER_TABLE
642: , p7_a3 JTF_NUMBER_TABLE
643: , p7_a4 JTF_NUMBER_TABLE

Line 641: , p7_a2 JTF_NUMBER_TABLE

637: , p6_a12 NUMBER
638: , p6_a13 NUMBER
639: , p7_a0 JTF_NUMBER_TABLE
640: , p7_a1 JTF_DATE_TABLE
641: , p7_a2 JTF_NUMBER_TABLE
642: , p7_a3 JTF_NUMBER_TABLE
643: , p7_a4 JTF_NUMBER_TABLE
644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE

Line 642: , p7_a3 JTF_NUMBER_TABLE

638: , p6_a13 NUMBER
639: , p7_a0 JTF_NUMBER_TABLE
640: , p7_a1 JTF_DATE_TABLE
641: , p7_a2 JTF_NUMBER_TABLE
642: , p7_a3 JTF_NUMBER_TABLE
643: , p7_a4 JTF_NUMBER_TABLE
644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE
646: , p7_a7 JTF_NUMBER_TABLE

Line 643: , p7_a4 JTF_NUMBER_TABLE

639: , p7_a0 JTF_NUMBER_TABLE
640: , p7_a1 JTF_DATE_TABLE
641: , p7_a2 JTF_NUMBER_TABLE
642: , p7_a3 JTF_NUMBER_TABLE
643: , p7_a4 JTF_NUMBER_TABLE
644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE
646: , p7_a7 JTF_NUMBER_TABLE
647: , p7_a8 JTF_VARCHAR2_TABLE_100

Line 644: , p7_a5 JTF_NUMBER_TABLE

640: , p7_a1 JTF_DATE_TABLE
641: , p7_a2 JTF_NUMBER_TABLE
642: , p7_a3 JTF_NUMBER_TABLE
643: , p7_a4 JTF_NUMBER_TABLE
644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE
646: , p7_a7 JTF_NUMBER_TABLE
647: , p7_a8 JTF_VARCHAR2_TABLE_100
648: , p7_a9 JTF_VARCHAR2_TABLE_100

Line 645: , p7_a6 JTF_NUMBER_TABLE

641: , p7_a2 JTF_NUMBER_TABLE
642: , p7_a3 JTF_NUMBER_TABLE
643: , p7_a4 JTF_NUMBER_TABLE
644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE
646: , p7_a7 JTF_NUMBER_TABLE
647: , p7_a8 JTF_VARCHAR2_TABLE_100
648: , p7_a9 JTF_VARCHAR2_TABLE_100
649: , p8_a0 VARCHAR2

Line 646: , p7_a7 JTF_NUMBER_TABLE

642: , p7_a3 JTF_NUMBER_TABLE
643: , p7_a4 JTF_NUMBER_TABLE
644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE
646: , p7_a7 JTF_NUMBER_TABLE
647: , p7_a8 JTF_VARCHAR2_TABLE_100
648: , p7_a9 JTF_VARCHAR2_TABLE_100
649: , p8_a0 VARCHAR2
650: , p8_a1 NUMBER

Line 663: , p9_a0 JTF_NUMBER_TABLE

659: , p8_a10 NUMBER
660: , p8_a11 NUMBER
661: , p8_a12 NUMBER
662: , p8_a13 NUMBER
663: , p9_a0 JTF_NUMBER_TABLE
664: , p9_a1 JTF_DATE_TABLE
665: , p9_a2 JTF_NUMBER_TABLE
666: , p9_a3 JTF_NUMBER_TABLE
667: , p9_a4 JTF_NUMBER_TABLE

Line 665: , p9_a2 JTF_NUMBER_TABLE

661: , p8_a12 NUMBER
662: , p8_a13 NUMBER
663: , p9_a0 JTF_NUMBER_TABLE
664: , p9_a1 JTF_DATE_TABLE
665: , p9_a2 JTF_NUMBER_TABLE
666: , p9_a3 JTF_NUMBER_TABLE
667: , p9_a4 JTF_NUMBER_TABLE
668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE

Line 666: , p9_a3 JTF_NUMBER_TABLE

662: , p8_a13 NUMBER
663: , p9_a0 JTF_NUMBER_TABLE
664: , p9_a1 JTF_DATE_TABLE
665: , p9_a2 JTF_NUMBER_TABLE
666: , p9_a3 JTF_NUMBER_TABLE
667: , p9_a4 JTF_NUMBER_TABLE
668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE
670: , p9_a7 JTF_NUMBER_TABLE

Line 667: , p9_a4 JTF_NUMBER_TABLE

663: , p9_a0 JTF_NUMBER_TABLE
664: , p9_a1 JTF_DATE_TABLE
665: , p9_a2 JTF_NUMBER_TABLE
666: , p9_a3 JTF_NUMBER_TABLE
667: , p9_a4 JTF_NUMBER_TABLE
668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE
670: , p9_a7 JTF_NUMBER_TABLE
671: , p9_a8 JTF_VARCHAR2_TABLE_100

Line 668: , p9_a5 JTF_NUMBER_TABLE

664: , p9_a1 JTF_DATE_TABLE
665: , p9_a2 JTF_NUMBER_TABLE
666: , p9_a3 JTF_NUMBER_TABLE
667: , p9_a4 JTF_NUMBER_TABLE
668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE
670: , p9_a7 JTF_NUMBER_TABLE
671: , p9_a8 JTF_VARCHAR2_TABLE_100
672: , p9_a9 JTF_VARCHAR2_TABLE_100

Line 669: , p9_a6 JTF_NUMBER_TABLE

665: , p9_a2 JTF_NUMBER_TABLE
666: , p9_a3 JTF_NUMBER_TABLE
667: , p9_a4 JTF_NUMBER_TABLE
668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE
670: , p9_a7 JTF_NUMBER_TABLE
671: , p9_a8 JTF_VARCHAR2_TABLE_100
672: , p9_a9 JTF_VARCHAR2_TABLE_100
673: , x_service_id out nocopy NUMBER

Line 670: , p9_a7 JTF_NUMBER_TABLE

666: , p9_a3 JTF_NUMBER_TABLE
667: , p9_a4 JTF_NUMBER_TABLE
668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE
670: , p9_a7 JTF_NUMBER_TABLE
671: , p9_a8 JTF_VARCHAR2_TABLE_100
672: , p9_a9 JTF_VARCHAR2_TABLE_100
673: , x_service_id out nocopy NUMBER
674: , x_return_status out nocopy VARCHAR2