APPS.OKL_RELOCATE_ASSETS_PUB_W dependencies on JTF_DATE_TABLE

Line 14: , p5_a6 JTF_DATE_TABLE

10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_VARCHAR2_TABLE_2000
16: , p5_a8 JTF_VARCHAR2_TABLE_300
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 38: , p5_a30 JTF_DATE_TABLE

34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_NUMBER_TABLE

Line 40: , p5_a32 JTF_DATE_TABLE

36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_NUMBER_TABLE
43: , p5_a35 JTF_DATE_TABLE
44: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 43: , p5_a35 JTF_DATE_TABLE

39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_NUMBER_TABLE
43: , p5_a35 JTF_DATE_TABLE
44: , p5_a36 JTF_VARCHAR2_TABLE_100
45: , p5_a37 JTF_VARCHAR2_TABLE_100
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_NUMBER_TABLE

Line 48: , p5_a40 JTF_DATE_TABLE

44: , p5_a36 JTF_VARCHAR2_TABLE_100
45: , p5_a37 JTF_VARCHAR2_TABLE_100
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_NUMBER_TABLE
48: , p5_a40 JTF_DATE_TABLE
49: , p6_a0 out nocopy JTF_NUMBER_TABLE
50: , p6_a1 out nocopy JTF_NUMBER_TABLE
51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 55: , p6_a6 out nocopy JTF_DATE_TABLE

51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , p6_a3 out nocopy JTF_NUMBER_TABLE
53: , p6_a4 out nocopy JTF_NUMBER_TABLE
54: , p6_a5 out nocopy JTF_NUMBER_TABLE
55: , p6_a6 out nocopy JTF_DATE_TABLE
56: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
57: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
58: , p6_a9 out nocopy JTF_NUMBER_TABLE
59: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 79: , p6_a30 out nocopy JTF_DATE_TABLE

75: , p6_a26 out nocopy JTF_NUMBER_TABLE
76: , p6_a27 out nocopy JTF_NUMBER_TABLE
77: , p6_a28 out nocopy JTF_NUMBER_TABLE
78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE
82: , p6_a33 out nocopy JTF_NUMBER_TABLE
83: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 81: , p6_a32 out nocopy JTF_DATE_TABLE

77: , p6_a28 out nocopy JTF_NUMBER_TABLE
78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE
82: , p6_a33 out nocopy JTF_NUMBER_TABLE
83: , p6_a34 out nocopy JTF_NUMBER_TABLE
84: , p6_a35 out nocopy JTF_DATE_TABLE
85: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: , p6_a35 out nocopy JTF_DATE_TABLE

80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE
82: , p6_a33 out nocopy JTF_NUMBER_TABLE
83: , p6_a34 out nocopy JTF_NUMBER_TABLE
84: , p6_a35 out nocopy JTF_DATE_TABLE
85: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 89: , p6_a40 out nocopy JTF_DATE_TABLE

85: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , p6_a39 out nocopy JTF_NUMBER_TABLE
89: , p6_a40 out nocopy JTF_DATE_TABLE
90: );
91: procedure insert_relocate_assets(p_api_version NUMBER
92: , p_init_msg_list VARCHAR2
93: , x_return_status out nocopy VARCHAR2

Line 190: , p5_a6 JTF_DATE_TABLE

186: , p5_a2 JTF_VARCHAR2_TABLE_100
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_NUMBER_TABLE
190: , p5_a6 JTF_DATE_TABLE
191: , p5_a7 JTF_VARCHAR2_TABLE_2000
192: , p5_a8 JTF_VARCHAR2_TABLE_300
193: , p5_a9 JTF_NUMBER_TABLE
194: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 214: , p5_a30 JTF_DATE_TABLE

210: , p5_a26 JTF_NUMBER_TABLE
211: , p5_a27 JTF_NUMBER_TABLE
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE
217: , p5_a33 JTF_NUMBER_TABLE
218: , p5_a34 JTF_NUMBER_TABLE

Line 216: , p5_a32 JTF_DATE_TABLE

212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE
217: , p5_a33 JTF_NUMBER_TABLE
218: , p5_a34 JTF_NUMBER_TABLE
219: , p5_a35 JTF_DATE_TABLE
220: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 219: , p5_a35 JTF_DATE_TABLE

215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE
217: , p5_a33 JTF_NUMBER_TABLE
218: , p5_a34 JTF_NUMBER_TABLE
219: , p5_a35 JTF_DATE_TABLE
220: , p5_a36 JTF_VARCHAR2_TABLE_100
221: , p5_a37 JTF_VARCHAR2_TABLE_100
222: , p5_a38 JTF_VARCHAR2_TABLE_100
223: , p5_a39 JTF_NUMBER_TABLE

Line 224: , p5_a40 JTF_DATE_TABLE

220: , p5_a36 JTF_VARCHAR2_TABLE_100
221: , p5_a37 JTF_VARCHAR2_TABLE_100
222: , p5_a38 JTF_VARCHAR2_TABLE_100
223: , p5_a39 JTF_NUMBER_TABLE
224: , p5_a40 JTF_DATE_TABLE
225: );
226: procedure lock_relocate_assets(p_api_version NUMBER
227: , p_init_msg_list VARCHAR2
228: , x_return_status out nocopy VARCHAR2

Line 284: , p5_a6 JTF_DATE_TABLE

280: , p5_a2 JTF_VARCHAR2_TABLE_100
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_DATE_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_2000
286: , p5_a8 JTF_VARCHAR2_TABLE_300
287: , p5_a9 JTF_NUMBER_TABLE
288: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 308: , p5_a30 JTF_DATE_TABLE

304: , p5_a26 JTF_NUMBER_TABLE
305: , p5_a27 JTF_NUMBER_TABLE
306: , p5_a28 JTF_NUMBER_TABLE
307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE
311: , p5_a33 JTF_NUMBER_TABLE
312: , p5_a34 JTF_NUMBER_TABLE

Line 310: , p5_a32 JTF_DATE_TABLE

306: , p5_a28 JTF_NUMBER_TABLE
307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE
311: , p5_a33 JTF_NUMBER_TABLE
312: , p5_a34 JTF_NUMBER_TABLE
313: , p5_a35 JTF_DATE_TABLE
314: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 313: , p5_a35 JTF_DATE_TABLE

309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE
311: , p5_a33 JTF_NUMBER_TABLE
312: , p5_a34 JTF_NUMBER_TABLE
313: , p5_a35 JTF_DATE_TABLE
314: , p5_a36 JTF_VARCHAR2_TABLE_100
315: , p5_a37 JTF_VARCHAR2_TABLE_100
316: , p5_a38 JTF_VARCHAR2_TABLE_100
317: , p5_a39 JTF_NUMBER_TABLE

Line 318: , p5_a40 JTF_DATE_TABLE

314: , p5_a36 JTF_VARCHAR2_TABLE_100
315: , p5_a37 JTF_VARCHAR2_TABLE_100
316: , p5_a38 JTF_VARCHAR2_TABLE_100
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 325: , p6_a6 out nocopy JTF_DATE_TABLE

321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_NUMBER_TABLE
325: , p6_a6 out nocopy JTF_DATE_TABLE
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
327: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
328: , p6_a9 out nocopy JTF_NUMBER_TABLE
329: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 349: , p6_a30 out nocopy JTF_DATE_TABLE

345: , p6_a26 out nocopy JTF_NUMBER_TABLE
346: , p6_a27 out nocopy JTF_NUMBER_TABLE
347: , p6_a28 out nocopy JTF_NUMBER_TABLE
348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE
352: , p6_a33 out nocopy JTF_NUMBER_TABLE
353: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 351: , p6_a32 out nocopy JTF_DATE_TABLE

347: , p6_a28 out nocopy JTF_NUMBER_TABLE
348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE
352: , p6_a33 out nocopy JTF_NUMBER_TABLE
353: , p6_a34 out nocopy JTF_NUMBER_TABLE
354: , p6_a35 out nocopy JTF_DATE_TABLE
355: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 354: , p6_a35 out nocopy JTF_DATE_TABLE

350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE
352: , p6_a33 out nocopy JTF_NUMBER_TABLE
353: , p6_a34 out nocopy JTF_NUMBER_TABLE
354: , p6_a35 out nocopy JTF_DATE_TABLE
355: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
358: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 359: , p6_a40 out nocopy JTF_DATE_TABLE

355: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
358: , p6_a39 out nocopy JTF_NUMBER_TABLE
359: , p6_a40 out nocopy JTF_DATE_TABLE
360: );
361: procedure update_relocate_assets(p_api_version NUMBER
362: , p_init_msg_list VARCHAR2
363: , x_return_status out nocopy VARCHAR2

Line 460: , p5_a6 JTF_DATE_TABLE

456: , p5_a2 JTF_VARCHAR2_TABLE_100
457: , p5_a3 JTF_NUMBER_TABLE
458: , p5_a4 JTF_NUMBER_TABLE
459: , p5_a5 JTF_NUMBER_TABLE
460: , p5_a6 JTF_DATE_TABLE
461: , p5_a7 JTF_VARCHAR2_TABLE_2000
462: , p5_a8 JTF_VARCHAR2_TABLE_300
463: , p5_a9 JTF_NUMBER_TABLE
464: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 484: , p5_a30 JTF_DATE_TABLE

480: , p5_a26 JTF_NUMBER_TABLE
481: , p5_a27 JTF_NUMBER_TABLE
482: , p5_a28 JTF_NUMBER_TABLE
483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE
487: , p5_a33 JTF_NUMBER_TABLE
488: , p5_a34 JTF_NUMBER_TABLE

Line 486: , p5_a32 JTF_DATE_TABLE

482: , p5_a28 JTF_NUMBER_TABLE
483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE
487: , p5_a33 JTF_NUMBER_TABLE
488: , p5_a34 JTF_NUMBER_TABLE
489: , p5_a35 JTF_DATE_TABLE
490: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 489: , p5_a35 JTF_DATE_TABLE

485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE
487: , p5_a33 JTF_NUMBER_TABLE
488: , p5_a34 JTF_NUMBER_TABLE
489: , p5_a35 JTF_DATE_TABLE
490: , p5_a36 JTF_VARCHAR2_TABLE_100
491: , p5_a37 JTF_VARCHAR2_TABLE_100
492: , p5_a38 JTF_VARCHAR2_TABLE_100
493: , p5_a39 JTF_NUMBER_TABLE

Line 494: , p5_a40 JTF_DATE_TABLE

490: , p5_a36 JTF_VARCHAR2_TABLE_100
491: , p5_a37 JTF_VARCHAR2_TABLE_100
492: , p5_a38 JTF_VARCHAR2_TABLE_100
493: , p5_a39 JTF_NUMBER_TABLE
494: , p5_a40 JTF_DATE_TABLE
495: );
496: procedure delete_relocate_assets(p_api_version NUMBER
497: , p_init_msg_list VARCHAR2
498: , x_return_status out nocopy VARCHAR2

Line 554: , p5_a6 JTF_DATE_TABLE

550: , p5_a2 JTF_VARCHAR2_TABLE_100
551: , p5_a3 JTF_NUMBER_TABLE
552: , p5_a4 JTF_NUMBER_TABLE
553: , p5_a5 JTF_NUMBER_TABLE
554: , p5_a6 JTF_DATE_TABLE
555: , p5_a7 JTF_VARCHAR2_TABLE_2000
556: , p5_a8 JTF_VARCHAR2_TABLE_300
557: , p5_a9 JTF_NUMBER_TABLE
558: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 578: , p5_a30 JTF_DATE_TABLE

574: , p5_a26 JTF_NUMBER_TABLE
575: , p5_a27 JTF_NUMBER_TABLE
576: , p5_a28 JTF_NUMBER_TABLE
577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE
581: , p5_a33 JTF_NUMBER_TABLE
582: , p5_a34 JTF_NUMBER_TABLE

Line 580: , p5_a32 JTF_DATE_TABLE

576: , p5_a28 JTF_NUMBER_TABLE
577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE
581: , p5_a33 JTF_NUMBER_TABLE
582: , p5_a34 JTF_NUMBER_TABLE
583: , p5_a35 JTF_DATE_TABLE
584: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 583: , p5_a35 JTF_DATE_TABLE

579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE
581: , p5_a33 JTF_NUMBER_TABLE
582: , p5_a34 JTF_NUMBER_TABLE
583: , p5_a35 JTF_DATE_TABLE
584: , p5_a36 JTF_VARCHAR2_TABLE_100
585: , p5_a37 JTF_VARCHAR2_TABLE_100
586: , p5_a38 JTF_VARCHAR2_TABLE_100
587: , p5_a39 JTF_NUMBER_TABLE

Line 588: , p5_a40 JTF_DATE_TABLE

584: , p5_a36 JTF_VARCHAR2_TABLE_100
585: , p5_a37 JTF_VARCHAR2_TABLE_100
586: , p5_a38 JTF_VARCHAR2_TABLE_100
587: , p5_a39 JTF_NUMBER_TABLE
588: , p5_a40 JTF_DATE_TABLE
589: );
590: procedure validate_relocate_assets(p_api_version NUMBER
591: , p_init_msg_list VARCHAR2
592: , x_return_status out nocopy VARCHAR2