DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT_W dependencies on JTF_DATE_TABLE

Line 11: , a8 JTF_DATE_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE

Line 13: , a10 JTF_DATE_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_300

Line 27: , a24 JTF_DATE_TABLE

23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE

Line 30: , a27 JTF_DATE_TABLE

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE

Line 33: , a30 JTF_DATE_TABLE

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE

Line 36: , a33 JTF_DATE_TABLE

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE

Line 69: , a8 out nocopy JTF_DATE_TABLE

65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_DATE_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_DATE_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE

Line 71: , a10 out nocopy JTF_DATE_TABLE

67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_DATE_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_DATE_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 85: , a24 out nocopy JTF_DATE_TABLE

81: , a20 out nocopy JTF_VARCHAR2_TABLE_100
82: , a21 out nocopy JTF_VARCHAR2_TABLE_100
83: , a22 out nocopy JTF_NUMBER_TABLE
84: , a23 out nocopy JTF_NUMBER_TABLE
85: , a24 out nocopy JTF_DATE_TABLE
86: , a25 out nocopy JTF_NUMBER_TABLE
87: , a26 out nocopy JTF_NUMBER_TABLE
88: , a27 out nocopy JTF_DATE_TABLE
89: , a28 out nocopy JTF_NUMBER_TABLE

Line 88: , a27 out nocopy JTF_DATE_TABLE

84: , a23 out nocopy JTF_NUMBER_TABLE
85: , a24 out nocopy JTF_DATE_TABLE
86: , a25 out nocopy JTF_NUMBER_TABLE
87: , a26 out nocopy JTF_NUMBER_TABLE
88: , a27 out nocopy JTF_DATE_TABLE
89: , a28 out nocopy JTF_NUMBER_TABLE
90: , a29 out nocopy JTF_NUMBER_TABLE
91: , a30 out nocopy JTF_DATE_TABLE
92: , a31 out nocopy JTF_NUMBER_TABLE

Line 91: , a30 out nocopy JTF_DATE_TABLE

87: , a26 out nocopy JTF_NUMBER_TABLE
88: , a27 out nocopy JTF_DATE_TABLE
89: , a28 out nocopy JTF_NUMBER_TABLE
90: , a29 out nocopy JTF_NUMBER_TABLE
91: , a30 out nocopy JTF_DATE_TABLE
92: , a31 out nocopy JTF_NUMBER_TABLE
93: , a32 out nocopy JTF_NUMBER_TABLE
94: , a33 out nocopy JTF_DATE_TABLE
95: , a34 out nocopy JTF_NUMBER_TABLE

Line 94: , a33 out nocopy JTF_DATE_TABLE

90: , a29 out nocopy JTF_NUMBER_TABLE
91: , a30 out nocopy JTF_DATE_TABLE
92: , a31 out nocopy JTF_NUMBER_TABLE
93: , a32 out nocopy JTF_NUMBER_TABLE
94: , a33 out nocopy JTF_DATE_TABLE
95: , a34 out nocopy JTF_NUMBER_TABLE
96: , a35 out nocopy JTF_NUMBER_TABLE
97: , a36 out nocopy JTF_NUMBER_TABLE
98: , a37 out nocopy JTF_NUMBER_TABLE

Line 135: , a15 JTF_DATE_TABLE

131: , a11 JTF_NUMBER_TABLE
132: , a12 JTF_VARCHAR2_TABLE_100
133: , a13 JTF_VARCHAR2_TABLE_100
134: , a14 JTF_VARCHAR2_TABLE_100
135: , a15 JTF_DATE_TABLE
136: , a16 JTF_NUMBER_TABLE
137: , a17 JTF_NUMBER_TABLE
138: , a18 JTF_DATE_TABLE
139: , a19 JTF_NUMBER_TABLE

Line 138: , a18 JTF_DATE_TABLE

134: , a14 JTF_VARCHAR2_TABLE_100
135: , a15 JTF_DATE_TABLE
136: , a16 JTF_NUMBER_TABLE
137: , a17 JTF_NUMBER_TABLE
138: , a18 JTF_DATE_TABLE
139: , a19 JTF_NUMBER_TABLE
140: , a20 JTF_NUMBER_TABLE
141: , a21 JTF_DATE_TABLE
142: , a22 JTF_NUMBER_TABLE

Line 141: , a21 JTF_DATE_TABLE

137: , a17 JTF_NUMBER_TABLE
138: , a18 JTF_DATE_TABLE
139: , a19 JTF_NUMBER_TABLE
140: , a20 JTF_NUMBER_TABLE
141: , a21 JTF_DATE_TABLE
142: , a22 JTF_NUMBER_TABLE
143: , a23 JTF_NUMBER_TABLE
144: , a24 JTF_DATE_TABLE
145: , a25 JTF_NUMBER_TABLE

Line 144: , a24 JTF_DATE_TABLE

140: , a20 JTF_NUMBER_TABLE
141: , a21 JTF_DATE_TABLE
142: , a22 JTF_NUMBER_TABLE
143: , a23 JTF_NUMBER_TABLE
144: , a24 JTF_DATE_TABLE
145: , a25 JTF_NUMBER_TABLE
146: , a26 JTF_NUMBER_TABLE
147: , a27 JTF_NUMBER_TABLE
148: , a28 JTF_NUMBER_TABLE

Line 213: , a93 JTF_DATE_TABLE

209: , a89 JTF_VARCHAR2_TABLE_200
210: , a90 JTF_VARCHAR2_TABLE_200
211: , a91 JTF_VARCHAR2_TABLE_200
212: , a92 JTF_VARCHAR2_TABLE_200
213: , a93 JTF_DATE_TABLE
214: , a94 JTF_NUMBER_TABLE
215: , a95 JTF_DATE_TABLE
216: , a96 JTF_NUMBER_TABLE
217: , a97 JTF_NUMBER_TABLE

Line 215: , a95 JTF_DATE_TABLE

211: , a91 JTF_VARCHAR2_TABLE_200
212: , a92 JTF_VARCHAR2_TABLE_200
213: , a93 JTF_DATE_TABLE
214: , a94 JTF_NUMBER_TABLE
215: , a95 JTF_DATE_TABLE
216: , a96 JTF_NUMBER_TABLE
217: , a97 JTF_NUMBER_TABLE
218: , a98 JTF_VARCHAR2_TABLE_100
219: , a99 JTF_VARCHAR2_TABLE_100

Line 237: , a15 out nocopy JTF_DATE_TABLE

233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100
235: , a13 out nocopy JTF_VARCHAR2_TABLE_100
236: , a14 out nocopy JTF_VARCHAR2_TABLE_100
237: , a15 out nocopy JTF_DATE_TABLE
238: , a16 out nocopy JTF_NUMBER_TABLE
239: , a17 out nocopy JTF_NUMBER_TABLE
240: , a18 out nocopy JTF_DATE_TABLE
241: , a19 out nocopy JTF_NUMBER_TABLE

Line 240: , a18 out nocopy JTF_DATE_TABLE

236: , a14 out nocopy JTF_VARCHAR2_TABLE_100
237: , a15 out nocopy JTF_DATE_TABLE
238: , a16 out nocopy JTF_NUMBER_TABLE
239: , a17 out nocopy JTF_NUMBER_TABLE
240: , a18 out nocopy JTF_DATE_TABLE
241: , a19 out nocopy JTF_NUMBER_TABLE
242: , a20 out nocopy JTF_NUMBER_TABLE
243: , a21 out nocopy JTF_DATE_TABLE
244: , a22 out nocopy JTF_NUMBER_TABLE

Line 243: , a21 out nocopy JTF_DATE_TABLE

239: , a17 out nocopy JTF_NUMBER_TABLE
240: , a18 out nocopy JTF_DATE_TABLE
241: , a19 out nocopy JTF_NUMBER_TABLE
242: , a20 out nocopy JTF_NUMBER_TABLE
243: , a21 out nocopy JTF_DATE_TABLE
244: , a22 out nocopy JTF_NUMBER_TABLE
245: , a23 out nocopy JTF_NUMBER_TABLE
246: , a24 out nocopy JTF_DATE_TABLE
247: , a25 out nocopy JTF_NUMBER_TABLE

Line 246: , a24 out nocopy JTF_DATE_TABLE

242: , a20 out nocopy JTF_NUMBER_TABLE
243: , a21 out nocopy JTF_DATE_TABLE
244: , a22 out nocopy JTF_NUMBER_TABLE
245: , a23 out nocopy JTF_NUMBER_TABLE
246: , a24 out nocopy JTF_DATE_TABLE
247: , a25 out nocopy JTF_NUMBER_TABLE
248: , a26 out nocopy JTF_NUMBER_TABLE
249: , a27 out nocopy JTF_NUMBER_TABLE
250: , a28 out nocopy JTF_NUMBER_TABLE

Line 315: , a93 out nocopy JTF_DATE_TABLE

311: , a89 out nocopy JTF_VARCHAR2_TABLE_200
312: , a90 out nocopy JTF_VARCHAR2_TABLE_200
313: , a91 out nocopy JTF_VARCHAR2_TABLE_200
314: , a92 out nocopy JTF_VARCHAR2_TABLE_200
315: , a93 out nocopy JTF_DATE_TABLE
316: , a94 out nocopy JTF_NUMBER_TABLE
317: , a95 out nocopy JTF_DATE_TABLE
318: , a96 out nocopy JTF_NUMBER_TABLE
319: , a97 out nocopy JTF_NUMBER_TABLE

Line 317: , a95 out nocopy JTF_DATE_TABLE

313: , a91 out nocopy JTF_VARCHAR2_TABLE_200
314: , a92 out nocopy JTF_VARCHAR2_TABLE_200
315: , a93 out nocopy JTF_DATE_TABLE
316: , a94 out nocopy JTF_NUMBER_TABLE
317: , a95 out nocopy JTF_DATE_TABLE
318: , a96 out nocopy JTF_NUMBER_TABLE
319: , a97 out nocopy JTF_NUMBER_TABLE
320: , a98 out nocopy JTF_VARCHAR2_TABLE_100
321: , a99 out nocopy JTF_VARCHAR2_TABLE_100

Line 350: , a6 JTF_DATE_TABLE

346: , a2 JTF_VARCHAR2_TABLE_100
347: , a3 JTF_VARCHAR2_TABLE_2000
348: , a4 JTF_NUMBER_TABLE
349: , a5 JTF_VARCHAR2_TABLE_300
350: , a6 JTF_DATE_TABLE
351: , a7 JTF_NUMBER_TABLE
352: );
353: procedure rosetta_table_copy_out_p13(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE

Line 359: , a6 out nocopy JTF_DATE_TABLE

355: , a2 out nocopy JTF_VARCHAR2_TABLE_100
356: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_VARCHAR2_TABLE_300
359: , a6 out nocopy JTF_DATE_TABLE
360: , a7 out nocopy JTF_NUMBER_TABLE
361: );
362:
363: procedure process_jobs(p_api_version NUMBER

Line 387: , p9_a15 in out nocopy JTF_DATE_TABLE

383: , p9_a11 in out nocopy JTF_NUMBER_TABLE
384: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p9_a15 in out nocopy JTF_DATE_TABLE
388: , p9_a16 in out nocopy JTF_NUMBER_TABLE
389: , p9_a17 in out nocopy JTF_NUMBER_TABLE
390: , p9_a18 in out nocopy JTF_DATE_TABLE
391: , p9_a19 in out nocopy JTF_NUMBER_TABLE

Line 390: , p9_a18 in out nocopy JTF_DATE_TABLE

386: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p9_a15 in out nocopy JTF_DATE_TABLE
388: , p9_a16 in out nocopy JTF_NUMBER_TABLE
389: , p9_a17 in out nocopy JTF_NUMBER_TABLE
390: , p9_a18 in out nocopy JTF_DATE_TABLE
391: , p9_a19 in out nocopy JTF_NUMBER_TABLE
392: , p9_a20 in out nocopy JTF_NUMBER_TABLE
393: , p9_a21 in out nocopy JTF_DATE_TABLE
394: , p9_a22 in out nocopy JTF_NUMBER_TABLE

Line 393: , p9_a21 in out nocopy JTF_DATE_TABLE

389: , p9_a17 in out nocopy JTF_NUMBER_TABLE
390: , p9_a18 in out nocopy JTF_DATE_TABLE
391: , p9_a19 in out nocopy JTF_NUMBER_TABLE
392: , p9_a20 in out nocopy JTF_NUMBER_TABLE
393: , p9_a21 in out nocopy JTF_DATE_TABLE
394: , p9_a22 in out nocopy JTF_NUMBER_TABLE
395: , p9_a23 in out nocopy JTF_NUMBER_TABLE
396: , p9_a24 in out nocopy JTF_DATE_TABLE
397: , p9_a25 in out nocopy JTF_NUMBER_TABLE

Line 396: , p9_a24 in out nocopy JTF_DATE_TABLE

392: , p9_a20 in out nocopy JTF_NUMBER_TABLE
393: , p9_a21 in out nocopy JTF_DATE_TABLE
394: , p9_a22 in out nocopy JTF_NUMBER_TABLE
395: , p9_a23 in out nocopy JTF_NUMBER_TABLE
396: , p9_a24 in out nocopy JTF_DATE_TABLE
397: , p9_a25 in out nocopy JTF_NUMBER_TABLE
398: , p9_a26 in out nocopy JTF_NUMBER_TABLE
399: , p9_a27 in out nocopy JTF_NUMBER_TABLE
400: , p9_a28 in out nocopy JTF_NUMBER_TABLE

Line 465: , p9_a93 in out nocopy JTF_DATE_TABLE

461: , p9_a89 in out nocopy JTF_VARCHAR2_TABLE_200
462: , p9_a90 in out nocopy JTF_VARCHAR2_TABLE_200
463: , p9_a91 in out nocopy JTF_VARCHAR2_TABLE_200
464: , p9_a92 in out nocopy JTF_VARCHAR2_TABLE_200
465: , p9_a93 in out nocopy JTF_DATE_TABLE
466: , p9_a94 in out nocopy JTF_NUMBER_TABLE
467: , p9_a95 in out nocopy JTF_DATE_TABLE
468: , p9_a96 in out nocopy JTF_NUMBER_TABLE
469: , p9_a97 in out nocopy JTF_NUMBER_TABLE

Line 467: , p9_a95 in out nocopy JTF_DATE_TABLE

463: , p9_a91 in out nocopy JTF_VARCHAR2_TABLE_200
464: , p9_a92 in out nocopy JTF_VARCHAR2_TABLE_200
465: , p9_a93 in out nocopy JTF_DATE_TABLE
466: , p9_a94 in out nocopy JTF_NUMBER_TABLE
467: , p9_a95 in out nocopy JTF_DATE_TABLE
468: , p9_a96 in out nocopy JTF_NUMBER_TABLE
469: , p9_a97 in out nocopy JTF_NUMBER_TABLE
470: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100

Line 601: , p11_a8 in out nocopy JTF_DATE_TABLE

597: , p11_a4 in out nocopy JTF_NUMBER_TABLE
598: , p11_a5 in out nocopy JTF_NUMBER_TABLE
599: , p11_a6 in out nocopy JTF_NUMBER_TABLE
600: , p11_a7 in out nocopy JTF_NUMBER_TABLE
601: , p11_a8 in out nocopy JTF_DATE_TABLE
602: , p11_a9 in out nocopy JTF_NUMBER_TABLE
603: , p11_a10 in out nocopy JTF_DATE_TABLE
604: , p11_a11 in out nocopy JTF_NUMBER_TABLE
605: , p11_a12 in out nocopy JTF_NUMBER_TABLE

Line 603: , p11_a10 in out nocopy JTF_DATE_TABLE

599: , p11_a6 in out nocopy JTF_NUMBER_TABLE
600: , p11_a7 in out nocopy JTF_NUMBER_TABLE
601: , p11_a8 in out nocopy JTF_DATE_TABLE
602: , p11_a9 in out nocopy JTF_NUMBER_TABLE
603: , p11_a10 in out nocopy JTF_DATE_TABLE
604: , p11_a11 in out nocopy JTF_NUMBER_TABLE
605: , p11_a12 in out nocopy JTF_NUMBER_TABLE
606: , p11_a13 in out nocopy JTF_NUMBER_TABLE
607: , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300

Line 617: , p11_a24 in out nocopy JTF_DATE_TABLE

613: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
614: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p11_a22 in out nocopy JTF_NUMBER_TABLE
616: , p11_a23 in out nocopy JTF_NUMBER_TABLE
617: , p11_a24 in out nocopy JTF_DATE_TABLE
618: , p11_a25 in out nocopy JTF_NUMBER_TABLE
619: , p11_a26 in out nocopy JTF_NUMBER_TABLE
620: , p11_a27 in out nocopy JTF_DATE_TABLE
621: , p11_a28 in out nocopy JTF_NUMBER_TABLE

Line 620: , p11_a27 in out nocopy JTF_DATE_TABLE

616: , p11_a23 in out nocopy JTF_NUMBER_TABLE
617: , p11_a24 in out nocopy JTF_DATE_TABLE
618: , p11_a25 in out nocopy JTF_NUMBER_TABLE
619: , p11_a26 in out nocopy JTF_NUMBER_TABLE
620: , p11_a27 in out nocopy JTF_DATE_TABLE
621: , p11_a28 in out nocopy JTF_NUMBER_TABLE
622: , p11_a29 in out nocopy JTF_NUMBER_TABLE
623: , p11_a30 in out nocopy JTF_DATE_TABLE
624: , p11_a31 in out nocopy JTF_NUMBER_TABLE

Line 623: , p11_a30 in out nocopy JTF_DATE_TABLE

619: , p11_a26 in out nocopy JTF_NUMBER_TABLE
620: , p11_a27 in out nocopy JTF_DATE_TABLE
621: , p11_a28 in out nocopy JTF_NUMBER_TABLE
622: , p11_a29 in out nocopy JTF_NUMBER_TABLE
623: , p11_a30 in out nocopy JTF_DATE_TABLE
624: , p11_a31 in out nocopy JTF_NUMBER_TABLE
625: , p11_a32 in out nocopy JTF_NUMBER_TABLE
626: , p11_a33 in out nocopy JTF_DATE_TABLE
627: , p11_a34 in out nocopy JTF_NUMBER_TABLE

Line 626: , p11_a33 in out nocopy JTF_DATE_TABLE

622: , p11_a29 in out nocopy JTF_NUMBER_TABLE
623: , p11_a30 in out nocopy JTF_DATE_TABLE
624: , p11_a31 in out nocopy JTF_NUMBER_TABLE
625: , p11_a32 in out nocopy JTF_NUMBER_TABLE
626: , p11_a33 in out nocopy JTF_DATE_TABLE
627: , p11_a34 in out nocopy JTF_NUMBER_TABLE
628: , p11_a35 in out nocopy JTF_NUMBER_TABLE
629: , p11_a36 in out nocopy JTF_NUMBER_TABLE
630: , p11_a37 in out nocopy JTF_NUMBER_TABLE

Line 666: , p9_a6 in out nocopy JTF_DATE_TABLE

662: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
664: , p9_a4 in out nocopy JTF_NUMBER_TABLE
665: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
666: , p9_a6 in out nocopy JTF_DATE_TABLE
667: , p9_a7 in out nocopy JTF_NUMBER_TABLE
668: );
669: end ahl_prd_workorder_pvt_w;