1 PACKAGE ghr_pdi_api AUTHID CURRENT_USER AS
2 /*$Header: ghpdiapi.pkh 120.1 2005/10/02 01:58:16 aroussel $*/
3 /*#
4 * This package contains the Position Description APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Position Description
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------------< create_pdi >----------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates the Federal Position Description.
17 *
18 * This API creates the Position Description record in the
19 * GHR_POSITION_DESCRIPTIONS table.
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 * A valid Routing Group ID is passed to the API.
26 *
27 * <p><b>Post Success</b><br>
28 * Position Description record is created
29 *
30 * <p><b>Post Failure</b><br>
31 * An application error is raised and processing is terminated
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_position_description_id If p_validate is false, then this uniquely
36 * identifies the Position Description created. If p_validate is true, then set
37 * to null.
38 * @param p_date_from The date on which the Position Description becomes
39 * effective
40 * @param p_routing_grp_id {@rep:casecolumn
41 * GHR_ROUTING_GROUPS.ROUTING_GROUP_ID}
42 * @param p_date_to The date after which the Position Description no longer
43 * effective
44 * @param p_opm_cert_num Office of Personnel Management certification number
45 * @param p_flsa FLSA Category. Valid Values are defined by
46 * 'GHR_US_FLSA_CATEGORY' Lookup Type
47 * @param p_financial_statement Financial Statement Required. Valid Values are
48 * defined by 'GHR_US_FINANCIAL_STATEMENT' Lookup Type.
49 * @param p_subject_to_ia_action Indicates whether the position is subject to
50 * IA action. Valid Values are Y - Yes, N - No
51 * @param p_position_status Position Status. Valid Values are defined by
52 * 'GHR_US_POSITION_OCCUPIED' Lookup Type.
53 * @param p_position_is Supervisory Status. Valid Values are defined by
54 * 'GHR_US_SUPERVISORY_STATUS' Lookup Type.
55 * @param p_position_sensitivity Position Sensitivity. Valid Values are defined
56 * by 'GHR_US_POSN_SENSITIVITY' Lookup Type.
57 * @param p_competitive_level {@rep:casecolumn
58 * GHR_POSITION_DESCRIPTIONS.COMPETITIVE_LEVEL}
59 * @param p_pd_remarks Remarks
60 * @param p_position_class_std Position classification standards
61 * @param p_category Category Code. Valid Values are A - Active, I - Inactive,
62 * S - Standard, C - Cancelled
63 * @param p_career_ladder Indicates whether the position is part of a career
64 * ladder. Valid Values are Y - Yes, N - No.
65 * @param p_supervisor_name Supervisor's name
66 * @param p_supervisor_title Supervisor's title
67 * @param p_supervisor_date Date of Supervisor's authorization
68 * @param p_manager_name Manager's name
69 * @param p_manager_title Manager's title
70 * @param p_manager_date Date of Manager's authorization
71 * @param p_classifier_name Classifier's name
72 * @param p_classifier_title Classifier's title
73 * @param p_classifier_date Date on Classifier's authorization
74 * @param p_attribute_category This context value determines which flexfield
75 * structure to use with the descriptive flexfield segments.
76 * @param p_attribute1 Descriptive flexfield segment.
77 * @param p_attribute2 Descriptive flexfield segment.
78 * @param p_attribute3 Descriptive flexfield segment.
79 * @param p_attribute4 Descriptive flexfield segment.
80 * @param p_attribute5 Descriptive flexfield segment.
81 * @param p_attribute6 Descriptive flexfield segment.
82 * @param p_attribute7 Descriptive flexfield segment.
83 * @param p_attribute8 Descriptive flexfield segment.
84 * @param p_attribute9 Descriptive flexfield segment.
85 * @param p_attribute10 Descriptive flexfield segment.
86 * @param p_attribute11 Descriptive flexfield segment.
87 * @param p_attribute12 Descriptive flexfield segment.
88 * @param p_attribute13 Descriptive flexfield segment.
89 * @param p_attribute14 Descriptive flexfield segment.
90 * @param p_attribute15 Descriptive flexfield segment.
91 * @param p_attribute16 Descriptive flexfield segment.
92 * @param p_attribute17 Descriptive flexfield segment.
93 * @param p_attribute18 Descriptive flexfield segment.
94 * @param p_attribute19 Descriptive flexfield segment.
95 * @param p_attribute20 Descriptive flexfield segment.
96 * @param p_business_group_id Business Group of Record
97 * @param p_1_approved_flag Position Description approved flag.
98 * @param p_1_user_name_acted_on Application User Name
99 * @param p_1_action_taken Action taken. Valid Values are AUTHORIZED, CANCELED,
100 * CLASSIFIED, INITIATED, NOT_ROUTED, NO_ACTION, RECLASSIFIED, REOPENED,
101 * REQUESTED, REVIEWED
102 * @param p_2_user_name_routed_to Application User Name
103 * @param p_2_groupbox_id {@rep:casecolumn GHR_GROUPBOXES.GROUPBOX_ID}
104 * @param p_2_routing_list_id {@rep:casecolumn
105 * GHR_ROUTING_LISTS.ROUTING_LIST_ID}
106 * @param p_2_routing_seq_number {@rep:casecolumn
107 * GHR_ROUTING_LIST_MEMBERS.SEQ_NUMBER}
108 * @param p_1_pd_routing_history_id {@rep:casecolumn
109 * GHR_PD_ROUTING_HISTORY.PD_ROUTING_HISTORY_ID}
113 * @param p_2_pdh_object_version_number If p_validate is false, then sets the
110 * @param p_1_pdh_object_version_number If p_validate is false, then sets the
111 * version number of the created Position Description history. If p_validate is
112 * true, then the value is null.
114 * version number of the created Position Description history. If p_validate is
115 * true, then the value is null.
116 * @param p_2_pd_routing_history_id If p_validate is false, then this uniquely
117 * identifies the Position Description Routing History created. If p_validate
118 * is true, then set to null.
119 * @param p_pdi_object_version_number If p_validate is false, then sets the
120 * version number of the created Position Description. If p_validate is true,
121 * then the value is null.
122 * @rep:displayname Create Federal Position Description
123 * @rep:category BUSINESS_ENTITY GHR_POSITION_DESCRIPTION
124 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
125 * @rep:scope public
126 * @rep:lifecycle active
127 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
128 */
129 --
130 -- {End Of Comments}
131 --
132 PROCEDURE create_pdi(
133 p_validate IN BOOLEAN default false,
134 p_position_description_id OUT NOCOPY number,
135 p_date_from IN date,
136 p_routing_grp_id IN number default null,
137 p_date_to IN date default null,
138 p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
139 p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
140 p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141 p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142 p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143 p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144 p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145 p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146 p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147 p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
148 p_category IN ghr_position_descriptions.category%TYPE default null,
149 p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
150 p_supervisor_name in varchar2 default hr_api.g_varchar2,
151 p_supervisor_title in varchar2 default hr_api.g_varchar2,
152 p_supervisor_date in date default hr_api.g_date,
153 p_manager_name in varchar2 default hr_api.g_varchar2,
154 p_manager_title in varchar2 default hr_api.g_varchar2,
155 p_manager_date in date default hr_api.g_date,
156 p_classifier_name in varchar2 default hr_api.g_varchar2,
157 p_classifier_title in varchar2 default hr_api.g_varchar2,
158 p_classifier_date in date default hr_api.g_date,
159 p_attribute_category in varchar2 default null,
160 p_attribute1 in varchar2 default null,
161 p_attribute2 in varchar2 default null,
162 p_attribute3 in varchar2 default null,
163 p_attribute4 in varchar2 default null,
164 p_attribute5 in varchar2 default null,
165 p_attribute6 in varchar2 default null,
166 p_attribute7 in varchar2 default null,
167 p_attribute8 in varchar2 default null,
168 p_attribute9 in varchar2 default null,
169 p_attribute10 in varchar2 default null,
170 p_attribute11 in varchar2 default null,
171 p_attribute12 in varchar2 default null,
172 p_attribute13 in varchar2 default null,
173 p_attribute14 in varchar2 default null,
174 p_attribute15 in varchar2 default null,
175 p_attribute16 in varchar2 default null,
176 p_attribute17 in varchar2 default null,
177 p_attribute18 in varchar2 default null,
178 p_attribute19 in varchar2 default null,
179 p_attribute20 in varchar2 default null,
180 p_business_group_id in number default null,
181 p_1_approved_flag in varchar2 default null,
182 p_1_user_name_acted_on in varchar2 default null,
183 p_1_action_taken in varchar2 default null,
184 p_2_user_name_routed_to in varchar2 default null,
185 p_2_groupbox_id in number default null,
186 p_2_routing_list_id in number default null,
187 p_2_routing_seq_number in number default null,
188 p_1_pd_routing_history_id out nocopy number,
189 p_1_pdh_object_version_number out nocopy number,
190 p_2_pdh_object_version_number out nocopy number,
191 p_2_pd_routing_history_id out nocopy number,
192 p_pdi_object_version_number out nocopy number);
193 --
194 -- ----------------------------------------------------------------------------
195 -- |--------------------------------< update_pdi >----------------------------|
196 -- ----------------------------------------------------------------------------
197 --
198 -- {Start Of Comments}
199 /*#
200 * This API updates the Position Description.
201 *
202 * This API updates the Position Description record in the
203 * GHR_POSITION_DESCRIPTIONS
204 *
205 * <p><b>Licensing</b><br>
206 * This API is licensed for use with Human Resources.
207 *
208 * <p><b>Prerequisites</b><br>
209 * A valid Position Description id needs to be passed.
210 *
211 * <p><b>Post Success</b><br>
215 * An application error is raised and processing is terminated
212 * Position Description record is updated.
213 *
214 * <p><b>Post Failure</b><br>
216 * @param p_validate If true, then validation alone will be performed and the
217 * database will remain unchanged. If false and all validation checks pass,
218 * then the database will be modified.
219 * @param p_position_description_id Identifies the Position Description record
220 * to be modified.
221 * @param p_routing_grp_id {@rep:casecolumn
222 * GHR_ROUTING_GROUPS.ROUTING_GROUP_ID}
223 * @param p_date_from The date on which the Position Description becomes
224 * effective.
225 * @param p_date_to The date after which the Position Description is no longer
226 * effective.
227 * @param p_opm_cert_num Office of Personnel Management certification number.
228 * @param p_flsa FLSA Category. Valid Values are defined by
229 * 'GHR_US_FLSA_CATEGORY' Lookup Type
230 * @param p_financial_statement Financial Statement Required. Valid Values are
231 * defined by 'GHR_US_FINANCIAL_STATEMENT' Lookup Type.
232 * @param p_subject_to_ia_action Indicates whether the position is subject to
233 * IA action. Valid Values are Y - Yes, N - No.
234 * @param p_position_status Position Status. Valid Values are defined by
235 * 'GHR_US_POSITION_OCCUPIED' Lookup Type.
236 * @param p_position_is Supervisory Status. Valid Values are defined by
237 * 'GHR_US_SUPERVISORY_STATUS' Lookup Type.
238 * @param p_position_sensitivity Position Sensitivity. Valid Values are defined
239 * by 'GHR_US_POSN_SENSITIVITY' Lookup Type.
240 * @param p_competitive_level {@rep:casecolumn
241 * GHR_POSITION_DESCRIPTIONS.COMPETITIVE_LEVEL}
242 * @param p_pd_remarks Remarks
243 * @param p_position_class_std Position classification standards
244 * @param p_category Category Code. Valid Values are A - Active, I - Inactive,
245 * S - Standard, C - Cancelled
246 * @param p_career_ladder Indicates whether the position is part of a career
247 * ladder. Valid Values are Y - Yes, N - No
248 * @param p_supervisor_name Supervisor's name
249 * @param p_supervisor_title Supervisor's title
250 * @param p_supervisor_date Date of Supervisor's authorization
251 * @param p_manager_name Manager's name
252 * @param p_manager_title Manager's title
253 * @param p_manager_date Date of Manager's authorization
254 * @param p_classifier_name Classifier's name
255 * @param p_classifier_title Classifier's title
256 * @param p_classifier_date Date on Classifier's authorization
257 * @param p_attribute_category This context value determines which flexfield
258 * structure to use with the descriptive flexfield segments.
259 * @param p_attribute1 Descriptive flexfield segment.
260 * @param p_attribute2 Descriptive flexfield segment.
261 * @param p_attribute3 Descriptive flexfield segment.
262 * @param p_attribute4 Descriptive flexfield segment.
263 * @param p_attribute5 Descriptive flexfield segment.
264 * @param p_attribute6 Descriptive flexfield segment.
265 * @param p_attribute7 Descriptive flexfield segment.
266 * @param p_attribute8 Descriptive flexfield segment.
267 * @param p_attribute9 Descriptive flexfield segment.
268 * @param p_attribute10 Descriptive flexfield segment.
269 * @param p_attribute11 Descriptive flexfield segment.
270 * @param p_attribute12 Descriptive flexfield segment.
271 * @param p_attribute13 Descriptive flexfield segment.
272 * @param p_attribute14 Descriptive flexfield segment.
273 * @param p_attribute15 Descriptive flexfield segment.
274 * @param p_attribute16 Descriptive flexfield segment.
275 * @param p_attribute17 Descriptive flexfield segment.
276 * @param p_attribute18 Descriptive flexfield segment.
277 * @param p_attribute19 Descriptive flexfield segment.
278 * @param p_attribute20 Descriptive flexfield segment.
279 * @param p_business_group_id Business Group of Record
280 * @param p_u_approved_flag Position Description approved flag.
281 * @param p_u_user_name_acted_on Application User Name
282 * @param p_u_action_taken Action taken. Valid Values are AUTHORIZED, CANCELED,
283 * CLASSIFIED, INITIATED, NOT_ROUTED, NO_ACTION, RECLASSIFIED, REOPENED,
284 * REQUESTED, REVIEWED
285 * @param p_i_user_name_routed_to Application User Name
286 * @param p_i_groupbox_id {@rep:casecolumn GHR_GROUPBOXES.GROUPBOX_ID}
287 * @param p_i_routing_list_id {@rep:casecolumn
288 * GHR_ROUTING_LISTS.ROUTING_LIST_ID}
289 * @param p_i_routing_seq_number {@rep:casecolumn
290 * GHR_ROUTING_LIST_MEMBERS.SEQ_NUMBER}
291 * @param p_u_pdh_object_version_number Pass in the current version number of
292 * the Position Description History that you are updating. When the API
293 * completes, if p_validate is false, sets the new version number of the
294 * updated Position Description History. If p_validate is true, sets the same
295 * value passed in.
296 * @param p_i_pd_routing_history_id {@rep:casecolumn
297 * GHR_PD_ROUTING_HISTORY.PD_ROUTING_HISTORY_ID}
298 * @param p_i_pdh_object_version_number If p_validate is false, then sets the
299 * version number of the created Position Description History. If p_validate is
300 * true, then the value is null.
301 * @param p_o_pd_routing_history_id If p_validate is false, then this uniquely
302 * identifies the Position Description Routing History created. If p_validate
303 * is true, then set to null.
304 * @param p_o_pdh_object_version_number If p_validate is false, then sets the
305 * version number of the created Position Description History. If p_validate is
306 * true, then the value is null.
307 * @param p_pdi_object_version_number Pass in the current version number of the
308 * Position Description that you are updating. When the API completes, if
309 * p_validate is false, sets the new version number of the updated Position
310 * Description. If p_validate is true, sets the same value passed in.
311 * @rep:displayname Update Federal Position Description
312 * @rep:category BUSINESS_ENTITY GHR_POSITION_DESCRIPTION
313 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
314 * @rep:scope public
315 * @rep:lifecycle active
316 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
317 */
318 --
319 -- {End Of Comments}
320 --
321 PROCEDURE update_pdi
322 (
323 p_validate IN BOOLEAN default false,
324 p_position_description_id IN number,
325 p_routing_grp_id IN number default hr_api.g_number,
326 p_date_from IN date,
327 p_date_to IN date default hr_api.g_date,
328 p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
329 p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
330 p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331 p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332 p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333 p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334 p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335 p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336 p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337 p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
338 p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
339 p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
340 p_supervisor_name in varchar2 default hr_api.g_varchar2,
341 p_supervisor_title in varchar2 default hr_api.g_varchar2,
342 p_supervisor_date in date default hr_api.g_date,
343 p_manager_name in varchar2 default hr_api.g_varchar2,
344 p_manager_title in varchar2 default hr_api.g_varchar2,
345 p_manager_date in date default hr_api.g_date,
346 p_classifier_name in varchar2 default hr_api.g_varchar2,
347 p_classifier_title in varchar2 default hr_api.g_varchar2,
348 p_classifier_date in date default hr_api.g_date,
349 p_attribute_category in varchar2 default hr_api.g_varchar2,
350 p_attribute1 in varchar2 default hr_api.g_varchar2,
351 p_attribute2 in varchar2 default hr_api.g_varchar2,
352 p_attribute3 in varchar2 default hr_api.g_varchar2,
353 p_attribute4 in varchar2 default hr_api.g_varchar2,
354 p_attribute5 in varchar2 default hr_api.g_varchar2,
355 p_attribute6 in varchar2 default hr_api.g_varchar2,
356 p_attribute7 in varchar2 default hr_api.g_varchar2,
357 p_attribute8 in varchar2 default hr_api.g_varchar2,
358 p_attribute9 in varchar2 default hr_api.g_varchar2,
359 p_attribute10 in varchar2 default hr_api.g_varchar2,
360 p_attribute11 in varchar2 default hr_api.g_varchar2,
361 p_attribute12 in varchar2 default hr_api.g_varchar2,
362 p_attribute13 in varchar2 default hr_api.g_varchar2,
363 p_attribute14 in varchar2 default hr_api.g_varchar2,
364 p_attribute15 in varchar2 default hr_api.g_varchar2,
365 p_attribute16 in varchar2 default hr_api.g_varchar2,
366 p_attribute17 in varchar2 default hr_api.g_varchar2,
367 p_attribute18 in varchar2 default hr_api.g_varchar2,
368 p_attribute19 in varchar2 default hr_api.g_varchar2,
369 p_attribute20 in varchar2 default hr_api.g_varchar2,
370 p_business_group_id in number default hr_api.g_number,
371 p_u_approved_flag in varchar2 default hr_api.g_varchar2,
372 p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
373 p_u_action_taken in varchar2 default null,
374 p_i_user_name_routed_to in varchar2 default null,
375 p_i_groupbox_id in number default null,
376 p_i_routing_list_id in number default null,
377 p_i_routing_seq_number in number default null,
378 p_u_pdh_object_version_number in out nocopy number,
379 p_i_pd_routing_history_id out nocopy number,
380 p_i_pdh_object_version_number out nocopy number,
381 p_o_pd_routing_history_id out nocopy number,
382
383 p_o_pdh_object_version_number out nocopy number,
384
385 p_pdi_object_version_number in out nocopy number);
386
387 procedure call_workflow
388 (
389 p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
390 p_action_taken IN ghr_pd_routing_history.action_taken%TYPE
391 );
392 end ghr_pdi_api;