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