DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT_W dependencies on JTF_DATE_TABLE

Line 20: , a17 JTF_DATE_TABLE

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 21: , a18 JTF_DATE_TABLE

17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
25: , a1 out nocopy JTF_NUMBER_TABLE

Line 22: , a19 JTF_DATE_TABLE

18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , a17 out nocopy JTF_DATE_TABLE

37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_VARCHAR2_TABLE_100
39: , a15 out nocopy JTF_VARCHAR2_TABLE_100
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_DATE_TABLE
42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_DATE_TABLE
44: );
45:

Line 42: , a18 out nocopy JTF_DATE_TABLE

38: , a14 out nocopy JTF_VARCHAR2_TABLE_100
39: , a15 out nocopy JTF_VARCHAR2_TABLE_100
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_DATE_TABLE
42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_DATE_TABLE
44: );
45:
46: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300

Line 43: , a19 out nocopy JTF_DATE_TABLE

39: , a15 out nocopy JTF_VARCHAR2_TABLE_100
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_DATE_TABLE
42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_DATE_TABLE
44: );
45:
46: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
47: , a1 JTF_VARCHAR2_TABLE_100

Line 94: , a1 JTF_DATE_TABLE

90: , a21 out nocopy JTF_VARCHAR2_TABLE_100
91: );
92:
93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
94: , a1 JTF_DATE_TABLE
95: );
96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: );

Line 97: , a1 out nocopy JTF_DATE_TABLE

93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
94: , a1 JTF_DATE_TABLE
95: );
96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: );
99:
100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE
101: , a1 JTF_VARCHAR2_TABLE_100

Line 110: , a10 JTF_DATE_TABLE

106: , a6 JTF_VARCHAR2_TABLE_100
107: , a7 JTF_VARCHAR2_TABLE_300
108: , a8 JTF_VARCHAR2_TABLE_100
109: , a9 JTF_VARCHAR2_TABLE_100
110: , a10 JTF_DATE_TABLE
111: , a11 JTF_DATE_TABLE
112: , a12 JTF_DATE_TABLE
113: );
114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 111: , a11 JTF_DATE_TABLE

107: , a7 JTF_VARCHAR2_TABLE_300
108: , a8 JTF_VARCHAR2_TABLE_100
109: , a9 JTF_VARCHAR2_TABLE_100
110: , a10 JTF_DATE_TABLE
111: , a11 JTF_DATE_TABLE
112: , a12 JTF_DATE_TABLE
113: );
114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , a12 JTF_DATE_TABLE

108: , a8 JTF_VARCHAR2_TABLE_100
109: , a9 JTF_VARCHAR2_TABLE_100
110: , a10 JTF_DATE_TABLE
111: , a11 JTF_DATE_TABLE
112: , a12 JTF_DATE_TABLE
113: );
114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_VARCHAR2_TABLE_100
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , a10 out nocopy JTF_DATE_TABLE

120: , a6 out nocopy JTF_VARCHAR2_TABLE_100
121: , a7 out nocopy JTF_VARCHAR2_TABLE_300
122: , a8 out nocopy JTF_VARCHAR2_TABLE_100
123: , a9 out nocopy JTF_VARCHAR2_TABLE_100
124: , a10 out nocopy JTF_DATE_TABLE
125: , a11 out nocopy JTF_DATE_TABLE
126: , a12 out nocopy JTF_DATE_TABLE
127: );
128:

Line 125: , a11 out nocopy JTF_DATE_TABLE

121: , a7 out nocopy JTF_VARCHAR2_TABLE_300
122: , a8 out nocopy JTF_VARCHAR2_TABLE_100
123: , a9 out nocopy JTF_VARCHAR2_TABLE_100
124: , a10 out nocopy JTF_DATE_TABLE
125: , a11 out nocopy JTF_DATE_TABLE
126: , a12 out nocopy JTF_DATE_TABLE
127: );
128:
129: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE

Line 126: , a12 out nocopy JTF_DATE_TABLE

122: , a8 out nocopy JTF_VARCHAR2_TABLE_100
123: , a9 out nocopy JTF_VARCHAR2_TABLE_100
124: , a10 out nocopy JTF_DATE_TABLE
125: , a11 out nocopy JTF_DATE_TABLE
126: , a12 out nocopy JTF_DATE_TABLE
127: );
128:
129: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE
130: , p0_a1 in out nocopy JTF_DATE_TABLE

Line 130: , p0_a1 in out nocopy JTF_DATE_TABLE

126: , a12 out nocopy JTF_DATE_TABLE
127: );
128:
129: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE
130: , p0_a1 in out nocopy JTF_DATE_TABLE
131: , x_return_status out nocopy VARCHAR2
132: , x_msg_count out nocopy NUMBER
133: , x_msg_data out nocopy VARCHAR2
134: );

Line 265: , p6_a10 out nocopy JTF_DATE_TABLE

261: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
263: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a10 out nocopy JTF_DATE_TABLE
266: , p6_a11 out nocopy JTF_DATE_TABLE
267: , p6_a12 out nocopy JTF_DATE_TABLE
268: , x_return_status out nocopy VARCHAR2
269: , x_msg_count out nocopy NUMBER

Line 266: , p6_a11 out nocopy JTF_DATE_TABLE

262: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
263: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a10 out nocopy JTF_DATE_TABLE
266: , p6_a11 out nocopy JTF_DATE_TABLE
267: , p6_a12 out nocopy JTF_DATE_TABLE
268: , x_return_status out nocopy VARCHAR2
269: , x_msg_count out nocopy NUMBER
270: , x_msg_data out nocopy VARCHAR2

Line 267: , p6_a12 out nocopy JTF_DATE_TABLE

263: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a10 out nocopy JTF_DATE_TABLE
266: , p6_a11 out nocopy JTF_DATE_TABLE
267: , p6_a12 out nocopy JTF_DATE_TABLE
268: , x_return_status out nocopy VARCHAR2
269: , x_msg_count out nocopy NUMBER
270: , x_msg_data out nocopy VARCHAR2
271: );