1: package okl_etv_pvt_w as
2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_etv_pvt_w as
2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package okl_etv_pvt_w as
2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500
38: , a8 out nocopy JTF_VARCHAR2_TABLE_500
47: , a17 out nocopy JTF_VARCHAR2_TABLE_500
48: , a18 out nocopy JTF_VARCHAR2_TABLE_500
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure insert_row(p_api_version NUMBER
59: , p_init_msg_list VARCHAR2
117: , p_init_msg_list VARCHAR2
118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_VARCHAR2_TABLE_500
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_VARCHAR2_TABLE_500
128: , p5_a7 JTF_VARCHAR2_TABLE_500
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_VARCHAR2_TABLE_500
128: , p5_a7 JTF_VARCHAR2_TABLE_500
129: , p5_a8 JTF_VARCHAR2_TABLE_500
138: , p5_a17 JTF_VARCHAR2_TABLE_500
139: , p5_a18 JTF_VARCHAR2_TABLE_500
140: , p5_a19 JTF_VARCHAR2_TABLE_500
141: , p5_a20 JTF_VARCHAR2_TABLE_500
142: , p5_a21 JTF_NUMBER_TABLE
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
140: , p5_a19 JTF_VARCHAR2_TABLE_500
141: , p5_a20 JTF_VARCHAR2_TABLE_500
142: , p5_a21 JTF_NUMBER_TABLE
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
142: , p5_a21 JTF_NUMBER_TABLE
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
154: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
154: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
155: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
164: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
165: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
166: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
167: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
168: , p6_a21 out nocopy JTF_NUMBER_TABLE
169: , p6_a22 out nocopy JTF_DATE_TABLE
170: , p6_a23 out nocopy JTF_NUMBER_TABLE
171: , p6_a24 out nocopy JTF_DATE_TABLE
172: , p6_a25 out nocopy JTF_NUMBER_TABLE
166: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
167: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
168: , p6_a21 out nocopy JTF_NUMBER_TABLE
169: , p6_a22 out nocopy JTF_DATE_TABLE
170: , p6_a23 out nocopy JTF_NUMBER_TABLE
171: , p6_a24 out nocopy JTF_DATE_TABLE
172: , p6_a25 out nocopy JTF_NUMBER_TABLE
173: );
174: procedure update_row(p_api_version NUMBER
168: , p6_a21 out nocopy JTF_NUMBER_TABLE
169: , p6_a22 out nocopy JTF_DATE_TABLE
170: , p6_a23 out nocopy JTF_NUMBER_TABLE
171: , p6_a24 out nocopy JTF_DATE_TABLE
172: , p6_a25 out nocopy JTF_NUMBER_TABLE
173: );
174: procedure update_row(p_api_version NUMBER
175: , p_init_msg_list VARCHAR2
176: , x_return_status out nocopy VARCHAR2
233: , p_init_msg_list VARCHAR2
234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100
243: , p5_a6 JTF_VARCHAR2_TABLE_500
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100
243: , p5_a6 JTF_VARCHAR2_TABLE_500
244: , p5_a7 JTF_VARCHAR2_TABLE_500
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100
243: , p5_a6 JTF_VARCHAR2_TABLE_500
244: , p5_a7 JTF_VARCHAR2_TABLE_500
245: , p5_a8 JTF_VARCHAR2_TABLE_500
254: , p5_a17 JTF_VARCHAR2_TABLE_500
255: , p5_a18 JTF_VARCHAR2_TABLE_500
256: , p5_a19 JTF_VARCHAR2_TABLE_500
257: , p5_a20 JTF_VARCHAR2_TABLE_500
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
256: , p5_a19 JTF_VARCHAR2_TABLE_500
257: , p5_a20 JTF_VARCHAR2_TABLE_500
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
271: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
280: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
281: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a21 out nocopy JTF_NUMBER_TABLE
285: , p6_a22 out nocopy JTF_DATE_TABLE
286: , p6_a23 out nocopy JTF_NUMBER_TABLE
287: , p6_a24 out nocopy JTF_DATE_TABLE
288: , p6_a25 out nocopy JTF_NUMBER_TABLE
282: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a21 out nocopy JTF_NUMBER_TABLE
285: , p6_a22 out nocopy JTF_DATE_TABLE
286: , p6_a23 out nocopy JTF_NUMBER_TABLE
287: , p6_a24 out nocopy JTF_DATE_TABLE
288: , p6_a25 out nocopy JTF_NUMBER_TABLE
289: );
290: procedure delete_row(p_api_version NUMBER
284: , p6_a21 out nocopy JTF_NUMBER_TABLE
285: , p6_a22 out nocopy JTF_DATE_TABLE
286: , p6_a23 out nocopy JTF_NUMBER_TABLE
287: , p6_a24 out nocopy JTF_DATE_TABLE
288: , p6_a25 out nocopy JTF_NUMBER_TABLE
289: );
290: procedure delete_row(p_api_version NUMBER
291: , p_init_msg_list VARCHAR2
292: , x_return_status out nocopy VARCHAR2
323: , p_init_msg_list VARCHAR2
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_VARCHAR2_TABLE_500
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_VARCHAR2_TABLE_500
334: , p5_a7 JTF_VARCHAR2_TABLE_500
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_VARCHAR2_TABLE_500
334: , p5_a7 JTF_VARCHAR2_TABLE_500
335: , p5_a8 JTF_VARCHAR2_TABLE_500
344: , p5_a17 JTF_VARCHAR2_TABLE_500
345: , p5_a18 JTF_VARCHAR2_TABLE_500
346: , p5_a19 JTF_VARCHAR2_TABLE_500
347: , p5_a20 JTF_VARCHAR2_TABLE_500
348: , p5_a21 JTF_NUMBER_TABLE
349: , p5_a22 JTF_DATE_TABLE
350: , p5_a23 JTF_NUMBER_TABLE
351: , p5_a24 JTF_DATE_TABLE
352: , p5_a25 JTF_NUMBER_TABLE
346: , p5_a19 JTF_VARCHAR2_TABLE_500
347: , p5_a20 JTF_VARCHAR2_TABLE_500
348: , p5_a21 JTF_NUMBER_TABLE
349: , p5_a22 JTF_DATE_TABLE
350: , p5_a23 JTF_NUMBER_TABLE
351: , p5_a24 JTF_DATE_TABLE
352: , p5_a25 JTF_NUMBER_TABLE
353: );
354: end okl_etv_pvt_w;
348: , p5_a21 JTF_NUMBER_TABLE
349: , p5_a22 JTF_DATE_TABLE
350: , p5_a23 JTF_NUMBER_TABLE
351: , p5_a24 JTF_DATE_TABLE
352: , p5_a25 JTF_NUMBER_TABLE
353: );
354: end okl_etv_pvt_w;