APPS.OKL_VCR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500

Line 45: , a4 out nocopy JTF_VARCHAR2_TABLE_100

41: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_VARCHAR2_TABLE_100
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_DATE_TABLE
48: , a7 out nocopy JTF_DATE_TABLE
49: , a8 out nocopy JTF_DATE_TABLE

Line 46: , a5 out nocopy JTF_VARCHAR2_TABLE_100

42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_VARCHAR2_TABLE_100
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_DATE_TABLE
48: , a7 out nocopy JTF_DATE_TABLE
49: , a8 out nocopy JTF_DATE_TABLE
50: , a9 out nocopy JTF_DATE_TABLE

Line 53: , a12 out nocopy JTF_VARCHAR2_TABLE_100

49: , a8 out nocopy JTF_DATE_TABLE
50: , a9 out nocopy JTF_DATE_TABLE
51: , a10 out nocopy JTF_DATE_TABLE
52: , a11 out nocopy JTF_DATE_TABLE
53: , a12 out nocopy JTF_VARCHAR2_TABLE_100
54: , a13 out nocopy JTF_VARCHAR2_TABLE_500
55: , a14 out nocopy JTF_VARCHAR2_TABLE_500
56: , a15 out nocopy JTF_VARCHAR2_TABLE_500
57: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 84: , a4 JTF_VARCHAR2_TABLE_100

80: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_NUMBER_TABLE
83: , a3 JTF_NUMBER_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_100
86: , a6 JTF_DATE_TABLE
87: , a7 JTF_DATE_TABLE
88: , a8 JTF_DATE_TABLE

Line 85: , a5 JTF_VARCHAR2_TABLE_100

81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_NUMBER_TABLE
83: , a3 JTF_NUMBER_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_100
86: , a6 JTF_DATE_TABLE
87: , a7 JTF_DATE_TABLE
88: , a8 JTF_DATE_TABLE
89: , a9 JTF_DATE_TABLE

Line 92: , a12 JTF_VARCHAR2_TABLE_100

88: , a8 JTF_DATE_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_DATE_TABLE
91: , a11 JTF_DATE_TABLE
92: , a12 JTF_VARCHAR2_TABLE_100
93: , a13 JTF_VARCHAR2_TABLE_500
94: , a14 JTF_VARCHAR2_TABLE_500
95: , a15 JTF_VARCHAR2_TABLE_500
96: , a16 JTF_VARCHAR2_TABLE_500

Line 122: , a4 out nocopy JTF_VARCHAR2_TABLE_100

118: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , a6 out nocopy JTF_DATE_TABLE
125: , a7 out nocopy JTF_DATE_TABLE
126: , a8 out nocopy JTF_DATE_TABLE

Line 123: , a5 out nocopy JTF_VARCHAR2_TABLE_100

119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , a6 out nocopy JTF_DATE_TABLE
125: , a7 out nocopy JTF_DATE_TABLE
126: , a8 out nocopy JTF_DATE_TABLE
127: , a9 out nocopy JTF_DATE_TABLE

Line 130: , a12 out nocopy JTF_VARCHAR2_TABLE_100

126: , a8 out nocopy JTF_DATE_TABLE
127: , a9 out nocopy JTF_DATE_TABLE
128: , a10 out nocopy JTF_DATE_TABLE
129: , a11 out nocopy JTF_DATE_TABLE
130: , a12 out nocopy JTF_VARCHAR2_TABLE_100
131: , a13 out nocopy JTF_VARCHAR2_TABLE_500
132: , a14 out nocopy JTF_VARCHAR2_TABLE_500
133: , a15 out nocopy JTF_VARCHAR2_TABLE_500
134: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 246: , p5_a4 JTF_VARCHAR2_TABLE_100

242: , p5_a0 JTF_NUMBER_TABLE
243: , p5_a1 JTF_NUMBER_TABLE
244: , p5_a2 JTF_NUMBER_TABLE
245: , p5_a3 JTF_NUMBER_TABLE
246: , p5_a4 JTF_VARCHAR2_TABLE_100
247: , p5_a5 JTF_VARCHAR2_TABLE_100
248: , p5_a6 JTF_DATE_TABLE
249: , p5_a7 JTF_DATE_TABLE
250: , p5_a8 JTF_DATE_TABLE

Line 247: , p5_a5 JTF_VARCHAR2_TABLE_100

243: , p5_a1 JTF_NUMBER_TABLE
244: , p5_a2 JTF_NUMBER_TABLE
245: , p5_a3 JTF_NUMBER_TABLE
246: , p5_a4 JTF_VARCHAR2_TABLE_100
247: , p5_a5 JTF_VARCHAR2_TABLE_100
248: , p5_a6 JTF_DATE_TABLE
249: , p5_a7 JTF_DATE_TABLE
250: , p5_a8 JTF_DATE_TABLE
251: , p5_a9 JTF_DATE_TABLE

Line 254: , p5_a12 JTF_VARCHAR2_TABLE_100

250: , p5_a8 JTF_DATE_TABLE
251: , p5_a9 JTF_DATE_TABLE
252: , p5_a10 JTF_DATE_TABLE
253: , p5_a11 JTF_DATE_TABLE
254: , p5_a12 JTF_VARCHAR2_TABLE_100
255: , p5_a13 JTF_VARCHAR2_TABLE_500
256: , p5_a14 JTF_VARCHAR2_TABLE_500
257: , p5_a15 JTF_VARCHAR2_TABLE_500
258: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 283: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_NUMBER_TABLE
282: , p6_a3 out nocopy JTF_NUMBER_TABLE
283: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a6 out nocopy JTF_DATE_TABLE
286: , p6_a7 out nocopy JTF_DATE_TABLE
287: , p6_a8 out nocopy JTF_DATE_TABLE

Line 284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_NUMBER_TABLE
282: , p6_a3 out nocopy JTF_NUMBER_TABLE
283: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a6 out nocopy JTF_DATE_TABLE
286: , p6_a7 out nocopy JTF_DATE_TABLE
287: , p6_a8 out nocopy JTF_DATE_TABLE
288: , p6_a9 out nocopy JTF_DATE_TABLE

Line 291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

287: , p6_a8 out nocopy JTF_DATE_TABLE
288: , p6_a9 out nocopy JTF_DATE_TABLE
289: , p6_a10 out nocopy JTF_DATE_TABLE
290: , p6_a11 out nocopy JTF_DATE_TABLE
291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
292: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
293: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
294: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
295: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

313: , p6_a34 out nocopy JTF_NUMBER_TABLE
314: , p6_a35 out nocopy JTF_DATE_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: , p7_a0 in out nocopy JTF_NUMBER_TABLE
317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a2 in out nocopy JTF_NUMBER_TABLE
319: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
320: , p7_a4 in out nocopy JTF_NUMBER_TABLE
321: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 321: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a2 in out nocopy JTF_NUMBER_TABLE
319: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
320: , p7_a4 in out nocopy JTF_NUMBER_TABLE
321: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
323: );
324: procedure insert_row(p_api_version NUMBER
325: , p_init_msg_list VARCHAR2

Line 322: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

318: , p7_a2 in out nocopy JTF_NUMBER_TABLE
319: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
320: , p7_a4 in out nocopy JTF_NUMBER_TABLE
321: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
323: );
324: procedure insert_row(p_api_version NUMBER
325: , p_init_msg_list VARCHAR2
326: , x_return_status out nocopy VARCHAR2

Line 333: , p5_a4 JTF_VARCHAR2_TABLE_100

329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_100
334: , p5_a5 JTF_VARCHAR2_TABLE_100
335: , p5_a6 JTF_DATE_TABLE
336: , p5_a7 JTF_DATE_TABLE
337: , p5_a8 JTF_DATE_TABLE

Line 334: , p5_a5 JTF_VARCHAR2_TABLE_100

330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_100
334: , p5_a5 JTF_VARCHAR2_TABLE_100
335: , p5_a6 JTF_DATE_TABLE
336: , p5_a7 JTF_DATE_TABLE
337: , p5_a8 JTF_DATE_TABLE
338: , p5_a9 JTF_DATE_TABLE

Line 341: , p5_a12 JTF_VARCHAR2_TABLE_100

337: , p5_a8 JTF_DATE_TABLE
338: , p5_a9 JTF_DATE_TABLE
339: , p5_a10 JTF_DATE_TABLE
340: , p5_a11 JTF_DATE_TABLE
341: , p5_a12 JTF_VARCHAR2_TABLE_100
342: , p5_a13 JTF_VARCHAR2_TABLE_500
343: , p5_a14 JTF_VARCHAR2_TABLE_500
344: , p5_a15 JTF_VARCHAR2_TABLE_500
345: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_NUMBER_TABLE
369: , p6_a3 out nocopy JTF_NUMBER_TABLE
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a6 out nocopy JTF_DATE_TABLE
373: , p6_a7 out nocopy JTF_DATE_TABLE
374: , p6_a8 out nocopy JTF_DATE_TABLE

Line 371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_NUMBER_TABLE
369: , p6_a3 out nocopy JTF_NUMBER_TABLE
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a6 out nocopy JTF_DATE_TABLE
373: , p6_a7 out nocopy JTF_DATE_TABLE
374: , p6_a8 out nocopy JTF_DATE_TABLE
375: , p6_a9 out nocopy JTF_DATE_TABLE

Line 378: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

374: , p6_a8 out nocopy JTF_DATE_TABLE
375: , p6_a9 out nocopy JTF_DATE_TABLE
376: , p6_a10 out nocopy JTF_DATE_TABLE
377: , p6_a11 out nocopy JTF_DATE_TABLE
378: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
380: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
381: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
382: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 456: , p5_a4 JTF_VARCHAR2_TABLE_100

452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_NUMBER_TABLE
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_VARCHAR2_TABLE_100
458: , p5_a6 JTF_DATE_TABLE
459: , p5_a7 JTF_DATE_TABLE
460: , p5_a8 JTF_DATE_TABLE

Line 457: , p5_a5 JTF_VARCHAR2_TABLE_100

453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_NUMBER_TABLE
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_VARCHAR2_TABLE_100
458: , p5_a6 JTF_DATE_TABLE
459: , p5_a7 JTF_DATE_TABLE
460: , p5_a8 JTF_DATE_TABLE
461: , p5_a9 JTF_DATE_TABLE

Line 464: , p5_a12 JTF_VARCHAR2_TABLE_100

460: , p5_a8 JTF_DATE_TABLE
461: , p5_a9 JTF_DATE_TABLE
462: , p5_a10 JTF_DATE_TABLE
463: , p5_a11 JTF_DATE_TABLE
464: , p5_a12 JTF_VARCHAR2_TABLE_100
465: , p5_a13 JTF_VARCHAR2_TABLE_500
466: , p5_a14 JTF_VARCHAR2_TABLE_500
467: , p5_a15 JTF_VARCHAR2_TABLE_500
468: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

486: , p5_a34 JTF_NUMBER_TABLE
487: , p5_a35 JTF_DATE_TABLE
488: , p5_a36 JTF_NUMBER_TABLE
489: , p6_a0 in out nocopy JTF_NUMBER_TABLE
490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a2 in out nocopy JTF_NUMBER_TABLE
492: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
493: , p6_a4 in out nocopy JTF_NUMBER_TABLE
494: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 494: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a2 in out nocopy JTF_NUMBER_TABLE
492: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
493: , p6_a4 in out nocopy JTF_NUMBER_TABLE
494: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
495: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
496: );
497: procedure lock_row(p_api_version NUMBER
498: , p_init_msg_list VARCHAR2

Line 495: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

491: , p6_a2 in out nocopy JTF_NUMBER_TABLE
492: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
493: , p6_a4 in out nocopy JTF_NUMBER_TABLE
494: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
495: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
496: );
497: procedure lock_row(p_api_version NUMBER
498: , p_init_msg_list VARCHAR2
499: , x_return_status out nocopy VARCHAR2

Line 506: , p5_a4 JTF_VARCHAR2_TABLE_100

502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_NUMBER_TABLE
505: , p5_a3 JTF_NUMBER_TABLE
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , p5_a6 JTF_DATE_TABLE
509: , p5_a7 JTF_DATE_TABLE
510: , p5_a8 JTF_DATE_TABLE

Line 507: , p5_a5 JTF_VARCHAR2_TABLE_100

503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_NUMBER_TABLE
505: , p5_a3 JTF_NUMBER_TABLE
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , p5_a6 JTF_DATE_TABLE
509: , p5_a7 JTF_DATE_TABLE
510: , p5_a8 JTF_DATE_TABLE
511: , p5_a9 JTF_DATE_TABLE

Line 514: , p5_a12 JTF_VARCHAR2_TABLE_100

510: , p5_a8 JTF_DATE_TABLE
511: , p5_a9 JTF_DATE_TABLE
512: , p5_a10 JTF_DATE_TABLE
513: , p5_a11 JTF_DATE_TABLE
514: , p5_a12 JTF_VARCHAR2_TABLE_100
515: , p5_a13 JTF_VARCHAR2_TABLE_500
516: , p5_a14 JTF_VARCHAR2_TABLE_500
517: , p5_a15 JTF_VARCHAR2_TABLE_500
518: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 629: , p5_a4 JTF_VARCHAR2_TABLE_100

625: , p5_a0 JTF_NUMBER_TABLE
626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_NUMBER_TABLE
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_VARCHAR2_TABLE_100
630: , p5_a5 JTF_VARCHAR2_TABLE_100
631: , p5_a6 JTF_DATE_TABLE
632: , p5_a7 JTF_DATE_TABLE
633: , p5_a8 JTF_DATE_TABLE

Line 630: , p5_a5 JTF_VARCHAR2_TABLE_100

626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_NUMBER_TABLE
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_VARCHAR2_TABLE_100
630: , p5_a5 JTF_VARCHAR2_TABLE_100
631: , p5_a6 JTF_DATE_TABLE
632: , p5_a7 JTF_DATE_TABLE
633: , p5_a8 JTF_DATE_TABLE
634: , p5_a9 JTF_DATE_TABLE

Line 637: , p5_a12 JTF_VARCHAR2_TABLE_100

633: , p5_a8 JTF_DATE_TABLE
634: , p5_a9 JTF_DATE_TABLE
635: , p5_a10 JTF_DATE_TABLE
636: , p5_a11 JTF_DATE_TABLE
637: , p5_a12 JTF_VARCHAR2_TABLE_100
638: , p5_a13 JTF_VARCHAR2_TABLE_500
639: , p5_a14 JTF_VARCHAR2_TABLE_500
640: , p5_a15 JTF_VARCHAR2_TABLE_500
641: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 666: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

662: , p6_a0 out nocopy JTF_NUMBER_TABLE
663: , p6_a1 out nocopy JTF_NUMBER_TABLE
664: , p6_a2 out nocopy JTF_NUMBER_TABLE
665: , p6_a3 out nocopy JTF_NUMBER_TABLE
666: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
668: , p6_a6 out nocopy JTF_DATE_TABLE
669: , p6_a7 out nocopy JTF_DATE_TABLE
670: , p6_a8 out nocopy JTF_DATE_TABLE

Line 667: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

663: , p6_a1 out nocopy JTF_NUMBER_TABLE
664: , p6_a2 out nocopy JTF_NUMBER_TABLE
665: , p6_a3 out nocopy JTF_NUMBER_TABLE
666: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
668: , p6_a6 out nocopy JTF_DATE_TABLE
669: , p6_a7 out nocopy JTF_DATE_TABLE
670: , p6_a8 out nocopy JTF_DATE_TABLE
671: , p6_a9 out nocopy JTF_DATE_TABLE

Line 674: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

670: , p6_a8 out nocopy JTF_DATE_TABLE
671: , p6_a9 out nocopy JTF_DATE_TABLE
672: , p6_a10 out nocopy JTF_DATE_TABLE
673: , p6_a11 out nocopy JTF_DATE_TABLE
674: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
675: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
676: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
677: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
678: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

696: , p6_a34 out nocopy JTF_NUMBER_TABLE
697: , p6_a35 out nocopy JTF_DATE_TABLE
698: , p6_a36 out nocopy JTF_NUMBER_TABLE
699: , p7_a0 in out nocopy JTF_NUMBER_TABLE
700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p7_a2 in out nocopy JTF_NUMBER_TABLE
702: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
703: , p7_a4 in out nocopy JTF_NUMBER_TABLE
704: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 704: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p7_a2 in out nocopy JTF_NUMBER_TABLE
702: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
703: , p7_a4 in out nocopy JTF_NUMBER_TABLE
704: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
706: );
707: procedure update_row(p_api_version NUMBER
708: , p_init_msg_list VARCHAR2

Line 705: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

701: , p7_a2 in out nocopy JTF_NUMBER_TABLE
702: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
703: , p7_a4 in out nocopy JTF_NUMBER_TABLE
704: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
706: );
707: procedure update_row(p_api_version NUMBER
708: , p_init_msg_list VARCHAR2
709: , x_return_status out nocopy VARCHAR2

Line 716: , p5_a4 JTF_VARCHAR2_TABLE_100

712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_NUMBER_TABLE
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_NUMBER_TABLE
716: , p5_a4 JTF_VARCHAR2_TABLE_100
717: , p5_a5 JTF_VARCHAR2_TABLE_100
718: , p5_a6 JTF_DATE_TABLE
719: , p5_a7 JTF_DATE_TABLE
720: , p5_a8 JTF_DATE_TABLE

Line 717: , p5_a5 JTF_VARCHAR2_TABLE_100

713: , p5_a1 JTF_NUMBER_TABLE
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_NUMBER_TABLE
716: , p5_a4 JTF_VARCHAR2_TABLE_100
717: , p5_a5 JTF_VARCHAR2_TABLE_100
718: , p5_a6 JTF_DATE_TABLE
719: , p5_a7 JTF_DATE_TABLE
720: , p5_a8 JTF_DATE_TABLE
721: , p5_a9 JTF_DATE_TABLE

Line 724: , p5_a12 JTF_VARCHAR2_TABLE_100

720: , p5_a8 JTF_DATE_TABLE
721: , p5_a9 JTF_DATE_TABLE
722: , p5_a10 JTF_DATE_TABLE
723: , p5_a11 JTF_DATE_TABLE
724: , p5_a12 JTF_VARCHAR2_TABLE_100
725: , p5_a13 JTF_VARCHAR2_TABLE_500
726: , p5_a14 JTF_VARCHAR2_TABLE_500
727: , p5_a15 JTF_VARCHAR2_TABLE_500
728: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 753: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

749: , p6_a0 out nocopy JTF_NUMBER_TABLE
750: , p6_a1 out nocopy JTF_NUMBER_TABLE
751: , p6_a2 out nocopy JTF_NUMBER_TABLE
752: , p6_a3 out nocopy JTF_NUMBER_TABLE
753: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
754: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
755: , p6_a6 out nocopy JTF_DATE_TABLE
756: , p6_a7 out nocopy JTF_DATE_TABLE
757: , p6_a8 out nocopy JTF_DATE_TABLE

Line 754: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

750: , p6_a1 out nocopy JTF_NUMBER_TABLE
751: , p6_a2 out nocopy JTF_NUMBER_TABLE
752: , p6_a3 out nocopy JTF_NUMBER_TABLE
753: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
754: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
755: , p6_a6 out nocopy JTF_DATE_TABLE
756: , p6_a7 out nocopy JTF_DATE_TABLE
757: , p6_a8 out nocopy JTF_DATE_TABLE
758: , p6_a9 out nocopy JTF_DATE_TABLE

Line 761: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

757: , p6_a8 out nocopy JTF_DATE_TABLE
758: , p6_a9 out nocopy JTF_DATE_TABLE
759: , p6_a10 out nocopy JTF_DATE_TABLE
760: , p6_a11 out nocopy JTF_DATE_TABLE
761: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
763: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
764: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
765: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 839: , p5_a4 JTF_VARCHAR2_TABLE_100

835: , p5_a0 JTF_NUMBER_TABLE
836: , p5_a1 JTF_NUMBER_TABLE
837: , p5_a2 JTF_NUMBER_TABLE
838: , p5_a3 JTF_NUMBER_TABLE
839: , p5_a4 JTF_VARCHAR2_TABLE_100
840: , p5_a5 JTF_VARCHAR2_TABLE_100
841: , p5_a6 JTF_DATE_TABLE
842: , p5_a7 JTF_DATE_TABLE
843: , p5_a8 JTF_DATE_TABLE

Line 840: , p5_a5 JTF_VARCHAR2_TABLE_100

836: , p5_a1 JTF_NUMBER_TABLE
837: , p5_a2 JTF_NUMBER_TABLE
838: , p5_a3 JTF_NUMBER_TABLE
839: , p5_a4 JTF_VARCHAR2_TABLE_100
840: , p5_a5 JTF_VARCHAR2_TABLE_100
841: , p5_a6 JTF_DATE_TABLE
842: , p5_a7 JTF_DATE_TABLE
843: , p5_a8 JTF_DATE_TABLE
844: , p5_a9 JTF_DATE_TABLE

Line 847: , p5_a12 JTF_VARCHAR2_TABLE_100

843: , p5_a8 JTF_DATE_TABLE
844: , p5_a9 JTF_DATE_TABLE
845: , p5_a10 JTF_DATE_TABLE
846: , p5_a11 JTF_DATE_TABLE
847: , p5_a12 JTF_VARCHAR2_TABLE_100
848: , p5_a13 JTF_VARCHAR2_TABLE_500
849: , p5_a14 JTF_VARCHAR2_TABLE_500
850: , p5_a15 JTF_VARCHAR2_TABLE_500
851: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

869: , p5_a34 JTF_NUMBER_TABLE
870: , p5_a35 JTF_DATE_TABLE
871: , p5_a36 JTF_NUMBER_TABLE
872: , p6_a0 in out nocopy JTF_NUMBER_TABLE
873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a2 in out nocopy JTF_NUMBER_TABLE
875: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
876: , p6_a4 in out nocopy JTF_NUMBER_TABLE
877: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 877: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a2 in out nocopy JTF_NUMBER_TABLE
875: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
876: , p6_a4 in out nocopy JTF_NUMBER_TABLE
877: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
878: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
879: );
880: procedure delete_row(p_api_version NUMBER
881: , p_init_msg_list VARCHAR2

Line 878: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

874: , p6_a2 in out nocopy JTF_NUMBER_TABLE
875: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
876: , p6_a4 in out nocopy JTF_NUMBER_TABLE
877: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
878: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
879: );
880: procedure delete_row(p_api_version NUMBER
881: , p_init_msg_list VARCHAR2
882: , x_return_status out nocopy VARCHAR2

Line 889: , p5_a4 JTF_VARCHAR2_TABLE_100

885: , p5_a0 JTF_NUMBER_TABLE
886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_NUMBER_TABLE
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_VARCHAR2_TABLE_100
890: , p5_a5 JTF_VARCHAR2_TABLE_100
891: , p5_a6 JTF_DATE_TABLE
892: , p5_a7 JTF_DATE_TABLE
893: , p5_a8 JTF_DATE_TABLE

Line 890: , p5_a5 JTF_VARCHAR2_TABLE_100

886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_NUMBER_TABLE
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_VARCHAR2_TABLE_100
890: , p5_a5 JTF_VARCHAR2_TABLE_100
891: , p5_a6 JTF_DATE_TABLE
892: , p5_a7 JTF_DATE_TABLE
893: , p5_a8 JTF_DATE_TABLE
894: , p5_a9 JTF_DATE_TABLE

Line 897: , p5_a12 JTF_VARCHAR2_TABLE_100

893: , p5_a8 JTF_DATE_TABLE
894: , p5_a9 JTF_DATE_TABLE
895: , p5_a10 JTF_DATE_TABLE
896: , p5_a11 JTF_DATE_TABLE
897: , p5_a12 JTF_VARCHAR2_TABLE_100
898: , p5_a13 JTF_VARCHAR2_TABLE_500
899: , p5_a14 JTF_VARCHAR2_TABLE_500
900: , p5_a15 JTF_VARCHAR2_TABLE_500
901: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 975: , p5_a4 JTF_VARCHAR2_TABLE_100

971: , p5_a0 JTF_NUMBER_TABLE
972: , p5_a1 JTF_NUMBER_TABLE
973: , p5_a2 JTF_NUMBER_TABLE
974: , p5_a3 JTF_NUMBER_TABLE
975: , p5_a4 JTF_VARCHAR2_TABLE_100
976: , p5_a5 JTF_VARCHAR2_TABLE_100
977: , p5_a6 JTF_DATE_TABLE
978: , p5_a7 JTF_DATE_TABLE
979: , p5_a8 JTF_DATE_TABLE

Line 976: , p5_a5 JTF_VARCHAR2_TABLE_100

972: , p5_a1 JTF_NUMBER_TABLE
973: , p5_a2 JTF_NUMBER_TABLE
974: , p5_a3 JTF_NUMBER_TABLE
975: , p5_a4 JTF_VARCHAR2_TABLE_100
976: , p5_a5 JTF_VARCHAR2_TABLE_100
977: , p5_a6 JTF_DATE_TABLE
978: , p5_a7 JTF_DATE_TABLE
979: , p5_a8 JTF_DATE_TABLE
980: , p5_a9 JTF_DATE_TABLE

Line 983: , p5_a12 JTF_VARCHAR2_TABLE_100

979: , p5_a8 JTF_DATE_TABLE
980: , p5_a9 JTF_DATE_TABLE
981: , p5_a10 JTF_DATE_TABLE
982: , p5_a11 JTF_DATE_TABLE
983: , p5_a12 JTF_VARCHAR2_TABLE_100
984: , p5_a13 JTF_VARCHAR2_TABLE_500
985: , p5_a14 JTF_VARCHAR2_TABLE_500
986: , p5_a15 JTF_VARCHAR2_TABLE_500
987: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1005: , p5_a34 JTF_NUMBER_TABLE
1006: , p5_a35 JTF_DATE_TABLE
1007: , p5_a36 JTF_NUMBER_TABLE
1008: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1010: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1011: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1013: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1013: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1010: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1011: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1013: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1015: );
1016: procedure validate_row(p_api_version NUMBER
1017: , p_init_msg_list VARCHAR2

Line 1014: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1010: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1011: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1013: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1015: );
1016: procedure validate_row(p_api_version NUMBER
1017: , p_init_msg_list VARCHAR2
1018: , x_return_status out nocopy VARCHAR2

Line 1025: , p5_a4 JTF_VARCHAR2_TABLE_100

1021: , p5_a0 JTF_NUMBER_TABLE
1022: , p5_a1 JTF_NUMBER_TABLE
1023: , p5_a2 JTF_NUMBER_TABLE
1024: , p5_a3 JTF_NUMBER_TABLE
1025: , p5_a4 JTF_VARCHAR2_TABLE_100
1026: , p5_a5 JTF_VARCHAR2_TABLE_100
1027: , p5_a6 JTF_DATE_TABLE
1028: , p5_a7 JTF_DATE_TABLE
1029: , p5_a8 JTF_DATE_TABLE

Line 1026: , p5_a5 JTF_VARCHAR2_TABLE_100

1022: , p5_a1 JTF_NUMBER_TABLE
1023: , p5_a2 JTF_NUMBER_TABLE
1024: , p5_a3 JTF_NUMBER_TABLE
1025: , p5_a4 JTF_VARCHAR2_TABLE_100
1026: , p5_a5 JTF_VARCHAR2_TABLE_100
1027: , p5_a6 JTF_DATE_TABLE
1028: , p5_a7 JTF_DATE_TABLE
1029: , p5_a8 JTF_DATE_TABLE
1030: , p5_a9 JTF_DATE_TABLE

Line 1033: , p5_a12 JTF_VARCHAR2_TABLE_100

1029: , p5_a8 JTF_DATE_TABLE
1030: , p5_a9 JTF_DATE_TABLE
1031: , p5_a10 JTF_DATE_TABLE
1032: , p5_a11 JTF_DATE_TABLE
1033: , p5_a12 JTF_VARCHAR2_TABLE_100
1034: , p5_a13 JTF_VARCHAR2_TABLE_500
1035: , p5_a14 JTF_VARCHAR2_TABLE_500
1036: , p5_a15 JTF_VARCHAR2_TABLE_500
1037: , p5_a16 JTF_VARCHAR2_TABLE_500