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