APPS.OKL_SRV_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE

1: package okl_srv_pvt_w as
2: /* $Header: OKLISRVS.pls 120.0 2005/07/07 10:41:04 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_srv_pvt_w as
2: /* $Header: OKLISRVS.pls 120.0 2005/07/07 10:41:04 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLISRVS.pls 120.0 2005/07/07 10:41:04 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE

Line 34: , a31 JTF_NUMBER_TABLE

30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 36: , a33 JTF_NUMBER_TABLE

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE

34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE

Line 39: , a1 out nocopy JTF_NUMBER_TABLE

35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE

Line 41: , a3 out nocopy JTF_NUMBER_TABLE

37: );
38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE

Line 45: , a7 out nocopy JTF_NUMBER_TABLE

41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE

Line 46: , a8 out nocopy JTF_NUMBER_TABLE

42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE

Line 47: , a9 out nocopy JTF_NUMBER_TABLE

43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a11 out nocopy JTF_NUMBER_TABLE

45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 50: , a12 out nocopy JTF_NUMBER_TABLE

46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500
54: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 67: , a29 out nocopy JTF_NUMBER_TABLE

63: , a25 out nocopy JTF_VARCHAR2_TABLE_500
64: , a26 out nocopy JTF_VARCHAR2_TABLE_500
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE

Line 69: , a31 out nocopy JTF_NUMBER_TABLE

65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:

Line 71: , a33 out nocopy JTF_NUMBER_TABLE

67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure insert_row(p_api_version NUMBER
75: , p_init_msg_list VARCHAR2

Line 153: , p5_a0 JTF_NUMBER_TABLE

149: , p_init_msg_list VARCHAR2
150: , x_return_status out nocopy VARCHAR2
151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE

Line 154: , p5_a1 JTF_NUMBER_TABLE

150: , x_return_status out nocopy VARCHAR2
151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE

Line 156: , p5_a3 JTF_NUMBER_TABLE

152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE

Line 160: , p5_a7 JTF_NUMBER_TABLE

156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE

Line 161: , p5_a8 JTF_NUMBER_TABLE

157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE

Line 162: , p5_a9 JTF_NUMBER_TABLE

158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE
166: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 164: , p5_a11 JTF_NUMBER_TABLE

160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE
166: , p5_a13 JTF_VARCHAR2_TABLE_100
167: , p5_a14 JTF_VARCHAR2_TABLE_500
168: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 165: , p5_a12 JTF_NUMBER_TABLE

161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE
166: , p5_a13 JTF_VARCHAR2_TABLE_100
167: , p5_a14 JTF_VARCHAR2_TABLE_500
168: , p5_a15 JTF_VARCHAR2_TABLE_500
169: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 182: , p5_a29 JTF_NUMBER_TABLE

178: , p5_a25 JTF_VARCHAR2_TABLE_500
179: , p5_a26 JTF_VARCHAR2_TABLE_500
180: , p5_a27 JTF_VARCHAR2_TABLE_500
181: , p5_a28 JTF_VARCHAR2_TABLE_500
182: , p5_a29 JTF_NUMBER_TABLE
183: , p5_a30 JTF_DATE_TABLE
184: , p5_a31 JTF_NUMBER_TABLE
185: , p5_a32 JTF_DATE_TABLE
186: , p5_a33 JTF_NUMBER_TABLE

Line 184: , p5_a31 JTF_NUMBER_TABLE

180: , p5_a27 JTF_VARCHAR2_TABLE_500
181: , p5_a28 JTF_VARCHAR2_TABLE_500
182: , p5_a29 JTF_NUMBER_TABLE
183: , p5_a30 JTF_DATE_TABLE
184: , p5_a31 JTF_NUMBER_TABLE
185: , p5_a32 JTF_DATE_TABLE
186: , p5_a33 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 186: , p5_a33 JTF_NUMBER_TABLE

182: , p5_a29 JTF_NUMBER_TABLE
183: , p5_a30 JTF_DATE_TABLE
184: , p5_a31 JTF_NUMBER_TABLE
185: , p5_a32 JTF_DATE_TABLE
186: , p5_a33 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 187: , p6_a0 out nocopy JTF_NUMBER_TABLE

183: , p5_a30 JTF_DATE_TABLE
184: , p5_a31 JTF_NUMBER_TABLE
185: , p5_a32 JTF_DATE_TABLE
186: , p5_a33 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE

Line 188: , p6_a1 out nocopy JTF_NUMBER_TABLE

184: , p5_a31 JTF_NUMBER_TABLE
185: , p5_a32 JTF_DATE_TABLE
186: , p5_a33 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE

Line 190: , p6_a3 out nocopy JTF_NUMBER_TABLE

186: , p5_a33 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 194: , p6_a7 out nocopy JTF_NUMBER_TABLE

190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 195: , p6_a8 out nocopy JTF_NUMBER_TABLE

191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 196: , p6_a9 out nocopy JTF_NUMBER_TABLE

192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE
200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 198: , p6_a11 out nocopy JTF_NUMBER_TABLE

194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE
200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
202: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 199: , p6_a12 out nocopy JTF_NUMBER_TABLE

195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE
200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
202: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
203: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 216: , p6_a29 out nocopy JTF_NUMBER_TABLE

212: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
213: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
214: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
215: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
216: , p6_a29 out nocopy JTF_NUMBER_TABLE
217: , p6_a30 out nocopy JTF_DATE_TABLE
218: , p6_a31 out nocopy JTF_NUMBER_TABLE
219: , p6_a32 out nocopy JTF_DATE_TABLE
220: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 218: , p6_a31 out nocopy JTF_NUMBER_TABLE

214: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
215: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
216: , p6_a29 out nocopy JTF_NUMBER_TABLE
217: , p6_a30 out nocopy JTF_DATE_TABLE
218: , p6_a31 out nocopy JTF_NUMBER_TABLE
219: , p6_a32 out nocopy JTF_DATE_TABLE
220: , p6_a33 out nocopy JTF_NUMBER_TABLE
221: );
222: procedure update_row(p_api_version NUMBER

Line 220: , p6_a33 out nocopy JTF_NUMBER_TABLE

216: , p6_a29 out nocopy JTF_NUMBER_TABLE
217: , p6_a30 out nocopy JTF_DATE_TABLE
218: , p6_a31 out nocopy JTF_NUMBER_TABLE
219: , p6_a32 out nocopy JTF_DATE_TABLE
220: , p6_a33 out nocopy JTF_NUMBER_TABLE
221: );
222: procedure update_row(p_api_version NUMBER
223: , p_init_msg_list VARCHAR2
224: , x_return_status out nocopy VARCHAR2

Line 301: , p5_a0 JTF_NUMBER_TABLE

297: , p_init_msg_list VARCHAR2
298: , x_return_status out nocopy VARCHAR2
299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p5_a0 JTF_NUMBER_TABLE
302: , p5_a1 JTF_NUMBER_TABLE
303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE

Line 302: , p5_a1 JTF_NUMBER_TABLE

298: , x_return_status out nocopy VARCHAR2
299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p5_a0 JTF_NUMBER_TABLE
302: , p5_a1 JTF_NUMBER_TABLE
303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE

Line 304: , p5_a3 JTF_NUMBER_TABLE

300: , x_msg_data out nocopy VARCHAR2
301: , p5_a0 JTF_NUMBER_TABLE
302: , p5_a1 JTF_NUMBER_TABLE
303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE

Line 308: , p5_a7 JTF_NUMBER_TABLE

304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE

Line 309: , p5_a8 JTF_NUMBER_TABLE

305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE

Line 310: , p5_a9 JTF_NUMBER_TABLE

306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE
314: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 312: , p5_a11 JTF_NUMBER_TABLE

308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE
314: , p5_a13 JTF_VARCHAR2_TABLE_100
315: , p5_a14 JTF_VARCHAR2_TABLE_500
316: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 313: , p5_a12 JTF_NUMBER_TABLE

309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE
314: , p5_a13 JTF_VARCHAR2_TABLE_100
315: , p5_a14 JTF_VARCHAR2_TABLE_500
316: , p5_a15 JTF_VARCHAR2_TABLE_500
317: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 330: , p5_a29 JTF_NUMBER_TABLE

326: , p5_a25 JTF_VARCHAR2_TABLE_500
327: , p5_a26 JTF_VARCHAR2_TABLE_500
328: , p5_a27 JTF_VARCHAR2_TABLE_500
329: , p5_a28 JTF_VARCHAR2_TABLE_500
330: , p5_a29 JTF_NUMBER_TABLE
331: , p5_a30 JTF_DATE_TABLE
332: , p5_a31 JTF_NUMBER_TABLE
333: , p5_a32 JTF_DATE_TABLE
334: , p5_a33 JTF_NUMBER_TABLE

Line 332: , p5_a31 JTF_NUMBER_TABLE

328: , p5_a27 JTF_VARCHAR2_TABLE_500
329: , p5_a28 JTF_VARCHAR2_TABLE_500
330: , p5_a29 JTF_NUMBER_TABLE
331: , p5_a30 JTF_DATE_TABLE
332: , p5_a31 JTF_NUMBER_TABLE
333: , p5_a32 JTF_DATE_TABLE
334: , p5_a33 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 334: , p5_a33 JTF_NUMBER_TABLE

330: , p5_a29 JTF_NUMBER_TABLE
331: , p5_a30 JTF_DATE_TABLE
332: , p5_a31 JTF_NUMBER_TABLE
333: , p5_a32 JTF_DATE_TABLE
334: , p5_a33 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 335: , p6_a0 out nocopy JTF_NUMBER_TABLE

331: , p5_a30 JTF_DATE_TABLE
332: , p5_a31 JTF_NUMBER_TABLE
333: , p5_a32 JTF_DATE_TABLE
334: , p5_a33 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE

Line 336: , p6_a1 out nocopy JTF_NUMBER_TABLE

332: , p5_a31 JTF_NUMBER_TABLE
333: , p5_a32 JTF_DATE_TABLE
334: , p5_a33 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE

Line 338: , p6_a3 out nocopy JTF_NUMBER_TABLE

334: , p5_a33 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 342: , p6_a7 out nocopy JTF_NUMBER_TABLE

338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 343: , p6_a8 out nocopy JTF_NUMBER_TABLE

339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 344: , p6_a9 out nocopy JTF_NUMBER_TABLE

340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE
348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 346: , p6_a11 out nocopy JTF_NUMBER_TABLE

342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE
348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 347: , p6_a12 out nocopy JTF_NUMBER_TABLE

343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE
348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
351: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 364: , p6_a29 out nocopy JTF_NUMBER_TABLE

360: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
361: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
362: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
363: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
364: , p6_a29 out nocopy JTF_NUMBER_TABLE
365: , p6_a30 out nocopy JTF_DATE_TABLE
366: , p6_a31 out nocopy JTF_NUMBER_TABLE
367: , p6_a32 out nocopy JTF_DATE_TABLE
368: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 366: , p6_a31 out nocopy JTF_NUMBER_TABLE

362: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
363: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
364: , p6_a29 out nocopy JTF_NUMBER_TABLE
365: , p6_a30 out nocopy JTF_DATE_TABLE
366: , p6_a31 out nocopy JTF_NUMBER_TABLE
367: , p6_a32 out nocopy JTF_DATE_TABLE
368: , p6_a33 out nocopy JTF_NUMBER_TABLE
369: );
370: procedure delete_row(p_api_version NUMBER

Line 368: , p6_a33 out nocopy JTF_NUMBER_TABLE

364: , p6_a29 out nocopy JTF_NUMBER_TABLE
365: , p6_a30 out nocopy JTF_DATE_TABLE
366: , p6_a31 out nocopy JTF_NUMBER_TABLE
367: , p6_a32 out nocopy JTF_DATE_TABLE
368: , p6_a33 out nocopy JTF_NUMBER_TABLE
369: );
370: procedure delete_row(p_api_version NUMBER
371: , p_init_msg_list VARCHAR2
372: , x_return_status out nocopy VARCHAR2

Line 415: , p5_a0 JTF_NUMBER_TABLE

411: , p_init_msg_list VARCHAR2
412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_VARCHAR2_TABLE_100
418: , p5_a3 JTF_NUMBER_TABLE
419: , p5_a4 JTF_DATE_TABLE

Line 416: , p5_a1 JTF_NUMBER_TABLE

412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_VARCHAR2_TABLE_100
418: , p5_a3 JTF_NUMBER_TABLE
419: , p5_a4 JTF_DATE_TABLE
420: , p5_a5 JTF_DATE_TABLE

Line 418: , p5_a3 JTF_NUMBER_TABLE

414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_VARCHAR2_TABLE_100
418: , p5_a3 JTF_NUMBER_TABLE
419: , p5_a4 JTF_DATE_TABLE
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE

Line 422: , p5_a7 JTF_NUMBER_TABLE

418: , p5_a3 JTF_NUMBER_TABLE
419: , p5_a4 JTF_DATE_TABLE
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE

Line 423: , p5_a8 JTF_NUMBER_TABLE

419: , p5_a4 JTF_DATE_TABLE
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE

Line 424: , p5_a9 JTF_NUMBER_TABLE

420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE
428: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 426: , p5_a11 JTF_NUMBER_TABLE

422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE
428: , p5_a13 JTF_VARCHAR2_TABLE_100
429: , p5_a14 JTF_VARCHAR2_TABLE_500
430: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 427: , p5_a12 JTF_NUMBER_TABLE

423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE
428: , p5_a13 JTF_VARCHAR2_TABLE_100
429: , p5_a14 JTF_VARCHAR2_TABLE_500
430: , p5_a15 JTF_VARCHAR2_TABLE_500
431: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 444: , p5_a29 JTF_NUMBER_TABLE

440: , p5_a25 JTF_VARCHAR2_TABLE_500
441: , p5_a26 JTF_VARCHAR2_TABLE_500
442: , p5_a27 JTF_VARCHAR2_TABLE_500
443: , p5_a28 JTF_VARCHAR2_TABLE_500
444: , p5_a29 JTF_NUMBER_TABLE
445: , p5_a30 JTF_DATE_TABLE
446: , p5_a31 JTF_NUMBER_TABLE
447: , p5_a32 JTF_DATE_TABLE
448: , p5_a33 JTF_NUMBER_TABLE

Line 446: , p5_a31 JTF_NUMBER_TABLE

442: , p5_a27 JTF_VARCHAR2_TABLE_500
443: , p5_a28 JTF_VARCHAR2_TABLE_500
444: , p5_a29 JTF_NUMBER_TABLE
445: , p5_a30 JTF_DATE_TABLE
446: , p5_a31 JTF_NUMBER_TABLE
447: , p5_a32 JTF_DATE_TABLE
448: , p5_a33 JTF_NUMBER_TABLE
449: );
450: end okl_srv_pvt_w;

Line 448: , p5_a33 JTF_NUMBER_TABLE

444: , p5_a29 JTF_NUMBER_TABLE
445: , p5_a30 JTF_DATE_TABLE
446: , p5_a31 JTF_NUMBER_TABLE
447: , p5_a32 JTF_DATE_TABLE
448: , p5_a33 JTF_NUMBER_TABLE
449: );
450: end okl_srv_pvt_w;