[Home] [Help]
PACKAGE: APPS.JTF_CALENDAR_PUB_24HR_W
Source
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
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
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
21 , a7 JTF_VARCHAR2_TABLE_200
22 , a8 JTF_VARCHAR2_TABLE_200
23 , a9 JTF_VARCHAR2_TABLE_200
24 , a10 JTF_VARCHAR2_TABLE_200
25 , a11 JTF_VARCHAR2_TABLE_200
26 , a12 JTF_VARCHAR2_TABLE_200
27 , a13 JTF_VARCHAR2_TABLE_200
28 , a14 JTF_VARCHAR2_TABLE_200
29 , a15 JTF_VARCHAR2_TABLE_200
30 , a16 JTF_VARCHAR2_TABLE_200
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
40 , a6 out nocopy JTF_VARCHAR2_TABLE_200
41 , a7 out nocopy JTF_VARCHAR2_TABLE_200
42 , a8 out nocopy JTF_VARCHAR2_TABLE_200
43 , a9 out nocopy JTF_VARCHAR2_TABLE_200
44 , a10 out nocopy JTF_VARCHAR2_TABLE_200
45 , a11 out nocopy JTF_VARCHAR2_TABLE_200
46 , a12 out nocopy JTF_VARCHAR2_TABLE_200
47 , a13 out nocopy JTF_VARCHAR2_TABLE_200
48 , a14 out nocopy JTF_VARCHAR2_TABLE_200
49 , a15 out nocopy JTF_VARCHAR2_TABLE_200
50 , a16 out nocopy JTF_VARCHAR2_TABLE_200
51 , a17 out nocopy JTF_VARCHAR2_TABLE_200
52 , a18 out nocopy JTF_VARCHAR2_TABLE_200
53 );
54
55 procedure get_available_time(p_api_version NUMBER
56 , p_init_msg_list VARCHAR2
57 , p_resource_id NUMBER
58 , p_resource_type VARCHAR2
59 , p_start_date date
60 , p_end_date date
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
70 , p_init_msg_list VARCHAR2
71 , p_resource_id NUMBER
72 , p_resource_type VARCHAR2
73 , p_start_date_time date
74 , p_end_date_time date
75 , p_duration NUMBER
76 , x_return_status out nocopy VARCHAR2
77 , x_msg_count out nocopy NUMBER
78 , x_msg_data out nocopy VARCHAR2
79 , x_slot_start_date out nocopy DATE
80 , x_slot_end_date out nocopy DATE
81 , x_shift_construct_id out nocopy NUMBER
82 , x_availability_type out nocopy VARCHAR2
83 );
84 procedure get_resource_shifts(p_api_version NUMBER
85 , p_init_msg_list VARCHAR2
86 , p_resource_id NUMBER
87 , p_resource_type VARCHAR2
88 , p_start_date date
89 , p_end_date date
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
99 , p_init_msg_list VARCHAR2
100 , p_resource_id NUMBER
101 , p_resource_type VARCHAR2
102 , p_start_date date
103 , p_end_date date
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
113 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_200
114 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_200
115 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
116 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_200
117 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_200
118 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200
119 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
120 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
121 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200
122 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_200
123 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_200
124 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_200
125 , p9_a18 out nocopy JTF_VARCHAR2_TABLE_200
126 );
127 procedure is_res_available(p_api_version NUMBER
128 , p_init_msg_list VARCHAR2
129 , p_resource_id NUMBER
130 , p_resource_type VARCHAR2
131 , p_start_date_time date
132 , p_duration NUMBER
133 , x_return_status out nocopy VARCHAR2
134 , x_msg_count out nocopy NUMBER
135 , x_msg_data out nocopy VARCHAR2
136 , x_avail out nocopy VARCHAR2
137 );
138 procedure get_res_schedule(p_api_version NUMBER
139 , p_init_msg_list VARCHAR2
140 , p_resource_id NUMBER
141 , p_resource_type VARCHAR2
142 , p_start_date date
143 , p_end_date date
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
153 , p_resource_tz_id NUMBER
154 , p_server_tz_id NUMBER
155 ) return date;
156 procedure validate_cal_date(p_calendar_id NUMBER
157 , p_shift_date date
158 , ddrosetta_retval_bool OUT NOCOPY NUMBER
159 );
160 end jtf_calendar_pub_24hr_w;