1 Package hr_de_assignment_api as
2 /* $Header: peasgdei.pkh 120.1 2005/10/02 02:11:08 aroussel $ */
3 /*#
4 * This package contains assignment APIs for Germany.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Assignment for Germany
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_de_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a secondary employee assignment for Germany.
17 *
18 * The API calls the generic API create_secondary_emp_asg, with the appropriate
19 * parameters set for the German person. As this API is effectively an
20 * alternative to the API create_secondary_emp_asg, see that API for further
21 * explanation.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * The person (p_person_id) and the organization (p_organization_id) must exist
28 * at the effective start date of the assignment (p_effective_date).
29 *
30 * <p><b>Post Success</b><br>
31 * The API successfully creates the secondary employee assignment record in the
32 * database.
33 *
34 * <p><b>Post Failure</b><br>
35 * The API does not create the secondary assignment record and raises an error.
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_effective_date Determines when the DateTrack operation comes into
40 * force.
41 * @param p_person_id Identifies the person for whom you create the secondary
42 * assignment record
43 * @param p_organization_id Identifies the organization of the secondary
44 * assignment
45 * @param p_grade_id Identifies the grade of the secondary assignment
46 * @param p_position_id Identifies the position of the secondary assignment
47 * @param p_job_id Identifies the job of the secondary assignment
48 * @param p_assignment_status_type_id Identifies the assignment status of the
49 * secondary assignment.
50 * @param p_payroll_id Identifies the payroll for the secondary assignment
51 * @param p_location_id Identifies the location of the secondary assignment
52 * @param p_supervisor_id Identifies the supervisor for the secondary
53 * assignment. The value refers to the supervisor's person record.
54 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
55 * associated with the grade of the secondary assignment.
56 * @param p_pay_basis_id Salary basis for the secondary assignment
57 * @param p_assignment_number If a value is passed in, this is used as the
58 * assignment number. If no value is passed in an assignment number is
59 * generated.
60 * @param p_change_reason Reason for the assignment status change. If there is
61 * no change reason the parameter can be null. Valid values are defined in the
62 * EMP_ASSIGN_REASON lookup type.
63 * @param p_comments Comment text.
64 * @param p_date_probation_end End date of probation period
65 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
66 * Flexfield combination that applies to this assignment
67 * @param p_employment_category Employment category. Valid values are defined
68 * in the EMP_CAT lookup type.
69 * @param p_frequency Frequency associated with the defined normal working
70 * hours. Valid values are defined in the FREQUENCY lookup type.
71 * @param p_internal_address_line Internal address identified with the
72 * secondary assignment.
73 * @param p_manager_flag Indicates whether the employee is a manager
74 * @param p_normal_hours Normal working hours for this assignment
75 * @param p_perf_review_period Length of performance review period.
76 * @param p_perf_review_period_frequency Units of performance review period.
77 * Valid values are defined in the FREQUENCY lookup type.
78 * @param p_probation_period Length of probation period
79 * @param p_probation_unit Units of probation period. Valid values are defined
80 * in the QUALIFYING_UNITS lookup type.
81 * @param p_sal_review_period Length of salary review period
82 * @param p_sal_review_period_frequency Units of salary review period. Valid
83 * values are defined in the FREQUENCY lookup type.
84 * @param p_set_of_books_id Identifies General Ledger set of books.
85 * @param p_source_type Recruitment activity which this assignment is sourced
86 * from. Valid values are defined in the REC_TYPE lookup type.
87 * @param p_time_normal_finish Normal work finish time
88 * @param p_time_normal_start Normal work start time
89 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
90 * defined in the BARGAINING_UNIT_CODE lookup type.
91 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
92 * is salaried. Valid values defined in the HOURLY_SALARIED_CODE lookup type.
93 * @param p_ass_attribute_category This context value determines which
94 * Flexfield Structure to use with the Descriptive flexfield segments.
95 * @param p_ass_attribute1 Descriptive flexfield segment
96 * @param p_ass_attribute2 Descriptive flexfield segment
97 * @param p_ass_attribute3 Descriptive flexfield segment
98 * @param p_ass_attribute4 Descriptive flexfield segment
99 * @param p_ass_attribute5 Descriptive flexfield segment
100 * @param p_ass_attribute6 Descriptive flexfield segment
101 * @param p_ass_attribute7 Descriptive flexfield segment
102 * @param p_ass_attribute8 Descriptive flexfield segment
103 * @param p_ass_attribute9 Descriptive flexfield segment
104 * @param p_ass_attribute10 Descriptive flexfield segment
105 * @param p_ass_attribute11 Descriptive flexfield segment
106 * @param p_ass_attribute12 Descriptive flexfield segment
107 * @param p_ass_attribute13 Descriptive flexfield segment
108 * @param p_ass_attribute14 Descriptive flexfield segment
109 * @param p_ass_attribute15 Descriptive flexfield segment
110 * @param p_ass_attribute16 Descriptive flexfield segment
111 * @param p_ass_attribute17 Descriptive flexfield segment
112 * @param p_ass_attribute18 Descriptive flexfield segment
113 * @param p_ass_attribute19 Descriptive flexfield segment
114 * @param p_ass_attribute20 Descriptive flexfield segment
115 * @param p_ass_attribute21 Descriptive flexfield segment
116 * @param p_ass_attribute22 Descriptive flexfield segment
117 * @param p_ass_attribute23 Descriptive flexfield segment
118 * @param p_ass_attribute24 Descriptive flexfield segment
119 * @param p_ass_attribute25 Descriptive flexfield segment
120 * @param p_ass_attribute26 Descriptive flexfield segment
121 * @param p_ass_attribute27 Descriptive flexfield segment
122 * @param p_ass_attribute28 Descriptive flexfield segment
123 * @param p_ass_attribute29 Descriptive flexfield segment
124 * @param p_ass_attribute30 Descriptive flexfield segment
125 * @param p_title Obsolete parameter, do not use.
126 * @param p_scl_segment1 Soft Coded key flexfield segment
127 * @param p_scl_segment2 Soft Coded key flexfield segment
128 * @param p_scl_segment3 Soft Coded key flexfield segment
129 * @param p_scl_segment4 Soft Coded key flexfield segment
130 * @param p_scl_segment5 Soft Coded key flexfield segment
131 * @param p_scl_segment6 Soft Coded key flexfield segment
132 * @param p_scl_segment7 Soft Coded key flexfield segment
133 * @param p_scl_segment8 Soft Coded key flexfield segment
134 * @param p_scl_segment9 Soft Coded key flexfield segment
135 * @param p_scl_segment10 Soft Coded key flexfield segment
136 * @param p_scl_segment11 Soft Coded key flexfield segment
137 * @param p_scl_segment12 Soft Coded key flexfield segment
138 * @param p_scl_segment13 Soft Coded key flexfield segment
139 * @param p_scl_segment14 Soft Coded key flexfield segment
140 * @param p_scl_segment15 Soft Coded key flexfield segment
141 * @param p_scl_segment16 Soft Coded key flexfield segment
142 * @param p_scl_segment17 Soft Coded key flexfield segment
143 * @param p_scl_segment18 Soft Coded key flexfield segment
144 * @param p_scl_segment19 Soft Coded key flexfield segment
145 * @param p_scl_segment20 Soft Coded key flexfield segment
146 * @param p_scl_segment21 Soft Coded key flexfield segment
147 * @param p_scl_segment22 Soft Coded key flexfield segment
148 * @param p_scl_segment23 Soft Coded key flexfield segment
149 * @param p_scl_segment24 Soft Coded key flexfield segment
150 * @param p_scl_segment25 Soft Coded key flexfield segment
151 * @param p_scl_segment26 Soft Coded key flexfield segment
152 * @param p_scl_segment27 Soft Coded key flexfield segment
153 * @param p_scl_segment28 Soft Coded key flexfield segment
154 * @param p_scl_segment29 Soft Coded key flexfield segment
155 * @param p_scl_segment30 Soft Coded key flexfield segment
156 * @param p_scl_concat_segments Concatenated segments for Soft Coded Key
157 * Flexfield. Concatenated segments can be supplied instead of individual
158 * segments.
159 * @param p_pgp_segment1 People group key flexfield segment
160 * @param p_pgp_segment2 People group key flexfield segment
161 * @param p_pgp_segment3 People group key flexfield segment
162 * @param p_pgp_segment4 People group key flexfield segment
163 * @param p_pgp_segment5 People group key flexfield segment
164 * @param p_pgp_segment6 People group key flexfield segment
165 * @param p_pgp_segment7 People group key flexfield segment
166 * @param p_pgp_segment8 People group key flexfield segment
167 * @param p_pgp_segment9 People group key flexfield segment
168 * @param p_pgp_segment10 People group key flexfield segment
169 * @param p_pgp_segment11 People group key flexfield segment
170 * @param p_pgp_segment12 People group key flexfield segment
171 * @param p_pgp_segment13 People group key flexfield segment
172 * @param p_pgp_segment14 People group key flexfield segment
173 * @param p_pgp_segment15 People group key flexfield segment
174 * @param p_pgp_segment16 People group key flexfield segment
175 * @param p_pgp_segment17 People group key flexfield segment
176 * @param p_pgp_segment18 People group key flexfield segment
177 * @param p_pgp_segment19 People group key flexfield segment
178 * @param p_pgp_segment20 People group key flexfield segment
179 * @param p_pgp_segment21 People group key flexfield segment
180 * @param p_pgp_segment22 People group key flexfield segment
181 * @param p_pgp_segment23 People group key flexfield segment
182 * @param p_pgp_segment24 People group key flexfield segment
183 * @param p_pgp_segment25 People group key flexfield segment
184 * @param p_pgp_segment26 People group key flexfield segment
185 * @param p_pgp_segment27 People group key flexfield segment
186 * @param p_pgp_segment28 People group key flexfield segment
187 * @param p_pgp_segment29 People group key flexfield segment
188 * @param p_pgp_segment30 People group key flexfield segment
189 * @param p_pgp_concat_segments Concatenated segments for People Group Key
190 * Flexfield. Concatenated segments can be supplied instead of individual
191 * segments.
192 * @param p_contract_id Contract associated with this assignment
193 * @param p_establishment_id For French business groups, this identifies the
194 * Establishment Legal Entity for this assignment.
195 * @param p_collective_agreement_id Collective Agreement that applies to this
196 * assignment
197 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
198 * flexfield to use for this assignment
199 * @param p_cag_segment1 CAGR Key Flexfield segment
200 * @param p_cag_segment2 CAGR Key Flexfield segment
201 * @param p_cag_segment3 CAGR Key Flexfield segment
202 * @param p_cag_segment4 CAGR Key Flexfield segment
203 * @param p_cag_segment5 CAGR Key Flexfield segment
204 * @param p_cag_segment6 CAGR Key Flexfield segment
205 * @param p_cag_segment7 CAGR Key Flexfield segment
206 * @param p_cag_segment8 CAGR Key Flexfield segment
207 * @param p_cag_segment9 CAGR Key Flexfield segment
208 * @param p_cag_segment10 CAGR Key Flexfield segment
209 * @param p_cag_segment11 CAGR Key Flexfield segment
210 * @param p_cag_segment12 CAGR Key Flexfield segment
211 * @param p_cag_segment13 CAGR Key Flexfield segment
212 * @param p_cag_segment14 CAGR Key Flexfield segment
213 * @param p_cag_segment15 CAGR Key Flexfield segment
214 * @param p_cag_segment16 CAGR Key Flexfield segment
215 * @param p_cag_segment17 CAGR Key Flexfield segment
216 * @param p_cag_segment18 CAGR Key Flexfield segment
217 * @param p_cag_segment19 CAGR Key Flexfield segment
218 * @param p_cag_segment20 CAGR Key Flexfield segment
219 * @param p_group_name If p_validate is false, set to the People Group Key
220 * Flexfield concatenated segments. If p_validate is true, set to null.
221 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
222 * Flexfield concatenated segments, if p_validate is true, set to null.
223 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
224 * identifies an existing CAGR Key Flexfield combination to associate with the
225 * assignment, and segment values are ignored. If a value is not passed in,
226 * then the individual CAGR Key Flexfield segments supplied will be used to
227 * choose an existing combination or create a new combination. When the API
228 * completes, if p_validate is false, then this uniquely identifies the
229 * associated combination of the CAGR Key flexfield for this assignment. If
230 * p_validate is true, then set to null.
231 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated segments
232 * @param p_assignment_id If p_validate is false, then this uniquely identifies
233 * the created assignment. If p_validate is true, then set to null.
234 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
235 * it identifies an existing Soft Coded Key Flexfield combination to associate
236 * with the assignment, and segment values are ignored. If a value is not
237 * passed in, then the individual Soft Coded Key Flexfield segments supplied
238 * will be used to choose an existing combination or create a new combination.
239 * When the API completes, if p_validate is false, then this uniquely
240 * identifies the associated combination of the Soft Coded Key flexfield for
241 * this assignment. If p_validate is true, then set to null.
242 * @param p_people_group_id If a value is passed in for this parameter, it
243 * identifies an existing People Group Key Flexfield combination to associate
244 * with the assignment, and segment values are ignored. If a value is not
245 * passed in, then the individual People Group Key Flexfield segments supplied
246 * will be used to choose an existing combination or create a new combination.
247 * When the API completes, if p_validate is false, then this uniquely
248 * identifies the associated combination of the People Group Key flexfield for
249 * this assignment. If p_validate is true, then set to null.
250 * @param p_object_version_number If p_validate is false, then set to the
251 * version number of the created assignment. If p_validate is true, then the
252 * value will be null.
253 * @param p_effective_start_date If p_validate is false, then set to the
254 * earliest effective start date for the created assignment. If p_validate is
255 * true, then set to null.
256 * @param p_effective_end_date If p_validate is false, then set to the
257 * effective end date for the created assignment. If p_validate is true, then
258 * set to null.
259 * @param p_assignment_sequence If p_validate is false, then an automatically
260 * incremented number is associated with this assignment, depending on the
261 * number of assignment which already exist. If p_validate is true then set to
262 * null.
263 * @param p_comment_id If p_validate is false and comment text was provided,
264 * then will be set to the identifier of the created assignment comment record.
265 * If p_validate is true or no comment text was provided, then will be null.
266 * @param p_other_manager_warning If set to true, then a manager existed in the
267 * organization prior to calling this API and the manager flag has been set to
268 * 'Y' for yes.
269 * @rep:displayname Create Secondary Employee Assignment for Germany
270 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
271 * @rep:scope public
272 * @rep:lifecycle active
273 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
274 */
275 --
276 -- {End Of Comments}
277 --
278 procedure create_de_secondary_emp_asg
279 (p_validate in boolean default false
280 ,p_effective_date in date
281 ,p_person_id in number
282 ,p_organization_id in number
283 ,p_grade_id in number default null
284 ,p_position_id in number default null
285 ,p_job_id in number default null
286 ,p_assignment_status_type_id in number default null
287 ,p_payroll_id in number default null
288 ,p_location_id in number default null
289 ,p_supervisor_id in number default null
290 ,p_special_ceiling_step_id in number default null
291 ,p_pay_basis_id in number default null
292 ,p_assignment_number in out nocopy varchar2
293 ,p_change_reason in varchar2 default null
294 ,p_comments in varchar2 default null
295 ,p_date_probation_end in date default null
296 ,p_default_code_comb_id in number default null
297 ,p_employment_category in varchar2 default null
298 ,p_frequency in varchar2 default null
299 ,p_internal_address_line in varchar2 default null
300 ,p_manager_flag in varchar2 default null
301 ,p_normal_hours in number default null
302 ,p_perf_review_period in number default null
303 ,p_perf_review_period_frequency in varchar2 default null
304 ,p_probation_period in number default null
305 ,p_probation_unit in varchar2 default null
306 ,p_sal_review_period in number default null
307 ,p_sal_review_period_frequency in varchar2 default null
308 ,p_set_of_books_id in number default null
309 ,p_source_type in varchar2 default null
310 ,p_time_normal_finish in varchar2 default null
311 ,p_time_normal_start in varchar2 default null
312 ,p_bargaining_unit_code in varchar2 default null
313 ,p_hourly_salaried_code in varchar2 default null
314 ,p_ass_attribute_category in varchar2 default null
315 ,p_ass_attribute1 in varchar2 default null
316 ,p_ass_attribute2 in varchar2 default null
317 ,p_ass_attribute3 in varchar2 default null
318 ,p_ass_attribute4 in varchar2 default null
319 ,p_ass_attribute5 in varchar2 default null
320 ,p_ass_attribute6 in varchar2 default null
321 ,p_ass_attribute7 in varchar2 default null
322 ,p_ass_attribute8 in varchar2 default null
323 ,p_ass_attribute9 in varchar2 default null
324 ,p_ass_attribute10 in varchar2 default null
325 ,p_ass_attribute11 in varchar2 default null
326 ,p_ass_attribute12 in varchar2 default null
327 ,p_ass_attribute13 in varchar2 default null
328 ,p_ass_attribute14 in varchar2 default null
329 ,p_ass_attribute15 in varchar2 default null
330 ,p_ass_attribute16 in varchar2 default null
331 ,p_ass_attribute17 in varchar2 default null
332 ,p_ass_attribute18 in varchar2 default null
333 ,p_ass_attribute19 in varchar2 default null
334 ,p_ass_attribute20 in varchar2 default null
335 ,p_ass_attribute21 in varchar2 default null
336 ,p_ass_attribute22 in varchar2 default null
337 ,p_ass_attribute23 in varchar2 default null
338 ,p_ass_attribute24 in varchar2 default null
339 ,p_ass_attribute25 in varchar2 default null
340 ,p_ass_attribute26 in varchar2 default null
341 ,p_ass_attribute27 in varchar2 default null
342 ,p_ass_attribute28 in varchar2 default null
343 ,p_ass_attribute29 in varchar2 default null
344 ,p_ass_attribute30 in varchar2 default null
345 ,p_title in varchar2 default null
346 ,p_scl_segment1 in varchar2 default null
347 ,p_scl_segment2 in varchar2 default null
348 ,p_scl_segment3 in varchar2 default null
349 ,p_scl_segment4 in varchar2 default null
350 ,p_scl_segment5 in varchar2 default null
351 ,p_scl_segment6 in varchar2 default null
352 ,p_scl_segment7 in varchar2 default null
353 ,p_scl_segment8 in varchar2 default null
354 ,p_scl_segment9 in varchar2 default null
355 ,p_scl_segment10 in varchar2 default null
356 ,p_scl_segment11 in varchar2 default null
357 ,p_scl_segment12 in varchar2 default null
358 ,p_scl_segment13 in varchar2 default null
359 ,p_scl_segment14 in varchar2 default null
360 ,p_scl_segment15 in varchar2 default null
361 ,p_scl_segment16 in varchar2 default null
362 ,p_scl_segment17 in varchar2 default null
363 ,p_scl_segment18 in varchar2 default null
364 ,p_scl_segment19 in varchar2 default null
365 ,p_scl_segment20 in varchar2 default null
366 ,p_scl_segment21 in varchar2 default null
367 ,p_scl_segment22 in varchar2 default null
368 ,p_scl_segment23 in varchar2 default null
369 ,p_scl_segment24 in varchar2 default null
370 ,p_scl_segment25 in varchar2 default null
371 ,p_scl_segment26 in varchar2 default null
372 ,p_scl_segment27 in varchar2 default null
373 ,p_scl_segment28 in varchar2 default null
374 ,p_scl_segment29 in varchar2 default null
375 ,p_scl_segment30 in varchar2 default null
376 ,p_scl_concat_segments in varchar2 default null
377 ,p_pgp_segment1 in varchar2 default null
378 ,p_pgp_segment2 in varchar2 default null
379 ,p_pgp_segment3 in varchar2 default null
380 ,p_pgp_segment4 in varchar2 default null
381 ,p_pgp_segment5 in varchar2 default null
382 ,p_pgp_segment6 in varchar2 default null
383 ,p_pgp_segment7 in varchar2 default null
384 ,p_pgp_segment8 in varchar2 default null
385 ,p_pgp_segment9 in varchar2 default null
386 ,p_pgp_segment10 in varchar2 default null
387 ,p_pgp_segment11 in varchar2 default null
388 ,p_pgp_segment12 in varchar2 default null
389 ,p_pgp_segment13 in varchar2 default null
390 ,p_pgp_segment14 in varchar2 default null
391 ,p_pgp_segment15 in varchar2 default null
392 ,p_pgp_segment16 in varchar2 default null
393 ,p_pgp_segment17 in varchar2 default null
394 ,p_pgp_segment18 in varchar2 default null
395 ,p_pgp_segment19 in varchar2 default null
396 ,p_pgp_segment20 in varchar2 default null
397 ,p_pgp_segment21 in varchar2 default null
398 ,p_pgp_segment22 in varchar2 default null
399 ,p_pgp_segment23 in varchar2 default null
400 ,p_pgp_segment24 in varchar2 default null
401 ,p_pgp_segment25 in varchar2 default null
402 ,p_pgp_segment26 in varchar2 default null
403 ,p_pgp_segment27 in varchar2 default null
404 ,p_pgp_segment28 in varchar2 default null
405 ,p_pgp_segment29 in varchar2 default null
406 ,p_pgp_segment30 in varchar2 default null
407 ,p_pgp_concat_segments in varchar2 default null
408 ,p_contract_id in number default null
409 ,p_establishment_id in number default null
410 ,p_collective_agreement_id in number default null
411 ,p_cagr_id_flex_num in number default null
412 ,p_cag_segment1 in varchar2 default null
413 ,p_cag_segment2 in varchar2 default null
414 ,p_cag_segment3 in varchar2 default null
415 ,p_cag_segment4 in varchar2 default null
416 ,p_cag_segment5 in varchar2 default null
417 ,p_cag_segment6 in varchar2 default null
418 ,p_cag_segment7 in varchar2 default null
419 ,p_cag_segment8 in varchar2 default null
420 ,p_cag_segment9 in varchar2 default null
421 ,p_cag_segment10 in varchar2 default null
422 ,p_cag_segment11 in varchar2 default null
423 ,p_cag_segment12 in varchar2 default null
424 ,p_cag_segment13 in varchar2 default null
425 ,p_cag_segment14 in varchar2 default null
426 ,p_cag_segment15 in varchar2 default null
427 ,p_cag_segment16 in varchar2 default null
428 ,p_cag_segment17 in varchar2 default null
429 ,p_cag_segment18 in varchar2 default null
430 ,p_cag_segment19 in varchar2 default null
431 ,p_cag_segment20 in varchar2 default null
432 --
433 ,p_group_name out nocopy varchar2
434 ,p_concatenated_segments out nocopy varchar2
435 ,p_cagr_grade_def_id out nocopy number
436 ,p_cagr_concatenated_segments out nocopy varchar2
437 ,p_assignment_id out nocopy number
438 ,p_soft_coding_keyflex_id out nocopy number
439 ,p_people_group_id out nocopy number
440 ,p_object_version_number out nocopy number
441 ,p_effective_start_date out nocopy date
442 ,p_effective_end_date out nocopy date
443 ,p_assignment_sequence out nocopy number
444 ,p_comment_id out nocopy number
445 ,p_other_manager_warning out nocopy boolean
446 );
447 --
448 -- ----------------------------------------------------------------------------
449 -- |----------------------------< update_de_emp_asg >-------------------------|
450 -- ----------------------------------------------------------------------------
451 --
452 -- {Start Of Comments}
453 /*#
454 * This API updates information for an existing employee assignment with a
455 * German legislation.
456 *
457 * The API calls the generic API update_emp_asg, with parameters set as
458 * appropriate for a German employee assignment.
459 *
460 * <p><b>Licensing</b><br>
461 * This API is licensed for use with Human Resources.
462 *
463 * <p><b>Prerequisites</b><br>
464 * The assignment (p_assignment_id) must exist as of the effective date of the
465 * update (p_effective_date).
466 *
467 * <p><b>Post Success</b><br>
468 * The employee assignment is successfully updated in the database.
469 *
470 * <p><b>Post Failure</b><br>
471 * The API does not update the assignment and raises an error.
472 * @param p_validate If true, then validation alone will be performed and the
473 * database will remain unchanged. If false and all validation checks pass,
474 * then the database will be modified.
475 * @param p_effective_date Determines when the DateTrack operation comes into
476 * force.
477 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
478 * updating the record. You must set to either UPDATE, CORRECTION,
479 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
480 * particular record depend on the dates of previous record changes and the
481 * effective date of this change.
482 * @param p_assignment_id Identifies the assignment record to be modified.
483 * @param p_object_version_number Pass in the current version number of the
484 * assignment to be updated. When the API completes if p_validate is false,
485 * will be set to the new version number of the updated assignment. If
486 * p_validate is true will be set to the same value which was passed in.
487 * @param p_supervisor_id Supervisor for the assignment. The value refers to
488 * the supervisor's person record.
489 * @param p_assignment_number Assignment number
490 * @param p_change_reason Reason for the assignment status change. If there is
491 * no change reason the parameter can be null. Valid values are defined in the
492 * EMP_ASSIGN_REASON lookup type.
493 * @param p_comments Comment text.
494 * @param p_date_probation_end End date of probation period
495 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
496 * Flexfield combination that applies to this assignment
497 * @param p_frequency Frequency associated with the defined normal working
498 * hours. Valid values are defined in the FREQUENCY lookup type.
499 * @param p_internal_address_line Internal address identified with this
500 * assignment.
501 * @param p_manager_flag Indicates whether the employee is a manager
502 * @param p_normal_hours Normal working hours for this assignment
503 * @param p_perf_review_period Length of performance review period
504 * @param p_perf_review_period_frequency Units of performance review period.
505 * Valid values are defined in the FREQUENCY lookup type.
506 * @param p_probation_period Length of probation period
507 * @param p_probation_unit Units of probation period. Valid values are defined
508 * in the QUALIFYING_UNITS lookup type.
509 * @param p_sal_review_period Length of salary review period
510 * @param p_sal_review_period_frequency Units of salary review period. Valid
511 * values are defined in the FREQUENCY lookup type.
512 * @param p_set_of_books_id Identifies General Ledger set of books.
513 * @param p_source_type Recruitment activity which this assignment is sourced
514 * from. Valid values are defined in the REC_TYPE lookup type.
515 * @param p_time_normal_finish Normal work finish time
516 * @param p_time_normal_start Normal work start time
517 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
518 * defined in the BARGAINING_UNIT_CODE lookup type.
519 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
520 * is salaried. Valid values defined in the HOURLY_SALARIED_CODE lookup type.
521 * @param p_ass_attribute_category This context value determines which
522 * Flexfield Structure to use with the Descriptive flexfield segments.
523 * @param p_ass_attribute1 Descriptive flexfield segment
524 * @param p_ass_attribute2 Descriptive flexfield segment
525 * @param p_ass_attribute3 Descriptive flexfield segment
526 * @param p_ass_attribute4 Descriptive flexfield segment
527 * @param p_ass_attribute5 Descriptive flexfield segment
528 * @param p_ass_attribute6 Descriptive flexfield segment
529 * @param p_ass_attribute7 Descriptive flexfield segment
530 * @param p_ass_attribute8 Descriptive flexfield segment
531 * @param p_ass_attribute9 Descriptive flexfield segment
532 * @param p_ass_attribute10 Descriptive flexfield segment
533 * @param p_ass_attribute11 Descriptive flexfield segment
534 * @param p_ass_attribute12 Descriptive flexfield segment
535 * @param p_ass_attribute13 Descriptive flexfield segment
536 * @param p_ass_attribute14 Descriptive flexfield segment
537 * @param p_ass_attribute15 Descriptive flexfield segment
538 * @param p_ass_attribute16 Descriptive flexfield segment
539 * @param p_ass_attribute17 Descriptive flexfield segment
540 * @param p_ass_attribute18 Descriptive flexfield segment
541 * @param p_ass_attribute19 Descriptive flexfield segment
542 * @param p_ass_attribute20 Descriptive flexfield segment
543 * @param p_ass_attribute21 Descriptive flexfield segment
544 * @param p_ass_attribute22 Descriptive flexfield segment
545 * @param p_ass_attribute23 Descriptive flexfield segment
546 * @param p_ass_attribute24 Descriptive flexfield segment
547 * @param p_ass_attribute25 Descriptive flexfield segment
548 * @param p_ass_attribute26 Descriptive flexfield segment
549 * @param p_ass_attribute27 Descriptive flexfield segment
550 * @param p_ass_attribute28 Descriptive flexfield segment
551 * @param p_ass_attribute29 Descriptive flexfield segment
552 * @param p_ass_attribute30 Descriptive flexfield segment
553 * @param p_title Obsolete parameter, do not use.
554 * @param p_segment1 Soft Coded key flexfield segment
555 * @param p_segment2 Soft Coded key flexfield segment
556 * @param p_segment3 Soft Coded key flexfield segment
557 * @param p_segment4 Soft Coded key flexfield segment
558 * @param p_segment5 Soft Coded key flexfield segment
559 * @param p_segment6 Soft Coded key flexfield segment
560 * @param p_segment7 Soft Coded key flexfield segment
561 * @param p_segment8 Soft Coded key flexfield segment
562 * @param p_segment9 Soft Coded key flexfield segment
563 * @param p_segment10 Soft Coded key flexfield segment
564 * @param p_segment11 Soft Coded key flexfield segment
565 * @param p_segment12 Soft Coded key flexfield segment
566 * @param p_segment13 Soft Coded key flexfield segment
567 * @param p_segment14 Soft Coded key flexfield segment
568 * @param p_segment15 Soft Coded key flexfield segment
569 * @param p_segment16 Soft Coded key flexfield segment
570 * @param p_segment17 Soft Coded key flexfield segment
571 * @param p_segment18 Soft Coded key flexfield segment
572 * @param p_segment19 Soft Coded key flexfield segment
573 * @param p_segment20 Soft Coded key flexfield segment
574 * @param p_segment21 Soft Coded key flexfield segment
575 * @param p_segment22 Soft Coded key flexfield segment
576 * @param p_segment23 Soft Coded key flexfield segment
577 * @param p_segment24 Soft Coded key flexfield segment
578 * @param p_segment25 Soft Coded key flexfield segment
579 * @param p_segment26 Soft Coded key flexfield segment
580 * @param p_segment27 Soft Coded key flexfield segment
581 * @param p_segment28 Soft Coded key flexfield segment
582 * @param p_segment29 Soft Coded key flexfield segment
583 * @param p_segment30 Soft Coded key flexfield segment
584 * @param p_concat_segments Concatenated segments for Soft Coded Key Flexfield.
585 * Concatenated segments can be supplied instead of individual segments.
586 * @param p_contract_id Contract associated with this assignment
587 * @param p_establishment_id For French business groups, this identifies the
588 * Establishment Legal Entity for this assignment.
589 * @param p_collective_agreement_id Collective Agreement that applies to this
590 * assignment
591 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
592 * flexfield to use for this assignment
593 * @param p_cag_segment1 CAGR Key Flexfield segment
594 * @param p_cag_segment2 CAGR Key Flexfield segment
595 * @param p_cag_segment3 CAGR Key Flexfield segment
596 * @param p_cag_segment4 CAGR Key Flexfield segment
597 * @param p_cag_segment5 CAGR Key Flexfield segment
598 * @param p_cag_segment6 CAGR Key Flexfield segment
599 * @param p_cag_segment7 CAGR Key Flexfield segment
600 * @param p_cag_segment8 CAGR Key Flexfield segment
601 * @param p_cag_segment9 CAGR Key Flexfield segment
602 * @param p_cag_segment10 CAGR Key Flexfield segment
603 * @param p_cag_segment11 CAGR Key Flexfield segment
604 * @param p_cag_segment12 CAGR Key Flexfield segment
605 * @param p_cag_segment13 CAGR Key Flexfield segment
606 * @param p_cag_segment14 CAGR Key Flexfield segment
607 * @param p_cag_segment15 CAGR Key Flexfield segment
608 * @param p_cag_segment16 CAGR Key Flexfield segment
609 * @param p_cag_segment17 CAGR Key Flexfield segment
610 * @param p_cag_segment18 CAGR Key Flexfield segment
611 * @param p_cag_segment19 CAGR Key Flexfield segment
612 * @param p_cag_segment20 CAGR Key Flexfield segment
613 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
614 * identifies an existing CAGR Key Flexfield combination to associate with the
615 * assignment, and segment values are ignored. If a value is not passed in,
616 * then the individual CAGR Key Flexfield segments supplied will be used to
617 * choose an existing combination or create a new combination. When the API
618 * completes, if p_validate is false, then this uniquely identifies the
619 * associated combination of the CAGR Key flexfield for this assignment. If
620 * p_validate is true, then set to null.
621 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated segments
622 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
623 * Flexfield concatenated segments, if p_validate is true, set to null.
624 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
625 * it identifies an existing Soft Coded Key Flexfield combination to associate
626 * with the assignment, and segment values are ignored. If a value is not
627 * passed in, then the individual Soft Coded Key Flexfield segments supplied
628 * will be used to choose an existing combination or create a new combination.
629 * When the API completes, if p_validate is false, then this uniquely
630 * identifies the associated combination of the Soft Coded Key flexfield for
631 * this assignment. If p_validate is true, then set to null.
632 * @param p_comment_id If p_validate is false and comment text was provided,
633 * then will be set to the identifier of the created assignment comment record.
634 * If p_validate is true or no comment text was provided, then will be null.
635 * @param p_effective_start_date If p_validate is false, then set to the
636 * earliest effective start date for the created assignment. If p_validate is
637 * true, then set to null.
638 * @param p_effective_end_date If p_validate is false, then set to the
639 * effective end date for the created assignment. If p_validate is true, then
640 * set to null.
641 * @param p_no_managers_warning Set to true if as a result of the update there
642 * is no manager in the organization. Otherwise set to false.
643 * @param p_other_manager_warning If set to true, then a manager existed in the
644 * organization prior to calling this API and the manager flag has been set to
645 * 'Y' for yes.
646 * @rep:displayname Update Employee Assignment for Germany
647 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
648 * @rep:scope public
649 * @rep:lifecycle active
650 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
651 */
652 --
653 -- {End Of Comments}
654 --
655 procedure update_de_emp_asg
656 (p_validate in boolean default false
657 ,p_effective_date in date
658 ,p_datetrack_update_mode in varchar2
659 ,p_assignment_id in number
660 ,p_object_version_number in out nocopy number
661 ,p_supervisor_id in number default hr_api.g_number
662 ,p_assignment_number in varchar2 default hr_api.g_varchar2
663 ,p_change_reason in varchar2 default hr_api.g_varchar2
664 ,p_comments in varchar2 default hr_api.g_varchar2
665 ,p_date_probation_end in date default hr_api.g_date
666 ,p_default_code_comb_id in number default hr_api.g_number
667 ,p_frequency in varchar2 default hr_api.g_varchar2
668 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
669 ,p_manager_flag in varchar2 default hr_api.g_varchar2
670 ,p_normal_hours in number default hr_api.g_number
671 ,p_perf_review_period in number default hr_api.g_number
672 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
673 ,p_probation_period in number default hr_api.g_number
674 ,p_probation_unit in varchar2 default hr_api.g_varchar2
675 ,p_sal_review_period in number default hr_api.g_number
676 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
677 ,p_set_of_books_id in number default hr_api.g_number
678 ,p_source_type in varchar2 default hr_api.g_varchar2
679 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
680 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
681 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
682 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
683 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
684 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
685 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
686 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
687 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
688 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
689 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
690 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
691 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
692 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
693 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
694 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
695 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
696 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
697 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
698 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
699 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
700 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
701 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
702 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
703 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
704 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
705 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
706 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
707 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
708 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
709 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
710 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
711 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
712 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
713 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
714 ,p_title in varchar2 default hr_api.g_varchar2
715 ,p_segment1 in varchar2 default hr_api.g_varchar2
716 ,p_segment2 in varchar2 default hr_api.g_varchar2
717 ,p_segment3 in varchar2 default hr_api.g_varchar2
718 ,p_segment4 in varchar2 default hr_api.g_varchar2
719 ,p_segment5 in varchar2 default hr_api.g_varchar2
720 ,p_segment6 in varchar2 default hr_api.g_varchar2
721 ,p_segment7 in varchar2 default hr_api.g_varchar2
722 ,p_segment8 in varchar2 default hr_api.g_varchar2
723 ,p_segment9 in varchar2 default hr_api.g_varchar2
724 ,p_segment10 in varchar2 default hr_api.g_varchar2
725 ,p_segment11 in varchar2 default hr_api.g_varchar2
726 ,p_segment12 in varchar2 default hr_api.g_varchar2
727 ,p_segment13 in varchar2 default hr_api.g_varchar2
728 ,p_segment14 in varchar2 default hr_api.g_varchar2
729 ,p_segment15 in varchar2 default hr_api.g_varchar2
730 ,p_segment16 in varchar2 default hr_api.g_varchar2
731 ,p_segment17 in varchar2 default hr_api.g_varchar2
732 ,p_segment18 in varchar2 default hr_api.g_varchar2
733 ,p_segment19 in varchar2 default hr_api.g_varchar2
734 ,p_segment20 in varchar2 default hr_api.g_varchar2
735 ,p_segment21 in varchar2 default hr_api.g_varchar2
736 ,p_segment22 in varchar2 default hr_api.g_varchar2
737 ,p_segment23 in varchar2 default hr_api.g_varchar2
738 ,p_segment24 in varchar2 default hr_api.g_varchar2
739 ,p_segment25 in varchar2 default hr_api.g_varchar2
740 ,p_segment26 in varchar2 default hr_api.g_varchar2
741 ,p_segment27 in varchar2 default hr_api.g_varchar2
742 ,p_segment28 in varchar2 default hr_api.g_varchar2
743 ,p_segment29 in varchar2 default hr_api.g_varchar2
744 ,p_segment30 in varchar2 default hr_api.g_varchar2
745 ,p_concat_segments in varchar2 default hr_api.g_varchar2
746 ,p_contract_id in number default hr_api.g_number
747 ,p_establishment_id in number default hr_api.g_number
748 ,p_collective_agreement_id in number default hr_api.g_number
749 ,p_cagr_id_flex_num in number default hr_api.g_number
750 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
751 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
752 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
753 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
754 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
755 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
756 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
757 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
758 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
759 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
760 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
761 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
762 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
763 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
764 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
765 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
766 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
767 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
768 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
769 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
770 ,p_cagr_grade_def_id out nocopy number
771 ,p_cagr_concatenated_segments out nocopy varchar2
772 ,p_concatenated_segments out nocopy varchar2
773 ,p_soft_coding_keyflex_id out nocopy number
774 ,p_comment_id out nocopy number
775 ,p_effective_start_date out nocopy date
776 ,p_effective_end_date out nocopy date
777 ,p_no_managers_warning out nocopy boolean
778 ,p_other_manager_warning out nocopy boolean
779 );
780 --
781 --
782 end hr_de_assignment_api;
[Home] [Help]