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