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