1 PACKAGE hr_ae_assignment_api AS
2 /* $Header: peasgaei.pkh 120.8 2006/04/27 01:12:26 spendhar noship $ */
3 /*#
4 * This package contains assignment APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Assignment for UAE
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------< create_ae_secondary_emp_asg >-------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 /*#
15 * This API creates secondary assignment for an employee.
16 *
17 * The API calls the generic API create_secondary_emp_asg, with parameters set
18 * as appropriate for the UAE person. As this API is effectively an
19 * alternative to the API create_secondary_emp_asg, see that API for further
20 * explanation.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * The employee must have been created already and must exist at the effective
27 * start date of the assignment.
28 *
29 * <p><b>Post Success</b><br>
30 * A new secondary assignment is created for the employee.
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, the database remains unchanged. If FALSE a valid
36 * assignment is created IN the database.
37 * @param p_effective_date The effective date of the change
38 * @param p_person_id Person for whom this assignment applies
39 * @param p_organization_id Organization
40 * @param p_grade_id Grade
41 * @param p_position_id Position
42 * @param p_job_id Job
43 * @param p_assignment_status_type_id Assignment Status
44 * @param p_payroll_id Payroll
45 * @param p_location_id Location
46 * @param p_special_ceiling_step_id Special ceiling step
47 * @param p_pay_basis_id Salary basis
48 * @param p_assignment_id ID of the assignment
49 * @param p_supervisor_id Supervisor
50 * @param p_assignment_number Assignment number
51 * @param p_change_reason Reason for change
52 * @param p_comments Comments
53 * @param p_date_probation_end End date of probation period
54 * @param p_default_code_comb_id Foreign key to GL_CODE_COMBINATIONS
55 * @param p_employment_category Employment category
56 * @param p_frequency Frequency for quoting working hours (eg per week)
57 * @param p_internal_address_line Internal address line
58 * @param p_manager_flag Indicates whether the employee is a manager
59 * @param p_normal_hours Normal working hours
60 * @param p_perf_review_period Performance review period
61 * @param p_perf_review_period_frequency Units for quoting performance
62 * review period (eg months)
63 * @param p_probation_period Length of probation period
64 * @param p_probation_unit Units for quoting probation period (eg months)
65 * @param p_sal_review_period Salary review period
66 * @param p_sal_review_period_frequency Units for quoting salary review
67 * period (eg months)
68 * @param p_set_of_books_id Set of books (GL)
69 * @param p_source_type Recruitment activity source
70 * @param p_time_normal_finish Normal work finish time
71 * @param p_time_normal_start Normal work start time
72 * @param p_bargaining_unit_code Bargaining unit
73 * @param p_labour_union_member_flag Labour union member flag
74 * @param p_hourly_salaried_code Hourly Salaried code
75 * @param p_ass_attribute_category Descriptive flexfield attribute category
76 * @param p_ass_attribute1 Descriptive flexfield
77 * @param p_ass_attribute2 Descriptive flexfield
78 * @param p_ass_attribute3 Descriptive flexfield
79 * @param p_ass_attribute4 Descriptive flexfield
80 * @param p_ass_attribute5 Descriptive flexfield
81 * @param p_ass_attribute6 Descriptive flexfield
82 * @param p_ass_attribute7 Descriptive flexfield
83 * @param p_ass_attribute8 Descriptive flexfield
84 * @param p_ass_attribute9 Descriptive flexfield
85 * @param p_ass_attribute10 Descriptive flexfield
86 * @param p_ass_attribute11 Descriptive flexfield
87 * @param p_ass_attribute12 Descriptive flexfield
88 * @param p_ass_attribute13 Descriptive flexfield
89 * @param p_ass_attribute14 Descriptive flexfield
90 * @param p_ass_attribute15 Descriptive flexfield
91 * @param p_ass_attribute16 Descriptive flexfield
92 * @param p_ass_attribute17 Descriptive flexfield
93 * @param p_ass_attribute18 Descriptive flexfield
94 * @param p_ass_attribute19 Descriptive flexfield
95 * @param p_ass_attribute20 Descriptive flexfield
96 * @param p_ass_attribute21 Descriptive flexfield
97 * @param p_ass_attribute22 Descriptive flexfield
98 * @param p_ass_attribute23 Descriptive flexfield
99 * @param p_ass_attribute24 Descriptive flexfield
100 * @param p_ass_attribute25 Descriptive flexfield
101 * @param p_ass_attribute26 Descriptive flexfield
102 * @param p_ass_attribute27 Descriptive flexfield
103 * @param p_ass_attribute28 Descriptive flexfield
104 * @param p_ass_attribute29 Descriptive flexfield
105 * @param p_ass_attribute30 Descriptive flexfield
106 * @param p_title Title -must be NULL
107 * @param p_employer Employer
108 * @param p_civil_reg_number Civil Registration Number
109 * @param p_social_sec_number Social Security Number
110 * @param p_contribution_start_date Contribution Start Date
111 * @param p_latest_qualification Latest Qualification
112 * @param p_accommodation_provided Indicates whether Accommodation is provided
113 * @param p_transportation_provided Indicates whether Transportation is provided
114 * @param p_pgp_segment1 People group segment
115 * @param p_pgp_segment2 People group segment
116 * @param p_pgp_segment3 People group segment
117 * @param p_pgp_segment4 People group segment
118 * @param p_pgp_segment5 People group segment
119 * @param p_pgp_segment6 People group segment
120 * @param p_pgp_segment7 People group segment
121 * @param p_pgp_segment8 People group segment
122 * @param p_pgp_segment9 People group segment
123 * @param p_pgp_segment10 People group segment
124 * @param p_pgp_segment11 People group segment
125 * @param p_pgp_segment12 People group segment
126 * @param p_pgp_segment13 People group segment
127 * @param p_pgp_segment14 People group segment
128 * @param p_pgp_segment15 People group segment
129 * @param p_pgp_segment16 People group segment
130 * @param p_pgp_segment17 People group segment
131 * @param p_pgp_segment18 People group segment
132 * @param p_pgp_segment19 People group segment
133 * @param p_pgp_segment20 People group segment
134 * @param p_pgp_segment21 People group segment
135 * @param p_pgp_segment22 People group segment
136 * @param p_pgp_segment23 People group segment
137 * @param p_pgp_segment24 People group segment
138 * @param p_pgp_segment25 People group segment
139 * @param p_pgp_segment26 People group segment
140 * @param p_pgp_segment27 People group segment
141 * @param p_pgp_segment28 People group segment
142 * @param p_pgp_segment29 People group segment
143 * @param p_pgp_segment30 People group segment
144 * @param p_pgp_concat_segments Concatenated people group segments
145 * @param p_people_group_id People group id
146 * @param p_assignment_sequence Assignment sequence
147 * @param p_group_name Group name
148 * Post Success:
149 * The API sets the following OUT parameters:
150 * @param p_object_version_number If p_validate is FALSE, set to the new object
151 * version number of the updated assignment record. If p_validate is true, set
152 * to the passed IN value.
153 * @param p_soft_coding_keyflex_id If p_validate is FALSE and any p_segment
154 * parameters have set text, set to the id of the corresponding soft coding
155 * keyflex row. If p_validate is true, or no p_segment parameters have set
156 * text, this will be NULL.
157 * @param p_comment_id If p_validate is FALSE and any comment text exists,
158 * set to the id of the corresponding assignment comment row. If p_validate is
159 * true, or no comment text exists this will be NULL.
160 * @param p_effective_start_date If p_validate is FALSE, set to the effective
161 * start DATE of the assignment. If p_validate is true, set to NULL.
162 * @param p_effective_end_date If p_validate is FALSE, set to the effective end
163 * DATE of the assignment. If p_validate is true, set to NULL.
164 * @param p_concatenated_segments If p_validate is FALSE and any p_segment
165 * parameters have set text, set to the concatenation of all p_segment parameters with
166 * set text. If p_validate is true, or no p_segment parameters have set text, this
167 * will be NULL.
168 * @param p_other_manager_warning If p_validate is FALSE then set to true if manager_flag is
169 * changed from 'N' to 'Y' and a manager already exists IN the organization, p_organization_id,
170 * at p_effective_date. Set to FALSE if no other managers exist IN p_organization_id.This is
171 * always set to FALSE if manager_flag is not updated.The warning value only applies as of
172 * p_effective_date. If p_validate is true then set to FALSE.
173 * @rep:displayname Create Secondary Employee Assignment for UAE
174 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
175 * @rep:lifecycle active
176 * @rep:scope public
177 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
178 */
179 --
180 -- {End Of Comments}
181 --
182 --
183 PROCEDURE create_ae_secondary_emp_asg
184 (p_validate IN BOOLEAN DEFAULT FALSE
185 ,p_effective_date IN DATE
186 ,p_person_id IN NUMBER
187 ,p_organization_id IN NUMBER
188 ,p_grade_id IN NUMBER DEFAULT NULL
189 ,p_position_id IN NUMBER DEFAULT NULL
190 ,p_job_id IN NUMBER DEFAULT NULL
191 ,p_assignment_status_type_id IN NUMBER DEFAULT NULL
192 ,p_payroll_id IN NUMBER DEFAULT NULL
193 ,p_location_id IN NUMBER DEFAULT NULL
194 ,p_supervisor_id IN NUMBER DEFAULT NULL
195 ,p_special_ceiling_step_id IN NUMBER DEFAULT NULL
196 ,p_pay_basis_id IN NUMBER DEFAULT NULL
197 ,p_assignment_number IN OUT NOCOPY VARCHAR2
198 ,p_change_reason IN VARCHAR2 DEFAULT NULL
199 ,p_comments IN VARCHAR2 DEFAULT NULL
200 ,p_date_probation_end IN DATE DEFAULT NULL
201 ,p_default_code_comb_id IN NUMBER DEFAULT NULL
202 ,p_employment_category IN VARCHAR2 DEFAULT NULL
203 ,p_frequency IN VARCHAR2 DEFAULT NULL
204 ,p_internal_address_line IN VARCHAR2 DEFAULT NULL
205 ,p_manager_flag IN VARCHAR2 DEFAULT NULL
206 ,p_normal_hours IN NUMBER DEFAULT NULL
207 ,p_perf_review_period IN NUMBER DEFAULT NULL
208 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT NULL
209 ,p_probation_period IN NUMBER DEFAULT NULL
210 ,p_probation_unit IN VARCHAR2 DEFAULT NULL
211 ,p_sal_review_period IN NUMBER DEFAULT NULL
212 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT NULL
213 ,p_set_of_books_id IN NUMBER DEFAULT NULL
214 ,p_source_type IN VARCHAR2 DEFAULT NULL
215 ,p_time_normal_finish IN VARCHAR2 DEFAULT NULL
216 ,p_time_normal_start IN VARCHAR2 DEFAULT NULL
217 ,p_bargaining_unit_code in varchar2 default null
218 ,p_labour_union_member_flag in varchar2 default 'N'
219 ,p_hourly_salaried_code in varchar2 default null
220 ,p_ass_attribute_category IN VARCHAR2 DEFAULT NULL
221 ,p_ass_attribute1 IN VARCHAR2 DEFAULT NULL
222 ,p_ass_attribute2 IN VARCHAR2 DEFAULT NULL
223 ,p_ass_attribute3 IN VARCHAR2 DEFAULT NULL
224 ,p_ass_attribute4 IN VARCHAR2 DEFAULT NULL
225 ,p_ass_attribute5 IN VARCHAR2 DEFAULT NULL
226 ,p_ass_attribute6 IN VARCHAR2 DEFAULT NULL
227 ,p_ass_attribute7 IN VARCHAR2 DEFAULT NULL
228 ,p_ass_attribute8 IN VARCHAR2 DEFAULT NULL
229 ,p_ass_attribute9 IN VARCHAR2 DEFAULT NULL
230 ,p_ass_attribute10 IN VARCHAR2 DEFAULT NULL
231 ,p_ass_attribute11 IN VARCHAR2 DEFAULT NULL
232 ,p_ass_attribute12 IN VARCHAR2 DEFAULT NULL
233 ,p_ass_attribute13 IN VARCHAR2 DEFAULT NULL
234 ,p_ass_attribute14 IN VARCHAR2 DEFAULT NULL
235 ,p_ass_attribute15 IN VARCHAR2 DEFAULT NULL
236 ,p_ass_attribute16 IN VARCHAR2 DEFAULT NULL
237 ,p_ass_attribute17 IN VARCHAR2 DEFAULT NULL
238 ,p_ass_attribute18 IN VARCHAR2 DEFAULT NULL
239 ,p_ass_attribute19 IN VARCHAR2 DEFAULT NULL
240 ,p_ass_attribute20 IN VARCHAR2 DEFAULT NULL
241 ,p_ass_attribute21 IN VARCHAR2 DEFAULT NULL
242 ,p_ass_attribute22 IN VARCHAR2 DEFAULT NULL
243 ,p_ass_attribute23 IN VARCHAR2 DEFAULT NULL
244 ,p_ass_attribute24 IN VARCHAR2 DEFAULT NULL
245 ,p_ass_attribute25 IN VARCHAR2 DEFAULT NULL
246 ,p_ass_attribute26 IN VARCHAR2 DEFAULT NULL
247 ,p_ass_attribute27 IN VARCHAR2 DEFAULT NULL
248 ,p_ass_attribute28 IN VARCHAR2 DEFAULT NULL
249 ,p_ass_attribute29 IN VARCHAR2 DEFAULT NULL
250 ,p_ass_attribute30 IN VARCHAR2 DEFAULT NULL
251 ,p_title IN VARCHAR2 DEFAULT NULL
252 ,p_employer IN VARCHAR2 DEFAULT NULL
253 ,p_civil_reg_number IN VARCHAR2 DEFAULT NULL
254 ,p_social_sec_number IN VARCHAR2 DEFAULT NULL
255 ,p_contribution_start_date IN VARCHAR2 DEFAULT NULL
256 ,p_latest_qualification IN VARCHAR2 DEFAULT NULL
257 ,p_accommodation_provided IN VARCHAR2 DEFAULT NULL
258 ,p_transportation_provided IN VARCHAR2 DEFAULT NULL
259 ,p_pgp_segment1 IN VARCHAR2 DEFAULT NULL
260 ,p_pgp_segment2 IN VARCHAR2 DEFAULT NULL
261 ,p_pgp_segment3 IN VARCHAR2 DEFAULT NULL
262 ,p_pgp_segment4 IN VARCHAR2 DEFAULT NULL
263 ,p_pgp_segment5 IN VARCHAR2 DEFAULT NULL
264 ,p_pgp_segment6 IN VARCHAR2 DEFAULT NULL
265 ,p_pgp_segment7 IN VARCHAR2 DEFAULT NULL
266 ,p_pgp_segment8 IN VARCHAR2 DEFAULT NULL
267 ,p_pgp_segment9 IN VARCHAR2 DEFAULT NULL
268 ,p_pgp_segment10 IN VARCHAR2 DEFAULT NULL
269 ,p_pgp_segment11 IN VARCHAR2 DEFAULT NULL
270 ,p_pgp_segment12 IN VARCHAR2 DEFAULT NULL
271 ,p_pgp_segment13 IN VARCHAR2 DEFAULT NULL
272 ,p_pgp_segment14 IN VARCHAR2 DEFAULT NULL
273 ,p_pgp_segment15 IN VARCHAR2 DEFAULT NULL
274 ,p_pgp_segment16 IN VARCHAR2 DEFAULT NULL
275 ,p_pgp_segment17 IN VARCHAR2 DEFAULT NULL
276 ,p_pgp_segment18 IN VARCHAR2 DEFAULT NULL
277 ,p_pgp_segment19 IN VARCHAR2 DEFAULT NULL
278 ,p_pgp_segment20 IN VARCHAR2 DEFAULT NULL
279 ,p_pgp_segment21 IN VARCHAR2 DEFAULT NULL
280 ,p_pgp_segment22 IN VARCHAR2 DEFAULT NULL
281 ,p_pgp_segment23 IN VARCHAR2 DEFAULT NULL
282 ,p_pgp_segment24 IN VARCHAR2 DEFAULT NULL
283 ,p_pgp_segment25 IN VARCHAR2 DEFAULT NULL
284 ,p_pgp_segment26 IN VARCHAR2 DEFAULT NULL
285 ,p_pgp_segment27 IN VARCHAR2 DEFAULT NULL
286 ,p_pgp_segment28 IN VARCHAR2 DEFAULT NULL
287 ,p_pgp_segment29 IN VARCHAR2 DEFAULT NULL
288 ,p_pgp_segment30 IN VARCHAR2 DEFAULT NULL
289 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT NULL
290 ,p_assignment_id OUT NOCOPY NUMBER
291 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
292 ,p_people_group_id OUT NOCOPY NUMBER
293 ,p_object_version_number OUT NOCOPY NUMBER
294 ,p_effective_start_date OUT NOCOPY DATE
295 ,p_effective_end_date OUT NOCOPY DATE
296 ,p_assignment_sequence OUT NOCOPY NUMBER
297 ,p_comment_id OUT NOCOPY NUMBER
298 ,p_concatenated_segments OUT NOCOPY VARCHAR2
299 ,p_group_name OUT NOCOPY VARCHAR2
300 ,p_other_manager_warning OUT NOCOPY BOOLEAN
301 );
302
303 -- ----------------------------------------------------------------------------
304 -- |--------------------------< update_ae_emp_asg >---------------------------|
308 * This API updates employee assignment details which do not
305 -- ----------------------------------------------------------------------------
306 -- {Start Of Comments}
307 /*#
309 * affect entitlement to element entries.
310 *
311 * The API calls the generic API update_emp_asg, with parameters set as
312 * appropriate for the UAE employee assignment. As this API is effectively an
313 * alternative to the API update_emp_asg, see that API for further explanation.
314 *
315 * <p><b>Licensing</b><br>
316 * This API is licensed for use with Human Resources.
317 *
318 * <p><b>Prerequisites</b><br>
319 * The assignment must exist as of the effective date and must be an employee
320 * assignment.
321 *
322 * <p><b>Post Success</b><br>
323 * The assignment will have been updated.
324 *
325 * <p><b>Post Failure</b><br>
326 * The assignment will not be updated and an error will be raised.
327
328 * @param p_validate If true, the database remains unchanged. If FALSE a valid
329 * assignment is created IN the database.
330 * @param p_effective_date The effective date of the change
331 * @param p_datetrack_update_mode Update mode
332 * @param p_assignment_id ID of the assignment
333 * @param p_supervisor_id Supervisor
334 * @param p_assignment_number Assignment number
335 * @param p_change_reason Reason for change
336 * @param p_comments Comments
337 * @param p_date_probation_end End date of probation period
338 * @param p_default_code_comb_id Foreign key to GL_CODE_COMBINATIONS
339 * @param p_frequency Frequency for quoting working hours (eg per week)
340 * @param p_internal_address_line Internal address line
341 * @param p_manager_flag Indicates whether the employee is a manager
342 * @param p_normal_hours Normal working hours
343 * @param p_perf_review_period Performance review period
344 * @param p_perf_review_period_frequency Units for quoting performance
345 * review period (eg months)
346 * @param p_probation_period Length of probation period
347 * @param p_probation_unit Units for quoting probation period (eg months)
348 * @param p_sal_review_period Salary review period
349 * @param p_sal_review_period_frequency Units for quoting salary review
350 * period (eg months)
351 * @param p_set_of_books_id Set of books (GL)
352 * @param p_source_type Recruitment activity source
353 * @param p_time_normal_finish Normal work finish time
354 * @param p_time_normal_start Normal work start time
355 * @param p_bargaining_unit_code Bargaining unit
356 * @param p_labour_union_member_flag Labour union member flag
357 * @param p_hourly_salaried_code Hourly Salaried code
358 * @param p_ass_attribute_category Descriptive flexfield attribute category
359 * @param p_ass_attribute1 Descriptive flexfield
360 * @param p_ass_attribute2 Descriptive flexfield
361 * @param p_ass_attribute3 Descriptive flexfield
362 * @param p_ass_attribute4 Descriptive flexfield
363 * @param p_ass_attribute5 Descriptive flexfield
364 * @param p_ass_attribute6 Descriptive flexfield
365 * @param p_ass_attribute7 Descriptive flexfield
366 * @param p_ass_attribute8 Descriptive flexfield
367 * @param p_ass_attribute9 Descriptive flexfield
368 * @param p_ass_attribute10 Descriptive flexfield
369 * @param p_ass_attribute11 Descriptive flexfield
370 * @param p_ass_attribute12 Descriptive flexfield
371 * @param p_ass_attribute13 Descriptive flexfield
372 * @param p_ass_attribute14 Descriptive flexfield
373 * @param p_ass_attribute15 Descriptive flexfield
374 * @param p_ass_attribute16 Descriptive flexfield
375 * @param p_ass_attribute17 Descriptive flexfield
376 * @param p_ass_attribute18 Descriptive flexfield
377 * @param p_ass_attribute19 Descriptive flexfield
378 * @param p_ass_attribute20 Descriptive flexfield
379 * @param p_ass_attribute21 Descriptive flexfield
380 * @param p_ass_attribute22 Descriptive flexfield
381 * @param p_ass_attribute23 Descriptive flexfield
382 * @param p_ass_attribute24 Descriptive flexfield
383 * @param p_ass_attribute25 Descriptive flexfield
384 * @param p_ass_attribute26 Descriptive flexfield
385 * @param p_ass_attribute27 Descriptive flexfield
386 * @param p_ass_attribute28 Descriptive flexfield
387 * @param p_ass_attribute29 Descriptive flexfield
388 * @param p_ass_attribute30 Descriptive flexfield
389 * @param p_title Title -must be NULL
390 * @param p_employer Employer
391 * @param p_civil_reg_number Civil Registration Number
392 * @param p_social_sec_number Social Security Number
393 * @param p_contribution_start_date Contribution Start Date
394 * @param p_latest_qualification Latest Qualification
395 * @param p_accommodation_provided Indicates whether Accommodation is provided
396 * @param p_transportation_provided Indicates whether Transportation is provided
397 * Post Success:
398 * The API sets the following OUT parameters:
399 * @param p_object_version_number If p_validate is FALSE, set to the new object
400 * version NUMBER of the updated assignment record. If p_validate is true, set
401 * to the passed IN value.
402 * @param p_soft_coding_keyflex_id If p_validate is FALSE and any p_segment
403 * parameters have set text, set to the id of the corresponding soft coding
404 * keyflex row. If p_validate is true, or no p_segment parameters have set
405 * text, this will be NULL.
406 * @param p_comment_id If p_validate is FALSE and any comment text exists,
407 * set to the id of the corresponding assignment comment row. If p_validate is
408 * true, or no comment text exists this will be NULL.
409 * @param p_effective_start_date If p_validate is FALSE, set to the effective
410 * start DATE of the assignment. If p_validate is true, set to NULL.
414 * parameters have set text, set to the concatenation of all p_segment parameters with
411 * @param p_effective_end_date If p_validate is FALSE, set to the effective end
412 * DATE of the assignment. If p_validate is true, set to NULL.
413 * @param p_concatenated_segments If p_validate is FALSE and any p_segment
415 * set text. If p_validate is true, or no p_segment parameters have set text, this
416 * will be NULL.
417 * @param p_no_managers_warning If p_validate is FALSE then set to true if manager_flag is
418 * updated from 'Y' to 'N' and no other manager exists IN p_organization_id. Set to FALSE
419 * if another manager exists IN p_organization_id.This parameter is always set to FALSE if
420 * manager_flag is not updated. The warning value only applies as of p_effective_date.
421 * If p_validate is true then set to FALSE.
422 * @param p_other_manager_warning If p_validate is FALSE then set to true if manager_flag is
423 * changed from 'N' to 'Y' and a manager already exists IN the organization, p_organization_id,
424 * at p_effective_date. Set to FALSE if no other managers exist IN p_organization_id.This is
425 * always set to FALSE if manager_flag is not updated.The warning value only applies as of
426 * p_effective_date. If p_validate is true then set to FALSE.
427 * @rep:displayname Updates Secondary Employee Assignment for UAE
428 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
429 * @rep:lifecycle active
430 * @rep:scope public
431 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
432 */
433 --
434 -- {End Of Comments}
435 --
436 PROCEDURE update_ae_emp_asg
437 (p_validate IN BOOLEAN DEFAULT FALSE
438 ,p_effective_date IN DATE
439 ,p_datetrack_update_mode IN VARCHAR2
440 ,p_assignment_id IN NUMBER
441 ,p_object_version_number IN OUT NOCOPY NUMBER
442 ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
443 ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
444 ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
445 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
446 ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
447 ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
448 ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
449 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
450 ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451 ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
452 ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
453 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
454 ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
455 ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
456 ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
457 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
458 ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
459 ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
460 ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
461 ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
462 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
463 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
464 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
465 ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
466 ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467 ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468 ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469 ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470 ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471 ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472 ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473 ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474 ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475 ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476 ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477 ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478 ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479 ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480 ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481 ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482 ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483 ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484 ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
485 ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486 ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487 ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488 ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489 ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490 ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491 ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492 ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493 ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
494 ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495 ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
497 ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
498 ,p_civil_reg_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
499 ,p_social_sec_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
500 ,p_contribution_start_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
501 ,p_latest_qualification IN VARCHAR2 DEFAULT hr_api.g_varchar2
502 ,p_accommodation_provided IN VARCHAR2 DEFAULT hr_api.g_varchar2
503 ,p_transportation_provided IN VARCHAR2 DEFAULT hr_api.g_varchar2
504 ,p_comment_id OUT NOCOPY NUMBER
505 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
506 ,p_effective_start_date OUT NOCOPY DATE
507 ,p_effective_end_date OUT NOCOPY DATE
508 ,p_concatenated_segments OUT NOCOPY VARCHAR2
509 ,p_no_managers_warning OUT NOCOPY BOOLEAN
510 ,p_other_manager_warning OUT NOCOPY BOOLEAN
511 );
512 END hr_ae_assignment_api;
[Home] [Help]