[Home] [Help]
PACKAGE: APPS.HR_COMP_ELEMENT_OUTCOME_API
Source
1 Package hr_comp_element_outcome_api as
2 /* $Header: peceoapi.pkh 120.1 2005/10/02 02:13 aroussel $ */
3 /*#
4 * This package contains competence element outcome APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Competence Element Outcome
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_element_outcome >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates competence element outcome.
17 *
18 * Competence element outcome holds outcomes achieved towards a given
19 * competency.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * Competence element and competence outcome must exist.
26 *
27 * <p><b>Post Success</b><br>
28 * Competence element outcome is created.
29 *
30 * <p><b>Post Failure</b><br>
31 * Competence element outcome is not created and an error is raised.
32 * @param p_validate If true, then validation alone will be performed and the
33 * database will remain unchanged. If false and all validation checks pass,
34 * then the database will be modified.
35 * @param p_effective_date Reference date for validating lookup values are
36 * applicable during the start to end active date range. This date does not
37 * determine when the changes take effect.
38 * @param p_competence_element_id Identifies the competence element.
39 * @param p_outcome_id Identifies the competence outcome.
40 * @param p_date_from Date from which this competence element outcome is
41 * active.
42 * @param p_date_to Date until which this competence element outcome is active.
43 * @param p_attribute_category This context value determines which flexfield
44 * structure to use with the descriptive flexfield segments.
45 * @param p_attribute1 Descriptive flexfield segment.
46 * @param p_attribute2 Descriptive flexfield segment.
47 * @param p_attribute3 Descriptive flexfield segment.
48 * @param p_attribute4 Descriptive flexfield segment.
49 * @param p_attribute5 Descriptive flexfield segment.
50 * @param p_attribute6 Descriptive flexfield segment.
51 * @param p_attribute7 Descriptive flexfield segment.
52 * @param p_attribute8 Descriptive flexfield segment.
53 * @param p_attribute9 Descriptive flexfield segment.
54 * @param p_attribute10 Descriptive flexfield segment.
55 * @param p_attribute11 Descriptive flexfield segment.
56 * @param p_attribute12 Descriptive flexfield segment.
57 * @param p_attribute13 Descriptive flexfield segment.
58 * @param p_attribute14 Descriptive flexfield segment.
59 * @param p_attribute15 Descriptive flexfield segment.
60 * @param p_attribute16 Descriptive flexfield segment.
61 * @param p_attribute17 Descriptive flexfield segment.
62 * @param p_attribute18 Descriptive flexfield segment.
63 * @param p_attribute19 Descriptive flexfield segment.
64 * @param p_attribute20 Descriptive flexfield segment.
65 * @param p_information_category This context value determines which flexfield
66 * structure to use with the developer descriptive flexfield segments.
67 * @param p_information1 Developer descriptive flexfield segment.
68 * @param p_information2 Developer descriptive flexfield segment.
69 * @param p_information3 Developer descriptive flexfield segment.
70 * @param p_information4 Developer descriptive flexfield segment.
71 * @param p_information5 Developer descriptive flexfield segment.
72 * @param p_information6 Developer descriptive flexfield segment.
73 * @param p_information7 Developer descriptive flexfield segment.
74 * @param p_information8 Developer descriptive flexfield segment.
75 * @param p_information9 Developer descriptive flexfield segment.
76 * @param p_information10 Developer descriptive flexfield segment.
77 * @param p_information11 Developer descriptive flexfield segment.
78 * @param p_information12 Developer descriptive flexfield segment.
79 * @param p_information13 Developer descriptive flexfield segment.
80 * @param p_information14 Developer descriptive flexfield segment.
81 * @param p_information15 Developer descriptive flexfield segment.
82 * @param p_information16 Developer descriptive flexfield segment.
83 * @param p_information17 Developer descriptive flexfield segment.
84 * @param p_information18 Developer descriptive flexfield segment.
85 * @param p_information19 Developer descriptive flexfield segment.
86 * @param p_information20 Developer descriptive flexfield segment.
87 * @param p_comp_element_outcome_id If p_validate is false, then this uniquely
88 * identifies the competence element outcome created. If p_validate is true,
89 * then set to null.
90 * @param p_object_version_number If p_validate is false, then set to the
91 * version number of the created element outcome. If p_validate is true, then
92 * the value will be null.
93 * @rep:displayname Create Competence Element Outcome
94 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
95 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
96 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
97 * @rep:scope public
98 * @rep:lifecycle active
99 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
100 */
101 --
102 -- {End Of Comments}
103 --
104 procedure create_element_outcome
105 (p_validate in boolean default false
106 ,p_effective_date in date
107 ,p_competence_element_id in number
108 ,p_outcome_id in number
109 ,p_date_from in date
110 ,p_date_to in date default null
111 ,p_attribute_category in varchar2 default null
112 ,p_attribute1 in varchar2 default null
113 ,p_attribute2 in varchar2 default null
114 ,p_attribute3 in varchar2 default null
115 ,p_attribute4 in varchar2 default null
116 ,p_attribute5 in varchar2 default null
117 ,p_attribute6 in varchar2 default null
118 ,p_attribute7 in varchar2 default null
119 ,p_attribute8 in varchar2 default null
120 ,p_attribute9 in varchar2 default null
121 ,p_attribute10 in varchar2 default null
122 ,p_attribute11 in varchar2 default null
123 ,p_attribute12 in varchar2 default null
124 ,p_attribute13 in varchar2 default null
125 ,p_attribute14 in varchar2 default null
126 ,p_attribute15 in varchar2 default null
127 ,p_attribute16 in varchar2 default null
128 ,p_attribute17 in varchar2 default null
129 ,p_attribute18 in varchar2 default null
130 ,p_attribute19 in varchar2 default null
131 ,p_attribute20 in varchar2 default null
132 ,p_information_category in varchar2 default null
133 ,p_information1 in varchar2 default null
134 ,p_information2 in varchar2 default null
135 ,p_information3 in varchar2 default null
136 ,p_information4 in varchar2 default null
137 ,p_information5 in varchar2 default null
138 ,p_information6 in varchar2 default null
139 ,p_information7 in varchar2 default null
140 ,p_information8 in varchar2 default null
141 ,p_information9 in varchar2 default null
142 ,p_information10 in varchar2 default null
143 ,p_information11 in varchar2 default null
144 ,p_information12 in varchar2 default null
145 ,p_information13 in varchar2 default null
146 ,p_information14 in varchar2 default null
147 ,p_information15 in varchar2 default null
148 ,p_information16 in varchar2 default null
149 ,p_information17 in varchar2 default null
150 ,p_information18 in varchar2 default null
151 ,p_information19 in varchar2 default null
152 ,p_information20 in varchar2 default null
153 ,p_comp_element_outcome_id out nocopy number
154 ,p_object_version_number out nocopy number
155 ) ;
156 --
157 -- ----------------------------------------------------------------------------
158 -- |--------------------------< update_element_outcome >----------------------|
159 -- ----------------------------------------------------------------------------
160 --
161 -- {Start Of Comments}
162 /*#
163 * This API updates competence element outcome.
164 *
165 * Competence element outcome holds outcomes achieved towards a given
166 * Competency.
167 *
168 * <p><b>Licensing</b><br>
169 * This API is licensed for use with Human Resources.
170 *
171 * <p><b>Prerequisites</b><br>
172 * The competence element outcome must exist.
173 *
174 * <p><b>Post Success</b><br>
175 * Competence element outcome is updated.
176 *
177 * <p><b>Post Failure</b><br>
178 * Competence element outcome is not updated and an error is raised.
179 * @param p_validate If true, then validation alone will be performed and the
180 * database will remain unchanged. If false and all validation checks pass,
181 * then the database will be modified.
182 * @param p_effective_date Reference date for validating lookup values are
183 * applicable during the start to end active date range. This date does not
184 * determine when the changes take effect.
185 * @param p_comp_element_outcome_id Identifies the competence element outcome
186 * to be modified.
187 * @param p_object_version_number Pass in the current version number of the
188 * element outcome to be updated. When the API completes if p_validate is
189 * false, will be set to the new version number of the updated element outcome.
190 * If p_validate is true will be set to the same value which was passed in
191 * @param p_competence_element_id Identifies the competence element.
192 * @param p_outcome_id Identifies the competence outcome.
193 * @param p_date_from Date from which this competence element outcome is
194 * active.
195 * @param p_date_to Date until which this competence element outcome is active.
196 * @param p_attribute_category This context value determines which flexfield
197 * structure to use with the descriptive flexfield segments.
198 * @param p_attribute1 Descriptive flexfield segment.
199 * @param p_attribute2 Descriptive flexfield segment.
200 * @param p_attribute3 Descriptive flexfield segment.
201 * @param p_attribute4 Descriptive flexfield segment.
202 * @param p_attribute5 Descriptive flexfield segment.
203 * @param p_attribute6 Descriptive flexfield segment.
204 * @param p_attribute7 Descriptive flexfield segment.
205 * @param p_attribute8 Descriptive flexfield segment.
206 * @param p_attribute9 Descriptive flexfield segment.
207 * @param p_attribute10 Descriptive flexfield segment.
208 * @param p_attribute11 Descriptive flexfield segment.
209 * @param p_attribute12 Descriptive flexfield segment.
210 * @param p_attribute13 Descriptive flexfield segment.
211 * @param p_attribute14 Descriptive flexfield segment.
212 * @param p_attribute15 Descriptive flexfield segment.
213 * @param p_attribute16 Descriptive flexfield segment.
214 * @param p_attribute17 Descriptive flexfield segment.
215 * @param p_attribute18 Descriptive flexfield segment.
216 * @param p_attribute19 Descriptive flexfield segment.
217 * @param p_attribute20 Descriptive flexfield segment.
218 * @param p_information_category This context value determines which flexfield
219 * structure to use with the developer descriptive flexfield segments.
220 * @param p_information1 Developer descriptive flexfield segment.
221 * @param p_information2 Developer descriptive flexfield segment.
222 * @param p_information3 Developer descriptive flexfield segment.
223 * @param p_information4 Developer descriptive flexfield segment.
224 * @param p_information5 Developer descriptive flexfield segment.
225 * @param p_information6 Developer descriptive flexfield segment.
226 * @param p_information7 Developer descriptive flexfield segment.
227 * @param p_information8 Developer descriptive flexfield segment.
228 * @param p_information9 Developer descriptive flexfield segment.
229 * @param p_information10 Developer descriptive flexfield segment.
230 * @param p_information11 Developer descriptive flexfield segment.
231 * @param p_information12 Developer descriptive flexfield segment.
232 * @param p_information13 Developer descriptive flexfield segment.
233 * @param p_information14 Developer descriptive flexfield segment.
234 * @param p_information15 Developer descriptive flexfield segment.
235 * @param p_information16 Developer descriptive flexfield segment.
236 * @param p_information17 Developer descriptive flexfield segment.
237 * @param p_information18 Developer descriptive flexfield segment.
238 * @param p_information19 Developer descriptive flexfield segment.
239 * @param p_information20 Developer descriptive flexfield segment.
240 * @rep:displayname Update Competence Element Outcome
241 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
242 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
243 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
244 * @rep:scope public
245 * @rep:lifecycle active
246 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
247 */
248 --
249 -- {End Of Comments}
250 --
251 procedure update_element_outcome
252 (p_validate in boolean default false
253 ,p_effective_date in date
254 ,p_comp_element_outcome_id in number
255 ,p_object_version_number in out nocopy number
256 ,p_competence_element_id in number default hr_api.g_number
257 ,p_outcome_id in number default hr_api.g_number
258 ,p_date_from in date default hr_api.g_date
259 ,p_date_to in date default hr_api.g_date
260 ,p_attribute_category in varchar2 default hr_api.g_varchar2
261 ,p_attribute1 in varchar2 default hr_api.g_varchar2
262 ,p_attribute2 in varchar2 default hr_api.g_varchar2
263 ,p_attribute3 in varchar2 default hr_api.g_varchar2
264 ,p_attribute4 in varchar2 default hr_api.g_varchar2
265 ,p_attribute5 in varchar2 default hr_api.g_varchar2
266 ,p_attribute6 in varchar2 default hr_api.g_varchar2
267 ,p_attribute7 in varchar2 default hr_api.g_varchar2
268 ,p_attribute8 in varchar2 default hr_api.g_varchar2
269 ,p_attribute9 in varchar2 default hr_api.g_varchar2
270 ,p_attribute10 in varchar2 default hr_api.g_varchar2
271 ,p_attribute11 in varchar2 default hr_api.g_varchar2
272 ,p_attribute12 in varchar2 default hr_api.g_varchar2
273 ,p_attribute13 in varchar2 default hr_api.g_varchar2
274 ,p_attribute14 in varchar2 default hr_api.g_varchar2
275 ,p_attribute15 in varchar2 default hr_api.g_varchar2
276 ,p_attribute16 in varchar2 default hr_api.g_varchar2
277 ,p_attribute17 in varchar2 default hr_api.g_varchar2
278 ,p_attribute18 in varchar2 default hr_api.g_varchar2
279 ,p_attribute19 in varchar2 default hr_api.g_varchar2
280 ,p_attribute20 in varchar2 default hr_api.g_varchar2
281 ,p_information_category in varchar2 default hr_api.g_varchar2
282 ,p_information1 in varchar2 default hr_api.g_varchar2
283 ,p_information2 in varchar2 default hr_api.g_varchar2
284 ,p_information3 in varchar2 default hr_api.g_varchar2
285 ,p_information4 in varchar2 default hr_api.g_varchar2
286 ,p_information5 in varchar2 default hr_api.g_varchar2
287 ,p_information6 in varchar2 default hr_api.g_varchar2
288 ,p_information7 in varchar2 default hr_api.g_varchar2
289 ,p_information8 in varchar2 default hr_api.g_varchar2
290 ,p_information9 in varchar2 default hr_api.g_varchar2
291 ,p_information10 in varchar2 default hr_api.g_varchar2
292 ,p_information11 in varchar2 default hr_api.g_varchar2
293 ,p_information12 in varchar2 default hr_api.g_varchar2
294 ,p_information13 in varchar2 default hr_api.g_varchar2
295 ,p_information14 in varchar2 default hr_api.g_varchar2
299 ,p_information18 in varchar2 default hr_api.g_varchar2
296 ,p_information15 in varchar2 default hr_api.g_varchar2
297 ,p_information16 in varchar2 default hr_api.g_varchar2
298 ,p_information17 in varchar2 default hr_api.g_varchar2
300 ,p_information19 in varchar2 default hr_api.g_varchar2
301 ,p_information20 in varchar2 default hr_api.g_varchar2
302 ) ;
303 --
304 -- ----------------------------------------------------------------------------
305 -- |--------------------------< delete_element_outcome >----------------------|
306 -- ----------------------------------------------------------------------------
307 --
308 -- {Start Of Comments}
309 /*#
310 * This API deletes competence element outcome.
311 *
312 * Competence element outcome holds outcomes achieved towards a given
313 * Competency.
314 *
315 * <p><b>Licensing</b><br>
316 * This API is licensed for use with Human Resources.
317 *
318 * <p><b>Prerequisites</b><br>
319 * Competence element outcome must exist.
320 *
321 * <p><b>Post Success</b><br>
322 * Competence element outcome is deleted.
323 *
324 * <p><b>Post Failure</b><br>
325 * Competence element outcome is not deleted and an error is raised.
326 * @param p_validate If true, then validation alone will be performed and the
327 * database will remain unchanged. If false and all validation checks pass,
328 * then the database will be modified.
329 * @param p_comp_element_outcome_id Identifies the record of the competence
330 * element outcome to be deleted.
331 * @param p_object_version_number Current version number of the element outcome
332 * to be deleted.
333 * @rep:displayname Delete Competence Element Outcome
334 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
335 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
336 * @rep:scope public
337 * @rep:lifecycle active
338 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
339 */
340 --
341 -- {End Of Comments}
342 --
343 procedure delete_element_outcome
344 (p_validate in boolean
345 ,p_comp_element_outcome_id in number
346 ,p_object_version_number in out nocopy number
347 );
348
349 --
350 end hr_comp_element_outcome_api;