DBA Data[Home] [Help]

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 okl_lease_quote_service_pvt_w as
2: /* $Header: OKLEQUSS.pls 120.2 2006/02/13 07:28:25 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 okl_lease_quote_service_pvt_w as
2: /* $Header: OKLEQUSS.pls 120.2 2006/02/13 07:28:25 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: OKLEQUSS.pls 120.2 2006/02/13 07:28:25 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 15: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 16: , a1 out nocopy JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_NUMBER_TABLE

Line 18: , a3 out nocopy JTF_NUMBER_TABLE

14: );
15: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 20: , a5 out nocopy JTF_NUMBER_TABLE

16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_300
23: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
24: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

Line 21: , a6 out nocopy JTF_NUMBER_TABLE

17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_300
23: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
24: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , p4_a0 JTF_NUMBER_TABLE

53: , p3_a22 NUMBER
54: , p3_a23 VARCHAR2
55: , p3_a24 VARCHAR2
56: , p3_a25 VARCHAR2
57: , p4_a0 JTF_NUMBER_TABLE
58: , p4_a1 JTF_NUMBER_TABLE
59: , p4_a2 JTF_VARCHAR2_TABLE_100
60: , p4_a3 JTF_NUMBER_TABLE
61: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 58: , p4_a1 JTF_NUMBER_TABLE

54: , p3_a23 VARCHAR2
55: , p3_a24 VARCHAR2
56: , p3_a25 VARCHAR2
57: , p4_a0 JTF_NUMBER_TABLE
58: , p4_a1 JTF_NUMBER_TABLE
59: , p4_a2 JTF_VARCHAR2_TABLE_100
60: , p4_a3 JTF_NUMBER_TABLE
61: , p4_a4 JTF_VARCHAR2_TABLE_100
62: , p4_a5 JTF_NUMBER_TABLE

Line 60: , p4_a3 JTF_NUMBER_TABLE

56: , p3_a25 VARCHAR2
57: , p4_a0 JTF_NUMBER_TABLE
58: , p4_a1 JTF_NUMBER_TABLE
59: , p4_a2 JTF_VARCHAR2_TABLE_100
60: , p4_a3 JTF_NUMBER_TABLE
61: , p4_a4 JTF_VARCHAR2_TABLE_100
62: , p4_a5 JTF_NUMBER_TABLE
63: , p4_a6 JTF_NUMBER_TABLE
64: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 62: , p4_a5 JTF_NUMBER_TABLE

58: , p4_a1 JTF_NUMBER_TABLE
59: , p4_a2 JTF_VARCHAR2_TABLE_100
60: , p4_a3 JTF_NUMBER_TABLE
61: , p4_a4 JTF_VARCHAR2_TABLE_100
62: , p4_a5 JTF_NUMBER_TABLE
63: , p4_a6 JTF_NUMBER_TABLE
64: , p4_a7 JTF_VARCHAR2_TABLE_300
65: , p4_a8 JTF_VARCHAR2_TABLE_2000
66: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 63: , p4_a6 JTF_NUMBER_TABLE

59: , p4_a2 JTF_VARCHAR2_TABLE_100
60: , p4_a3 JTF_NUMBER_TABLE
61: , p4_a4 JTF_VARCHAR2_TABLE_100
62: , p4_a5 JTF_NUMBER_TABLE
63: , p4_a6 JTF_NUMBER_TABLE
64: , p4_a7 JTF_VARCHAR2_TABLE_300
65: , p4_a8 JTF_VARCHAR2_TABLE_2000
66: , p4_a9 JTF_VARCHAR2_TABLE_2000
67: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 82: , p6_a0 JTF_NUMBER_TABLE

78: , p5_a10 NUMBER
79: , p5_a11 NUMBER
80: , p5_a12 NUMBER
81: , p5_a13 NUMBER
82: , p6_a0 JTF_NUMBER_TABLE
83: , p6_a1 JTF_DATE_TABLE
84: , p6_a2 JTF_NUMBER_TABLE
85: , p6_a3 JTF_NUMBER_TABLE
86: , p6_a4 JTF_NUMBER_TABLE

Line 84: , p6_a2 JTF_NUMBER_TABLE

80: , p5_a12 NUMBER
81: , p5_a13 NUMBER
82: , p6_a0 JTF_NUMBER_TABLE
83: , p6_a1 JTF_DATE_TABLE
84: , p6_a2 JTF_NUMBER_TABLE
85: , p6_a3 JTF_NUMBER_TABLE
86: , p6_a4 JTF_NUMBER_TABLE
87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE

Line 85: , p6_a3 JTF_NUMBER_TABLE

81: , p5_a13 NUMBER
82: , p6_a0 JTF_NUMBER_TABLE
83: , p6_a1 JTF_DATE_TABLE
84: , p6_a2 JTF_NUMBER_TABLE
85: , p6_a3 JTF_NUMBER_TABLE
86: , p6_a4 JTF_NUMBER_TABLE
87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE
89: , p6_a7 JTF_NUMBER_TABLE

Line 86: , p6_a4 JTF_NUMBER_TABLE

82: , p6_a0 JTF_NUMBER_TABLE
83: , p6_a1 JTF_DATE_TABLE
84: , p6_a2 JTF_NUMBER_TABLE
85: , p6_a3 JTF_NUMBER_TABLE
86: , p6_a4 JTF_NUMBER_TABLE
87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE
89: , p6_a7 JTF_NUMBER_TABLE
90: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 87: , p6_a5 JTF_NUMBER_TABLE

83: , p6_a1 JTF_DATE_TABLE
84: , p6_a2 JTF_NUMBER_TABLE
85: , p6_a3 JTF_NUMBER_TABLE
86: , p6_a4 JTF_NUMBER_TABLE
87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE
89: , p6_a7 JTF_NUMBER_TABLE
90: , p6_a8 JTF_VARCHAR2_TABLE_100
91: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 88: , p6_a6 JTF_NUMBER_TABLE

84: , p6_a2 JTF_NUMBER_TABLE
85: , p6_a3 JTF_NUMBER_TABLE
86: , p6_a4 JTF_NUMBER_TABLE
87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE
89: , p6_a7 JTF_NUMBER_TABLE
90: , p6_a8 JTF_VARCHAR2_TABLE_100
91: , p6_a9 JTF_VARCHAR2_TABLE_100
92: , p7_a0 VARCHAR2

Line 89: , p6_a7 JTF_NUMBER_TABLE

85: , p6_a3 JTF_NUMBER_TABLE
86: , p6_a4 JTF_NUMBER_TABLE
87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE
89: , p6_a7 JTF_NUMBER_TABLE
90: , p6_a8 JTF_VARCHAR2_TABLE_100
91: , p6_a9 JTF_VARCHAR2_TABLE_100
92: , p7_a0 VARCHAR2
93: , p7_a1 NUMBER

Line 106: , p8_a0 JTF_NUMBER_TABLE

102: , p7_a10 NUMBER
103: , p7_a11 NUMBER
104: , p7_a12 NUMBER
105: , p7_a13 NUMBER
106: , p8_a0 JTF_NUMBER_TABLE
107: , p8_a1 JTF_DATE_TABLE
108: , p8_a2 JTF_NUMBER_TABLE
109: , p8_a3 JTF_NUMBER_TABLE
110: , p8_a4 JTF_NUMBER_TABLE

Line 108: , p8_a2 JTF_NUMBER_TABLE

104: , p7_a12 NUMBER
105: , p7_a13 NUMBER
106: , p8_a0 JTF_NUMBER_TABLE
107: , p8_a1 JTF_DATE_TABLE
108: , p8_a2 JTF_NUMBER_TABLE
109: , p8_a3 JTF_NUMBER_TABLE
110: , p8_a4 JTF_NUMBER_TABLE
111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE

Line 109: , p8_a3 JTF_NUMBER_TABLE

105: , p7_a13 NUMBER
106: , p8_a0 JTF_NUMBER_TABLE
107: , p8_a1 JTF_DATE_TABLE
108: , p8_a2 JTF_NUMBER_TABLE
109: , p8_a3 JTF_NUMBER_TABLE
110: , p8_a4 JTF_NUMBER_TABLE
111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE
113: , p8_a7 JTF_NUMBER_TABLE

Line 110: , p8_a4 JTF_NUMBER_TABLE

106: , p8_a0 JTF_NUMBER_TABLE
107: , p8_a1 JTF_DATE_TABLE
108: , p8_a2 JTF_NUMBER_TABLE
109: , p8_a3 JTF_NUMBER_TABLE
110: , p8_a4 JTF_NUMBER_TABLE
111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE
113: , p8_a7 JTF_NUMBER_TABLE
114: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 111: , p8_a5 JTF_NUMBER_TABLE

107: , p8_a1 JTF_DATE_TABLE
108: , p8_a2 JTF_NUMBER_TABLE
109: , p8_a3 JTF_NUMBER_TABLE
110: , p8_a4 JTF_NUMBER_TABLE
111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE
113: , p8_a7 JTF_NUMBER_TABLE
114: , p8_a8 JTF_VARCHAR2_TABLE_100
115: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 112: , p8_a6 JTF_NUMBER_TABLE

108: , p8_a2 JTF_NUMBER_TABLE
109: , p8_a3 JTF_NUMBER_TABLE
110: , p8_a4 JTF_NUMBER_TABLE
111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE
113: , p8_a7 JTF_NUMBER_TABLE
114: , p8_a8 JTF_VARCHAR2_TABLE_100
115: , p8_a9 JTF_VARCHAR2_TABLE_100
116: , x_service_id out nocopy NUMBER

Line 113: , p8_a7 JTF_NUMBER_TABLE

109: , p8_a3 JTF_NUMBER_TABLE
110: , p8_a4 JTF_NUMBER_TABLE
111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE
113: , p8_a7 JTF_NUMBER_TABLE
114: , p8_a8 JTF_VARCHAR2_TABLE_100
115: , p8_a9 JTF_VARCHAR2_TABLE_100
116: , x_service_id out nocopy NUMBER
117: , x_return_status out nocopy VARCHAR2

Line 150: , p4_a0 JTF_NUMBER_TABLE

146: , p3_a22 NUMBER
147: , p3_a23 VARCHAR2
148: , p3_a24 VARCHAR2
149: , p3_a25 VARCHAR2
150: , p4_a0 JTF_NUMBER_TABLE
151: , p4_a1 JTF_NUMBER_TABLE
152: , p4_a2 JTF_VARCHAR2_TABLE_100
153: , p4_a3 JTF_NUMBER_TABLE
154: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 151: , p4_a1 JTF_NUMBER_TABLE

147: , p3_a23 VARCHAR2
148: , p3_a24 VARCHAR2
149: , p3_a25 VARCHAR2
150: , p4_a0 JTF_NUMBER_TABLE
151: , p4_a1 JTF_NUMBER_TABLE
152: , p4_a2 JTF_VARCHAR2_TABLE_100
153: , p4_a3 JTF_NUMBER_TABLE
154: , p4_a4 JTF_VARCHAR2_TABLE_100
155: , p4_a5 JTF_NUMBER_TABLE

Line 153: , p4_a3 JTF_NUMBER_TABLE

149: , p3_a25 VARCHAR2
150: , p4_a0 JTF_NUMBER_TABLE
151: , p4_a1 JTF_NUMBER_TABLE
152: , p4_a2 JTF_VARCHAR2_TABLE_100
153: , p4_a3 JTF_NUMBER_TABLE
154: , p4_a4 JTF_VARCHAR2_TABLE_100
155: , p4_a5 JTF_NUMBER_TABLE
156: , p4_a6 JTF_NUMBER_TABLE
157: , p4_a7 JTF_VARCHAR2_TABLE_300

Line 155: , p4_a5 JTF_NUMBER_TABLE

151: , p4_a1 JTF_NUMBER_TABLE
152: , p4_a2 JTF_VARCHAR2_TABLE_100
153: , p4_a3 JTF_NUMBER_TABLE
154: , p4_a4 JTF_VARCHAR2_TABLE_100
155: , p4_a5 JTF_NUMBER_TABLE
156: , p4_a6 JTF_NUMBER_TABLE
157: , p4_a7 JTF_VARCHAR2_TABLE_300
158: , p4_a8 JTF_VARCHAR2_TABLE_2000
159: , p4_a9 JTF_VARCHAR2_TABLE_2000

Line 156: , p4_a6 JTF_NUMBER_TABLE

152: , p4_a2 JTF_VARCHAR2_TABLE_100
153: , p4_a3 JTF_NUMBER_TABLE
154: , p4_a4 JTF_VARCHAR2_TABLE_100
155: , p4_a5 JTF_NUMBER_TABLE
156: , p4_a6 JTF_NUMBER_TABLE
157: , p4_a7 JTF_VARCHAR2_TABLE_300
158: , p4_a8 JTF_VARCHAR2_TABLE_2000
159: , p4_a9 JTF_VARCHAR2_TABLE_2000
160: , p4_a10 JTF_VARCHAR2_TABLE_100

Line 175: , p6_a0 JTF_NUMBER_TABLE

171: , p5_a10 NUMBER
172: , p5_a11 NUMBER
173: , p5_a12 NUMBER
174: , p5_a13 NUMBER
175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_DATE_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_NUMBER_TABLE

Line 177: , p6_a2 JTF_NUMBER_TABLE

173: , p5_a12 NUMBER
174: , p5_a13 NUMBER
175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_DATE_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_NUMBER_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE

Line 178: , p6_a3 JTF_NUMBER_TABLE

174: , p5_a13 NUMBER
175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_DATE_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_NUMBER_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE
182: , p6_a7 JTF_NUMBER_TABLE

Line 179: , p6_a4 JTF_NUMBER_TABLE

175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_DATE_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_NUMBER_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 180: , p6_a5 JTF_NUMBER_TABLE

176: , p6_a1 JTF_DATE_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_NUMBER_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_VARCHAR2_TABLE_100
184: , p6_a9 JTF_VARCHAR2_TABLE_100

Line 181: , p6_a6 JTF_NUMBER_TABLE

177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_NUMBER_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_VARCHAR2_TABLE_100
184: , p6_a9 JTF_VARCHAR2_TABLE_100
185: , p7_a0 VARCHAR2

Line 182: , p6_a7 JTF_NUMBER_TABLE

178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_NUMBER_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_VARCHAR2_TABLE_100
184: , p6_a9 JTF_VARCHAR2_TABLE_100
185: , p7_a0 VARCHAR2
186: , p7_a1 NUMBER

Line 199: , p8_a0 JTF_NUMBER_TABLE

195: , p7_a10 NUMBER
196: , p7_a11 NUMBER
197: , p7_a12 NUMBER
198: , p7_a13 NUMBER
199: , p8_a0 JTF_NUMBER_TABLE
200: , p8_a1 JTF_DATE_TABLE
201: , p8_a2 JTF_NUMBER_TABLE
202: , p8_a3 JTF_NUMBER_TABLE
203: , p8_a4 JTF_NUMBER_TABLE

Line 201: , p8_a2 JTF_NUMBER_TABLE

197: , p7_a12 NUMBER
198: , p7_a13 NUMBER
199: , p8_a0 JTF_NUMBER_TABLE
200: , p8_a1 JTF_DATE_TABLE
201: , p8_a2 JTF_NUMBER_TABLE
202: , p8_a3 JTF_NUMBER_TABLE
203: , p8_a4 JTF_NUMBER_TABLE
204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE

Line 202: , p8_a3 JTF_NUMBER_TABLE

198: , p7_a13 NUMBER
199: , p8_a0 JTF_NUMBER_TABLE
200: , p8_a1 JTF_DATE_TABLE
201: , p8_a2 JTF_NUMBER_TABLE
202: , p8_a3 JTF_NUMBER_TABLE
203: , p8_a4 JTF_NUMBER_TABLE
204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE
206: , p8_a7 JTF_NUMBER_TABLE

Line 203: , p8_a4 JTF_NUMBER_TABLE

199: , p8_a0 JTF_NUMBER_TABLE
200: , p8_a1 JTF_DATE_TABLE
201: , p8_a2 JTF_NUMBER_TABLE
202: , p8_a3 JTF_NUMBER_TABLE
203: , p8_a4 JTF_NUMBER_TABLE
204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE
206: , p8_a7 JTF_NUMBER_TABLE
207: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 204: , p8_a5 JTF_NUMBER_TABLE

200: , p8_a1 JTF_DATE_TABLE
201: , p8_a2 JTF_NUMBER_TABLE
202: , p8_a3 JTF_NUMBER_TABLE
203: , p8_a4 JTF_NUMBER_TABLE
204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE
206: , p8_a7 JTF_NUMBER_TABLE
207: , p8_a8 JTF_VARCHAR2_TABLE_100
208: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 205: , p8_a6 JTF_NUMBER_TABLE

201: , p8_a2 JTF_NUMBER_TABLE
202: , p8_a3 JTF_NUMBER_TABLE
203: , p8_a4 JTF_NUMBER_TABLE
204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE
206: , p8_a7 JTF_NUMBER_TABLE
207: , p8_a8 JTF_VARCHAR2_TABLE_100
208: , p8_a9 JTF_VARCHAR2_TABLE_100
209: , x_return_status out nocopy VARCHAR2

Line 206: , p8_a7 JTF_NUMBER_TABLE

202: , p8_a3 JTF_NUMBER_TABLE
203: , p8_a4 JTF_NUMBER_TABLE
204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE
206: , p8_a7 JTF_NUMBER_TABLE
207: , p8_a8 JTF_VARCHAR2_TABLE_100
208: , p8_a9 JTF_VARCHAR2_TABLE_100
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER

Line 243: , p5_a0 JTF_NUMBER_TABLE

239: , p4_a22 NUMBER
240: , p4_a23 VARCHAR2
241: , p4_a24 VARCHAR2
242: , p4_a25 VARCHAR2
243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 244: , p5_a1 JTF_NUMBER_TABLE

240: , p4_a23 VARCHAR2
241: , p4_a24 VARCHAR2
242: , p4_a25 VARCHAR2
243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_NUMBER_TABLE

Line 246: , p5_a3 JTF_NUMBER_TABLE

242: , p4_a25 VARCHAR2
243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_NUMBER_TABLE
249: , p5_a6 JTF_NUMBER_TABLE
250: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 248: , p5_a5 JTF_NUMBER_TABLE

244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_NUMBER_TABLE
249: , p5_a6 JTF_NUMBER_TABLE
250: , p5_a7 JTF_VARCHAR2_TABLE_300
251: , p5_a8 JTF_VARCHAR2_TABLE_2000
252: , p5_a9 JTF_VARCHAR2_TABLE_2000

Line 249: , p5_a6 JTF_NUMBER_TABLE

245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_NUMBER_TABLE
249: , p5_a6 JTF_NUMBER_TABLE
250: , p5_a7 JTF_VARCHAR2_TABLE_300
251: , p5_a8 JTF_VARCHAR2_TABLE_2000
252: , p5_a9 JTF_VARCHAR2_TABLE_2000
253: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 268: , p7_a0 JTF_NUMBER_TABLE

264: , p6_a10 NUMBER
265: , p6_a11 NUMBER
266: , p6_a12 NUMBER
267: , p6_a13 NUMBER
268: , p7_a0 JTF_NUMBER_TABLE
269: , p7_a1 JTF_DATE_TABLE
270: , p7_a2 JTF_NUMBER_TABLE
271: , p7_a3 JTF_NUMBER_TABLE
272: , p7_a4 JTF_NUMBER_TABLE

Line 270: , p7_a2 JTF_NUMBER_TABLE

266: , p6_a12 NUMBER
267: , p6_a13 NUMBER
268: , p7_a0 JTF_NUMBER_TABLE
269: , p7_a1 JTF_DATE_TABLE
270: , p7_a2 JTF_NUMBER_TABLE
271: , p7_a3 JTF_NUMBER_TABLE
272: , p7_a4 JTF_NUMBER_TABLE
273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE

Line 271: , p7_a3 JTF_NUMBER_TABLE

267: , p6_a13 NUMBER
268: , p7_a0 JTF_NUMBER_TABLE
269: , p7_a1 JTF_DATE_TABLE
270: , p7_a2 JTF_NUMBER_TABLE
271: , p7_a3 JTF_NUMBER_TABLE
272: , p7_a4 JTF_NUMBER_TABLE
273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE
275: , p7_a7 JTF_NUMBER_TABLE

Line 272: , p7_a4 JTF_NUMBER_TABLE

268: , p7_a0 JTF_NUMBER_TABLE
269: , p7_a1 JTF_DATE_TABLE
270: , p7_a2 JTF_NUMBER_TABLE
271: , p7_a3 JTF_NUMBER_TABLE
272: , p7_a4 JTF_NUMBER_TABLE
273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE
275: , p7_a7 JTF_NUMBER_TABLE
276: , p7_a8 JTF_VARCHAR2_TABLE_100

Line 273: , p7_a5 JTF_NUMBER_TABLE

269: , p7_a1 JTF_DATE_TABLE
270: , p7_a2 JTF_NUMBER_TABLE
271: , p7_a3 JTF_NUMBER_TABLE
272: , p7_a4 JTF_NUMBER_TABLE
273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE
275: , p7_a7 JTF_NUMBER_TABLE
276: , p7_a8 JTF_VARCHAR2_TABLE_100
277: , p7_a9 JTF_VARCHAR2_TABLE_100

Line 274: , p7_a6 JTF_NUMBER_TABLE

270: , p7_a2 JTF_NUMBER_TABLE
271: , p7_a3 JTF_NUMBER_TABLE
272: , p7_a4 JTF_NUMBER_TABLE
273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE
275: , p7_a7 JTF_NUMBER_TABLE
276: , p7_a8 JTF_VARCHAR2_TABLE_100
277: , p7_a9 JTF_VARCHAR2_TABLE_100
278: , p8_a0 VARCHAR2

Line 275: , p7_a7 JTF_NUMBER_TABLE

271: , p7_a3 JTF_NUMBER_TABLE
272: , p7_a4 JTF_NUMBER_TABLE
273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE
275: , p7_a7 JTF_NUMBER_TABLE
276: , p7_a8 JTF_VARCHAR2_TABLE_100
277: , p7_a9 JTF_VARCHAR2_TABLE_100
278: , p8_a0 VARCHAR2
279: , p8_a1 NUMBER

Line 292: , p9_a0 JTF_NUMBER_TABLE

288: , p8_a10 NUMBER
289: , p8_a11 NUMBER
290: , p8_a12 NUMBER
291: , p8_a13 NUMBER
292: , p9_a0 JTF_NUMBER_TABLE
293: , p9_a1 JTF_DATE_TABLE
294: , p9_a2 JTF_NUMBER_TABLE
295: , p9_a3 JTF_NUMBER_TABLE
296: , p9_a4 JTF_NUMBER_TABLE

Line 294: , p9_a2 JTF_NUMBER_TABLE

290: , p8_a12 NUMBER
291: , p8_a13 NUMBER
292: , p9_a0 JTF_NUMBER_TABLE
293: , p9_a1 JTF_DATE_TABLE
294: , p9_a2 JTF_NUMBER_TABLE
295: , p9_a3 JTF_NUMBER_TABLE
296: , p9_a4 JTF_NUMBER_TABLE
297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE

Line 295: , p9_a3 JTF_NUMBER_TABLE

291: , p8_a13 NUMBER
292: , p9_a0 JTF_NUMBER_TABLE
293: , p9_a1 JTF_DATE_TABLE
294: , p9_a2 JTF_NUMBER_TABLE
295: , p9_a3 JTF_NUMBER_TABLE
296: , p9_a4 JTF_NUMBER_TABLE
297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE
299: , p9_a7 JTF_NUMBER_TABLE

Line 296: , p9_a4 JTF_NUMBER_TABLE

292: , p9_a0 JTF_NUMBER_TABLE
293: , p9_a1 JTF_DATE_TABLE
294: , p9_a2 JTF_NUMBER_TABLE
295: , p9_a3 JTF_NUMBER_TABLE
296: , p9_a4 JTF_NUMBER_TABLE
297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE
299: , p9_a7 JTF_NUMBER_TABLE
300: , p9_a8 JTF_VARCHAR2_TABLE_100

Line 297: , p9_a5 JTF_NUMBER_TABLE

293: , p9_a1 JTF_DATE_TABLE
294: , p9_a2 JTF_NUMBER_TABLE
295: , p9_a3 JTF_NUMBER_TABLE
296: , p9_a4 JTF_NUMBER_TABLE
297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE
299: , p9_a7 JTF_NUMBER_TABLE
300: , p9_a8 JTF_VARCHAR2_TABLE_100
301: , p9_a9 JTF_VARCHAR2_TABLE_100

Line 298: , p9_a6 JTF_NUMBER_TABLE

294: , p9_a2 JTF_NUMBER_TABLE
295: , p9_a3 JTF_NUMBER_TABLE
296: , p9_a4 JTF_NUMBER_TABLE
297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE
299: , p9_a7 JTF_NUMBER_TABLE
300: , p9_a8 JTF_VARCHAR2_TABLE_100
301: , p9_a9 JTF_VARCHAR2_TABLE_100
302: , x_service_id out nocopy NUMBER

Line 299: , p9_a7 JTF_NUMBER_TABLE

295: , p9_a3 JTF_NUMBER_TABLE
296: , p9_a4 JTF_NUMBER_TABLE
297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE
299: , p9_a7 JTF_NUMBER_TABLE
300: , p9_a8 JTF_VARCHAR2_TABLE_100
301: , p9_a9 JTF_VARCHAR2_TABLE_100
302: , x_service_id out nocopy NUMBER
303: , x_return_status out nocopy VARCHAR2