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