1 PACKAGE hr_mx_assignment_api AUTHID CURRENT_USER AS
2 /* $Header: pemxwras.pkh 120.3 2005/11/04 05:36:57 jcolman noship $ */
3 /*#
4 * This package contains APIs for maintaining employee, applicant and
5 * contingent worker assignment details for Mexico.
6 * @rep:scope public
7 * @rep:product PER
8 * @rep:displayname Assignment for Mexico
9 */
10 g_leaving_reason VARCHAR2(2);
11 g_old_gre hr_soft_coding_keyflex.segment1%TYPE;
12 g_old_location hr_locations.location_id%TYPE;
13 --
14 -- ----------------------------------------------------------------------------
15 -- |-----------------------< create_mx_secondary_emp_asg >--------------------|
16 -- ----------------------------------------------------------------------------
17 --
18 -- {Start Of Comments}
19 /*#
20 * This API creates a new secondary assignment for an employee.
21 *
22 * This API cannot create a primary assignment.
23 *
24 * <p><b>Licensing</b><br>
25 * This API is licensed for use with Human Resources.
26 *
27 * <p><b>Prerequisites</b><br>
28 * The person and organization must exist at the effective start date of the
29 * assignment.
30 *
31 * <p><b>Post Success</b><br>
32 * A new secondary assignment is created for the employee.
33 *
34 * <p><b>Post Failure</b><br>
35 * The API does not create the secondary assignment and raises an error.
36 *
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_effective_date Determines when the DateTrack operation comes into
41 * force.
42 * @param p_person_id Identifies the person for whom you create the secondary
43 * assignment record.
44 * @param p_organization_id Identifies the organization of the secondary
45 * assignment.
46 * @param p_grade_id Identifies the grade of the secondary assignment.
47 * @param p_position_id Identifies the position of the secondary assignment.
48 * @param p_job_id Identifies the job of the secondary assignment.
49 * @param p_assignment_status_type_id Identifies the assignment status of the
50 * secondary assignment.
51 * @param p_payroll_id Identifies the payroll for the secondary assignment.
52 * @param p_location_id Identifies the location of the secondary assignment.
53 * @param p_supervisor_id Identifies the supervisor for the secondary
54 * assignment. The value refers to the supervisor's person record.
55 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
56 * associated with the grade of the secondary assignment.
57 * @param p_pay_basis_id Salary basis for the secondary assignment.
58 * @param p_assignment_number If a value is passed in, this is used as the
59 * assignment number. If no value is passed in an assignment number is
60 * generated.
61 * @param p_change_reason Reason for the assignment status change. If there is
62 * no change reason the parameter can be null. Valid values are defined in the
63 * EMP_ASSIGN_REASON lookup type.
64 * @param p_comments Comment text.
65 * @param p_date_probation_end End date of probation period.
66 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
67 * Flexfield combination that applies to this assignment.
68 * @param p_employment_category Employment category. Valid values are defined
69 * in the EMP_CAT lookup type.
70 * @param p_frequency Frequency associated with the defined normal working
71 * hours. Valid values are defined in the FREQUENCY lookup type.
72 * @param p_internal_address_line Internal address identified with the
73 * secondary assignment.
74 * @param p_manager_flag Indicates whether the employee is a manager.
75 * @param p_normal_hours Normal working hours for this assignment.
76 * @param p_perf_review_period Length of performance review period.
77 * @param p_perf_review_period_frequency Units of performance review period.
78 * Valid values are defined in the FREQUENCY lookup type.
79 * @param p_probation_period Length of probation period.
80 * @param p_probation_unit Units of probation period. Valid values are defined
81 * in the QUALIFYING_UNITS lookup type.
82 * @param p_sal_review_period Length of salary review period.
83 * @param p_sal_review_period_frequency Units of salary review period. Valid
84 * values are defined in the FREQUENCY lookup type.
85 * @param p_set_of_books_id Identifies General Ledger set of books.
86 * @param p_source_type Recruitment activity which this assignment is sourced
87 * from. Valid values are defined in the REC_TYPE lookup type.
88 * @param p_time_normal_finish Normal work finish time.
89 * @param p_time_normal_start Normal work start time
90 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
91 * defined in the BARGAINING_UNIT_CODE lookup type.
92 * @param p_labour_union_member_flag Value 'Y' indicates employee is a labour
93 * union member. Other values indicate not a member.
94 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
95 * is salaried. Valid values defined in the HOURLY_SALARIED_CODE lookup type.
96 * @param p_ass_attribute_category This context value determines which
97 * Flexfield Structure to use with the Descriptive flexfield segments.
98 * @param p_ass_attribute1 Descriptive flexfield segment.
99 * @param p_ass_attribute2 Descriptive flexfield segment.
100 * @param p_ass_attribute3 Descriptive flexfield segment.
101 * @param p_ass_attribute4 Descriptive flexfield segment.
102 * @param p_ass_attribute5 Descriptive flexfield segment.
103 * @param p_ass_attribute6 Descriptive flexfield segment.
104 * @param p_ass_attribute7 Descriptive flexfield segment.
105 * @param p_ass_attribute8 Descriptive flexfield segment.
106 * @param p_ass_attribute9 Descriptive flexfield segment.
107 * @param p_ass_attribute10 Descriptive flexfield segment.
108 * @param p_ass_attribute11 Descriptive flexfield segment.
109 * @param p_ass_attribute12 Descriptive flexfield segment.
110 * @param p_ass_attribute13 Descriptive flexfield segment.
111 * @param p_ass_attribute14 Descriptive flexfield segment.
112 * @param p_ass_attribute15 Descriptive flexfield segment.
113 * @param p_ass_attribute16 Descriptive flexfield segment.
114 * @param p_ass_attribute17 Descriptive flexfield segment.
115 * @param p_ass_attribute18 Descriptive flexfield segment.
116 * @param p_ass_attribute19 Descriptive flexfield segment.
117 * @param p_ass_attribute20 Descriptive flexfield segment.
118 * @param p_ass_attribute21 Descriptive flexfield segment.
119 * @param p_ass_attribute22 Descriptive flexfield segment.
120 * @param p_ass_attribute23 Descriptive flexfield segment.
121 * @param p_ass_attribute24 Descriptive flexfield segment.
122 * @param p_ass_attribute25 Descriptive flexfield segment.
123 * @param p_ass_attribute26 Descriptive flexfield segment.
124 * @param p_ass_attribute27 Descriptive flexfield segment.
125 * @param p_ass_attribute28 Descriptive flexfield segment.
126 * @param p_ass_attribute29 Descriptive flexfield segment.
127 * @param p_ass_attribute30 Descriptive flexfield segment.
128 * @param p_title Obsolete parameter, do not use.
129 * @param p_tax_unit Government Reporting Entity.
130 * @param p_timecard_approver Timecard Approver.
131 * @param p_timecard_required Indicates whether timecard is required.
132 * @param p_work_schedule Indicates the pattern of work for the assignment.
133 * @param p_gov_emp_sector Federal Government Sector (Rama del Gobierno
134 * Federal).
135 * @param p_ss_salary_type Social Security Salary Type.
136 * @param p_scl_concat_segments Concatenated segments for Soft Coded Key
137 * Flexfield. Concatenated segments can be supplied instead of individual
138 * segments.
139 * @param p_pgp_segment1 People Group Key flexfield segment.
140 * @param p_pgp_segment2 People Group Key flexfield segment.
141 * @param p_pgp_segment3 People Group Key flexfield segment.
142 * @param p_pgp_segment4 People Group Key flexfield segment.
143 * @param p_pgp_segment5 People Group Key flexfield segment.
144 * @param p_pgp_segment6 People Group Key flexfield segment.
145 * @param p_pgp_segment7 People Group Key flexfield segment.
146 * @param p_pgp_segment8 People Group Key flexfield segment.
147 * @param p_pgp_segment9 People Group Key flexfield segment.
148 * @param p_pgp_segment10 People Group Key flexfield segment.
149 * @param p_pgp_segment11 People Group Key flexfield segment.
150 * @param p_pgp_segment12 People Group Key flexfield segment.
151 * @param p_pgp_segment13 People Group Key flexfield segment.
152 * @param p_pgp_segment14 People Group Key flexfield segment.
153 * @param p_pgp_segment15 People Group Key flexfield segment.
154 * @param p_pgp_segment16 People Group Key flexfield segment.
155 * @param p_pgp_segment17 People Group Key flexfield segment.
156 * @param p_pgp_segment18 People Group Key flexfield segment.
157 * @param p_pgp_segment19 People Group Key flexfield segment.
158 * @param p_pgp_segment20 People Group Key flexfield segment.
159 * @param p_pgp_segment21 People Group Key flexfield segment.
160 * @param p_pgp_segment22 People Group Key flexfield segment.
161 * @param p_pgp_segment23 People Group Key flexfield segment.
162 * @param p_pgp_segment24 People Group Key flexfield segment.
163 * @param p_pgp_segment25 People Group Key flexfield segment.
164 * @param p_pgp_segment26 People Group Key flexfield segment.
165 * @param p_pgp_segment27 People Group Key flexfield segment.
166 * @param p_pgp_segment28 People Group Key flexfield segment.
167 * @param p_pgp_segment29 People Group Key flexfield segment.
168 * @param p_pgp_segment30 People Group Key flexfield segment.
169 * @param p_pgp_concat_segments Concatenated segments for People Group Key
170 * Flexfield. Concatenated segments can be supplied instead of individual
171 * segments.
172 * @param p_contract_id Contract associated with this assignment.
173 * @param p_establishment_id For French business groups, this identifies the
174 * Establishment Legal Entity for this assignment.
175 * @param p_collective_agreement_id Collective Agreement that applies to this
176 * assignment.
177 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
178 * flexfield to use for this assignment.
179 * @param p_cag_segment1 CAGR Key Flexfield segment.
180 * @param p_cag_segment2 CAGR Key Flexfield segment.
181 * @param p_cag_segment3 CAGR Key Flexfield segment.
182 * @param p_cag_segment4 CAGR Key Flexfield segment.
183 * @param p_cag_segment5 CAGR Key Flexfield segment.
184 * @param p_cag_segment6 CAGR Key Flexfield segment.
185 * @param p_cag_segment7 CAGR Key Flexfield segment.
186 * @param p_cag_segment8 CAGR Key Flexfield segment.
187 * @param p_cag_segment9 CAGR Key Flexfield segment.
188 * @param p_cag_segment10 CAGR Key Flexfield segment.
189 * @param p_cag_segment11 CAGR Key Flexfield segment.
190 * @param p_cag_segment12 CAGR Key Flexfield segment.
191 * @param p_cag_segment13 CAGR Key Flexfield segment.
192 * @param p_cag_segment14 CAGR Key Flexfield segment.
193 * @param p_cag_segment15 CAGR Key Flexfield segment.
194 * @param p_cag_segment16 CAGR Key Flexfield segment.
195 * @param p_cag_segment17 CAGR Key Flexfield segment.
196 * @param p_cag_segment18 CAGR Key Flexfield segment.
197 * @param p_cag_segment19 CAGR Key Flexfield segment.
198 * @param p_cag_segment20 CAGR Key Flexfield segment.
199 * @param p_notice_period Length of notice period.
200 * @param p_notice_period_uom Units for notice period. Valid values are defined
201 * in the QUALIFYING_UNITS lookup type.
202 * @param p_employee_category Employee Category. Valid values are defined in
203 * the EMPLOYEE_CATG lookup type.
204 * @param p_work_at_home Indicates whether this assignment is to work at home.
205 * Valid values are defined in the YES_NO lookup type.
206 * @param p_job_post_source_name The source of the job posting that was
207 * answered for this assignment.
208 * @param p_grade_ladder_pgm_id Grade Ladder for this assignment.
209 * @param p_supervisor_assignment_id Supervisor's assignment that is
210 * responsible for supervising this assignment.
211 * @param p_group_name If p_validate is false, then set to the People Group Key
212 * Flexfield concatenated segments. If p_validate is true, then set to null.
213 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
214 * Flexfield concatenated segments, if p_validate is true, set to null.
215 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
216 * identifies an existing CAGR Key Flexfield combination to associate with the
217 * assignment, and segment values are ignored. If a value is not passed in,
218 * then the individual CAGR Key Flexfield segments supplied will be used to
219 * choose an existing combination or create a new combination. When the API
220 * completes, if p_validate is false, then this uniquely identifies the
221 * associated combination of the CAGR Key flexfield for this assignment. If
222 * p_validate is true, then set to null.
223 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
224 * segments.
225 * @param p_assignment_id If p_validate is false, then this uniquely identifies
226 * the created assignment. If p_validate is true, then set to null.
227 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
228 * it identifies an existing Soft Coded Key Flexfield combination to associate
229 * with the assignment, and segment values are ignored. If a value is not
230 * passed in, then the individual Soft Coded Key Flexfield segments supplied
231 * will be used to choose an existing combination or create a new combination.
232 * When the API completes, if p_validate is false, then this uniquely
233 * identifies the associated combination of the Soft Coded Key flexfield for
234 * this assignment. If p_validate is true, then set to null.
235 * @param p_people_group_id If a value is passed in for this parameter, it
236 * identifies an existing People Group Key Flexfield combination to associate
237 * with the assignment, and segment values are ignored. If a value is not
238 * passed in, then the individual People Group Key Flexfield segments supplied
239 * will be used to choose an existing combination or create a new combination.
240 * When the API completes, if p_validate is false, then this uniquely
241 * identifies the associated combination of the People Group Key flexfield for
242 * this assignment. If p_validate is true, then set to null.
243 * @param p_object_version_number If p_validate is false, then set to the
244 * version number of the created assignment. If p_validate is true, then the
245 * value will be null.
246 * @param p_effective_start_date If p_validate is false, then set to the
247 * earliest effective start date for the created assignment. If p_validate is
248 * true, then set to null.
249 * @param p_effective_end_date If p_validate is false, then set to the
250 * effective end date for the created assignment. If p_validate is true, then
251 * set to null.
252 * @param p_assignment_sequence If p_validate is false, then an automatically
253 * incremented number is associated with this assignment, depending on the
254 * number of assignment which already exist. If p_validate is true then set to
255 * null.
256 * @param p_comment_id If p_validate is false and comment text was provided,
257 * then will be set to the identifier of the created assignment comment record.
258 * If p_validate is true or no comment text was provided, then will be null.
259 * @param p_other_manager_warning If set to true, then a manager existed in the
260 * organization prior to calling this API and the manager flag has been set to
261 * 'Y' for yes.
262 * @param p_hourly_salaried_warning Set to true if values entered for Salary
263 * Basis and Hourly Salaried Code are invalid as of p_effective_date.
264 * @param p_gsp_post_process_warning Set to the name of a warning message from
265 * the Message Dictionary if any Grade Ladder related errors have been
266 * encountered while running this API.
267 * @rep:displayname Create Secondary Employee Assignment for Mexico
268 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
269 * @rep:lifecycle active
270 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
271 * @rep:scope public
272 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
273 */
274 --
275 -- {End Of Comments}
276 --
277 PROCEDURE create_mx_secondary_emp_asg
278 (p_validate IN BOOLEAN DEFAULT false
279 ,p_effective_date IN DATE
280 ,p_person_id IN NUMBER
281 ,p_organization_id IN NUMBER
282 ,p_grade_id IN NUMBER DEFAULT null
283 ,p_position_id IN NUMBER DEFAULT null
284 ,p_job_id IN NUMBER DEFAULT null
285 ,p_assignment_status_type_id IN NUMBER DEFAULT null
286 ,p_payroll_id IN NUMBER DEFAULT null
287 ,p_location_id IN NUMBER DEFAULT null
288 ,p_supervisor_id IN NUMBER DEFAULT null
289 ,p_special_ceiling_step_id IN NUMBER DEFAULT null
290 ,p_pay_basis_id IN NUMBER DEFAULT null
291 ,p_assignment_number IN OUT NOCOPY VARCHAR2
292 ,p_change_reason IN VARCHAR2 DEFAULT null
293 ,p_comments IN VARCHAR2 DEFAULT null
294 ,p_date_probation_end IN DATE DEFAULT null
295 ,p_default_code_comb_id IN NUMBER DEFAULT null
296 ,p_employment_category IN VARCHAR2 DEFAULT null
297 ,p_frequency IN VARCHAR2 DEFAULT null
298 ,p_internal_address_line IN VARCHAR2 DEFAULT null
299 ,p_manager_flag IN VARCHAR2 DEFAULT null
300 ,p_normal_hours IN NUMBER DEFAULT null
301 ,p_perf_review_period IN NUMBER DEFAULT null
302 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT null
303 ,p_probation_period IN NUMBER DEFAULT null
304 ,p_probation_unit IN VARCHAR2 DEFAULT null
305 ,p_sal_review_period IN NUMBER DEFAULT null
306 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT null
307 ,p_set_of_books_id IN NUMBER DEFAULT null
308 ,p_source_type IN VARCHAR2 DEFAULT null
309 ,p_time_normal_finish IN VARCHAR2 DEFAULT null
310 ,p_time_normal_start IN VARCHAR2 DEFAULT null
311 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT null
312 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT null
313 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT null
314 ,p_ass_attribute_category IN VARCHAR2 DEFAULT null
315 ,p_ass_attribute1 IN VARCHAR2 DEFAULT null
316 ,p_ass_attribute2 IN VARCHAR2 DEFAULT null
317 ,p_ass_attribute3 IN VARCHAR2 DEFAULT null
318 ,p_ass_attribute4 IN VARCHAR2 DEFAULT null
319 ,p_ass_attribute5 IN VARCHAR2 DEFAULT null
320 ,p_ass_attribute6 IN VARCHAR2 DEFAULT null
321 ,p_ass_attribute7 IN VARCHAR2 DEFAULT null
322 ,p_ass_attribute8 IN VARCHAR2 DEFAULT null
323 ,p_ass_attribute9 IN VARCHAR2 DEFAULT null
324 ,p_ass_attribute10 IN VARCHAR2 DEFAULT null
325 ,p_ass_attribute11 IN VARCHAR2 DEFAULT null
326 ,p_ass_attribute12 IN VARCHAR2 DEFAULT null
327 ,p_ass_attribute13 IN VARCHAR2 DEFAULT null
328 ,p_ass_attribute14 IN VARCHAR2 DEFAULT null
329 ,p_ass_attribute15 IN VARCHAR2 DEFAULT null
330 ,p_ass_attribute16 IN VARCHAR2 DEFAULT null
331 ,p_ass_attribute17 IN VARCHAR2 DEFAULT null
332 ,p_ass_attribute18 IN VARCHAR2 DEFAULT null
333 ,p_ass_attribute19 IN VARCHAR2 DEFAULT null
334 ,p_ass_attribute20 IN VARCHAR2 DEFAULT null
335 ,p_ass_attribute21 IN VARCHAR2 DEFAULT null
336 ,p_ass_attribute22 IN VARCHAR2 DEFAULT null
337 ,p_ass_attribute23 IN VARCHAR2 DEFAULT null
338 ,p_ass_attribute24 IN VARCHAR2 DEFAULT null
339 ,p_ass_attribute25 IN VARCHAR2 DEFAULT null
340 ,p_ass_attribute26 IN VARCHAR2 DEFAULT null
341 ,p_ass_attribute27 IN VARCHAR2 DEFAULT null
342 ,p_ass_attribute28 IN VARCHAR2 DEFAULT null
343 ,p_ass_attribute29 IN VARCHAR2 DEFAULT null
344 ,p_ass_attribute30 IN VARCHAR2 DEFAULT null
345 ,p_title IN VARCHAR2 DEFAULT null
346 ,p_tax_unit IN VARCHAR2 DEFAULT null
347 ,p_timecard_approver IN VARCHAR2 DEFAULT null
348 ,p_timecard_required IN VARCHAR2 DEFAULT null
349 ,p_work_schedule IN VARCHAR2 DEFAULT null
350 ,p_gov_emp_sector IN VARCHAR2 DEFAULT null
351 ,p_ss_salary_type IN VARCHAR2 DEFAULT null
352 ,p_scl_concat_segments IN VARCHAR2 DEFAULT null
353 ,p_pgp_segment1 IN VARCHAR2 DEFAULT null
354 ,p_pgp_segment2 IN VARCHAR2 DEFAULT null
355 ,p_pgp_segment3 IN VARCHAR2 DEFAULT null
356 ,p_pgp_segment4 IN VARCHAR2 DEFAULT null
357 ,p_pgp_segment5 IN VARCHAR2 DEFAULT null
358 ,p_pgp_segment6 IN VARCHAR2 DEFAULT null
359 ,p_pgp_segment7 IN VARCHAR2 DEFAULT null
360 ,p_pgp_segment8 IN VARCHAR2 DEFAULT null
361 ,p_pgp_segment9 IN VARCHAR2 DEFAULT null
362 ,p_pgp_segment10 IN VARCHAR2 DEFAULT null
363 ,p_pgp_segment11 IN VARCHAR2 DEFAULT null
364 ,p_pgp_segment12 IN VARCHAR2 DEFAULT null
365 ,p_pgp_segment13 IN VARCHAR2 DEFAULT null
366 ,p_pgp_segment14 IN VARCHAR2 DEFAULT null
367 ,p_pgp_segment15 IN VARCHAR2 DEFAULT null
368 ,p_pgp_segment16 IN VARCHAR2 DEFAULT null
369 ,p_pgp_segment17 IN VARCHAR2 DEFAULT null
370 ,p_pgp_segment18 IN VARCHAR2 DEFAULT null
371 ,p_pgp_segment19 IN VARCHAR2 DEFAULT null
372 ,p_pgp_segment20 IN VARCHAR2 DEFAULT null
373 ,p_pgp_segment21 IN VARCHAR2 DEFAULT null
374 ,p_pgp_segment22 IN VARCHAR2 DEFAULT null
375 ,p_pgp_segment23 IN VARCHAR2 DEFAULT null
376 ,p_pgp_segment24 IN VARCHAR2 DEFAULT null
377 ,p_pgp_segment25 IN VARCHAR2 DEFAULT null
378 ,p_pgp_segment26 IN VARCHAR2 DEFAULT null
379 ,p_pgp_segment27 IN VARCHAR2 DEFAULT null
380 ,p_pgp_segment28 IN VARCHAR2 DEFAULT null
381 ,p_pgp_segment29 IN VARCHAR2 DEFAULT null
382 ,p_pgp_segment30 IN VARCHAR2 DEFAULT null
383 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT null
384 ,p_contract_id IN NUMBER DEFAULT null
385 ,p_establishment_id IN NUMBER DEFAULT null
386 ,p_collective_agreement_id IN NUMBER DEFAULT null
387 ,p_cagr_id_flex_num IN NUMBER DEFAULT null
388 ,p_cag_segment1 IN VARCHAR2 DEFAULT null
389 ,p_cag_segment2 IN VARCHAR2 DEFAULT null
390 ,p_cag_segment3 IN VARCHAR2 DEFAULT null
391 ,p_cag_segment4 IN VARCHAR2 DEFAULT null
392 ,p_cag_segment5 IN VARCHAR2 DEFAULT null
393 ,p_cag_segment6 IN VARCHAR2 DEFAULT null
394 ,p_cag_segment7 IN VARCHAR2 DEFAULT null
395 ,p_cag_segment8 IN VARCHAR2 DEFAULT null
396 ,p_cag_segment9 IN VARCHAR2 DEFAULT null
397 ,p_cag_segment10 IN VARCHAR2 DEFAULT null
398 ,p_cag_segment11 IN VARCHAR2 DEFAULT null
399 ,p_cag_segment12 IN VARCHAR2 DEFAULT null
400 ,p_cag_segment13 IN VARCHAR2 DEFAULT null
401 ,p_cag_segment14 IN VARCHAR2 DEFAULT null
402 ,p_cag_segment15 IN VARCHAR2 DEFAULT null
403 ,p_cag_segment16 IN VARCHAR2 DEFAULT null
404 ,p_cag_segment17 IN VARCHAR2 DEFAULT null
405 ,p_cag_segment18 IN VARCHAR2 DEFAULT null
406 ,p_cag_segment19 IN VARCHAR2 DEFAULT null
407 ,p_cag_segment20 IN VARCHAR2 DEFAULT null
408 ,p_notice_period IN NUMBER DEFAULT null
409 ,p_notice_period_uom IN VARCHAR2 DEFAULT null
410 ,p_employee_category IN VARCHAR2 DEFAULT null
411 ,p_work_at_home IN VARCHAR2 DEFAULT null
412 ,p_job_post_source_name IN VARCHAR2 DEFAULT null
413 ,p_grade_ladder_pgm_id IN NUMBER DEFAULT null
414 ,p_supervisor_assignment_id IN NUMBER DEFAULT null
415 ,p_group_name OUT NOCOPY VARCHAR2
416 ,p_concatenated_segments OUT NOCOPY VARCHAR2
417 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
418 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
419 ,p_assignment_id OUT NOCOPY NUMBER
420 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
421 ,p_people_group_id IN OUT NOCOPY NUMBER
422 ,p_object_version_number OUT NOCOPY NUMBER
423 ,p_effective_start_date OUT NOCOPY DATE
424 ,p_effective_end_date OUT NOCOPY DATE
425 ,p_assignment_sequence OUT NOCOPY NUMBER
426 ,p_comment_id OUT NOCOPY NUMBER
427 ,p_other_manager_warning OUT NOCOPY BOOLEAN
428 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
429 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2);
430 --
431 -- ----------------------------------------------------------------------------
432 -- |----------------------------< update_mx_emp_asg >-------------------------|
433 -- ----------------------------------------------------------------------------
434 --
435 -- {Start Of Comments}
436 /*#
437 * This API updates employee assignment details that do not affect entitlement
438 * to element entries.
439 *
440 *
441 * <p><b>Licensing</b><br>
442 * This API is licensed for use with Human Resources.
443 *
444 * <p><b>Prerequisites</b><br>
445 * The assignment must exist as of the effective date and must be an employee
446 * assignment.
447 *
448 * <p><b>Post Success</b><br>
449 * The API updates the assignment.
450 *
451 * <p><b>Post Failure</b><br>
452 * The API does not update the assignment and raises an error.
453 *
454 * @param p_validate If true, then validation alone will be performed and the
455 * database will remain unchanged. If false and all validation checks pass,
456 * then the database will be modified.
457 * @param p_effective_date Determines when the DateTrack operation comes into
458 * force.
459 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
460 * updating the record. You must set to either UPDATE, CORRECTION,
461 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
462 * particular record depend on the dates of previous record changes and the
463 * effective date of this change.
464 * @param p_assignment_id Identifies the assignment record to be modified.
465 * @param p_object_version_number Pass in the current version number of the
466 * assignment to be updated. When the API completes if p_validate is false,
467 * will be set to the new version number of the updated assignment. If
468 * p_validate is true will be set to the same value which was passed in.
469 * @param p_supervisor_id Supervisor for the assignment. The value refers to
470 * the supervisor's person record.
471 * @param p_assignment_number Assignment number.
472 * @param p_change_reason Reason for the assignment status change. If there is
473 * no change reason the parameter can be null. Valid values are defined in the
474 * EMP_ASSIGN_REASON lookup type.
475 * @param p_assignment_status_type_id Assignment status. The system status must
476 * be the same as before the update, otherwise one of the status change APIs
477 * should be used.
478 * @param p_comments Comment text.
479 * @param p_date_probation_end End date of probation period.
480 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
481 * Flexfield combination that applies to this assignment.
482 * @param p_frequency Frequency associated with the defined normal working
483 * hours. Valid values are defined in the FREQUENCY lookup type.
484 * @param p_internal_address_line Internal address identified with this
485 * assignment.
486 * @param p_manager_flag Indicates whether the employee is a manager.
487 * @param p_normal_hours Normal working hours for this assignment.
488 * @param p_perf_review_period Length of performance review period.
489 * @param p_perf_review_period_frequency Units of performance review period.
490 * Valid values are defined in the FREQUENCY lookup type.
491 * @param p_probation_period Length of probation period.
492 * @param p_probation_unit Units of probation period. Valid values are defined
493 * in the QUALIFYING_UNITS lookup type.
494 * @param p_sal_review_period Length of salary review period.
495 * @param p_sal_review_period_frequency Units of salary review period. Valid
496 * values are defined in the FREQUENCY lookup type.
497 * @param p_set_of_books_id Identifies General Ledger set of books.
498 * @param p_source_type Recruitment activity which this assignment is sourced
499 * from. Valid values are defined in the REC_TYPE lookup type.
500 * @param p_time_normal_finish Normal work finish time.
501 * @param p_time_normal_start Normal work start time.
502 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
503 * defined in the BARGAINING_UNIT_CODE lookup type.
504 * @param p_labour_union_member_flag Value 'Y' indicates employee is a labour
505 * union member. Other values indicate not a member.
506 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
507 * is salaried. Valid values are defined in the HOURLY_SALARIED_CODE lookup
508 * type.
509 * @param p_ass_attribute_category This context value determines which
510 * Flexfield Structure to use with the Descriptive flexfield segments.
511 * @param p_ass_attribute1 Descriptive flexfield segment.
512 * @param p_ass_attribute2 Descriptive flexfield segment.
513 * @param p_ass_attribute3 Descriptive flexfield segment.
514 * @param p_ass_attribute4 Descriptive flexfield segment.
515 * @param p_ass_attribute5 Descriptive flexfield segment.
516 * @param p_ass_attribute6 Descriptive flexfield segment.
517 * @param p_ass_attribute7 Descriptive flexfield segment.
518 * @param p_ass_attribute8 Descriptive flexfield segment.
519 * @param p_ass_attribute9 Descriptive flexfield segment.
520 * @param p_ass_attribute10 Descriptive flexfield segment.
521 * @param p_ass_attribute11 Descriptive flexfield segment.
522 * @param p_ass_attribute12 Descriptive flexfield segment.
523 * @param p_ass_attribute13 Descriptive flexfield segment.
524 * @param p_ass_attribute14 Descriptive flexfield segment.
525 * @param p_ass_attribute15 Descriptive flexfield segment.
526 * @param p_ass_attribute16 Descriptive flexfield segment.
527 * @param p_ass_attribute17 Descriptive flexfield segment.
528 * @param p_ass_attribute18 Descriptive flexfield segment.
529 * @param p_ass_attribute19 Descriptive flexfield segment.
530 * @param p_ass_attribute20 Descriptive flexfield segment.
531 * @param p_ass_attribute21 Descriptive flexfield segment.
532 * @param p_ass_attribute22 Descriptive flexfield segment.
533 * @param p_ass_attribute23 Descriptive flexfield segment.
534 * @param p_ass_attribute24 Descriptive flexfield segment.
535 * @param p_ass_attribute25 Descriptive flexfield segment.
536 * @param p_ass_attribute26 Descriptive flexfield segment.
537 * @param p_ass_attribute27 Descriptive flexfield segment.
538 * @param p_ass_attribute28 Descriptive flexfield segment.
539 * @param p_ass_attribute29 Descriptive flexfield segment.
540 * @param p_ass_attribute30 Descriptive flexfield segment.
541 * @param p_title Obsolete parameter, do not use.
542 * @param p_tax_unit Government Reporting Entity.
543 * @param p_timecard_approver Timecard Approver.
544 * @param p_timecard_required Indicates whether timecard is required.
545 * @param p_work_schedule Indicates the pattern of work for the assignment.
546 * @param p_gov_emp_sector Federal Government Sector (Rama del Gobierno
547 * Federal).
548 * @param p_ss_salary_type Social Security Salary Type.
549 * @param p_scl_concat_segments Obsolete parameter, do not use.
550 * @param p_concat_segments Concatenated segments for Soft Coded Key Flexfield.
551 * Concatenated segments can be supplied instead of individual segments.
552 * @param p_contract_id Contract associated with this assignment.
553 * @param p_establishment_id For French business groups, this identifies the
554 * Establishment Legal Entity for this assignment.
555 * @param p_collective_agreement_id Collective Agreement that applies to this
556 * assignment.
557 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
558 * flexfield to use for this assignment.
559 * @param p_cag_segment1 CAGR Key Flexfield segment.
560 * @param p_cag_segment2 CAGR Key Flexfield segment.
561 * @param p_cag_segment3 CAGR Key Flexfield segment.
562 * @param p_cag_segment4 CAGR Key Flexfield segment.
563 * @param p_cag_segment5 CAGR Key Flexfield segment.
564 * @param p_cag_segment6 CAGR Key Flexfield segment.
565 * @param p_cag_segment7 CAGR Key Flexfield segment.
566 * @param p_cag_segment8 CAGR Key Flexfield segment.
567 * @param p_cag_segment9 CAGR Key Flexfield segment.
568 * @param p_cag_segment10 CAGR Key Flexfield segment.
569 * @param p_cag_segment11 CAGR Key Flexfield segment.
570 * @param p_cag_segment12 CAGR Key Flexfield segment.
571 * @param p_cag_segment13 CAGR Key Flexfield segment.
572 * @param p_cag_segment14 CAGR Key Flexfield segment.
573 * @param p_cag_segment15 CAGR Key Flexfield segment.
574 * @param p_cag_segment16 CAGR Key Flexfield segment.
575 * @param p_cag_segment17 CAGR Key Flexfield segment.
576 * @param p_cag_segment18 CAGR Key Flexfield segment.
577 * @param p_cag_segment19 CAGR Key Flexfield segment.
578 * @param p_cag_segment20 CAGR Key Flexfield segment.
579 * @param p_notice_period Length of notice period.
580 * @param p_notice_period_uom Units for notice period. Valid values are defined
581 * in the QUALIFYING_UNITS lookup type.
582 * @param p_employee_category Employee Category. Valid values are defined in
583 * the EMPLOYEE_CATG lookup type.
584 * @param p_work_at_home Indicate whether this assignment is to work at home.
585 * Valid values are defined in the YES_NO lookup type.
586 * @param p_job_post_source_name Name of the source of the job posting that was
587 * answered for this assignment.
588 * @param p_supervisor_assignment_id Supervisor's assignment that is
589 * responsible for supervising this assignment.
590 * @param p_ss_leaving_reason If a value is passed in for this parameter, it
591 * identifies an existing CAGR Key Flexfield combination to associate with the
592 * assignment, and segment values are ignored. If a value is not passed in,
593 * then the individual CAGR Key Flexfield segments supplied will be used to
594 * choose an existing combination or create a new combination. When the API
595 * completes, if p_validate is false, then this uniquely identifies the
596 * associated combination of the CAGR Key flexfield for this assignment. If
597 * p_validate is true, then set to null.
598 * @param p_cagr_grade_def_id CAGR Key Flexfield concatenated segments.
599 * @param p_cagr_concatenated_segments If p_validate is false, then set to CAGR
600 * Key Flexfield concatenated segments. If p_validate is true, then set to
601 * null.
602 * @param p_concatenated_segments If p_validate is false, then set to Soft
603 * Coded Key Flexfield concatenated segments. If p_validate is true, then set
604 * to null.
605 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
606 * it identifies an existing Soft Coded Key Flexfield combination to associate
607 * with the assignment, and segment values are ignored. If a value is not
608 * passed in, then the individual Soft Coded Key Flexfield segments supplied
609 * will be used to choose an existing combination or create a new combination.
610 * When the API completes, if p_validate is false, then this uniquely
611 * identifies the associated combination of the Soft Coded Key flexfield for
612 * this assignment. If p_validate is true, then set to null.
613 * @param p_comment_id If p_validate is false and comment text was provided,
614 * then will be set to the identifier of the created assignment comment record.
615 * If p_validate is true or no comment text was provided, then will be null.
616 * @param p_effective_start_date If p_validate is false, then set to the
617 * earliest effective start date for the created assignment. If p_validate is
618 * true, then set to null.
619 * @param p_effective_end_date If p_validate is false, then set to the
620 * effective end date for the created assignment. If p_validate is true, then
621 * set to null.
622 * @param p_no_managers_warning Set to true if as a result of the update there
623 * is no manager in the organization. Otherwise set to false.
624 * @param p_other_manager_warning If set to true, then a manager existed in the
625 * organization prior to calling this API and the manager flag has been set to
626 * 'Y' for yes.
627 * @param p_hourly_salaried_warning Set to true if values entered for Salary
628 * Basis and Hourly Salaried Code are invalid date as of p_effective_date.
629 * @param p_gsp_post_process_warning Set to the name of a warning message from
630 * the Message Dictionary if any Grade Ladder related errors have been
631 * encountered while running this API.
632 * @rep:displayname Update Employee Assignment for Mexico
633 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
634 * @rep:lifecycle active
635 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
636 * @rep:scope public
637 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
638 */
639 --
640 -- {End Of Comments}
641 --
642 PROCEDURE update_mx_emp_asg
643 ( p_validate IN BOOLEAN DEFAULT false
644 ,p_effective_date IN DATE
645 ,p_datetrack_update_mode IN VARCHAR2
646 ,p_assignment_id IN NUMBER
647 ,p_object_version_number IN OUT NOCOPY NUMBER
648 ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
649 ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
650 ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
651 ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
652 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
653 ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
654 ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
655 ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
656 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
657 ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
658 ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
659 ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
660 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
661 ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
662 ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
663 ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
664 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
665 ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
666 ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
667 ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
668 ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
669 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
670 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
671 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
672 ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
673 ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674 ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
675 ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
676 ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
677 ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
678 ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
679 ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
680 ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
681 ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
682 ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
683 ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
684 ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
685 ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
686 ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
687 ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
688 ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
689 ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
690 ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
691 ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
692 ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
693 ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
694 ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
695 ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
696 ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
697 ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
698 ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
699 ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
700 ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
701 ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
702 ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
703 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
704 ,p_tax_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
705 ,p_timecard_approver IN VARCHAR2 DEFAULT hr_api.g_varchar2
706 ,p_timecard_required IN VARCHAR2 DEFAULT hr_api.g_varchar2
707 ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
708 ,p_gov_emp_sector IN VARCHAR2 DEFAULT hr_api.g_varchar2
709 ,p_ss_salary_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
710 ,p_scl_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
711 ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
712 ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
713 ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
714 ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
715 ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
716 ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
717 ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
718 ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
719 ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
720 ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
721 ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
722 ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
723 ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
724 ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
725 ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
726 ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
727 ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
728 ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
729 ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
730 ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
731 ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
732 ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
733 ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
734 ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
735 ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
736 ,p_notice_period IN NUMBER DEFAULT hr_api.g_number
737 ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
738 ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
739 ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
740 ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
741 ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
742 ,p_ss_leaving_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
743 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
744 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
745 ,p_concatenated_segments OUT NOCOPY VARCHAR2
746 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
747 ,p_comment_id OUT NOCOPY NUMBER
748 ,p_effective_start_date OUT NOCOPY DATE
749 ,p_effective_end_date OUT NOCOPY DATE
750 ,p_no_managers_warning OUT NOCOPY BOOLEAN
751 ,p_other_manager_warning OUT NOCOPY BOOLEAN
752 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
753 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2 );
754 --
755 -- ----------------------------------------------------------------------------
756 -- |------------------------< update_mx_emp_asg_criteria >--------------------|
757 -- ----------------------------------------------------------------------------
758 --
759 -- {Start Of Comments}
760 /*#
761 * This API updates attributes of the employee assignment that affect the
762 * entitlement criteria for any element entry.
763 *
764 *
765 * <p><b>Licensing</b><br>
766 * This API is licensed for use with Human Resources.
767 *
768 * <p><b>Prerequisites</b><br>
769 * The assignment must be an employee assignment. The assignment must exist as
770 * of the effective date of the change
771 *
772 * <p><b>Post Success</b><br>
773 * The API updates the assignment.
774 *
775 * <p><b>Post Failure</b><br>
776 * The API does not update the assignment and raises an error.
777 *
778 * @param p_effective_date Determines when the DateTrack operation comes into
779 * force.
780 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
781 * updating the record. You must set to either UPDATE, CORRECTION,
782 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
783 * particular record depend on the dates of previous record changes and the
784 * effective date of this change.
785 * @param p_assignment_id Identifies the assignment record to be modified.
786 * @param p_validate If true, then validation alone will be performed and the
787 * database will remain unchanged. If false and all validation checks pass,
788 * then the database will be modified.
789 * @param p_called_from_mass_update Set to TRUE if the API is called from the
790 * Mass Update Processes. This defaults Job and Organization information from
791 * the Position information, if the first two are not supplied.
792 * @param p_grade_id Identifies the grade of the assignment.
793 * @param p_position_id Identifies the position of the assignment.
794 * @param p_job_id Identifies the job of the assignment.
795 * @param p_payroll_id Identifies the payroll of this assignment.
796 * @param p_location_id Identifies the location of the assignment.
797 * @param p_organization_id Identifies the organization of the assignment.
798 * @param p_pay_basis_id Salary basis for the assignment.
799 * @param p_segment1 Key flexfield segment.
800 * @param p_segment2 Key flexfield segment.
801 * @param p_segment3 Key flexfield segment.
802 * @param p_segment4 Key flexfield segment.
803 * @param p_segment5 Key flexfield segment.
804 * @param p_segment6 Key flexfield segment.
805 * @param p_segment7 Key flexfield segment.
806 * @param p_segment8 Key flexfield segment.
807 * @param p_segment9 Key flexfield segment.
808 * @param p_segment10 Key flexfield segment.
809 * @param p_segment11 Key flexfield segment.
810 * @param p_segment12 Key flexfield segment.
811 * @param p_segment13 Key flexfield segment.
812 * @param p_segment14 Key flexfield segment.
813 * @param p_segment15 Key flexfield segment.
814 * @param p_segment16 Key flexfield segment.
815 * @param p_segment17 Key flexfield segment.
816 * @param p_segment18 Key flexfield segment.
817 * @param p_segment19 Key flexfield segment.
818 * @param p_segment20 Key flexfield segment.
819 * @param p_segment21 Key flexfield segment.
820 * @param p_segment22 Key flexfield segment.
821 * @param p_segment23 Key flexfield segment.
822 * @param p_segment24 Key flexfield segment.
823 * @param p_segment25 Key flexfield segment.
824 * @param p_segment26 Key flexfield segment.
825 * @param p_segment27 Key flexfield segment.
826 * @param p_segment28 Key flexfield segment.
827 * @param p_segment29 Key flexfield segment.
828 * @param p_segment30 Key flexfield segment.
829 * @param p_employment_category Employment category. Valid values are defined
830 * in the EMP_CAT lookup type.
831 * @param p_concat_segments Concatenated Key Flexfield segments.
832 * @param p_contract_id Contract associated with this assignment.
833 * @param p_establishment_id For French business groups, this identifies the
834 * Establishment Legal Entity for this assignment.
835 * @param p_tax_unit Government Reporting Entity.
836 * @param p_grade_ladder_pgm_id Grade Ladder for this assignment.
837 * @param p_supervisor_assignment_id Supervisor's assignment which is
838 * responsible for supervising this assignment.
839 * @param p_ss_leaving_reason Social Security Leaving Reason to be specified in
840 * case there is a change in the assignment's Government Reporting Entity
841 * (GRE).
842 * @param p_object_version_number Pass in the current version number of the
843 * assignment to be updated. When the API completes if p_validate is false,
844 * will be set to the new version number of the updated assignment. If
845 * p_validate is true will be set to the same value which was passed in.
846 * @param p_special_ceiling_step_id Pass in the highest allowed step for the
847 * grade scale associated with the grade of the assignment. Will be set to null
848 * if the Grade is updated to null. If p_validate is false, then set to the
849 * value of the Ceiling step from the database. If p_validate is true, then set
850 * to the value passed in.
851 * @param p_people_group_id If a value is passed in for this parameter, it
852 * identifies an existing People Group Key Flexfield combination to associate
853 * with the assignment, and segment values are ignored. If a value is not
854 * passed in, then the individual People Group Key Flexfield segments supplied
855 * will be used to choose an existing combination or create a new combination.
856 * When the API completes, if p_validate is false, then this uniquely
857 * identifies the associated combination of the People Group Key flexfield for
858 * this assignment. If p_validate is true, then set to null.
859 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
860 * it identifies an existing Soft Coded Key Flexfield combination to associate
861 * with the assignment, and segment values are ignored. If a value is not
862 * passed in, then the individual Soft Coded Key Flexfield segments supplied
863 * will be used to choose an existing combination or create a new combination.
864 * When the API completes, if p_validate is false, then this uniquely
865 * identifies the associated combination of the Soft Coded Key flexfield for
866 * this assignment. If p_validate is true, then set to null.
867 * @param p_group_name If p_validate is false, then set to the People Group Key
868 * Flexfield concatenated segments. If p_validate is true, then set to null.
869 * @param p_effective_start_date If p_validate is false, then set to the
870 * effective start date on the updated assignment row which now exists as of
871 * the effective date. If p_validate is true, then set to null.
872 * @param p_effective_end_date If p_validate is false, then set to the
873 * effective end date on the updated assignment row which now exists as of the
874 * effective date. If p_validate is true, then set to null.
875 * @param p_org_now_no_manager_warning Set to true if this assignment is a
876 * manager, the organization is updated and there is now no manager in the
877 * previous organization. Set to false if another manager exists in the
878 * previous organization.
879 * @param p_other_manager_warning If set to true, then a manager existed in the
880 * organization prior to calling this API and the manager flag has been set to
881 * 'Y' for yes.
882 * @param p_spp_delete_warning Set to true when grade step and point placements
883 * are date effectively ended or purged by this update. Both types of change
884 * occur when the Grade is changed and spinal point placement rows exist over
885 * the updated date range. Set to false when no grade step and point placements
886 * are affected.
887 * @param p_entries_changed_warning Set to 'Y' when one or more element entries
888 * are changed due to the assignment change. Set to 'S' if at least one salary
889 * element entry is affected. ('S' is a more specific case of 'Y') Set to 'N'
890 * when no element entries are changed.
891 * @param p_tax_district_changed_warning Set to true if the assignment is for a
892 * United Kingdom legislation and the payroll has changed to reflect that.
893 * Otherwise, set to false.
894 * @param p_concatenated_segments If p_validate is false, then set to Soft
895 * Coded Key Flexfield concatenated segments. If p_validate is true, then set
896 * to null.
897 * @param p_gsp_post_process_warning Set to the name of a warning message from
898 * the Message Dictionary if any Grade Ladder related errors have been
899 * encountered while running this API.
900 * @rep:displayname Update Employee Assignment Criteria for Mexico
901 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
902 * @rep:lifecycle active
903 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
904 * @rep:scope public
905 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
906 */
907 --
908 -- {End Of Comments}
909 --
910 PROCEDURE update_mx_emp_asg_criteria
911 (p_effective_date IN DATE
912 ,p_datetrack_update_mode IN VARCHAR2
913 ,p_assignment_id IN NUMBER
914 ,p_validate IN BOOLEAN DEFAULT FALSE
915 ,p_called_from_mass_update IN BOOLEAN DEFAULT FALSE
916 ,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER
917 ,p_position_id IN NUMBER DEFAULT HR_API.G_NUMBER
918 ,p_job_id IN NUMBER DEFAULT HR_API.G_NUMBER
919 ,p_payroll_id IN NUMBER DEFAULT HR_API.G_NUMBER
920 ,p_location_id IN NUMBER DEFAULT HR_API.G_NUMBER
921 ,p_organization_id IN NUMBER DEFAULT HR_API.G_NUMBER
922 ,p_pay_basis_id IN NUMBER DEFAULT HR_API.G_NUMBER
923 ,p_segment1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
924 ,p_segment2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
925 ,p_segment3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
926 ,p_segment4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
927 ,p_segment5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
928 ,p_segment6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
929 ,p_segment7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
930 ,p_segment8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
931 ,p_segment9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
932 ,p_segment10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
933 ,p_segment11 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
934 ,p_segment12 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
935 ,p_segment13 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
936 ,p_segment14 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
937 ,p_segment15 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
938 ,p_segment16 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
939 ,p_segment17 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
940 ,p_segment18 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
941 ,p_segment19 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
942 ,p_segment20 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
943 ,p_segment21 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
944 ,p_segment22 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
945 ,p_segment23 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
946 ,p_segment24 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
947 ,p_segment25 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
948 ,p_segment26 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
949 ,p_segment27 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
950 ,p_segment28 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
951 ,p_segment29 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
952 ,p_segment30 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
953 ,p_employment_category IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
954 ,p_concat_segments IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
955 ,p_contract_id IN NUMBER DEFAULT HR_API.G_NUMBER
956 ,p_establishment_id IN NUMBER DEFAULT HR_API.G_NUMBER
957 ,p_tax_unit IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
958 ,p_grade_ladder_pgm_id IN NUMBER DEFAULT HR_API.G_NUMBER
959 ,p_supervisor_assignment_id IN NUMBER DEFAULT HR_API.G_NUMBER
960 ,p_ss_leaving_reason IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
961 ,p_object_version_number IN OUT NOCOPY NUMBER
962 ,p_special_ceiling_step_id IN OUT NOCOPY NUMBER
963 ,p_people_group_id IN OUT NOCOPY NUMBER
964 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
965 ,p_group_name OUT NOCOPY VARCHAR2
966 ,p_effective_start_date OUT NOCOPY DATE
967 ,p_effective_end_date OUT NOCOPY DATE
968 ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
969 ,p_other_manager_warning OUT NOCOPY BOOLEAN
970 ,p_spp_delete_warning OUT NOCOPY BOOLEAN
971 ,p_entries_changed_warning OUT NOCOPY VARCHAR2
972 ,p_tax_district_changed_warning OUT NOCOPY BOOLEAN
973 ,p_concatenated_segments OUT NOCOPY VARCHAR2
974 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2 );
975 --
976 -- ----------------------------------------------------------------------------
977 -- |-------------------------< mx_final_process_emp_asg >---------------------|
978 -- ----------------------------------------------------------------------------
979 --
980 -- {Start Of Comments}
981 /*#
982 * This API terminates any assignment except the primary assignment.
983 *
984 * This API carries out the second step in terminating an individual employee
985 * assignment. The employee assignment must already have an actual termination
986 * date. The actual termination date is derived from the date when the
987 * assignment status first changes to a TERM_ASSIGN system status. Element
988 * entries for the assignment that have an element termination rule of 'Final
989 * Close' are ended as of the final process date. Element entries for the
990 * assignment that have an element termination rule of 'Last Standard Process'
991 * are ended as of the final process date, if the last standard process date is
992 * later than the final process date.Any cost allocations, grade step/point
993 * placements, cobra coverage benefits and personal payment methods for this
994 * assignment are ended as of the final process date.
995 *
996 * <p><b>Licensing</b><br>
997 * This API is licensed for use with Human Resources.
998 *
999 * <p><b>Prerequisites</b><br>
1000 * The assignment must be a secondary employee assignment. The assignment must
1001 * already have been terminated by a previous call to
1002 * actual_termination_emp_asg.
1003 *
1004 * <p><b>Post Success</b><br>
1005 * The API ends the assignment on the final process date and ends any
1006 * associated element entries.
1007 *
1008 * <p><b>Post Failure</b><br>
1009 * The API does not end the assignment or element entries and raises an error.
1010 *
1011 * @param p_validate If true, then validation alone will be performed and the
1012 * database will remain unchanged. If false and all validation checks pass,
1013 * then the database will be modified.
1014 * @param p_assignment_id Identifies the assignment record to be modified.
1015 * @param p_object_version_number Pass in the current version number of the
1016 * assignment to be updated. When the API completes if p_validate is false,
1017 * will be set to the new version number of the updated assignment. If
1018 * p_validate is true will be set to the same value which was passed in.
1019 * @param p_final_process_date The last date on which the assignment should
1020 * exist.
1021 * @param p_ss_leaving_reason Social Security Leaving Reason for the
1022 * assignment's termination.
1023 * @param p_effective_start_date If p_validate is false, then set to the
1024 * effective start date on the updated assignment row which now exists as of
1025 * the effective date. If p_validate is true, then set to null.
1026 * @param p_effective_end_date If p_validate is false, then set to the
1027 * effective end date on the updated assignment row which now exists as of the
1028 * effective date. If p_validate is true, then set to null.
1029 * @param p_org_now_no_manager_warning Set to true if this assignment had the
1030 * manager flag set to 'Y' and there are no other managers in the assignment's
1031 * organization. Set to false if there is another manager in the assignment's
1032 * organization or if this assignment did not have the manager flag set to 'Y'.
1033 * The warning value only applies as of the final process date.
1034 * @param p_asg_future_changes_warning Set to true if at least one assignment
1035 * change, after the final process date, has been deleted as a result of
1036 * terminating the assignment. (The only valid change after the actual
1037 * termination date is setting the assignment status to another TERM_ASSIGN
1038 * status.) Set to false when there were no changes after final process date.
1039 * @param p_entries_changed_warning Set to 'Y' when at least one element entry
1040 * was altered due to the assignment change. Set to 'S' if at least one salary
1041 * element entry was affected. This is a more specific case than 'Y'. Otherwise
1042 * set to 'N', when no element entries were changed.
1043 * @rep:displayname Final Process Employee Assignment for Mexico
1044 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
1045 * @rep:lifecycle active
1046 * @rep:scope public
1047 */
1048 --
1049 -- {End Of Comments}
1050 --
1051 PROCEDURE mx_final_process_emp_asg
1052 (p_validate IN BOOLEAN DEFAULT FALSE
1053 ,p_assignment_id IN NUMBER
1054 ,p_object_version_number IN OUT NOCOPY NUMBER
1055 ,p_final_process_date IN DATE
1056 ,p_ss_leaving_reason IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1057 ,p_effective_start_date OUT NOCOPY DATE
1058 ,p_effective_end_date OUT NOCOPY DATE
1059 ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
1060 ,p_asg_future_changes_warning OUT NOCOPY BOOLEAN
1061 ,p_entries_changed_warning OUT NOCOPY VARCHAR2
1062 );
1063
1064 END hr_mx_assignment_api ;
[Home] [Help]