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