1 PACKAGE hr_dk_assignment_api AUTHID CURRENT_USER AS
2 /* $Header: peasgdki.pkh 120.2.12000000.2 2007/05/08 07:24:18 saurai ship $ */
3 /*#
4 * This package contains assignment APIs for Denmark.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Assignment for Denmark
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_dk_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates additional non-primary assignments for an existing employee
17 * in the Denmark business group.
18 *
19 * This API creates additional non-primary assignments for an existing employee
20 * in the Denmark business group. It calls create_secondary_emp_asg. You cannot
21 * use this API to create the primary assignment. The primary assignment is
22 * created when you create the employee.
23 *
24 * <p><b>Licensing</b><br>
25 * This API is licensed for use with Human Resources.
26 *
27 * <p><b>Prerequisites</b><br>
28 * The person and the organization must exist on the effective date.
29 *
30 * <p><b>Post Success</b><br>
31 * A new secondary assignment is successfully created for the employee in the
32 * database.
33 *
34 * <p><b>Post Failure</b><br>
35 * The API does not create the assignment and raises an error.
36 *
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_effective_date Determines when the DateTrack operation comes into
41 * force.
42 * @param p_person_id Identifies the person for whom you create the secondary
43 * assignment record.
44 * @param p_organization_id Identifies the organization of the secondary
45 * assignment.
46 * @param p_grade_id Identifies the grade of the secondary assignment.
47 * @param p_position_id Identifies the position of the secondary assignment.
48 * @param p_job_id Identifies the job of the secondary assignment.
49 * @param p_assignment_status_type_id Identifies the assignment status of the
50 * secondary assignment. Valid values are defined by the 'PER_ASS_SYS_STATUS'
51 * lookup type.
52 * @param p_payroll_id Identifies the payroll for the secondary assignment.
53 * @param p_location_id Identifies the location of the secondary assignment.
54 * @param p_supervisor_id Identifies the supervisor for the secondary
55 * assignment. The value refers to the supervisor's person record.
56 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
57 * associated with the grade of the secondary assignment.
58 * @param p_pay_basis_id Salary basis for the secondary assignment.
59 * @param p_assignment_number If a value is passed in, this is used as the
60 * assignment number. If no value is passed in, an assignment number is
61 * generated.
62 * @param p_change_reason Reason for the assignment status change. If there is
63 * no change reason the parameter can be null. Valid values are defined in the
64 * 'EMP_ASSIGN_REASON' lookup type.
65 * @param p_comments Comment text.
66 * @param p_date_probation_end End date of probation period.
67 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
68 * flexfield combination that applies to this assignment.
69 * @param p_employment_category Employment category of the assignment. Valid
70 * values are defined in the 'EMP_CAT' lookup type.
71 * @param p_frequency Frequency associated with the defined normal working
72 * hours. Valid values are defined in the 'FREQUENCY' lookup type.
73 * @param p_internal_address_line Internal address identified with the
74 * secondary assignment.
75 * @param p_manager_flag Indicates whether the employee is a manager.
76 * @param p_normal_hours Normal working hours for this assignment.
77 * @param p_perf_review_period Length of performance review period.
78 * @param p_perf_review_period_frequency Units of performance review period.
79 * Valid values are defined in the 'FREQUENCY' lookup type.
80 * @param p_probation_period Length of probation period
81 * @param p_probation_unit Units of probation period. Valid values are defined
82 * in the 'QUALIFYING_UNITS' lookup type.
83 * @param p_sal_review_period Length of salary review period.
84 * @param p_sal_review_period_frequency Units of salary review period. Valid
85 * values are defined in the 'FREQUENCY' lookup type.
86 * @param p_set_of_books_id Identifies General Ledger set of books.
87 * @param p_source_type Recruitment activity which this assignment is sourced
88 * from. Valid values are defined in the 'REC_TYPE' lookup type.
89 * @param p_time_normal_finish Normal work finish time.
90 * @param p_time_normal_start Normal work start time.
91 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
92 * defined in the 'BARGAINING_UNIT_CODE' lookup type.
93 * @param p_labour_union_member_flag Indicates whether the employee is a labour
94 * union member. A value 'Y' indicates that the employee is a labour union
95 * member.
96 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
97 * is salaried. Valid values are defined in the 'HOURLY_SALARIED_CODE' lookup
98 * type.
99 * @param p_ass_attribute_category This context value determines which
100 * flexfield structure to use with the descriptive flexfield segments.
101 * @param p_ass_attribute1 Descriptive flexfield segment.
102 * @param p_ass_attribute2 Descriptive flexfield segment.
103 * @param p_ass_attribute3 Descriptive flexfield segment.
104 * @param p_ass_attribute4 Descriptive flexfield segment.
105 * @param p_ass_attribute5 Descriptive flexfield segment.
106 * @param p_ass_attribute6 Descriptive flexfield segment.
107 * @param p_ass_attribute7 Descriptive flexfield segment.
108 * @param p_ass_attribute8 Descriptive flexfield segment.
109 * @param p_ass_attribute9 Descriptive flexfield segment.
110 * @param p_ass_attribute10 Descriptive flexfield segment.
111 * @param p_ass_attribute11 Descriptive flexfield segment.
112 * @param p_ass_attribute12 Descriptive flexfield segment.
113 * @param p_ass_attribute13 Descriptive flexfield segment.
114 * @param p_ass_attribute14 Descriptive flexfield segment.
115 * @param p_ass_attribute15 Descriptive flexfield segment.
116 * @param p_ass_attribute16 Descriptive flexfield segment.
117 * @param p_ass_attribute17 Descriptive flexfield segment.
118 * @param p_ass_attribute18 Descriptive flexfield segment.
119 * @param p_ass_attribute19 Descriptive flexfield segment.
120 * @param p_ass_attribute20 Descriptive flexfield segment.
121 * @param p_ass_attribute21 Descriptive flexfield segment.
122 * @param p_ass_attribute22 Descriptive flexfield segment.
123 * @param p_ass_attribute23 Descriptive flexfield segment.
124 * @param p_ass_attribute24 Descriptive flexfield segment.
125 * @param p_ass_attribute25 Descriptive flexfield segment.
126 * @param p_ass_attribute26 Descriptive flexfield segment.
127 * @param p_ass_attribute27 Descriptive flexfield segment.
128 * @param p_ass_attribute28 Descriptive flexfield segment.
129 * @param p_ass_attribute29 Descriptive flexfield segment.
130 * @param p_ass_attribute30 Descriptive flexfield segment.
131 * @param p_title Obsolete parameter, do not use.
132 * @param p_legal_entity Legal Entity of the assignment. Valid values are
133 * defined in the 'HR_DK_LEGAL_ENTITY' lookup type.
134 * @param p_cond_of_emp Employee Category. Valid values are defined in the
135 * lookup type 'DK_COND_OF_EMP'
136 * @param p_emp_group Employee type. Valid values are defined in the
137 * 'DK_EMP_TYPE' lookup type
138 * @param p_union_membership Union membership. Valid values are defined in the
139 * 'DK_UNION_MEMBERSHIP' lookup type.
140 * @param p_termination_reason Reason for terminating the assignment.
141 * @param p_notified_date Notified date.
142 * @param p_termination_date Termination date.
143 * @param p_adjusted_seniority_date Adjusted seniority date.
144 * @param p_default_work_pattern Default Work Pattern for Holiday Entitlement
145 * Valid values are defined in the Value set 'DK_WORK_PATTERNS'
146 * @param p_hourly_accrual_rate Hourly Accrual Rate for Holiday Entitlement
147 * Valid values are defined in the Value set 'HR_DK_2_DIGIT'
148 * @param p_accrual_type Accrual Type for Holiday Entitlement
149 * Valid values are defined in the Value set 'DK_ACCRUAL_TYPES'
150 * @param p_salaried_allowance_rate Salaried Allowance Rate for Holiday Entitlement
151 * Valid values are defined in the Value set 'HR_DK_2_DIGIT'
152 * @param p_job_occupation_employee_code Job Occupation Employee Code for DA Office codes
153 * Valid values are defined in the Value set 'HR_DK_JOB_OCC_MKODE'
154 * @param p_job_status_employee_code Job Status Employee Code for DA Office codes
155 * Valid values are defined in the Value set 'HR_DK_JOB_STATUS_MKODE'
156 * @param p_salary_basis_employee_code Salary Basis Employee Code for DA Office codes
157 * Valid values are defined in the Value set 'HR_DK_SALARY_BASIS_MKODE'
158 * @param p_time_off_in_lieu Time Off in Lieu for DA Office codes
159 * Valid values are defined in the Value set 'HR_DK_YES_NO'
160 * @param p_section_28_registration Section 28 Registration for Sick Pay Defaults
161 * Valid values are defined in the Value set 'HR_DK_YES_NO'
162 * @param p_pgp_segment1 People group key flexfield segment.
163 * @param p_pgp_segment2 People group key flexfield segment.
164 * @param p_pgp_segment3 People group key flexfield segment.
165 * @param p_pgp_segment4 People group key flexfield segment.
166 * @param p_pgp_segment5 People group key flexfield segment.
167 * @param p_pgp_segment6 People group key flexfield segment.
168 * @param p_pgp_segment7 People group key flexfield segment.
169 * @param p_pgp_segment8 People group key flexfield segment.
170 * @param p_pgp_segment9 People group key flexfield segment.
171 * @param p_pgp_segment10 People group key flexfield segment.
172 * @param p_pgp_segment11 People group key flexfield segment.
173 * @param p_pgp_segment12 People group key flexfield segment.
174 * @param p_pgp_segment13 People group key flexfield segment.
175 * @param p_pgp_segment14 People group key flexfield segment.
176 * @param p_pgp_segment15 People group key flexfield segment.
177 * @param p_pgp_segment16 People group key flexfield segment.
178 * @param p_pgp_segment17 People group key flexfield segment.
179 * @param p_pgp_segment18 People group key flexfield segment.
180 * @param p_pgp_segment19 People group key flexfield segment.
181 * @param p_pgp_segment20 People group key flexfield segment.
182 * @param p_pgp_segment21 People group key flexfield segment.
183 * @param p_pgp_segment22 People group key flexfield segment.
184 * @param p_pgp_segment23 People group key flexfield segment.
185 * @param p_pgp_segment24 People group key flexfield segment.
186 * @param p_pgp_segment25 People group key flexfield segment.
187 * @param p_pgp_segment26 People group key flexfield segment.
188 * @param p_pgp_segment27 People group key flexfield segment.
189 * @param p_pgp_segment28 People group key flexfield segment.
190 * @param p_pgp_segment29 People group key flexfield segment.
191 * @param p_pgp_segment30 People group key flexfield segment.
192 * @param p_pgp_concat_segments Concatenated segments for People Group Key
193 * Flexfield. Concatenated segments can be supplied instead of individual
194 * segments.
195 * @param p_assignment_id If p_validate is false, then this uniquely identifies
196 * the created secondary assignment. If p_validate is true, then set to null.
197 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
198 * it identifies an existing Soft Coded Key Flexfield combination to associate
199 * with the assignment, and segment values are ignored. If a value is not
200 * passed in, then the individual Soft Coded Key Flexfield segments supplied
201 * will be used to choose an existing combination or create a new combination.
202 * When the API completes, if p_validate is false, then this uniquely
203 * identifies the associated combination of the Soft Coded Key flexfield for
204 * this assignment. If p_validate is true, then set to null.
205 * @param p_people_group_id If a value is passed in for this parameter, it
206 * identifies an existing People Group Key Flexfield combination to associate
207 * with the assignment, and segment values are ignored. If a value is not
208 * passed in, then the individual People Group Key Flexfield segments supplied
209 * will be used to choose an existing combination or create a new combination.
210 * When the API completes, if p_validate is false, then this uniquely
211 * identifies the associated combination of the People Group Key flexfield for
212 * this assignment. If p_validate is true, then set to null.
213 * @param p_object_version_number If p_validate is false, then set to the
214 * version number of the created secondary assignment. If p_validate is true,
215 * then the value will be null.
216 * @param p_effective_start_date If p_validate is false, then set to the
217 * earliest effective start date for the created secondary assignment. If
218 * p_validate is true, then set to null.
219 * @param p_effective_end_date If p_validate is false, then set to the
220 * effective end date for the created secondary assignment. If p_validate is
221 * true, then set to null.
222 * @param p_assignment_sequence If p_validate is false, then an automatically
223 * incremented number is associated with this assignment, depending on the
224 * number of assignment which already exist. If p_validate is true, then set to
225 * null.
226 * @param p_comment_id If p_validate is false and comment text was provided,
227 * then will be set to the identifier of the created secondary assignment
228 * comment record. If p_validate is true or no comment text was provided, then
229 * will be null.
230 * @param p_concatenated_segments If p_validate is false, set to soft coded key
231 * flexfield concatenated segments. If p_validate is true, set to null.
232 * @param p_group_name If p_validate is false, set to the people group key
233 * flexfield concatenated segments. If p_validate is true, set to null.
234 * @param p_other_manager_warning If set to true, then a manager existed in the
235 * organization prior to calling this API and the manager flag has been set to
236 * 'Y' for yes.
237 * @rep:displayname Create Secondary Employee Assignment for Denmark
238 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
239 * @rep:lifecycle active
240 * @rep:scope public
241 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
242 */
243 --
244 -- {End Of Comments}
245 --
246 PROCEDURE create_dk_secondary_emp_asg
247 (p_validate IN BOOLEAN DEFAULT FALSE
248 ,p_effective_date IN DATE
249 ,p_person_id IN NUMBER
250 ,p_organization_id IN NUMBER
251 ,p_grade_id IN NUMBER DEFAULT NULL
252 ,p_position_id IN NUMBER DEFAULT NULL
253 ,p_job_id IN NUMBER DEFAULT NULL
254 ,p_assignment_status_type_id IN NUMBER DEFAULT NULL
255 ,p_payroll_id IN NUMBER DEFAULT NULL
256 ,p_location_id IN NUMBER DEFAULT NULL
257 ,p_supervisor_id IN NUMBER DEFAULT NULL
258 ,p_special_ceiling_step_id IN NUMBER DEFAULT NULL
259 ,p_pay_basis_id IN NUMBER DEFAULT NULL
260 ,p_assignment_number IN OUT NOCOPY VARCHAR2
261 ,p_change_reason IN VARCHAR2 DEFAULT NULL
262 ,p_comments IN VARCHAR2 DEFAULT NULL
263 ,p_date_probation_end IN DATE DEFAULT NULL
264 ,p_default_code_comb_id IN NUMBER DEFAULT NULL
265 ,p_employment_category IN VARCHAR2 DEFAULT NULL
266 ,p_frequency IN VARCHAR2 DEFAULT NULL
267 ,p_internal_address_line IN VARCHAR2 DEFAULT NULL
268 ,p_manager_flag IN VARCHAR2 DEFAULT NULL
269 ,p_normal_hours IN NUMBER DEFAULT NULL
270 ,p_perf_review_period IN NUMBER DEFAULT NULL
271 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT NULL
272 ,p_probation_period IN NUMBER DEFAULT NULL
273 ,p_probation_unit IN VARCHAR2 DEFAULT NULL
274 ,p_sal_review_period IN NUMBER DEFAULT NULL
275 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT NULL
276 ,p_set_of_books_id IN NUMBER DEFAULT NULL
277 ,p_source_type IN VARCHAR2 DEFAULT NULL
278 ,p_time_normal_finish IN VARCHAR2 DEFAULT NULL
279 ,p_time_normal_start IN VARCHAR2 DEFAULT NULL
280 ,p_bargaining_unit_code in varchar2 default null
281 ,p_labour_union_member_flag in varchar2 default 'N'
282 ,p_hourly_salaried_code in varchar2 default null
283 ,p_ass_attribute_category IN VARCHAR2 DEFAULT NULL
284 ,p_ass_attribute1 IN VARCHAR2 DEFAULT NULL
285 ,p_ass_attribute2 IN VARCHAR2 DEFAULT NULL
286 ,p_ass_attribute3 IN VARCHAR2 DEFAULT NULL
287 ,p_ass_attribute4 IN VARCHAR2 DEFAULT NULL
288 ,p_ass_attribute5 IN VARCHAR2 DEFAULT NULL
289 ,p_ass_attribute6 IN VARCHAR2 DEFAULT NULL
290 ,p_ass_attribute7 IN VARCHAR2 DEFAULT NULL
291 ,p_ass_attribute8 IN VARCHAR2 DEFAULT NULL
292 ,p_ass_attribute9 IN VARCHAR2 DEFAULT NULL
293 ,p_ass_attribute10 IN VARCHAR2 DEFAULT NULL
294 ,p_ass_attribute11 IN VARCHAR2 DEFAULT NULL
295 ,p_ass_attribute12 IN VARCHAR2 DEFAULT NULL
296 ,p_ass_attribute13 IN VARCHAR2 DEFAULT NULL
297 ,p_ass_attribute14 IN VARCHAR2 DEFAULT NULL
298 ,p_ass_attribute15 IN VARCHAR2 DEFAULT NULL
299 ,p_ass_attribute16 IN VARCHAR2 DEFAULT NULL
300 ,p_ass_attribute17 IN VARCHAR2 DEFAULT NULL
301 ,p_ass_attribute18 IN VARCHAR2 DEFAULT NULL
302 ,p_ass_attribute19 IN VARCHAR2 DEFAULT NULL
303 ,p_ass_attribute20 IN VARCHAR2 DEFAULT NULL
304 ,p_ass_attribute21 IN VARCHAR2 DEFAULT NULL
305 ,p_ass_attribute22 IN VARCHAR2 DEFAULT NULL
306 ,p_ass_attribute23 IN VARCHAR2 DEFAULT NULL
307 ,p_ass_attribute24 IN VARCHAR2 DEFAULT NULL
308 ,p_ass_attribute25 IN VARCHAR2 DEFAULT NULL
309 ,p_ass_attribute26 IN VARCHAR2 DEFAULT NULL
310 ,p_ass_attribute27 IN VARCHAR2 DEFAULT NULL
311 ,p_ass_attribute28 IN VARCHAR2 DEFAULT NULL
312 ,p_ass_attribute29 IN VARCHAR2 DEFAULT NULL
313 ,p_ass_attribute30 IN VARCHAR2 DEFAULT NULL
314 ,p_title IN VARCHAR2 DEFAULT NULL
315 ,p_legal_entity IN VARCHAR2 DEFAULT NULL
316 --,p_pension_provider IN VARCHAR2 DEFAULT NULL Removed from assignment level and it's captured at Element entry level
317 ,p_cond_of_emp IN VARCHAR2 DEFAULT NULL -- Condition of Employment
318 ,p_emp_group IN VARCHAR2 DEFAULT NULL -- Employee Group
319 ,p_union_membership IN VARCHAR2 DEFAULT NULL -- Union Membership
320 ,p_termination_reason IN VARCHAR2 DEFAULT NULL
321 ,p_notified_date IN DATE DEFAULT NULL
322 ,p_termination_date IN DATE DEFAULT NULL
323 ,p_adjusted_seniority_date IN DATE DEFAULT NULL
324 ,p_default_work_pattern IN VARCHAR2 DEFAULT NULL -- Holiday Entitlement
325 ,p_hourly_accrual_rate IN NUMBER DEFAULT NULL -- Holiday Entitlement
326 ,p_accrual_type IN VARCHAR2 DEFAULT NULL -- Holiday Entitlement
327 ,p_salaried_allowance_rate IN NUMBER DEFAULT NULL -- Holiday Entitlement
328 ,p_job_occupation_employee_code IN VARCHAR2 DEFAULT NULL -- DA Office codes
329 ,p_job_status_employee_code IN VARCHAR2 DEFAULT NULL -- DA Office codes
330 ,p_salary_basis_employee_code IN VARCHAR2 DEFAULT NULL -- DA Office codes
331 ,p_time_off_in_lieu IN VARCHAR2 DEFAULT NULL -- DA Office codes
332 ,p_section_28_registration IN VARCHAR2 DEFAULT NULL -- Sick Pay Defaults
333 ,p_pgp_segment1 IN VARCHAR2 DEFAULT NULL
334 ,p_pgp_segment2 IN VARCHAR2 DEFAULT NULL
335 ,p_pgp_segment3 IN VARCHAR2 DEFAULT NULL
336 ,p_pgp_segment4 IN VARCHAR2 DEFAULT NULL
337 ,p_pgp_segment5 IN VARCHAR2 DEFAULT NULL
338 ,p_pgp_segment6 IN VARCHAR2 DEFAULT NULL
339 ,p_pgp_segment7 IN VARCHAR2 DEFAULT NULL
340 ,p_pgp_segment8 IN VARCHAR2 DEFAULT NULL
341 ,p_pgp_segment9 IN VARCHAR2 DEFAULT NULL
342 ,p_pgp_segment10 IN VARCHAR2 DEFAULT NULL
343 ,p_pgp_segment11 IN VARCHAR2 DEFAULT NULL
344 ,p_pgp_segment12 IN VARCHAR2 DEFAULT NULL
345 ,p_pgp_segment13 IN VARCHAR2 DEFAULT NULL
346 ,p_pgp_segment14 IN VARCHAR2 DEFAULT NULL
347 ,p_pgp_segment15 IN VARCHAR2 DEFAULT NULL
348 ,p_pgp_segment16 IN VARCHAR2 DEFAULT NULL
349 ,p_pgp_segment17 IN VARCHAR2 DEFAULT NULL
350 ,p_pgp_segment18 IN VARCHAR2 DEFAULT NULL
351 ,p_pgp_segment19 IN VARCHAR2 DEFAULT NULL
352 ,p_pgp_segment20 IN VARCHAR2 DEFAULT NULL
353 ,p_pgp_segment21 IN VARCHAR2 DEFAULT NULL
354 ,p_pgp_segment22 IN VARCHAR2 DEFAULT NULL
355 ,p_pgp_segment23 IN VARCHAR2 DEFAULT NULL
356 ,p_pgp_segment24 IN VARCHAR2 DEFAULT NULL
357 ,p_pgp_segment25 IN VARCHAR2 DEFAULT NULL
358 ,p_pgp_segment26 IN VARCHAR2 DEFAULT NULL
359 ,p_pgp_segment27 IN VARCHAR2 DEFAULT NULL
360 ,p_pgp_segment28 IN VARCHAR2 DEFAULT NULL
361 ,p_pgp_segment29 IN VARCHAR2 DEFAULT NULL
362 ,p_pgp_segment30 IN VARCHAR2 DEFAULT NULL
363 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT NULL
364 ,p_assignment_id OUT NOCOPY NUMBER
365 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
366 ,p_people_group_id OUT NOCOPY NUMBER
367 ,p_object_version_number OUT NOCOPY NUMBER
368 ,p_effective_start_date OUT NOCOPY DATE
369 ,p_effective_end_date OUT NOCOPY DATE
370 ,p_assignment_sequence OUT NOCOPY NUMBER
371 ,p_comment_id OUT NOCOPY NUMBER
372 ,p_concatenated_segments OUT NOCOPY VARCHAR2
373 ,p_group_name OUT NOCOPY VARCHAR2
374 ,p_other_manager_warning OUT NOCOPY BOOLEAN
375 );
376 --
377 -- ----------------------------------------------------------------------------
378 -- |----------------------------< update_dk_emp_asg >-------------------------|
379 -- ----------------------------------------------------------------------------
380 --
381 -- {Start Of Comments}
382 /*#
383 * This API updates employee assignment details which do not affect entitlement
384 * to element entries.
385 *
386 * This API is effectively an alternative to the API update_emp_asg. If
387 * p_validate is set to false, then the assignment record is updated. Also,
388 * this API updates an employee assignment status. The new status must have a
389 * system status of ACTIVE_ASSIGN. If the assignment status is already a type
390 * of ACTIVE_ASSIGN, this API can be used to set a different active status. If
391 * the calling routine does not explicitly pass in a status, the API uses the
392 * default ACTIVE_ASSIGN status for the assignment's business group. Note: Only
393 * employee assignments can be altered with this API. Updates to an applicant
394 * assignment status are not allowed.
395 *
396 * <p><b>Licensing</b><br>
397 * This API is licensed for use with Human Resources.
398 *
399 * <p><b>Prerequisites</b><br>
400 * The assignment must exist as of the effective date and must be an employee
401 * assignment.
402 *
403 * <p><b>Post Success</b><br>
404 * The API updates the assignment record in the database.
405 *
406 * <p><b>Post Failure</b><br>
407 * The API does not update the assignment record and raises an error.
408 *
409 * @param p_validate If true, then validation alone will be performed and the
410 * database will remain unchanged. If false and all validation checks pass,
411 * then the database will be modified.
412 * @param p_effective_date Determines when the DateTrack operation comes into
413 * force.
414 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
415 * updating the record. You must set to either UPDATE, CORRECTION,
416 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
417 * particular record depend on the dates of previous record changes and the
418 * effective date of this change.
419 * @param p_assignment_id Identifies the assignment record to modify.
420 * @param p_object_version_number Pass in the current version number of the
421 * assignment to be updated. When the API completes if p_validate is false,
422 * will be set to the new version number of the updated assignment. If
423 * p_validate is true will be set to the same value which was passed in.
424 * @param p_supervisor_id Supervisor for the assignment. The value refers to
425 * the supervisor's person record.
426 * @param p_assignment_number Assignment number.
427 * @param p_change_reason Reason for the assignment status change. If there is
428 * no change reason, then the parameter can be null. Valid values are defined
429 * in the 'EMP_ASSIGN_REASON' lookup type.
430 * @param p_comments Comment text.
431 * @param p_date_probation_end End date of probation period.
432 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
433 * Flexfield combination that applies to this assignment.
434 * @param p_frequency Frequency associated with the defined normal working
435 * hours. Valid values are defined in the 'FREQUENCY' lookup type.
436 * @param p_internal_address_line Internal address identified with this
437 * assignment.
438 * @param p_manager_flag Indicates whether the employee is a manager.
439 * @param p_normal_hours Normal working hours for this assignment.
440 * @param p_perf_review_period Length of performance review period.
441 * @param p_perf_review_period_frequency Units of performance review period.
442 * Valid values are defined in the 'FREQUENCY' lookup type.
443 * @param p_probation_period Length of probation period.
444 * @param p_probation_unit Units of probation period. Valid values are defined
445 * in the 'QUALIFYING_UNITS' lookup type.
446 * @param p_sal_review_period Length of salary review period.
447 * @param p_sal_review_period_frequency Units of salary review period. Valid
448 * values are defined in the 'FREQUENCY' lookup type.
449 * @param p_set_of_books_id Identifies General Ledger set of books.
450 * @param p_source_type Recruitment activity which this assignment is sourced
451 * from. Valid values are defined in the 'REC_TYPE' lookup type.
452 * @param p_time_normal_finish Normal work finish time.
453 * @param p_time_normal_start Normal work start time.
454 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
455 * defined in the 'BARGAINING_UNIT_CODE' lookup type.
456 * @param p_labour_union_member_flag Indicates whether the employee is a labour
457 * union member. A value 'Y' indicates that the employee is a labour union
458 * member.
459 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
460 * is salaried. Valid values defined in the 'HOURLY_SALARIED_CODE' lookup type.
461 * @param p_ass_attribute_category This context value determines which
462 * flexfield structure to use with the descriptive flexfield segments.
463 * @param p_ass_attribute1 Descriptive flexfield segment.
464 * @param p_ass_attribute2 Descriptive flexfield segment.
465 * @param p_ass_attribute3 Descriptive flexfield segment.
466 * @param p_ass_attribute4 Descriptive flexfield segment.
467 * @param p_ass_attribute5 Descriptive flexfield segment.
468 * @param p_ass_attribute6 Descriptive flexfield segment.
469 * @param p_ass_attribute7 Descriptive flexfield segment.
470 * @param p_ass_attribute8 Descriptive flexfield segment.
471 * @param p_ass_attribute9 Descriptive flexfield segment.
472 * @param p_ass_attribute10 Descriptive flexfield segment.
473 * @param p_ass_attribute11 Descriptive flexfield segment.
474 * @param p_ass_attribute12 Descriptive flexfield segment.
475 * @param p_ass_attribute13 Descriptive flexfield segment.
476 * @param p_ass_attribute14 Descriptive flexfield segment.
477 * @param p_ass_attribute15 Descriptive flexfield segment.
478 * @param p_ass_attribute16 Descriptive flexfield segment.
479 * @param p_ass_attribute17 Descriptive flexfield segment.
480 * @param p_ass_attribute18 Descriptive flexfield segment.
481 * @param p_ass_attribute19 Descriptive flexfield segment.
482 * @param p_ass_attribute20 Descriptive flexfield segment.
483 * @param p_ass_attribute21 Descriptive flexfield segment.
484 * @param p_ass_attribute22 Descriptive flexfield segment.
485 * @param p_ass_attribute23 Descriptive flexfield segment.
486 * @param p_ass_attribute24 Descriptive flexfield segment.
487 * @param p_ass_attribute25 Descriptive flexfield segment.
488 * @param p_ass_attribute26 Descriptive flexfield segment.
489 * @param p_ass_attribute27 Descriptive flexfield segment.
490 * @param p_ass_attribute28 Descriptive flexfield segment.
491 * @param p_ass_attribute29 Descriptive flexfield segment.
492 * @param p_ass_attribute30 Descriptive flexfield segment.
493 * @param p_title Obsolete parameter, do not use.
494 * @param p_legal_entity Legal Entity of the assignment. Valid values are
495 * defined in the 'HR_DK_LEGAL_ENTITY' lookup type.
496 * @param p_cond_of_emp Employee category. Valid values are defined in the
497 * lookup type 'DK_COND_OF_EMP'
498 * @param p_emp_group Employee type. Valid values are defined in the
499 * 'DK_EMP_TYPE' lookup type.
500 * @param p_union_membership Union membership. Valid values are defined in the
501 * 'DK_UNION_MEMBERSHIP' lookup type.
502 * @param p_termination_reason Reason for terminating the assignment.
503 * @param p_notified_date Notified date.
504 * @param p_termination_date Termination date.
505 * @param p_adjusted_seniority_date Adjusted seniority date.
506 * @param p_default_work_pattern Default Work Pattern for Holiday Entitlement
507 * Valid values are defined in the Value set 'DK_WORK_PATTERNS'
508 * @param p_hourly_accrual_rate Hourly Accrual Rate for Holiday Entitlement
509 * Valid values are defined in the Value set 'HR_DK_2_DIGIT'
510 * @param p_accrual_type Accrual Type for Holiday Entitlement
511 * Valid values are defined in the Value set 'DK_ACCRUAL_TYPES'
512 * @param p_salaried_allowance_rate Salaried Allowance Rate for Holiday Entitlement
513 * Valid values are defined in the Value set 'HR_DK_2_DIGIT'
514 * @param p_job_occupation_employee_code Job Occupation Employee Code for DA Office codes
515 * Valid values are defined in the Value set 'HR_DK_JOB_OCC_MKODE'
516 * @param p_job_status_employee_code Job Status Employee Code for DA Office codes
517 * Valid values are defined in the Value set 'HR_DK_JOB_STATUS_MKODE'
518 * @param p_salary_basis_employee_code Salary Basis Employee Code for DA Office codes
519 * Valid values are defined in the Value set 'HR_DK_SALARY_BASIS_MKODE'
520 * @param p_time_off_in_lieu Time Off in Lieu for DA Office codes
521 * Valid values are defined in the Value set 'HR_DK_YES_NO'
522 * @param p_section_28_registration Section 28 Registration for Sick Pay Defaults
523 * Valid values are defined in the Value set 'HR_DK_YES_NO'
524 * @param p_comment_id If p_validate is false and comment text was provided,
525 * then will be set to the identifier of the created assignment comment record.
526 * If p_validate is true or no comment text was provided, then will be null.
527 * @param p_soft_coding_keyflex_id If p_validate is FALSE and any p_segment
528 * parameters have set text, set to the ID of the corresponding soft coding
529 * keyflex row. If p_validate is true, or no p_segment parameters have set
530 * text, this will be NULL.
531 * @param p_effective_start_date If p_validate is false, then set to the
532 * effective start date on the updated assignment row which now exists as of
533 * the effective date. If p_validate is true, then set to null.
534 * @param p_effective_end_date If p_validate is false, then set to the
535 * effective end date on the updated assignment row which now exists as of the
536 * effective date. If p_validate is true, then set to null.
537 * @param p_concatenated_segments If p_validate is false, set to soft coded key
538 * flexfield concatenated segments. If p_validate is true, set to null.
539 * @param p_no_managers_warning Set to true if as a result of the update there
540 * is no manager in the organization. Otherwise set to false.
541 * @param p_other_manager_warning If set to true, then a manager existed in the
542 * organization prior to calling this API and the manager flag has been set to
543 * 'Y' for yes.
544 * @rep:displayname Update Employee Assignment for Denmark
545 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
546 * @rep:lifecycle active
547 * @rep:scope public
548 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
549 */
550 --
551 -- {End Of Comments}
552 --
553 PROCEDURE update_dk_emp_asg
554 (p_validate IN BOOLEAN DEFAULT FALSE
555 ,p_effective_date IN DATE
556 ,p_datetrack_update_mode IN VARCHAR2
557 ,p_assignment_id IN NUMBER
558 ,p_object_version_number IN OUT NOCOPY NUMBER
559 ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
560 ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
561 ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
562 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
563 ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
564 ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
565 ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
566 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
567 ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
568 ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
569 ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
570 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
571 ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
572 ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
573 ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
574 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
575 ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
576 ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
577 ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
578 ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
579 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
580 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
581 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
582 ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
583 ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
584 ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
585 ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
586 ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
587 ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
588 ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
589 ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
590 ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
591 ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
592 ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
593 ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
594 ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
595 ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
596 ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
597 ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
598 ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
599 ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
600 ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
601 ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
602 ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
603 ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
604 ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
605 ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
606 ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
607 ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
608 ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
609 ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
610 ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
611 ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612 ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
614 ,p_legal_entity IN VARCHAR2 DEFAULT hr_api.g_varchar2
615 --,p_pension_provider IN VARCHAR2 DEFAULT hr_api.g_varchar2 Removed from assignment level and it's captured at Element entry level
616 ,p_cond_of_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Condition of Employment
617 ,p_emp_group IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Employee Group
618 ,p_union_membership IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Union Membership
619 ,p_termination_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
620 ,p_notified_date IN DATE DEFAULT hr_api.g_date
621 ,p_termination_date IN DATE DEFAULT hr_api.g_date
622 ,p_adjusted_seniority_date IN DATE DEFAULT hr_api.g_date
623 ,p_default_work_pattern IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Holiday Entitlement
624 ,p_hourly_accrual_rate IN NUMBER DEFAULT hr_api.g_number -- Holiday Entitlement
625 ,p_accrual_type IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Holiday Entitlement
626 ,p_salaried_allowance_rate IN NUMBER DEFAULT hr_api.g_number -- Holiday Entitlement
627 ,p_job_occupation_employee_code IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- DA Office codes
628 ,p_job_status_employee_code IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- DA Office codes
629 ,p_salary_basis_employee_code IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- DA Office codes
630 ,p_time_off_in_lieu IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- DA Office codes
631 ,p_section_28_registration IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Sick Pay Defaults
632 ,p_comment_id OUT NOCOPY NUMBER
633 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
634 ,p_effective_start_date OUT NOCOPY DATE
635 ,p_effective_end_date OUT NOCOPY DATE
636 ,p_concatenated_segments OUT NOCOPY VARCHAR2
637 ,p_no_managers_warning OUT NOCOPY BOOLEAN
638 ,p_other_manager_warning OUT NOCOPY BOOLEAN
639 );
640 END hr_dk_assignment_api;