APPS.JTF_CALENDAR_PUB_24HR_W dependencies on JTF_DATE_TABLE

Line 4: , a1 JTF_DATE_TABLE

1: package jtf_calendar_pub_24hr_w as
2: /* $Header: JTFPC24S.pls 120.2 2005/07/07 12:28:30 abraina ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_calendar_pub_24hr.shift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub_24hr.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 5: , a2 JTF_DATE_TABLE

1: package jtf_calendar_pub_24hr_w as
2: /* $Header: JTFPC24S.pls 120.2 2005/07/07 12:28:30 abraina ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_calendar_pub_24hr.shift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub_24hr.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_DATE_TABLE

Line 9: , a1 out nocopy JTF_DATE_TABLE

5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub_24hr.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_DATE_TABLE
10: , a2 out nocopy JTF_DATE_TABLE
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:

Line 10: , a2 out nocopy JTF_DATE_TABLE

6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub_24hr.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_DATE_TABLE
10: , a2 out nocopy JTF_DATE_TABLE
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:
14: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE

Line 15: , a1 JTF_DATE_TABLE

11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:
14: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_DATE_TABLE
16: , a2 JTF_DATE_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_200
19: , a5 JTF_VARCHAR2_TABLE_200

Line 16: , a2 JTF_DATE_TABLE

12: );
13:
14: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_DATE_TABLE
16: , a2 JTF_DATE_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_200
19: , a5 JTF_VARCHAR2_TABLE_200
20: , a6 JTF_VARCHAR2_TABLE_200

Line 35: , a1 out nocopy JTF_DATE_TABLE

31: , a17 JTF_VARCHAR2_TABLE_200
32: , a18 JTF_VARCHAR2_TABLE_200
33: );
34: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_DATE_TABLE
36: , a2 out nocopy JTF_DATE_TABLE
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_200
39: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 36: , a2 out nocopy JTF_DATE_TABLE

32: , a18 JTF_VARCHAR2_TABLE_200
33: );
34: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_DATE_TABLE
36: , a2 out nocopy JTF_DATE_TABLE
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_200
39: , a5 out nocopy JTF_VARCHAR2_TABLE_200
40: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 65: , p9_a1 out nocopy JTF_DATE_TABLE

61: , x_return_status out nocopy VARCHAR2
62: , x_msg_count out nocopy NUMBER
63: , x_msg_data out nocopy VARCHAR2
64: , p9_a0 out nocopy JTF_NUMBER_TABLE
65: , p9_a1 out nocopy JTF_DATE_TABLE
66: , p9_a2 out nocopy JTF_DATE_TABLE
67: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
68: );
69: procedure get_available_slot(p_api_version NUMBER

Line 66: , p9_a2 out nocopy JTF_DATE_TABLE

62: , x_msg_count out nocopy NUMBER
63: , x_msg_data out nocopy VARCHAR2
64: , p9_a0 out nocopy JTF_NUMBER_TABLE
65: , p9_a1 out nocopy JTF_DATE_TABLE
66: , p9_a2 out nocopy JTF_DATE_TABLE
67: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
68: );
69: procedure get_available_slot(p_api_version NUMBER
70: , p_init_msg_list VARCHAR2

Line 94: , p9_a1 out nocopy JTF_DATE_TABLE

90: , x_return_status out nocopy VARCHAR2
91: , x_msg_count out nocopy NUMBER
92: , x_msg_data out nocopy VARCHAR2
93: , p9_a0 out nocopy JTF_NUMBER_TABLE
94: , p9_a1 out nocopy JTF_DATE_TABLE
95: , p9_a2 out nocopy JTF_DATE_TABLE
96: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: );
98: procedure get_resource_shifts(p_api_version NUMBER

Line 95: , p9_a2 out nocopy JTF_DATE_TABLE

91: , x_msg_count out nocopy NUMBER
92: , x_msg_data out nocopy VARCHAR2
93: , p9_a0 out nocopy JTF_NUMBER_TABLE
94: , p9_a1 out nocopy JTF_DATE_TABLE
95: , p9_a2 out nocopy JTF_DATE_TABLE
96: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: );
98: procedure get_resource_shifts(p_api_version NUMBER
99: , p_init_msg_list VARCHAR2

Line 108: , p9_a1 out nocopy JTF_DATE_TABLE

104: , x_return_status out nocopy VARCHAR2
105: , x_msg_count out nocopy NUMBER
106: , x_msg_data out nocopy VARCHAR2
107: , p9_a0 out nocopy JTF_NUMBER_TABLE
108: , p9_a1 out nocopy JTF_DATE_TABLE
109: , p9_a2 out nocopy JTF_DATE_TABLE
110: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_200
112: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 109: , p9_a2 out nocopy JTF_DATE_TABLE

105: , x_msg_count out nocopy NUMBER
106: , x_msg_data out nocopy VARCHAR2
107: , p9_a0 out nocopy JTF_NUMBER_TABLE
108: , p9_a1 out nocopy JTF_DATE_TABLE
109: , p9_a2 out nocopy JTF_DATE_TABLE
110: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_200
112: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_200
113: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 148: , p9_a1 out nocopy JTF_DATE_TABLE

144: , x_return_status out nocopy VARCHAR2
145: , x_msg_count out nocopy NUMBER
146: , x_msg_data out nocopy VARCHAR2
147: , p9_a0 out nocopy JTF_NUMBER_TABLE
148: , p9_a1 out nocopy JTF_DATE_TABLE
149: , p9_a2 out nocopy JTF_DATE_TABLE
150: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
151: );
152: function resourcedt_to_serverdt(p_resource_dttime date

Line 149: , p9_a2 out nocopy JTF_DATE_TABLE

145: , x_msg_count out nocopy NUMBER
146: , x_msg_data out nocopy VARCHAR2
147: , p9_a0 out nocopy JTF_NUMBER_TABLE
148: , p9_a1 out nocopy JTF_DATE_TABLE
149: , p9_a2 out nocopy JTF_DATE_TABLE
150: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
151: );
152: function resourcedt_to_serverdt(p_resource_dttime date
153: , p_resource_tz_id NUMBER