1: package okl_idx_pvt_w as
2: /* $Header: OKLIIDXS.pls 120.1 2005/07/13 09:26:56 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idx_pvt.idx_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idx_pvt.idx_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_idx_pvt.idx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_idx_pvt.idx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_idx_pvt.idx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_NUMBER_TABLE
35: procedure rosetta_table_copy_out_p2(t okl_idx_pvt.idx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_NUMBER_TABLE
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE
43: , a8 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_NUMBER_TABLE
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_DATE_TABLE
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_NUMBER_TABLE
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_DATE_TABLE
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a11 out nocopy JTF_VARCHAR2_TABLE_500
39: , a4 out nocopy JTF_NUMBER_TABLE
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_DATE_TABLE
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a11 out nocopy JTF_VARCHAR2_TABLE_500
47: , a12 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_VARCHAR2_TABLE_500
58: , a23 out nocopy JTF_VARCHAR2_TABLE_500
59: , a24 out nocopy JTF_VARCHAR2_TABLE_500
60: , a25 out nocopy JTF_VARCHAR2_TABLE_500
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_VARCHAR2_TABLE_500
60: , a25 out nocopy JTF_VARCHAR2_TABLE_500
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_idx_pvt.idxv_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_idx_pvt.idxv_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_VARCHAR2_TABLE_200
71: , a3 JTF_VARCHAR2_TABLE_2000
72: , a4 JTF_VARCHAR2_TABLE_100
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_idx_pvt.idxv_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_VARCHAR2_TABLE_200
71: , a3 JTF_VARCHAR2_TABLE_2000
72: , a4 JTF_VARCHAR2_TABLE_100
73: , a5 JTF_VARCHAR2_TABLE_500
86: , a18 JTF_VARCHAR2_TABLE_500
87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_100
89: , a21 JTF_VARCHAR2_TABLE_100
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_100
89: , a21 JTF_VARCHAR2_TABLE_100
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
88: , a20 JTF_VARCHAR2_TABLE_100
89: , a21 JTF_VARCHAR2_TABLE_100
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_idx_pvt.idxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_idx_pvt.idxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_VARCHAR2_TABLE_200
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_idx_pvt.idxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_VARCHAR2_TABLE_200
103: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_idx_pvt.idxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_VARCHAR2_TABLE_200
103: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100
105: , a5 out nocopy JTF_VARCHAR2_TABLE_500
118: , a18 out nocopy JTF_VARCHAR2_TABLE_500
119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_100
121: , a21 out nocopy JTF_VARCHAR2_TABLE_100
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_100
121: , a21 out nocopy JTF_VARCHAR2_TABLE_100
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
120: , a20 out nocopy JTF_VARCHAR2_TABLE_100
121: , a21 out nocopy JTF_VARCHAR2_TABLE_100
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
133: procedure insert_row(p_api_version NUMBER
134: , p_init_msg_list VARCHAR2
202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_VARCHAR2_TABLE_200
209: , p5_a3 JTF_VARCHAR2_TABLE_2000
210: , p5_a4 JTF_VARCHAR2_TABLE_100
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_VARCHAR2_TABLE_200
209: , p5_a3 JTF_VARCHAR2_TABLE_2000
210: , p5_a4 JTF_VARCHAR2_TABLE_100
211: , p5_a5 JTF_VARCHAR2_TABLE_500
224: , p5_a18 JTF_VARCHAR2_TABLE_500
225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_100
227: , p5_a21 JTF_VARCHAR2_TABLE_100
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_100
227: , p5_a21 JTF_VARCHAR2_TABLE_100
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
226: , p5_a20 JTF_VARCHAR2_TABLE_100
227: , p5_a21 JTF_VARCHAR2_TABLE_100
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
255: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: );
269: procedure lock_row(p_api_version NUMBER
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: );
269: procedure lock_row(p_api_version NUMBER
270: , p_init_msg_list VARCHAR2
271: , x_return_status out nocopy VARCHAR2
307: , p_init_msg_list VARCHAR2
308: , x_return_status out nocopy VARCHAR2
309: , x_msg_count out nocopy NUMBER
310: , x_msg_data out nocopy VARCHAR2
311: , p5_a0 JTF_NUMBER_TABLE
312: , p5_a1 JTF_NUMBER_TABLE
313: , p5_a2 JTF_VARCHAR2_TABLE_200
314: , p5_a3 JTF_VARCHAR2_TABLE_2000
315: , p5_a4 JTF_VARCHAR2_TABLE_100
308: , x_return_status out nocopy VARCHAR2
309: , x_msg_count out nocopy NUMBER
310: , x_msg_data out nocopy VARCHAR2
311: , p5_a0 JTF_NUMBER_TABLE
312: , p5_a1 JTF_NUMBER_TABLE
313: , p5_a2 JTF_VARCHAR2_TABLE_200
314: , p5_a3 JTF_VARCHAR2_TABLE_2000
315: , p5_a4 JTF_VARCHAR2_TABLE_100
316: , p5_a5 JTF_VARCHAR2_TABLE_500
329: , p5_a18 JTF_VARCHAR2_TABLE_500
330: , p5_a19 JTF_VARCHAR2_TABLE_500
331: , p5_a20 JTF_VARCHAR2_TABLE_100
332: , p5_a21 JTF_VARCHAR2_TABLE_100
333: , p5_a22 JTF_NUMBER_TABLE
334: , p5_a23 JTF_NUMBER_TABLE
335: , p5_a24 JTF_NUMBER_TABLE
336: , p5_a25 JTF_DATE_TABLE
337: , p5_a26 JTF_NUMBER_TABLE
330: , p5_a19 JTF_VARCHAR2_TABLE_500
331: , p5_a20 JTF_VARCHAR2_TABLE_100
332: , p5_a21 JTF_VARCHAR2_TABLE_100
333: , p5_a22 JTF_NUMBER_TABLE
334: , p5_a23 JTF_NUMBER_TABLE
335: , p5_a24 JTF_NUMBER_TABLE
336: , p5_a25 JTF_DATE_TABLE
337: , p5_a26 JTF_NUMBER_TABLE
338: , p5_a27 JTF_DATE_TABLE
331: , p5_a20 JTF_VARCHAR2_TABLE_100
332: , p5_a21 JTF_VARCHAR2_TABLE_100
333: , p5_a22 JTF_NUMBER_TABLE
334: , p5_a23 JTF_NUMBER_TABLE
335: , p5_a24 JTF_NUMBER_TABLE
336: , p5_a25 JTF_DATE_TABLE
337: , p5_a26 JTF_NUMBER_TABLE
338: , p5_a27 JTF_DATE_TABLE
339: , p5_a28 JTF_NUMBER_TABLE
333: , p5_a22 JTF_NUMBER_TABLE
334: , p5_a23 JTF_NUMBER_TABLE
335: , p5_a24 JTF_NUMBER_TABLE
336: , p5_a25 JTF_DATE_TABLE
337: , p5_a26 JTF_NUMBER_TABLE
338: , p5_a27 JTF_DATE_TABLE
339: , p5_a28 JTF_NUMBER_TABLE
340: , p5_a29 JTF_DATE_TABLE
341: , p5_a30 JTF_NUMBER_TABLE
335: , p5_a24 JTF_NUMBER_TABLE
336: , p5_a25 JTF_DATE_TABLE
337: , p5_a26 JTF_NUMBER_TABLE
338: , p5_a27 JTF_DATE_TABLE
339: , p5_a28 JTF_NUMBER_TABLE
340: , p5_a29 JTF_DATE_TABLE
341: , p5_a30 JTF_NUMBER_TABLE
342: );
343: procedure update_row(p_api_version NUMBER
337: , p5_a26 JTF_NUMBER_TABLE
338: , p5_a27 JTF_DATE_TABLE
339: , p5_a28 JTF_NUMBER_TABLE
340: , p5_a29 JTF_DATE_TABLE
341: , p5_a30 JTF_NUMBER_TABLE
342: );
343: procedure update_row(p_api_version NUMBER
344: , p_init_msg_list VARCHAR2
345: , x_return_status out nocopy VARCHAR2
412: , p_init_msg_list VARCHAR2
413: , x_return_status out nocopy VARCHAR2
414: , x_msg_count out nocopy NUMBER
415: , x_msg_data out nocopy VARCHAR2
416: , p5_a0 JTF_NUMBER_TABLE
417: , p5_a1 JTF_NUMBER_TABLE
418: , p5_a2 JTF_VARCHAR2_TABLE_200
419: , p5_a3 JTF_VARCHAR2_TABLE_2000
420: , p5_a4 JTF_VARCHAR2_TABLE_100
413: , x_return_status out nocopy VARCHAR2
414: , x_msg_count out nocopy NUMBER
415: , x_msg_data out nocopy VARCHAR2
416: , p5_a0 JTF_NUMBER_TABLE
417: , p5_a1 JTF_NUMBER_TABLE
418: , p5_a2 JTF_VARCHAR2_TABLE_200
419: , p5_a3 JTF_VARCHAR2_TABLE_2000
420: , p5_a4 JTF_VARCHAR2_TABLE_100
421: , p5_a5 JTF_VARCHAR2_TABLE_500
434: , p5_a18 JTF_VARCHAR2_TABLE_500
435: , p5_a19 JTF_VARCHAR2_TABLE_500
436: , p5_a20 JTF_VARCHAR2_TABLE_100
437: , p5_a21 JTF_VARCHAR2_TABLE_100
438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_NUMBER_TABLE
441: , p5_a25 JTF_DATE_TABLE
442: , p5_a26 JTF_NUMBER_TABLE
435: , p5_a19 JTF_VARCHAR2_TABLE_500
436: , p5_a20 JTF_VARCHAR2_TABLE_100
437: , p5_a21 JTF_VARCHAR2_TABLE_100
438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_NUMBER_TABLE
441: , p5_a25 JTF_DATE_TABLE
442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
436: , p5_a20 JTF_VARCHAR2_TABLE_100
437: , p5_a21 JTF_VARCHAR2_TABLE_100
438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_NUMBER_TABLE
441: , p5_a25 JTF_DATE_TABLE
442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_NUMBER_TABLE
441: , p5_a25 JTF_DATE_TABLE
442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE
440: , p5_a24 JTF_NUMBER_TABLE
441: , p5_a25 JTF_DATE_TABLE
442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_NUMBER_TABLE
449: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_NUMBER_TABLE
449: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
451: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_NUMBER_TABLE
449: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
451: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
452: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
465: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
466: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
467: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a22 out nocopy JTF_NUMBER_TABLE
470: , p6_a23 out nocopy JTF_NUMBER_TABLE
471: , p6_a24 out nocopy JTF_NUMBER_TABLE
472: , p6_a25 out nocopy JTF_DATE_TABLE
473: , p6_a26 out nocopy JTF_NUMBER_TABLE
466: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
467: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a22 out nocopy JTF_NUMBER_TABLE
470: , p6_a23 out nocopy JTF_NUMBER_TABLE
471: , p6_a24 out nocopy JTF_NUMBER_TABLE
472: , p6_a25 out nocopy JTF_DATE_TABLE
473: , p6_a26 out nocopy JTF_NUMBER_TABLE
474: , p6_a27 out nocopy JTF_DATE_TABLE
467: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a22 out nocopy JTF_NUMBER_TABLE
470: , p6_a23 out nocopy JTF_NUMBER_TABLE
471: , p6_a24 out nocopy JTF_NUMBER_TABLE
472: , p6_a25 out nocopy JTF_DATE_TABLE
473: , p6_a26 out nocopy JTF_NUMBER_TABLE
474: , p6_a27 out nocopy JTF_DATE_TABLE
475: , p6_a28 out nocopy JTF_NUMBER_TABLE
469: , p6_a22 out nocopy JTF_NUMBER_TABLE
470: , p6_a23 out nocopy JTF_NUMBER_TABLE
471: , p6_a24 out nocopy JTF_NUMBER_TABLE
472: , p6_a25 out nocopy JTF_DATE_TABLE
473: , p6_a26 out nocopy JTF_NUMBER_TABLE
474: , p6_a27 out nocopy JTF_DATE_TABLE
475: , p6_a28 out nocopy JTF_NUMBER_TABLE
476: , p6_a29 out nocopy JTF_DATE_TABLE
477: , p6_a30 out nocopy JTF_NUMBER_TABLE
471: , p6_a24 out nocopy JTF_NUMBER_TABLE
472: , p6_a25 out nocopy JTF_DATE_TABLE
473: , p6_a26 out nocopy JTF_NUMBER_TABLE
474: , p6_a27 out nocopy JTF_DATE_TABLE
475: , p6_a28 out nocopy JTF_NUMBER_TABLE
476: , p6_a29 out nocopy JTF_DATE_TABLE
477: , p6_a30 out nocopy JTF_NUMBER_TABLE
478: );
479: procedure delete_row(p_api_version NUMBER
473: , p6_a26 out nocopy JTF_NUMBER_TABLE
474: , p6_a27 out nocopy JTF_DATE_TABLE
475: , p6_a28 out nocopy JTF_NUMBER_TABLE
476: , p6_a29 out nocopy JTF_DATE_TABLE
477: , p6_a30 out nocopy JTF_NUMBER_TABLE
478: );
479: procedure delete_row(p_api_version NUMBER
480: , p_init_msg_list VARCHAR2
481: , x_return_status out nocopy VARCHAR2
517: , p_init_msg_list VARCHAR2
518: , x_return_status out nocopy VARCHAR2
519: , x_msg_count out nocopy NUMBER
520: , x_msg_data out nocopy VARCHAR2
521: , p5_a0 JTF_NUMBER_TABLE
522: , p5_a1 JTF_NUMBER_TABLE
523: , p5_a2 JTF_VARCHAR2_TABLE_200
524: , p5_a3 JTF_VARCHAR2_TABLE_2000
525: , p5_a4 JTF_VARCHAR2_TABLE_100
518: , x_return_status out nocopy VARCHAR2
519: , x_msg_count out nocopy NUMBER
520: , x_msg_data out nocopy VARCHAR2
521: , p5_a0 JTF_NUMBER_TABLE
522: , p5_a1 JTF_NUMBER_TABLE
523: , p5_a2 JTF_VARCHAR2_TABLE_200
524: , p5_a3 JTF_VARCHAR2_TABLE_2000
525: , p5_a4 JTF_VARCHAR2_TABLE_100
526: , p5_a5 JTF_VARCHAR2_TABLE_500
539: , p5_a18 JTF_VARCHAR2_TABLE_500
540: , p5_a19 JTF_VARCHAR2_TABLE_500
541: , p5_a20 JTF_VARCHAR2_TABLE_100
542: , p5_a21 JTF_VARCHAR2_TABLE_100
543: , p5_a22 JTF_NUMBER_TABLE
544: , p5_a23 JTF_NUMBER_TABLE
545: , p5_a24 JTF_NUMBER_TABLE
546: , p5_a25 JTF_DATE_TABLE
547: , p5_a26 JTF_NUMBER_TABLE
540: , p5_a19 JTF_VARCHAR2_TABLE_500
541: , p5_a20 JTF_VARCHAR2_TABLE_100
542: , p5_a21 JTF_VARCHAR2_TABLE_100
543: , p5_a22 JTF_NUMBER_TABLE
544: , p5_a23 JTF_NUMBER_TABLE
545: , p5_a24 JTF_NUMBER_TABLE
546: , p5_a25 JTF_DATE_TABLE
547: , p5_a26 JTF_NUMBER_TABLE
548: , p5_a27 JTF_DATE_TABLE
541: , p5_a20 JTF_VARCHAR2_TABLE_100
542: , p5_a21 JTF_VARCHAR2_TABLE_100
543: , p5_a22 JTF_NUMBER_TABLE
544: , p5_a23 JTF_NUMBER_TABLE
545: , p5_a24 JTF_NUMBER_TABLE
546: , p5_a25 JTF_DATE_TABLE
547: , p5_a26 JTF_NUMBER_TABLE
548: , p5_a27 JTF_DATE_TABLE
549: , p5_a28 JTF_NUMBER_TABLE
543: , p5_a22 JTF_NUMBER_TABLE
544: , p5_a23 JTF_NUMBER_TABLE
545: , p5_a24 JTF_NUMBER_TABLE
546: , p5_a25 JTF_DATE_TABLE
547: , p5_a26 JTF_NUMBER_TABLE
548: , p5_a27 JTF_DATE_TABLE
549: , p5_a28 JTF_NUMBER_TABLE
550: , p5_a29 JTF_DATE_TABLE
551: , p5_a30 JTF_NUMBER_TABLE
545: , p5_a24 JTF_NUMBER_TABLE
546: , p5_a25 JTF_DATE_TABLE
547: , p5_a26 JTF_NUMBER_TABLE
548: , p5_a27 JTF_DATE_TABLE
549: , p5_a28 JTF_NUMBER_TABLE
550: , p5_a29 JTF_DATE_TABLE
551: , p5_a30 JTF_NUMBER_TABLE
552: );
553: procedure validate_row(p_api_version NUMBER
547: , p5_a26 JTF_NUMBER_TABLE
548: , p5_a27 JTF_DATE_TABLE
549: , p5_a28 JTF_NUMBER_TABLE
550: , p5_a29 JTF_DATE_TABLE
551: , p5_a30 JTF_NUMBER_TABLE
552: );
553: procedure validate_row(p_api_version NUMBER
554: , p_init_msg_list VARCHAR2
555: , x_return_status out nocopy VARCHAR2
591: , p_init_msg_list VARCHAR2
592: , x_return_status out nocopy VARCHAR2
593: , x_msg_count out nocopy NUMBER
594: , x_msg_data out nocopy VARCHAR2
595: , p5_a0 JTF_NUMBER_TABLE
596: , p5_a1 JTF_NUMBER_TABLE
597: , p5_a2 JTF_VARCHAR2_TABLE_200
598: , p5_a3 JTF_VARCHAR2_TABLE_2000
599: , p5_a4 JTF_VARCHAR2_TABLE_100
592: , x_return_status out nocopy VARCHAR2
593: , x_msg_count out nocopy NUMBER
594: , x_msg_data out nocopy VARCHAR2
595: , p5_a0 JTF_NUMBER_TABLE
596: , p5_a1 JTF_NUMBER_TABLE
597: , p5_a2 JTF_VARCHAR2_TABLE_200
598: , p5_a3 JTF_VARCHAR2_TABLE_2000
599: , p5_a4 JTF_VARCHAR2_TABLE_100
600: , p5_a5 JTF_VARCHAR2_TABLE_500
613: , p5_a18 JTF_VARCHAR2_TABLE_500
614: , p5_a19 JTF_VARCHAR2_TABLE_500
615: , p5_a20 JTF_VARCHAR2_TABLE_100
616: , p5_a21 JTF_VARCHAR2_TABLE_100
617: , p5_a22 JTF_NUMBER_TABLE
618: , p5_a23 JTF_NUMBER_TABLE
619: , p5_a24 JTF_NUMBER_TABLE
620: , p5_a25 JTF_DATE_TABLE
621: , p5_a26 JTF_NUMBER_TABLE
614: , p5_a19 JTF_VARCHAR2_TABLE_500
615: , p5_a20 JTF_VARCHAR2_TABLE_100
616: , p5_a21 JTF_VARCHAR2_TABLE_100
617: , p5_a22 JTF_NUMBER_TABLE
618: , p5_a23 JTF_NUMBER_TABLE
619: , p5_a24 JTF_NUMBER_TABLE
620: , p5_a25 JTF_DATE_TABLE
621: , p5_a26 JTF_NUMBER_TABLE
622: , p5_a27 JTF_DATE_TABLE
615: , p5_a20 JTF_VARCHAR2_TABLE_100
616: , p5_a21 JTF_VARCHAR2_TABLE_100
617: , p5_a22 JTF_NUMBER_TABLE
618: , p5_a23 JTF_NUMBER_TABLE
619: , p5_a24 JTF_NUMBER_TABLE
620: , p5_a25 JTF_DATE_TABLE
621: , p5_a26 JTF_NUMBER_TABLE
622: , p5_a27 JTF_DATE_TABLE
623: , p5_a28 JTF_NUMBER_TABLE
617: , p5_a22 JTF_NUMBER_TABLE
618: , p5_a23 JTF_NUMBER_TABLE
619: , p5_a24 JTF_NUMBER_TABLE
620: , p5_a25 JTF_DATE_TABLE
621: , p5_a26 JTF_NUMBER_TABLE
622: , p5_a27 JTF_DATE_TABLE
623: , p5_a28 JTF_NUMBER_TABLE
624: , p5_a29 JTF_DATE_TABLE
625: , p5_a30 JTF_NUMBER_TABLE
619: , p5_a24 JTF_NUMBER_TABLE
620: , p5_a25 JTF_DATE_TABLE
621: , p5_a26 JTF_NUMBER_TABLE
622: , p5_a27 JTF_DATE_TABLE
623: , p5_a28 JTF_NUMBER_TABLE
624: , p5_a29 JTF_DATE_TABLE
625: , p5_a30 JTF_NUMBER_TABLE
626: );
627: end okl_idx_pvt_w;
621: , p5_a26 JTF_NUMBER_TABLE
622: , p5_a27 JTF_DATE_TABLE
623: , p5_a28 JTF_NUMBER_TABLE
624: , p5_a29 JTF_DATE_TABLE
625: , p5_a30 JTF_NUMBER_TABLE
626: );
627: end okl_idx_pvt_w;