1 Package hr_ca_assignment_api as
2 /* $Header: peasgcai.pkh 120.1 2005/10/02 02:10:59 aroussel $ */
3 /*#
4 * This package contains person assignment APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Assignment for Canada
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_ca_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates additional non-primary assignments for an existing employee
17 * in a Canadian Business Group,however this API cannot be used to create the
18 * primary assignment, which gets created at the time of creating an employee.
19 *
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The person (p_person_id) and the organization (p_organization_id) must exist
26 * at the effective start date of the assignment (p_effective_date).
27 *
28 * <p><b>Post Success</b><br>
29 * The secondary assignments will have been successfully inserted into the
30 * database.
31 *
32 * <p><b>Post Failure</b><br>
33 * The secondary assignments will not get created and an error will be raised.
34 * @param p_validate If true,the database remains unchanged.If false a valid
35 * assignment is created in the database.
36 * @param p_effective_date Determines when the DateTrack operation comes into
37 * force
38 * @param p_person_id Identifies the person for whom you create the secondary
39 * assignment record.
40 * @param p_organization_id Organization
41 * @param p_grade_id Grade
42 * @param p_position_id Position
43 * @param p_job_id Job
44 * @param p_assignment_status_type_id Assigmnent status type, the list of
45 * status types come from per_assignment_status_types table .
46 * @param p_payroll_id Payroll
47 * @param p_location_id Location
48 * @param p_supervisor_id Supervisor
49 * @param p_special_ceiling_step_id Special ceiling step
50 * @param p_pay_basis_id Salary basis
51 * @param p_assignment_number Assignment number If an assignment number is not
52 * passed in, a value is generated.
53 * @param p_change_reason Change reason
54 * @param p_comments Secondary Assignment Comments text
55 * @param p_date_probation_end End date of probation period
56 * @param p_default_code_comb_id Foreign key to GL_CODE_COMBINATIONS
57 * @param p_employment_category Employment category
58 * @param p_frequency Frequency for quoting working hours (eg per week)
59 * @param p_internal_address_line Internal address line
60 * @param p_manager_flag Indicates whether employee is a manager
61 * @param p_normal_hours Normal working hours
62 * @param p_perf_review_period Performance review period
63 * @param p_perf_review_period_frequency Units for quoting performance review
64 * period (eg months)
65 * @param p_probation_period Length of probation period
66 * @param p_probation_unit Units for quoting probation period (eg months)
67 * @param p_sal_review_period Salary review period
68 * @param p_sal_review_period_frequency Units for quoting salary review period
69 * (eg months)
70 * @param p_set_of_books_id Set of books (GL)
71 * @param p_source_type Recruitment activity source
72 * @param p_time_normal_finish Normal work finish time
73 * @param p_time_normal_start Normal work start time
74 * @param p_bargaining_unit_code Code for bargaining unit
75 * @param p_labour_union_member_flag Indicates whether employee is a labour
76 * union member
77 * @param p_hourly_salaried_code Hourly or salaried pay code
78 * @param p_ass_attribute_category Descriptive flexfield attribute category
79 * @param p_ass_attribute1 Descriptive flexfield segment.
80 * @param p_ass_attribute2 Descriptive flexfield segment.
81 * @param p_ass_attribute3 Descriptive flexfield segment.
82 * @param p_ass_attribute4 Descriptive flexfield segment.
83 * @param p_ass_attribute5 Descriptive flexfield segment.
84 * @param p_ass_attribute6 Descriptive flexfield segment.
85 * @param p_ass_attribute7 Descriptive flexfield segment.
86 * @param p_ass_attribute8 Descriptive flexfield segment.
87 * @param p_ass_attribute9 Descriptive flexfield segment.
88 * @param p_ass_attribute10 Descriptive flexfield segment.
89 * @param p_ass_attribute11 Descriptive flexfield segment.
90 * @param p_ass_attribute12 Descriptive flexfield segment.
91 * @param p_ass_attribute13 Descriptive flexfield segment.
92 * @param p_ass_attribute14 Descriptive flexfield segment.
93 * @param p_ass_attribute15 Descriptive flexfield segment.
94 * @param p_ass_attribute16 Descriptive flexfield segment.
95 * @param p_ass_attribute17 Descriptive flexfield segment.
96 * @param p_ass_attribute18 Descriptive flexfield segment.
97 * @param p_ass_attribute19 Descriptive flexfield segment.
98 * @param p_ass_attribute20 Descriptive flexfield segment.
99 * @param p_ass_attribute21 Descriptive flexfield segment.
100 * @param p_ass_attribute22 Descriptive flexfield segment.
101 * @param p_ass_attribute23 Descriptive flexfield segment.
102 * @param p_ass_attribute24 Descriptive flexfield segment.
103 * @param p_ass_attribute25 Descriptive flexfield segment.
104 * @param p_ass_attribute26 Descriptive flexfield segment.
105 * @param p_ass_attribute27 Descriptive flexfield segment.
106 * @param p_ass_attribute28 Descriptive flexfield segment.
107 * @param p_ass_attribute29 Descriptive flexfield segment.
108 * @param p_ass_attribute30 Descriptive flexfield segment.
109 * @param p_title Obsolete parameter, do not use.
110 * @param p_tax_unit Tax Unit
111 * @param p_timecard_approver Timecard approver
112 * @param p_timecard_required Timecard required
113 * @param p_work_schedule Work Schedule
114 * @param p_shift Shift
115 * @param p_naic_override_code NAIC override code
116 * @param p_seasonal_worker Seasonal worker
117 * @param p_officer_code Officer code
118 * @param p_wci_account_number WCI account number
119 * @param p_wci_code_override WCI code override
120 * @param p_ca_concat_segments Concat segments for Canada
121 * @param p_pgp_segment1 People group segment
122 * @param p_pgp_segment2 People group segment
123 * @param p_pgp_segment3 People group segment
124 * @param p_pgp_segment4 People group segment
125 * @param p_pgp_segment5 People group segment
126 * @param p_pgp_segment6 People group segment
127 * @param p_pgp_segment7 People group segment
128 * @param p_pgp_segment8 People group segment
129 * @param p_pgp_segment9 People group segment
130 * @param p_pgp_segment10 People group segment
131 * @param p_pgp_segment11 People group segment
132 * @param p_pgp_segment12 People group segment
133 * @param p_pgp_segment13 People group segment
134 * @param p_pgp_segment14 People group segment
135 * @param p_pgp_segment15 People group segment
136 * @param p_pgp_segment16 People group segment
137 * @param p_pgp_segment17 People group segment
138 * @param p_pgp_segment18 People group segment
139 * @param p_pgp_segment19 People group segment
140 * @param p_pgp_segment20 People group segment
141 * @param p_pgp_segment21 People group segment
142 * @param p_pgp_segment22 People group segment
143 * @param p_pgp_segment23 People group segment
144 * @param p_pgp_segment24 People group segment
145 * @param p_pgp_segment25 People group segment
146 * @param p_pgp_segment26 People group segment
147 * @param p_pgp_segment27 People group segment
148 * @param p_pgp_segment28 People group segment
149 * @param p_pgp_segment29 People group segment
150 * @param p_pgp_segment30 People group segment
151 * @param p_pgp_concat_segments People group concat segments
152 * @param p_contract_id Contract
153 * @param p_establishment_id Establishment
154 * @param p_collective_agreement_id Collective Agreement
155 * @param p_cagr_id_flex_num Collective Agreement grade structure
156 * @param p_cag_segment1 Collective agreement grade
157 * @param p_cag_segment2 Collective agreement grade
158 * @param p_cag_segment3 Collective agreement grade
159 * @param p_cag_segment4 Collective agreement grade
160 * @param p_cag_segment5 Collective agreement grade
161 * @param p_cag_segment6 Collective agreement grade
162 * @param p_cag_segment7 Collective agreement grade
163 * @param p_cag_segment8 Collective agreement grade
164 * @param p_cag_segment9 Collective agreement grade
165 * @param p_cag_segment10 Collective agreement grade
166 * @param p_cag_segment11 Collective agreement grade
167 * @param p_cag_segment12 Collective agreement grade
168 * @param p_cag_segment13 Collective agreement grade
169 * @param p_cag_segment14 Collective agreement grade
170 * @param p_cag_segment15 Collective agreement grade
171 * @param p_cag_segment16 Collective agreement grade
172 * @param p_cag_segment17 Collective agreement grade
173 * @param p_cag_segment18 Collective agreement grade
174 * @param p_cag_segment19 Collective agreement grade
175 * @param p_cag_segment20 Collective agreement grade
176 * @param p_cagr_grade_def_id Set to the ID value of the grade if cag_segments
177 * and a cagr_id_flex_num are available
178 * @param p_cagr_concatenated_segments If p_validate is false and any p_segment
179 * parameters have set text, set to the concatenation of all p_segment
180 * parameters with set text. If p_validate is true, or no p_segment parameters
181 * have set text, this will be null.
182 * @param p_assignment_id If p_validate is false, then this uniquely identifies
183 * the created secondary assignment ID. If p_validate is true, then set to
184 * null.
185 * @param p_soft_coding_keyflex_id Soft coding combination ID
186 * @param p_people_group_id People Group combination ID
187 * @param p_object_version_number If p_validate is false, then set to the
188 * version number of the created secondary assignment ID. If p_validate is
189 * true, then the value will be null.
190 * @param p_effective_start_date If p_validate is false, then set to the
191 * earliest effective start date for the created secondary assignment ID. If
192 * p_validate is true, then set to null.
193 * @param p_effective_end_date If p_validate is false, then set to the
194 * effective end date for the created secondary assignment ID. If p_validate is
195 * true, then set to null.
196 * @param p_assignment_sequence If p_validate is false this will be set to the
197 * sequence number of the primary assignment. If p_validate is true this will
198 * be null.
199 * @param p_comment_id If p_validate is false and comment text was provided,
200 * then will be set to the identifier of the created employee assignment
201 * comment record. If p_validate is true or no comment text was provided, then
202 * will be null.
203 * @param p_concatenated_segments Soft Coding combination name
204 * @param p_group_name People Group name
205 * @param p_other_manager_warning Set to true if manager_flag is 'Y' and a
206 * manager already exists in the organization as on the effective date.
207 * @rep:displayname Create Secondary Employee Assignment for Canada
208 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
209 * @rep:scope public
210 * @rep:lifecycle active
211 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
212 */
213 --
214 -- {End Of Comments}
215 --
216 procedure create_ca_secondary_emp_asg
217 (p_validate in boolean default false
218 ,p_effective_date in date
219 ,p_person_id in number
220 ,p_organization_id in number
221 ,p_grade_id in number default null
222 ,p_position_id in number default null
223 ,p_job_id in number default null
224 ,p_assignment_status_type_id in number default null
225 ,p_payroll_id in number default null
226 ,p_location_id in number default null
227 ,p_supervisor_id in number default null
228 ,p_special_ceiling_step_id in number default null
229 ,p_pay_basis_id in number default null
230 ,p_assignment_number in out nocopy varchar2
231 ,p_change_reason in varchar2 default null
232 ,p_comments in varchar2 default null
233 ,p_date_probation_end in date default null
234 ,p_default_code_comb_id in number default null
235 ,p_employment_category in varchar2 default null
236 ,p_frequency in varchar2 default null
237 ,p_internal_address_line in varchar2 default null
238 ,p_manager_flag in varchar2 default null
239 ,p_normal_hours in number default null
240 ,p_perf_review_period in number default null
241 ,p_perf_review_period_frequency in varchar2 default null
242 ,p_probation_period in number default null
243 ,p_probation_unit in varchar2 default null
244 ,p_sal_review_period in number default null
245 ,p_sal_review_period_frequency in varchar2 default null
246 ,p_set_of_books_id in number default null
247 ,p_source_type in varchar2 default null
248 ,p_time_normal_finish in varchar2 default null
249 ,p_time_normal_start in varchar2 default null
250 ,p_bargaining_unit_code in varchar2 default null
251 ,p_labour_union_member_flag in varchar2 default 'N'
252 ,p_hourly_salaried_code in varchar2 default null
253 ,p_ass_attribute_category in varchar2 default null
254 ,p_ass_attribute1 in varchar2 default null
255 ,p_ass_attribute2 in varchar2 default null
256 ,p_ass_attribute3 in varchar2 default null
257 ,p_ass_attribute4 in varchar2 default null
258 ,p_ass_attribute5 in varchar2 default null
259 ,p_ass_attribute6 in varchar2 default null
260 ,p_ass_attribute7 in varchar2 default null
261 ,p_ass_attribute8 in varchar2 default null
262 ,p_ass_attribute9 in varchar2 default null
263 ,p_ass_attribute10 in varchar2 default null
264 ,p_ass_attribute11 in varchar2 default null
265 ,p_ass_attribute12 in varchar2 default null
266 ,p_ass_attribute13 in varchar2 default null
267 ,p_ass_attribute14 in varchar2 default null
268 ,p_ass_attribute15 in varchar2 default null
269 ,p_ass_attribute16 in varchar2 default null
270 ,p_ass_attribute17 in varchar2 default null
271 ,p_ass_attribute18 in varchar2 default null
272 ,p_ass_attribute19 in varchar2 default null
273 ,p_ass_attribute20 in varchar2 default null
274 ,p_ass_attribute21 in varchar2 default null
275 ,p_ass_attribute22 in varchar2 default null
276 ,p_ass_attribute23 in varchar2 default null
277 ,p_ass_attribute24 in varchar2 default null
278 ,p_ass_attribute25 in varchar2 default null
279 ,p_ass_attribute26 in varchar2 default null
280 ,p_ass_attribute27 in varchar2 default null
281 ,p_ass_attribute28 in varchar2 default null
282 ,p_ass_attribute29 in varchar2 default null
283 ,p_ass_attribute30 in varchar2 default null
284 ,p_title in varchar2 default null
285 ,p_tax_unit in varchar2 default null
286 ,p_timecard_approver in varchar2 default null
287 ,p_timecard_required in varchar2 default null
288 ,p_work_schedule in varchar2 default null
289 ,p_shift in varchar2 default null
290 ,p_naic_override_code in varchar2 default null
291 ,p_seasonal_worker in varchar2 default null
292 ,p_officer_code in varchar2 default null
293 ,p_wci_account_number in varchar2 default null
294 ,p_wci_code_override in varchar2 default null
295 ,p_ca_concat_segments in varchar2 default null
296 ,p_pgp_segment1 in varchar2 default null
297 ,p_pgp_segment2 in varchar2 default null
298 ,p_pgp_segment3 in varchar2 default null
299 ,p_pgp_segment4 in varchar2 default null
300 ,p_pgp_segment5 in varchar2 default null
301 ,p_pgp_segment6 in varchar2 default null
302 ,p_pgp_segment7 in varchar2 default null
303 ,p_pgp_segment8 in varchar2 default null
304 ,p_pgp_segment9 in varchar2 default null
305 ,p_pgp_segment10 in varchar2 default null
306 ,p_pgp_segment11 in varchar2 default null
307 ,p_pgp_segment12 in varchar2 default null
308 ,p_pgp_segment13 in varchar2 default null
309 ,p_pgp_segment14 in varchar2 default null
310 ,p_pgp_segment15 in varchar2 default null
311 ,p_pgp_segment16 in varchar2 default null
312 ,p_pgp_segment17 in varchar2 default null
313 ,p_pgp_segment18 in varchar2 default null
314 ,p_pgp_segment19 in varchar2 default null
315 ,p_pgp_segment20 in varchar2 default null
316 ,p_pgp_segment21 in varchar2 default null
317 ,p_pgp_segment22 in varchar2 default null
318 ,p_pgp_segment23 in varchar2 default null
319 ,p_pgp_segment24 in varchar2 default null
320 ,p_pgp_segment25 in varchar2 default null
321 ,p_pgp_segment26 in varchar2 default null
322 ,p_pgp_segment27 in varchar2 default null
323 ,p_pgp_segment28 in varchar2 default null
324 ,p_pgp_segment29 in varchar2 default null
325 ,p_pgp_segment30 in varchar2 default null
326 ,p_pgp_concat_segments in varchar2 default null
327 ,p_contract_id in number default null
328 ,p_establishment_id in number default null
329 ,p_collective_agreement_id in number default null
330 ,p_cagr_id_flex_num in number default null
331 ,p_cag_segment1 in varchar2 default null
332 ,p_cag_segment2 in varchar2 default null
333 ,p_cag_segment3 in varchar2 default null
334 ,p_cag_segment4 in varchar2 default null
335 ,p_cag_segment5 in varchar2 default null
336 ,p_cag_segment6 in varchar2 default null
337 ,p_cag_segment7 in varchar2 default null
338 ,p_cag_segment8 in varchar2 default null
339 ,p_cag_segment9 in varchar2 default null
340 ,p_cag_segment10 in varchar2 default null
341 ,p_cag_segment11 in varchar2 default null
342 ,p_cag_segment12 in varchar2 default null
343 ,p_cag_segment13 in varchar2 default null
344 ,p_cag_segment14 in varchar2 default null
345 ,p_cag_segment15 in varchar2 default null
346 ,p_cag_segment16 in varchar2 default null
347 ,p_cag_segment17 in varchar2 default null
348 ,p_cag_segment18 in varchar2 default null
349 ,p_cag_segment19 in varchar2 default null
350 ,p_cag_segment20 in varchar2 default null
351 ,p_cagr_grade_def_id out nocopy number
352 ,p_cagr_concatenated_segments out nocopy varchar2
353 ,p_assignment_id out nocopy number
354 ,p_soft_coding_keyflex_id out nocopy number
355 ,p_people_group_id out nocopy number
356 ,p_object_version_number out nocopy number
357 ,p_effective_start_date out nocopy date
358 ,p_effective_end_date out nocopy date
359 ,p_assignment_sequence out nocopy number
360 ,p_comment_id out nocopy number
361 ,p_concatenated_segments out nocopy varchar2
362 ,p_group_name out nocopy varchar2
363 ,p_other_manager_warning out nocopy boolean
364 );
365 --
366 -- ----------------------------------------------------------------------------
367 -- |----------------------------< update_ca_emp_asg >-------------------------|
368 -- ----------------------------------------------------------------------------
369 --
370 -- {Start Of Comments}
371 /*#
372 * This package contains person assignment APIs.
373 *
374 * This API updates information for an existing employee assignment with
375 * Canadian legislation by calling the generic API update_emp_asg, with
376 * parameters set as appropriate for a Canadian employee assignment.
377 *
378 * <p><b>Licensing</b><br>
379 * This API is licensed for use with Human Resources.
380 *
381 * <p><b>Prerequisites</b><br>
382 * The assignment (p_assignment_id) must exist as of the effective date of the
383 * update (p_effective_date).
384 *
385 * <p><b>Post Success</b><br>
386 * Updates The Assignment
387 *
388 * <p><b>Post Failure</b><br>
389 * The Assignment will not get updated and an error will be raised.
390 * @param p_validate If true ,the database remains unchanged.if false a valid
391 * assignment is created in the database.
392 * @param p_effective_date The effective start date of this assignment.
393 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
394 * updating the record. You must set to either UPDATE, CORRECTION,
395 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
396 * particular record depend on the dates of previous record changes and the
397 * effective date of this change.
398 * @param p_assignment_id Unique ID for the assignment created by the API.
399 * @param p_object_version_number Pass in the current version number of the
400 * assignment to be updated. When the API completes if p_validate is false,
401 * will be set to the new version number of the updated assignment. If
402 * p_validate is true will be set to the same value which was passed in.
403 * @param p_supervisor_id Supervisor
404 * @param p_assignment_number Assignment number
405 * @param p_change_reason Reason for the change
406 * @param p_comments Secondary Assignment Comment text.
407 * @param p_date_probation_end End date of probation period
408 * @param p_default_code_comb_id Foreign key to GL_CODE_COMBINATIONS
409 * @param p_frequency Frequency for quoting working hours (eg per week)
410 * @param p_internal_address_line Internal address line
411 * @param p_manager_flag Indicates whether the employee is a manager
412 * @param p_normal_hours Normal working hours
413 * @param p_perf_review_period Performance review period
414 * @param p_perf_review_period_frequency Units for quoting performance review
415 * period (eg months)
416 * @param p_probation_period Length of probation period
417 * @param p_probation_unit Units for quoting probation period (eg months)
418 * @param p_sal_review_period Salary review period
419 * @param p_sal_review_period_frequency Units for quoting salary review period
420 * (eg months)
421 * @param p_set_of_books_id Set of books (GL)
422 * @param p_source_type Recruitment activity source
423 * @param p_time_normal_finish Normal work finish time
424 * @param p_time_normal_start Normal work start time
425 * @param p_bargaining_unit_code Code for bargaining unit
426 * @param p_labour_union_member_flag Indicates whether employee is a labour
427 * union member
428 * @param p_hourly_salaried_code Hourly or salaried pay code
429 * @param p_ass_attribute_category Descriptive flexfield attribute category
430 * @param p_ass_attribute1 Descriptive flexfield segment.
431 * @param p_ass_attribute2 Descriptive flexfield segment.
432 * @param p_ass_attribute3 Descriptive flexfield segment.
433 * @param p_ass_attribute4 Descriptive flexfield segment.
434 * @param p_ass_attribute5 Descriptive flexfield segment.
435 * @param p_ass_attribute6 Descriptive flexfield segment.
436 * @param p_ass_attribute7 Descriptive flexfield segment.
437 * @param p_ass_attribute8 Descriptive flexfield segment.
438 * @param p_ass_attribute9 Descriptive flexfield segment.
439 * @param p_ass_attribute10 Descriptive flexfield segment.
440 * @param p_ass_attribute11 Descriptive flexfield segment.
441 * @param p_ass_attribute12 Descriptive flexfield segment.
442 * @param p_ass_attribute13 Descriptive flexfield segment.
443 * @param p_ass_attribute14 Descriptive flexfield segment.
444 * @param p_ass_attribute15 Descriptive flexfield segment.
445 * @param p_ass_attribute16 Descriptive flexfield segment.
446 * @param p_ass_attribute17 Descriptive flexfield segment.
447 * @param p_ass_attribute18 Descriptive flexfield segment.
448 * @param p_ass_attribute19 Descriptive flexfield segment.
449 * @param p_ass_attribute20 Descriptive flexfield segment.
450 * @param p_ass_attribute21 Descriptive flexfield segment.
451 * @param p_ass_attribute22 Descriptive flexfield segment.
452 * @param p_ass_attribute23 Descriptive flexfield segment.
453 * @param p_ass_attribute24 Descriptive flexfield segment.
454 * @param p_ass_attribute25 Descriptive flexfield segment.
455 * @param p_ass_attribute26 Descriptive flexfield segment.
456 * @param p_ass_attribute27 Descriptive flexfield segment.
457 * @param p_ass_attribute28 Descriptive flexfield segment.
458 * @param p_ass_attribute29 Descriptive flexfield segment.
459 * @param p_ass_attribute30 Descriptive flexfield segment.
460 * @param p_title Obsolete parameter, do not use.
461 * @param p_tax_unit Tax Unit
462 * @param p_timecard_approver Timecard approver
463 * @param p_timecard_required Timecard required
464 * @param p_work_schedule Work Schedule
465 * @param p_shift Shift
466 * @param p_naic_override_code NAIC override code
467 * @param p_seasonal_worker Seasonal worker
468 * @param p_officer_code Officer code
469 * @param p_wci_account_number WCI account number
470 * @param p_wci_code_override WCI code override
471 * @param p_ca_concat_segments Concat segments for Canada
472 * @param p_contract_id Collective Agreement
473 * @param p_establishment_id Establishment ID
474 * @param p_collective_agreement_id Collective Agreement ID
475 * @param p_cagr_id_flex_num Collective Agreement grade structure
476 * @param p_cag_segment1 Collective agreement grade
477 * @param p_cag_segment2 Collective agreement grade
478 * @param p_cag_segment3 Collective agreement grade
479 * @param p_cag_segment4 Collective agreement grade
480 * @param p_cag_segment5 Collective agreement grade
481 * @param p_cag_segment6 Collective agreement grade
482 * @param p_cag_segment7 Collective agreement grade
483 * @param p_cag_segment8 Collective agreement grade
484 * @param p_cag_segment9 Collective agreement grade
485 * @param p_cag_segment10 Collective agreement grade
486 * @param p_cag_segment11 Collective agreement grade
487 * @param p_cag_segment12 Collective agreement grade
488 * @param p_cag_segment13 Collective agreement grade
489 * @param p_cag_segment14 Collective agreement grade
490 * @param p_cag_segment15 Collective agreement grade
491 * @param p_cag_segment16 Collective agreement grade
492 * @param p_cag_segment17 Collective agreement grade
493 * @param p_cag_segment18 Collective agreement grade
494 * @param p_cag_segment19 Collective agreement grade
495 * @param p_cag_segment20 Collective agreement grade
496 * @param p_cagr_grade_def_id Set to the ID value of the grade if cag_segments
497 * and a cagr_id_flex_num are available
498 * @param p_cagr_concatenated_segments If p_validate is false and any p_segment
499 * parameters have set text, set to the concatenation of all p_segment
500 * parameters with set text. If p_validate is true, or no p_segment parameters
501 * have set text, this will be null.
502 * @param p_soft_coding_keyflex_id If p_validate is false and any p_segment
503 * parameters have set text, set to the id of the corresponding soft coding
504 * keyflex row. If p_validate is true, or no p_segment parameters have set
505 * text, this will be null.
506 * @param p_comment_id If p_validate is false and new or existing comment text
507 * exists, then will be set to the identifier of the employee's secondary
508 * assignment comment record. If p_validate is true or no comment text exists,
509 * then will be null.
510 * @param p_effective_start_date If p_validate is false, then set to the
511 * effective start date on the updated assignment row which now exists as of
512 * the effective date. If p_validate is true, then set to null.
513 * @param p_effective_end_date If p_validate is false, then set to the
514 * effective end date for the created assignment. If p_validate is true, then
515 * set to null.
516 * @param p_concatenated_segments If p_validate is false and any p_segment
517 * parameters have set text, set to the concatenation of all p_segment
518 * parameters with set text. If p_validate is true, or no p_segment parameters
519 * have set text, this will be null.
520 * @param p_no_managers_warning Set to true if manager_flag is updated from 'Y'
521 * to 'N' and no other manager exists in
522 * @param p_other_manager_warning Set to true if manager flag is changed from
523 * 'N' to 'Y' and a manager already exist in the
524 * organization(p_organization_id) at p_effective_date. Set to false if no
525 * other managers exist in p_organization.This is always set to false if
526 * manager_flag is not updated.
527 * @rep:displayname Update Secondary Employee Assignment for Canada
528 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
529 * @rep:scope public
530 * @rep:lifecycle active
531 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
532 */
533 --
534 -- {End Of Comments}
535 --
536 procedure update_ca_emp_asg
537 (p_validate in boolean default false
538 ,p_effective_date in date
539 ,p_datetrack_update_mode in varchar2
540 ,p_assignment_id in number
541 ,p_object_version_number in out nocopy number
542 ,p_supervisor_id in number default hr_api.g_number
543 ,p_assignment_number in out nocopy varchar2
544 ,p_change_reason in varchar2 default hr_api.g_varchar2
545 ,p_comments in varchar2 default hr_api.g_varchar2
546 ,p_date_probation_end in date default hr_api.g_date
547 ,p_default_code_comb_id in number default hr_api.g_number
548 ,p_frequency in varchar2 default hr_api.g_varchar2
549 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
550 ,p_manager_flag in varchar2 default hr_api.g_varchar2
551 ,p_normal_hours in number default hr_api.g_number
552 ,p_perf_review_period in number default hr_api.g_number
553 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
554 ,p_probation_period in number default hr_api.g_number
555 ,p_probation_unit in varchar2 default hr_api.g_varchar2
556 ,p_sal_review_period in number default hr_api.g_number
557 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
558 ,p_set_of_books_id in number default hr_api.g_number
559 ,p_source_type in varchar2 default hr_api.g_varchar2
560 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
561 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
562 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
563 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
564 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
565 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
566 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
567 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
568 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
569 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
570 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
571 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
572 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
573 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
574 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
575 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
576 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
577 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
578 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
579 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
580 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
581 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
582 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
583 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
584 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
585 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
586 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
587 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
588 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
589 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
590 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
591 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
592 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
593 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
594 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
595 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
596 ,p_title in varchar2 default hr_api.g_varchar2
597 ,p_tax_unit in varchar2 default hr_api.g_varchar2
598 ,p_timecard_approver in varchar2 default hr_api.g_varchar2
599 ,p_timecard_required in varchar2 default hr_api.g_varchar2
600 ,p_work_schedule in varchar2 default hr_api.g_varchar2
601 ,p_shift in varchar2 default hr_api.g_varchar2
602 ,p_naic_override_code in varchar2 default hr_api.g_varchar2
603 ,p_seasonal_worker in varchar2 default hr_api.g_varchar2
604 ,p_officer_code in varchar2 default hr_api.g_varchar2
605 ,p_wci_account_number in varchar2 default hr_api.g_varchar2
606 ,p_wci_code_override in varchar2 default hr_api.g_varchar2
607 ,p_ca_concat_segments in varchar2 default hr_api.g_varchar2
608 ,p_contract_id in number default hr_api.g_number
609 ,p_establishment_id in number default hr_api.g_number
610 ,p_collective_agreement_id in number default hr_api.g_number
611 ,p_cagr_id_flex_num in number default hr_api.g_number
612 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
613 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
614 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
615 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
616 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
617 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
618 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
619 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
620 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
621 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
622 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
623 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
624 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
625 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
626 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
627 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
628 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
629 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
630 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
631 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
632 ,p_cagr_grade_def_id out nocopy number
633 ,p_cagr_concatenated_segments out nocopy varchar2
634 ,p_soft_coding_keyflex_id out nocopy number
635 ,p_comment_id out nocopy number
636 ,p_effective_start_date out nocopy date
637 ,p_effective_end_date out nocopy date
638 ,p_concatenated_segments out nocopy varchar2
639 ,p_no_managers_warning out nocopy boolean
640 ,p_other_manager_warning out nocopy boolean
641 );
642 --
643 end hr_ca_assignment_api;