1: package okl_xmp_pvt_w as
2: /* $Header: OKLIXMPS.pls 120.0 2007/04/02 09:12:21 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_xmp_pvt.xmp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_xmp_pvt_w as
2: /* $Header: OKLIXMPS.pls 120.0 2007/04/02 09:12:21 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_xmp_pvt.xmp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
2: /* $Header: OKLIXMPS.pls 120.0 2007/04/02 09:12:21 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_xmp_pvt.xmp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 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_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_VARCHAR2_TABLE_300
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_VARCHAR2_TABLE_300
30: );
31: procedure rosetta_table_copy_out_p2(t okl_xmp_pvt.xmp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_VARCHAR2_TABLE_300
30: );
31: procedure rosetta_table_copy_out_p2(t okl_xmp_pvt.xmp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_VARCHAR2_TABLE_300
34: , a3 out nocopy JTF_NUMBER_TABLE
35: , a4 out nocopy JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_VARCHAR2_TABLE_300
30: );
31: procedure rosetta_table_copy_out_p2(t okl_xmp_pvt.xmp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_VARCHAR2_TABLE_300
34: , a3 out nocopy JTF_NUMBER_TABLE
35: , a4 out nocopy JTF_VARCHAR2_TABLE_100
36: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
30: );
31: procedure rosetta_table_copy_out_p2(t okl_xmp_pvt.xmp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_VARCHAR2_TABLE_300
34: , a3 out nocopy JTF_NUMBER_TABLE
35: , a4 out nocopy JTF_VARCHAR2_TABLE_100
36: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
38: , a7 out nocopy JTF_VARCHAR2_TABLE_500
49: , a18 out nocopy JTF_VARCHAR2_TABLE_500
50: , a19 out nocopy JTF_VARCHAR2_TABLE_500
51: , a20 out nocopy JTF_VARCHAR2_TABLE_500
52: , a21 out nocopy JTF_VARCHAR2_TABLE_500
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_VARCHAR2_TABLE_300
51: , a20 out nocopy JTF_VARCHAR2_TABLE_500
52: , a21 out nocopy JTF_VARCHAR2_TABLE_500
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_VARCHAR2_TABLE_300
58: );
59:
121: , p_init_msg_list VARCHAR2
122: , x_return_status out nocopy VARCHAR2
123: , x_msg_count out nocopy NUMBER
124: , x_msg_data out nocopy VARCHAR2
125: , p5_a0 JTF_NUMBER_TABLE
126: , p5_a1 JTF_NUMBER_TABLE
127: , p5_a2 JTF_VARCHAR2_TABLE_300
128: , p5_a3 JTF_NUMBER_TABLE
129: , p5_a4 JTF_VARCHAR2_TABLE_100
122: , x_return_status out nocopy VARCHAR2
123: , x_msg_count out nocopy NUMBER
124: , x_msg_data out nocopy VARCHAR2
125: , p5_a0 JTF_NUMBER_TABLE
126: , p5_a1 JTF_NUMBER_TABLE
127: , p5_a2 JTF_VARCHAR2_TABLE_300
128: , p5_a3 JTF_NUMBER_TABLE
129: , p5_a4 JTF_VARCHAR2_TABLE_100
130: , p5_a5 JTF_VARCHAR2_TABLE_2000
124: , x_msg_data out nocopy VARCHAR2
125: , p5_a0 JTF_NUMBER_TABLE
126: , p5_a1 JTF_NUMBER_TABLE
127: , p5_a2 JTF_VARCHAR2_TABLE_300
128: , p5_a3 JTF_NUMBER_TABLE
129: , p5_a4 JTF_VARCHAR2_TABLE_100
130: , p5_a5 JTF_VARCHAR2_TABLE_2000
131: , p5_a6 JTF_VARCHAR2_TABLE_100
132: , p5_a7 JTF_VARCHAR2_TABLE_500
143: , p5_a18 JTF_VARCHAR2_TABLE_500
144: , p5_a19 JTF_VARCHAR2_TABLE_500
145: , p5_a20 JTF_VARCHAR2_TABLE_500
146: , p5_a21 JTF_VARCHAR2_TABLE_500
147: , p5_a22 JTF_NUMBER_TABLE
148: , p5_a23 JTF_DATE_TABLE
149: , p5_a24 JTF_NUMBER_TABLE
150: , p5_a25 JTF_DATE_TABLE
151: , p5_a26 JTF_VARCHAR2_TABLE_300
145: , p5_a20 JTF_VARCHAR2_TABLE_500
146: , p5_a21 JTF_VARCHAR2_TABLE_500
147: , p5_a22 JTF_NUMBER_TABLE
148: , p5_a23 JTF_DATE_TABLE
149: , p5_a24 JTF_NUMBER_TABLE
150: , p5_a25 JTF_DATE_TABLE
151: , p5_a26 JTF_VARCHAR2_TABLE_300
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p5_a23 JTF_DATE_TABLE
149: , p5_a24 JTF_NUMBER_TABLE
150: , p5_a25 JTF_DATE_TABLE
151: , p5_a26 JTF_VARCHAR2_TABLE_300
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
155: , p6_a3 out nocopy JTF_NUMBER_TABLE
156: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
149: , p5_a24 JTF_NUMBER_TABLE
150: , p5_a25 JTF_DATE_TABLE
151: , p5_a26 JTF_VARCHAR2_TABLE_300
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
155: , p6_a3 out nocopy JTF_NUMBER_TABLE
156: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
157: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
151: , p5_a26 JTF_VARCHAR2_TABLE_300
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
155: , p6_a3 out nocopy JTF_NUMBER_TABLE
156: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
157: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
158: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
159: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
170: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
171: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
172: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
173: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
174: , p6_a22 out nocopy JTF_NUMBER_TABLE
175: , p6_a23 out nocopy JTF_DATE_TABLE
176: , p6_a24 out nocopy JTF_NUMBER_TABLE
177: , p6_a25 out nocopy JTF_DATE_TABLE
178: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
172: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
173: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
174: , p6_a22 out nocopy JTF_NUMBER_TABLE
175: , p6_a23 out nocopy JTF_DATE_TABLE
176: , p6_a24 out nocopy JTF_NUMBER_TABLE
177: , p6_a25 out nocopy JTF_DATE_TABLE
178: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
179: );
180: procedure lock_row(p_api_version NUMBER
214: , p_init_msg_list VARCHAR2
215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_VARCHAR2_TABLE_300
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_100
215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_VARCHAR2_TABLE_300
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_100
223: , p5_a5 JTF_VARCHAR2_TABLE_2000
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_VARCHAR2_TABLE_300
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_100
223: , p5_a5 JTF_VARCHAR2_TABLE_2000
224: , p5_a6 JTF_VARCHAR2_TABLE_100
225: , p5_a7 JTF_VARCHAR2_TABLE_500
236: , p5_a18 JTF_VARCHAR2_TABLE_500
237: , p5_a19 JTF_VARCHAR2_TABLE_500
238: , p5_a20 JTF_VARCHAR2_TABLE_500
239: , p5_a21 JTF_VARCHAR2_TABLE_500
240: , p5_a22 JTF_NUMBER_TABLE
241: , p5_a23 JTF_DATE_TABLE
242: , p5_a24 JTF_NUMBER_TABLE
243: , p5_a25 JTF_DATE_TABLE
244: , p5_a26 JTF_VARCHAR2_TABLE_300
238: , p5_a20 JTF_VARCHAR2_TABLE_500
239: , p5_a21 JTF_VARCHAR2_TABLE_500
240: , p5_a22 JTF_NUMBER_TABLE
241: , p5_a23 JTF_DATE_TABLE
242: , p5_a24 JTF_NUMBER_TABLE
243: , p5_a25 JTF_DATE_TABLE
244: , p5_a26 JTF_VARCHAR2_TABLE_300
245: , p6_a0 in out nocopy JTF_NUMBER_TABLE
246: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a23 JTF_DATE_TABLE
242: , p5_a24 JTF_NUMBER_TABLE
243: , p5_a25 JTF_DATE_TABLE
244: , p5_a26 JTF_VARCHAR2_TABLE_300
245: , p6_a0 in out nocopy JTF_NUMBER_TABLE
246: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a2 in out nocopy JTF_NUMBER_TABLE
248: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
249: , p6_a4 in out nocopy JTF_NUMBER_TABLE
243: , p5_a25 JTF_DATE_TABLE
244: , p5_a26 JTF_VARCHAR2_TABLE_300
245: , p6_a0 in out nocopy JTF_NUMBER_TABLE
246: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a2 in out nocopy JTF_NUMBER_TABLE
248: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
249: , p6_a4 in out nocopy JTF_NUMBER_TABLE
250: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a0 in out nocopy JTF_NUMBER_TABLE
246: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a2 in out nocopy JTF_NUMBER_TABLE
248: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
249: , p6_a4 in out nocopy JTF_NUMBER_TABLE
250: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
252: );
253: procedure lock_row(p_api_version NUMBER
254: , p_init_msg_list VARCHAR2
255: , x_return_status out nocopy VARCHAR2
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2
258: , p5_a0 JTF_NUMBER_TABLE
259: , p5_a1 JTF_NUMBER_TABLE
260: , p5_a2 JTF_VARCHAR2_TABLE_300
261: , p5_a3 JTF_NUMBER_TABLE
262: , p5_a4 JTF_VARCHAR2_TABLE_100
255: , x_return_status out nocopy VARCHAR2
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2
258: , p5_a0 JTF_NUMBER_TABLE
259: , p5_a1 JTF_NUMBER_TABLE
260: , p5_a2 JTF_VARCHAR2_TABLE_300
261: , p5_a3 JTF_NUMBER_TABLE
262: , p5_a4 JTF_VARCHAR2_TABLE_100
263: , p5_a5 JTF_VARCHAR2_TABLE_2000
257: , x_msg_data out nocopy VARCHAR2
258: , p5_a0 JTF_NUMBER_TABLE
259: , p5_a1 JTF_NUMBER_TABLE
260: , p5_a2 JTF_VARCHAR2_TABLE_300
261: , p5_a3 JTF_NUMBER_TABLE
262: , p5_a4 JTF_VARCHAR2_TABLE_100
263: , p5_a5 JTF_VARCHAR2_TABLE_2000
264: , p5_a6 JTF_VARCHAR2_TABLE_100
265: , p5_a7 JTF_VARCHAR2_TABLE_500
276: , p5_a18 JTF_VARCHAR2_TABLE_500
277: , p5_a19 JTF_VARCHAR2_TABLE_500
278: , p5_a20 JTF_VARCHAR2_TABLE_500
279: , p5_a21 JTF_VARCHAR2_TABLE_500
280: , p5_a22 JTF_NUMBER_TABLE
281: , p5_a23 JTF_DATE_TABLE
282: , p5_a24 JTF_NUMBER_TABLE
283: , p5_a25 JTF_DATE_TABLE
284: , p5_a26 JTF_VARCHAR2_TABLE_300
278: , p5_a20 JTF_VARCHAR2_TABLE_500
279: , p5_a21 JTF_VARCHAR2_TABLE_500
280: , p5_a22 JTF_NUMBER_TABLE
281: , p5_a23 JTF_DATE_TABLE
282: , p5_a24 JTF_NUMBER_TABLE
283: , p5_a25 JTF_DATE_TABLE
284: , p5_a26 JTF_VARCHAR2_TABLE_300
285: );
286: procedure update_row(p_api_version NUMBER
347: , p_init_msg_list VARCHAR2
348: , x_return_status out nocopy VARCHAR2
349: , x_msg_count out nocopy NUMBER
350: , x_msg_data out nocopy VARCHAR2
351: , p5_a0 JTF_NUMBER_TABLE
352: , p5_a1 JTF_NUMBER_TABLE
353: , p5_a2 JTF_VARCHAR2_TABLE_300
354: , p5_a3 JTF_NUMBER_TABLE
355: , p5_a4 JTF_VARCHAR2_TABLE_100
348: , x_return_status out nocopy VARCHAR2
349: , x_msg_count out nocopy NUMBER
350: , x_msg_data out nocopy VARCHAR2
351: , p5_a0 JTF_NUMBER_TABLE
352: , p5_a1 JTF_NUMBER_TABLE
353: , p5_a2 JTF_VARCHAR2_TABLE_300
354: , p5_a3 JTF_NUMBER_TABLE
355: , p5_a4 JTF_VARCHAR2_TABLE_100
356: , p5_a5 JTF_VARCHAR2_TABLE_2000
350: , x_msg_data out nocopy VARCHAR2
351: , p5_a0 JTF_NUMBER_TABLE
352: , p5_a1 JTF_NUMBER_TABLE
353: , p5_a2 JTF_VARCHAR2_TABLE_300
354: , p5_a3 JTF_NUMBER_TABLE
355: , p5_a4 JTF_VARCHAR2_TABLE_100
356: , p5_a5 JTF_VARCHAR2_TABLE_2000
357: , p5_a6 JTF_VARCHAR2_TABLE_100
358: , p5_a7 JTF_VARCHAR2_TABLE_500
369: , p5_a18 JTF_VARCHAR2_TABLE_500
370: , p5_a19 JTF_VARCHAR2_TABLE_500
371: , p5_a20 JTF_VARCHAR2_TABLE_500
372: , p5_a21 JTF_VARCHAR2_TABLE_500
373: , p5_a22 JTF_NUMBER_TABLE
374: , p5_a23 JTF_DATE_TABLE
375: , p5_a24 JTF_NUMBER_TABLE
376: , p5_a25 JTF_DATE_TABLE
377: , p5_a26 JTF_VARCHAR2_TABLE_300
371: , p5_a20 JTF_VARCHAR2_TABLE_500
372: , p5_a21 JTF_VARCHAR2_TABLE_500
373: , p5_a22 JTF_NUMBER_TABLE
374: , p5_a23 JTF_DATE_TABLE
375: , p5_a24 JTF_NUMBER_TABLE
376: , p5_a25 JTF_DATE_TABLE
377: , p5_a26 JTF_VARCHAR2_TABLE_300
378: , p6_a0 out nocopy JTF_NUMBER_TABLE
379: , p6_a1 out nocopy JTF_NUMBER_TABLE
374: , p5_a23 JTF_DATE_TABLE
375: , p5_a24 JTF_NUMBER_TABLE
376: , p5_a25 JTF_DATE_TABLE
377: , p5_a26 JTF_VARCHAR2_TABLE_300
378: , p6_a0 out nocopy JTF_NUMBER_TABLE
379: , p6_a1 out nocopy JTF_NUMBER_TABLE
380: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
381: , p6_a3 out nocopy JTF_NUMBER_TABLE
382: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
375: , p5_a24 JTF_NUMBER_TABLE
376: , p5_a25 JTF_DATE_TABLE
377: , p5_a26 JTF_VARCHAR2_TABLE_300
378: , p6_a0 out nocopy JTF_NUMBER_TABLE
379: , p6_a1 out nocopy JTF_NUMBER_TABLE
380: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
381: , p6_a3 out nocopy JTF_NUMBER_TABLE
382: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
377: , p5_a26 JTF_VARCHAR2_TABLE_300
378: , p6_a0 out nocopy JTF_NUMBER_TABLE
379: , p6_a1 out nocopy JTF_NUMBER_TABLE
380: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
381: , p6_a3 out nocopy JTF_NUMBER_TABLE
382: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
384: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
385: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
396: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
397: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
398: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
399: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a22 out nocopy JTF_NUMBER_TABLE
401: , p6_a23 out nocopy JTF_DATE_TABLE
402: , p6_a24 out nocopy JTF_NUMBER_TABLE
403: , p6_a25 out nocopy JTF_DATE_TABLE
404: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
398: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
399: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a22 out nocopy JTF_NUMBER_TABLE
401: , p6_a23 out nocopy JTF_DATE_TABLE
402: , p6_a24 out nocopy JTF_NUMBER_TABLE
403: , p6_a25 out nocopy JTF_DATE_TABLE
404: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
405: , p7_a0 in out nocopy JTF_NUMBER_TABLE
406: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
401: , p6_a23 out nocopy JTF_DATE_TABLE
402: , p6_a24 out nocopy JTF_NUMBER_TABLE
403: , p6_a25 out nocopy JTF_DATE_TABLE
404: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
405: , p7_a0 in out nocopy JTF_NUMBER_TABLE
406: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p7_a2 in out nocopy JTF_NUMBER_TABLE
408: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
409: , p7_a4 in out nocopy JTF_NUMBER_TABLE
403: , p6_a25 out nocopy JTF_DATE_TABLE
404: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
405: , p7_a0 in out nocopy JTF_NUMBER_TABLE
406: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p7_a2 in out nocopy JTF_NUMBER_TABLE
408: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
409: , p7_a4 in out nocopy JTF_NUMBER_TABLE
410: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
411: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
405: , p7_a0 in out nocopy JTF_NUMBER_TABLE
406: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p7_a2 in out nocopy JTF_NUMBER_TABLE
408: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
409: , p7_a4 in out nocopy JTF_NUMBER_TABLE
410: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
411: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
412: );
413: procedure update_row(p_api_version NUMBER
414: , p_init_msg_list VARCHAR2
415: , x_return_status out nocopy VARCHAR2
416: , x_msg_count out nocopy NUMBER
417: , x_msg_data out nocopy VARCHAR2
418: , p5_a0 JTF_NUMBER_TABLE
419: , p5_a1 JTF_NUMBER_TABLE
420: , p5_a2 JTF_VARCHAR2_TABLE_300
421: , p5_a3 JTF_NUMBER_TABLE
422: , p5_a4 JTF_VARCHAR2_TABLE_100
415: , x_return_status out nocopy VARCHAR2
416: , x_msg_count out nocopy NUMBER
417: , x_msg_data out nocopy VARCHAR2
418: , p5_a0 JTF_NUMBER_TABLE
419: , p5_a1 JTF_NUMBER_TABLE
420: , p5_a2 JTF_VARCHAR2_TABLE_300
421: , p5_a3 JTF_NUMBER_TABLE
422: , p5_a4 JTF_VARCHAR2_TABLE_100
423: , p5_a5 JTF_VARCHAR2_TABLE_2000
417: , x_msg_data out nocopy VARCHAR2
418: , p5_a0 JTF_NUMBER_TABLE
419: , p5_a1 JTF_NUMBER_TABLE
420: , p5_a2 JTF_VARCHAR2_TABLE_300
421: , p5_a3 JTF_NUMBER_TABLE
422: , p5_a4 JTF_VARCHAR2_TABLE_100
423: , p5_a5 JTF_VARCHAR2_TABLE_2000
424: , p5_a6 JTF_VARCHAR2_TABLE_100
425: , p5_a7 JTF_VARCHAR2_TABLE_500
436: , p5_a18 JTF_VARCHAR2_TABLE_500
437: , p5_a19 JTF_VARCHAR2_TABLE_500
438: , p5_a20 JTF_VARCHAR2_TABLE_500
439: , p5_a21 JTF_VARCHAR2_TABLE_500
440: , p5_a22 JTF_NUMBER_TABLE
441: , p5_a23 JTF_DATE_TABLE
442: , p5_a24 JTF_NUMBER_TABLE
443: , p5_a25 JTF_DATE_TABLE
444: , p5_a26 JTF_VARCHAR2_TABLE_300
438: , p5_a20 JTF_VARCHAR2_TABLE_500
439: , p5_a21 JTF_VARCHAR2_TABLE_500
440: , p5_a22 JTF_NUMBER_TABLE
441: , p5_a23 JTF_DATE_TABLE
442: , p5_a24 JTF_NUMBER_TABLE
443: , p5_a25 JTF_DATE_TABLE
444: , p5_a26 JTF_VARCHAR2_TABLE_300
445: , p6_a0 out nocopy JTF_NUMBER_TABLE
446: , p6_a1 out nocopy JTF_NUMBER_TABLE
441: , p5_a23 JTF_DATE_TABLE
442: , p5_a24 JTF_NUMBER_TABLE
443: , p5_a25 JTF_DATE_TABLE
444: , p5_a26 JTF_VARCHAR2_TABLE_300
445: , p6_a0 out nocopy JTF_NUMBER_TABLE
446: , p6_a1 out nocopy JTF_NUMBER_TABLE
447: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
448: , p6_a3 out nocopy JTF_NUMBER_TABLE
449: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
442: , p5_a24 JTF_NUMBER_TABLE
443: , p5_a25 JTF_DATE_TABLE
444: , p5_a26 JTF_VARCHAR2_TABLE_300
445: , p6_a0 out nocopy JTF_NUMBER_TABLE
446: , p6_a1 out nocopy JTF_NUMBER_TABLE
447: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
448: , p6_a3 out nocopy JTF_NUMBER_TABLE
449: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
444: , p5_a26 JTF_VARCHAR2_TABLE_300
445: , p6_a0 out nocopy JTF_NUMBER_TABLE
446: , p6_a1 out nocopy JTF_NUMBER_TABLE
447: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
448: , p6_a3 out nocopy JTF_NUMBER_TABLE
449: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
451: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
452: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
465: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
466: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
467: , p6_a22 out nocopy JTF_NUMBER_TABLE
468: , p6_a23 out nocopy JTF_DATE_TABLE
469: , p6_a24 out nocopy JTF_NUMBER_TABLE
470: , p6_a25 out nocopy JTF_DATE_TABLE
471: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
465: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
466: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
467: , p6_a22 out nocopy JTF_NUMBER_TABLE
468: , p6_a23 out nocopy JTF_DATE_TABLE
469: , p6_a24 out nocopy JTF_NUMBER_TABLE
470: , p6_a25 out nocopy JTF_DATE_TABLE
471: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
472: );
473: procedure delete_row(p_api_version NUMBER
507: , p_init_msg_list VARCHAR2
508: , x_return_status out nocopy VARCHAR2
509: , x_msg_count out nocopy NUMBER
510: , x_msg_data out nocopy VARCHAR2
511: , p5_a0 JTF_NUMBER_TABLE
512: , p5_a1 JTF_NUMBER_TABLE
513: , p5_a2 JTF_VARCHAR2_TABLE_300
514: , p5_a3 JTF_NUMBER_TABLE
515: , p5_a4 JTF_VARCHAR2_TABLE_100
508: , x_return_status out nocopy VARCHAR2
509: , x_msg_count out nocopy NUMBER
510: , x_msg_data out nocopy VARCHAR2
511: , p5_a0 JTF_NUMBER_TABLE
512: , p5_a1 JTF_NUMBER_TABLE
513: , p5_a2 JTF_VARCHAR2_TABLE_300
514: , p5_a3 JTF_NUMBER_TABLE
515: , p5_a4 JTF_VARCHAR2_TABLE_100
516: , p5_a5 JTF_VARCHAR2_TABLE_2000
510: , x_msg_data out nocopy VARCHAR2
511: , p5_a0 JTF_NUMBER_TABLE
512: , p5_a1 JTF_NUMBER_TABLE
513: , p5_a2 JTF_VARCHAR2_TABLE_300
514: , p5_a3 JTF_NUMBER_TABLE
515: , p5_a4 JTF_VARCHAR2_TABLE_100
516: , p5_a5 JTF_VARCHAR2_TABLE_2000
517: , p5_a6 JTF_VARCHAR2_TABLE_100
518: , p5_a7 JTF_VARCHAR2_TABLE_500
529: , p5_a18 JTF_VARCHAR2_TABLE_500
530: , p5_a19 JTF_VARCHAR2_TABLE_500
531: , p5_a20 JTF_VARCHAR2_TABLE_500
532: , p5_a21 JTF_VARCHAR2_TABLE_500
533: , p5_a22 JTF_NUMBER_TABLE
534: , p5_a23 JTF_DATE_TABLE
535: , p5_a24 JTF_NUMBER_TABLE
536: , p5_a25 JTF_DATE_TABLE
537: , p5_a26 JTF_VARCHAR2_TABLE_300
531: , p5_a20 JTF_VARCHAR2_TABLE_500
532: , p5_a21 JTF_VARCHAR2_TABLE_500
533: , p5_a22 JTF_NUMBER_TABLE
534: , p5_a23 JTF_DATE_TABLE
535: , p5_a24 JTF_NUMBER_TABLE
536: , p5_a25 JTF_DATE_TABLE
537: , p5_a26 JTF_VARCHAR2_TABLE_300
538: , p6_a0 in out nocopy JTF_NUMBER_TABLE
539: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p5_a23 JTF_DATE_TABLE
535: , p5_a24 JTF_NUMBER_TABLE
536: , p5_a25 JTF_DATE_TABLE
537: , p5_a26 JTF_VARCHAR2_TABLE_300
538: , p6_a0 in out nocopy JTF_NUMBER_TABLE
539: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
540: , p6_a2 in out nocopy JTF_NUMBER_TABLE
541: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
542: , p6_a4 in out nocopy JTF_NUMBER_TABLE
536: , p5_a25 JTF_DATE_TABLE
537: , p5_a26 JTF_VARCHAR2_TABLE_300
538: , p6_a0 in out nocopy JTF_NUMBER_TABLE
539: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
540: , p6_a2 in out nocopy JTF_NUMBER_TABLE
541: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
542: , p6_a4 in out nocopy JTF_NUMBER_TABLE
543: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
544: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a0 in out nocopy JTF_NUMBER_TABLE
539: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
540: , p6_a2 in out nocopy JTF_NUMBER_TABLE
541: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
542: , p6_a4 in out nocopy JTF_NUMBER_TABLE
543: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
544: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
545: );
546: procedure delete_row(p_api_version NUMBER
547: , p_init_msg_list VARCHAR2
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: , p5_a0 JTF_NUMBER_TABLE
552: , p5_a1 JTF_NUMBER_TABLE
553: , p5_a2 JTF_VARCHAR2_TABLE_300
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_100
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: , p5_a0 JTF_NUMBER_TABLE
552: , p5_a1 JTF_NUMBER_TABLE
553: , p5_a2 JTF_VARCHAR2_TABLE_300
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_100
556: , p5_a5 JTF_VARCHAR2_TABLE_2000
550: , x_msg_data out nocopy VARCHAR2
551: , p5_a0 JTF_NUMBER_TABLE
552: , p5_a1 JTF_NUMBER_TABLE
553: , p5_a2 JTF_VARCHAR2_TABLE_300
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_100
556: , p5_a5 JTF_VARCHAR2_TABLE_2000
557: , p5_a6 JTF_VARCHAR2_TABLE_100
558: , p5_a7 JTF_VARCHAR2_TABLE_500
569: , p5_a18 JTF_VARCHAR2_TABLE_500
570: , p5_a19 JTF_VARCHAR2_TABLE_500
571: , p5_a20 JTF_VARCHAR2_TABLE_500
572: , p5_a21 JTF_VARCHAR2_TABLE_500
573: , p5_a22 JTF_NUMBER_TABLE
574: , p5_a23 JTF_DATE_TABLE
575: , p5_a24 JTF_NUMBER_TABLE
576: , p5_a25 JTF_DATE_TABLE
577: , p5_a26 JTF_VARCHAR2_TABLE_300
571: , p5_a20 JTF_VARCHAR2_TABLE_500
572: , p5_a21 JTF_VARCHAR2_TABLE_500
573: , p5_a22 JTF_NUMBER_TABLE
574: , p5_a23 JTF_DATE_TABLE
575: , p5_a24 JTF_NUMBER_TABLE
576: , p5_a25 JTF_DATE_TABLE
577: , p5_a26 JTF_VARCHAR2_TABLE_300
578: );
579: procedure validate_row(p_api_version NUMBER
613: , p_init_msg_list VARCHAR2
614: , x_return_status out nocopy VARCHAR2
615: , x_msg_count out nocopy NUMBER
616: , x_msg_data out nocopy VARCHAR2
617: , p5_a0 JTF_NUMBER_TABLE
618: , p5_a1 JTF_NUMBER_TABLE
619: , p5_a2 JTF_VARCHAR2_TABLE_300
620: , p5_a3 JTF_NUMBER_TABLE
621: , p5_a4 JTF_VARCHAR2_TABLE_100
614: , x_return_status out nocopy VARCHAR2
615: , x_msg_count out nocopy NUMBER
616: , x_msg_data out nocopy VARCHAR2
617: , p5_a0 JTF_NUMBER_TABLE
618: , p5_a1 JTF_NUMBER_TABLE
619: , p5_a2 JTF_VARCHAR2_TABLE_300
620: , p5_a3 JTF_NUMBER_TABLE
621: , p5_a4 JTF_VARCHAR2_TABLE_100
622: , p5_a5 JTF_VARCHAR2_TABLE_2000
616: , x_msg_data out nocopy VARCHAR2
617: , p5_a0 JTF_NUMBER_TABLE
618: , p5_a1 JTF_NUMBER_TABLE
619: , p5_a2 JTF_VARCHAR2_TABLE_300
620: , p5_a3 JTF_NUMBER_TABLE
621: , p5_a4 JTF_VARCHAR2_TABLE_100
622: , p5_a5 JTF_VARCHAR2_TABLE_2000
623: , p5_a6 JTF_VARCHAR2_TABLE_100
624: , p5_a7 JTF_VARCHAR2_TABLE_500
635: , p5_a18 JTF_VARCHAR2_TABLE_500
636: , p5_a19 JTF_VARCHAR2_TABLE_500
637: , p5_a20 JTF_VARCHAR2_TABLE_500
638: , p5_a21 JTF_VARCHAR2_TABLE_500
639: , p5_a22 JTF_NUMBER_TABLE
640: , p5_a23 JTF_DATE_TABLE
641: , p5_a24 JTF_NUMBER_TABLE
642: , p5_a25 JTF_DATE_TABLE
643: , p5_a26 JTF_VARCHAR2_TABLE_300
637: , p5_a20 JTF_VARCHAR2_TABLE_500
638: , p5_a21 JTF_VARCHAR2_TABLE_500
639: , p5_a22 JTF_NUMBER_TABLE
640: , p5_a23 JTF_DATE_TABLE
641: , p5_a24 JTF_NUMBER_TABLE
642: , p5_a25 JTF_DATE_TABLE
643: , p5_a26 JTF_VARCHAR2_TABLE_300
644: , p6_a0 in out nocopy JTF_NUMBER_TABLE
645: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
640: , p5_a23 JTF_DATE_TABLE
641: , p5_a24 JTF_NUMBER_TABLE
642: , p5_a25 JTF_DATE_TABLE
643: , p5_a26 JTF_VARCHAR2_TABLE_300
644: , p6_a0 in out nocopy JTF_NUMBER_TABLE
645: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
646: , p6_a2 in out nocopy JTF_NUMBER_TABLE
647: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
648: , p6_a4 in out nocopy JTF_NUMBER_TABLE
642: , p5_a25 JTF_DATE_TABLE
643: , p5_a26 JTF_VARCHAR2_TABLE_300
644: , p6_a0 in out nocopy JTF_NUMBER_TABLE
645: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
646: , p6_a2 in out nocopy JTF_NUMBER_TABLE
647: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
648: , p6_a4 in out nocopy JTF_NUMBER_TABLE
649: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
650: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
644: , p6_a0 in out nocopy JTF_NUMBER_TABLE
645: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
646: , p6_a2 in out nocopy JTF_NUMBER_TABLE
647: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
648: , p6_a4 in out nocopy JTF_NUMBER_TABLE
649: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
650: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
651: );
652: procedure validate_row(p_api_version NUMBER
653: , p_init_msg_list VARCHAR2
654: , x_return_status out nocopy VARCHAR2
655: , x_msg_count out nocopy NUMBER
656: , x_msg_data out nocopy VARCHAR2
657: , p5_a0 JTF_NUMBER_TABLE
658: , p5_a1 JTF_NUMBER_TABLE
659: , p5_a2 JTF_VARCHAR2_TABLE_300
660: , p5_a3 JTF_NUMBER_TABLE
661: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , x_return_status out nocopy VARCHAR2
655: , x_msg_count out nocopy NUMBER
656: , x_msg_data out nocopy VARCHAR2
657: , p5_a0 JTF_NUMBER_TABLE
658: , p5_a1 JTF_NUMBER_TABLE
659: , p5_a2 JTF_VARCHAR2_TABLE_300
660: , p5_a3 JTF_NUMBER_TABLE
661: , p5_a4 JTF_VARCHAR2_TABLE_100
662: , p5_a5 JTF_VARCHAR2_TABLE_2000
656: , x_msg_data out nocopy VARCHAR2
657: , p5_a0 JTF_NUMBER_TABLE
658: , p5_a1 JTF_NUMBER_TABLE
659: , p5_a2 JTF_VARCHAR2_TABLE_300
660: , p5_a3 JTF_NUMBER_TABLE
661: , p5_a4 JTF_VARCHAR2_TABLE_100
662: , p5_a5 JTF_VARCHAR2_TABLE_2000
663: , p5_a6 JTF_VARCHAR2_TABLE_100
664: , p5_a7 JTF_VARCHAR2_TABLE_500
675: , p5_a18 JTF_VARCHAR2_TABLE_500
676: , p5_a19 JTF_VARCHAR2_TABLE_500
677: , p5_a20 JTF_VARCHAR2_TABLE_500
678: , p5_a21 JTF_VARCHAR2_TABLE_500
679: , p5_a22 JTF_NUMBER_TABLE
680: , p5_a23 JTF_DATE_TABLE
681: , p5_a24 JTF_NUMBER_TABLE
682: , p5_a25 JTF_DATE_TABLE
683: , p5_a26 JTF_VARCHAR2_TABLE_300
677: , p5_a20 JTF_VARCHAR2_TABLE_500
678: , p5_a21 JTF_VARCHAR2_TABLE_500
679: , p5_a22 JTF_NUMBER_TABLE
680: , p5_a23 JTF_DATE_TABLE
681: , p5_a24 JTF_NUMBER_TABLE
682: , p5_a25 JTF_DATE_TABLE
683: , p5_a26 JTF_VARCHAR2_TABLE_300
684: );
685: end okl_xmp_pvt_w;