1 PACKAGE hr_cn_assignment_api AUTHID CURRENT_USER AS
2 /* $Header: hrcnwras.pkh 120.4 2011/12/20 11:28:34 jmarupil ship $ */
3 /*#
4 * This package contains assignment APIs for China.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Assignment for China
8 */
9 g_trace boolean := false;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------< create_cn_secondary_emp_asg >--------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a secondary employment assignment of an employee in
18 * business groups using the legislation for China.
19 *
20 * This API calls the generic create_secondary_emp_asg API. It maps certain
21 * columns to user-friendly names appropriate for China so as to ensure easy
22 * identification. As this API is an alternative API, see the generic
23 * create_secondary_emp_asg API for further explanation.
24 *
25 * <p><b>Licensing</b><br>
26 * This API is licensed for use with Human Resources.
27 *
28 * <p><b>Prerequisites</b><br>
29 * The person and the organization must exist at the effective start date of
30 * the assignment. The business group of the person must belong to the Chinese
31 * legislation. See the corresponding generic API for further details.
32 *
33 * <p><b>Post Success</b><br>
34 * The secondary assignment for the employee are created
35 *
36 * <p><b>Post Failure</b><br>
37 * The API does not create the secondary assignment and raises an error.
38 * @param p_validate If true, then validation alone will be performed and the
39 * database will remain unchanged. If false and all validation checks pass,
40 * then the database will be modified.
41 * @param p_effective_date Determines when the DateTrack operation takes
42 * effect.
43 * @param p_person_id Identifies the person for whom you create the Secondary
44 * Assignment record.
45 * @param p_organization_id {@rep:casecolumn
46 * PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID}
47 * @param p_grade_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.GRADE_ID}
48 * @param p_position_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.POSITION_ID}
49 * @param p_job_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.JOB_ID}
50 * @param p_assignment_status_type_id {@rep:casecolumn
51 * PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID}
52 * @param p_payroll_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.PAYROLL_ID}
53 * @param p_location_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.LOCATION_ID}
54 * @param p_supervisor_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID}
55 * @param p_special_ceiling_step_id {@rep:casecolumn
56 * PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID}
57 * @param p_pay_basis_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID}
58 * @param p_assignment_number If the number generation method is Manual then
59 * this parameter is mandatory. If the number generation method is Automatic
60 * then the value of this parameter must be NULL. When the API Completes, if
61 * p_validate is false and the assignment number generation method is Automatic
62 * this will be set to the generated assignment number of the person created.
63 * If p_validate is false and the assignment number generation method is manual
64 * or if p_validate is true this will be set to the value passed.
65 * @param p_change_reason Reason the assignment last changed. Valid values are
66 * defined by the 'EMP_ASSIGN_REASON' lookup type.
67 * @param p_comments If p_validate is false and comment text was provided, then
68 * this will be set to the identifier of the created Secondary Assignment
69 * comment record. If p_validate is true or no comment text was provided, then
70 * this will be null.
71 * @param p_date_probation_end {@rep:casecolumn
72 * PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END}
73 * @param p_default_code_comb_id Foreign key to GL_CODE_COMBINATIONS
74 * @param p_employment_category {@rep:casecolumn
75 * PER_ALL_PEOPLE_F.PER_INFORMATION7}
76 * @param p_frequency Frequency of normal working hours, such as week, month,
77 * or year. Valid values are defined by the 'FREQUENCY' lookup type.
78 * @param p_internal_address_line {@rep:casecolumn
79 * PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE}
80 * @param p_manager_flag Indicates if the assignment has a manager. Valid
81 * values are defined by the 'YES_NO' lookup type.
82 * @param p_normal_hours {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS}
83 * @param p_perf_review_period {@rep:casecolumn
84 * PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD}
85 * @param p_perf_review_period_frequency {@rep:casecolumn
86 * PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY}
87 * @param p_probation_period {@rep:casecolumn
88 * PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD}
89 * @param p_probation_unit {@rep:casecolumn
90 * PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT}
91 * @param p_sal_review_period {@rep:casecolumn
92 * PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD}
93 * @param p_sal_review_period_frequency {@rep:casecolumn
94 * PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY}
95 * @param p_set_of_books_id {@rep:casecolumn
96 * PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID}
97 * @param p_source_type Recruitment activity source for applicant assignment,
98 * for example, Advertisement. Valid values are defined by the 'REC_TYPE'
99 * lookup type.
100 * @param p_time_normal_finish {@rep:casecolumn
101 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH}
102 * @param p_time_normal_start {@rep:casecolumn
103 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START}
104 * @param p_bargaining_unit_code Bargaining unit code. Valid values are defined
105 * by the 'BARGAINING_UNIT_CODE' lookup type.
106 * @param p_labour_union_member_flag Indicates if the assignment is a labour
107 * union member. Valid values are defined by the 'YES_NO' lookup type.
108 * @param p_hourly_salaried_code Identifies if the assignment is paid by the
109 * hour or by a salary. Valid values are defined by the 'HOURLY_SALARIED_CODE'
110 * lookup type.
111 * @param p_ass_attribute_category This context value determines which
112 * Flexfield Structure to use with the Descriptive flexfield segments.
113 * @param p_ass_attribute1 Descriptive flexfield
114 * @param p_ass_attribute2 Descriptive flexfield
115 * @param p_ass_attribute3 Descriptive flexfield
116 * @param p_ass_attribute4 Descriptive flexfield
117 * @param p_ass_attribute5 Descriptive flexfield
118 * @param p_ass_attribute6 Descriptive flexfield
119 * @param p_ass_attribute7 Descriptive flexfield
120 * @param p_ass_attribute8 Descriptive flexfield
121 * @param p_ass_attribute9 Descriptive flexfield
122 * @param p_ass_attribute10 Descriptive flexfield
123 * @param p_ass_attribute11 Descriptive flexfield
124 * @param p_ass_attribute12 Descriptive flexfield
125 * @param p_ass_attribute13 Descriptive flexfield
126 * @param p_ass_attribute14 Descriptive flexfield
127 * @param p_ass_attribute15 Descriptive flexfield
128 * @param p_ass_attribute16 Descriptive flexfield
129 * @param p_ass_attribute17 Descriptive flexfield
130 * @param p_ass_attribute18 Descriptive flexfield
131 * @param p_ass_attribute19 Descriptive flexfield
132 * @param p_ass_attribute20 Descriptive flexfield
133 * @param p_ass_attribute21 Descriptive flexfield
134 * @param p_ass_attribute22 Descriptive flexfield
135 * @param p_ass_attribute23 Descriptive flexfield
136 * @param p_ass_attribute24 Descriptive flexfield
137 * @param p_ass_attribute25 Descriptive flexfield
138 * @param p_ass_attribute26 Descriptive flexfield
139 * @param p_ass_attribute27 Descriptive flexfield
140 * @param p_ass_attribute28 Descriptive flexfield
141 * @param p_ass_attribute29 Descriptive flexfield
142 * @param p_ass_attribute30 Descriptive flexfield
143 * @param p_title Title. This value must be NULL.
144 * @param p_employer_id Registered legal employer for the current assignment.
145 * @param p_tax_area_code Tax area. Valid values are defined by the
146 * 'CN_TAX_AREA' lookup type.
147 * @param p_sic_area_code Social insurance contribution area. Valid values are
148 * defined by the 'CN_SIC_AREA' lookup type.
149 * @param p_salary_payout_locn Salary payout location. Valid values are defined
150 * by the 'CN_PAYOUT_LOCATION' lookup thpe
151 * @param p_scl_concat_segments Concatenated segments for all the people SCL
152 * segments.
153 * @param p_pgp_segment1 People group segment
154 * @param p_pgp_segment2 People group segment
155 * @param p_pgp_segment3 People group segment
156 * @param p_pgp_segment4 People group segment
157 * @param p_pgp_segment5 People group segment
158 * @param p_pgp_segment6 People group segment
159 * @param p_pgp_segment7 People group segment
160 * @param p_pgp_segment8 People group segment
161 * @param p_pgp_segment9 People group segment
162 * @param p_pgp_segment10 People group segment
163 * @param p_pgp_segment11 People group segment
164 * @param p_pgp_segment12 People group segment
165 * @param p_pgp_segment13 People group segment
166 * @param p_pgp_segment14 People group segment
167 * @param p_pgp_segment15 People group segment
168 * @param p_pgp_segment16 People group segment
169 * @param p_pgp_segment17 People group segment
170 * @param p_pgp_segment18 People group segment
171 * @param p_pgp_segment19 People group segment
172 * @param p_pgp_segment20 People group segment
173 * @param p_pgp_segment21 People group segment
174 * @param p_pgp_segment22 People group segment
175 * @param p_pgp_segment23 People group segment
176 * @param p_pgp_segment24 People group segment
177 * @param p_pgp_segment25 People group segment
178 * @param p_pgp_segment26 People group segment
179 * @param p_pgp_segment27 People group segment
180 * @param p_pgp_segment28 People group segment
181 * @param p_pgp_segment29 People group segment
182 * @param p_pgp_segment30 People group segment
183 * @param p_pgp_concat_segments Concatenated segments for all the people group
184 * segments.
185 * @param p_contract_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.CONTRACT_ID}
186 * @param p_establishment_id {@rep:casecolumn
187 * PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID}
188 * @param p_collective_agreement_id {@rep:casecolumn
189 * PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID}
190 * @param p_cagr_id_flex_num {@rep:casecolumn
191 * PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM}
192 * @param p_cag_segment1 Collective agreement grade
193 * @param p_cag_segment2 Collective agreement grade
194 * @param p_cag_segment3 Collective agreement grade
195 * @param p_cag_segment4 Collective agreement grade
196 * @param p_cag_segment5 Collective agreement grade
197 * @param p_cag_segment6 Collective agreement grade
198 * @param p_cag_segment7 Collective agreement grade
199 * @param p_cag_segment8 Collective agreement grade
200 * @param p_cag_segment9 Collective agreement grade
201 * @param p_cag_segment10 Collective agreement grade
202 * @param p_cag_segment11 Collective agreement grade
203 * @param p_cag_segment12 Collective agreement grade
204 * @param p_cag_segment13 Collective agreement grade
205 * @param p_cag_segment14 Collective agreement grade
206 * @param p_cag_segment15 Collective agreement grade
207 * @param p_cag_segment16 Collective agreement grade
208 * @param p_cag_segment17 Collective agreement grade
209 * @param p_cag_segment18 Collective agreement grade
210 * @param p_cag_segment19 Collective agreement grade
211 * @param p_cag_segment20 Collective agreement grade
212 * @param p_notice_period Notice Period
213 * @param p_notice_period_uom Notice period units. Valid values are defined by
214 * the 'QUALIFYING_UNITS' lookup type.
215 * @param p_employee_category User defined category. For example Full-Time
216 * Permanent or Part-Time Permanent. Known as the Assignment Category. Valid
217 * values are defined by the 'EMP_CAT' lookup type.
218 * @param p_work_at_home Indicates if the assignment works at home.Valid values
219 * are defined by the 'YES_NO' lookup type.
220 * @param p_job_post_source_name Job Source
221 * @param p_group_name If p_validate is false, if the people group key
222 * combination already exists then the current people group name will be
223 * returned. If p_validate is true, the people group name will be set to null.
224 * @param p_concatenated_segments If p_validate is false, this returns the
225 * concatenation of all p_segment parameters. If p_validate is true or no
226 * p_segment parameters have been set, this will be null.
227 * @param p_cagr_grade_def_id If p_validate is false and if the cag_segments
228 * and a cagr_id_flex_num are available, this is set to the ID value of the
229 * grade. If p_validate is true, id willl be assignments current value.
230 * @param p_cagr_concatenated_segments If p_validate is false and any p_segment
231 * parameters have set text, set to the concatenation of all p_segment
232 * parameters with set text. If p_validate is true, or no p_segment parameters
233 * have set text, this will be null.
234 * @param p_assignment_id If p_validate is false, then this uniquely identifies
235 * the created assignment. If p_validate is true, then set to null.
236 * @param p_soft_coding_keyflex_id If p_validate is false, if the Soft coding
237 * key combination already exists then the current ID will be returned. If
238 * p_validate is true, the id will be the assignments current value.
239 * @param p_people_group_id If p_validate is false, if the people group key
240 * combination already exists then the current people group id will be
241 * returned. If p_validate is true, the id will be the assignments current
242 * value.
243 * @param p_object_version_number If p_validate is false, then set to the
244 * version number of the created Secondary Assignment. If p_validate is true,
245 * then the 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 Secondary Assignment. If
248 * p_validate is 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 Secondary Assignment. If p_validate is
251 * true, then set to null.
252 * @param p_assignment_sequence If p_validate is false, returns the sequence of
253 * the current assignment. If p_validate is true, this value will be null.
254 * @param p_comment_id If p_validate is false and comment text was provided,
255 * then will be set to the identifier of the created Secondary Assignment
256 * comment record. If p_validate is true or no comment text was provided, then
257 * will be null.
258 * @param p_other_manager_warning If set to true, then a manager existed in the
259 * organization prior to calling this API and the manager flag has been set to
260 * 'Y' for yes.
261 * @param p_hourly_salaried_warning If the combination values entered for
262 * pay_basis and hourly_salaried_code are invalid date p_effective_date, then
263 * this is set to true.
264 * @param p_special_tax_exmp_category New parameter, available on the latest
265 * version of this API.
266 * @rep:displayname Create Secondary Employee Assignment for China
267 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
268 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
269 * @rep:scope public
270 * @rep:lifecycle active
271 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
272 */
273 --
274 -- {End Of Comments}
275 --
276 PROCEDURE create_cn_secondary_emp_asg
277 (p_validate IN BOOLEAN DEFAULT false
278 ,p_effective_date IN DATE
279 ,p_person_id IN NUMBER
280 ,p_organization_id IN NUMBER
281 ,p_grade_id IN NUMBER DEFAULT null
282 ,p_position_id IN NUMBER DEFAULT null
283 ,p_job_id IN NUMBER DEFAULT null
284 ,p_assignment_status_type_id IN NUMBER DEFAULT null
285 ,p_payroll_id IN NUMBER DEFAULT null
286 ,p_location_id IN NUMBER DEFAULT null
287 ,p_supervisor_id IN NUMBER DEFAULT null
288 ,p_special_ceiling_step_id IN NUMBER DEFAULT null
289 ,p_pay_basis_id IN NUMBER DEFAULT null
290 ,p_assignment_number IN OUT NOCOPY VARCHAR2
291 ,p_change_reason IN VARCHAR2 DEFAULT null
292 ,p_comments IN hr_comments.comment_text%TYPE DEFAULT null
293 ,p_date_probation_end IN DATE DEFAULT null
294 ,p_default_code_comb_id IN NUMBER DEFAULT null
295 ,p_employment_category IN VARCHAR2 DEFAULT null
296 ,p_frequency IN VARCHAR2 DEFAULT null
297 ,p_internal_address_line IN VARCHAR2 DEFAULT null
298 ,p_manager_flag IN VARCHAR2 DEFAULT null
299 ,p_normal_hours IN NUMBER DEFAULT null
300 ,p_perf_review_period IN NUMBER DEFAULT null
301 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT null
302 ,p_probation_period IN NUMBER DEFAULT null
303 ,p_probation_unit IN VARCHAR2 DEFAULT null
304 ,p_sal_review_period IN NUMBER DEFAULT null
305 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT null
306 ,p_set_of_books_id IN NUMBER DEFAULT null
307 ,p_source_type IN VARCHAR2 DEFAULT null
308 ,p_time_normal_finish IN VARCHAR2 DEFAULT null
309 ,p_time_normal_start IN VARCHAR2 DEFAULT null
310 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT null
311 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT null
312 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT null
313 ,p_ass_attribute_category IN VARCHAR2 DEFAULT null
314 ,p_ass_attribute1 IN VARCHAR2 DEFAULT null
315 ,p_ass_attribute2 IN VARCHAR2 DEFAULT null
316 ,p_ass_attribute3 IN VARCHAR2 DEFAULT null
317 ,p_ass_attribute4 IN VARCHAR2 DEFAULT null
318 ,p_ass_attribute5 IN VARCHAR2 DEFAULT null
319 ,p_ass_attribute6 IN VARCHAR2 DEFAULT null
320 ,p_ass_attribute7 IN VARCHAR2 DEFAULT null
321 ,p_ass_attribute8 IN VARCHAR2 DEFAULT null
322 ,p_ass_attribute9 IN VARCHAR2 DEFAULT null
323 ,p_ass_attribute10 IN VARCHAR2 DEFAULT null
324 ,p_ass_attribute11 IN VARCHAR2 DEFAULT null
325 ,p_ass_attribute12 IN VARCHAR2 DEFAULT null
326 ,p_ass_attribute13 IN VARCHAR2 DEFAULT null
327 ,p_ass_attribute14 IN VARCHAR2 DEFAULT null
328 ,p_ass_attribute15 IN VARCHAR2 DEFAULT null
329 ,p_ass_attribute16 IN VARCHAR2 DEFAULT null
330 ,p_ass_attribute17 IN VARCHAR2 DEFAULT null
331 ,p_ass_attribute18 IN VARCHAR2 DEFAULT null
332 ,p_ass_attribute19 IN VARCHAR2 DEFAULT null
333 ,p_ass_attribute20 IN VARCHAR2 DEFAULT null
334 ,p_ass_attribute21 IN VARCHAR2 DEFAULT null
335 ,p_ass_attribute22 IN VARCHAR2 DEFAULT null
336 ,p_ass_attribute23 IN VARCHAR2 DEFAULT null
337 ,p_ass_attribute24 IN VARCHAR2 DEFAULT null
338 ,p_ass_attribute25 IN VARCHAR2 DEFAULT null
339 ,p_ass_attribute26 IN VARCHAR2 DEFAULT null
340 ,p_ass_attribute27 IN VARCHAR2 DEFAULT null
341 ,p_ass_attribute28 IN VARCHAR2 DEFAULT null
342 ,p_ass_attribute29 IN VARCHAR2 DEFAULT null
343 ,p_ass_attribute30 IN VARCHAR2 DEFAULT null
344 ,p_title IN VARCHAR2 DEFAULT null
345 ,p_employer_id IN VARCHAR2
346 ,p_tax_area_code IN VARCHAR2
347 ,p_sic_area_code IN VARCHAR2 -- Bug 2955433 removed Default
348 ,p_salary_payout_locn IN VARCHAR2 DEFAULT null
349 ,p_special_tax_exmp_category IN VARCHAR2 DEFAULT null -- Bug 3828396 Added the change
350 ,p_scl_concat_segments IN VARCHAR2 DEFAULT null
351 ,p_pgp_segment1 IN VARCHAR2 DEFAULT null
352 ,p_pgp_segment2 IN VARCHAR2 DEFAULT null
353 ,p_pgp_segment3 IN VARCHAR2 DEFAULT null
354 ,p_pgp_segment4 IN VARCHAR2 DEFAULT null
355 ,p_pgp_segment5 IN VARCHAR2 DEFAULT null
356 ,p_pgp_segment6 IN VARCHAR2 DEFAULT null
357 ,p_pgp_segment7 IN VARCHAR2 DEFAULT null
358 ,p_pgp_segment8 IN VARCHAR2 DEFAULT null
359 ,p_pgp_segment9 IN VARCHAR2 DEFAULT null
360 ,p_pgp_segment10 IN VARCHAR2 DEFAULT null
361 ,p_pgp_segment11 IN VARCHAR2 DEFAULT null
362 ,p_pgp_segment12 IN VARCHAR2 DEFAULT null
363 ,p_pgp_segment13 IN VARCHAR2 DEFAULT null
364 ,p_pgp_segment14 IN VARCHAR2 DEFAULT null
365 ,p_pgp_segment15 IN VARCHAR2 DEFAULT null
366 ,p_pgp_segment16 IN VARCHAR2 DEFAULT null
367 ,p_pgp_segment17 IN VARCHAR2 DEFAULT null
368 ,p_pgp_segment18 IN VARCHAR2 DEFAULT null
369 ,p_pgp_segment19 IN VARCHAR2 DEFAULT null
370 ,p_pgp_segment20 IN VARCHAR2 DEFAULT null
371 ,p_pgp_segment21 IN VARCHAR2 DEFAULT null
372 ,p_pgp_segment22 IN VARCHAR2 DEFAULT null
373 ,p_pgp_segment23 IN VARCHAR2 DEFAULT null
374 ,p_pgp_segment24 IN VARCHAR2 DEFAULT null
375 ,p_pgp_segment25 IN VARCHAR2 DEFAULT null
376 ,p_pgp_segment26 IN VARCHAR2 DEFAULT null
377 ,p_pgp_segment27 IN VARCHAR2 DEFAULT null
378 ,p_pgp_segment28 IN VARCHAR2 DEFAULT null
379 ,p_pgp_segment29 IN VARCHAR2 DEFAULT null
380 ,p_pgp_segment30 IN VARCHAR2 DEFAULT null
381 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT null
382 ,p_contract_id IN NUMBER DEFAULT null
383 ,p_establishment_id IN NUMBER DEFAULT null
384 ,p_collective_agreement_id IN NUMBER DEFAULT null
385 ,p_cagr_id_flex_num IN NUMBER DEFAULT null
386 ,p_cag_segment1 IN VARCHAR2 DEFAULT null
387 ,p_cag_segment2 IN VARCHAR2 DEFAULT null
388 ,p_cag_segment3 IN VARCHAR2 DEFAULT null
389 ,p_cag_segment4 IN VARCHAR2 DEFAULT null
390 ,p_cag_segment5 IN VARCHAR2 DEFAULT null
391 ,p_cag_segment6 IN VARCHAR2 DEFAULT null
392 ,p_cag_segment7 IN VARCHAR2 DEFAULT null
393 ,p_cag_segment8 IN VARCHAR2 DEFAULT null
394 ,p_cag_segment9 IN VARCHAR2 DEFAULT null
395 ,p_cag_segment10 IN VARCHAR2 DEFAULT null
396 ,p_cag_segment11 IN VARCHAR2 DEFAULT null
397 ,p_cag_segment12 IN VARCHAR2 DEFAULT null
398 ,p_cag_segment13 IN VARCHAR2 DEFAULT null
399 ,p_cag_segment14 IN VARCHAR2 DEFAULT null
400 ,p_cag_segment15 IN VARCHAR2 DEFAULT null
401 ,p_cag_segment16 IN VARCHAR2 DEFAULT null
402 ,p_cag_segment17 IN VARCHAR2 DEFAULT null
403 ,p_cag_segment18 IN VARCHAR2 DEFAULT null
404 ,p_cag_segment19 IN VARCHAR2 DEFAULT null
405 ,p_cag_segment20 IN VARCHAR2 DEFAULT null
406 ,p_notice_period IN NUMBER DEFAULT null
407 ,p_notice_period_uom IN VARCHAR2 DEFAULT null
408 ,p_employee_category IN VARCHAR2 DEFAULT null
409 ,p_work_at_home IN VARCHAR2 DEFAULT null
410 ,p_job_post_source_name IN VARCHAR2 DEFAULT null
411 ,p_group_name OUT NOCOPY VARCHAR2
412 ,p_concatenated_segments OUT NOCOPY VARCHAR2
413 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
414 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
415 ,p_assignment_id OUT NOCOPY NUMBER
416 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
417 ,p_people_group_id IN OUT NOCOPY NUMBER
418 ,p_object_version_number OUT NOCOPY NUMBER
419 ,p_effective_start_date OUT NOCOPY DATE
420 ,p_effective_end_date OUT NOCOPY DATE
421 ,p_assignment_sequence OUT NOCOPY NUMBER
422 ,p_comment_id OUT NOCOPY NUMBER
423 ,p_other_manager_warning OUT NOCOPY BOOLEAN
424 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN );
425 --
426 -- ----------------------------------------------------------------------------
427 -- |----------------------------< update_cn_emp_asg >-------------------------|
428 -- ----------------------------------------------------------------------------
429 --
430 -- {Start Of Comments}
431 /*#
432 * This API updates employee assignment details of an employee within a
433 * business group using the legislation for China.
434 *
435 * The API calls the generic update_emp_asg API. It maps certain columns to
436 * user-friendly names appropriate for China so as to ensure easy
437 * identification. As this API is an alternative API, see the generic
438 * update_emp_asg API for further explanation.
439 *
440 * <p><b>Licensing</b><br>
441 * This API is licensed for use with Human Resources.
442 *
443 * <p><b>Prerequisites</b><br>
444 * The assignment must exist as of the effective date of the update. The
445 * business group of the person must belong to the Chinese legislation. See the
446 * corresponding generic API for further details.
447 *
448 * <p><b>Post Success</b><br>
449 * The assignment will be updated with the new details.
450 *
451 * <p><b>Post Failure</b><br>
452 * The API does not update the assignment and raises an error.
453 * @param p_validate If true, then validation alone will be performed and the
454 * database will remain unchanged. If false and all validation checks pass,
455 * then the database will be modified.
456 * @param p_effective_date Determines when the DateTrack operation takes
457 * effect.
458 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
459 * updating the record. You must set to either UPDATE, CORRECTION,
460 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
461 * particular record depend on the dates of previous record changes and the
462 * effective date of this change.
463 * @param p_assignment_id Identifies the assignment record to be modified.
464 * @param p_object_version_number Passes in the current version number of the
465 * Assignment to be updated. When the API completes if p_validate is false,
466 * this will be set to the new version number of the updated Assignment. If
467 * p_validate is true this will be set to the same value which was passed in.
468 * @param p_supervisor_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID}
469 * @param p_assignment_number The business group's assignment number generation
470 * method determines when you can update the employee value. To keep the
471 * existing employee number, it passes in hr_api.g_varchar2. When the API call
472 * completes, if p_validate is true then it will be set to the employee.
473 * @param p_change_reason The reason the assignment last changed. Valid values
474 * are defined by the 'EMP_ASSIGN_REASON' lookup type.
475 * @param p_assignment_status_type_id {@rep:casecolumn
476 * PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID}
477 * @param p_comments If p_validate is false and new or existing comment text
478 * exists, then this will be set to the identifier of the Assignment comment
479 * record. If p_validate is true or no comment text exists, then this will be
480 * null.
481 * @param p_date_probation_end {@rep:casecolumn
482 * PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END}
483 * @param p_default_code_comb_id Foreign key to GL_CODE_COMBINATIONS
484 * @param p_frequency Frequency of normal working hours, such as week, month,
485 * and year. Valid values are defined by the 'FREQUENCY' lookup type.
486 * @param p_internal_address_line {@rep:casecolumn
487 * PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE}
488 * @param p_manager_flag Indicates if the assignment has a manager. Valid
489 * values are defined by the 'YES_NO' lookup type.
490 * @param p_normal_hours {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS}
491 * @param p_perf_review_period {@rep:casecolumn
492 * PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD}
493 * @param p_perf_review_period_frequency {@rep:casecolumn
494 * PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY}
495 * @param p_probation_period {@rep:casecolumn
496 * PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD}
497 * @param p_probation_unit Units of probation period duration. Valid values are
498 * defined by the 'QUALIFYING_UNITS' lookup type.
499 * @param p_sal_review_period {@rep:casecolumn
500 * PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD}
501 * @param p_sal_review_period_frequency {@rep:casecolumn
502 * PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY}
503 * @param p_set_of_books_id {@rep:casecolumn
504 * PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID}
505 * @param p_source_type Recruitment activity source for the applicant
506 * assignment, for example, Advertisement. Valid values are defined by the
507 * 'REC_TYPE' lookup type.
508 * @param p_time_normal_finish {@rep:casecolumn
509 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH}
510 * @param p_time_normal_start {@rep:casecolumn
511 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START}
512 * @param p_bargaining_unit_code Bargaining unit code. Valid values are defined
513 * by the 'BARGAINING_UNIT_CODE' lookup type.
514 * @param p_labour_union_member_flag Indicates if the assignment is a labour
515 * union member. Valid values are defined by the 'YES_NO' lookup type.
516 * @param p_hourly_salaried_code Identifies if the assignment is paid by the
517 * hour or by a salary. Valid values are defined by the 'HOURLY_SALARIED_CODE'
518 * lookup type.
519 * @param p_ass_attribute_category This context value determines which
520 * Flexfield Structure to use with the Descriptive flexfield segments.
521 * @param p_ass_attribute1 Descriptive flexfield
522 * @param p_ass_attribute2 Descriptive flexfield
523 * @param p_ass_attribute3 Descriptive flexfield
524 * @param p_ass_attribute4 Descriptive flexfield
525 * @param p_ass_attribute5 Descriptive flexfield
526 * @param p_ass_attribute6 Descriptive flexfield
527 * @param p_ass_attribute7 Descriptive flexfield
528 * @param p_ass_attribute8 Descriptive flexfield
529 * @param p_ass_attribute9 Descriptive flexfield
530 * @param p_ass_attribute10 Descriptive flexfield
531 * @param p_ass_attribute11 Descriptive flexfield
532 * @param p_ass_attribute12 Descriptive flexfield
533 * @param p_ass_attribute13 Descriptive flexfield
534 * @param p_ass_attribute14 Descriptive flexfield
535 * @param p_ass_attribute15 Descriptive flexfield
536 * @param p_ass_attribute16 Descriptive flexfield
537 * @param p_ass_attribute17 Descriptive flexfield
538 * @param p_ass_attribute18 Descriptive flexfield
539 * @param p_ass_attribute19 Descriptive flexfield
540 * @param p_ass_attribute20 Descriptive flexfield
541 * @param p_ass_attribute21 Descriptive flexfield
542 * @param p_ass_attribute22 Descriptive flexfield
543 * @param p_ass_attribute23 Descriptive flexfield
544 * @param p_ass_attribute24 Descriptive flexfield
545 * @param p_ass_attribute25 Descriptive flexfield
546 * @param p_ass_attribute26 Descriptive flexfield
547 * @param p_ass_attribute27 Descriptive flexfield
548 * @param p_ass_attribute28 Descriptive flexfield
549 * @param p_ass_attribute29 Descriptive flexfield
550 * @param p_ass_attribute30 Descriptive flexfield
551 * @param p_title Title e.g. Mr, Mrs, Dr. Valid values are defined by the
552 * 'TITLE' lookup type.
553 * @param p_employer_id Registered legal employer for the current assignment.
554 * @param p_tax_area_code Tax area. Valid values are defined by the
555 * 'CN_TAX_AREA' lookup type.
556 * @param p_sic_area_code Social insurance contribution area. Valid values are
557 * defined by the 'CN_SIC_AREA' lookup type.
558 * @param p_salary_payout_locn Salary payout location. Valid values are defined
559 * by the 'CN_PAYOUT_LOCATION' lookup thpe
560 * @param p_concat_segments Concatenated segments for all the people SCL
561 * segments.
562 * @param p_contract_id PER_ALL_ASSIGNMENTS_F.CONTRACT_ID
563 * @param p_establishment_id PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID
564 * @param p_collective_agreement_id
565 * PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID
566 * @param p_cagr_id_flex_num PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM
567 * @param p_cag_segment1 Collective agreement grade
568 * @param p_cag_segment2 Collective agreement grade
569 * @param p_cag_segment3 Collective agreement grade
570 * @param p_cag_segment4 Collective agreement grade
571 * @param p_cag_segment5 Collective agreement grade
572 * @param p_cag_segment6 Collective agreement grade
573 * @param p_cag_segment7 Collective agreement grade
574 * @param p_cag_segment8 Collective agreement grade
575 * @param p_cag_segment9 Collective agreement grade
576 * @param p_cag_segment10 Collective agreement grade
577 * @param p_cag_segment11 Collective agreement grade
578 * @param p_cag_segment12 Collective agreement grade
579 * @param p_cag_segment13 Collective agreement grade
580 * @param p_cag_segment14 Collective agreement grade
581 * @param p_cag_segment15 Collective agreement grade
582 * @param p_cag_segment16 Collective agreement grade
583 * @param p_cag_segment17 Collective agreement grade
584 * @param p_cag_segment18 Collective agreement grade
585 * @param p_cag_segment19 Collective agreement grade
586 * @param p_cag_segment20 Collective agreement grade
587 * @param p_notice_period Notice Period
588 * @param p_notice_period_uom Notice period units. Valid values are defined by
589 * the 'QUALIFYING_UNITS' lookup type.
590 * @param p_employee_category User defined category. For example Full-Time
591 * Permanent or Part-Time Permanent. Known as the Assignment Category. Valid
592 * values are defined by the 'EMP_CAT' lookup type.
593 * @param p_work_at_home Indicates if the employee works at home.Valid values
594 * are defined by the 'YES_NO' lookup type.
595 * @param p_job_post_source_name Job Source
596 * @param p_cagr_grade_def_id If p_validate is false and if the cag_segments
597 * and a cagr_id_flex_num are available, this is set to the ID value of the
598 * grade. If p_validate is true, id willl be assignments current value.
599 * @param p_cagr_concatenated_segments If p_validate is false and any p_segment
600 * parameters have set text, set to the concatenation of all p_segment
601 * parameters with set text. If p_validate is true, or no p_segment parameters
602 * have set text, this will be null.
603 * @param p_concatenated_segments If p_validate is false and any p_segment
604 * parameters have set text, set to the concatenation of all p_segment
605 * parameters with set text. If p_validate is true, or no p_segment parameters
606 * have set text, this will be null.
607 * @param p_soft_coding_keyflex_id If p_validate is false and any p_segment
608 * parameters have set text, set to the id of the corresponding soft coding
609 * keyflex row. If p_validate is true, or no p_segment parameters have set
610 * text, this will be null.
611 * @param p_comment_id If p_validate is false and new or existing comment text
612 * exists, then will be set to the identifier of the Assignment comment record.
613 * If p_validate is true or no comment text exists, then will be null.
614 * @param p_effective_start_date If p_validate is false, then set to the
615 * effective start date on the updated Assignment row which now exists as of
616 * the effective date. If p_validate is true, then set to null.
617 * @param p_effective_end_date If p_validate is false, then set to the
618 * effective end date on the updated Assignment row which now exists as of the
619 * effective date. If p_validate is true, then set to null.
620 * @param p_no_managers_warning If the manager_flag is updated from 'Y' to 'N'
621 * and no other manager exists, this is set to true.
622 * @param p_other_manager_warning If set to true, then a manager existed in the
623 * organization prior to calling this API and the manager flag has been set to
624 * 'Y' for yes.
625 * @param p_hourly_salaried_warning If there is an invalid combination for
626 * pay_basis and hourly_salaried_code, this is set to True.
627 * @param p_special_tax_exmp_category New parameter, available on the latest
628 * version of this API.
629 * @rep:displayname Update Employee Assignment for China
630 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
631 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
632 * @rep:scope public
633 * @rep:lifecycle active
634 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
635 */
636 --
637 -- {End Of Comments}
638 --
639 PROCEDURE update_cn_emp_asg
640 ( p_validate IN BOOLEAN DEFAULT false
641 ,p_effective_date IN DATE
642 ,p_datetrack_update_mode IN VARCHAR2
643 ,p_assignment_id IN NUMBER
644 ,p_object_version_number IN OUT NOCOPY NUMBER
645 ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
646 ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
647 ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
648 ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
649 ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
650 ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
651 ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
652 ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
653 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
654 ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
655 ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
656 ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
657 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
658 ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
659 ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
660 ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
661 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
662 ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
663 ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
664 ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
665 ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
666 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
667 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
668 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
669 ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
670 ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671 ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672 ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673 ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674 ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
675 ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
676 ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
677 ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
678 ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
679 ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
680 ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
681 ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
682 ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
683 ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
684 ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
685 ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
686 ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
687 ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
688 ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
689 ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
690 ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
691 ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
692 ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
693 ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
694 ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
695 ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
696 ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
697 ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
698 ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
699 ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
700 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
701 ,p_employer_id IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Bug 2955433 added DEFAULT
702 ,p_tax_area_code IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Bug 2955433 added DEFAULT
703 ,p_sic_area_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
704 ,p_salary_payout_locn IN VARCHAR2 DEFAULT hr_api.g_varchar2
705 ,p_special_tax_exmp_category IN VARCHAR2 DEFAULT hr_api.g_varchar2 -- Bug 3828396 added the change
706 ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
707 ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
708 ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
709 ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
710 ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
711 ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
712 ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
713 ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
714 ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
715 ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
716 ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
717 ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
718 ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
719 ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
720 ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
721 ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
722 ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
723 ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
724 ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
725 ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
726 ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
727 ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
728 ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
729 ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
730 ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
731 ,p_notice_period IN NUMBER DEFAULT hr_api.g_number
732 ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
733 ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
734 ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
735 ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
736 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
737 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
738 ,p_concatenated_segments OUT NOCOPY VARCHAR2
739 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
740 ,p_comment_id OUT NOCOPY NUMBER
741 ,p_effective_start_date OUT NOCOPY DATE
742 ,p_effective_end_date OUT NOCOPY DATE
743 ,p_no_managers_warning OUT NOCOPY BOOLEAN
744 ,p_other_manager_warning OUT NOCOPY BOOLEAN
745 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN );
746
747 END hr_cn_assignment_api;