1 PACKAGE hr_sa_assignment_api AUTHID CURRENT_USER AS
2 /* $Header: peasgsai.pkh 120.1 2005/10/02 02:11:28 aroussel $ */
3 /*#
4 * This package contains assignment APIs for Saudi Arabia.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Assignment for Saudi Arabia
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_sa_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a secondary employee assignment for Saudi Arabia.
17 *
18 * The API calls the generic API create_secondary_emp_asg, with parameters set
19 * as appropriate for the Saudi person. As this API is effectively an
20 * alternative to the API create_secondary_emp_asg, see that API for further
21 * explanation.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * See API create_secondary_emp_asg
28 *
29 * <p><b>Post Success</b><br>
30 * The API successfully creates the secondary employee assignment record in the
31 * database.
32 *
33 * <p><b>Post Failure</b><br>
34 * The API does not create the secondary employee assignment record and raises
35 * an error.
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_effective_date Determines when the DateTrack operation comes into
40 * force.
41 * @param p_person_id Identifies the person for whom you create the secondary
42 * assignment record
43 * @param p_organization_id Identifies the organization of the secondary
44 * assignment
45 * @param p_grade_id Identifies the grade of the secondary assignment
46 * @param p_position_id Identifies the position of the secondary assignment
47 * @param p_job_id Identifies the job of the secondary assignment
48 * @param p_assignment_status_type_id Identifies the assignment status of the
49 * secondary assignment.
50 * @param p_payroll_id Identifies the payroll for the secondary assignment
51 * @param p_location_id Identifies the location of the secondary assignment
52 * @param p_supervisor_id Identifies the supervisor for the secondary
53 * assignment. The value refers to the supervisor's person record.
54 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
55 * associated with the grade of the secondary assignment.
56 * @param p_pay_basis_id Salary basis for the secondary assignment
57 * @param p_assignment_number If a value is passed in, this is used as the
58 * assignment number. If no value is passed in an assignment number is
59 * generated.
60 * @param p_change_reason Reason for the assignment status change. If there is
61 * no change reason the parameter can be null. Valid values are defined in the
62 * EMP_ASSIGN_REASON lookup type.
63 * @param p_comments Comment text.
64 * @param p_date_probation_end End date of probation period
65 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
66 * Flexfield combination that applies to this assignment
67 * @param p_employment_category Employment category. Valid values are defined
68 * in the EMP_CAT lookup type.
69 * @param p_frequency Frequency associated with the defined normal working
70 * hours. Valid values are defined in the FREQUENCY lookup type.
71 * @param p_internal_address_line Internal address identified with the
72 * secondary assignment.
73 * @param p_manager_flag Indicates whether the employee is a manager
74 * @param p_normal_hours Normal working hours for this assignment
75 * @param p_perf_review_period Length of performance review period.
76 * @param p_perf_review_period_frequency Units of performance review period.
77 * Valid values are defined in the FREQUENCY lookup type.
78 * @param p_probation_period Length of probation period
79 * @param p_probation_unit Units of probation period. Valid values are defined
80 * in the QUALIFYING_UNITS lookup type.
81 * @param p_sal_review_period Length of salary review period
82 * @param p_sal_review_period_frequency Units of salary review period. Valid
83 * values are defined in the FREQUENCY lookup type.
84 * @param p_set_of_books_id Identifies General Ledger set of books.
85 * @param p_source_type Recruitment activity which this assignment is sourced
86 * from. Valid values are defined in the REC_TYPE lookup type.
87 * @param p_time_normal_finish Normal work finish time
88 * @param p_time_normal_start Normal work start time
89 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
90 * defined in the BARGAINING_UNIT_CODE lookup type.
91 * @param p_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
106 * @param p_ass_attribute10 Descriptive flexfield segment
107 * @param p_ass_attribute11 Descriptive flexfield segment
108 * @param p_ass_attribute12 Descriptive flexfield segment
109 * @param p_ass_attribute13 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_employer Saudi Employer. Valid value are all organizations
129 * classified as GRE / Legal Entity.
130 * @param p_gosi_num GOSI Number
131 * @param p_gosi_annuities Specifies whether GOSI Annuities should be deducted
132 * or not. Valid values are defined by the 'YES_NO' lookup type.
133 * @param p_annuities_branch_join_date Date of joining the GOSI Annuities
134 * branch.
135 * @param p_gosi_hazards Specifies whether GOSI Hazards should be deducted or
136 * not. Valid values are defined by the 'YES_NO' lookup type.
137 * @param p_hazards_branch_join_date Date of joining the GOSI Hazards branch.
138 * @param p_pgp_segment1 People group key flexfield segment
139 * @param p_pgp_segment2 People group key flexfield segment
140 * @param p_pgp_segment3 People group key flexfield segment
141 * @param p_pgp_segment4 People group key flexfield segment
142 * @param p_pgp_segment5 People group key flexfield segment
143 * @param p_pgp_segment6 People group key flexfield segment
144 * @param p_pgp_segment7 People group key flexfield segment
145 * @param p_pgp_segment8 People group key flexfield segment
146 * @param p_pgp_segment9 People group key flexfield segment
147 * @param p_pgp_segment10 People group key flexfield segment
148 * @param p_pgp_segment11 People group key flexfield segment
149 * @param p_pgp_segment12 People group key flexfield segment
150 * @param p_pgp_segment13 People group key flexfield segment
151 * @param p_pgp_segment14 People group key flexfield segment
152 * @param p_pgp_segment15 People group key flexfield segment
153 * @param p_pgp_segment16 People group key flexfield segment
154 * @param p_pgp_segment17 People group key flexfield segment
155 * @param p_pgp_segment18 People group key flexfield segment
156 * @param p_pgp_segment19 People group key flexfield segment
157 * @param p_pgp_segment20 People group key flexfield segment
158 * @param p_pgp_segment21 People group key flexfield segment
159 * @param p_pgp_segment22 People group key flexfield segment
160 * @param p_pgp_segment23 People group key flexfield segment
161 * @param p_pgp_segment24 People group key flexfield segment
162 * @param p_pgp_segment25 People group key flexfield segment
163 * @param p_pgp_segment26 People group key flexfield segment
164 * @param p_pgp_segment27 People group key flexfield segment
165 * @param p_pgp_segment28 People group key flexfield segment
166 * @param p_pgp_segment29 People group key flexfield segment
167 * @param p_pgp_segment30 People group key flexfield segment
168 * @param p_pgp_concat_segments Concatenated segments for People Group Key
169 * Flexfield. Concatenated segments can be supplied instead of individual
170 * segments.
171 * @param p_assignment_id If p_validate is false, then this uniquely identifies
172 * the created assignment. If p_validate is true, then set to null.
173 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
174 * it identifies an existing Soft Coded Key Flexfield combination to associate
175 * with the assignment, and segment values are ignored. If a value is not
176 * passed in, then the individual Soft Coded Key Flexfield segments supplied
177 * will be used to choose an existing combination or create a new combination.
178 * When the API completes, if p_validate is false, then this uniquely
179 * identifies the associated combination of the Soft Coded Key flexfield for
180 * this assignment. If p_validate is true, then set to null.
181 * @param p_people_group_id If a value is passed in for this parameter, it
182 * identifies an existing People Group Key Flexfield combination to associate
183 * with the assignment, and segment values are ignored. If a value is not
184 * passed in, then the individual People Group Key Flexfield segments supplied
185 * will be used to choose an existing combination or create a new combination.
186 * When the API completes, if p_validate is false, then this uniquely
187 * identifies the associated combination of the People Group Key flexfield for
188 * this assignment. If p_validate is true, then set to null.
189 * @param p_object_version_number If p_validate is false, then set to the
190 * version number of the created assignment. If p_validate is true, then the
191 * value will be null.
192 * @param p_effective_start_date If p_validate is false, then set to the
193 * earliest effective start date for the created assignment. If p_validate is
194 * true, then set to null.
195 * @param p_effective_end_date If p_validate is false, then set to the
196 * effective end date for the created assignment. If p_validate is true, then
197 * set to null.
198 * @param p_assignment_sequence If p_validate is false, then an automatically
199 * incremented number is associated with this assignment, depending on the
200 * number of assignment which already exist. If p_validate is true then set to
201 * null.
202 * @param p_comment_id If p_validate is false and comment text was provided,
203 * then will be set to the identifier of the created assignment comment record.
204 * If p_validate is true or no comment text was provided, then will be null.
205 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
206 * Flexfield concatenated segments, if p_validate is true, set to null.
207 * @param p_group_name If p_validate is false, set to the People Group Key
208 * Flexfield concatenated segments. If p_validate is true, set to null.
209 * @param p_other_manager_warning If set to true, then a manager existed in the
210 * organization prior to calling this API and the manager flag has been set to
211 * 'Y' for yes.
212 * @rep:displayname Create Secondary Employee Assignment for Saudi Arabia
213 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
214 * @rep:scope public
215 * @rep:lifecycle active
216 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
217 */
218 --
219 -- {End Of Comments}
220 --
221 PROCEDURE create_sa_secondary_emp_asg
222 (p_validate IN BOOLEAN DEFAULT FALSE
223 ,p_effective_date IN DATE
224 ,p_person_id IN NUMBER
225 ,p_organization_id IN NUMBER
226 ,p_grade_id IN NUMBER DEFAULT NULL
227 ,p_position_id IN NUMBER DEFAULT NULL
228 ,p_job_id IN NUMBER DEFAULT NULL
229 ,p_assignment_status_type_id IN NUMBER DEFAULT NULL
230 ,p_payroll_id IN NUMBER DEFAULT NULL
231 ,p_location_id IN NUMBER DEFAULT NULL
232 ,p_supervisor_id IN NUMBER DEFAULT NULL
233 ,p_special_ceiling_step_id IN NUMBER DEFAULT NULL
234 ,p_pay_basis_id IN NUMBER DEFAULT NULL
235 ,p_assignment_number IN OUT NOCOPY VARCHAR2
236 ,p_change_reason IN VARCHAR2 DEFAULT NULL
237 ,p_comments IN VARCHAR2 DEFAULT NULL
238 ,p_date_probation_end IN DATE DEFAULT NULL
239 ,p_default_code_comb_id IN NUMBER DEFAULT NULL
240 ,p_employment_category IN VARCHAR2 DEFAULT NULL
241 ,p_frequency IN VARCHAR2 DEFAULT NULL
242 ,p_internal_address_line IN VARCHAR2 DEFAULT NULL
243 ,p_manager_flag IN VARCHAR2 DEFAULT NULL
244 ,p_normal_hours IN NUMBER DEFAULT NULL
245 ,p_perf_review_period IN NUMBER DEFAULT NULL
246 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT NULL
247 ,p_probation_period IN NUMBER DEFAULT NULL
248 ,p_probation_unit IN VARCHAR2 DEFAULT NULL
249 ,p_sal_review_period IN NUMBER DEFAULT NULL
250 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT NULL
251 ,p_set_of_books_id IN NUMBER DEFAULT NULL
252 ,p_source_type IN VARCHAR2 DEFAULT NULL
253 ,p_time_normal_finish IN VARCHAR2 DEFAULT NULL
254 ,p_time_normal_start IN VARCHAR2 DEFAULT NULL
255 ,p_bargaining_unit_code in varchar2 default null
256 ,p_labour_union_member_flag in varchar2 default 'N'
257 ,p_hourly_salaried_code in varchar2 default null
258 ,p_ass_attribute_category IN VARCHAR2 DEFAULT NULL
259 ,p_ass_attribute1 IN VARCHAR2 DEFAULT NULL
260 ,p_ass_attribute2 IN VARCHAR2 DEFAULT NULL
261 ,p_ass_attribute3 IN VARCHAR2 DEFAULT NULL
262 ,p_ass_attribute4 IN VARCHAR2 DEFAULT NULL
263 ,p_ass_attribute5 IN VARCHAR2 DEFAULT NULL
264 ,p_ass_attribute6 IN VARCHAR2 DEFAULT NULL
265 ,p_ass_attribute7 IN VARCHAR2 DEFAULT NULL
266 ,p_ass_attribute8 IN VARCHAR2 DEFAULT NULL
267 ,p_ass_attribute9 IN VARCHAR2 DEFAULT NULL
268 ,p_ass_attribute10 IN VARCHAR2 DEFAULT NULL
269 ,p_ass_attribute11 IN VARCHAR2 DEFAULT NULL
270 ,p_ass_attribute12 IN VARCHAR2 DEFAULT NULL
271 ,p_ass_attribute13 IN VARCHAR2 DEFAULT NULL
272 ,p_ass_attribute14 IN VARCHAR2 DEFAULT NULL
273 ,p_ass_attribute15 IN VARCHAR2 DEFAULT NULL
274 ,p_ass_attribute16 IN VARCHAR2 DEFAULT NULL
275 ,p_ass_attribute17 IN VARCHAR2 DEFAULT NULL
276 ,p_ass_attribute18 IN VARCHAR2 DEFAULT NULL
277 ,p_ass_attribute19 IN VARCHAR2 DEFAULT NULL
278 ,p_ass_attribute20 IN VARCHAR2 DEFAULT NULL
279 ,p_ass_attribute21 IN VARCHAR2 DEFAULT NULL
280 ,p_ass_attribute22 IN VARCHAR2 DEFAULT NULL
281 ,p_ass_attribute23 IN VARCHAR2 DEFAULT NULL
282 ,p_ass_attribute24 IN VARCHAR2 DEFAULT NULL
283 ,p_ass_attribute25 IN VARCHAR2 DEFAULT NULL
284 ,p_ass_attribute26 IN VARCHAR2 DEFAULT NULL
285 ,p_ass_attribute27 IN VARCHAR2 DEFAULT NULL
286 ,p_ass_attribute28 IN VARCHAR2 DEFAULT NULL
287 ,p_ass_attribute29 IN VARCHAR2 DEFAULT NULL
288 ,p_ass_attribute30 IN VARCHAR2 DEFAULT NULL
289 ,p_title IN VARCHAR2 DEFAULT NULL
290 ,p_employer IN VARCHAR2 DEFAULT NULL
291 ,p_gosi_num IN VARCHAR2 DEFAULT NULL
292 ,p_gosi_annuities IN VARCHAR2 DEFAULT NULL
293 ,p_annuities_branch_join_date IN VARCHAR2 DEFAULT NULL
294 ,p_gosi_hazards IN VARCHAR2 DEFAULT NULL
295 ,p_hazards_branch_join_date IN VARCHAR2 DEFAULT NULL
296 ,p_pgp_segment1 IN VARCHAR2 DEFAULT NULL
297 ,p_pgp_segment2 IN VARCHAR2 DEFAULT NULL
298 ,p_pgp_segment3 IN VARCHAR2 DEFAULT NULL
299 ,p_pgp_segment4 IN VARCHAR2 DEFAULT NULL
300 ,p_pgp_segment5 IN VARCHAR2 DEFAULT NULL
301 ,p_pgp_segment6 IN VARCHAR2 DEFAULT NULL
302 ,p_pgp_segment7 IN VARCHAR2 DEFAULT NULL
303 ,p_pgp_segment8 IN VARCHAR2 DEFAULT NULL
304 ,p_pgp_segment9 IN VARCHAR2 DEFAULT NULL
305 ,p_pgp_segment10 IN VARCHAR2 DEFAULT NULL
306 ,p_pgp_segment11 IN VARCHAR2 DEFAULT NULL
307 ,p_pgp_segment12 IN VARCHAR2 DEFAULT NULL
308 ,p_pgp_segment13 IN VARCHAR2 DEFAULT NULL
309 ,p_pgp_segment14 IN VARCHAR2 DEFAULT NULL
310 ,p_pgp_segment15 IN VARCHAR2 DEFAULT NULL
311 ,p_pgp_segment16 IN VARCHAR2 DEFAULT NULL
312 ,p_pgp_segment17 IN VARCHAR2 DEFAULT NULL
313 ,p_pgp_segment18 IN VARCHAR2 DEFAULT NULL
314 ,p_pgp_segment19 IN VARCHAR2 DEFAULT NULL
315 ,p_pgp_segment20 IN VARCHAR2 DEFAULT NULL
316 ,p_pgp_segment21 IN VARCHAR2 DEFAULT NULL
317 ,p_pgp_segment22 IN VARCHAR2 DEFAULT NULL
318 ,p_pgp_segment23 IN VARCHAR2 DEFAULT NULL
319 ,p_pgp_segment24 IN VARCHAR2 DEFAULT NULL
320 ,p_pgp_segment25 IN VARCHAR2 DEFAULT NULL
321 ,p_pgp_segment26 IN VARCHAR2 DEFAULT NULL
322 ,p_pgp_segment27 IN VARCHAR2 DEFAULT NULL
323 ,p_pgp_segment28 IN VARCHAR2 DEFAULT NULL
324 ,p_pgp_segment29 IN VARCHAR2 DEFAULT NULL
325 ,p_pgp_segment30 IN VARCHAR2 DEFAULT NULL
326 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT NULL
327 ,p_assignment_id OUT NOCOPY NUMBER
328 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
329 ,p_people_group_id OUT NOCOPY NUMBER
330 ,p_object_version_number OUT NOCOPY NUMBER
331 ,p_effective_start_date OUT NOCOPY DATE
332 ,p_effective_end_date OUT NOCOPY DATE
333 ,p_assignment_sequence OUT NOCOPY NUMBER
334 ,p_comment_id OUT NOCOPY NUMBER
335 ,p_concatenated_segments OUT NOCOPY VARCHAR2
336 ,p_group_name OUT NOCOPY VARCHAR2
337 ,p_other_manager_warning OUT NOCOPY BOOLEAN
338 );
339 --
340 -- ----------------------------------------------------------------------------
341 -- |----------------------------< update_sa_emp_asg >-------------------------|
342 -- ----------------------------------------------------------------------------
343 --
344 -- {Start Of Comments}
345 /*#
346 * This API updates information for an existing employee assignment in a Saudi
347 * Arabia business group.
348 *
349 * The API calls the generic API update_emp_asg, with parameters set as
350 * appropriate for the Saudi employee assignment. As this API is effectively an
351 * alternative to the API update_emp_asg, see that API for further explanation.
352 *
353 * <p><b>Licensing</b><br>
354 * This API is licensed for use with Human Resources.
355 *
356 * <p><b>Prerequisites</b><br>
357 * See API update_emp_asg
358 *
359 * <p><b>Post Success</b><br>
360 * The employee assignment record is successfully updated in the database.
361 *
362 * <p><b>Post Failure</b><br>
363 * The API does not update the employee assignment record and raises an error.
364 * @param p_validate If true, then validation alone will be performed and the
365 * database will remain unchanged. If false and all validation checks pass,
366 * then the database will be modified.
367 * @param p_effective_date Determines when the DateTrack operation comes into
368 * force.
369 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
370 * updating the record. You must set to either UPDATE, CORRECTION,
371 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
372 * particular record depend on the dates of previous record changes and the
373 * effective date of this change.
374 * @param p_assignment_id Identifies the assignment record to be modified.
375 * @param p_object_version_number Pass in the current version number of the
376 * assignment to be updated. When the API completes if p_validate is false,
377 * will be set to the new version number of the updated assignment. If
378 * p_validate is true will be set to the same value which was passed in.
379 * @param p_supervisor_id Supervisor for the assignment. The value refers to
380 * the supervisor's person record.
381 * @param p_assignment_number Assignment number
382 * @param p_change_reason Reason for the assignment status change. If there is
383 * no change reason the parameter can be null. Valid values are defined in the
384 * EMP_ASSIGN_REASON lookup type.
385 * @param p_comments Comment text.
386 * @param p_date_probation_end End date of probation period
387 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
388 * Flexfield combination that applies to this assignment
389 * @param p_frequency Frequency associated with the defined normal working
390 * hours. Valid values are defined in the FREQUENCY lookup type.
391 * @param p_internal_address_line Internal address identified with this
392 * assignment.
393 * @param p_manager_flag Indicates whether the employee is a manager
394 * @param p_normal_hours Normal working hours for this assignment
395 * @param p_perf_review_period Length of performance review period
396 * @param p_perf_review_period_frequency Units of performance review period.
397 * Valid values are defined in the FREQUENCY lookup type.
398 * @param p_probation_period Length of probation period
399 * @param p_probation_unit Units of probation period. Valid values are defined
400 * in the QUALIFYING_UNITS lookup type.
401 * @param p_sal_review_period Length of salary review period
402 * @param p_sal_review_period_frequency Units of salary review period. Valid
403 * values are defined in the FREQUENCY lookup type.
404 * @param p_set_of_books_id Identifies General Ledger set of books.
405 * @param p_source_type Recruitment activity which this assignment is sourced
406 * from. Valid values are defined in the REC_TYPE lookup type.
407 * @param p_time_normal_finish Normal work finish time
408 * @param p_time_normal_start Normal work start time
409 * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
410 * defined in the BARGAINING_UNIT_CODE lookup type.
411 * @param p_labour_union_member_flag Value 'Y' indicates employee is a labour
412 * union member. Other values indicate not a member.
413 * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
414 * is salaried. Valid values defined in the HOURLY_SALARIED_CODE lookup type.
415 * @param p_ass_attribute_category This context value determines which
416 * Flexfield Structure to use with the Descriptive flexfield segments.
417 * @param p_ass_attribute1 Descriptive flexfield segment
418 * @param p_ass_attribute2 Descriptive flexfield segment
419 * @param p_ass_attribute3 Descriptive flexfield segment
420 * @param p_ass_attribute4 Descriptive flexfield segment
421 * @param p_ass_attribute5 Descriptive flexfield segment
422 * @param p_ass_attribute6 Descriptive flexfield segment
423 * @param p_ass_attribute7 Descriptive flexfield segment
424 * @param p_ass_attribute8 Descriptive flexfield segment
425 * @param p_ass_attribute9 Descriptive flexfield segment
426 * @param p_ass_attribute10 Descriptive flexfield segment
427 * @param p_ass_attribute11 Descriptive flexfield segment
428 * @param p_ass_attribute12 Descriptive flexfield segment
429 * @param p_ass_attribute13 Descriptive flexfield segment
430 * @param p_ass_attribute14 Descriptive flexfield segment
431 * @param p_ass_attribute15 Descriptive flexfield segment
432 * @param p_ass_attribute16 Descriptive flexfield segment
433 * @param p_ass_attribute17 Descriptive flexfield segment
434 * @param p_ass_attribute18 Descriptive flexfield segment
435 * @param p_ass_attribute19 Descriptive flexfield segment
436 * @param p_ass_attribute20 Descriptive flexfield segment
437 * @param p_ass_attribute21 Descriptive flexfield segment
438 * @param p_ass_attribute22 Descriptive flexfield segment
439 * @param p_ass_attribute23 Descriptive flexfield segment
440 * @param p_ass_attribute24 Descriptive flexfield segment
441 * @param p_ass_attribute25 Descriptive flexfield segment
442 * @param p_ass_attribute26 Descriptive flexfield segment
443 * @param p_ass_attribute27 Descriptive flexfield segment
444 * @param p_ass_attribute28 Descriptive flexfield segment
445 * @param p_ass_attribute29 Descriptive flexfield segment
446 * @param p_ass_attribute30 Descriptive flexfield segment
447 * @param p_title Obsolete parameter, do not use.
448 * @param p_employer Saudi Employer. Valid values are all organizations
449 * classified as GRE / Legal Entity.
450 * @param p_gosi_num GOSI Number
451 * @param p_gosi_annuities Specifies whether GOSI Annuities should be deducted
452 * or not. Valid values are defined by the 'YES_NO' lookup type.
453 * @param p_annuities_branch_join_date Date of joining the GOSI Annuities
454 * branch.
455 * @param p_gosi_hazards Specifies whether GOSI Hazards should be deducted or
456 * not. Valid values are defined by the 'YES_NO' lookup type.
457 * @param p_hazards_branch_join_date Date of joining the GOSI Hazards branch.
458 * @param p_comment_id If p_validate is false and comment text was provided,
459 * then will be set to the identifier of the created assignment comment record.
460 * If p_validate is true or no comment text was provided, then will be null.
461 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
462 * it identifies an existing Soft Coded Key Flexfield combination to associate
463 * with the assignment, and segment values are ignored. If a value is not
464 * passed in, then the individual Soft Coded Key Flexfield segments supplied
465 * will be used to choose an existing combination or create a new combination.
466 * When the API completes, if p_validate is false, then this uniquely
467 * identifies the associated combination of the Soft Coded Key flexfield for
468 * this assignment. If p_validate is true, then set to null.
469 * @param p_effective_start_date If p_validate is false, then set to the
470 * earliest effective start date for the created assignment. If p_validate is
471 * true, then set to null.
472 * @param p_effective_end_date If p_validate is false, then set to the
473 * effective end date for the created assignment. If p_validate is true, then
474 * set to null.
475 * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
476 * Flexfield concatenated segments, if p_validate is true, set to null.
477 * @param p_no_managers_warning Set to true if as a result of the update there
478 * is no manager in the organization. Otherwise set to false.
479 * @param p_other_manager_warning If set to true, then a manager existed in the
480 * organization prior to calling this API and the manager flag has been set to
481 * 'Y' for yes.
482 * @rep:displayname Update Employee Assignment for Saudi Arabia
483 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
484 * @rep:scope public
485 * @rep:lifecycle active
486 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
487 */
488 --
489 -- {End Of Comments}
490 --
491 PROCEDURE update_sa_emp_asg
492 (p_validate IN BOOLEAN DEFAULT FALSE
493 ,p_effective_date IN DATE
494 ,p_datetrack_update_mode IN VARCHAR2
495 ,p_assignment_id IN NUMBER
496 ,p_object_version_number IN OUT NOCOPY NUMBER
497 ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
498 ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
499 ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
500 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
501 ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
502 ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
503 ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
504 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
505 ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506 ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
507 ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
508 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
509 ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
510 ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
511 ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
512 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
513 ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
514 ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
515 ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
516 ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
517 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
518 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
519 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
520 ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521 ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522 ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523 ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524 ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525 ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526 ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527 ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528 ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529 ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530 ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531 ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532 ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533 ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534 ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535 ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536 ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537 ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538 ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539 ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540 ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541 ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542 ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543 ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544 ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545 ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546 ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547 ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548 ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549 ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550 ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
552 ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
553 ,p_gosi_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
554 ,p_gosi_annuities IN VARCHAR2 DEFAULT hr_api.g_varchar2
555 ,p_annuities_branch_join_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
556 ,p_gosi_hazards IN VARCHAR2 DEFAULT hr_api.g_varchar2
557 ,p_hazards_branch_join_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
558 ,p_comment_id OUT NOCOPY NUMBER
559 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
560 ,p_effective_start_date OUT NOCOPY DATE
561 ,p_effective_end_date OUT NOCOPY DATE
562 ,p_concatenated_segments OUT NOCOPY VARCHAR2
563 ,p_no_managers_warning OUT NOCOPY BOOLEAN
564 ,p_other_manager_warning OUT NOCOPY BOOLEAN
565 );
566 END hr_sa_assignment_api;
[Home] [Help]