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
30: );
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
32: , a1 out nocopy JTF_NUMBER_TABLE
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
58: );
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:
60: procedure insert_row(p_api_version NUMBER
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
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
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
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
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
179: );
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
181: , p_init_msg_list VARCHAR2
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
245: , p6_a0 in out nocopy JTF_NUMBER_TABLE
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
247: , p6_a2 in out nocopy JTF_NUMBER_TABLE
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
285: );
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
287: , p_init_msg_list VARCHAR2
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
378: , p6_a0 out nocopy JTF_NUMBER_TABLE
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
380: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
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
405: , p7_a0 in out nocopy JTF_NUMBER_TABLE
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
407: , p7_a2 in out nocopy JTF_NUMBER_TABLE
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
445: , p6_a0 out nocopy JTF_NUMBER_TABLE
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
447: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
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
472: );
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
474: , p_init_msg_list VARCHAR2
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
538: , p6_a0 in out nocopy JTF_NUMBER_TABLE
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
540: , p6_a2 in out nocopy JTF_NUMBER_TABLE
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
578: );
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
580: , p_init_msg_list VARCHAR2
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
644: , p6_a0 in out nocopy JTF_NUMBER_TABLE
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
646: , p6_a2 in out nocopy JTF_NUMBER_TABLE
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
684: );
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;