DBA Data[Home] [Help]

APPS.OKL_XMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 5: , a2 JTF_VARCHAR2_TABLE_300

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
9: , a6 JTF_VARCHAR2_TABLE_100

Line 29: , a26 JTF_VARCHAR2_TABLE_300

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
33: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 33: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , a26 out nocopy JTF_VARCHAR2_TABLE_300

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
61: , p_init_msg_list VARCHAR2

Line 127: , p5_a2 JTF_VARCHAR2_TABLE_300

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
131: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 151: , p5_a26 JTF_VARCHAR2_TABLE_300

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
155: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
158: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300

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
182: , x_return_status out nocopy VARCHAR2

Line 220: , p5_a2 JTF_VARCHAR2_TABLE_300

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
224: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 244: , p5_a26 JTF_VARCHAR2_TABLE_300

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
248: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 260: , p5_a2 JTF_VARCHAR2_TABLE_300

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
264: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 284: , p5_a26 JTF_VARCHAR2_TABLE_300

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
288: , x_return_status out nocopy VARCHAR2

Line 353: , p5_a2 JTF_VARCHAR2_TABLE_300

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
357: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 377: , p5_a26 JTF_VARCHAR2_TABLE_300

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
381: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 380: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
384: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 404: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300

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
408: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 420: , p5_a2 JTF_VARCHAR2_TABLE_300

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
424: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 444: , p5_a26 JTF_VARCHAR2_TABLE_300

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
448: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 447: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
451: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 471: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300

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
475: , x_return_status out nocopy VARCHAR2

Line 513: , p5_a2 JTF_VARCHAR2_TABLE_300

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
517: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 537: , p5_a26 JTF_VARCHAR2_TABLE_300

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
541: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 553: , p5_a2 JTF_VARCHAR2_TABLE_300

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
557: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 577: , p5_a26 JTF_VARCHAR2_TABLE_300

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
581: , x_return_status out nocopy VARCHAR2

Line 619: , p5_a2 JTF_VARCHAR2_TABLE_300

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
623: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 643: , p5_a26 JTF_VARCHAR2_TABLE_300

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
647: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 659: , p5_a2 JTF_VARCHAR2_TABLE_300

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
663: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 683: , p5_a26 JTF_VARCHAR2_TABLE_300

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;