1 package hr_sg_assignment_api as
2 /* $Header: hrsgwras.pkh 120.1 2005/10/02 02:06:08 aroussel $ */
3 /*#
4 * This package contains assignment related APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Assignment for Singapore
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_sg_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a secondary assignment for an existing Singapore employee.
17 *
18 * The API calls the generic API hr_assignment_api.create_secondary_emp_asg.
19 *
20 * <p><b>Licensing</b><br>
21 * This API is licensed for use with Human Resources.
22 *
23 * <p><b>Prerequisites</b><br>
24 * The employee and primary assignment must exist at the effective start date
25 * of the assignment creation.
26 *
27 * <p><b>Post Success</b><br>
28 * The API successfully creates the secondary employee assignment record in the
29 * database.
30 *
31 * <p><b>Post Failure</b><br>
32 * The API does not create the secondary assignment record and raises an error.
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Determines when the DateTrack operation takes
37 * effect.
38 * @param p_person_id Identifies the person for whom you create the secondary
39 * assignment record.
40 * @param p_organization_id {@rep:casecolumn
41 * PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID}
42 * @param p_grade_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.GRADE_ID}
43 * @param p_position_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.POSITION_ID}
44 * @param p_job_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.JOB_ID}
45 * @param p_assignment_status_type_id {@rep:casecolumn
46 * PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID}
47 * @param p_payroll_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.PAYROLL_ID}
48 * @param p_location_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.LOCATION_ID}
49 * @param p_supervisor_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID}
50 * @param p_special_ceiling_step_id {@rep:casecolumn
51 * PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID}
52 * @param p_pay_basis_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID}
53 * @param p_assignment_number If the number generation method is Manual then
54 * this parameter is mandatory. If the number generation method is Automatic
55 * then the value of this parameter must be NULL. When the API Completes, if
56 * p_validate is false and the assignment number generation method is Automatic
57 * this will be set to the generated assignment number of the person created.
58 * If p_validate is false and the assignment number generation method is manual
59 * or if p_validate is true this will be set to the value passed.
60 * @param p_change_reason Indicates the reason for the last change in the
61 * assignment. Valid values are defined by 'EMP_ASSIGN_REASON' lookup type.
62 * @param p_comments Comment text.
63 * @param p_date_probation_end {@rep:casecolumn
64 * PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END}
65 * @param p_default_code_comb_id {@rep:casecolumn
66 * PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID}
67 * @param p_employment_category User defined category. For example Full-Time
68 * Permanent or Part-Time Permanent. Known as Assignment Category. Valid values
69 * are defined by 'EMP_CAT' lookup type.
70 * @param p_frequency Determines the Frequency of normal working hours, - week,
71 * month, year. Valid values are defined by 'FREQUENCY' lookup type.
72 * @param p_internal_address_line {@rep:casecolumn
73 * PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE}
74 * @param p_manager_flag {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG}
75 * @param p_normal_hours {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS}
76 * @param p_perf_review_period {@rep:casecolumn
77 * PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD}
78 * @param p_perf_review_period_frequency The Frequency units is used with
79 * PERF_REVIEW_PERIOD to define time between reviews. Valid values are defined
80 * by 'FREQUENCY' lookup type.
81 * @param p_probation_period {@rep:casecolumn
82 * PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD}
83 * @param p_probation_unit Determines the Units of probation period duration.
84 * Valid values are defined by 'QUALIFYING_UNITS' lookup type.
85 * @param p_sal_review_period {@rep:casecolumn
86 * PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD}
87 * @param p_sal_review_period_frequency The Salary Review Frequence Units is
88 * used with Salary Review Period to define time between salary reviews. Valid
89 * values are defined by 'FREQUENCY' lookup type.
90 * @param p_set_of_books_id {@rep:casecolumn
91 * PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID}
92 * @param p_source_type Determines the Recruitment activity source for
93 * applicant assignment, for example, Advertisement. Valid values are defined
94 * by 'REC_TYPE' lookup type.
95 * @param p_time_normal_finish {@rep:casecolumn
96 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH}
97 * @param p_time_normal_start {@rep:casecolumn
98 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START}
99 * @param p_bargaining_unit_code Determines the Bargaining unit code. Valid
100 * values are defined by 'BARGAINING_UNIT_CODE' lookup type.
101 * @param p_labour_union_member_flag Indicates if the employee is an Assignment
102 * Labour union member. Valid values as applicable are defined by 'YES_NO'
103 * lookup type.
104 * @param p_hourly_salaried_code Identifies if the assignment is paid by the
105 * hour or by a salary. Valid values are defined by 'HOURLY_SALARIED_CODE'
106 * lookup type.
107 * @param p_ass_attribute_category This context value determines which
108 * Flexfield Structure to use with the Descriptive flexfield segments.
109 * @param p_ass_attribute1 Descriptive flexfield segment.
110 * @param p_ass_attribute2 Descriptive flexfield segment.
111 * @param p_ass_attribute3 Descriptive flexfield segment.
112 * @param p_ass_attribute4 Descriptive flexfield segment.
113 * @param p_ass_attribute5 Descriptive flexfield segment.
114 * @param p_ass_attribute6 Descriptive flexfield segment.
115 * @param p_ass_attribute7 Descriptive flexfield segment.
116 * @param p_ass_attribute8 Descriptive flexfield segment.
117 * @param p_ass_attribute9 Descriptive flexfield segment.
118 * @param p_ass_attribute10 Descriptive flexfield segment.
119 * @param p_ass_attribute11 Descriptive flexfield segment.
120 * @param p_ass_attribute12 Descriptive flexfield segment.
121 * @param p_ass_attribute13 Descriptive flexfield segment.
122 * @param p_ass_attribute14 Descriptive flexfield segment.
123 * @param p_ass_attribute15 Descriptive flexfield segment.
124 * @param p_ass_attribute16 Descriptive flexfield segment.
125 * @param p_ass_attribute17 Descriptive flexfield segment.
126 * @param p_ass_attribute18 Descriptive flexfield segment.
127 * @param p_ass_attribute19 Descriptive flexfield segment.
128 * @param p_ass_attribute20 Descriptive flexfield segment.
129 * @param p_ass_attribute21 Descriptive flexfield segment.
130 * @param p_ass_attribute22 Descriptive flexfield segment.
131 * @param p_ass_attribute23 Descriptive flexfield segment.
132 * @param p_ass_attribute24 Descriptive flexfield segment.
133 * @param p_ass_attribute25 Descriptive flexfield segment.
134 * @param p_ass_attribute26 Descriptive flexfield segment.
135 * @param p_ass_attribute27 Descriptive flexfield segment.
136 * @param p_ass_attribute28 Descriptive flexfield segment.
137 * @param p_ass_attribute29 Descriptive flexfield segment.
138 * @param p_ass_attribute30 Descriptive flexfield segment.
139 * @param p_title Title e.g. Mr, Mrs, Dr. Valid values are defined by 'TITLE'
140 * lookup type.
141 * @param p_legal_employer_id Indicates the Legal employer ID for the current
142 * assignment
143 * @param p_contract_id Indicates the Contract ID for the assignment
144 * @param p_establishment_id Indicates the Establishment ID of the assignment
145 * @param p_collective_agreement_id Indicates the Collective agreement ID of
146 * the assignment
147 * @param p_cagr_id_flex_num This context value determines which Flexfield
148 * Structure to use with the Descriptive flexfield segments.
149 * @param p_cag_segment1 Descriptive flexfield segment.
150 * @param p_cag_segment2 Descriptive flexfield segment.
151 * @param p_cag_segment3 Descriptive flexfield segment.
152 * @param p_cag_segment4 Descriptive flexfield segment.
153 * @param p_cag_segment5 Descriptive flexfield segment.
154 * @param p_cag_segment6 Descriptive flexfield segment.
155 * @param p_cag_segment7 Descriptive flexfield segment.
156 * @param p_cag_segment8 Descriptive flexfield segment.
157 * @param p_cag_segment9 Descriptive flexfield segment.
158 * @param p_cag_segment10 Descriptive flexfield segment.
159 * @param p_cag_segment11 Descriptive flexfield segment.
160 * @param p_cag_segment12 Descriptive flexfield segment.
161 * @param p_cag_segment13 Descriptive flexfield segment.
162 * @param p_cag_segment14 Descriptive flexfield segment.
163 * @param p_cag_segment15 Descriptive flexfield segment.
164 * @param p_cag_segment16 Descriptive flexfield segment.
165 * @param p_cag_segment17 Descriptive flexfield segment.
166 * @param p_cag_segment18 Descriptive flexfield segment.
167 * @param p_cag_segment19 Descriptive flexfield segment.
168 * @param p_cag_segment20 Descriptive flexfield segment.
169 * @param p_group_name if p_validate is false, returns the existing group name.
170 * If p_validate is true then returns the new group name.
171 * @param p_concatenated_segments If p_validate is false, returns the
172 * concatenation of all p_segment parameters. If p_validate is true or no
173 * p_segment parameters have been set, this will be null.
174 * @param p_cagr_grade_def_id Indicates the Category grate definition id for
175 * the current assignment
176 * @param p_cagr_concatenated_segments If p_validate is false, returns the
177 * concatenation of all p_cag_segment parameters. If p_validate is true or no
178 * p_cag_segment parameters have been set, this will be null.
179 * @param p_assignment_id If p_validate is false, then this uniquely identifies
180 * the created assignment. If p_validate is true, then set to null.
181 * @param p_soft_coding_keyflex_id If p_validate is false and the Soft coding
182 * key combination already exists, then retrun the current ID. If p_validate is
183 * true, the ID will be the assignments current value.
184 * @param p_people_group_id If p_validate is false, if the people group key
185 * combination already exists then the current people group id will be
186 * returned. If p_validate is true, the id will be the assignments current
187 * value.
188 * @param p_object_version_number If p_validate is false, then set to the
189 * version number of the created assignment. If p_validate is true, then the
190 * value will be null.
191 * @param p_effective_start_date If p_validate is false, then set to the
192 * earliest effective start date for the created assignment. If p_validate is
193 * true, then set to null.
194 * @param p_effective_end_date If p_validate is false, then set to the
195 * effective end date for the created assignment. If p_validate is true, then
196 * set to null.
197 * @param p_assignment_sequence If p_validate is false, then an automatically
198 * incremented number is associated with this assignment, depending on the
199 * number of assignment which already exist. If p_validate is true then set to
200 * null.
201 * @param p_comment_id If p_validate is false and comment text was provided,
202 * then will be set to the identifier of the created assignment comment record.
203 * If p_validate is true or no comment text was provided, then will be null.
204 * @param p_other_manager_warning If set to true, then a manager existed in the
205 * organization prior to calling this API and the manager flag has been set to
206 * 'Y' for yes.
207 * @rep:displayname Create Secondary Employee Assignment for Singapore
208 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
209 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
210 * @rep:scope public
211 * @rep:lifecycle active
212 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
213 */
214 --
215 -- {End Of Comments}
216 --
217 PROCEDURE create_sg_secondary_emp_asg
218 (p_validate in boolean default false
219 ,p_effective_date in date
220 ,p_person_id in number
221 ,p_organization_id in number
222 ,p_grade_id in number default null
223 ,p_position_id in number default null
224 ,p_job_id in number default null
225 ,p_assignment_status_type_id in number default null
226 ,p_payroll_id in number default null
227 ,p_location_id in number default null
228 ,p_supervisor_id in number default null
229 ,p_special_ceiling_step_id in number default null
230 ,p_pay_basis_id in number default null
231 ,p_assignment_number in out nocopy varchar2
232 ,p_change_reason in varchar2 default null
233 ,p_comments in varchar2 default null
234 ,p_date_probation_end in date default null
235 ,p_default_code_comb_id in number default null
236 ,p_employment_category in varchar2 default null
237 ,p_frequency in varchar2 default null
238 ,p_internal_address_line in varchar2 default null
239 ,p_manager_flag in varchar2 default null
240 ,p_normal_hours in number default null
241 ,p_perf_review_period in number default null
242 ,p_perf_review_period_frequency in varchar2 default null
243 ,p_probation_period in number default null
244 ,p_probation_unit in varchar2 default null
245 ,p_sal_review_period in number default null
246 ,p_sal_review_period_frequency in varchar2 default null
247 ,p_set_of_books_id in number default null
248 ,p_source_type in varchar2 default null
249 ,p_time_normal_finish in varchar2 default null
250 ,p_time_normal_start in varchar2 default null
251 ,p_bargaining_unit_code in varchar2 default null
252 ,p_labour_union_member_flag in varchar2 default null
253 ,p_hourly_salaried_code in varchar2 default null
254 ,p_ass_attribute_category in varchar2 default null
255 ,p_ass_attribute1 in varchar2 default null
256 ,p_ass_attribute2 in varchar2 default null
257 ,p_ass_attribute3 in varchar2 default null
258 ,p_ass_attribute4 in varchar2 default null
259 ,p_ass_attribute5 in varchar2 default null
260 ,p_ass_attribute6 in varchar2 default null
261 ,p_ass_attribute7 in varchar2 default null
262 ,p_ass_attribute8 in varchar2 default null
263 ,p_ass_attribute9 in varchar2 default null
264 ,p_ass_attribute10 in varchar2 default null
265 ,p_ass_attribute11 in varchar2 default null
266 ,p_ass_attribute12 in varchar2 default null
267 ,p_ass_attribute13 in varchar2 default null
268 ,p_ass_attribute14 in varchar2 default null
269 ,p_ass_attribute15 in varchar2 default null
270 ,p_ass_attribute16 in varchar2 default null
271 ,p_ass_attribute17 in varchar2 default null
272 ,p_ass_attribute18 in varchar2 default null
273 ,p_ass_attribute19 in varchar2 default null
274 ,p_ass_attribute20 in varchar2 default null
275 ,p_ass_attribute21 in varchar2 default null
276 ,p_ass_attribute22 in varchar2 default null
277 ,p_ass_attribute23 in varchar2 default null
278 ,p_ass_attribute24 in varchar2 default null
279 ,p_ass_attribute25 in varchar2 default null
280 ,p_ass_attribute26 in varchar2 default null
281 ,p_ass_attribute27 in varchar2 default null
282 ,p_ass_attribute28 in varchar2 default null
283 ,p_ass_attribute29 in varchar2 default null
284 ,p_ass_attribute30 in varchar2 default null
285 ,p_title in varchar2 default null
286 ,p_legal_employer_id in varchar2 default null
287 ,p_contract_id in number default null
288 ,p_establishment_id in number default null
289 ,p_collective_agreement_id in number default null
290 ,p_cagr_id_flex_num in number default null
291 ,p_cag_segment1 in varchar2 default null
292 ,p_cag_segment2 in varchar2 default null
293 ,p_cag_segment3 in varchar2 default null
294 ,p_cag_segment4 in varchar2 default null
295 ,p_cag_segment5 in varchar2 default null
296 ,p_cag_segment6 in varchar2 default null
297 ,p_cag_segment7 in varchar2 default null
298 ,p_cag_segment8 in varchar2 default null
299 ,p_cag_segment9 in varchar2 default null
300 ,p_cag_segment10 in varchar2 default null
301 ,p_cag_segment11 in varchar2 default null
302 ,p_cag_segment12 in varchar2 default null
303 ,p_cag_segment13 in varchar2 default null
304 ,p_cag_segment14 in varchar2 default null
305 ,p_cag_segment15 in varchar2 default null
306 ,p_cag_segment16 in varchar2 default null
307 ,p_cag_segment17 in varchar2 default null
308 ,p_cag_segment18 in varchar2 default null
309 ,p_cag_segment19 in varchar2 default null
310 ,p_cag_segment20 in varchar2 default null
311 ,p_group_name out nocopy varchar2
312 ,p_concatenated_segments out nocopy varchar2
313 ,p_cagr_grade_def_id out nocopy number
314 ,p_cagr_concatenated_segments out nocopy varchar2
315 ,p_assignment_id out nocopy number
316 ,p_soft_coding_keyflex_id out nocopy number
317 ,p_people_group_id out nocopy number
318 ,p_object_version_number out nocopy number
319 ,p_effective_start_date out nocopy date
320 ,p_effective_end_date out nocopy date
321 ,p_assignment_sequence out nocopy number
322 ,p_comment_id out nocopy number
323 ,p_other_manager_warning out nocopy boolean);
324 --
325 -- ----------------------------------------------------------------------------
326 -- |----------------------------< update_sg_emp_asg >-------------------------|
327 -- ----------------------------------------------------------------------------
328 --
329 -- {Start Of Comments}
330 /*#
334 * appropriate for Singapore.
331 * This API updates employee assignment details for Singapore.
332 *
333 * The API calls the generic API update_emp_asg, with parameters set as
335 *
336 * <p><b>Licensing</b><br>
337 * This API is licensed for use with Human Resources.
338 *
339 * <p><b>Prerequisites</b><br>
340 * The assignment (p_assignment_id) must exist as of the effective date of the
341 * update (p_effective_date).
342 *
343 * <p><b>Post Success</b><br>
344 * The employee assignment is successfully updated in the database.
345 *
346 * <p><b>Post Failure</b><br>
347 * The API does not update the assignment and raises an error.
348 * @param p_validate If true, then validation alone will be performed and the
349 * database will remain unchanged. If false and all validation checks pass,
350 * then the database will be modified.
351 * @param p_effective_date Determines when the DateTrack operation takes
352 * effect.
353 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
354 * updating the record. You must set to either UPDATE, CORRECTION,
355 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
356 * particular record depend on the dates of previous record changes and the
357 * effective date of this change.
358 * @param p_assignment_id Identifies the assignment for which you update
359 * Assignment record.
360 * @param p_object_version_number Pass in the current version number of the
361 * assignment to be updated. When the API completes if p_validate is false,
362 * will be set to the new version number of the updated assignment. If
363 * p_validate is true will be set to the same value which was passed in.
364 * @param p_supervisor_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID}
365 * @param p_assignment_number {@rep:casecolumn
366 * PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER}
367 * @param p_change_reason Indicates the reason for the last change in the
368 * assignment. Valid values are defined by 'EMP_ASSIGN_REASON' lookup type.
369 * @param p_comments Comment text.
370 * @param p_date_probation_end {@rep:casecolumn
371 * PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END}
372 * @param p_default_code_comb_id {@rep:casecolumn
373 * PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID}
374 * @param p_frequency Frequency of normal working hours, - week, month, year.
375 * Valid values are defined by 'FREQUENCY' lookup type.
376 * @param p_internal_address_line {@rep:casecolumn
377 * PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE}
378 * @param p_manager_flag {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG}
379 * @param p_normal_hours {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS}
380 * @param p_perf_review_period {@rep:casecolumn
381 * PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD}
382 * @param p_perf_review_period_frequency The Frequency units will be used along
383 * with PERF_REVIEW_PERIOD to define the time between reviews. Valid values are
384 * defined by 'FREQUENCY' lookup type.
385 * @param p_probation_period {@rep:casecolumn
386 * PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD}
387 * @param p_probation_unit Units of probation period duration. Valid values are
388 * defined by 'QUALIFYING_UNITS' lookup type.
389 * @param p_sal_review_period {@rep:casecolumn
390 * PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD}
391 * @param p_sal_review_period_frequency The Salary Review Frequence Units will
392 * be used with Salary Review Period to define time between salary reviews.
393 * Valid values are defined by 'FREQUENCY' lookup type.
394 * @param p_set_of_books_id {@rep:casecolumn
395 * PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID}
396 * @param p_source_type Recruitment activity source for applicant assignment,
397 * for example, Advertisement. Valid values are defined by 'REC_TYPE' lookup
398 * type.
399 * @param p_time_normal_finish {@rep:casecolumn
400 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH}
401 * @param p_time_normal_start {@rep:casecolumn
402 * PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START}
403 * @param p_bargaining_unit_code Bargaining unit code. Valid values are defined
404 * by 'BARGAINING_UNIT_CODE' lookup type.
405 * @param p_labour_union_member_flag Indicates if the employee is an Assignment
406 * Labour union member. Valid values as applicable are defined by 'YES_NO'
407 * lookup type.
408 * @param p_hourly_salaried_code Identifies if the assignment is paid by the
409 * hour or by a salary. Valid values are defined by 'HOURLY_SALARIED_CODE'
410 * lookup type.
411 * @param p_ass_attribute_category This context value determines which
412 * Flexfield Structure to use with the Descriptive flexfield segments.
413 * @param p_ass_attribute1 Descriptive flexfield segment.
414 * @param p_ass_attribute2 Descriptive flexfield segment.
415 * @param p_ass_attribute3 Descriptive flexfield segment.
416 * @param p_ass_attribute4 Descriptive flexfield segment.
417 * @param p_ass_attribute5 Descriptive flexfield segment.
418 * @param p_ass_attribute6 Descriptive flexfield segment.
419 * @param p_ass_attribute7 Descriptive flexfield segment.
420 * @param p_ass_attribute8 Descriptive flexfield segment.
421 * @param p_ass_attribute9 Descriptive flexfield segment.
422 * @param p_ass_attribute10 Descriptive flexfield segment.
423 * @param p_ass_attribute11 Descriptive flexfield segment.
424 * @param p_ass_attribute12 Descriptive flexfield segment.
425 * @param p_ass_attribute13 Descriptive flexfield segment.
426 * @param p_ass_attribute14 Descriptive flexfield segment.
427 * @param p_ass_attribute15 Descriptive flexfield segment.
428 * @param p_ass_attribute16 Descriptive flexfield segment.
429 * @param p_ass_attribute17 Descriptive flexfield segment.
430 * @param p_ass_attribute18 Descriptive flexfield segment.
431 * @param p_ass_attribute19 Descriptive flexfield segment.
432 * @param p_ass_attribute20 Descriptive flexfield segment.
433 * @param p_ass_attribute21 Descriptive flexfield segment.
434 * @param p_ass_attribute22 Descriptive flexfield segment.
438 * @param p_ass_attribute26 Descriptive flexfield segment.
435 * @param p_ass_attribute23 Descriptive flexfield segment.
436 * @param p_ass_attribute24 Descriptive flexfield segment.
437 * @param p_ass_attribute25 Descriptive flexfield segment.
439 * @param p_ass_attribute27 Descriptive flexfield segment.
440 * @param p_ass_attribute28 Descriptive flexfield segment.
441 * @param p_ass_attribute29 Descriptive flexfield segment.
442 * @param p_ass_attribute30 Descriptive flexfield segment.
443 * @param p_title Title e.g. Mr, Mrs, Dr. Valid values are defined by 'TITLE'
444 * lookup type.
445 * @param p_legal_employer_id Indicates the Legal employer ID for the current
446 * assignment
447 * @param p_cagr_grade_def_id Indicates the Category grate definition id for
448 * the current assignment
449 * @param p_cagr_concatenated_segments If p_validate is false, returns the
450 * concatenation of all p_cag_segment parameters. If p_validate is true or no
451 * p_cag_segment parameters have been set, this will be null.
452 * @param p_concatenated_segments If p_validate is false, returns the
453 * concatenation of all p_segment parameters. If p_validate is true or no
454 * p_segment parameters have been set, this will be null.
455 * @param p_soft_coding_keyflex_id If p_validate is false, returns the
456 * corresponding soft coding keyflex row. If p_validate is true or no p_segment
457 * parameters have been set text, this will be null.
458 * @param p_comment_id If p_validate is false and new or existing comment text
459 * exists, then will be set to the identifier of the assignment comment record.
460 * If p_validate is true or no comment text exists, then will be null.
461 * @param p_effective_start_date If p_validate is false, then set to the
462 * effective start date on the updated assignment row which now exists as of
463 * the effective date. If p_validate is true, then set to null.
464 * @param p_effective_end_date If p_validate is false, then set to the
465 * effective end date on the updated assignment row which now exists as of the
466 * effective date. If p_validate is true, then set to null.
467 * @param p_no_managers_warning If manager_flag has been updated from 'Y' to
468 * 'N' and no other manager exists in p_organization_id, then set to true. If
469 * another manager exists in p_organization_id, then set to false. If
470 * manager_flag is not updated, then always set the value to false.
471 * @param p_other_manager_warning If set to true, then a manager existed in the
472 * organization prior to calling this API and the manager flag has been set to
473 * 'Y' for yes.
474 * @rep:displayname Update Employee Assignment for Singapore
475 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
476 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
477 * @rep:scope public
478 * @rep:lifecycle active
479 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
480 */
481 --
482 -- {End Of Comments}
483 --
484 PROCEDURE update_sg_emp_asg
485 (p_validate in boolean default false
486 ,p_effective_date in date
487 ,p_datetrack_update_mode in varchar2
488 ,p_assignment_id in number
489 ,p_object_version_number in out nocopy number
490 ,p_supervisor_id in number default null
491 ,p_assignment_number in varchar2 default null
492 ,p_change_reason in varchar2 default null
493 ,p_comments in varchar2 default null
494 ,p_date_probation_end in date default null
495 ,p_default_code_comb_id in number default null
496 ,p_frequency in varchar2 default null
497 ,p_internal_address_line in varchar2 default null
498 ,p_manager_flag in varchar2 default null
499 ,p_normal_hours in number default null
500 ,p_perf_review_period in number default null
501 ,p_perf_review_period_frequency in varchar2 default null
502 ,p_probation_period in number default null
503 ,p_probation_unit in varchar2 default null
504 ,p_sal_review_period in number default null
505 ,p_sal_review_period_frequency in varchar2 default null
506 ,p_set_of_books_id in number default null
507 ,p_source_type in varchar2 default null
508 ,p_time_normal_finish in varchar2 default null
509 ,p_time_normal_start in varchar2 default null
510 ,p_bargaining_unit_code in varchar2 default null
511 ,p_labour_union_member_flag in varchar2 default null
512 ,p_hourly_salaried_code in varchar2 default null
513 ,p_ass_attribute_category in varchar2 default null
514 ,p_ass_attribute1 in varchar2 default null
515 ,p_ass_attribute2 in varchar2 default null
516 ,p_ass_attribute3 in varchar2 default null
517 ,p_ass_attribute4 in varchar2 default null
518 ,p_ass_attribute5 in varchar2 default null
519 ,p_ass_attribute6 in varchar2 default null
520 ,p_ass_attribute7 in varchar2 default null
521 ,p_ass_attribute8 in varchar2 default null
522 ,p_ass_attribute9 in varchar2 default null
523 ,p_ass_attribute10 in varchar2 default null
524 ,p_ass_attribute11 in varchar2 default null
525 ,p_ass_attribute12 in varchar2 default null
526 ,p_ass_attribute13 in varchar2 default null
527 ,p_ass_attribute14 in varchar2 default null
528 ,p_ass_attribute15 in varchar2 default null
529 ,p_ass_attribute16 in varchar2 default null
530 ,p_ass_attribute17 in varchar2 default null
531 ,p_ass_attribute18 in varchar2 default null
532 ,p_ass_attribute19 in varchar2 default null
536 ,p_ass_attribute23 in varchar2 default null
533 ,p_ass_attribute20 in varchar2 default null
534 ,p_ass_attribute21 in varchar2 default null
535 ,p_ass_attribute22 in varchar2 default null
537 ,p_ass_attribute24 in varchar2 default null
538 ,p_ass_attribute25 in varchar2 default null
539 ,p_ass_attribute26 in varchar2 default null
540 ,p_ass_attribute27 in varchar2 default null
541 ,p_ass_attribute28 in varchar2 default null
542 ,p_ass_attribute29 in varchar2 default null
543 ,p_ass_attribute30 in varchar2 default null
544 ,p_title in varchar2 default null
545 ,p_legal_employer_id in varchar2 default null
546 ,p_cagr_grade_def_id out nocopy varchar2
547 ,p_cagr_concatenated_segments out nocopy varchar2
548 ,p_concatenated_segments out nocopy varchar2
549 ,p_soft_coding_keyflex_id out nocopy number
550 ,p_comment_id out nocopy number
551 ,p_effective_start_date out nocopy date
552 ,p_effective_end_date out nocopy date
553 ,p_no_managers_warning out nocopy boolean
554 ,p_other_manager_warning out nocopy boolean);
555
556 END hr_sg_assignment_api;