APPS.OKL_VRR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIVRRS.pls 120.0 2005/08/03 07:54:05 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500

Line 38: , a3 out nocopy JTF_VARCHAR2_TABLE_100

34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 41: , a6 out nocopy JTF_VARCHAR2_TABLE_100

37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , a7 out nocopy JTF_VARCHAR2_TABLE_500
43: , a8 out nocopy JTF_VARCHAR2_TABLE_500
44: , a9 out nocopy JTF_VARCHAR2_TABLE_500
45: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 71: , a3 JTF_VARCHAR2_TABLE_100

67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400
73: , a5 JTF_VARCHAR2_TABLE_2000
74: , a6 JTF_VARCHAR2_TABLE_100
75: , a7 JTF_VARCHAR2_TABLE_500

Line 74: , a6 JTF_VARCHAR2_TABLE_100

70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400
73: , a5 JTF_VARCHAR2_TABLE_2000
74: , a6 JTF_VARCHAR2_TABLE_100
75: , a7 JTF_VARCHAR2_TABLE_500
76: , a8 JTF_VARCHAR2_TABLE_500
77: , a9 JTF_VARCHAR2_TABLE_500
78: , a10 JTF_VARCHAR2_TABLE_500

Line 103: , a3 out nocopy JTF_VARCHAR2_TABLE_100

99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400
105: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
106: , a6 out nocopy JTF_VARCHAR2_TABLE_100
107: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 106: , a6 out nocopy JTF_VARCHAR2_TABLE_100

102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400
105: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
106: , a6 out nocopy JTF_VARCHAR2_TABLE_100
107: , a7 out nocopy JTF_VARCHAR2_TABLE_500
108: , a8 out nocopy JTF_VARCHAR2_TABLE_500
109: , a9 out nocopy JTF_VARCHAR2_TABLE_500
110: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 209: , p5_a3 JTF_VARCHAR2_TABLE_100

205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400
211: , p5_a5 JTF_VARCHAR2_TABLE_2000
212: , p5_a6 JTF_VARCHAR2_TABLE_100
213: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 212: , p5_a6 JTF_VARCHAR2_TABLE_100

208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400
211: , p5_a5 JTF_VARCHAR2_TABLE_2000
212: , p5_a6 JTF_VARCHAR2_TABLE_100
213: , p5_a7 JTF_VARCHAR2_TABLE_500
214: , p5_a8 JTF_VARCHAR2_TABLE_500
215: , p5_a9 JTF_VARCHAR2_TABLE_500
216: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
243: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 243: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
243: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
247: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: );
276: procedure insert_row(p_api_version NUMBER
277: , p_init_msg_list VARCHAR2

Line 274: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: );
276: procedure insert_row(p_api_version NUMBER
277: , p_init_msg_list VARCHAR2
278: , x_return_status out nocopy VARCHAR2

Line 284: , p5_a3 JTF_VARCHAR2_TABLE_100

280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 287: , p5_a6 JTF_VARCHAR2_TABLE_100

283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_VARCHAR2_TABLE_500
289: , p5_a8 JTF_VARCHAR2_TABLE_500
290: , p5_a9 JTF_VARCHAR2_TABLE_500
291: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
320: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
321: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
322: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 389: , p5_a3 JTF_VARCHAR2_TABLE_100

385: , x_msg_data out nocopy VARCHAR2
386: , p5_a0 JTF_NUMBER_TABLE
387: , p5_a1 JTF_NUMBER_TABLE
388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400
391: , p5_a5 JTF_VARCHAR2_TABLE_2000
392: , p5_a6 JTF_VARCHAR2_TABLE_100
393: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 392: , p5_a6 JTF_VARCHAR2_TABLE_100

388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400
391: , p5_a5 JTF_VARCHAR2_TABLE_2000
392: , p5_a6 JTF_VARCHAR2_TABLE_100
393: , p5_a7 JTF_VARCHAR2_TABLE_500
394: , p5_a8 JTF_VARCHAR2_TABLE_500
395: , p5_a9 JTF_VARCHAR2_TABLE_500
396: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
424: );
425: procedure lock_row(p_api_version NUMBER
426: , p_init_msg_list VARCHAR2

Line 423: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
424: );
425: procedure lock_row(p_api_version NUMBER
426: , p_init_msg_list VARCHAR2
427: , x_return_status out nocopy VARCHAR2

Line 433: , p5_a3 JTF_VARCHAR2_TABLE_100

429: , x_msg_data out nocopy VARCHAR2
430: , p5_a0 JTF_NUMBER_TABLE
431: , p5_a1 JTF_NUMBER_TABLE
432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400
435: , p5_a5 JTF_VARCHAR2_TABLE_2000
436: , p5_a6 JTF_VARCHAR2_TABLE_100
437: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 436: , p5_a6 JTF_VARCHAR2_TABLE_100

432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400
435: , p5_a5 JTF_VARCHAR2_TABLE_2000
436: , p5_a6 JTF_VARCHAR2_TABLE_100
437: , p5_a7 JTF_VARCHAR2_TABLE_500
438: , p5_a8 JTF_VARCHAR2_TABLE_500
439: , p5_a9 JTF_VARCHAR2_TABLE_500
440: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 538: , p5_a3 JTF_VARCHAR2_TABLE_100

534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 JTF_NUMBER_TABLE
536: , p5_a1 JTF_NUMBER_TABLE
537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400
540: , p5_a5 JTF_VARCHAR2_TABLE_2000
541: , p5_a6 JTF_VARCHAR2_TABLE_100
542: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 541: , p5_a6 JTF_VARCHAR2_TABLE_100

537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400
540: , p5_a5 JTF_VARCHAR2_TABLE_2000
541: , p5_a6 JTF_VARCHAR2_TABLE_100
542: , p5_a7 JTF_VARCHAR2_TABLE_500
543: , p5_a8 JTF_VARCHAR2_TABLE_500
544: , p5_a9 JTF_VARCHAR2_TABLE_500
545: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
571: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
572: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
573: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 572: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
571: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
572: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
573: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
574: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
575: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
576: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
604: );
605: procedure update_row(p_api_version NUMBER
606: , p_init_msg_list VARCHAR2

Line 603: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
604: );
605: procedure update_row(p_api_version NUMBER
606: , p_init_msg_list VARCHAR2
607: , x_return_status out nocopy VARCHAR2

Line 613: , p5_a3 JTF_VARCHAR2_TABLE_100

609: , x_msg_data out nocopy VARCHAR2
610: , p5_a0 JTF_NUMBER_TABLE
611: , p5_a1 JTF_NUMBER_TABLE
612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400
615: , p5_a5 JTF_VARCHAR2_TABLE_2000
616: , p5_a6 JTF_VARCHAR2_TABLE_100
617: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 616: , p5_a6 JTF_VARCHAR2_TABLE_100

612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400
615: , p5_a5 JTF_VARCHAR2_TABLE_2000
616: , p5_a6 JTF_VARCHAR2_TABLE_100
617: , p5_a7 JTF_VARCHAR2_TABLE_500
618: , p5_a8 JTF_VARCHAR2_TABLE_500
619: , p5_a9 JTF_VARCHAR2_TABLE_500
620: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
646: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
647: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
648: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 647: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
646: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
647: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
648: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
649: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
650: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
651: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 718: , p5_a3 JTF_VARCHAR2_TABLE_100

714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400
720: , p5_a5 JTF_VARCHAR2_TABLE_2000
721: , p5_a6 JTF_VARCHAR2_TABLE_100
722: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 721: , p5_a6 JTF_VARCHAR2_TABLE_100

717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400
720: , p5_a5 JTF_VARCHAR2_TABLE_2000
721: , p5_a6 JTF_VARCHAR2_TABLE_100
722: , p5_a7 JTF_VARCHAR2_TABLE_500
723: , p5_a8 JTF_VARCHAR2_TABLE_500
724: , p5_a9 JTF_VARCHAR2_TABLE_500
725: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
753: );
754: procedure delete_row(p_api_version NUMBER
755: , p_init_msg_list VARCHAR2

Line 752: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
753: );
754: procedure delete_row(p_api_version NUMBER
755: , p_init_msg_list VARCHAR2
756: , x_return_status out nocopy VARCHAR2

Line 762: , p5_a3 JTF_VARCHAR2_TABLE_100

758: , x_msg_data out nocopy VARCHAR2
759: , p5_a0 JTF_NUMBER_TABLE
760: , p5_a1 JTF_NUMBER_TABLE
761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400
764: , p5_a5 JTF_VARCHAR2_TABLE_2000
765: , p5_a6 JTF_VARCHAR2_TABLE_100
766: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 765: , p5_a6 JTF_VARCHAR2_TABLE_100

761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400
764: , p5_a5 JTF_VARCHAR2_TABLE_2000
765: , p5_a6 JTF_VARCHAR2_TABLE_100
766: , p5_a7 JTF_VARCHAR2_TABLE_500
767: , p5_a8 JTF_VARCHAR2_TABLE_500
768: , p5_a9 JTF_VARCHAR2_TABLE_500
769: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 836: , p5_a3 JTF_VARCHAR2_TABLE_100

832: , x_msg_data out nocopy VARCHAR2
833: , p5_a0 JTF_NUMBER_TABLE
834: , p5_a1 JTF_NUMBER_TABLE
835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400
838: , p5_a5 JTF_VARCHAR2_TABLE_2000
839: , p5_a6 JTF_VARCHAR2_TABLE_100
840: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 839: , p5_a6 JTF_VARCHAR2_TABLE_100

835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400
838: , p5_a5 JTF_VARCHAR2_TABLE_2000
839: , p5_a6 JTF_VARCHAR2_TABLE_100
840: , p5_a7 JTF_VARCHAR2_TABLE_500
841: , p5_a8 JTF_VARCHAR2_TABLE_500
842: , p5_a9 JTF_VARCHAR2_TABLE_500
843: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
871: );
872: procedure validate_row(p_api_version NUMBER
873: , p_init_msg_list VARCHAR2

Line 870: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
871: );
872: procedure validate_row(p_api_version NUMBER
873: , p_init_msg_list VARCHAR2
874: , x_return_status out nocopy VARCHAR2

Line 880: , p5_a3 JTF_VARCHAR2_TABLE_100

876: , x_msg_data out nocopy VARCHAR2
877: , p5_a0 JTF_NUMBER_TABLE
878: , p5_a1 JTF_NUMBER_TABLE
879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400
882: , p5_a5 JTF_VARCHAR2_TABLE_2000
883: , p5_a6 JTF_VARCHAR2_TABLE_100
884: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 883: , p5_a6 JTF_VARCHAR2_TABLE_100

879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400
882: , p5_a5 JTF_VARCHAR2_TABLE_2000
883: , p5_a6 JTF_VARCHAR2_TABLE_100
884: , p5_a7 JTF_VARCHAR2_TABLE_500
885: , p5_a8 JTF_VARCHAR2_TABLE_500
886: , p5_a9 JTF_VARCHAR2_TABLE_500
887: , p5_a10 JTF_VARCHAR2_TABLE_500