APPS.JTF_CALENDAR_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package jtf_calendar_pub_w as
2: /* $Header: jtfclaws.pls 120.2 2005/12/30 03:06 abraina ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_calendar_pub.shift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: jtfclaws.pls 120.2 2005/12/30 03:06 abraina ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_calendar_pub.shift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_calendar_pub.shift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_DATE_TABLE
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 11: , a2 out nocopy JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_DATE_TABLE
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_VARCHAR2_TABLE_100
13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:

Line 12: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 13: , a4 out nocopy JTF_VARCHAR2_TABLE_100

9: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_DATE_TABLE
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_VARCHAR2_TABLE_100
13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_DATE_TABLE

Line 18: , a2 JTF_VARCHAR2_TABLE_100

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

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_200
22: , a6 JTF_VARCHAR2_TABLE_200
23: , a7 JTF_VARCHAR2_TABLE_200

Line 20: , a4 JTF_VARCHAR2_TABLE_100

16: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_200
22: , a6 JTF_VARCHAR2_TABLE_200
23: , a7 JTF_VARCHAR2_TABLE_200
24: , a8 JTF_VARCHAR2_TABLE_200

Line 39: , a2 out nocopy JTF_VARCHAR2_TABLE_100

35: , a19 JTF_VARCHAR2_TABLE_200
36: );
37: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_DATE_TABLE
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_200
43: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 40: , a3 out nocopy JTF_VARCHAR2_TABLE_100

36: );
37: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_DATE_TABLE
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_200
43: , a6 out nocopy JTF_VARCHAR2_TABLE_200
44: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 41: , a4 out nocopy JTF_VARCHAR2_TABLE_100

37: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_DATE_TABLE
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_200
43: , a6 out nocopy JTF_VARCHAR2_TABLE_200
44: , a7 out nocopy JTF_VARCHAR2_TABLE_200
45: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 81: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

77: , x_msg_count out nocopy NUMBER
78: , x_msg_data out nocopy VARCHAR2
79: , p9_a0 out nocopy JTF_NUMBER_TABLE
80: , p9_a1 out nocopy JTF_DATE_TABLE
81: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure get_available_slot(p_api_version NUMBER

Line 82: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

78: , x_msg_data out nocopy VARCHAR2
79: , p9_a0 out nocopy JTF_NUMBER_TABLE
80: , p9_a1 out nocopy JTF_DATE_TABLE
81: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure get_available_slot(p_api_version NUMBER
86: , p_init_msg_list VARCHAR2

Line 83: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100

79: , p9_a0 out nocopy JTF_NUMBER_TABLE
80: , p9_a1 out nocopy JTF_DATE_TABLE
81: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure get_available_slot(p_api_version NUMBER
86: , p_init_msg_list VARCHAR2
87: , p_resource_id NUMBER

Line 111: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

107: , x_msg_count out nocopy NUMBER
108: , x_msg_data out nocopy VARCHAR2
109: , p9_a0 out nocopy JTF_NUMBER_TABLE
110: , p9_a1 out nocopy JTF_DATE_TABLE
111: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
113: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
114: );
115: procedure get_resource_shifts(p_api_version NUMBER

Line 112: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

108: , x_msg_data out nocopy VARCHAR2
109: , p9_a0 out nocopy JTF_NUMBER_TABLE
110: , p9_a1 out nocopy JTF_DATE_TABLE
111: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
113: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
114: );
115: procedure get_resource_shifts(p_api_version NUMBER
116: , p_init_msg_list VARCHAR2

Line 113: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100

109: , p9_a0 out nocopy JTF_NUMBER_TABLE
110: , p9_a1 out nocopy JTF_DATE_TABLE
111: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
113: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
114: );
115: procedure get_resource_shifts(p_api_version NUMBER
116: , p_init_msg_list VARCHAR2
117: , p_resource_id NUMBER

Line 126: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

122: , x_msg_count out nocopy NUMBER
123: , x_msg_data out nocopy VARCHAR2
124: , p9_a0 out nocopy JTF_NUMBER_TABLE
125: , p9_a1 out nocopy JTF_DATE_TABLE
126: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
127: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
129: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_200
130: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 127: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

123: , x_msg_data out nocopy VARCHAR2
124: , p9_a0 out nocopy JTF_NUMBER_TABLE
125: , p9_a1 out nocopy JTF_DATE_TABLE
126: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
127: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
129: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_200
130: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_200
131: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 128: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100

124: , p9_a0 out nocopy JTF_NUMBER_TABLE
125: , p9_a1 out nocopy JTF_DATE_TABLE
126: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
127: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
129: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_200
130: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_200
131: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_200
132: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 156: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

152: , x_msg_count out nocopy NUMBER
153: , x_msg_data out nocopy VARCHAR2
154: , p9_a0 out nocopy JTF_NUMBER_TABLE
155: , p9_a1 out nocopy JTF_DATE_TABLE
156: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
159: );
160: function resourcedt_to_serverdt(p_resource_dttime date

Line 157: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

153: , x_msg_data out nocopy VARCHAR2
154: , p9_a0 out nocopy JTF_NUMBER_TABLE
155: , p9_a1 out nocopy JTF_DATE_TABLE
156: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
159: );
160: function resourcedt_to_serverdt(p_resource_dttime date
161: , p_resource_tz_id NUMBER

Line 158: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100

154: , p9_a0 out nocopy JTF_NUMBER_TABLE
155: , p9_a1 out nocopy JTF_DATE_TABLE
156: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
159: );
160: function resourcedt_to_serverdt(p_resource_dttime date
161: , p_resource_tz_id NUMBER
162: , p_server_tz_id NUMBER