1 Package ame_action_swi As
2 /* $Header: amatyswi.pkh 120.0 2005/09/02 03:53 mbocutt noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_ame_action_type >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ame_action_api.create_ame_action_type
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_action_type
27 (p_validate in number default hr_api.g_false_num
28 ,p_language_code in varchar2 default null
29 ,p_name in varchar2
30 ,p_procedure_name in varchar2
31 ,p_dynamic_description in varchar2
32 ,p_description in varchar2
33 ,p_description_query in varchar2 default null
34 ,p_rule_type in number default null
35 ,p_approver_type_id in number default null
36 ,p_action_type_id in number
37 ,p_aty_object_version_number out nocopy number
38 ,p_aty_start_date out nocopy date
39 ,p_aty_end_date out nocopy date
40 ,p_apu_object_version_number out nocopy number
41 ,p_apu_start_date out nocopy date
42 ,p_apu_end_date out nocopy date
43 ,p_return_status out nocopy varchar2
44 );
45 -- ----------------------------------------------------------------------------
46 -- |---------------------< create_ame_action_type_usage >---------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start of comments}
49 --
50 -- Description:
51 -- This procedure is the self-service wrapper procedure to the following
52 -- API: ame_action_api.create_ame_action_type_usage
53 --
54 -- Pre-requisites
55 -- All 'IN' parameters to this procedure have been appropriately derived.
56 --
57 -- Post Success:
58 -- p_return_status will return value indicating success.
59 --
60 -- Post Failure:
61 -- p_return_status will return value indication failure.
62 --
63 -- Access Status:
64 -- Internal Development use only.
65 --
66 -- {End of comments}
67 -- ----------------------------------------------------------------------------
68 PROCEDURE create_ame_action_type_usage
69 (p_validate in number default hr_api.g_false_num
70 ,p_action_type_id in number
71 ,p_rule_type in number
72 ,p_object_version_number out nocopy number
73 ,p_start_date out nocopy date
74 ,p_end_date out nocopy date
75 ,p_return_status out nocopy varchar2
76 );
77 -- ----------------------------------------------------------------------------
78 -- |----------------------< create_ame_appr_type_usage >----------------------|
79 -- ----------------------------------------------------------------------------
80 -- {Start of comments}
81 --
82 -- Description:
83 -- This procedure is the self-service wrapper procedure to the following
84 -- API: ame_action_api.create_ame_appr_type_usage
85 --
86 -- Pre-requisites
87 -- All 'IN' parameters to this procedure have been appropriately derived.
88 --
89 -- Post Success:
90 -- p_return_status will return value indicating success.
91 --
92 -- Post Failure:
93 -- p_return_status will return value indication failure.
94 --
95 -- Access Status:
96 -- Internal Development use only.
97 --
98 -- {End of comments}
99 -- ----------------------------------------------------------------------------
100 PROCEDURE create_ame_appr_type_usage
101 (p_validate in number default hr_api.g_false_num
102 ,p_action_type_id in number
103 ,p_approver_type_id in number
104 ,p_object_version_number out nocopy number
105 ,p_start_date out nocopy date
106 ,p_end_date out nocopy date
107 ,p_return_status out nocopy varchar2
108 );
109 -- ----------------------------------------------------------------------------
110 -- |---------------------< create_ame_action_type_config >--------------------|
111 -- ----------------------------------------------------------------------------
112 -- {Start of comments}
113 --
114 -- Description:
115 -- This procedure is the self-service wrapper procedure to the following
116 -- API: ame_action_api.create_ame_action_type_config
117 --
118 -- Pre-requisites
119 -- All 'IN' parameters to this procedure have been appropriately derived.
120 --
121 -- Post Success:
122 -- p_return_status will return value indicating success.
123 --
124 -- Post Failure:
125 -- p_return_status will return value indication failure.
126 --
127 -- Access Status:
128 -- Internal Development use only.
129 --
130 -- {End of comments}
131 -- ----------------------------------------------------------------------------
132 PROCEDURE create_ame_action_type_config
133 (p_validate in number default hr_api.g_false_num
134 ,p_action_type_id in number
135 ,p_application_id in number
136 ,p_voting_regime in varchar2 default null
137 ,p_chain_ordering_mode in varchar2 default null
138 ,p_order_number in number default null
139 ,p_object_version_number out nocopy number
140 ,p_start_date out nocopy date
141 ,p_end_date out nocopy date
142 ,p_return_status out nocopy varchar2
143 );
144 -- ----------------------------------------------------------------------------
145 -- |-----------------------< create_ame_req_attribute >-----------------------|
146 -- ----------------------------------------------------------------------------
147 -- {Start of comments}
148 --
149 -- Description:
150 -- This procedure is the self-service wrapper procedure to the following
151 -- API: ame_action_api.create_ame_req_attribute
152 --
156 -- Post Success:
153 -- Pre-requisites
154 -- All 'IN' parameters to this procedure have been appropriately derived.
155 --
157 -- p_return_status will return value indicating success.
158 --
159 -- Post Failure:
160 -- p_return_status will return value indication failure.
161 --
162 -- Access Status:
163 -- Internal Development use only.
164 --
165 -- {End of comments}
166 -- ----------------------------------------------------------------------------
167 PROCEDURE create_ame_req_attribute
168 (p_validate in number default hr_api.g_false_num
169 ,p_action_type_id in number
170 ,p_attribute_id in number
171 ,p_object_version_number out nocopy number
172 ,p_start_date out nocopy date
173 ,p_end_date out nocopy date
174 ,p_return_status out nocopy varchar2
175 );
176 -- ----------------------------------------------------------------------------
177 -- |---------------------------< create_ame_action >--------------------------|
178 -- ----------------------------------------------------------------------------
179 -- {Start of comments}
180 --
181 -- Description:
182 -- This procedure is the self-service wrapper procedure to the following
183 -- API: ame_action_api.create_ame_action
184 --
185 -- Pre-requisites
186 -- All 'IN' parameters to this procedure have been appropriately derived.
187 --
188 -- Post Success:
189 -- p_return_status will return value indicating success.
190 --
191 -- Post Failure:
192 -- p_return_status will return value indication failure.
193 --
194 -- Access Status:
195 -- Internal Development use only.
196 --
197 -- {End of comments}
198 -- ----------------------------------------------------------------------------
199 PROCEDURE create_ame_action
200 (p_validate in number default hr_api.g_false_num
201 ,p_language_code in varchar2 default null
202 ,p_action_type_id in number
203 ,p_parameter in varchar2
204 ,p_description in varchar2
205 ,p_parameter_two in varchar2
206 ,p_action_id out nocopy number
207 ,p_object_version_number out nocopy number
208 ,p_start_date out nocopy date
209 ,p_end_date out nocopy date
210 ,p_return_status out nocopy varchar2
211 );
212 -- ----------------------------------------------------------------------------
213 -- |------------------------< update_ame_action_type >------------------------|
214 -- ----------------------------------------------------------------------------
215 -- {Start of comments}
216 --
217 -- Description:
218 -- This procedure is the self-service wrapper procedure to the following
219 -- API: ame_action_api.update_ame_action_type
220 --
221 -- Pre-requisites
222 -- All 'IN' parameters to this procedure have been appropriately derived.
223 --
224 -- Post Success:
225 -- p_return_status will return value indicating success.
226 --
227 -- Post Failure:
228 -- p_return_status will return value indication failure.
229 --
230 -- Access Status:
231 -- Internal Development use only.
232 --
233 -- {End of comments}
234 -- ----------------------------------------------------------------------------
235 PROCEDURE update_ame_action_type
236 (p_validate in number default hr_api.g_false_num
237 ,p_language_code in varchar2 default hr_api.userenv_lang
238 ,p_action_type_id in number
239 ,p_procedure_name in varchar2 default hr_api.g_varchar2
240 ,p_description in varchar2 default hr_api.g_varchar2
241 ,p_description_query in varchar2 default hr_api.g_varchar2
242 ,p_object_version_number in out nocopy number
243 ,p_start_date out nocopy date
244 ,p_end_date out nocopy date
245 ,p_return_status out nocopy varchar2
246 );
247 -- ----------------------------------------------------------------------------
248 -- |----------------------< update_ame_action_type_conf >---------------------|
249 -- ----------------------------------------------------------------------------
250 -- {Start of comments}
251 --
255 --
252 -- Description:
253 -- This procedure is the self-service wrapper procedure to the following
254 -- API: ame_action_api.update_ame_action_type_conf
256 -- Pre-requisites
257 -- All 'IN' parameters to this procedure have been appropriately derived.
258 --
259 -- Post Success:
260 -- p_return_status will return value indicating success.
261 --
262 -- Post Failure:
263 -- p_return_status will return value indication failure.
264 --
265 -- Access Status:
266 -- Internal Development use only.
267 --
268 -- {End of comments}
269 -- ----------------------------------------------------------------------------
270 PROCEDURE update_ame_action_type_conf
271 (p_validate in number default hr_api.g_false_num
272 ,p_action_type_id in number
273 ,p_application_id in number
274 ,p_voting_regime in varchar2 default hr_api.g_varchar2
275 ,p_chain_ordering_mode in varchar2 default hr_api.g_varchar2
276 ,p_order_number in number default hr_api.g_number
277 ,p_object_version_number in out nocopy number
278 ,p_start_date out nocopy date
279 ,p_end_date out nocopy date
280 ,p_return_status out nocopy varchar2
281 );
282 -- ----------------------------------------------------------------------------
283 -- |---------------------------< update_ame_action >--------------------------|
284 -- ----------------------------------------------------------------------------
285 -- {Start of comments}
286 --
287 -- Description:
288 -- This procedure is the self-service wrapper procedure to the following
289 -- API: ame_action_api.update_ame_action
290 --
291 -- Pre-requisites
292 -- All 'IN' parameters to this procedure have been appropriately derived.
293 --
294 -- Post Success:
295 -- p_return_status will return value indicating success.
296 --
297 -- Post Failure:
298 -- p_return_status will return value indication failure.
299 --
300 -- Access Status:
301 -- Internal Development use only.
302 --
303 -- {End of comments}
304 -- ----------------------------------------------------------------------------
305 PROCEDURE update_ame_action
306 (p_validate in number default hr_api.g_false_num
307 ,p_language_code in varchar2 default hr_api.userenv_lang
308 ,p_action_id in number
309 ,p_action_type_id in number
310 ,p_parameter in varchar2 default hr_api.g_varchar2
311 ,p_parameter_two in varchar2 default hr_api.g_varchar2
312 ,p_description in varchar2 default hr_api.g_varchar2
313 ,p_object_version_number in out nocopy number
314 ,p_start_date out nocopy date
315 ,p_end_date out nocopy date
316 ,p_return_status out nocopy varchar2
317 );
318 -- ----------------------------------------------------------------------------
319 -- |------------------------< delete_ame_action_type >------------------------|
320 -- ----------------------------------------------------------------------------
321 -- {Start of comments}
322 --
323 -- Description:
324 -- This procedure is the self-service wrapper procedure to the following
325 -- API: ame_action_api.delete_ame_action_type
326 --
327 -- Pre-requisites
328 -- All 'IN' parameters to this procedure have been appropriately derived.
329 --
330 -- Post Success:
331 -- p_return_status will return value indicating success.
332 --
333 -- Post Failure:
334 -- p_return_status will return value indication failure.
335 --
336 -- Access Status:
337 -- Internal Development use only.
338 --
339 -- {End of comments}
340 -- ----------------------------------------------------------------------------
341 PROCEDURE delete_ame_action_type
342 (p_validate in number default hr_api.g_false_num
343 ,p_action_type_id in number
344 ,p_object_version_number in out nocopy number
345 ,p_start_date out nocopy date
346 ,p_end_date out nocopy date
347 ,p_return_status out nocopy varchar2
348 );
349 -- ----------------------------------------------------------------------------
350 -- |----------------------< delete_ame_action_type_conf >---------------------|
351 -- ----------------------------------------------------------------------------
352 -- {Start of comments}
353 --
354 -- Description:
355 -- This procedure is the self-service wrapper procedure to the following
356 -- API: ame_action_api.delete_ame_action_type_conf
357 --
358 -- Pre-requisites
359 -- All 'IN' parameters to this procedure have been appropriately derived.
360 --
361 -- Post Success:
362 -- p_return_status will return value indicating success.
363 --
364 -- Post Failure:
365 -- p_return_status will return value indication failure.
366 --
367 -- Access Status:
368 -- Internal Development use only.
369 --
370 -- {End of comments}
371 -- ----------------------------------------------------------------------------
372 PROCEDURE delete_ame_action_type_conf
373 (p_validate in number default hr_api.g_false_num
374 ,p_action_type_id in number
375 ,p_application_id in number
376 ,p_object_version_number in out nocopy number
377 ,p_start_date out nocopy date
378 ,p_end_date out nocopy date
379 ,p_return_status out nocopy varchar2
380 );
384 -- {Start of comments}
381 -- ----------------------------------------------------------------------------
382 -- |---------------------< delete_ame_action_type_usage >---------------------|
383 -- ----------------------------------------------------------------------------
385 --
386 -- Description:
387 -- This procedure is the self-service wrapper procedure to the following
388 -- API: ame_action_api.delete_ame_action_type_usage
389 --
390 -- Pre-requisites
391 -- All 'IN' parameters to this procedure have been appropriately derived.
392 --
393 -- Post Success:
394 -- p_return_status will return value indicating success.
395 --
396 -- Post Failure:
397 -- p_return_status will return value indication failure.
398 --
399 -- Access Status:
400 -- Internal Development use only.
401 --
402 -- {End of comments}
403 -- ----------------------------------------------------------------------------
404 PROCEDURE delete_ame_action_type_usage
405 (p_validate in number default hr_api.g_false_num
406 ,p_action_type_id in number
407 ,p_rule_type in number
408 ,p_object_version_number in out nocopy number
409 ,p_start_date out nocopy date
410 ,p_end_date out nocopy date
411 ,p_return_status out nocopy varchar2
412 );
413 -- ----------------------------------------------------------------------------
414 -- |----------------------< delete_ame_appr_type_usage >----------------------|
415 -- ----------------------------------------------------------------------------
416 -- {Start of comments}
417 --
418 -- Description:
419 -- This procedure is the self-service wrapper procedure to the following
420 -- API: ame_action_api.delete_ame_appr_type_usage
421 --
422 -- Pre-requisites
423 -- All 'IN' parameters to this procedure have been appropriately derived.
424 --
425 -- Post Success:
426 -- p_return_status will return value indicating success.
427 --
428 -- Post Failure:
429 -- p_return_status will return value indication failure.
430 --
431 -- Access Status:
432 -- Internal Development use only.
433 --
434 -- {End of comments}
435 -- ----------------------------------------------------------------------------
436 PROCEDURE delete_ame_appr_type_usage
437 (p_validate in number default hr_api.g_false_num
438 ,p_action_type_id in number
439 ,p_approver_type_id in number
440 ,p_object_version_number in out nocopy number
441 ,p_start_date out nocopy date
442 ,p_end_date out nocopy date
443 ,p_return_status out nocopy varchar2
444 );
445 -- ----------------------------------------------------------------------------
446 -- |-----------------------< delete_ame_req_attribute >-----------------------|
447 -- ----------------------------------------------------------------------------
448 -- {Start of comments}
449 --
450 -- Description:
451 -- This procedure is the self-service wrapper procedure to the following
452 -- API: ame_action_api.delete_ame_req_attribute
453 --
454 -- Pre-requisites
455 -- All 'IN' parameters to this procedure have been appropriately derived.
456 --
457 -- Post Success:
458 -- p_return_status will return value indicating success.
459 --
460 -- Post Failure:
461 -- p_return_status will return value indication failure.
462 --
463 -- Access Status:
464 -- Internal Development use only.
465 --
466 -- {End of comments}
467 -- ----------------------------------------------------------------------------
468 PROCEDURE delete_ame_req_attribute
469 (p_validate in number default hr_api.g_false_num
470 ,p_action_type_id in number
471 ,p_attribute_id in number
472 ,p_object_version_number in out nocopy number
473 ,p_start_date out nocopy date
474 ,p_end_date out nocopy date
475 ,p_return_status out nocopy varchar2
476 );
477 -- ----------------------------------------------------------------------------
478 -- |---------------------------< delete_ame_action >--------------------------|
479 -- ----------------------------------------------------------------------------
480 -- {Start of comments}
481 --
482 -- Description:
483 -- This procedure is the self-service wrapper procedure to the following
484 -- API: ame_action_api.delete_ame_action
485 --
486 -- Pre-requisites
487 -- All 'IN' parameters to this procedure have been appropriately derived.
488 --
489 -- Post Success:
490 -- p_return_status will return value indicating success.
491 --
492 -- Post Failure:
493 -- p_return_status will return value indication failure.
494 --
495 -- Access Status:
496 -- Internal Development use only.
497 --
498 -- {End of comments}
499 -- ----------------------------------------------------------------------------
500 PROCEDURE delete_ame_action
501 (p_validate in number default hr_api.g_false_num
502 ,p_action_id in number
503 ,p_action_type_id in number
504 ,p_object_version_number in out nocopy number
505 ,p_start_date out nocopy date
506 ,p_end_date out nocopy date
507 ,p_return_status out nocopy varchar2
508 );
509 end ame_action_swi;