1 Package ame_approver_group_swi AUTHID CURRENT_USER As
2 /* $Header: amapgswi.pkh 120.0 2005/09/02 03:50 mbocutt noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-----------------------< create_ame_approver_group >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ame_approver_group_api.create_ame_approver_group
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_approver_group
27 (p_validate in number default hr_api.g_false_num
28 ,p_name in varchar2
29 ,p_description in varchar2
30 ,p_is_static in varchar2
31 ,p_query_string in varchar2 default null
32 ,p_approval_group_id in number
33 ,p_start_date out nocopy date
34 ,p_end_date out nocopy date
35 ,p_object_version_number out nocopy number
36 ,p_return_status out nocopy varchar2
37 );
38 -- ----------------------------------------------------------------------------
39 -- |-----------------------< update_ame_approver_group >----------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start of comments}
42 --
43 -- Description:
44 -- This procedure is the self-service wrapper procedure to the following
45 -- API: ame_approver_group_api.update_ame_approver_group
46 --
47 -- Pre-requisites
48 -- All 'IN' parameters to this procedure have been appropriately derived.
49 --
50 -- Post Success:
51 -- p_return_status will return value indicating success.
52 --
53 -- Post Failure:
54 -- p_return_status will return value indication failure.
55 --
56 -- Access Status:
57 -- Internal Development use only.
58 --
59 -- {End of comments}
60 -- ----------------------------------------------------------------------------
61 PROCEDURE update_ame_approver_group
62 (p_validate in number default hr_api.g_false_num
63 ,p_approval_group_id in number
64 ,p_description in varchar2 default hr_api.g_varchar2
65 ,p_is_static in varchar2 default hr_api.g_varchar2
66 ,p_query_string in varchar2 default hr_api.g_varchar2
67 ,p_object_version_number in out nocopy number
68 ,p_start_date out nocopy date
69 ,p_end_date out nocopy date
70 ,p_return_status out nocopy varchar2
71 );
72 -- ----------------------------------------------------------------------------
73 -- |-----------------------< delete_ame_approver_group >----------------------|
74 -- ----------------------------------------------------------------------------
75 -- {Start of comments}
76 --
77 -- Description:
78 -- This procedure is the self-service wrapper procedure to the following
79 -- API: ame_approver_group_api.delete_ame_approver_group
80 --
81 -- Pre-requisites
82 -- All 'IN' parameters to this procedure have been appropriately derived.
83 --
84 -- Post Success:
85 -- p_return_status will return value indicating success.
86 --
87 -- Post Failure:
88 -- p_return_status will return value indication failure.
89 --
90 -- Access Status:
91 -- Internal Development use only.
92 --
93 -- {End of comments}
94 -- ----------------------------------------------------------------------------
95 PROCEDURE delete_ame_approver_group
96 (p_validate in number default hr_api.g_false_num
97 ,p_approval_group_id in number
98 ,p_object_version_number in out nocopy number
99 ,p_start_date out nocopy date
100 ,p_end_date out nocopy date
101 ,p_return_status out nocopy varchar2
102 );
103 -- ----------------------------------------------------------------------------
104 -- |---------------------< create_approver_group_config >---------------------|
105 -- ----------------------------------------------------------------------------
106 -- {Start of comments}
107 --
108 -- Description:
109 -- This procedure is the self-service wrapper procedure to the following
110 -- API: ame_approver_group_api.create_approver_group_config
111 --
112 -- Pre-requisites
113 -- All 'IN' parameters to this procedure have been appropriately derived.
114 --
115 -- Post Success:
116 -- p_return_status will return value indicating success.
117 --
118 -- Post Failure:
119 -- p_return_status will return value indication failure.
120 --
121 -- Access Status:
122 -- Internal Development use only.
123 --
124 -- {End of comments}
125 -- ----------------------------------------------------------------------------
126 PROCEDURE create_approver_group_config
127 (p_validate in number default hr_api.g_false_num
128 ,p_approval_group_id in number
129 ,p_application_id in number
130 ,p_voting_regime in varchar2
131 ,p_order_number in number
132 ,p_object_version_number out nocopy number
133 ,p_start_date out nocopy date
134 ,p_end_date out nocopy date
135 ,p_return_status out nocopy varchar2
136 );
137 -- ----------------------------------------------------------------------------
138 -- |---------------------< delete_approver_group_config >---------------------|
139 -- ----------------------------------------------------------------------------
140 -- {Start of comments}
141 --
142 -- Description:
143 -- This procedure is the self-service wrapper procedure to the following
144 -- API: ame_approver_group_api.delete_approver_group_config
145 --
146 -- Pre-requisites
147 -- All 'IN' parameters to this procedure have been appropriately derived.
148 --
149 -- Post Success:
150 -- p_return_status will return value indicating success.
151 --
152 -- Post Failure:
153 -- p_return_status will return value indication failure.
154 --
155 -- Access Status:
156 -- Internal Development use only.
157 --
158 -- {End of comments}
159 -- ----------------------------------------------------------------------------
163 ,p_application_id in number
160 PROCEDURE delete_approver_group_config
161 (p_validate in number default hr_api.g_false_num
162 ,p_approval_group_id in number
164 ,p_object_version_number in out nocopy number
165 ,p_start_date out nocopy date
166 ,p_end_date out nocopy date
167 ,p_return_status out nocopy varchar2
168 );
169 -- ----------------------------------------------------------------------------
170 -- |---------------------< update_approver_group_config >---------------------|
171 -- ----------------------------------------------------------------------------
172 -- {Start of comments}
173 --
174 -- Description:
175 -- This procedure is the self-service wrapper procedure to the following
176 -- API: ame_approver_group_api.update_approver_group_config
177 --
178 -- Pre-requisites
179 -- All 'IN' parameters to this procedure have been appropriately derived.
180 --
181 -- Post Success:
182 -- p_return_status will return value indicating success.
183 --
184 -- Post Failure:
185 -- p_return_status will return value indication failure.
186 --
187 -- Access Status:
188 -- Internal Development use only.
189 --
190 -- {End of comments}
191 -- ----------------------------------------------------------------------------
192 PROCEDURE update_approver_group_config
193 (p_validate in number default hr_api.g_false_num
194 ,p_approval_group_id in number
195 ,p_application_id in number
196 ,p_voting_regime in varchar2 default hr_api.g_varchar2
197 ,p_order_number in varchar2 default hr_api.g_varchar2
198 ,p_object_version_number in out nocopy number
199 ,p_start_date out nocopy date
200 ,p_end_date out nocopy date
201 ,p_return_status out nocopy varchar2
202 );
203 -- ----------------------------------------------------------------------------
204 -- |----------------------< create_approver_group_item >----------------------|
205 -- ----------------------------------------------------------------------------
206 -- {Start of comments}
207 --
208 -- Description:
209 -- This procedure is the self-service wrapper procedure to the following
210 -- API: ame_approver_group_api.create_approver_group_item
211 --
212 -- Pre-requisites
213 -- All 'IN' parameters to this procedure have been appropriately derived.
214 --
215 -- Post Success:
216 -- p_return_status will return value indicating success.
217 --
218 -- Post Failure:
219 -- p_return_status will return value indication failure.
220 --
221 -- Access Status:
222 -- Internal Development use only.
223 --
224 -- {End of comments}
225 -- ----------------------------------------------------------------------------
226 PROCEDURE create_approver_group_item
227 (p_validate in number default hr_api.g_false_num
228 ,p_approval_group_id in number
229 ,p_parameter_name in varchar2
230 ,p_parameter in varchar2
231 ,p_order_number in number
232 ,p_approval_group_item_id in number
233 ,p_object_version_number out nocopy number
234 ,p_start_date out nocopy date
235 ,p_end_date out nocopy date
236 ,p_return_status out nocopy varchar2
237 );
238 -- ----------------------------------------------------------------------------
239 -- |----------------------< delete_approver_group_item >----------------------|
240 -- ----------------------------------------------------------------------------
241 -- {Start of comments}
242 --
243 -- Description:
244 -- This procedure is the self-service wrapper procedure to the following
245 -- API: ame_approver_group_api.delete_approver_group_item
246 --
247 -- Pre-requisites
248 -- All 'IN' parameters to this procedure have been appropriately derived.
249 --
250 -- Post Success:
251 -- p_return_status will return value indicating success.
252 --
253 -- Post Failure:
254 -- p_return_status will return value indication failure.
255 --
256 -- Access Status:
257 -- Internal Development use only.
258 --
259 -- {End of comments}
260 -- ----------------------------------------------------------------------------
261 PROCEDURE delete_approver_group_item
262 (p_validate in number default hr_api.g_false_num
263 ,p_approval_group_item_id in number
264 ,p_object_version_number in out nocopy number
265 ,p_start_date out nocopy date
266 ,p_end_date out nocopy date
267 ,p_return_status out nocopy varchar2
268 );
269 -- ----------------------------------------------------------------------------
270 -- |----------------------< update_approver_group_item >----------------------|
271 -- ----------------------------------------------------------------------------
272 -- {Start of comments}
273 --
274 -- Description:
275 -- This procedure is the self-service wrapper procedure to the following
276 -- API: ame_approver_group_api.update_approver_group_item
277 --
278 -- Pre-requisites
279 -- All 'IN' parameters to this procedure have been appropriately derived.
280 --
281 -- Post Success:
282 -- p_return_status will return value indicating success.
283 --
284 -- Post Failure:
285 -- p_return_status will return value indication failure.
286 --
287 -- Access Status:
288 -- Internal Development use only.
289 --
290 -- {End of comments}
291 -- ----------------------------------------------------------------------------
292 PROCEDURE update_approver_group_item
293 (p_validate in number default hr_api.g_false_num
294 ,p_approval_group_item_id in number
295 ,p_order_number in varchar2 default hr_api.g_varchar2
296 ,p_object_version_number in out nocopy number
297 ,p_start_date out nocopy date
298 ,p_end_date out nocopy date
299 ,p_return_status out nocopy varchar2
300 );
301 end ame_approver_group_swi;