1 PACKAGE hr_ae_assignment_api AUTHID CURRENT_USER AS
2 /* $Header: peasgaei.pkh 120.11 2012/01/19 08:56:40 rpahune ship $ */
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)
68 * @param p_set_of_books_id Set of books (GL)
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)
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
144 * @param p_pgp_concat_segments Concatenated people group segments
141 * @param p_pgp_segment28 People group segment
142 * @param p_pgp_segment29 People group segment
143 * @param p_pgp_segment30 People group segment
145 * @param p_people_group_id People group id
146 * @param p_assignment_sequence Assignment sequence
147 * @param p_group_name Group name
148 * @param p_notice_period Notice period
149 * @param p_notice_period_uom Notice period units
150 * Post Success:
151 * The API sets the following OUT parameters:
152 * @param p_object_version_number If p_validate is FALSE, set to the new object
153 * version number of the updated assignment record. If p_validate is true, set
154 * to the passed IN value.
155 * @param p_soft_coding_keyflex_id If p_validate is FALSE and any p_segment
159 * @param p_cagr_grade_def_id When the API completes, if p_validate is false,
156 * parameters have set text, set to the id of the corresponding soft coding
157 * keyflex row. If p_validate is true, or no p_segment parameters have set
158 * text, this will be NULL.
160 * then this uniquely identifies the associated combination of the CAGR Key
161 * flexfield for this assignment. If p_validate is true, then set to null.
162 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated segments
163 * @param p_comment_id If p_validate is FALSE and any comment text exists,
164 * set to the id of the corresponding assignment comment row. If p_validate is
165 * true, or no comment text exists this will be NULL.
166 * @param p_effective_start_date If p_validate is FALSE, set to the effective
167 * start DATE of the assignment. If p_validate is true, set to NULL.
168 * @param p_effective_end_date If p_validate is FALSE, set to the effective end
169 * DATE of the assignment. If p_validate is true, set to NULL.
170 * @param p_concatenated_segments If p_validate is FALSE and any p_segment
171 * parameters have set text, set to the concatenation of all p_segment parameters with
172 * set text. If p_validate is true, or no p_segment parameters have set text, this
173 * will be NULL.
174 * @param p_other_manager_warning If p_validate is FALSE then set to true if manager_flag is
175 * changed from 'N' to 'Y' and a manager already exists IN the organization, p_organization_id,
176 * at p_effective_date. Set to FALSE if no other managers exist IN p_organization_id.This is
177 * always set to FALSE if manager_flag is not updated.The warning value only applies as of
178 * p_effective_date. If p_validate is true then set to FALSE.
179 * @rep:displayname Create Secondary Employee Assignment for UAE
180 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
181 * @rep:lifecycle active
182 * @rep:scope public
183 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
184 */
185 --
186 -- {End Of Comments}
187 --
188 --
189 PROCEDURE create_ae_secondary_emp_asg
190 (p_validate IN BOOLEAN DEFAULT FALSE
191 ,p_effective_date IN DATE
192 ,p_person_id IN NUMBER
193 ,p_organization_id IN NUMBER
194 ,p_grade_id IN NUMBER DEFAULT NULL
195 ,p_position_id IN NUMBER DEFAULT NULL
196 ,p_job_id IN NUMBER DEFAULT NULL
197 ,p_assignment_status_type_id IN NUMBER DEFAULT NULL
198 ,p_payroll_id IN NUMBER DEFAULT NULL
199 ,p_location_id IN NUMBER DEFAULT NULL
200 ,p_supervisor_id IN NUMBER DEFAULT NULL
201 ,p_special_ceiling_step_id IN NUMBER DEFAULT NULL
202 ,p_pay_basis_id IN NUMBER DEFAULT NULL
203 ,p_assignment_number IN OUT NOCOPY VARCHAR2
204 ,p_change_reason IN VARCHAR2 DEFAULT NULL
205 ,p_comments IN VARCHAR2 DEFAULT NULL
206 ,p_date_probation_end IN DATE DEFAULT NULL
207 ,p_default_code_comb_id IN NUMBER DEFAULT NULL
208 ,p_employment_category IN VARCHAR2 DEFAULT NULL
209 ,p_frequency IN VARCHAR2 DEFAULT NULL
210 ,p_internal_address_line IN VARCHAR2 DEFAULT NULL
211 ,p_manager_flag IN VARCHAR2 DEFAULT NULL
212 ,p_normal_hours IN NUMBER DEFAULT NULL
213 ,p_perf_review_period IN NUMBER DEFAULT NULL
214 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT NULL
215 ,p_probation_period IN NUMBER DEFAULT NULL
216 ,p_probation_unit IN VARCHAR2 DEFAULT NULL
217 ,p_sal_review_period IN NUMBER DEFAULT NULL
218 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT NULL
219 ,p_set_of_books_id IN NUMBER DEFAULT NULL
220 ,p_source_type IN VARCHAR2 DEFAULT NULL
221 ,p_time_normal_finish IN VARCHAR2 DEFAULT NULL
222 ,p_time_normal_start IN VARCHAR2 DEFAULT NULL
223 ,p_bargaining_unit_code in varchar2 default null
224 ,p_labour_union_member_flag in varchar2 default 'N'
225 ,p_hourly_salaried_code in varchar2 default null
226 ,p_notice_period IN NUMBER DEFAULT NULL /* Bug No : 8590134 */
227 ,p_notice_period_uom IN VARCHAR2 DEFAULT NULL /* Bug No : 8590134 */
228 ,p_ass_attribute_category IN VARCHAR2 DEFAULT NULL
229 ,p_ass_attribute1 IN VARCHAR2 DEFAULT NULL
230 ,p_ass_attribute2 IN VARCHAR2 DEFAULT NULL
231 ,p_ass_attribute3 IN VARCHAR2 DEFAULT NULL
232 ,p_ass_attribute4 IN VARCHAR2 DEFAULT NULL
233 ,p_ass_attribute5 IN VARCHAR2 DEFAULT NULL
234 ,p_ass_attribute6 IN VARCHAR2 DEFAULT NULL
235 ,p_ass_attribute7 IN VARCHAR2 DEFAULT NULL
236 ,p_ass_attribute8 IN VARCHAR2 DEFAULT NULL
237 ,p_ass_attribute9 IN VARCHAR2 DEFAULT NULL
238 ,p_ass_attribute10 IN VARCHAR2 DEFAULT NULL
239 ,p_ass_attribute11 IN VARCHAR2 DEFAULT NULL
240 ,p_ass_attribute12 IN VARCHAR2 DEFAULT NULL
241 ,p_ass_attribute13 IN VARCHAR2 DEFAULT NULL
242 ,p_ass_attribute14 IN VARCHAR2 DEFAULT NULL
243 ,p_ass_attribute15 IN VARCHAR2 DEFAULT NULL
244 ,p_ass_attribute16 IN VARCHAR2 DEFAULT NULL
245 ,p_ass_attribute17 IN VARCHAR2 DEFAULT NULL
246 ,p_ass_attribute18 IN VARCHAR2 DEFAULT NULL
247 ,p_ass_attribute19 IN VARCHAR2 DEFAULT NULL
248 ,p_ass_attribute20 IN VARCHAR2 DEFAULT NULL
249 ,p_ass_attribute21 IN VARCHAR2 DEFAULT NULL
250 ,p_ass_attribute22 IN VARCHAR2 DEFAULT NULL
251 ,p_ass_attribute23 IN VARCHAR2 DEFAULT NULL
252 ,p_ass_attribute24 IN VARCHAR2 DEFAULT NULL
253 ,p_ass_attribute25 IN VARCHAR2 DEFAULT NULL
254 ,p_ass_attribute26 IN VARCHAR2 DEFAULT NULL
255 ,p_ass_attribute27 IN VARCHAR2 DEFAULT NULL
256 ,p_ass_attribute28 IN VARCHAR2 DEFAULT NULL
257 ,p_ass_attribute29 IN VARCHAR2 DEFAULT NULL
258 ,p_ass_attribute30 IN VARCHAR2 DEFAULT NULL
259 ,p_title IN VARCHAR2 DEFAULT NULL
260 ,p_employer IN VARCHAR2 DEFAULT NULL
261 ,p_civil_reg_number IN VARCHAR2 DEFAULT NULL
262 ,p_social_sec_number IN VARCHAR2 DEFAULT NULL
263 ,p_contribution_start_date IN VARCHAR2 DEFAULT NULL
264 ,p_latest_qualification IN VARCHAR2 DEFAULT NULL
265 ,p_accommodation_provided IN VARCHAR2 DEFAULT NULL
266 ,p_transportation_provided IN VARCHAR2 DEFAULT NULL
267 ,p_pgp_segment1 IN VARCHAR2 DEFAULT NULL
268 ,p_pgp_segment2 IN VARCHAR2 DEFAULT NULL
269 ,p_pgp_segment3 IN VARCHAR2 DEFAULT NULL
270 ,p_pgp_segment4 IN VARCHAR2 DEFAULT NULL
271 ,p_pgp_segment5 IN VARCHAR2 DEFAULT NULL
272 ,p_pgp_segment6 IN VARCHAR2 DEFAULT NULL
273 ,p_pgp_segment7 IN VARCHAR2 DEFAULT NULL
277 ,p_pgp_segment11 IN VARCHAR2 DEFAULT NULL
274 ,p_pgp_segment8 IN VARCHAR2 DEFAULT NULL
275 ,p_pgp_segment9 IN VARCHAR2 DEFAULT NULL
276 ,p_pgp_segment10 IN VARCHAR2 DEFAULT NULL
278 ,p_pgp_segment12 IN VARCHAR2 DEFAULT NULL
279 ,p_pgp_segment13 IN VARCHAR2 DEFAULT NULL
280 ,p_pgp_segment14 IN VARCHAR2 DEFAULT NULL
281 ,p_pgp_segment15 IN VARCHAR2 DEFAULT NULL
282 ,p_pgp_segment16 IN VARCHAR2 DEFAULT NULL
283 ,p_pgp_segment17 IN VARCHAR2 DEFAULT NULL
284 ,p_pgp_segment18 IN VARCHAR2 DEFAULT NULL
285 ,p_pgp_segment19 IN VARCHAR2 DEFAULT NULL
286 ,p_pgp_segment20 IN VARCHAR2 DEFAULT NULL
287 ,p_pgp_segment21 IN VARCHAR2 DEFAULT NULL
288 ,p_pgp_segment22 IN VARCHAR2 DEFAULT NULL
289 ,p_pgp_segment23 IN VARCHAR2 DEFAULT NULL
290 ,p_pgp_segment24 IN VARCHAR2 DEFAULT NULL
291 ,p_pgp_segment25 IN VARCHAR2 DEFAULT NULL
292 ,p_pgp_segment26 IN VARCHAR2 DEFAULT NULL
293 ,p_pgp_segment27 IN VARCHAR2 DEFAULT NULL
294 ,p_pgp_segment28 IN VARCHAR2 DEFAULT NULL
295 ,p_pgp_segment29 IN VARCHAR2 DEFAULT NULL
296 ,p_pgp_segment30 IN VARCHAR2 DEFAULT NULL
297 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT NULL
298 ,p_cagr_grade_def_id OUT NOCOPY NUMBER
299 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
300 ,p_assignment_id OUT NOCOPY NUMBER
301 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
302 ,p_people_group_id OUT NOCOPY NUMBER
303 ,p_object_version_number OUT NOCOPY NUMBER
304 ,p_effective_start_date OUT NOCOPY DATE
305 ,p_effective_end_date OUT NOCOPY DATE
306 ,p_assignment_sequence OUT NOCOPY NUMBER
307 ,p_comment_id OUT NOCOPY NUMBER
308 ,p_concatenated_segments OUT NOCOPY VARCHAR2
309 ,p_group_name OUT NOCOPY VARCHAR2
310 ,p_other_manager_warning OUT NOCOPY BOOLEAN
311 );
312
313 -- ----------------------------------------------------------------------------
314 -- |--------------------------< update_ae_emp_asg >---------------------------|
315 -- ----------------------------------------------------------------------------
316 -- {Start Of Comments}
317 /*#
318 * This API updates employee assignment details which do not
319 * affect entitlement to element entries.
320 *
321 * The API calls the generic API update_emp_asg, with parameters set as
322 * appropriate for the UAE employee assignment. As this API is effectively an
323 * alternative to the API update_emp_asg, see that API for further explanation.
324 *
325 * <p><b>Licensing</b><br>
326 * This API is licensed for use with Human Resources.
327 *
328 * <p><b>Prerequisites</b><br>
329 * The assignment must exist as of the effective date and must be an employee
330 * assignment.
331 *
332 * <p><b>Post Success</b><br>
333 * The assignment will have been updated.
334 *
335 * <p><b>Post Failure</b><br>
336 * The assignment will not be updated and an error will be raised.
337
338 * @param p_validate If true, the database remains unchanged. If FALSE a valid
339 * assignment is created IN the database.
340 * @param p_effective_date The effective date of the change
341 * @param p_datetrack_update_mode Update mode
342 * @param p_assignment_id ID of the assignment
343 * @param p_supervisor_id Supervisor
344 * @param p_assignment_number Assignment number
345 * @param p_change_reason Reason for change
346 * @param p_comments Comments
347 * @param p_date_probation_end End date of probation period
348 * @param p_default_code_comb_id Foreign key to GL_CODE_COMBINATIONS
349 * @param p_frequency Frequency for quoting working hours (eg per week)
350 * @param p_internal_address_line Internal address line
351 * @param p_manager_flag Indicates whether the employee is a manager
352 * @param p_normal_hours Normal working hours
353 * @param p_perf_review_period Performance review period
354 * @param p_perf_review_period_frequency Units for quoting performance
355 * review period (eg months)
356 * @param p_probation_period Length of probation period
357 * @param p_probation_unit Units for quoting probation period (eg months)
358 * @param p_sal_review_period Salary review period
359 * @param p_sal_review_period_frequency Units for quoting salary review
360 * period (eg months)
361 * @param p_set_of_books_id Set of books (GL)
362 * @param p_source_type Recruitment activity source
363 * @param p_time_normal_finish Normal work finish time
364 * @param p_time_normal_start Normal work start time
365 * @param p_bargaining_unit_code Bargaining unit
366 * @param p_labour_union_member_flag Labour union member flag
367 * @param p_hourly_salaried_code Hourly Salaried code
368 * @param p_ass_attribute_category Descriptive flexfield attribute category
369 * @param p_ass_attribute1 Descriptive flexfield
370 * @param p_ass_attribute2 Descriptive flexfield
371 * @param p_ass_attribute3 Descriptive flexfield
372 * @param p_ass_attribute4 Descriptive flexfield
373 * @param p_ass_attribute5 Descriptive flexfield
374 * @param p_ass_attribute6 Descriptive flexfield
375 * @param p_ass_attribute7 Descriptive flexfield
376 * @param p_ass_attribute8 Descriptive flexfield
377 * @param p_ass_attribute9 Descriptive flexfield
378 * @param p_ass_attribute10 Descriptive flexfield
379 * @param p_ass_attribute11 Descriptive flexfield
380 * @param p_ass_attribute12 Descriptive flexfield
381 * @param p_ass_attribute13 Descriptive flexfield
382 * @param p_ass_attribute14 Descriptive flexfield
386 * @param p_ass_attribute18 Descriptive flexfield
383 * @param p_ass_attribute15 Descriptive flexfield
384 * @param p_ass_attribute16 Descriptive flexfield
385 * @param p_ass_attribute17 Descriptive flexfield
387 * @param p_ass_attribute19 Descriptive flexfield
388 * @param p_ass_attribute20 Descriptive flexfield
389 * @param p_ass_attribute21 Descriptive flexfield
390 * @param p_ass_attribute22 Descriptive flexfield
391 * @param p_ass_attribute23 Descriptive flexfield
392 * @param p_ass_attribute24 Descriptive flexfield
393 * @param p_ass_attribute25 Descriptive flexfield
394 * @param p_ass_attribute26 Descriptive flexfield
395 * @param p_ass_attribute27 Descriptive flexfield
396 * @param p_ass_attribute28 Descriptive flexfield
397 * @param p_ass_attribute29 Descriptive flexfield
398 * @param p_ass_attribute30 Descriptive flexfield
399 * @param p_title Title -must be NULL
400 * @param p_employer Employer
401 * @param p_civil_reg_number Civil Registration Number
402 * @param p_social_sec_number Social Security Number
403 * @param p_contribution_start_date Contribution Start Date
404 * @param p_latest_qualification Latest Qualification
405 * @param p_accommodation_provided Indicates whether Accommodation is provided
406 * @param p_transportation_provided Indicates whether Transportation is provided
407 * @param p_notice_period Notice Period
408 * @param p_notice_period_uom Notice Period UOM
409 * Post Success:
410 * The API sets the following OUT parameters:
411 * @param p_object_version_number If p_validate is FALSE, set to the new object
412 * version NUMBER of the updated assignment record. If p_validate is true, set
413 * to the passed IN value.
414 * @param p_soft_coding_keyflex_id If p_validate is FALSE and any p_segment
415 * parameters have set text, set to the id of the corresponding soft coding
416 * keyflex row. If p_validate is true, or no p_segment parameters have set
417 * text, this will be NULL.
418 * @param p_cagr_grade_def_id When the API completes, if p_validate is false,
419 * then this uniquely identifies the associated combination of the CAGR Key
420 * flexfield for this assignment. If p_validate is true, then set to null.
421 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated segments
422 * @param p_comment_id If p_validate is FALSE and any comment text exists,
423 * set to the id of the corresponding assignment comment row. If p_validate is
424 * true, or no comment text exists this will be NULL.
425 * @param p_effective_start_date If p_validate is FALSE, set to the effective
426 * start DATE of the assignment. If p_validate is true, set to NULL.
427 * @param p_effective_end_date If p_validate is FALSE, set to the effective end
428 * DATE of the assignment. If p_validate is true, set to NULL.
429 * @param p_concatenated_segments If p_validate is FALSE and any p_segment
430 * parameters have set text, set to the concatenation of all p_segment parameters with
431 * set text. If p_validate is true, or no p_segment parameters have set text, this
432 * will be NULL.
433 * @param p_no_managers_warning If p_validate is FALSE then set to true if manager_flag is
434 * updated from 'Y' to 'N' and no other manager exists IN p_organization_id. Set to FALSE
435 * if another manager exists IN p_organization_id.This parameter is always set to FALSE if
436 * manager_flag is not updated. The warning value only applies as of p_effective_date.
437 * If p_validate is true then set to FALSE.
438 * @param p_other_manager_warning If p_validate is FALSE then set to true if manager_flag is
439 * changed from 'N' to 'Y' and a manager already exists IN the organization, p_organization_id,
440 * at p_effective_date. Set to FALSE if no other managers exist IN p_organization_id.This is
441 * always set to FALSE if manager_flag is not updated.The warning value only applies as of
442 * p_effective_date. If p_validate is true then set to FALSE.
443 * @rep:displayname Updates Secondary Employee Assignment for UAE
444 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
445 * @rep:lifecycle active
446 * @rep:scope public
447 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
448 */
449 --
450 -- {End Of Comments}
451 --
452 PROCEDURE update_ae_emp_asg
453 (p_validate IN BOOLEAN DEFAULT FALSE
454 ,p_effective_date IN DATE
455 ,p_datetrack_update_mode IN VARCHAR2
456 ,p_assignment_id IN NUMBER
457 ,p_object_version_number IN OUT NOCOPY NUMBER
458 ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
459 ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
460 ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
461 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
462 ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
463 ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
464 ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
465 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
466 ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
467 ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
468 ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
469 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
470 ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
471 ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
472 ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
473 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
474 ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
475 ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
476 ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
477 ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
478 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
479 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
480 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
481 ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
482 ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483 ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484 ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
485 ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486 ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487 ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488 ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489 ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490 ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491 ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492 ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493 ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
494 ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495 ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496 ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497 ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498 ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499 ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500 ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501 ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502 ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503 ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504 ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505 ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506 ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507 ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508 ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509 ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510 ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511 ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
513 ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
514 ,p_civil_reg_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
515 ,p_social_sec_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
516 ,p_contribution_start_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
517 ,p_latest_qualification IN VARCHAR2 DEFAULT hr_api.g_varchar2
518 ,p_accommodation_provided IN VARCHAR2 DEFAULT hr_api.g_varchar2
519 ,p_transportation_provided IN VARCHAR2 DEFAULT hr_api.g_varchar2
520 ,p_notice_period IN NUMBER DEFAULT hr_api.g_number /* Bug No : 8590134 */
521 ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2 /* Bug No : 8590134 */
522 ,p_cagr_grade_def_id OUT NOCOPY NUMBER
523 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
524 ,p_comment_id OUT NOCOPY NUMBER
525 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
526 ,p_effective_start_date OUT NOCOPY DATE
527 ,p_effective_end_date OUT NOCOPY DATE
528 ,p_concatenated_segments OUT NOCOPY VARCHAR2
529 ,p_no_managers_warning OUT NOCOPY BOOLEAN
530 ,p_other_manager_warning OUT NOCOPY BOOLEAN
531 );
532 END hr_ae_assignment_api;
[Home] [Help]