1 Package hr_rate_swi AUTHID CURRENT_USER As
2 /* $Header: pypyrswi.pkh 115.0 2004/01/05 05:59 lsilveir noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_assignment_rate >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_rate_api.create_assignment_rate
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_assignment_rate
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_business_group_id in number
30 ,p_name in varchar2
31 ,p_rate_basis in varchar2
32 ,p_asg_rate_type in varchar2 default null
33 ,p_attribute_category in varchar2 default null
34 ,p_attribute1 in varchar2 default null
35 ,p_attribute2 in varchar2 default null
36 ,p_attribute3 in varchar2 default null
37 ,p_attribute4 in varchar2 default null
38 ,p_attribute5 in varchar2 default null
39 ,p_attribute6 in varchar2 default null
40 ,p_attribute7 in varchar2 default null
41 ,p_attribute8 in varchar2 default null
42 ,p_attribute9 in varchar2 default null
43 ,p_attribute10 in varchar2 default null
44 ,p_attribute11 in varchar2 default null
45 ,p_attribute12 in varchar2 default null
46 ,p_attribute13 in varchar2 default null
47 ,p_attribute14 in varchar2 default null
48 ,p_attribute15 in varchar2 default null
49 ,p_attribute16 in varchar2 default null
50 ,p_attribute17 in varchar2 default null
51 ,p_attribute18 in varchar2 default null
52 ,p_attribute19 in varchar2 default null
53 ,p_attribute20 in varchar2 default null
54 ,p_object_version_number out nocopy number
55 ,p_rate_id out nocopy number
56 ,p_return_status out nocopy varchar2
57 );
58 -- ----------------------------------------------------------------------------
59 -- |------------------------------< create_rate >-----------------------------|
60 -- ----------------------------------------------------------------------------
61 -- {Start of comments}
62 --
63 -- Description:
64 -- This procedure is the self-service wrapper procedure to the following
65 -- API: hr_rate_api.create_rate
66 --
67 -- Pre-requisites
68 -- All 'IN' parameters to this procedure have been appropriately derived.
69 --
70 -- Post Success:
71 -- p_return_status will return value indicating success.
72 --
73 -- Post Failure:
74 -- p_return_status will return value indication failure.
75 --
76 -- Access Status:
77 -- Internal Development use only.
78 --
79 -- {End of comments}
80 -- ----------------------------------------------------------------------------
81 PROCEDURE create_rate
82 (p_validate in number default hr_api.g_false_num
83 ,p_effective_date in date
84 ,p_business_group_id in number
85 ,p_name in varchar2
86 ,p_rate_type in varchar2
87 ,p_rate_uom in varchar2
88 ,p_parent_spine_id in number default null
89 ,p_comments in varchar2 default null
90 ,p_rate_basis in varchar2 default null
91 ,p_asg_rate_type in varchar2 default null
92 ,p_attribute_category in varchar2 default null
93 ,p_attribute1 in varchar2 default null
94 ,p_attribute2 in varchar2 default null
95 ,p_attribute3 in varchar2 default null
96 ,p_attribute4 in varchar2 default null
97 ,p_attribute5 in varchar2 default null
98 ,p_attribute6 in varchar2 default null
99 ,p_attribute7 in varchar2 default null
100 ,p_attribute8 in varchar2 default null
101 ,p_attribute9 in varchar2 default null
102 ,p_attribute10 in varchar2 default null
103 ,p_attribute11 in varchar2 default null
104 ,p_attribute12 in varchar2 default null
105 ,p_attribute13 in varchar2 default null
106 ,p_attribute14 in varchar2 default null
107 ,p_attribute15 in varchar2 default null
108 ,p_attribute16 in varchar2 default null
109 ,p_attribute17 in varchar2 default null
110 ,p_attribute18 in varchar2 default null
111 ,p_attribute19 in varchar2 default null
112 ,p_attribute20 in varchar2 default null
113 ,p_object_version_number out nocopy number
114 ,p_rate_id in number
115 ,p_return_status out nocopy varchar2
116 );
117 -- ----------------------------------------------------------------------------
118 -- |------------------------------< delete_rate >-----------------------------|
119 -- ----------------------------------------------------------------------------
120 -- {Start of comments}
121 --
122 -- Description:
123 -- This procedure is the self-service wrapper procedure to the following
124 -- API: hr_rate_api.delete_rate
125 --
126 -- Pre-requisites
127 -- All 'IN' parameters to this procedure have been appropriately derived.
128 --
129 -- Post Success:
130 -- p_return_status will return value indicating success.
131 --
132 -- Post Failure:
133 -- p_return_status will return value indication failure.
134 --
135 -- Access Status:
136 -- Internal Development use only.
137 --
138 -- {End of comments}
139 -- ----------------------------------------------------------------------------
140 PROCEDURE delete_rate
141 (p_validate in number default hr_api.g_false_num
142 ,p_effective_date in date
143 ,p_rate_id in number
144 ,p_rate_type in varchar2
145 ,p_object_version_number in out nocopy number
146 ,p_return_status out nocopy varchar2
147 );
148 -- ----------------------------------------------------------------------------
149 -- |------------------------< update_assignment_rate >------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start of comments}
152 --
153 -- Description:
154 -- This procedure is the self-service wrapper procedure to the following
155 -- API: hr_rate_api.update_assignment_rate
156 --
157 -- Pre-requisites
158 -- All 'IN' parameters to this procedure have been appropriately derived.
159 --
160 -- Post Success:
161 -- p_return_status will return value indicating success.
162 --
163 -- Post Failure:
164 -- p_return_status will return value indication failure.
165 --
166 -- Access Status:
167 -- Internal Development use only.
168 --
169 -- {End of comments}
170 -- ----------------------------------------------------------------------------
171 PROCEDURE update_assignment_rate
172 (p_validate in number default hr_api.g_false_num
173 ,p_rate_id in number
174 ,p_object_version_number in out nocopy number
175 ,p_effective_date in date
176 ,p_name in varchar2 default hr_api.g_varchar2
177 ,p_rate_basis in varchar2 default hr_api.g_varchar2
178 ,p_asg_rate_type in varchar2 default hr_api.g_varchar2
179 ,p_attribute_category in varchar2 default hr_api.g_varchar2
180 ,p_attribute1 in varchar2 default hr_api.g_varchar2
181 ,p_attribute2 in varchar2 default hr_api.g_varchar2
182 ,p_attribute3 in varchar2 default hr_api.g_varchar2
183 ,p_attribute4 in varchar2 default hr_api.g_varchar2
184 ,p_attribute5 in varchar2 default hr_api.g_varchar2
185 ,p_attribute6 in varchar2 default hr_api.g_varchar2
186 ,p_attribute7 in varchar2 default hr_api.g_varchar2
187 ,p_attribute8 in varchar2 default hr_api.g_varchar2
188 ,p_attribute9 in varchar2 default hr_api.g_varchar2
189 ,p_attribute10 in varchar2 default hr_api.g_varchar2
190 ,p_attribute11 in varchar2 default hr_api.g_varchar2
191 ,p_attribute12 in varchar2 default hr_api.g_varchar2
192 ,p_attribute13 in varchar2 default hr_api.g_varchar2
193 ,p_attribute14 in varchar2 default hr_api.g_varchar2
194 ,p_attribute15 in varchar2 default hr_api.g_varchar2
195 ,p_attribute16 in varchar2 default hr_api.g_varchar2
196 ,p_attribute17 in varchar2 default hr_api.g_varchar2
197 ,p_attribute18 in varchar2 default hr_api.g_varchar2
198 ,p_attribute19 in varchar2 default hr_api.g_varchar2
199 ,p_attribute20 in varchar2 default hr_api.g_varchar2
200 ,p_return_status out nocopy varchar2
201 );
202 -- ----------------------------------------------------------------------------
203 -- |------------------------------< update_rate >-----------------------------|
204 -- ----------------------------------------------------------------------------
205 -- {Start of comments}
206 --
207 -- Description:
208 -- This procedure is the self-service wrapper procedure to the following
209 -- API: hr_rate_api.update_rate
210 --
211 -- Pre-requisites
212 -- All 'IN' parameters to this procedure have been appropriately derived.
213 --
214 -- Post Success:
215 -- p_return_status will return value indicating success.
216 --
217 -- Post Failure:
218 -- p_return_status will return value indication failure.
219 --
220 -- Access Status:
221 -- Internal Development use only.
222 --
223 -- {End of comments}
224 -- ----------------------------------------------------------------------------
225 PROCEDURE update_rate
226 (p_validate in number default hr_api.g_false_num
227 ,p_rate_id in number
228 ,p_object_version_number in out nocopy number
229 ,p_effective_date in date
230 ,p_name in varchar2 default hr_api.g_varchar2
231 ,p_rate_uom in varchar2 default hr_api.g_varchar2
232 ,p_parent_spine_id in number default hr_api.g_number
233 ,p_comments in varchar2 default hr_api.g_varchar2
234 ,p_rate_basis in varchar2 default hr_api.g_varchar2
235 ,p_asg_rate_type in varchar2 default hr_api.g_varchar2
236 ,p_attribute_category in varchar2 default hr_api.g_varchar2
237 ,p_attribute1 in varchar2 default hr_api.g_varchar2
238 ,p_attribute2 in varchar2 default hr_api.g_varchar2
239 ,p_attribute3 in varchar2 default hr_api.g_varchar2
240 ,p_attribute4 in varchar2 default hr_api.g_varchar2
241 ,p_attribute5 in varchar2 default hr_api.g_varchar2
242 ,p_attribute6 in varchar2 default hr_api.g_varchar2
243 ,p_attribute7 in varchar2 default hr_api.g_varchar2
244 ,p_attribute8 in varchar2 default hr_api.g_varchar2
245 ,p_attribute9 in varchar2 default hr_api.g_varchar2
246 ,p_attribute10 in varchar2 default hr_api.g_varchar2
247 ,p_attribute11 in varchar2 default hr_api.g_varchar2
248 ,p_attribute12 in varchar2 default hr_api.g_varchar2
249 ,p_attribute13 in varchar2 default hr_api.g_varchar2
250 ,p_attribute14 in varchar2 default hr_api.g_varchar2
251 ,p_attribute15 in varchar2 default hr_api.g_varchar2
252 ,p_attribute16 in varchar2 default hr_api.g_varchar2
253 ,p_attribute17 in varchar2 default hr_api.g_varchar2
254 ,p_attribute18 in varchar2 default hr_api.g_varchar2
255 ,p_attribute19 in varchar2 default hr_api.g_varchar2
256 ,p_attribute20 in varchar2 default hr_api.g_varchar2
257 ,p_return_status out nocopy varchar2
258 );
259 end hr_rate_swi;