1 PACKAGE hr_nl_assignment_api AUTHID CURRENT_USER AS
2 /* $Header: peasgnli.pkh 120.4 2006/01/20 01:50:59 summohan noship $ */
3 /*#
4 * This package contains assignment APIs for the Netherlands.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Assignment for Netherlands
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_nl_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates secondary employee assignments for the Netherlands.
17 *
18 * Create a secondary employee assignment for a person. The API calls the
19 * generic API create_secondary_emp_asg, with the parameters set as appropriate
20 * for a Dutch employee assignment. As this API is effectively an alternative
21 * to the API create_secondary_emp_asg, see that API for further 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 * See API create_secondary_emp_asg.
28 *
29 * <p><b>Post Success</b><br>
30 * When an employee assignment has been successfully created, the following out
31 * parameters are set.
32 *
33 * <p><b>Post Failure</b><br>
34 * The API does not create an employee 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_regular_working_hrs Regular Working Hours. These are the normal
74 * expected working hours.
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_labour_union_member_flag Value 'Y' indicates employee is a labour
92 * union member. Other values indicate not a member.
93 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
94 * is salaried. Valid values defined in the HOURLY_SALARIED_CODE lookup type.
95 * @param p_ass_attribute_category This context value determines which
96 * Flexfield Structure to use with the Descriptive flexfield segments.
97 * @param p_ass_attribute1 Descriptive flexfield segment
98 * @param p_ass_attribute2 Descriptive flexfield segment
99 * @param p_ass_attribute3 Descriptive flexfield segment
100 * @param p_ass_attribute4 Descriptive flexfield segment
101 * @param p_ass_attribute5 Descriptive flexfield segment
102 * @param p_ass_attribute6 Descriptive flexfield segment
103 * @param p_ass_attribute7 Descriptive flexfield segment
104 * @param p_ass_attribute8 Descriptive flexfield segment
105 * @param p_ass_attribute9 Descriptive flexfield segment
109 * @param p_ass_attribute13 Descriptive flexfield segment
106 * @param p_ass_attribute10 Descriptive flexfield segment
107 * @param p_ass_attribute11 Descriptive flexfield segment
108 * @param p_ass_attribute12 Descriptive flexfield segment
110 * @param p_ass_attribute14 Descriptive flexfield segment
111 * @param p_ass_attribute15 Descriptive flexfield segment
112 * @param p_ass_attribute16 Descriptive flexfield segment
113 * @param p_ass_attribute17 Descriptive flexfield segment
114 * @param p_ass_attribute18 Descriptive flexfield segment
115 * @param p_ass_attribute19 Descriptive flexfield segment
116 * @param p_ass_attribute20 Descriptive flexfield segment
117 * @param p_ass_attribute21 Descriptive flexfield segment
118 * @param p_ass_attribute22 Descriptive flexfield segment
119 * @param p_ass_attribute23 Descriptive flexfield segment
120 * @param p_ass_attribute24 Descriptive flexfield segment
121 * @param p_ass_attribute25 Descriptive flexfield segment
122 * @param p_ass_attribute26 Descriptive flexfield segment
123 * @param p_ass_attribute27 Descriptive flexfield segment
124 * @param p_ass_attribute28 Descriptive flexfield segment
125 * @param p_ass_attribute29 Descriptive flexfield segment
126 * @param p_ass_attribute30 Descriptive flexfield segment
127 * @param p_title Obsolete parameter, do not use.
128 * @param p_employment_type Employment Type. Valid values are defined by the
129 * lookup type 'NL_EMPLOYMENT_TYPE'.
130 * @param p_employment_subtype Employment Sub-type. Valid values are defined by
131 * the lookup types 'NL_FICT_EMPLOYMENT_SUBTYPES',
132 * 'NL_PREV_EMPLOYMENT_SUBTYPES' and 'NL_REAL_EMPLOYMENT_SUBTYPES'. The lookup
133 * type that applies, depends on the value selected for Employment Type.
134 * @param p_tax_reductions_apply General Tax Reduction Indicator. Valid values
135 * are defined by the lookup type 'HR_NL_YES_NO'.
136 * @param p_work_pattern Work Pattern. Valid values are defined by the lookup
137 * type 'HR_NL_SHI_WRK_PTN'.
138 * @param p_labour_tax_apply Labour Tax Reduction Indicator. Valid values are
139 * defined by the lookup type 'HR_NL_YES_NO'.
140 * @param p_income_code Income Code. Valid values are defined by the lookup
141 * type 'NL_INCOME_CODE'.
142 * @param p_addl_snr_tax_apply Additional Senior Tax Reduction Indicator. Valid
143 * values are defined by the lookup type 'HR_NL_YES_NO'.
144 * @param p_special_indicators Special Tax Indicators. This contains several
145 * indicators (two digit codes), where codes are concatenated together into one
146 * string. Valid indicator codes are defined by the lookup type
147 * 'NL_SPECIAL_INDICATORS'.
148 * @param p_tax_code Tax Code. This is a three digit code.
149 * @param p_last_year_salary Override for Previous Years' Salary.
150 * @param p_low_wages_apply Low Wages Indicator. Valid values are defined by
151 * the lookup type 'HR_NL_YES_NO'.
152 * @param p_education_apply Education Indicator. Valid values are defined by
153 * the lookup type 'HR_NL_YES_NO'.
154 * @param p_child_day_care_apply Obsolete parameter, do not use.
155 * @param p_long_term_unemployed Long Term Unemployed Indicator. Valid values
156 * are defined by the lookup type 'HR_NL_YES_NO'.
157 * @param p_foreigner_with_spl_knowledge Foreigner With Special Knowledge (30%
158 * Rule) Indicator. Valid values are defined by the lookup type 'HR_NL_YES_NO'.
159 * @param p_beneficial_rule_apply Beneficial Rule Indicator for special rate
160 * taxation. Valid values are defined by the lookup type 'HR_NL_YES_NO'.
161 * @param p_individual_percentage Individual Percentage for special rate
162 * taxation. This percentage value overrides any derived percentage rate.
163 * @param p_commencing_from Commencing Date for Individual Percentage.
164 * @param p_date_approved Approved Date for Individual Percentage.
165 * @param p_date_ending Ending Date for Individual Percentage.
166 * @param p_foreigner_tax_expiry Expiry Date for Foreigner With Special
167 * Knowledge (30% Rule) Indicator.
168 * @param p_job_level Job Level. Valid values are defined by the lookup type
169 * 'HR_NL_JOB_LEVEL'.
170 * @param p_max_days_method Maximum Days Method used in Social Insurance
171 * calculations. Valid values are defined by the lookup type
172 * 'NL_MAX_DAYS_METHOD'.
173 * @param p_override_real_si_days Override for Real Social Insurance Days.
174 * @param p_indiv_working_hrs Individual Working Hours. These are the hours
175 * worked by an employee, for the assignment, during a specific time period.
176 * @param p_part_time_percentage Part-time Percentage, based on Individual
177 * Working Hours as opposed to Regular Working Hours.
178 * @param p_scl_concat_segments Concatenated segments for Soft Coded Key
179 * Flexfield. Concatenated segments can be supplied instead of individual
180 * segments.
181 * @param p_pgp_segment1 People group key flexfield segment
182 * @param p_pgp_segment2 People group key flexfield segment
183 * @param p_pgp_segment3 People group key flexfield segment
184 * @param p_pgp_segment4 People group key flexfield segment
185 * @param p_pgp_segment5 People group key flexfield segment
186 * @param p_pgp_segment6 People group key flexfield segment
187 * @param p_pgp_segment7 People group key flexfield segment
188 * @param p_pgp_segment8 People group key flexfield segment
189 * @param p_pgp_segment9 People group key flexfield segment
190 * @param p_pgp_segment10 People group key flexfield segment
191 * @param p_pgp_segment11 People group key flexfield segment
192 * @param p_pgp_segment12 People group key flexfield segment
193 * @param p_pgp_segment13 People group key flexfield segment
194 * @param p_pgp_segment14 People group key flexfield segment
195 * @param p_pgp_segment15 People group key flexfield segment
196 * @param p_pgp_segment16 People group key flexfield segment
197 * @param p_pgp_segment17 People group key flexfield segment
198 * @param p_pgp_segment18 People group key flexfield segment
199 * @param p_pgp_segment19 People group key flexfield segment
200 * @param p_pgp_segment20 People group key flexfield segment
204 * @param p_pgp_segment24 People group key flexfield segment
201 * @param p_pgp_segment21 People group key flexfield segment
202 * @param p_pgp_segment22 People group key flexfield segment
203 * @param p_pgp_segment23 People group key flexfield segment
205 * @param p_pgp_segment25 People group key flexfield segment
206 * @param p_pgp_segment26 People group key flexfield segment
207 * @param p_pgp_segment27 People group key flexfield segment
208 * @param p_pgp_segment28 People group key flexfield segment
209 * @param p_pgp_segment29 People group key flexfield segment
210 * @param p_pgp_segment30 People group key flexfield segment
211 * @param p_pgp_concat_segments Concatenated segments for People Group Key
212 * Flexfield. Concatenated segments can be supplied instead of individual
213 * segments.
214 * @param p_contract_id Contract associated with this assignment
215 * @param p_establishment_id For French business groups, this identifies the
216 * Establishment Legal Entity for this assignment.
217 * @param p_collective_agreement_id Collective Agreement that applies to this
218 * assignment
219 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
220 * flexfield to use for this assignment
221 * @param p_cag_segment1 CAGR Key Flexfield segment
222 * @param p_cag_segment2 CAGR Key Flexfield segment
223 * @param p_cag_segment3 CAGR Key Flexfield segment
224 * @param p_cag_segment4 CAGR Key Flexfield segment
225 * @param p_cag_segment5 CAGR Key Flexfield segment
226 * @param p_cag_segment6 CAGR Key Flexfield segment
227 * @param p_cag_segment7 CAGR Key Flexfield segment
228 * @param p_cag_segment8 CAGR Key Flexfield segment
229 * @param p_cag_segment9 CAGR Key Flexfield segment
230 * @param p_cag_segment10 CAGR Key Flexfield segment
231 * @param p_cag_segment11 CAGR Key Flexfield segment
232 * @param p_cag_segment12 CAGR Key Flexfield segment
233 * @param p_cag_segment13 CAGR Key Flexfield segment
234 * @param p_cag_segment14 CAGR Key Flexfield segment
235 * @param p_cag_segment15 CAGR Key Flexfield segment
236 * @param p_cag_segment16 CAGR Key Flexfield segment
237 * @param p_cag_segment17 CAGR Key Flexfield segment
238 * @param p_cag_segment18 CAGR Key Flexfield segment
239 * @param p_cag_segment19 CAGR Key Flexfield segment
240 * @param p_cag_segment20 CAGR Key Flexfield segment
241 * @param p_notice_period Length of notice period
242 * @param p_notice_period_uom Units for notice period. Valid values are defined
243 * in the QUALIFYING_UNITS lookup type.
244 * @param p_employee_category Employee Category. Valid values are defined in
245 * the EMPLOYEE_CATG lookup type.
246 * @param p_work_at_home Indicate whether this assignment is to work at home.
247 * Valid values are defined in the YES_NO lookup type.
248 * @param p_job_post_source_name The source of the job posting that was
249 * answered for this assignment.
250 * @param p_grade_ladder_pgm_id Grade Ladder for this assignment
251 * @param p_supervisor_assignment_id Supervisor's assignment that is
252 * responsible for supervising this assignment.
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_concatenated_segments If p_validate is false, set to Soft Coded Key
256 * Flexfield concatenated segments, if p_validate is true, set to null.
257 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
258 * identifies an existing CAGR Key Flexfield combination to associate with the
259 * assignment, and segment values are ignored. If a value is not passed in,
260 * then the individual CAGR Key Flexfield segments supplied will be used to
261 * choose an existing combination or create a new combination. When the API
262 * completes, if p_validate is false, then this uniquely identifies the
263 * associated combination of the CAGR Key flexfield for this assignment. If
264 * p_validate is true, then set to null.
265 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated segments
266 * @param p_assignment_id If p_validate is false, then this uniquely identifies
267 * the created assignment. If p_validate is true, then set to null.
268 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
269 * it identifies an existing Soft Coded Key Flexfield combination to associate
270 * with the assignment, and segment values are ignored. If a value is not
271 * passed in, then the individual Soft Coded Key Flexfield segments supplied
272 * will be used to choose an existing combination or create a new combination.
273 * When the API completes, if p_validate is false, then this uniquely
274 * identifies the associated combination of the Soft Coded Key flexfield for
275 * this assignment. If p_validate is true, then set to null.
276 * @param p_people_group_id If a value is passed in for this parameter, it
277 * identifies an existing People Group Key Flexfield combination to associate
278 * with the assignment, and segment values are ignored. If a value is not
279 * passed in, then the individual People Group Key Flexfield segments supplied
280 * will be used to choose an existing combination or create a new combination.
281 * When the API completes, if p_validate is false, then this uniquely
282 * identifies the associated combination of the People Group Key flexfield for
283 * this assignment. If p_validate is true, then set to null.
284 * @param p_object_version_number If p_validate is false, then set to the
285 * version number of the created assignment. If p_validate is true, then the
286 * value will be null.
287 * @param p_effective_start_date If p_validate is false, then set to the
288 * earliest effective start date for the created assignment. If p_validate is
289 * true, then set to null.
290 * @param p_effective_end_date If p_validate is false, then set to the
291 * effective end date for the created assignment. If p_validate is true, then
292 * set to null.
293 * @param p_assignment_sequence If p_validate is false, then an automatically
294 * incremented number is associated with this assignment, depending on the
298 * then will be set to the identifier of the created assignment comment record.
295 * number of assignment which already exist. If p_validate is true then set to
296 * null.
297 * @param p_comment_id If p_validate is false and comment text was provided,
299 * If p_validate is true or no comment text was provided, then will be null.
300 * @param p_other_manager_warning If set to true, then a manager existed in the
301 * organization prior to calling this API and the manager flag has been set to
302 * 'Y' for yes.
303 * @param p_hourly_salaried_warning Set to true if values entered for Salary
304 * Basis and Hourly Salaried Code are invalid as of p_effective_date.
305 * @param p_gsp_post_process_warning Set to the name of a warning message from
306 * the Message Dictionary if any Grade Ladder related errors have been
307 * encountered while running this API.
308 * @param p_si_special_indicators SI Special Indicators. Valid values are
309 * defined in the NL_SI_SPECIAL_INDICATORS lookup type.
310 * @param p_incidental_worker Incidental Worker Flag. Valid values are defined
311 * in the HR_NL_YES_NO lookup type.
312 * @param p_paid_parental_leave_apply Paid Parental Leave. Valid values are
313 * defined in the HR_NL_YES_NO lookup type.
314 * @param p_deviating_working_hours Reasons for deviating working hours. Valid
315 * values are defined in the NL_DEVIATING_WORKING_HOURS lookup type.
316 * @param p_anonymous_employee Anonymous Employee. Valid values are defined in
317 * the HR_NL_YES_NO lookup type.
318 * @rep:displayname Create Secondary Employee Assignment for Netherlands
319 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
320 * @rep:scope public
321 * @rep:lifecycle active
322 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
323 */
324 --
325 -- {End Of Comments}
326 --
327 PROCEDURE create_nl_secondary_emp_asg
328 (p_validate IN BOOLEAN DEFAULT false
329 ,p_effective_date IN DATE
330 ,p_person_id IN NUMBER
331 ,p_organization_id IN NUMBER
332 ,p_grade_id IN NUMBER DEFAULT null
333 ,p_position_id IN NUMBER DEFAULT null
334 ,p_job_id IN NUMBER DEFAULT null
335 ,p_assignment_status_type_id IN NUMBER DEFAULT null
336 ,p_payroll_id IN NUMBER DEFAULT null
337 ,p_location_id IN NUMBER DEFAULT null
338 ,p_supervisor_id IN NUMBER DEFAULT null
339 ,p_special_ceiling_step_id IN NUMBER DEFAULT null
340 ,p_pay_basis_id IN NUMBER DEFAULT null
341 ,p_assignment_number IN OUT NOCOPY VARCHAR2
342 ,p_change_reason IN VARCHAR2 DEFAULT null
343 ,p_comments IN VARCHAR2 DEFAULT null
344 ,p_date_probation_end IN DATE DEFAULT null
345 ,p_default_code_comb_id IN NUMBER DEFAULT null
346 ,p_employment_category IN VARCHAR2 DEFAULT null
347 ,p_frequency IN VARCHAR2 DEFAULT null
348 ,p_internal_address_line IN VARCHAR2 DEFAULT null
349 ,p_manager_flag IN VARCHAR2 DEFAULT null
350 ,p_regular_working_hrs IN NUMBER DEFAULT null
351 ,p_perf_review_period IN NUMBER DEFAULT null
352 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT null
353 ,p_probation_period IN NUMBER DEFAULT null
354 ,p_probation_unit IN VARCHAR2 DEFAULT null
355 ,p_sal_review_period IN NUMBER DEFAULT null
356 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT null
357 ,p_set_of_books_id IN NUMBER DEFAULT null
358 ,p_source_type IN VARCHAR2 DEFAULT null
359 ,p_time_normal_finish IN VARCHAR2 DEFAULT null
360 ,p_time_normal_start IN VARCHAR2 DEFAULT null
361 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT null
362 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT null
363 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT null
364 ,p_ass_attribute_category IN VARCHAR2 DEFAULT null
365 ,p_ass_attribute1 IN VARCHAR2 DEFAULT null
366 ,p_ass_attribute2 IN VARCHAR2 DEFAULT null
367 ,p_ass_attribute3 IN VARCHAR2 DEFAULT null
368 ,p_ass_attribute4 IN VARCHAR2 DEFAULT null
369 ,p_ass_attribute5 IN VARCHAR2 DEFAULT null
370 ,p_ass_attribute6 IN VARCHAR2 DEFAULT null
371 ,p_ass_attribute7 IN VARCHAR2 DEFAULT null
372 ,p_ass_attribute8 IN VARCHAR2 DEFAULT null
373 ,p_ass_attribute9 IN VARCHAR2 DEFAULT null
374 ,p_ass_attribute10 IN VARCHAR2 DEFAULT null
375 ,p_ass_attribute11 IN VARCHAR2 DEFAULT null
376 ,p_ass_attribute12 IN VARCHAR2 DEFAULT null
377 ,p_ass_attribute13 IN VARCHAR2 DEFAULT null
378 ,p_ass_attribute14 IN VARCHAR2 DEFAULT null
379 ,p_ass_attribute15 IN VARCHAR2 DEFAULT null
380 ,p_ass_attribute16 IN VARCHAR2 DEFAULT null
381 ,p_ass_attribute17 IN VARCHAR2 DEFAULT null
382 ,p_ass_attribute18 IN VARCHAR2 DEFAULT null
383 ,p_ass_attribute19 IN VARCHAR2 DEFAULT null
384 ,p_ass_attribute20 IN VARCHAR2 DEFAULT null
385 ,p_ass_attribute21 IN VARCHAR2 DEFAULT null
386 ,p_ass_attribute22 IN VARCHAR2 DEFAULT null
387 ,p_ass_attribute23 IN VARCHAR2 DEFAULT null
388 ,p_ass_attribute24 IN VARCHAR2 DEFAULT null
389 ,p_ass_attribute25 IN VARCHAR2 DEFAULT null
390 ,p_ass_attribute26 IN VARCHAR2 DEFAULT null
394 ,p_ass_attribute30 IN VARCHAR2 DEFAULT null
391 ,p_ass_attribute27 IN VARCHAR2 DEFAULT null
392 ,p_ass_attribute28 IN VARCHAR2 DEFAULT null
393 ,p_ass_attribute29 IN VARCHAR2 DEFAULT null
395 ,p_title IN VARCHAR2 DEFAULT null
396 ,p_employment_type IN VARCHAR2 DEFAULT null
397 ,p_employment_subtype IN VARCHAR2 DEFAULT null
398 ,p_tax_reductions_apply IN VARCHAR2 DEFAULT null
399 ,p_paid_parental_leave_apply IN VARCHAR2 DEFAULT null
400 ,p_work_pattern IN VARCHAR2 DEFAULT null
401 ,p_labour_tax_apply IN VARCHAR2 DEFAULT null
402 ,p_income_code IN VARCHAR2 DEFAULT null
403 ,p_addl_snr_tax_apply IN VARCHAR2 DEFAULT null
404 ,p_special_indicators IN VARCHAR2 DEFAULT null
405 ,p_tax_code IN VARCHAR2 DEFAULT null
406 ,p_last_year_salary IN VARCHAR2 DEFAULT null
407 ,p_low_wages_apply IN VARCHAR2 DEFAULT null
408 ,p_education_apply IN VARCHAR2 DEFAULT null
409 ,p_child_day_care_apply IN VARCHAR2 DEFAULT null
410 ,p_anonymous_employee IN VARCHAR2 DEFAULT null
411 ,p_long_term_unemployed IN VARCHAR2 DEFAULT null
412 ,p_foreigner_with_spl_knowledge IN VARCHAR2 DEFAULT null
413 ,p_beneficial_rule_apply IN VARCHAR2 DEFAULT null
414 ,p_individual_percentage IN NUMBER DEFAULT null
415 ,p_commencing_from IN DATE DEFAULT null
416 ,p_date_approved IN DATE DEFAULT null
417 ,p_date_ending IN DATE DEFAULT null
418 ,p_foreigner_tax_expiry IN DATE DEFAULT null
419 ,p_job_level IN VARCHAR2 DEFAULT null
420 ,p_max_days_method IN VARCHAR2 DEFAULT null
421 ,p_override_real_si_days IN NUMBER DEFAULT null
422 ,p_indiv_working_hrs IN NUMBER DEFAULT null
423 ,p_part_time_percentage IN NUMBER DEFAULT null
424 ,p_si_special_indicators IN VARCHAR2 DEFAULT null
425 ,p_deviating_working_hours IN VARCHAR2 DEFAULT null
426 ,p_incidental_worker IN VARCHAR2 DEFAULT null
427 ,p_scl_concat_segments IN VARCHAR2 DEFAULT null
428 ,p_pgp_segment1 IN VARCHAR2 DEFAULT null
429 ,p_pgp_segment2 IN VARCHAR2 DEFAULT null
430 ,p_pgp_segment3 IN VARCHAR2 DEFAULT null
431 ,p_pgp_segment4 IN VARCHAR2 DEFAULT null
432 ,p_pgp_segment5 IN VARCHAR2 DEFAULT null
433 ,p_pgp_segment6 IN VARCHAR2 DEFAULT null
434 ,p_pgp_segment7 IN VARCHAR2 DEFAULT null
435 ,p_pgp_segment8 IN VARCHAR2 DEFAULT null
436 ,p_pgp_segment9 IN VARCHAR2 DEFAULT null
437 ,p_pgp_segment10 IN VARCHAR2 DEFAULT null
438 ,p_pgp_segment11 IN VARCHAR2 DEFAULT null
439 ,p_pgp_segment12 IN VARCHAR2 DEFAULT null
440 ,p_pgp_segment13 IN VARCHAR2 DEFAULT null
441 ,p_pgp_segment14 IN VARCHAR2 DEFAULT null
442 ,p_pgp_segment15 IN VARCHAR2 DEFAULT null
443 ,p_pgp_segment16 IN VARCHAR2 DEFAULT null
444 ,p_pgp_segment17 IN VARCHAR2 DEFAULT null
445 ,p_pgp_segment18 IN VARCHAR2 DEFAULT null
446 ,p_pgp_segment19 IN VARCHAR2 DEFAULT null
447 ,p_pgp_segment20 IN VARCHAR2 DEFAULT null
448 ,p_pgp_segment21 IN VARCHAR2 DEFAULT null
449 ,p_pgp_segment22 IN VARCHAR2 DEFAULT null
450 ,p_pgp_segment23 IN VARCHAR2 DEFAULT null
451 ,p_pgp_segment24 IN VARCHAR2 DEFAULT null
452 ,p_pgp_segment25 IN VARCHAR2 DEFAULT null
453 ,p_pgp_segment26 IN VARCHAR2 DEFAULT null
454 ,p_pgp_segment27 IN VARCHAR2 DEFAULT null
455 ,p_pgp_segment28 IN VARCHAR2 DEFAULT null
456 ,p_pgp_segment29 IN VARCHAR2 DEFAULT null
457 ,p_pgp_segment30 IN VARCHAR2 DEFAULT null
458 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT null
459 ,p_contract_id IN NUMBER DEFAULT null
460 ,p_establishment_id IN NUMBER DEFAULT null
461 ,p_collective_agreement_id IN NUMBER DEFAULT null
462 ,p_cagr_id_flex_num IN NUMBER DEFAULT null
463 ,p_cag_segment1 IN VARCHAR2 DEFAULT null
464 ,p_cag_segment2 IN VARCHAR2 DEFAULT null
465 ,p_cag_segment3 IN VARCHAR2 DEFAULT null
466 ,p_cag_segment4 IN VARCHAR2 DEFAULT null
467 ,p_cag_segment5 IN VARCHAR2 DEFAULT null
468 ,p_cag_segment6 IN VARCHAR2 DEFAULT null
469 ,p_cag_segment7 IN VARCHAR2 DEFAULT null
470 ,p_cag_segment8 IN VARCHAR2 DEFAULT null
471 ,p_cag_segment9 IN VARCHAR2 DEFAULT null
472 ,p_cag_segment10 IN VARCHAR2 DEFAULT null
473 ,p_cag_segment11 IN VARCHAR2 DEFAULT null
474 ,p_cag_segment12 IN VARCHAR2 DEFAULT null
475 ,p_cag_segment13 IN VARCHAR2 DEFAULT null
476 ,p_cag_segment14 IN VARCHAR2 DEFAULT null
477 ,p_cag_segment15 IN VARCHAR2 DEFAULT null
478 ,p_cag_segment16 IN VARCHAR2 DEFAULT null
479 ,p_cag_segment17 IN VARCHAR2 DEFAULT null
480 ,p_cag_segment18 IN VARCHAR2 DEFAULT null
484 ,p_notice_period_uom IN VARCHAR2 DEFAULT null
481 ,p_cag_segment19 IN VARCHAR2 DEFAULT null
482 ,p_cag_segment20 IN VARCHAR2 DEFAULT null
483 ,p_notice_period IN NUMBER DEFAULT null
485 ,p_employee_category IN VARCHAR2 DEFAULT null
486 ,p_work_at_home IN VARCHAR2 DEFAULT null
487 ,p_job_post_source_name IN VARCHAR2 DEFAULT null
488 ,p_grade_ladder_pgm_id in number
489 ,p_supervisor_assignment_id in number
490 ,p_group_name OUT NOCOPY VARCHAR2
491 ,p_concatenated_segments OUT NOCOPY VARCHAR2
492 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
493 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
494 ,p_assignment_id OUT NOCOPY NUMBER
495 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
496 ,p_people_group_id IN OUT NOCOPY NUMBER
497 ,p_object_version_number OUT NOCOPY NUMBER
498 ,p_effective_start_date OUT NOCOPY DATE
499 ,p_effective_end_date OUT NOCOPY DATE
500 ,p_assignment_sequence OUT NOCOPY NUMBER
501 ,p_comment_id OUT NOCOPY NUMBER
502 ,p_other_manager_warning OUT NOCOPY BOOLEAN
503 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
504 ,p_gsp_post_process_warning out nocopy varchar2) ;
505 --
506 -- ----------------------------------------------------------------------------
507 -- |----------------------------< update_nl_emp_asg >-------------------------|
508 -- ----------------------------------------------------------------------------
509 --
510 -- {Start Of Comments}
511 /*#
512 * This API updates employee assignments for the Netherlands.
513 *
514 * Update an employee assignment for a person. The API calls the generic API
515 * update_emp_asg, with the parameters set as appropriate for a Dutch employee
516 * assignment. As this API is effectively an alternative to the API
517 * update_emp_asg, see that API for further explanation.
518 *
519 * <p><b>Licensing</b><br>
520 * This API is licensed for use with Human Resources.
521 *
522 * <p><b>Prerequisites</b><br>
523 * See API update_emp_asg.
524 *
525 * <p><b>Post Success</b><br>
526 * When an employee assignment has been successfully updated, the following out
527 * parameters are set.
528 *
529 * <p><b>Post Failure</b><br>
530 * The API does not update an employee assignment and raises an error.
531 * @param p_validate If true, then validation alone will be performed and the
532 * database will remain unchanged. If false and all validation checks pass,
533 * then the database will be modified.
534 * @param p_effective_date Determines when the DateTrack operation comes into
535 * force.
536 * @param p_person_id Obsolete parameter, do not use.
537 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
538 * updating the record. You must set to either UPDATE, CORRECTION,
539 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
540 * particular record depend on the dates of previous record changes and the
541 * effective date of this change.
542 * @param p_assignment_id Identifies the assignment record to be modified.
543 * @param p_object_version_number Pass in the current version number of the
544 * assignment to be updated. When the API completes if p_validate is false,
545 * will be set to the new version number of the updated assignment. If
546 * p_validate is true will be set to the same value which was passed in.
547 * @param p_supervisor_id Supervisor for the assignment. The value refers to
548 * the supervisor's person record.
549 * @param p_assignment_number Assignment number
550 * @param p_change_reason Reason for the assignment status change. If there is
551 * no change reason the parameter can be null. Valid values are defined in the
552 * EMP_ASSIGN_REASON lookup type.
553 * @param p_assignment_status_type_id Assignment status. The system status must
554 * be the same as before the update, otherwise one of the status change APIs
555 * should be used.
556 * @param p_comments Comment text.
557 * @param p_date_probation_end End date of probation period
558 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
559 * Flexfield combination that applies to this assignment
560 * @param p_frequency Frequency associated with the defined normal working
561 * hours. Valid values are defined in the FREQUENCY lookup type.
562 * @param p_internal_address_line Internal address identified with this
563 * assignment.
564 * @param p_manager_flag Indicates whether the employee is a manager
565 * @param p_regular_working_hrs Regular Working Hours. These are the normal
566 * expected working hours.
567 * @param p_perf_review_period Length of performance review period
568 * @param p_perf_review_period_frequency Units of performance review period.
569 * Valid values are defined in the FREQUENCY lookup type.
570 * @param p_probation_period Length of probation period
571 * @param p_probation_unit Units of probation period. Valid values are defined
572 * in the QUALIFYING_UNITS lookup type.
573 * @param p_sal_review_period Length of salary review period
574 * @param p_sal_review_period_frequency Units of salary review period. Valid
575 * values are defined in the FREQUENCY lookup type.
576 * @param p_set_of_books_id Identifies General Ledger set of books.
577 * @param p_source_type Recruitment activity which this assignment is sourced
578 * from. Valid values are defined in the REC_TYPE lookup type.
579 * @param p_time_normal_finish Normal work finish time
580 * @param p_time_normal_start Normal work start time
581 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
582 * defined in the BARGAINING_UNIT_CODE lookup type.
583 * @param p_labour_union_member_flag Value 'Y' indicates employee is a labour
587 * @param p_ass_attribute_category This context value determines which
584 * union member. Other values indicate not a member.
585 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
586 * is salaried. Valid values defined in the HOURLY_SALARIED_CODE lookup type.
588 * Flexfield Structure to use with the Descriptive flexfield segments.
589 * @param p_ass_attribute1 Descriptive flexfield segment
590 * @param p_ass_attribute2 Descriptive flexfield segment
591 * @param p_ass_attribute3 Descriptive flexfield segment
592 * @param p_ass_attribute4 Descriptive flexfield segment
593 * @param p_ass_attribute5 Descriptive flexfield segment
594 * @param p_ass_attribute6 Descriptive flexfield segment
595 * @param p_ass_attribute7 Descriptive flexfield segment
596 * @param p_ass_attribute8 Descriptive flexfield segment
597 * @param p_ass_attribute9 Descriptive flexfield segment
598 * @param p_ass_attribute10 Descriptive flexfield segment
599 * @param p_ass_attribute11 Descriptive flexfield segment
600 * @param p_ass_attribute12 Descriptive flexfield segment
601 * @param p_ass_attribute13 Descriptive flexfield segment
602 * @param p_ass_attribute14 Descriptive flexfield segment
603 * @param p_ass_attribute15 Descriptive flexfield segment
604 * @param p_ass_attribute16 Descriptive flexfield segment
605 * @param p_ass_attribute17 Descriptive flexfield segment
606 * @param p_ass_attribute18 Descriptive flexfield segment
607 * @param p_ass_attribute19 Descriptive flexfield segment
608 * @param p_ass_attribute20 Descriptive flexfield segment
609 * @param p_ass_attribute21 Descriptive flexfield segment
610 * @param p_ass_attribute22 Descriptive flexfield segment
611 * @param p_ass_attribute23 Descriptive flexfield segment
612 * @param p_ass_attribute24 Descriptive flexfield segment
613 * @param p_ass_attribute25 Descriptive flexfield segment
614 * @param p_ass_attribute26 Descriptive flexfield segment
615 * @param p_ass_attribute27 Descriptive flexfield segment
616 * @param p_ass_attribute28 Descriptive flexfield segment
617 * @param p_ass_attribute29 Descriptive flexfield segment
618 * @param p_ass_attribute30 Descriptive flexfield segment
619 * @param p_title Obsolete parameter, do not use.
620 * @param p_employment_type Employment Type. Valid values are defined by the
621 * lookup type 'NL_EMPLOYMENT_TYPE'.
622 * @param p_employment_subtype Employment Sub-type. Valid values are defined by
623 * the lookup types 'NL_FICT_EMPLOYMENT_SUBTYPES',
624 * 'NL_PREV_EMPLOYMENT_SUBTYPES' and 'NL_REAL_EMPLOYMENT_SUBTYPES'. The lookup
625 * type that applies, depends on the value selected for Employment Type.
626 * @param p_tax_reductions_apply General Tax Reduction Indicator. Valid values
627 * are defined by the lookup type 'HR_NL_YES_NO'.
628 * @param p_work_pattern Work Pattern. Valid values are defined by the lookup
629 * type 'HR_NL_SHI_WRK_PTN'.
630 * @param p_labour_tax_apply Labour Tax Reduction Indicator. Valid values are
631 * defined by the lookup type 'HR_NL_YES_NO'.
632 * @param p_income_code Income Code. Valid values are defined by the lookup
633 * type 'NL_INCOME_CODE'.
634 * @param p_addl_snr_tax_apply Additional Senior Tax Reduction Indicator. Valid
635 * values are defined by the lookup type 'HR_NL_YES_NO'.
636 * @param p_special_indicators Special Tax Indicators. This contains several
637 * indicators (two digit codes), where codes are concatenated together in to
638 * one string. Valid indicator codes are defined by the lookup type
639 * 'NL_SPECIAL_INDICATORS'.
640 * @param p_tax_code Tax Code. This is a three digit code.
641 * @param p_last_year_salary Override for Previous Years' Salary.
642 * @param p_low_wages_apply Low Wages Indicator. Valid values are defined by
643 * the lookup type 'HR_NL_YES_NO'.
644 * @param p_education_apply Education Indicator. Valid values are defined by
645 * the lookup type 'HR_NL_YES_NO'.
646 * @param p_child_day_care_apply Obsolete parameter, do not use.
647 * @param p_long_term_unemployed Long Term Unemployed Indicator. Valid values
648 * are defined by the lookup type 'HR_NL_YES_NO'.
649 * @param p_foreigner_with_spl_knowledge Foreigner With Special Knowledge (30%
650 * Rule) Indicator. Valid values are defined by the lookup type 'HR_NL_YES_NO'.
651 * @param p_beneficial_rule_apply Beneficial Rule Indicator for special rate
652 * taxation. Valid values are defined by the lookup type 'HR_NL_YES_NO'.
653 * @param p_individual_percentage Individual Percentage for special rate
654 * taxation. This is a percentage value to override any derived percentage
655 * rate.
656 * @param p_commencing_from Commencing Date for Individual Percentage.
657 * @param p_date_approved Approved Date for Individual Percentage.
658 * @param p_date_ending Ending Date for Individual Percentage.
659 * @param p_foreigner_tax_expiry Expiry Date for Foreigner With Special
660 * Knowledge (30% Rule) Indicator.
661 * @param p_job_level Job Level. Valid values are defined by the lookup type
662 * 'HR_NL_JOB_LEVEL'.
663 * @param p_max_days_method Maximum Days Method used in Social Insurance
664 * calculations. Valid values are defined by the lookup type
665 * 'NL_MAX_DAYS_METHOD'.
666 * @param p_override_real_si_days Override for Real Social Insurance Days.
667 * @param p_indiv_working_hrs Individual Working Hours. These are the hours
668 * worked by an employee, for the assignment, during a specific time period.
669 * @param p_part_time_percentage Part-time Percentage, based on Individual
670 * Working Hours as opposed to Regular Working Hours.
671 * @param p_concat_segments Concatenated segments for Soft Coded Key Flexfield.
672 * Concatenated segments can be supplied instead of individual segments.
673 * @param p_contract_id Contract associated with this assignment
674 * @param p_establishment_id For French business groups, this identifies the
675 * Establishment Legal Entity for this assignment.
676 * @param p_collective_agreement_id Collective Agreement that applies to this
677 * assignment
678 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
682 * @param p_cag_segment3 CAGR Key Flexfield segment
679 * flexfield to use for this assignment
680 * @param p_cag_segment1 CAGR Key Flexfield segment
681 * @param p_cag_segment2 CAGR Key Flexfield segment
683 * @param p_cag_segment4 CAGR Key Flexfield segment
684 * @param p_cag_segment5 CAGR Key Flexfield segment
685 * @param p_cag_segment6 CAGR Key Flexfield segment
686 * @param p_cag_segment7 CAGR Key Flexfield segment
687 * @param p_cag_segment8 CAGR Key Flexfield segment
688 * @param p_cag_segment9 CAGR Key Flexfield segment
689 * @param p_cag_segment10 CAGR Key Flexfield segment
690 * @param p_cag_segment11 CAGR Key Flexfield segment
691 * @param p_cag_segment12 CAGR Key Flexfield segment
692 * @param p_cag_segment13 CAGR Key Flexfield segment
693 * @param p_cag_segment14 CAGR Key Flexfield segment
694 * @param p_cag_segment15 CAGR Key Flexfield segment
695 * @param p_cag_segment16 CAGR Key Flexfield segment
696 * @param p_cag_segment17 CAGR Key Flexfield segment
697 * @param p_cag_segment18 CAGR Key Flexfield segment
698 * @param p_cag_segment19 CAGR Key Flexfield segment
699 * @param p_cag_segment20 CAGR Key Flexfield segment
700 * @param p_notice_period Length of notice period
701 * @param p_notice_period_uom Units for notice period. Valid values are defined
702 * in the QUALIFYING_UNITS lookup type.
703 * @param p_employee_category Employee Category. Valid values are defined in
704 * the EMPLOYEE_CATG lookup type.
705 * @param p_work_at_home Indicate whether this assignment is to work at home.
706 * Valid values are defined in the YES_NO lookup type.
707 * @param p_job_post_source_name Name of the source of the job posting that was
708 * answered for this assignment.
709 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
710 * identifies an existing CAGR Key Flexfield combination to associate with the
711 * assignment, and segment values are ignored. If a value is not passed in,
712 * then the individual CAGR Key Flexfield segments supplied will be used to
713 * choose an existing combination or create a new combination. When the API
714 * completes, if p_validate is false, then this uniquely identifies the
715 * associated combination of the CAGR Key flexfield for this assignment. If
716 * p_validate is true, then set to null.
717 * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated segments
718 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
719 * Flexfield concatenated segments, if p_validate is true, set to null.
720 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
721 * it identifies an existing Soft Coded Key Flexfield combination to associate
722 * with the assignment, and segment values are ignored. If a value is not
723 * passed in, then the individual Soft Coded Key Flexfield segments supplied
724 * will be used to choose an existing combination or create a new combination.
725 * When the API completes, if p_validate is false, then this uniquely
726 * identifies the associated combination of the Soft Coded Key flexfield for
727 * this assignment. If p_validate is true, then set to null.
728 * @param p_comment_id If p_validate is false and comment text was provided,
729 * then will be set to the identifier of the created assignment comment record.
730 * If p_validate is true or no comment text was provided, then will be null.
731 * @param p_effective_start_date If p_validate is false, then set to the
732 * earliest effective start date for the created assignment. If p_validate is
733 * true, then set to null.
734 * @param p_effective_end_date If p_validate is false, then set to the
735 * effective end date for the created assignment. If p_validate is true, then
736 * set to null.
737 * @param p_no_managers_warning Set to true if as a result of the update there
738 * is no manager in the organization. Otherwise set to false.
739 * @param p_other_manager_warning If set to true, then a manager existed in the
740 * organization prior to calling this API and the manager flag has been set to
741 * 'Y' for yes.
742 * @param p_hourly_salaried_warning Set to true if values entered for Salary
743 * Basis and Hourly Salaried Code are invalid date as of p_effective_date.
744 * @param p_gsp_post_process_warning Set to the name of a warning message from
745 * the Message Dictionary if any Grade Ladder related errors have been
746 * encountered while running this API.
747 * @param p_paid_parental_leave_apply Paid Parental Leave. Valid values are
748 * defined in the HR_NL_YES_NO lookup type.
749 * @param p_si_special_indicators SI Special Indicators. Valid values are
750 * defined in the NL_SI_SPECIAL_INDICATORS lookup type.
751 * @param p_deviating_working_hours Reasons for deviating working hours. Valid
752 * values are defined in the NL_DEVIATING_WORKING_HOURS lookup type.
753 * @param p_incidental_worker Incidental Worker Flag. Valid values are defined
754 * in the HR_NL_YES_NO lookup type.
755 * @param p_anonymous_employee Anonymous Employee. Valid values are defined in
756 * the HR_NL_YES_NO lookup type.
757 * @rep:displayname Update Employee Assignment for Netherlands
758 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
759 * @rep:scope public
760 * @rep:lifecycle active
761 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
762 */
763 --
764 -- {End Of Comments}
765 --
766 PROCEDURE update_nl_emp_asg
767 (p_validate IN BOOLEAN default false
768 ,p_effective_date IN DATE
769 ,p_person_id IN NUMBER
770 ,p_datetrack_update_mode IN VARCHAR2
771 ,p_assignment_id IN NUMBER
772 ,p_object_version_number IN OUT NOCOPY NUMBER
773 ,p_supervisor_id IN NUMBER default hr_api.g_number
774 ,p_assignment_number IN VARCHAR2 default hr_api.g_varchar2
775 ,p_change_reason IN VARCHAR2 default hr_api.g_varchar2
776 ,p_assignment_status_type_id IN NUMBER default hr_api.g_number
780 ,p_frequency IN VARCHAR2 default hr_api.g_varchar2
777 ,p_comments IN VARCHAR2 default hr_api.g_varchar2
778 ,p_date_probation_end IN DATE default hr_api.g_date
779 ,p_default_code_comb_id IN NUMBER default hr_api.g_number
781 ,p_internal_address_line IN VARCHAR2 default hr_api.g_varchar2
782 ,p_manager_flag IN VARCHAR2 default hr_api.g_varchar2
783 ,p_regular_working_hrs IN NUMBER default hr_api.g_number
784 ,p_perf_review_period IN NUMBER default hr_api.g_number
785 ,p_perf_review_period_frequency IN VARCHAR2 default hr_api.g_varchar2
786 ,p_probation_period IN NUMBER default hr_api.g_number
787 ,p_probation_unit IN VARCHAR2 default hr_api.g_varchar2
788 ,p_sal_review_period IN NUMBER default hr_api.g_number
789 ,p_sal_review_period_frequency IN VARCHAR2 default hr_api.g_varchar2
790 ,p_set_of_books_id IN NUMBER default hr_api.g_number
791 ,p_source_type IN VARCHAR2 default hr_api.g_varchar2
792 ,p_time_normal_finish IN VARCHAR2 default hr_api.g_varchar2
793 ,p_time_normal_start IN VARCHAR2 default hr_api.g_varchar2
794 ,p_bargaining_unit_code IN VARCHAR2 default hr_api.g_varchar2
795 ,p_labour_union_member_flag IN VARCHAR2 default hr_api.g_varchar2
796 ,p_hourly_salaried_code IN VARCHAR2 default hr_api.g_varchar2
797 ,p_ass_attribute_category IN VARCHAR2 default hr_api.g_varchar2
798 ,p_ass_attribute1 IN VARCHAR2 default hr_api.g_varchar2
799 ,p_ass_attribute2 IN VARCHAR2 default hr_api.g_varchar2
800 ,p_ass_attribute3 IN VARCHAR2 default hr_api.g_varchar2
801 ,p_ass_attribute4 IN VARCHAR2 default hr_api.g_varchar2
802 ,p_ass_attribute5 IN VARCHAR2 default hr_api.g_varchar2
803 ,p_ass_attribute6 IN VARCHAR2 default hr_api.g_varchar2
804 ,p_ass_attribute7 IN VARCHAR2 default hr_api.g_varchar2
805 ,p_ass_attribute8 IN VARCHAR2 default hr_api.g_varchar2
806 ,p_ass_attribute9 IN VARCHAR2 default hr_api.g_varchar2
807 ,p_ass_attribute10 IN VARCHAR2 default hr_api.g_varchar2
808 ,p_ass_attribute11 IN VARCHAR2 default hr_api.g_varchar2
809 ,p_ass_attribute12 IN VARCHAR2 default hr_api.g_varchar2
810 ,p_ass_attribute13 IN VARCHAR2 default hr_api.g_varchar2
811 ,p_ass_attribute14 IN VARCHAR2 default hr_api.g_varchar2
812 ,p_ass_attribute15 IN VARCHAR2 default hr_api.g_varchar2
813 ,p_ass_attribute16 IN VARCHAR2 default hr_api.g_varchar2
814 ,p_ass_attribute17 IN VARCHAR2 default hr_api.g_varchar2
815 ,p_ass_attribute18 IN VARCHAR2 default hr_api.g_varchar2
816 ,p_ass_attribute19 IN VARCHAR2 default hr_api.g_varchar2
817 ,p_ass_attribute20 IN VARCHAR2 default hr_api.g_varchar2
818 ,p_ass_attribute21 IN VARCHAR2 default hr_api.g_varchar2
819 ,p_ass_attribute22 IN VARCHAR2 default hr_api.g_varchar2
820 ,p_ass_attribute23 IN VARCHAR2 default hr_api.g_varchar2
821 ,p_ass_attribute24 IN VARCHAR2 default hr_api.g_varchar2
822 ,p_ass_attribute25 IN VARCHAR2 default hr_api.g_varchar2
823 ,p_ass_attribute26 IN VARCHAR2 default hr_api.g_varchar2
824 ,p_ass_attribute27 IN VARCHAR2 default hr_api.g_varchar2
825 ,p_ass_attribute28 IN VARCHAR2 default hr_api.g_varchar2
826 ,p_ass_attribute29 IN VARCHAR2 default hr_api.g_varchar2
827 ,p_ass_attribute30 IN VARCHAR2 default hr_api.g_varchar2
828 ,p_title IN VARCHAR2 default hr_api.g_varchar2
829 ,p_employment_type IN VARCHAR2 default hr_api.g_varchar2
830 ,p_employment_subtype IN VARCHAR2 default hr_api.g_varchar2
831 ,p_tax_reductions_apply IN VARCHAR2 default hr_api.g_varchar2
832 ,p_paid_parental_leave_apply IN VARCHAR2 default hr_api.g_varchar2
833 ,p_work_pattern IN VARCHAR2 default hr_api.g_varchar2
834 ,p_labour_tax_apply IN VARCHAR2 default hr_api.g_varchar2
835 ,p_income_code IN VARCHAR2 default hr_api.g_varchar2
836 ,p_addl_snr_tax_apply IN VARCHAR2 default hr_api.g_varchar2
837 ,p_special_indicators IN VARCHAR2 default hr_api.g_varchar2
838 ,p_tax_code IN VARCHAR2 default hr_api.g_varchar2
839 ,p_last_year_salary IN VARCHAR2 default hr_api.g_varchar2
840 ,p_low_wages_apply IN VARCHAR2 default hr_api.g_varchar2
841 ,p_education_apply IN VARCHAR2 default hr_api.g_varchar2
842 ,p_child_day_care_apply IN VARCHAR2 default hr_api.g_varchar2
843 ,p_anonymous_employee IN VARCHAR2 default hr_api.g_varchar2
844 ,p_long_term_unemployed IN VARCHAR2 default hr_api.g_varchar2
845 ,p_foreigner_with_spl_knowledge IN VARCHAR2 default hr_api.g_varchar2
846 ,p_beneficial_rule_apply IN VARCHAR2 default hr_api.g_varchar2
847 ,p_individual_percentage IN NUMBER default hr_api.g_number
848 ,p_commencing_from IN DATE default hr_api.g_date
849 ,p_date_approved IN DATE default hr_api.g_date
850 ,p_date_ending IN DATE default hr_api.g_date
851 ,p_foreigner_tax_expiry IN DATE default hr_api.g_date
852 ,p_job_level IN VARCHAR2 default hr_api.g_varchar2
853 ,p_max_days_method IN VARCHAR2 default hr_api.g_varchar2
857 ,p_si_special_indicators IN VARCHAR2 default hr_api.g_varchar2
854 ,p_override_real_si_days IN NUMBER default hr_api.g_number
855 ,p_indiv_working_hrs IN NUMBER default hr_api.g_number
856 ,p_part_time_percentage IN NUMBER default hr_api.g_number
858 ,p_deviating_working_hours IN VARCHAR2 default hr_api.g_varchar2
859 ,p_incidental_worker IN VARCHAR2 default hr_api.g_varchar2
860 ,p_concat_segments IN VARCHAR2 default hr_api.g_varchar2
861 ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
862 ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
863 ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
864 ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
865 ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
866 ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867 ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868 ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869 ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870 ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871 ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872 ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873 ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874 ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875 ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876 ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877 ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
878 ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
879 ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880 ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881 ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882 ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883 ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884 ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885 ,p_notice_period IN NUMBER DEFAULT hr_api.g_number
886 ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
887 ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
888 ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
889 ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
890 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
891 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
892 ,p_concatenated_segments OUT NOCOPY VARCHAR2
893 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
894 ,p_comment_id OUT NOCOPY NUMBER
895 ,p_effective_start_date OUT NOCOPY DATE
896 ,p_effective_end_date OUT NOCOPY DATE
897 ,p_no_managers_warning OUT NOCOPY BOOLEAN
898 ,p_other_manager_warning OUT NOCOPY BOOLEAN
899 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
900 ,p_gsp_post_process_warning out nocopy varchar2
901 );
902
903 end hr_nl_assignment_api;
[Home] [Help]