APPS.AHL_COMPLETIONS_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_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_DATE_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
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_100

Line 13: , a10 JTF_DATE_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
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_100
17: , a14 JTF_NUMBER_TABLE

Line 14: , a11 JTF_DATE_TABLE

10: , a7 JTF_NUMBER_TABLE
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_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE

Line 36: , a8 out nocopy JTF_DATE_TABLE

32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , a9 out nocopy JTF_DATE_TABLE

33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , a10 out nocopy JTF_DATE_TABLE

34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE

Line 39: , a11 out nocopy JTF_DATE_TABLE

35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE

Line 64: , a10 JTF_DATE_TABLE

60: , a6 JTF_NUMBER_TABLE
61: , a7 JTF_VARCHAR2_TABLE_2000
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_DATE_TABLE
65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100

Line 65: , a11 JTF_DATE_TABLE

61: , a7 JTF_VARCHAR2_TABLE_2000
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_DATE_TABLE
65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_VARCHAR2_TABLE_100

Line 66: , a12 JTF_DATE_TABLE

62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_DATE_TABLE
65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_VARCHAR2_TABLE_100
70: );

Line 67: , a13 JTF_DATE_TABLE

63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_DATE_TABLE
65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_VARCHAR2_TABLE_100
70: );
71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 81: , a10 out nocopy JTF_DATE_TABLE

77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a8 out nocopy JTF_NUMBER_TABLE
80: , a9 out nocopy JTF_NUMBER_TABLE
81: , a10 out nocopy JTF_DATE_TABLE
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE
84: , a13 out nocopy JTF_DATE_TABLE
85: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , a11 out nocopy JTF_DATE_TABLE

78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a8 out nocopy JTF_NUMBER_TABLE
80: , a9 out nocopy JTF_NUMBER_TABLE
81: , a10 out nocopy JTF_DATE_TABLE
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE
84: , a13 out nocopy JTF_DATE_TABLE
85: , a14 out nocopy JTF_VARCHAR2_TABLE_100
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , a12 out nocopy JTF_DATE_TABLE

79: , a8 out nocopy JTF_NUMBER_TABLE
80: , a9 out nocopy JTF_NUMBER_TABLE
81: , a10 out nocopy JTF_DATE_TABLE
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE
84: , a13 out nocopy JTF_DATE_TABLE
85: , a14 out nocopy JTF_VARCHAR2_TABLE_100
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: );

Line 84: , a13 out nocopy JTF_DATE_TABLE

80: , a9 out nocopy JTF_NUMBER_TABLE
81: , a10 out nocopy JTF_DATE_TABLE
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE
84: , a13 out nocopy JTF_DATE_TABLE
85: , a14 out nocopy JTF_VARCHAR2_TABLE_100
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: );
88:

Line 100: , a11 JTF_DATE_TABLE

96: , a7 JTF_VARCHAR2_TABLE_200
97: , a8 JTF_NUMBER_TABLE
98: , a9 JTF_NUMBER_TABLE
99: , a10 JTF_NUMBER_TABLE
100: , a11 JTF_DATE_TABLE
101: );
102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 113: , a11 out nocopy JTF_DATE_TABLE

109: , a7 out nocopy JTF_VARCHAR2_TABLE_200
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_DATE_TABLE
114: );
115:
116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE

Line 249: , p3_a10 in out nocopy JTF_DATE_TABLE

245: , p3_a6 in out nocopy JTF_NUMBER_TABLE
246: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247: , p3_a8 in out nocopy JTF_NUMBER_TABLE
248: , p3_a9 in out nocopy JTF_NUMBER_TABLE
249: , p3_a10 in out nocopy JTF_DATE_TABLE
250: , p3_a11 in out nocopy JTF_DATE_TABLE
251: , p3_a12 in out nocopy JTF_DATE_TABLE
252: , p3_a13 in out nocopy JTF_DATE_TABLE
253: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 250: , p3_a11 in out nocopy JTF_DATE_TABLE

246: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247: , p3_a8 in out nocopy JTF_NUMBER_TABLE
248: , p3_a9 in out nocopy JTF_NUMBER_TABLE
249: , p3_a10 in out nocopy JTF_DATE_TABLE
250: , p3_a11 in out nocopy JTF_DATE_TABLE
251: , p3_a12 in out nocopy JTF_DATE_TABLE
252: , p3_a13 in out nocopy JTF_DATE_TABLE
253: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 251: , p3_a12 in out nocopy JTF_DATE_TABLE

247: , p3_a8 in out nocopy JTF_NUMBER_TABLE
248: , p3_a9 in out nocopy JTF_NUMBER_TABLE
249: , p3_a10 in out nocopy JTF_DATE_TABLE
250: , p3_a11 in out nocopy JTF_DATE_TABLE
251: , p3_a12 in out nocopy JTF_DATE_TABLE
252: , p3_a13 in out nocopy JTF_DATE_TABLE
253: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
255: );

Line 252: , p3_a13 in out nocopy JTF_DATE_TABLE

248: , p3_a9 in out nocopy JTF_NUMBER_TABLE
249: , p3_a10 in out nocopy JTF_DATE_TABLE
250: , p3_a11 in out nocopy JTF_DATE_TABLE
251: , p3_a12 in out nocopy JTF_DATE_TABLE
252: , p3_a13 in out nocopy JTF_DATE_TABLE
253: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
255: );
256: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2

Line 267: , p1_a10 in out nocopy JTF_DATE_TABLE

263: , p1_a6 in out nocopy JTF_NUMBER_TABLE
264: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265: , p1_a8 in out nocopy JTF_NUMBER_TABLE
266: , p1_a9 in out nocopy JTF_NUMBER_TABLE
267: , p1_a10 in out nocopy JTF_DATE_TABLE
268: , p1_a11 in out nocopy JTF_DATE_TABLE
269: , p1_a12 in out nocopy JTF_DATE_TABLE
270: , p1_a13 in out nocopy JTF_DATE_TABLE
271: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , p1_a11 in out nocopy JTF_DATE_TABLE

264: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265: , p1_a8 in out nocopy JTF_NUMBER_TABLE
266: , p1_a9 in out nocopy JTF_NUMBER_TABLE
267: , p1_a10 in out nocopy JTF_DATE_TABLE
268: , p1_a11 in out nocopy JTF_DATE_TABLE
269: , p1_a12 in out nocopy JTF_DATE_TABLE
270: , p1_a13 in out nocopy JTF_DATE_TABLE
271: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 269: , p1_a12 in out nocopy JTF_DATE_TABLE

265: , p1_a8 in out nocopy JTF_NUMBER_TABLE
266: , p1_a9 in out nocopy JTF_NUMBER_TABLE
267: , p1_a10 in out nocopy JTF_DATE_TABLE
268: , p1_a11 in out nocopy JTF_DATE_TABLE
269: , p1_a12 in out nocopy JTF_DATE_TABLE
270: , p1_a13 in out nocopy JTF_DATE_TABLE
271: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
273: );

Line 270: , p1_a13 in out nocopy JTF_DATE_TABLE

266: , p1_a9 in out nocopy JTF_NUMBER_TABLE
267: , p1_a10 in out nocopy JTF_DATE_TABLE
268: , p1_a11 in out nocopy JTF_DATE_TABLE
269: , p1_a12 in out nocopy JTF_DATE_TABLE
270: , p1_a13 in out nocopy JTF_DATE_TABLE
271: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
273: );
274: function is_signoff_date_overlapping(p_actual_start_date date