1 PACKAGE hr_pl_assignment_api AS
2 /* $Header: peasgpli.pkh 120.5 2005/12/01 03:26:19 mseshadr noship $ */
3 /*#
4 * This package contains assignment APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Assignment for Poland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_pl_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API(older version) creates secondary assignment for an employee.
17 *
18 * This API is an alternative to the API create_secondary_emp_asg. If
19 * p_validate is set to false, an assignment is created.
20 *
21 * <P> This version of the API is now out-of-date however it has been provided
22 * to you for backward compatibility support and will be removed in the future.
23 * Oracle recommends you to modify existing calling programs in advance of the
24 * support being withdrawn thus avoiding any potential disruption.
25 *
26 * <p><b>Licensing</b><br>
27 * This API is licensed for use with Human Resources.
28 *
29 * <p><b>Prerequisites</b><br>
30 * The employee must have been created already and must exist at the effective
31 * start date of the assignment.
32 *
33 * <p><b>Post Success</b><br>
34 * A new secondary assignment is created for the employee.
35 *
36 * <p><b>Post Failure</b><br>
37 * The API does not create the assignment and raises an error.
38 *
39 * @param p_validate If true, then validation alone will be performed and the
40 * database will remain unchanged. If false and all validation checks pass,
41 * then the database will be modified.
42 * @param p_effective_date Determines when the DateTrack operation comes into
43 * force.
44 * @param p_person_id Identifies the person for whom you create the secondary
45 * assignment record.
46 * @param p_organization_id Identifies the organization of the secondary
47 * assignment.
48 * @param p_grade_id Identifies the grade of the secondary assignment.
49 * @param p_position_id Identifies the position of the secondary assignment.
50 * @param p_job_id Identifies the job of the secondary assignment.
51 * @param p_assignment_status_type_id Identifies the assignment status of the
52 * secondary assignment. Valid values are defined by 'PER_ASS_SYS_STATUS'
53 * lookup type.
54 * @param p_payroll_id Identifies the payroll for the secondary assignment.
55 * @param p_location_id Identifies the location of the secondary assignment.
56 * @param p_supervisor_id Identifies the supervisor for the secondary
57 * assignment. The value refers to the supervisor's person record.
58 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
59 * associated with the grade of the secondary assignment.
60 * @param p_pay_basis_id Salary basis for the secondary assignment.
61 * @param p_assignment_number If a value is passed in, this is used as the
62 * assignment number. If no value is passed in an assignment number is
63 * generated.
64 * @param p_change_reason Reason for the assignment status change. If there is
65 * no change reason the parameter can be null. Valid values are defined in the
66 * 'EMP_ASSIGN_REASON' lookup type.
67 * @param p_comments Comment text.
68 * @param p_date_probation_end End date of probation period.
69 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
70 * Flexfield combination that applies to this assignment.
71 * @param p_employment_category Employment category of the assignment. Valid
72 * values are defined in the 'EMP_CAT' lookup type.
73 * @param p_frequency Frequency associated with the defined normal working
74 * hours. Valid values are defined in the 'FREQUENCY' lookup type.
75 * @param p_internal_address_line Internal address identified with the
76 * secondary assignment.
77 * @param p_manager_flag Indicates whether the employee is a manager.
78 * @param p_normal_hours Normal working hours for this assignment.
79 * @param p_perf_review_period Length of performance review period.
80 * @param p_perf_review_period_frequency Units of performance review period.
81 * Valid values are defined in the 'FREQUENCY' lookup type.
82 * @param p_probation_period Length of probation period.
83 * @param p_probation_unit Units of probation period. Valid values are defined
84 * in the 'QUALIFYING_UNITS' lookup type.
85 * @param p_sal_review_period Length of salary review period.
86 * @param p_sal_review_period_frequency Units of salary review period. Valid
87 * values are defined in the 'FREQUENCY' lookup type.
88 * @param p_set_of_books_id Identifies General Ledger set of books.
89 * @param p_source_type Recruitment activity which this assignment is sourced
90 * from. Valid values are defined in the 'REC_TYPE' lookup type.
91 * @param p_time_normal_finish Work end time.
92 * @param p_time_normal_start Work start time.
93 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
94 * defined in the 'BARGAINING_UNIT_CODE' lookup type.
95 * @param p_labour_union_member_flag Indicates whether the employee is a labour
96 * union member.
97 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
98 * is salaried. Valid values are defined in the 'HOURLY_SALARIED_CODE' lookup
99 * type.
100 * @param p_ass_attribute_category This context value determines which
101 * Flexfield Structure to use with the Descriptive flexfield segments.
102 * @param p_ass_attribute1 Descriptive flexfield segment.
103 * @param p_ass_attribute2 Descriptive flexfield segment.
104 * @param p_ass_attribute3 Descriptive flexfield segment.
105 * @param p_ass_attribute4 Descriptive flexfield segment.
106 * @param p_ass_attribute5 Descriptive flexfield segment.
107 * @param p_ass_attribute6 Descriptive flexfield segment.
108 * @param p_ass_attribute7 Descriptive flexfield segment.
109 * @param p_ass_attribute8 Descriptive flexfield segment.
110 * @param p_ass_attribute9 Descriptive flexfield segment.
111 * @param p_ass_attribute10 Descriptive flexfield segment.
112 * @param p_ass_attribute11 Descriptive flexfield segment.
113 * @param p_ass_attribute12 Descriptive flexfield segment.
114 * @param p_ass_attribute13 Descriptive flexfield segment.
115 * @param p_ass_attribute14 Descriptive flexfield segment.
116 * @param p_ass_attribute15 Descriptive flexfield segment.
117 * @param p_ass_attribute16 Descriptive flexfield segment.
118 * @param p_ass_attribute17 Descriptive flexfield segment.
119 * @param p_ass_attribute18 Descriptive flexfield segment.
120 * @param p_ass_attribute19 Descriptive flexfield segment.
121 * @param p_ass_attribute20 Descriptive flexfield segment.
122 * @param p_ass_attribute21 Descriptive flexfield segment.
123 * @param p_ass_attribute22 Descriptive flexfield segment.
124 * @param p_ass_attribute23 Descriptive flexfield segment.
125 * @param p_ass_attribute24 Descriptive flexfield segment.
126 * @param p_ass_attribute25 Descriptive flexfield segment.
127 * @param p_ass_attribute26 Descriptive flexfield segment.
128 * @param p_ass_attribute27 Descriptive flexfield segment.
129 * @param p_ass_attribute28 Descriptive flexfield segment.
130 * @param p_ass_attribute29 Descriptive flexfield segment.
131 * @param p_ass_attribute30 Descriptive flexfield segment.
132 * @param p_title Obsolete parameter, do not use.
133 * @param p_scl_segment1 Soft Coded key flexfield segment.
134 * @param p_legal_employer Legal Employer of the assignment.
135 * @param p_scl_segment3 Soft Coded key flexfield segment.
136 * @param p_scl_segment4 Soft Coded key flexfield segment.
137 * @param p_scl_segment5 Soft Coded key flexfield segment.
138 * @param p_scl_segment6 Soft Coded key flexfield segment.
139 * @param p_scl_segment7 Soft Coded key flexfield segment.
140 * @param p_scl_segment8 Soft Coded key flexfield segment.
141 * @param p_scl_segment9 Soft Coded key flexfield segment.
142 * @param p_scl_segment10 Soft Coded key flexfield segment.
143 * @param p_scl_segment11 Soft Coded key flexfield segment.
144 * @param p_scl_segment12 Soft Coded key flexfield segment.
145 * @param p_scl_segment13 Soft Coded key flexfield segment.
146 * @param p_scl_segment14 Soft Coded key flexfield segment.
147 * @param p_scl_segment15 Soft Coded key flexfield segment.
148 * @param p_scl_segment16 Soft Coded key flexfield segment.
149 * @param p_scl_segment17 Soft Coded key flexfield segment.
150 * @param p_scl_segment18 Soft Coded key flexfield segment.
151 * @param p_scl_segment19 Soft Coded key flexfield segment.
152 * @param p_scl_segment20 Soft Coded key flexfield segment.
153 * @param p_scl_segment21 Soft Coded key flexfield segment.
154 * @param p_scl_segment22 Soft Coded key flexfield segment.
155 * @param p_scl_segment23 Soft Coded key flexfield segment.
156 * @param p_scl_segment24 Soft Coded key flexfield segment.
157 * @param p_scl_segment25 Soft Coded key flexfield segment.
158 * @param p_scl_segment26 Soft Coded key flexfield segment.
159 * @param p_scl_segment27 Soft Coded key flexfield segment.
160 * @param p_scl_segment28 Soft Coded key flexfield segment.
161 * @param p_scl_segment29 Soft Coded key flexfield segment.
162 * @param p_scl_segment30 Soft Coded key flexfield segment.
163 * @param p_scl_concat_segments Concatenated segments for Soft Coded Key
164 * Flexfield. Concatenated segments can be supplied instead of individual
165 * segments.
166 * @param p_pgp_segment1 People group key flexfield segment.
167 * @param p_pgp_segment2 People group key flexfield segment.
168 * @param p_pgp_segment3 People group key flexfield segment.
169 * @param p_pgp_segment4 People group key flexfield segment.
170 * @param p_pgp_segment5 People group key flexfield segment.
171 * @param p_pgp_segment6 People group key flexfield segment.
172 * @param p_pgp_segment7 People group key flexfield segment.
173 * @param p_pgp_segment8 People group key flexfield segment.
174 * @param p_pgp_segment9 People group key flexfield segment.
175 * @param p_pgp_segment10 People group key flexfield segment.
176 * @param p_pgp_segment11 People group key flexfield segment.
177 * @param p_pgp_segment12 People group key flexfield segment.
178 * @param p_pgp_segment13 People group key flexfield segment.
179 * @param p_pgp_segment14 People group key flexfield segment.
180 * @param p_pgp_segment15 People group key flexfield segment.
181 * @param p_pgp_segment16 People group key flexfield segment.
182 * @param p_pgp_segment17 People group key flexfield segment.
183 * @param p_pgp_segment18 People group key flexfield segment.
184 * @param p_pgp_segment19 People group key flexfield segment.
185 * @param p_pgp_segment20 People group key flexfield segment.
186 * @param p_pgp_segment21 People group key flexfield segment.
187 * @param p_pgp_segment22 People group key flexfield segment.
188 * @param p_pgp_segment23 People group key flexfield segment.
189 * @param p_pgp_segment24 People group key flexfield segment.
190 * @param p_pgp_segment25 People group key flexfield segment.
191 * @param p_pgp_segment26 People group key flexfield segment.
192 * @param p_pgp_segment27 People group key flexfield segment.
193 * @param p_pgp_segment28 People group key flexfield segment.
194 * @param p_pgp_segment29 People group key flexfield segment.
195 * @param p_pgp_segment30 People group key flexfield segment.
196 * @param p_pgp_concat_segments Concatenated segments for People Group Key
197 * Flexfield. Concatenated segments can be supplied instead of individual
198 * segments.
199 * @param p_contract_id Contract associated with this assignment.
200 * @param p_establishment_id This identifies the establishment Legal Entity for
201 * this assignment.
202 * @param p_collective_agreement_id Collective Agreement that applies to this
203 * assignment.
204 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
205 * flexfield to use for this assignment.
206 * @param p_cag_segment1 CAGR Key Flexfield segment.
207 * @param p_cag_segment2 CAGR Key Flexfield segment.
208 * @param p_cag_segment3 CAGR Key Flexfield segment.
209 * @param p_cag_segment4 CAGR Key Flexfield segment.
210 * @param p_cag_segment5 CAGR Key Flexfield segment.
211 * @param p_cag_segment6 CAGR Key Flexfield segment.
212 * @param p_cag_segment7 CAGR Key Flexfield segment.
213 * @param p_cag_segment8 CAGR Key Flexfield segment.
214 * @param p_cag_segment9 CAGR Key Flexfield segment.
215 * @param p_cag_segment10 CAGR Key Flexfield segment.
216 * @param p_cag_segment11 CAGR Key Flexfield segment.
217 * @param p_cag_segment12 CAGR Key Flexfield segment.
218 * @param p_cag_segment13 CAGR Key Flexfield segment.
219 * @param p_cag_segment14 CAGR Key Flexfield segment.
220 * @param p_cag_segment15 CAGR Key Flexfield segment.
221 * @param p_cag_segment16 CAGR Key Flexfield segment.
222 * @param p_cag_segment17 CAGR Key Flexfield segment.
223 * @param p_cag_segment18 CAGR Key Flexfield segment.
224 * @param p_cag_segment19 CAGR Key Flexfield segment.
225 * @param p_cag_segment20 CAGR Key Flexfield segment.
226 * @param p_notice_period Length of notice period.
227 * @param p_notice_period_uom Units for notice period. Valid values are defined
228 * in the 'QUALIFYING_UNITS' lookup type.
229 * @param p_employee_category Employee Category of the assignment. Valid values
230 * are defined in the 'EMPLOYEE_CATG' lookup type.
231 * @param p_work_at_home Indicates working from home. Valid values are defined
232 * in the 'YES_NO' lookup type.
233 * @param p_job_post_source_name The source of the job posting that was
234 * answered for this assignment.
235 * @param p_grade_ladder_pgm_id Grade Ladder for this assignment.
236 * @param p_supervisor_assignment_id Supervisor's assignment identification
237 * that is responsible for supervising this assignment.
238 * @param p_group_name If p_validate is false, set to the People Group Key
239 * Flexfield concatenated segments. If p_validate is true, set to null.
240 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
241 * Flexfield concatenated segments, if p_validate is true, set to null.
242 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
243 * identifies an existing CAGR Key Flexfield combination to associate with the
244 * assignment, and the segment values are ignored. If a value is not passed in,
245 * then the individual CAGR Key Flexfield segments supplied will be used to
246 * choose an existing combination or create a new combination. When the API
247 * completes, if p_validate is false, then this uniquely identifies the
248 * associated combination of the CAGR Key flexfield for this assignment. If
249 * p_validate is true, then set to null.
250 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
251 * segments.
252 * @param p_assignment_id If p_validate is false, then this uniquely identifies
253 * the created assignment. If p_validate is true, then set to null.
254 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
255 * it identifies an existing Soft Coded Key Flexfield combination to associate
256 * with the assignment, and segment values are ignored. If a value is not
257 * passed in, then the individual Soft Coded Key Flexfield segments supplied
258 * will be used to choose an existing combination or create a new combination.
259 * When the API completes, if p_validate is false, then this uniquely
260 * identifies the associated combination of the Soft Coded Key flexfield for
261 * this assignment. If p_validate is true, then set to null.
262 * @param p_people_group_id If a value is passed in for this parameter, it
263 * identifies an existing People Group Key Flexfield combination to associate
264 * with the assignment, and segment values are ignored. If a value is not
265 * passed in, then the individual People Group Key Flexfield segments supplied
266 * will be used to choose an existing combination or create a new combination.
267 * When the API completes, if p_validate is false, then this uniquely
268 * identifies the associated combination of the People Group Key flexfield for
269 * this assignment. If p_validate is true, then set to null.
270 * @param p_object_version_number If p_validate is false, then set to the
271 * version number of the created assignment. If p_validate is true, then the
272 * value will be null.
273 * @param p_effective_start_date If p_validate is false, then set to the
274 * earliest effective start date for the created assignment. If p_validate is
275 * true, then set to null.
276 * @param p_effective_end_date If p_validate is false, then set to the
277 * effective end date for the created assignment. If p_validate is true, then
278 * set to null.
279 * @param p_assignment_sequence If p_validate is false, then an automatically
280 * incremented number is associated with this assignment, depending on the
284 * then will be set to the identifier of the created assignment comment record.
281 * number of assignment which already exist. If p_validate is true then set to
282 * null.
283 * @param p_comment_id If p_validate is false and comment text was provided,
285 * If p_validate is true or no comment text was provided, then will be null.
286 * @param p_other_manager_warning If set to true, then a manager existed in the
287 * organization prior to calling this API and the manager flag has been set to
288 * 'Y' for yes.
289 * @param p_hourly_salaried_warning Set to true if values entered for Salary
290 * Basis and Hourly Salaried Code are invalid as of p_effective_date.
291 * @param p_gsp_post_process_warning Set to the name of a warning message from
292 * the Message Dictionary if any Grade Ladder related errors have been
293 * encountered while running this API.
294 * @rep:displayname Create Secondary Employee Assignment for Poland
295 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
296 * @rep:lifecycle deprecated
297 * @rep:scope public
298 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
299 */
300 --
301 -- {End Of Comments}
302 --
303 Procedure create_pl_secondary_emp_asg
304 (p_validate in boolean default false
305 ,p_effective_date in date
306 ,p_person_id in number
307 ,p_organization_id in number
308 ,p_grade_id in number default null
309 ,p_position_id in number default null
310 ,p_job_id in number default null
311 ,p_assignment_status_type_id in number default null
312 ,p_payroll_id in number default null
313 ,p_location_id in number default null
314 ,p_supervisor_id in number default null
315 ,p_special_ceiling_step_id in number default null
316 ,p_pay_basis_id in number default null
317 ,p_assignment_number in out nocopy varchar2
318 ,p_change_reason in varchar2 default null
319 ,p_comments in varchar2 default null
320 ,p_date_probation_end in date default null
321 ,p_default_code_comb_id in number default null
322 ,p_employment_category in varchar2 default null
323 ,p_frequency in varchar2 default null
324 ,p_internal_address_line in varchar2 default null
325 ,p_manager_flag in varchar2 default null
326 ,p_normal_hours in number default null
327 ,p_perf_review_period in number default null
328 ,p_perf_review_period_frequency in varchar2 default null
329 ,p_probation_period in number default null
330 ,p_probation_unit in varchar2 default null
331 ,p_sal_review_period in number default null
332 ,p_sal_review_period_frequency in varchar2 default null
333 ,p_set_of_books_id in number default null
334 ,p_source_type in varchar2 default null
335 ,p_time_normal_finish in varchar2 default null
336 ,p_time_normal_start in varchar2 default null
337 ,p_bargaining_unit_code in varchar2 default null
338 ,p_labour_union_member_flag in varchar2 default 'N'
339 ,p_hourly_salaried_code in varchar2 default null
340 ,p_ass_attribute_category in varchar2 default null
341 ,p_ass_attribute1 in varchar2 default null
342 ,p_ass_attribute2 in varchar2 default null
343 ,p_ass_attribute3 in varchar2 default null
344 ,p_ass_attribute4 in varchar2 default null
345 ,p_ass_attribute5 in varchar2 default null
346 ,p_ass_attribute6 in varchar2 default null
347 ,p_ass_attribute7 in varchar2 default null
348 ,p_ass_attribute8 in varchar2 default null
349 ,p_ass_attribute9 in varchar2 default null
350 ,p_ass_attribute10 in varchar2 default null
351 ,p_ass_attribute11 in varchar2 default null
352 ,p_ass_attribute12 in varchar2 default null
353 ,p_ass_attribute13 in varchar2 default null
354 ,p_ass_attribute14 in varchar2 default null
355 ,p_ass_attribute15 in varchar2 default null
356 ,p_ass_attribute16 in varchar2 default null
357 ,p_ass_attribute17 in varchar2 default null
358 ,p_ass_attribute18 in varchar2 default null
359 ,p_ass_attribute19 in varchar2 default null
360 ,p_ass_attribute20 in varchar2 default null
361 ,p_ass_attribute21 in varchar2 default null
362 ,p_ass_attribute22 in varchar2 default null
363 ,p_ass_attribute23 in varchar2 default null
364 ,p_ass_attribute24 in varchar2 default null
365 ,p_ass_attribute25 in varchar2 default null
366 ,p_ass_attribute26 in varchar2 default null
367 ,p_ass_attribute27 in varchar2 default null
368 ,p_ass_attribute28 in varchar2 default null
369 ,p_ass_attribute29 in varchar2 default null
370 ,p_ass_attribute30 in varchar2 default null
371 ,p_title in varchar2 default null
372 ,p_scl_segment1 in varchar2 default null
373 ,p_legal_employer in varchar2 default null
374 ,p_scl_segment3 in varchar2 default null
375 ,p_scl_segment4 in varchar2 default null
379 ,p_scl_segment8 in varchar2 default null
376 ,p_scl_segment5 in varchar2 default null
377 ,p_scl_segment6 in varchar2 default null
378 ,p_scl_segment7 in varchar2 default null
380 ,p_scl_segment9 in varchar2 default null
381 ,p_scl_segment10 in varchar2 default null
382 ,p_scl_segment11 in varchar2 default null
383 ,p_scl_segment12 in varchar2 default null
384 ,p_scl_segment13 in varchar2 default null
385 ,p_scl_segment14 in varchar2 default null
386 ,p_scl_segment15 in varchar2 default null
387 ,p_scl_segment16 in varchar2 default null
388 ,p_scl_segment17 in varchar2 default null
389 ,p_scl_segment18 in varchar2 default null
390 ,p_scl_segment19 in varchar2 default null
391 ,p_scl_segment20 in varchar2 default null
392 ,p_scl_segment21 in varchar2 default null
393 ,p_scl_segment22 in varchar2 default null
394 ,p_scl_segment23 in varchar2 default null
395 ,p_scl_segment24 in varchar2 default null
396 ,p_scl_segment25 in varchar2 default null
397 ,p_scl_segment26 in varchar2 default null
398 ,p_scl_segment27 in varchar2 default null
399 ,p_scl_segment28 in varchar2 default null
400 ,p_scl_segment29 in varchar2 default null
401 ,p_scl_segment30 in varchar2 default null
402 ,p_scl_concat_segments in varchar2 default null
403 ,p_pgp_segment1 in varchar2 default null
404 ,p_pgp_segment2 in varchar2 default null
405 ,p_pgp_segment3 in varchar2 default null
406 ,p_pgp_segment4 in varchar2 default null
407 ,p_pgp_segment5 in varchar2 default null
408 ,p_pgp_segment6 in varchar2 default null
409 ,p_pgp_segment7 in varchar2 default null
410 ,p_pgp_segment8 in varchar2 default null
411 ,p_pgp_segment9 in varchar2 default null
412 ,p_pgp_segment10 in varchar2 default null
413 ,p_pgp_segment11 in varchar2 default null
414 ,p_pgp_segment12 in varchar2 default null
415 ,p_pgp_segment13 in varchar2 default null
416 ,p_pgp_segment14 in varchar2 default null
417 ,p_pgp_segment15 in varchar2 default null
418 ,p_pgp_segment16 in varchar2 default null
419 ,p_pgp_segment17 in varchar2 default null
420 ,p_pgp_segment18 in varchar2 default null
421 ,p_pgp_segment19 in varchar2 default null
422 ,p_pgp_segment20 in varchar2 default null
423 ,p_pgp_segment21 in varchar2 default null
424 ,p_pgp_segment22 in varchar2 default null
425 ,p_pgp_segment23 in varchar2 default null
426 ,p_pgp_segment24 in varchar2 default null
427 ,p_pgp_segment25 in varchar2 default null
428 ,p_pgp_segment26 in varchar2 default null
429 ,p_pgp_segment27 in varchar2 default null
430 ,p_pgp_segment28 in varchar2 default null
431 ,p_pgp_segment29 in varchar2 default null
432 ,p_pgp_segment30 in varchar2 default null
433 ,p_pgp_concat_segments in varchar2 default null
434 ,p_contract_id in number default null
435 ,p_establishment_id in number default null
436 ,p_collective_agreement_id in number default null
437 ,p_cagr_id_flex_num in number default null
438 ,p_cag_segment1 in varchar2 default null
439 ,p_cag_segment2 in varchar2 default null
440 ,p_cag_segment3 in varchar2 default null
441 ,p_cag_segment4 in varchar2 default null
442 ,p_cag_segment5 in varchar2 default null
443 ,p_cag_segment6 in varchar2 default null
444 ,p_cag_segment7 in varchar2 default null
445 ,p_cag_segment8 in varchar2 default null
446 ,p_cag_segment9 in varchar2 default null
447 ,p_cag_segment10 in varchar2 default null
448 ,p_cag_segment11 in varchar2 default null
449 ,p_cag_segment12 in varchar2 default null
450 ,p_cag_segment13 in varchar2 default null
451 ,p_cag_segment14 in varchar2 default null
452 ,p_cag_segment15 in varchar2 default null
453 ,p_cag_segment16 in varchar2 default null
454 ,p_cag_segment17 in varchar2 default null
455 ,p_cag_segment18 in varchar2 default null
456 ,p_cag_segment19 in varchar2 default null
457 ,p_cag_segment20 in varchar2 default null
458 ,p_notice_period in number default null
459 ,p_notice_period_uom in varchar2 default null
460 ,p_employee_category in varchar2 default null
461 ,p_work_at_home in varchar2 default null
462 ,p_job_post_source_name in varchar2 default null
463 ,p_grade_ladder_pgm_id in number default null
464 ,p_supervisor_assignment_id in number default null
465 ,p_group_name out nocopy varchar2
466 ,p_concatenated_segments out nocopy varchar2
467 ,p_cagr_grade_def_id in out nocopy number
468 ,p_cagr_concatenated_segments out nocopy varchar2
469 ,p_assignment_id out nocopy number
470 ,p_soft_coding_keyflex_id in out nocopy number
471 ,p_people_group_id in out nocopy number
472 ,p_object_version_number out nocopy number
473 ,p_effective_start_date out nocopy date
474 ,p_effective_end_date out nocopy date
475 ,p_assignment_sequence out nocopy number
476 ,p_comment_id out nocopy number
477 ,p_other_manager_warning out nocopy boolean
478 ,p_hourly_salaried_warning out nocopy boolean
482 -- ----------------------------------------------------------------------------
479 ,p_gsp_post_process_warning out nocopy varchar2
480 );
481 --
483 -- |----------------------------< update_pl_emp_asg >-------------------------|
484 -- ----------------------------------------------------------------------------
485 --
486 -- {Start Of Comments}
487 /*#
488 * This API(older version) updates employee assignment details which do not
489 * affect entitlement to element entries.
490 *
491 * This API is an alternative to the API update_emp_asg. If p_validate is set
492 * to false, then the assignment record is updated. Also this API updates an
493 * employee assignment status. The new status must have a system status of
494 * ACTIVE_ASSIGN. If the assignment status is already a type of ACTIVE_ASSIGN,
495 * this API can be used to set a different active status. If the calling
496 * routine does not explicitly pass in a status, the API uses the default
497 * ACTIVE_ASSIGN status for the assignment's business group. Note: Only
498 * employee assignments can be altered with this API. Updates to an applicant
499 * assignment status are not allowed.
500 *
501 * <P> This version of the API is now out-of-date however it has been provided
502 * to you for backward compatibility support and will be removed in the future.
503 * Oracle recommends you to modify existing calling programs in advance of the
504 * support being withdrawn thus avoiding any potential disruption.
505 *
506 * <p><b>Licensing</b><br>
507 * This API is licensed for use with Human Resources.
508 *
509 * <p><b>Prerequisites</b><br>
510 * The assignment must exist as of the effective date and must be an employee
511 * assignment.
512 *
513 * <p><b>Post Success</b><br>
514 * The assignment will have been updated.
515 *
516 * <p><b>Post Failure</b><br>
517 * The assignment will not be updated and an error will be raised.
518 *
519 * @param p_validate If true, then validation alone will be performed and the
520 * database will remain unchanged. If false and all validation checks pass,
521 * then the database will be modified.
522 * @param p_effective_date Determines when the DateTrack operation comes into
523 * force.
524 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
525 * updating the record. You must set to either UPDATE, CORRECTION,
526 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
527 * particular record depend on the dates of previous record changes and the
528 * effective date of this change.
529 * @param p_assignment_id Identifies the assignment record to modify.
530 * @param p_object_version_number Pass in the current version number of the
531 * assignment to be updated. When the API completes if p_validate is false,
532 * will be set to the new version number of the updated assignment. If
533 * p_validate is true will be set to the same value which was passed in.
534 * @param p_supervisor_id Supervisor for the assignment. The value refers to
535 * the supervisor's person record.
536 * @param p_assignment_number Assignment number.
537 * @param p_change_reason Reason for the assignment status change. If there is
538 * no change reason, then the parameter can be null. Valid values are defined
539 * in the 'EMP_ASSIGN_REASON' lookup type.
540 * @param p_assignment_status_type_id Assignment status. The system status must
544 * @param p_date_probation_end End date of probation period.
541 * be the same as before the update, otherwise one of the status change APIs
542 * should be used.
543 * @param p_comments Comment text.
545 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
546 * Flexfield combination that applies to this assignment.
547 * @param p_frequency Frequency associated with the defined normal working
548 * hours. Valid values are defined in the 'FREQUENCY' lookup type.
549 * @param p_internal_address_line Internal address identified with this
550 * assignment.
551 * @param p_manager_flag Indicates whether the employee is a manager.
552 * @param p_normal_hours Normal working hours for this assignment.
553 * @param p_perf_review_period Length of performance review period.
554 * @param p_perf_review_period_frequency Units of performance review period.
555 * Valid values are defined in the 'FREQUENCY' lookup type.
556 * @param p_probation_period Length of probation period.
557 * @param p_probation_unit Units of probation period. Valid values are defined
558 * in the 'QUALIFYING_UNITS' lookup type.
559 * @param p_sal_review_period Length of salary review period.
560 * @param p_sal_review_period_frequency Units of salary review period. Valid
561 * values are defined in the 'FREQUENCY' lookup type.
562 * @param p_set_of_books_id Identifies General Ledger set of books.
563 * @param p_source_type Recruitment activity which this assignment is sourced
564 * from. Valid values are defined in the 'REC_TYPE' lookup type.
565 * @param p_time_normal_finish Work end time.
566 * @param p_time_normal_start Work start time.
567 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
568 * defined in the 'BARGAINING_UNIT_CODE' lookup type.
569 * @param p_labour_union_member_flag Indicates whether the employee is a labour
570 * union member.
571 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
572 * is salaried. Valid values defined in the 'HOURLY_SALARIED_CODE' lookup type.
573 * @param p_ass_attribute_category This context value determines which
574 * Flexfield Structure to use with the Descriptive flexfield segments.
575 * @param p_ass_attribute1 Descriptive flexfield segment.
576 * @param p_ass_attribute2 Descriptive flexfield segment.
577 * @param p_ass_attribute3 Descriptive flexfield segment.
578 * @param p_ass_attribute4 Descriptive flexfield segment.
579 * @param p_ass_attribute5 Descriptive flexfield segment.
580 * @param p_ass_attribute6 Descriptive flexfield segment.
581 * @param p_ass_attribute7 Descriptive flexfield segment.
582 * @param p_ass_attribute8 Descriptive flexfield segment.
583 * @param p_ass_attribute9 Descriptive flexfield segment.
584 * @param p_ass_attribute10 Descriptive flexfield segment.
585 * @param p_ass_attribute11 Descriptive flexfield segment.
586 * @param p_ass_attribute12 Descriptive flexfield segment.
587 * @param p_ass_attribute13 Descriptive flexfield segment.
588 * @param p_ass_attribute14 Descriptive flexfield segment.
589 * @param p_ass_attribute15 Descriptive flexfield segment.
590 * @param p_ass_attribute16 Descriptive flexfield segment.
591 * @param p_ass_attribute17 Descriptive flexfield segment.
592 * @param p_ass_attribute18 Descriptive flexfield segment.
593 * @param p_ass_attribute19 Descriptive flexfield segment.
594 * @param p_ass_attribute20 Descriptive flexfield segment.
595 * @param p_ass_attribute21 Descriptive flexfield segment.
596 * @param p_ass_attribute22 Descriptive flexfield segment.
597 * @param p_ass_attribute23 Descriptive flexfield segment.
598 * @param p_ass_attribute24 Descriptive flexfield segment.
599 * @param p_ass_attribute25 Descriptive flexfield segment.
600 * @param p_ass_attribute26 Descriptive flexfield segment.
601 * @param p_ass_attribute27 Descriptive flexfield segment.
602 * @param p_ass_attribute28 Descriptive flexfield segment.
603 * @param p_ass_attribute29 Descriptive flexfield segment.
604 * @param p_ass_attribute30 Descriptive flexfield segment.
605 * @param p_title Obsolete parameter, do not use.
606 * @param p_segment1 Key flexfield segment.
607 * @param p_legal_employer Legal Employer of the assignment.
608 * @param p_segment3 Key flexfield segment.
609 * @param p_segment4 Key flexfield segment.
610 * @param p_segment5 Key flexfield segment.
611 * @param p_segment6 Key flexfield segment.
612 * @param p_segment7 Key flexfield segment.
613 * @param p_segment8 Key flexfield segment.
614 * @param p_segment9 Key flexfield segment.
615 * @param p_segment10 Key flexfield segment.
616 * @param p_segment11 Key flexfield segment.
617 * @param p_segment12 Key flexfield segment.
618 * @param p_segment13 Key flexfield segment.
619 * @param p_segment14 Key flexfield segment.
620 * @param p_segment15 Key flexfield segment.
621 * @param p_segment16 Key flexfield segment.
625 * @param p_segment20 Key flexfield segment.
622 * @param p_segment17 Key flexfield segment.
623 * @param p_segment18 Key flexfield segment.
624 * @param p_segment19 Key flexfield segment.
626 * @param p_segment21 Key flexfield segment.
627 * @param p_segment22 Key flexfield segment.
628 * @param p_segment23 Key flexfield segment.
629 * @param p_segment24 Key flexfield segment.
630 * @param p_segment25 Key flexfield segment.
631 * @param p_segment26 Key flexfield segment.
632 * @param p_segment27 Key flexfield segment.
633 * @param p_segment28 Key flexfield segment.
634 * @param p_segment29 Key flexfield segment.
635 * @param p_segment30 Key flexfield segment.
636 * @param p_concat_segments Concatenated segments for Soft Coded Key Flexfield.
637 * Concatenated segments can be supplied instead of individual segments.
638 * @param p_contract_id Contract associated with this assignment.
639 * @param p_establishment_id This identifies the establishment Legal Entity for
640 * this assignment.
641 * @param p_collective_agreement_id Collective Agreement that applies to this
642 * assignment.
643 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
644 * flexfield to use for this assignment.
645 * @param p_cag_segment1 CAGR Key Flexfield segment.
646 * @param p_cag_segment2 CAGR Key Flexfield segment.
647 * @param p_cag_segment3 CAGR Key Flexfield segment.
648 * @param p_cag_segment4 CAGR Key Flexfield segment.
649 * @param p_cag_segment5 CAGR Key Flexfield segment.
650 * @param p_cag_segment6 CAGR Key Flexfield segment.
651 * @param p_cag_segment7 CAGR Key Flexfield segment.
652 * @param p_cag_segment8 CAGR Key Flexfield segment.
653 * @param p_cag_segment9 CAGR Key Flexfield segment.
654 * @param p_cag_segment10 CAGR Key Flexfield segment.
655 * @param p_cag_segment11 CAGR Key Flexfield segment.
656 * @param p_cag_segment12 CAGR Key Flexfield segment.
657 * @param p_cag_segment13 CAGR Key Flexfield segment.
658 * @param p_cag_segment14 CAGR Key Flexfield segment.
659 * @param p_cag_segment15 CAGR Key Flexfield segment.
660 * @param p_cag_segment16 CAGR Key Flexfield segment.
661 * @param p_cag_segment17 CAGR Key Flexfield segment.
662 * @param p_cag_segment18 CAGR Key Flexfield segment.
663 * @param p_cag_segment19 CAGR Key Flexfield segment.
664 * @param p_cag_segment20 CAGR Key Flexfield segment.
665 * @param p_notice_period Length of notice period.
666 * @param p_notice_period_uom Units for notice period. Valid values are defined
667 * in the 'QUALIFYING_UNITS' lookup type.
668 * @param p_employee_category Employee Category of the assignment. Valid values
669 * are defined in the 'EMPLOYEE_CATG' lookup type.
670 * @param p_work_at_home Indicates working from home. Valid values are defined
671 * in the 'YES_NO' lookup type.
672 * @param p_job_post_source_name Name of the source of the job posting that was
673 * answered for this assignment.
674 * @param p_supervisor_assignment_id Supervisor's assignment identification
675 * that is responsible for supervising this assignment.
676 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
677 * identifies an existing CAGR Key Flexfield combination to associate with the
678 * assignment, and the segment values are ignored. If a value is not passed in,
679 * then the individual CAGR Key Flexfield segments supplied will be used to
680 * choose an existing combination or create a new combination. When the API
681 * completes, if p_validate is false, then this uniquely identifies the
682 * associated combination of the CAGR Key flexfield for this assignment. If
683 * p_validate is true, then set to null.
684 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
685 * segments.
686 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
687 * Flexfield concatenated segments, if p_validate is true, set to null.
688 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
689 * it identifies an existing Soft Coded Key Flexfield combination to associate
690 * with the assignment, and segment values are ignored. If a value is not
691 * passed in, then the individual Soft Coded Key Flexfield segments supplied
692 * will be used to choose an existing combination or create a new combination.
693 * When the API completes, if p_validate is false, then this uniquely
694 * identifies the associated combination of the Soft Coded Key flexfield for
695 * this assignment. If p_validate is true, then set to null.
696 * @param p_comment_id If p_validate is false and comment text was provided,
700 * the effective date. If p_validate is true, then set to null.
697 * then will be set to the identifier of the created assignment comment record.
698 * @param p_effective_start_date If p_validate is false, then set to the
699 * effective start date on the updated assignment row which now exists as of
701 * @param p_effective_end_date If p_validate is false, then set to the
702 * effective end date on the updated assignment row which now exists as of the
703 * effective date. If p_validate is true, then set to null.
704 * @param p_no_managers_warning Set to true if as a result of the update there
705 * is no manager in the organization. Otherwise set to false.
706 * @param p_other_manager_warning If set to true, then a manager existed in the
707 * organization prior to calling this API and the manager flag has been set to
708 * 'Y' for yes.
709 * @param p_hourly_salaried_warning Set to true if values entered for Salary
710 * Basis and Hourly Salaried Code are invalid as of the effective date.
711 * @param p_gsp_post_process_warning Set to the name of the warning message
712 * from the Message Dictionary if any Grade Ladder related errors have been
713 * encountered while running this API.
714 * @rep:displayname Updates Employee Assignment for Poland
715 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
716 * @rep:lifecycle deprecated
717 * @rep:scope public
718 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
719 */
720 --
721 -- {End Of Comments}
722 --
723 procedure update_pl_emp_asg
724 (p_validate in boolean default false
725 ,p_effective_date in date
726 ,p_datetrack_update_mode in varchar2
727 ,p_assignment_id in number
728 ,p_object_version_number in out nocopy number
729 ,p_supervisor_id in number default hr_api.g_number
730 ,p_assignment_number in varchar2 default hr_api.g_varchar2
731 ,p_change_reason in varchar2 default hr_api.g_varchar2
732 ,p_assignment_status_type_id in number default hr_api.g_number
733 ,p_comments in varchar2 default hr_api.g_varchar2
734 ,p_date_probation_end in date default hr_api.g_date
735 ,p_default_code_comb_id in number default hr_api.g_number
736 ,p_frequency in varchar2 default hr_api.g_varchar2
737 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
738 ,p_manager_flag in varchar2 default hr_api.g_varchar2
739 ,p_normal_hours in number default hr_api.g_number
740 ,p_perf_review_period in number default hr_api.g_number
741 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
742 ,p_probation_period in number default hr_api.g_number
743 ,p_probation_unit in varchar2 default hr_api.g_varchar2
744 ,p_sal_review_period in number default hr_api.g_number
745 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
746 ,p_set_of_books_id in number default hr_api.g_number
747 ,p_source_type in varchar2 default hr_api.g_varchar2
748 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
749 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
750 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
751 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
752 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
753 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
754 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
755 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
756 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
757 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
758 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
759 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
760 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
761 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
762 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
763 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
764 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
765 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
766 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
767 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
768 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
769 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
770 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
771 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
772 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
773 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
774 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
775 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
776 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
777 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
778 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
779 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
780 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
781 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
782 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
783 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
784 ,p_title in varchar2 default hr_api.g_varchar2
785 ,p_segment1 in varchar2 default hr_api.g_varchar2
786 ,p_legal_employer in varchar2 default hr_api.g_varchar2
787 ,p_segment3 in varchar2 default hr_api.g_varchar2
788 ,p_segment4 in varchar2 default hr_api.g_varchar2
789 ,p_segment5 in varchar2 default hr_api.g_varchar2
790 ,p_segment6 in varchar2 default hr_api.g_varchar2
791 ,p_segment7 in varchar2 default hr_api.g_varchar2
795 ,p_segment11 in varchar2 default hr_api.g_varchar2
792 ,p_segment8 in varchar2 default hr_api.g_varchar2
793 ,p_segment9 in varchar2 default hr_api.g_varchar2
794 ,p_segment10 in varchar2 default hr_api.g_varchar2
796 ,p_segment12 in varchar2 default hr_api.g_varchar2
797 ,p_segment13 in varchar2 default hr_api.g_varchar2
798 ,p_segment14 in varchar2 default hr_api.g_varchar2
799 ,p_segment15 in varchar2 default hr_api.g_varchar2
800 ,p_segment16 in varchar2 default hr_api.g_varchar2
801 ,p_segment17 in varchar2 default hr_api.g_varchar2
802 ,p_segment18 in varchar2 default hr_api.g_varchar2
803 ,p_segment19 in varchar2 default hr_api.g_varchar2
804 ,p_segment20 in varchar2 default hr_api.g_varchar2
805 ,p_segment21 in varchar2 default hr_api.g_varchar2
806 ,p_segment22 in varchar2 default hr_api.g_varchar2
807 ,p_segment23 in varchar2 default hr_api.g_varchar2
808 ,p_segment24 in varchar2 default hr_api.g_varchar2
809 ,p_segment25 in varchar2 default hr_api.g_varchar2
810 ,p_segment26 in varchar2 default hr_api.g_varchar2
811 ,p_segment27 in varchar2 default hr_api.g_varchar2
812 ,p_segment28 in varchar2 default hr_api.g_varchar2
813 ,p_segment29 in varchar2 default hr_api.g_varchar2
814 ,p_segment30 in varchar2 default hr_api.g_varchar2
815 ,p_concat_segments in varchar2 default hr_api.g_varchar2
816 ,p_contract_id in number default hr_api.g_number
817 ,p_establishment_id in number default hr_api.g_number
818 ,p_collective_agreement_id in number default hr_api.g_number
819 ,p_cagr_id_flex_num in number default hr_api.g_number
820 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
821 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
822 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
823 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
824 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
825 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
829 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
826 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
827 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
828 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
830 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
831 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
832 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
833 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
834 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
835 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
836 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
837 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
838 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
839 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
840 ,p_notice_period in number default hr_api.g_number
841 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
842 ,p_employee_category in varchar2 default hr_api.g_varchar2
843 ,p_work_at_home in varchar2 default hr_api.g_varchar2
844 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
845 ,p_supervisor_assignment_id in number default hr_api.g_number
846 ,p_cagr_grade_def_id in out nocopy number
847 ,p_cagr_concatenated_segments out nocopy varchar2
848 ,p_concatenated_segments out nocopy varchar2
849 ,p_soft_coding_keyflex_id in out nocopy number
850 ,p_comment_id out nocopy number
851 ,p_effective_start_date out nocopy date
852 ,p_effective_end_date out nocopy date
853 ,p_no_managers_warning out nocopy boolean
854 ,p_other_manager_warning out nocopy boolean
855 ,p_hourly_salaried_warning out nocopy boolean
856 ,p_gsp_post_process_warning out nocopy varchar2
857 );
858 --
859 -- ----------------------------------------------------------------------------
860 -- |-----------------------< create_pl_secondary_emp_asg >--------------------|
861 -- ----------------------------------------------------------------------------
862 --
863 -- {Start Of Comments}
864 /*#
865 * This API creates secondary assignment for an employee.
866 *
867 * This API is an alternative to the API create_secondary_emp_asg. If
868 * p_validate is set to false, an assignment is created.
869 *
870 * <p><b>Licensing</b><br>
871 * This API is licensed for use with Human Resources.
872 *
873 * <p><b>Prerequisites</b><br>
874 * The employee must have been created already and must exist at the effective
875 * start date of the assignment.
876 *
877 * <p><b>Post Success</b><br>
878 * A new secondary assignment is created for the employee.
879 *
880 * <p><b>Post Failure</b><br>
881 * The API does not create the assignment and raises an error.
882 *
883 * @param p_validate If true, then validation alone will be performed and the
884 * database will remain unchanged. If false and all validation checks pass,
885 * then the database will be modified.
886 * @param p_effective_date Determines when the DateTrack operation comes into
887 * force.
888 * @param p_person_id Identifies the person for whom you create the secondary
889 * assignment record.
890 * @param p_organization_id Identifies the organization of the secondary
891 * assignment.
892 * @param p_grade_id Identifies the grade of the secondary assignment.
893 * @param p_position_id Identifies the position of the secondary assignment.
894 * @param p_job_id Identifies the job of the secondary assignment.
895 * @param p_assignment_status_type_id Identifies the assignment status of the
896 * secondary assignment. Valid values are defined by 'PER_ASS_SYS_STATUS'
897 * lookup type.
898 * @param p_payroll_id Identifies the payroll for the secondary assignment.
899 * @param p_location_id Identifies the location of the secondary assignment.
900 * @param p_supervisor_id Identifies the supervisor for the secondary
901 * assignment. The value refers to the supervisor's person record.
902 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
903 * associated with the grade of the secondary assignment.
904 * @param p_pay_basis_id Salary basis for the secondary assignment.
905 * @param p_assignment_number If a value is passed in, this is used as the
906 * assignment number. If no value is passed in an assignment number is
907 * generated.
908 * @param p_change_reason Reason for the assignment status change. If there is
909 * no change reason the parameter can be null. Valid values are defined in the
910 * 'EMP_ASSIGN_REASON' lookup type.
911 * @param p_comments Comment text.
912 * @param p_date_probation_end End date of probation period.
913 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
914 * Flexfield combination that applies to this assignment.
915 * @param p_employment_category Employment category of the assignment. Valid
916 * values are defined in the 'EMP_CAT' lookup type.
917 * @param p_frequency Frequency associated with the defined normal working
918 * hours. Valid values are defined in the 'FREQUENCY' lookup type.
919 * @param p_internal_address_line Internal address identified with the
920 * secondary assignment.
921 * @param p_manager_flag Indicates whether the employee is a manager.
922 * @param p_normal_hours Normal working hours for this assignment.
923 * @param p_perf_review_period Length of performance review period.
924 * @param p_perf_review_period_frequency Units of performance review period.
928 * in the 'QUALIFYING_UNITS' lookup type.
925 * Valid values are defined in the 'FREQUENCY' lookup type.
926 * @param p_probation_period Length of probation period.
927 * @param p_probation_unit Units of probation period. Valid values are defined
929 * @param p_sal_review_period Length of salary review period.
930 * @param p_sal_review_period_frequency Units of salary review period. Valid
931 * values are defined in the 'FREQUENCY' lookup type.
932 * @param p_set_of_books_id Identifies General Ledger set of books.
933 * @param p_source_type Recruitment activity which this assignment is sourced
934 * from. Valid values are defined in the 'REC_TYPE' lookup type.
935 * @param p_time_normal_finish Work end time.
936 * @param p_time_normal_start Work start time.
937 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
938 * defined in the 'BARGAINING_UNIT_CODE' lookup type.
939 * @param p_labour_union_member_flag Indicates whether the employee is a labour
940 * union member.
941 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
942 * is salaried. Valid values are defined in the 'HOURLY_SALARIED_CODE' lookup
943 * type.
944 * @param p_ass_attribute_category This context value determines which
945 * Flexfield Structure to use with the Descriptive flexfield segments.
946 * @param p_ass_attribute1 Descriptive flexfield segment.
947 * @param p_ass_attribute2 Descriptive flexfield segment.
948 * @param p_ass_attribute3 Descriptive flexfield segment.
949 * @param p_ass_attribute4 Descriptive flexfield segment.
950 * @param p_ass_attribute5 Descriptive flexfield segment.
951 * @param p_ass_attribute6 Descriptive flexfield segment.
952 * @param p_ass_attribute7 Descriptive flexfield segment.
953 * @param p_ass_attribute8 Descriptive flexfield segment.
954 * @param p_ass_attribute9 Descriptive flexfield segment.
955 * @param p_ass_attribute10 Descriptive flexfield segment.
956 * @param p_ass_attribute11 Descriptive flexfield segment.
957 * @param p_ass_attribute12 Descriptive flexfield segment.
958 * @param p_ass_attribute13 Descriptive flexfield segment.
959 * @param p_ass_attribute14 Descriptive flexfield segment.
960 * @param p_ass_attribute15 Descriptive flexfield segment.
961 * @param p_ass_attribute16 Descriptive flexfield segment.
962 * @param p_ass_attribute17 Descriptive flexfield segment.
963 * @param p_ass_attribute18 Descriptive flexfield segment.
964 * @param p_ass_attribute19 Descriptive flexfield segment.
965 * @param p_ass_attribute20 Descriptive flexfield segment.
966 * @param p_ass_attribute21 Descriptive flexfield segment.
967 * @param p_ass_attribute22 Descriptive flexfield segment.
968 * @param p_ass_attribute23 Descriptive flexfield segment.
969 * @param p_ass_attribute24 Descriptive flexfield segment.
970 * @param p_ass_attribute25 Descriptive flexfield segment.
971 * @param p_ass_attribute26 Descriptive flexfield segment.
972 * @param p_ass_attribute27 Descriptive flexfield segment.
973 * @param p_ass_attribute28 Descriptive flexfield segment.
974 * @param p_ass_attribute29 Descriptive flexfield segment.
975 * @param p_ass_attribute30 Descriptive flexfield segment.
976 * @param p_title Obsolete parameter, do not use.
977 * @param p_contract_category This specifies the contract category of
978 * the assignment.The lookup type 'PL_CONTRACT_CATEGORY' defines
979 * the valid values for the Polish legislation.
980 * @param p_contract_type This specifies the Contract type of the
981 * assignment. If the contract category is 'CIVIL',then the lookup
982 * 'PL_CONTRACT_TYPE_CIVIL' defines the valid values.If the contract
983 * category is 'NORMAL',then the lookup 'PL_CONTRACT_TYPE_NORMAL'
984 * defines the valid values for the Polish legislation.
985 * @param p_contract_number This indicates the contract number of the assignment.
986 * @param p_change_of_contract_reason This indicates the reason for changing
987 * the contract type.The lookup 'PL_CONTRACT_END_REASON' defines the
988 * valid values for the Polish legislation.
989 * @param p_job This identifies the job(SII) of the contract.The lookup
990 * 'PL_JOB' defines the valid values for the Polish legislation.
991 * @param p_work_in_special_condition Identifies whether this assignment
992 * involves working under any special conditions.The lookup
993 * 'PL_WORK_IN_SPECIAL_COND' defines the valid values for the Polish legislation.
994 * @param p_end_of_contract_addl_details This specifies any additional
995 * details about the end of contract.
996 * @param p_contract_start_date This specifies the contract start
997 * date for the assignment.
998 * @param p_planned_valid_to_date This specifies the planned end date
999 * of the contract.
1000 * @param p_contract_type_change_date This specifies the date on which
1001 * the contract type is changed.
1002 * @param p_date_contract_signed This specifies the date on which
1003 * the contract is signed.
1004 * @param p_notice_period_date This specifies the date on which notice is
1005 * given to end the contract.
1006 * @param p_notice_period_end_date This is the specified date on
1007 * which contract will end.
1008 * @param p_scl_concat_segments Concatenated segments for Soft Coded Key
1009 * Flexfield. Concatenated segments can be supplied instead of individual
1010 * segments.
1011 * @param p_pgp_segment1 People group key flexfield segment.
1012 * @param p_pgp_segment2 People group key flexfield segment.
1013 * @param p_pgp_segment3 People group key flexfield segment.
1014 * @param p_pgp_segment4 People group key flexfield segment.
1015 * @param p_pgp_segment5 People group key flexfield segment.
1016 * @param p_pgp_segment6 People group key flexfield segment.
1017 * @param p_pgp_segment7 People group key flexfield segment.
1018 * @param p_pgp_segment8 People group key flexfield segment.
1019 * @param p_pgp_segment9 People group key flexfield segment.
1023 * @param p_pgp_segment13 People group key flexfield segment.
1020 * @param p_pgp_segment10 People group key flexfield segment.
1021 * @param p_pgp_segment11 People group key flexfield segment.
1022 * @param p_pgp_segment12 People group key flexfield segment.
1024 * @param p_pgp_segment14 People group key flexfield segment.
1025 * @param p_pgp_segment15 People group key flexfield segment.
1026 * @param p_pgp_segment16 People group key flexfield segment.
1027 * @param p_pgp_segment17 People group key flexfield segment.
1028 * @param p_pgp_segment18 People group key flexfield segment.
1029 * @param p_pgp_segment19 People group key flexfield segment.
1030 * @param p_pgp_segment20 People group key flexfield segment.
1031 * @param p_pgp_segment21 People group key flexfield segment.
1032 * @param p_pgp_segment22 People group key flexfield segment.
1033 * @param p_pgp_segment23 People group key flexfield segment.
1034 * @param p_pgp_segment24 People group key flexfield segment.
1035 * @param p_pgp_segment25 People group key flexfield segment.
1036 * @param p_pgp_segment26 People group key flexfield segment.
1037 * @param p_pgp_segment27 People group key flexfield segment.
1038 * @param p_pgp_segment28 People group key flexfield segment.
1039 * @param p_pgp_segment29 People group key flexfield segment.
1040 * @param p_pgp_segment30 People group key flexfield segment.
1041 * @param p_pgp_concat_segments Concatenated segments for People Group Key
1042 * Flexfield. Concatenated segments can be supplied instead of individual
1043 * segments.
1044 * @param p_contract_id Contract associated with this assignment.
1045 * @param p_establishment_id This identifies the establishment Legal Entity for
1046 * this assignment.
1047 * @param p_collective_agreement_id Collective Agreement that applies to this
1048 * assignment.
1049 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
1050 * flexfield to use for this assignment.
1051 * @param p_cag_segment1 CAGR Key Flexfield segment.
1052 * @param p_cag_segment2 CAGR Key Flexfield segment.
1053 * @param p_cag_segment3 CAGR Key Flexfield segment.
1054 * @param p_cag_segment4 CAGR Key Flexfield segment.
1055 * @param p_cag_segment5 CAGR Key Flexfield segment.
1056 * @param p_cag_segment6 CAGR Key Flexfield segment.
1057 * @param p_cag_segment7 CAGR Key Flexfield segment.
1058 * @param p_cag_segment8 CAGR Key Flexfield segment.
1059 * @param p_cag_segment9 CAGR Key Flexfield segment.
1060 * @param p_cag_segment10 CAGR Key Flexfield segment.
1061 * @param p_cag_segment11 CAGR Key Flexfield segment.
1062 * @param p_cag_segment12 CAGR Key Flexfield segment.
1063 * @param p_cag_segment13 CAGR Key Flexfield segment.
1064 * @param p_cag_segment14 CAGR Key Flexfield segment.
1065 * @param p_cag_segment15 CAGR Key Flexfield segment.
1066 * @param p_cag_segment16 CAGR Key Flexfield segment.
1067 * @param p_cag_segment17 CAGR Key Flexfield segment.
1068 * @param p_cag_segment18 CAGR Key Flexfield segment.
1069 * @param p_cag_segment19 CAGR Key Flexfield segment.
1070 * @param p_cag_segment20 CAGR Key Flexfield segment.
1071 * @param p_notice_period Length of notice period.
1072 * @param p_notice_period_uom Units for notice period. Valid values are defined
1073 * in the 'QUALIFYING_UNITS' lookup type.
1074 * @param p_employee_category Employee Category of the assignment. Valid values
1075 * are defined in the 'EMPLOYEE_CATG' lookup type.
1076 * @param p_work_at_home Indicates working from home. Valid values are defined
1077 * in the 'YES_NO' lookup type.
1078 * @param p_job_post_source_name The source of the job posting that was
1079 * answered for this assignment.
1080 * @param p_grade_ladder_pgm_id Grade Ladder for this assignment.
1081 * @param p_supervisor_assignment_id Supervisor's assignment identification
1082 * that is responsible for supervising this assignment.
1083 * @param p_group_name If p_validate is false, set to the People Group Key
1084 * Flexfield concatenated segments. If p_validate is true, set to null.
1085 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
1086 * Flexfield concatenated segments, if p_validate is true, set to null.
1087 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
1088 * identifies an existing CAGR Key Flexfield combination to associate with the
1089 * assignment, and the segment values are ignored. If a value is not passed in,
1090 * then the individual CAGR Key Flexfield segments supplied will be used to
1091 * choose an existing combination or create a new combination. When the API
1092 * completes, if p_validate is false, then this uniquely identifies the
1093 * associated combination of the CAGR Key flexfield for this assignment. If
1094 * p_validate is true, then set to null.
1095 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
1096 * segments.
1097 * @param p_assignment_id If p_validate is false, then this uniquely identifies
1098 * the created assignment. If p_validate is true, then set to null.
1099 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
1100 * it identifies an existing Soft Coded Key Flexfield combination to associate
1101 * with the assignment, and segment values are ignored. If a value is not
1102 * passed in, then the individual Soft Coded Key Flexfield segments supplied
1103 * will be used to choose an existing combination or create a new combination.
1104 * When the API completes, if p_validate is false, then this uniquely
1105 * identifies the associated combination of the Soft Coded Key flexfield for
1106 * this assignment. If p_validate is true, then set to null.
1107 * @param p_people_group_id If a value is passed in for this parameter, it
1108 * identifies an existing People Group Key Flexfield combination to associate
1109 * with the assignment, and segment values are ignored. If a value is not
1110 * passed in, then the individual People Group Key Flexfield segments supplied
1114 * this assignment. If p_validate is true, then set to null.
1111 * will be used to choose an existing combination or create a new combination.
1112 * When the API completes, if p_validate is false, then this uniquely
1113 * identifies the associated combination of the People Group Key flexfield for
1115 * @param p_object_version_number If p_validate is false, then set to the
1116 * version number of the created assignment. If p_validate is true, then the
1117 * value will be null.
1118 * @param p_effective_start_date If p_validate is false, then set to the
1119 * earliest effective start date for the created assignment. If p_validate is
1120 * true, then set to null.
1121 * @param p_effective_end_date If p_validate is false, then set to the
1122 * effective end date for the created assignment. If p_validate is true, then
1123 * set to null.
1124 * @param p_assignment_sequence If p_validate is false, then an automatically
1125 * incremented number is associated with this assignment, depending on the
1126 * number of assignment which already exist. If p_validate is true then set to
1127 * null.
1128 * @param p_comment_id If p_validate is false and comment text was provided,
1129 * then will be set to the identifier of the created assignment comment record.
1130 * If p_validate is true or no comment text was provided, then will be null.
1131 * @param p_other_manager_warning If set to true, then a manager existed in the
1132 * organization prior to calling this API and the manager flag has been set to
1133 * 'Y' for yes.
1134 * @param p_hourly_salaried_warning Set to true if values entered for Salary
1135 * Basis and Hourly Salaried Code are invalid as of p_effective_date.
1136 * @param p_gsp_post_process_warning Set to the name of a warning message from
1137 * the Message Dictionary if any Grade Ladder related errors have been
1138 * encountered while running this API.
1139 * @rep:displayname Create Secondary Employee Assignment for Poland
1140 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
1141 * @rep:lifecycle active
1142 * @rep:primaryinstance
1143 * @rep:scope public
1144 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1145 */
1146 --
1147 -- {End Of Comments}
1148 --
1149 Procedure create_pl_secondary_emp_asg
1150 (p_validate in boolean default false
1151 ,p_effective_date in date
1152 ,p_person_id in number
1153 ,p_organization_id in number
1154 ,p_grade_id in number default null
1155 ,p_position_id in number default null
1156 ,p_job_id in number default null
1157 ,p_assignment_status_type_id in number default null
1158 ,p_payroll_id in number default null
1159 ,p_location_id in number default null
1160 ,p_supervisor_id in number default null
1161 ,p_special_ceiling_step_id in number default null
1162 ,p_pay_basis_id in number default null
1163 ,p_assignment_number in out nocopy varchar2
1164 ,p_change_reason in varchar2 default null
1165 ,p_comments in varchar2 default null
1166 ,p_date_probation_end in date default null
1167 ,p_default_code_comb_id in number default null
1168 ,p_employment_category in varchar2 default null
1169 ,p_frequency in varchar2 default null
1170 ,p_internal_address_line in varchar2 default null
1171 ,p_manager_flag in varchar2 default null
1172 ,p_normal_hours in number default null
1173 ,p_perf_review_period in number default null
1174 ,p_perf_review_period_frequency in varchar2 default null
1175 ,p_probation_period in number default null
1176 ,p_probation_unit in varchar2 default null
1177 ,p_sal_review_period in number default null
1178 ,p_sal_review_period_frequency in varchar2 default null
1179 ,p_set_of_books_id in number default null
1180 ,p_source_type in varchar2 default null
1181 ,p_time_normal_finish in varchar2 default null
1182 ,p_time_normal_start in varchar2 default null
1183 ,p_bargaining_unit_code in varchar2 default null
1184 ,p_labour_union_member_flag in varchar2 default 'N'
1185 ,p_hourly_salaried_code in varchar2 default null
1186 ,p_ass_attribute_category in varchar2 default null
1187 ,p_ass_attribute1 in varchar2 default null
1188 ,p_ass_attribute2 in varchar2 default null
1189 ,p_ass_attribute3 in varchar2 default null
1190 ,p_ass_attribute4 in varchar2 default null
1191 ,p_ass_attribute5 in varchar2 default null
1192 ,p_ass_attribute6 in varchar2 default null
1193 ,p_ass_attribute7 in varchar2 default null
1194 ,p_ass_attribute8 in varchar2 default null
1195 ,p_ass_attribute9 in varchar2 default null
1196 ,p_ass_attribute10 in varchar2 default null
1197 ,p_ass_attribute11 in varchar2 default null
1198 ,p_ass_attribute12 in varchar2 default null
1199 ,p_ass_attribute13 in varchar2 default null
1200 ,p_ass_attribute14 in varchar2 default null
1201 ,p_ass_attribute15 in varchar2 default null
1202 ,p_ass_attribute16 in varchar2 default null
1203 ,p_ass_attribute17 in varchar2 default null
1204 ,p_ass_attribute18 in varchar2 default null
1205 ,p_ass_attribute19 in varchar2 default null
1206 ,p_ass_attribute20 in varchar2 default null
1207 ,p_ass_attribute21 in varchar2 default null
1208 ,p_ass_attribute22 in varchar2 default null
1212 ,p_ass_attribute26 in varchar2 default null
1209 ,p_ass_attribute23 in varchar2 default null
1210 ,p_ass_attribute24 in varchar2 default null
1211 ,p_ass_attribute25 in varchar2 default null
1213 ,p_ass_attribute27 in varchar2 default null
1214 ,p_ass_attribute28 in varchar2 default null
1215 ,p_ass_attribute29 in varchar2 default null
1216 ,p_ass_attribute30 in varchar2 default null
1217 ,p_title in varchar2 default null
1218 ,p_contract_category in varchar2
1219 ,p_contract_type in varchar2
1220 ,p_contract_number in varchar2
1221 ,p_change_of_contract_reason in varchar2 default null
1222 ,p_job in varchar2 default null
1223 ,p_work_in_special_condition in varchar2 default null
1224 ,p_end_of_contract_addl_details in varchar2 default null
1225 ,p_contract_start_date in varchar2
1226 ,p_planned_valid_to_date in varchar2 default null
1227 ,p_contract_type_change_date in varchar2 default null
1228 ,p_date_contract_signed in varchar2
1229 ,p_notice_period_date in varchar2 default null
1230 ,p_notice_period_end_date in varchar2 default null
1231 ,p_scl_concat_segments in varchar2 default null
1232 ,p_pgp_segment1 in varchar2 default null
1233 ,p_pgp_segment2 in varchar2 default null
1234 ,p_pgp_segment3 in varchar2 default null
1235 ,p_pgp_segment4 in varchar2 default null
1236 ,p_pgp_segment5 in varchar2 default null
1237 ,p_pgp_segment6 in varchar2 default null
1238 ,p_pgp_segment7 in varchar2 default null
1239 ,p_pgp_segment8 in varchar2 default null
1240 ,p_pgp_segment9 in varchar2 default null
1241 ,p_pgp_segment10 in varchar2 default null
1242 ,p_pgp_segment11 in varchar2 default null
1243 ,p_pgp_segment12 in varchar2 default null
1244 ,p_pgp_segment13 in varchar2 default null
1245 ,p_pgp_segment14 in varchar2 default null
1246 ,p_pgp_segment15 in varchar2 default null
1247 ,p_pgp_segment16 in varchar2 default null
1248 ,p_pgp_segment17 in varchar2 default null
1249 ,p_pgp_segment18 in varchar2 default null
1250 ,p_pgp_segment19 in varchar2 default null
1251 ,p_pgp_segment20 in varchar2 default null
1252 ,p_pgp_segment21 in varchar2 default null
1253 ,p_pgp_segment22 in varchar2 default null
1254 ,p_pgp_segment23 in varchar2 default null
1255 ,p_pgp_segment24 in varchar2 default null
1256 ,p_pgp_segment25 in varchar2 default null
1257 ,p_pgp_segment26 in varchar2 default null
1258 ,p_pgp_segment27 in varchar2 default null
1259 ,p_pgp_segment28 in varchar2 default null
1260 ,p_pgp_segment29 in varchar2 default null
1261 ,p_pgp_segment30 in varchar2 default null
1262 ,p_pgp_concat_segments in varchar2 default null
1263 ,p_contract_id in number default null
1264 ,p_establishment_id in number default null
1265 ,p_collective_agreement_id in number default null
1266 ,p_cagr_id_flex_num in number default null
1267 ,p_cag_segment1 in varchar2 default null
1268 ,p_cag_segment2 in varchar2 default null
1269 ,p_cag_segment3 in varchar2 default null
1270 ,p_cag_segment4 in varchar2 default null
1274 ,p_cag_segment8 in varchar2 default null
1271 ,p_cag_segment5 in varchar2 default null
1272 ,p_cag_segment6 in varchar2 default null
1273 ,p_cag_segment7 in varchar2 default null
1275 ,p_cag_segment9 in varchar2 default null
1276 ,p_cag_segment10 in varchar2 default null
1277 ,p_cag_segment11 in varchar2 default null
1278 ,p_cag_segment12 in varchar2 default null
1279 ,p_cag_segment13 in varchar2 default null
1280 ,p_cag_segment14 in varchar2 default null
1281 ,p_cag_segment15 in varchar2 default null
1282 ,p_cag_segment16 in varchar2 default null
1283 ,p_cag_segment17 in varchar2 default null
1284 ,p_cag_segment18 in varchar2 default null
1285 ,p_cag_segment19 in varchar2 default null
1286 ,p_cag_segment20 in varchar2 default null
1287 ,p_notice_period in number default null
1288 ,p_notice_period_uom in varchar2 default null
1289 ,p_employee_category in varchar2 default null
1290 ,p_work_at_home in varchar2 default null
1291 ,p_job_post_source_name in varchar2 default null
1292 ,p_grade_ladder_pgm_id in number default null
1293 ,p_supervisor_assignment_id in number default null
1294 ,p_group_name out nocopy varchar2
1295 ,p_concatenated_segments out nocopy varchar2
1296 ,p_cagr_grade_def_id in out nocopy number
1297 ,p_cagr_concatenated_segments out nocopy varchar2
1298 ,p_assignment_id out nocopy number
1299 ,p_soft_coding_keyflex_id in out nocopy number
1300 ,p_people_group_id in out nocopy number
1301 ,p_object_version_number out nocopy number
1302 ,p_effective_start_date out nocopy date
1303 ,p_effective_end_date out nocopy date
1304 ,p_assignment_sequence out nocopy number
1305 ,p_comment_id out nocopy number
1306 ,p_other_manager_warning out nocopy boolean
1307 ,p_hourly_salaried_warning out nocopy boolean
1308 ,p_gsp_post_process_warning out nocopy varchar2
1309 );
1310 --
1311 -- ----------------------------------------------------------------------------
1312 -- |----------------------------< update_pl_emp_asg >-------------------------|
1313 -- ----------------------------------------------------------------------------
1314 --
1315 -- {Start Of Comments}
1316 /*#
1317 * This API updates employee assignment details which do not affect entitlement
1318 * to element entries.
1319 *
1320 * This API is an alternative to the API update_emp_asg. If p_validate is set
1321 * to false, then the assignment record is updated. Also this API updates an
1322 * employee assignment status. The new status must have a system status of
1323 * ACTIVE_ASSIGN. If the assignment status is already a type of ACTIVE_ASSIGN,
1324 * this API can be used to set a different active status. If the calling
1325 * routine does not explicitly pass in a status, the API uses the default
1326 * ACTIVE_ASSIGN status for the assignment's business group. Note: Only
1327 * employee assignments can be altered with this API. Updates to an applicant
1328 * assignment status are not allowed.
1329 *
1330 * <p><b>Licensing</b><br>
1331 * This API is licensed for use with Human Resources.
1332 *
1333 * <p><b>Prerequisites</b><br>
1334 * The assignment must exist as of the effective date and must be an employee
1335 * assignment.
1336 *
1337 * <p><b>Post Success</b><br>
1338 * The assignment will have been updated.
1339 *
1340 * <p><b>Post Failure</b><br>
1341 * The assignment will not be updated and an error will be raised.
1342 *
1343 * @param p_validate If true, then validation alone will be performed and the
1344 * database will remain unchanged. If false and all validation checks pass,
1345 * then the database will be modified.
1346 * @param p_effective_date Determines when the DateTrack operation comes into
1347 * force.
1348 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
1349 * updating the record. You must set to either UPDATE, CORRECTION,
1350 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
1351 * particular record depend on the dates of previous record changes and the
1355 * assignment to be updated. When the API completes if p_validate is false,
1352 * effective date of this change.
1353 * @param p_assignment_id Identifies the assignment record to modify.
1354 * @param p_object_version_number Pass in the current version number of the
1356 * will be set to the new version number of the updated assignment. If
1357 * p_validate is true will be set to the same value which was passed in.
1358 * @param p_supervisor_id Supervisor for the assignment. The value refers to
1359 * the supervisor's person record.
1360 * @param p_assignment_number Assignment number.
1361 * @param p_change_reason Reason for the assignment status change. If there is
1362 * no change reason, then the parameter can be null. Valid values are defined
1363 * in the 'EMP_ASSIGN_REASON' lookup type.
1364 * @param p_assignment_status_type_id Assignment status. The system status must
1365 * be the same as before the update, otherwise one of the status change APIs
1366 * should be used.
1367 * @param p_comments Comment text.
1368 * @param p_date_probation_end End date of probation period.
1369 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
1370 * Flexfield combination that applies to this assignment.
1371 * @param p_frequency Frequency associated with the defined normal working
1372 * hours. Valid values are defined in the 'FREQUENCY' lookup type.
1373 * @param p_internal_address_line Internal address identified with this
1374 * assignment.
1375 * @param p_manager_flag Indicates whether the employee is a manager.
1376 * @param p_normal_hours Normal working hours for this assignment.
1377 * @param p_perf_review_period Length of performance review period.
1378 * @param p_perf_review_period_frequency Units of performance review period.
1379 * Valid values are defined in the 'FREQUENCY' lookup type.
1380 * @param p_probation_period Length of probation period.
1381 * @param p_probation_unit Units of probation period. Valid values are defined
1382 * in the 'QUALIFYING_UNITS' lookup type.
1383 * @param p_sal_review_period Length of salary review period.
1384 * @param p_sal_review_period_frequency Units of salary review period. Valid
1385 * values are defined in the 'FREQUENCY' lookup type.
1386 * @param p_set_of_books_id Identifies General Ledger set of books.
1387 * @param p_source_type Recruitment activity which this assignment is sourced
1388 * from. Valid values are defined in the 'REC_TYPE' lookup type.
1389 * @param p_time_normal_finish Work end time.
1390 * @param p_time_normal_start Work start time.
1391 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
1392 * defined in the 'BARGAINING_UNIT_CODE' lookup type.
1393 * @param p_labour_union_member_flag Indicates whether the employee is a labour
1394 * union member.
1395 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
1396 * is salaried. Valid values defined in the 'HOURLY_SALARIED_CODE' lookup type.
1397 * @param p_ass_attribute_category This context value determines which
1398 * Flexfield Structure to use with the Descriptive flexfield segments.
1399 * @param p_ass_attribute1 Descriptive flexfield segment.
1400 * @param p_ass_attribute2 Descriptive flexfield segment.
1401 * @param p_ass_attribute3 Descriptive flexfield segment.
1402 * @param p_ass_attribute4 Descriptive flexfield segment.
1403 * @param p_ass_attribute5 Descriptive flexfield segment.
1404 * @param p_ass_attribute6 Descriptive flexfield segment.
1405 * @param p_ass_attribute7 Descriptive flexfield segment.
1406 * @param p_ass_attribute8 Descriptive flexfield segment.
1407 * @param p_ass_attribute9 Descriptive flexfield segment.
1408 * @param p_ass_attribute10 Descriptive flexfield segment.
1409 * @param p_ass_attribute11 Descriptive flexfield segment.
1410 * @param p_ass_attribute12 Descriptive flexfield segment.
1411 * @param p_ass_attribute13 Descriptive flexfield segment.
1412 * @param p_ass_attribute14 Descriptive flexfield segment.
1413 * @param p_ass_attribute15 Descriptive flexfield segment.
1414 * @param p_ass_attribute16 Descriptive flexfield segment.
1415 * @param p_ass_attribute17 Descriptive flexfield segment.
1416 * @param p_ass_attribute18 Descriptive flexfield segment.
1417 * @param p_ass_attribute19 Descriptive flexfield segment.
1418 * @param p_ass_attribute20 Descriptive flexfield segment.
1419 * @param p_ass_attribute21 Descriptive flexfield segment.
1420 * @param p_ass_attribute22 Descriptive flexfield segment.
1421 * @param p_ass_attribute23 Descriptive flexfield segment.
1422 * @param p_ass_attribute24 Descriptive flexfield segment.
1423 * @param p_ass_attribute25 Descriptive flexfield segment.
1424 * @param p_ass_attribute26 Descriptive flexfield segment.
1425 * @param p_ass_attribute27 Descriptive flexfield segment.
1426 * @param p_ass_attribute28 Descriptive flexfield segment.
1427 * @param p_ass_attribute29 Descriptive flexfield segment.
1428 * @param p_ass_attribute30 Descriptive flexfield segment.
1429 * @param p_title Obsolete parameter, do not use.
1430 * @param p_contract_category This specifies the contract category of
1431 * the assignment.The lookup type 'PL_CONTRACT_CATEGORY' defines
1432 * the valid values for the Polish legislation.
1433 * @param p_contract_type This specifies the Contract type of the
1434 * assignment. If the contract category is 'CIVIL',then the lookup
1435 * 'PL_CONTRACT_TYPE_CIVIL' defines the valid values.If the contract
1436 * category is 'NORMAL',then the lookup 'PL_CONTRACT_TYPE_NORMAL'
1437 * defines the valid values for the Polish legislation.
1438 * @param p_contract_number This indicates the contract number of the assignment.
1439 * @param p_change_of_contract_reason This indicates the reason for changing
1440 * the contract type.The lookup 'PL_CONTRACT_END_REASON' defines the
1441 * valid values for the Polish legislation.
1442 * @param p_job This identifies the job(SII) of the contract.The lookup
1443 * 'PL_JOB' defines the valid values for the Polish legislation.
1444 * @param p_work_in_special_condition Identifies whether this assignment
1448 * details about the end of contract.
1445 * involves working under any special conditions.The lookup
1446 * 'PL_WORK_IN_SPECIAL_COND' defines the valid values for the Polish legislation.
1447 * @param p_end_of_contract_addl_details This specifies any additional
1449 * @param p_contract_start_date This specifies the contract start
1450 * date for the assignment.
1451 * @param p_planned_valid_to_date This specifies the planned end date
1452 * of the contract.
1453 * @param p_contract_type_change_date This specifies the date on which
1454 * the contract type is changed.
1455 * @param p_date_contract_signed This specifies the date on which
1456 * the contract is signed.
1457 * @param p_notice_period_date This specifies the date on which notice is
1458 * given to end the contract.
1459 * @param p_notice_period_end_date This is the specified date on
1460 * which contract will end.
1461 * @param p_concat_segments Concatenated segments for Soft Coded Key Flexfield.
1462 * Concatenated segments can be supplied instead of individual segments.
1463 * @param p_contract_id Contract associated with this assignment.
1464 * @param p_establishment_id This identifies the establishment Legal Entity for
1465 * this assignment.
1466 * @param p_collective_agreement_id Collective Agreement that applies to this
1467 * assignment.
1468 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
1469 * flexfield to use for this assignment.
1470 * @param p_cag_segment1 CAGR Key Flexfield segment.
1471 * @param p_cag_segment2 CAGR Key Flexfield segment.
1472 * @param p_cag_segment3 CAGR Key Flexfield segment.
1473 * @param p_cag_segment4 CAGR Key Flexfield segment.
1474 * @param p_cag_segment5 CAGR Key Flexfield segment.
1475 * @param p_cag_segment6 CAGR Key Flexfield segment.
1476 * @param p_cag_segment7 CAGR Key Flexfield segment.
1477 * @param p_cag_segment8 CAGR Key Flexfield segment.
1478 * @param p_cag_segment9 CAGR Key Flexfield segment.
1479 * @param p_cag_segment10 CAGR Key Flexfield segment.
1480 * @param p_cag_segment11 CAGR Key Flexfield segment.
1481 * @param p_cag_segment12 CAGR Key Flexfield segment.
1482 * @param p_cag_segment13 CAGR Key Flexfield segment.
1483 * @param p_cag_segment14 CAGR Key Flexfield segment.
1484 * @param p_cag_segment15 CAGR Key Flexfield segment.
1485 * @param p_cag_segment16 CAGR Key Flexfield segment.
1486 * @param p_cag_segment17 CAGR Key Flexfield segment.
1487 * @param p_cag_segment18 CAGR Key Flexfield segment.
1488 * @param p_cag_segment19 CAGR Key Flexfield segment.
1489 * @param p_cag_segment20 CAGR Key Flexfield segment.
1490 * @param p_notice_period Length of notice period.
1491 * @param p_notice_period_uom Units for notice period. Valid values are defined
1492 * in the 'QUALIFYING_UNITS' lookup type.
1493 * @param p_employee_category Employee Category of the assignment. Valid values
1494 * are defined in the 'EMPLOYEE_CATG' lookup type.
1495 * @param p_work_at_home Indicates working from home. Valid values are defined
1496 * in the 'YES_NO' lookup type.
1497 * @param p_job_post_source_name Name of the source of the job posting that was
1498 * answered for this assignment.
1499 * @param p_supervisor_assignment_id Supervisor's assignment identification
1500 * that is responsible for supervising this assignment.
1501 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
1502 * identifies an existing CAGR Key Flexfield combination to associate with the
1503 * assignment, and the segment values are ignored. If a value is not passed in,
1504 * then the individual CAGR Key Flexfield segments supplied will be used to
1505 * choose an existing combination or create a new combination. When the API
1506 * completes, if p_validate is false, then this uniquely identifies the
1507 * associated combination of the CAGR Key flexfield for this assignment. If
1508 * p_validate is true, then set to null.
1509 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
1510 * segments.
1511 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
1512 * Flexfield concatenated segments, if p_validate is true, set to null.
1513 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
1514 * it identifies an existing Soft Coded Key Flexfield combination to associate
1515 * with the assignment, and segment values are ignored. If a value is not
1516 * passed in, then the individual Soft Coded Key Flexfield segments supplied
1517 * will be used to choose an existing combination or create a new combination.
1518 * When the API completes, if p_validate is false, then this uniquely
1519 * identifies the associated combination of the Soft Coded Key flexfield for
1520 * this assignment. If p_validate is true, then set to null.
1521 * @param p_comment_id If p_validate is false and comment text was provided,
1522 * then will be set to the identifier of the created assignment comment record.
1523 * @param p_effective_start_date If p_validate is false, then set to the
1524 * effective start date on the updated assignment row which now exists as of
1525 * the effective date. If p_validate is true, then set to null.
1526 * @param p_effective_end_date If p_validate is false, then set to the
1527 * effective end date on the updated assignment row which now exists as of the
1528 * effective date. If p_validate is true, then set to null.
1529 * @param p_no_managers_warning Set to true if as a result of the update there
1530 * is no manager in the organization. Otherwise set to false.
1531 * @param p_other_manager_warning If set to true, then a manager existed in the
1532 * organization prior to calling this API and the manager flag has been set to
1533 * 'Y' for yes.
1534 * @param p_hourly_salaried_warning Set to true if values entered for Salary
1535 * Basis and Hourly Salaried Code are invalid as of the effective date.
1536 * @param p_gsp_post_process_warning Set to the name of the warning message
1537 * from the Message Dictionary if any Grade Ladder related errors have been
1538 * encountered while running this API.
1539 * @rep:displayname Updates Employee Assignment for Poland
1540 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
1541 * @rep:lifecycle active
1542 * @rep:primaryinstance
1543 * @rep:scope public
1544 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1545 */
1546 --
1547 -- {End Of Comments}
1548 --
1549 procedure update_pl_emp_asg
1550 (p_validate in boolean default false
1551 ,p_effective_date in date
1552 ,p_datetrack_update_mode in varchar2
1553 ,p_assignment_id in number
1554 ,p_object_version_number in out nocopy number
1555 ,p_supervisor_id in number default hr_api.g_number
1556 ,p_assignment_number in varchar2 default hr_api.g_varchar2
1557 ,p_change_reason in varchar2 default hr_api.g_varchar2
1558 ,p_assignment_status_type_id in number default hr_api.g_number
1559 ,p_comments in varchar2 default hr_api.g_varchar2
1560 ,p_date_probation_end in date default hr_api.g_date
1561 ,p_default_code_comb_id in number default hr_api.g_number
1562 ,p_frequency in varchar2 default hr_api.g_varchar2
1563 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1564 ,p_manager_flag in varchar2 default hr_api.g_varchar2
1565 ,p_normal_hours in number default hr_api.g_number
1566 ,p_perf_review_period in number default hr_api.g_number
1567 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1568 ,p_probation_period in number default hr_api.g_number
1569 ,p_probation_unit in varchar2 default hr_api.g_varchar2
1570 ,p_sal_review_period in number default hr_api.g_number
1571 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1572 ,p_set_of_books_id in number default hr_api.g_number
1573 ,p_source_type in varchar2 default hr_api.g_varchar2
1574 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1575 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1576 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1577 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1578 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1579 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1580 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1581 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1582 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1583 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1584 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1585 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1586 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1587 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1588 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1589 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1590 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1591 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1592 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1593 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1594 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1595 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1596 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1597 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1598 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1599 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1600 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1601 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1602 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1603 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1604 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1605 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1606 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1607 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1608 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1609 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1610 ,p_title in varchar2 default hr_api.g_varchar2
1611 ,p_contract_category in varchar2 default hr_api.g_varchar2
1612 ,p_contract_type in varchar2 default hr_api.g_varchar2
1613 ,p_contract_number in varchar2 default hr_api.g_varchar2
1614 ,p_change_of_contract_reason in varchar2 default hr_api.g_varchar2
1615 ,p_job in varchar2 default hr_api.g_varchar2
1616 ,p_work_in_special_condition in varchar2 default hr_api.g_varchar2
1617 ,p_end_of_contract_addl_details in varchar2 default hr_api.g_varchar2
1618 ,p_contract_start_date in varchar2 default hr_api.g_varchar2
1619 ,p_planned_valid_to_date in varchar2 default hr_api.g_varchar2
1620 ,p_contract_type_change_date in varchar2 default hr_api.g_varchar2
1621 ,p_date_contract_signed in varchar2 default hr_api.g_varchar2
1622 ,p_notice_period_date in varchar2 default hr_api.g_varchar2
1623 ,p_notice_period_end_date in varchar2 default hr_api.g_varchar2
1624 ,p_concat_segments in varchar2 default hr_api.g_varchar2
1625 ,p_contract_id in number default hr_api.g_number
1626 ,p_establishment_id in number default hr_api.g_number
1627 ,p_collective_agreement_id in number default hr_api.g_number
1628 ,p_cagr_id_flex_num in number default hr_api.g_number
1629 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1630 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1631 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1632 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1633 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1634 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1635 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1636 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1637 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1638 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1639 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1640 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1641 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1642 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1643 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1644 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1645 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1646 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1647 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1648 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1649 ,p_notice_period in number default hr_api.g_number
1650 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1651 ,p_employee_category in varchar2 default hr_api.g_varchar2
1652 ,p_work_at_home in varchar2 default hr_api.g_varchar2
1653 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1654 ,p_supervisor_assignment_id in number default hr_api.g_number
1655 ,p_cagr_grade_def_id in out nocopy number
1656 ,p_cagr_concatenated_segments out nocopy varchar2
1657 ,p_concatenated_segments out nocopy varchar2
1658 ,p_soft_coding_keyflex_id in out nocopy number
1659 ,p_comment_id out nocopy number
1660 ,p_effective_start_date out nocopy date
1661 ,p_effective_end_date out nocopy date
1662 ,p_no_managers_warning out nocopy boolean
1663 ,p_other_manager_warning out nocopy boolean
1664 ,p_hourly_salaried_warning out nocopy boolean
1665 ,p_gsp_post_process_warning out nocopy varchar2
1666 );
1667
1668
1669 END hr_pl_assignment_api;