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