[Home] [Help]
PACKAGE: APPS.JTF_CALENDAR_PUB_W
Source
1 package jtf_calendar_pub_w AUTHID CURRENT_USER 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
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
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
25 , a9 JTF_VARCHAR2_TABLE_200
26 , a10 JTF_VARCHAR2_TABLE_200
27 , a11 JTF_VARCHAR2_TABLE_200
28 , a12 JTF_VARCHAR2_TABLE_200
29 , a13 JTF_VARCHAR2_TABLE_200
30 , a14 JTF_VARCHAR2_TABLE_200
31 , a15 JTF_VARCHAR2_TABLE_200
32 , a16 JTF_VARCHAR2_TABLE_200
33 , a17 JTF_VARCHAR2_TABLE_200
34 , a18 JTF_VARCHAR2_TABLE_200
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
44 , a7 out nocopy JTF_VARCHAR2_TABLE_200
45 , a8 out nocopy JTF_VARCHAR2_TABLE_200
46 , a9 out nocopy JTF_VARCHAR2_TABLE_200
47 , a10 out nocopy JTF_VARCHAR2_TABLE_200
48 , a11 out nocopy JTF_VARCHAR2_TABLE_200
49 , a12 out nocopy JTF_VARCHAR2_TABLE_200
50 , a13 out nocopy JTF_VARCHAR2_TABLE_200
51 , a14 out nocopy JTF_VARCHAR2_TABLE_200
52 , a15 out nocopy JTF_VARCHAR2_TABLE_200
53 , a16 out nocopy JTF_VARCHAR2_TABLE_200
54 , a17 out nocopy JTF_VARCHAR2_TABLE_200
55 , a18 out nocopy JTF_VARCHAR2_TABLE_200
56 , a19 out nocopy JTF_VARCHAR2_TABLE_200
57 );
58
59 procedure is_res_available(p_api_version NUMBER
60 , p_init_msg_list VARCHAR2
61 , p_resource_id NUMBER
62 , p_resource_type VARCHAR2
63 , p_start_date_time date
64 , p_duration NUMBER
65 , x_return_status out nocopy VARCHAR2
66 , x_msg_count out nocopy NUMBER
67 , x_msg_data out nocopy VARCHAR2
68 , x_avail out nocopy VARCHAR2
69 );
70 procedure get_available_time(p_api_version NUMBER
71 , p_init_msg_list VARCHAR2
72 , p_resource_id NUMBER
73 , p_resource_type VARCHAR2
74 , p_start_date date
75 , p_end_date date
76 , x_return_status out nocopy VARCHAR2
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
86 , p_init_msg_list VARCHAR2
87 , p_resource_id NUMBER
88 , p_resource_type VARCHAR2
89 , p_start_date_time date
90 , p_end_date_time date
91 , p_duration NUMBER
92 , x_return_status out nocopy VARCHAR2
93 , x_msg_count out nocopy NUMBER
94 , x_msg_data out nocopy VARCHAR2
95 , x_slot_start_date out nocopy DATE
96 , x_slot_end_date out nocopy DATE
97 , x_shift_construct_id out nocopy NUMBER
98 , x_availability_type out nocopy VARCHAR2
99 );
100 procedure get_resource_shifts(p_api_version NUMBER
101 , p_init_msg_list VARCHAR2
102 , p_resource_id NUMBER
103 , p_resource_type VARCHAR2
104 , p_start_date date
105 , p_end_date date
106 , x_return_status out nocopy VARCHAR2
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
116 , p_init_msg_list VARCHAR2
117 , p_resource_id NUMBER
118 , p_resource_type VARCHAR2
119 , p_start_date date
120 , p_end_date date
121 , x_return_status out nocopy VARCHAR2
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
131 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_200
132 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
133 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_200
134 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_200
135 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200
136 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
137 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
138 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200
139 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_200
140 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_200
141 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_200
142 , p9_a18 out nocopy JTF_VARCHAR2_TABLE_200
143 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_200
144 );
145 procedure get_res_schedule(p_api_version NUMBER
146 , p_init_msg_list VARCHAR2
147 , p_resource_id NUMBER
148 , p_resource_type VARCHAR2
149 , p_start_date date
150 , p_end_date date
151 , x_return_status out nocopy VARCHAR2
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
161 , p_resource_tz_id NUMBER
162 , p_server_tz_id NUMBER
163 ) return date;
164 procedure validate_cal_date(p_calendar_id NUMBER
165 , p_shift_date date
166 , ddrosetta_retval_bool OUT NOCOPY NUMBER
167 );
168 end jtf_calendar_pub_w;