1 Package ame_rule_swi As
2 /* $Header: amrulswi.pkh 120.1 2005/10/11 04:22 tkolla noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_ame_rule >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ame_rule_api.create_ame_rule
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_ame_rule
27 (p_validate in number default hr_api.g_false_num
28 ,p_rule_key in varchar2
29 ,p_description in varchar2
30 ,p_rule_type in varchar2
31 ,p_item_class_id in number default null
32 ,p_condition_id in number default null
33 ,p_action_id in number default null
34 ,p_application_id in number default null
35 ,p_priority in number default null
36 ,p_approver_category in varchar2 default null
37 ,p_rul_start_date in out nocopy date
38 ,p_rul_end_date in out nocopy date
39 ,p_rule_id in number
40 ,p_rul_object_version_number out nocopy number
41 ,p_rlu_object_version_number out nocopy number
42 ,p_rlu_start_date out nocopy date
43 ,p_rlu_end_date out nocopy date
44 ,p_cnu_object_version_number out nocopy number
45 ,p_cnu_start_date out nocopy date
46 ,p_cnu_end_date out nocopy date
47 ,p_acu_object_version_number out nocopy number
48 ,p_acu_start_date out nocopy date
49 ,p_acu_end_date out nocopy date
50 ,p_return_status out nocopy varchar2
51 );
52 -- ----------------------------------------------------------------------------
53 -- |-------------------------< create_ame_rule_usage >------------------------|
54 -- ----------------------------------------------------------------------------
55 -- {Start of comments}
56 --
57 -- Description:
58 -- This procedure is the self-service wrapper procedure to the following
59 -- API: ame_rule_api.create_ame_rule_usage
60 --
61 -- Pre-requisites
62 -- All 'IN' parameters to this procedure have been appropriately derived.
63 --
64 -- Post Success:
65 -- p_return_status will return value indicating success.
66 --
67 -- Post Failure:
68 -- p_return_status will return value indication failure.
69 --
70 -- Access Status:
71 -- Internal Development use only.
72 --
73 -- {End of comments}
74 -- ----------------------------------------------------------------------------
75 PROCEDURE create_ame_rule_usage
76 (p_validate in number default hr_api.g_false_num
77 ,p_rule_id in number
78 ,p_application_id in number
79 ,p_priority in number default null
80 ,p_approver_category in varchar2 default null
81 ,p_start_date in out nocopy date
82 ,p_end_date in out nocopy date
83 ,p_object_version_number out nocopy number
84 ,p_return_status out nocopy varchar2
85 );
86 -- ----------------------------------------------------------------------------
87 -- |---------------------< create_ame_condition_to_rule >---------------------|
88 -- ----------------------------------------------------------------------------
89 -- {Start of comments}
90 --
91 -- Description:
92 -- This procedure is the self-service wrapper procedure to the following
93 -- API: ame_rule_api.create_ame_condition_to_rule
94 --
95 -- Pre-requisites
96 -- All 'IN' parameters to this procedure have been appropriately derived.
97 --
98 -- Post Success:
99 -- p_return_status will return value indicating success.
100 --
101 -- Post Failure:
102 -- p_return_status will return value indication failure.
103 --
104 -- Access Status:
105 -- Internal Development use only.
106 --
107 -- {End of comments}
108 -- ----------------------------------------------------------------------------
109 PROCEDURE create_ame_condition_to_rule
110 (p_validate in number default hr_api.g_false_num
111 ,p_rule_id in number
112 ,p_condition_id in number
113 ,p_object_version_number out nocopy number
114 ,p_start_date out nocopy date
115 ,p_end_date out nocopy date
116 ,p_return_status out nocopy varchar2
117 ,p_effective_date in date default null
118 );
119 -- ----------------------------------------------------------------------------
120 -- |-----------------------< create_ame_action_to_rule >----------------------|
121 -- ----------------------------------------------------------------------------
122 -- {Start of comments}
123 --
124 -- Description:
125 -- This procedure is the self-service wrapper procedure to the following
126 -- API: ame_rule_api.create_ame_action_to_rule
127 --
128 -- Pre-requisites
129 -- All 'IN' parameters to this procedure have been appropriately derived.
130 --
131 -- Post Success:
132 -- p_return_status will return value indicating success.
133 --
134 -- Post Failure:
135 -- p_return_status will return value indication failure.
136 --
137 -- Access Status:
138 -- Internal Development use only.
139 --
140 -- {End of comments}
141 -- ----------------------------------------------------------------------------
142 PROCEDURE create_ame_action_to_rule
143 (p_validate in number default hr_api.g_false_num
144 ,p_rule_id in number
145 ,p_action_id in number
146 ,p_object_version_number out nocopy number
147 ,p_start_date out nocopy date
148 ,p_end_date out nocopy date
149 ,p_return_status out nocopy varchar2
150 ,p_effective_date in date default null
151 );
152 -- ----------------------------------------------------------------------------
153 -- |----------------------------< update_ame_rule >---------------------------|
154 -- ----------------------------------------------------------------------------
155 -- {Start of comments}
156 --
157 -- Description:
158 -- This procedure is the self-service wrapper procedure to the following
159 -- API: ame_rule_api.update_ame_rule
160 --
161 -- Pre-requisites
162 -- All 'IN' parameters to this procedure have been appropriately derived.
163 --
164 -- Post Success:
165 -- p_return_status will return value indicating success.
166 --
167 -- Post Failure:
168 -- p_return_status will return value indication failure.
169 --
170 -- Access Status:
171 -- Internal Development use only.
172 --
173 -- {End of comments}
174 -- ----------------------------------------------------------------------------
175 PROCEDURE update_ame_rule
176 (p_validate in number default hr_api.g_false_num
177 ,p_rule_id in number
178 ,p_description in varchar2 default hr_api.g_varchar2
179 ,p_object_version_number in out nocopy number
180 ,p_start_date in out nocopy date
181 ,p_end_date in out nocopy date
182 ,p_return_status out nocopy varchar2
183 );
184 -- ----------------------------------------------------------------------------
185 -- |-------------------------< update_ame_rule_usage >------------------------|
186 -- ----------------------------------------------------------------------------
187 -- {Start of comments}
188 --
189 -- Description:
190 -- This procedure is the self-service wrapper procedure to the following
191 -- API: ame_rule_api.update_ame_rule_usage
192 --
193 -- Pre-requisites
194 -- All 'IN' parameters to this procedure have been appropriately derived.
195 --
196 -- Post Success:
197 -- p_return_status will return value indicating success.
198 --
199 -- Post Failure:
200 -- p_return_status will return value indication failure.
201 --
202 -- Access Status:
203 -- Internal Development use only.
204 --
205 -- {End of comments}
206 -- ----------------------------------------------------------------------------
207 PROCEDURE update_ame_rule_usage
208 (p_validate in number default hr_api.g_false_num
209 ,p_rule_id in number
210 ,p_application_id in number
211 ,p_priority in number default hr_api.g_number
212 ,p_approver_category in varchar2 default hr_api.g_varchar2
213 ,p_old_start_date in date
214 ,p_object_version_number in out nocopy number
215 ,p_start_date in out nocopy date
216 ,p_end_date in out nocopy date
217 ,p_return_status out nocopy varchar2
218 );
219 -- ----------------------------------------------------------------------------
220 -- |-------------------------< delete_ame_rule_usage >------------------------|
221 -- ----------------------------------------------------------------------------
222 -- {Start of comments}
223 --
224 -- Description:
225 -- This procedure is the self-service wrapper procedure to the following
226 -- API: ame_rule_api.delete_ame_rule_usage
227 --
228 -- Pre-requisites
229 -- All 'IN' parameters to this procedure have been appropriately derived.
230 --
231 -- Post Success:
232 -- p_return_status will return value indicating success.
233 --
234 -- Post Failure:
235 -- p_return_status will return value indication failure.
236 --
237 -- Access Status:
238 -- Internal Development use only.
239 --
240 -- {End of comments}
241 -- ----------------------------------------------------------------------------
242 PROCEDURE delete_ame_rule_usage
243 (p_validate in number default hr_api.g_false_num
244 ,p_rule_id in number
245 ,p_application_id in number
246 ,p_object_version_number in out nocopy number
247 ,p_start_date in out nocopy date
248 ,p_end_date in out nocopy date
249 ,p_return_status out nocopy varchar2
250 );
251 -- ----------------------------------------------------------------------------
252 -- |-----------------------< delete_ame_rule_condition >----------------------|
253 -- ----------------------------------------------------------------------------
254 -- {Start of comments}
255 --
256 -- Description:
257 -- This procedure is the self-service wrapper procedure to the following
258 -- API: ame_rule_api.delete_ame_rule_condition
259 --
260 -- Pre-requisites
261 -- All 'IN' parameters to this procedure have been appropriately derived.
262 --
263 -- Post Success:
264 -- p_return_status will return value indicating success.
265 --
266 -- Post Failure:
267 -- p_return_status will return value indication failure.
268 --
269 -- Access Status:
270 -- Internal Development use only.
271 --
275 (p_validate in number default hr_api.g_false_num
272 -- {End of comments}
273 -- ----------------------------------------------------------------------------
274 PROCEDURE delete_ame_rule_condition
276 ,p_rule_id in number
277 ,p_condition_id in number
278 ,p_object_version_number in out nocopy number
279 ,p_start_date out nocopy date
280 ,p_end_date out nocopy date
281 ,p_return_status out nocopy varchar2
282 );
283 -- ----------------------------------------------------------------------------
284 -- |------------------------< delete_ame_rule_action >------------------------|
285 -- ----------------------------------------------------------------------------
286 -- {Start of comments}
287 --
288 -- Description:
289 -- This procedure is the self-service wrapper procedure to the following
290 -- API: ame_rule_api.delete_ame_rule_action
291 --
292 -- Pre-requisites
293 -- All 'IN' parameters to this procedure have been appropriately derived.
294 --
295 -- Post Success:
296 -- p_return_status will return value indicating success.
297 --
298 -- Post Failure:
299 -- p_return_status will return value indication failure.
300 --
301 -- Access Status:
302 -- Internal Development use only.
303 --
304 -- {End of comments}
305 -- ----------------------------------------------------------------------------
306 PROCEDURE delete_ame_rule_action
307 (p_validate in number default hr_api.g_false_num
308 ,p_rule_id in number
309 ,p_action_id in number
310 ,p_object_version_number in out nocopy number
311 ,p_start_date out nocopy date
312 ,p_end_date out nocopy date
313 ,p_return_status out nocopy varchar2
314 );
315 -- ----------------------------------------------------------------------------
316 -- |------------------------< set_effective_date >------------------------|
317 -- ----------------------------------------------------------------------------
318 -- {Start of comments}
319 --
320 -- Description:
321 -- This procedure is used to set the g_effective_date package variable.This
322 -- value is used in the api as the effective_date of delete operation
323 -- ( delete_ame_rule_condition and delete_ame_rule_action ).
324 --
325 -- Pre-requisites
326 -- None
327 --
328 -- Post Success:
329 -- None
330 --
331 -- Post Failure:
332 -- None
333 --
334 -- Access Status:
335 -- Internal Development use only.
336 --
337 -- {End of comments}
338 -- ----------------------------------------------------------------------------
339 PROCEDURE set_effective_date
340 (p_effective_date in date
341 );
342 --
343 -- Other Global Variables
344 --
345 g_effective_date date default null;
346 end ame_rule_swi;