DBA Data[Home] [Help]

PACKAGE: APPS.HR_PL_ASSIGNMENT_API

Source


1 PACKAGE hr_pl_assignment_api AS
2 /* $Header: peasgpli.pkh 120.5 2005/12/01 03:26:19 mseshadr noship $ */
3 /*#
4  * This package contains assignment APIs.
5  * @rep:scope public
6  * @rep:product PER
7  * @rep:displayname Assignment for Poland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_pl_secondary_emp_asg >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16  * This API(older version) creates secondary assignment for an employee.
17  *
18  * This API is an alternative to the API create_secondary_emp_asg. If
19  * p_validate is set to false, an assignment is created.
20  *
21  * <P> This version of the API is now out-of-date however it has been provided
22  * to you for backward compatibility support and will be removed in the future.
23  * Oracle recommends you to modify existing calling programs in advance of the
24  * support being withdrawn thus avoiding any potential disruption.
25  *
26  * <p><b>Licensing</b><br>
27  * This API is licensed for use with Human Resources.
28  *
29  * <p><b>Prerequisites</b><br>
30  * The employee must have been created already and must exist at the effective
31  * start date of the assignment.
32  *
33  * <p><b>Post Success</b><br>
34  * A new secondary assignment is created for the employee.
35  *
36  * <p><b>Post Failure</b><br>
37  * The API does not create the assignment and raises an error.
38  *
39  * @param p_validate If true, then validation alone will be performed and the
40  * database will remain unchanged. If false and all validation checks pass,
41  * then the database will be modified.
42  * @param p_effective_date Determines when the DateTrack operation comes into
43  * force.
44  * @param p_person_id Identifies the person for whom you create the secondary
45  * assignment record.
46  * @param p_organization_id Identifies the organization of the secondary
47  * assignment.
48  * @param p_grade_id Identifies the grade of the secondary assignment.
49  * @param p_position_id Identifies the position of the secondary assignment.
50  * @param p_job_id Identifies the job of the secondary assignment.
51  * @param p_assignment_status_type_id Identifies the assignment status of the
52  * secondary assignment. Valid values are defined by 'PER_ASS_SYS_STATUS'
53  * lookup type.
54  * @param p_payroll_id Identifies the payroll for the secondary assignment.
55  * @param p_location_id Identifies the location of the secondary assignment.
56  * @param p_supervisor_id Identifies the supervisor for the secondary
57  * assignment. The value refers to the supervisor's person record.
58  * @param p_special_ceiling_step_id Highest allowed step for the grade scale
59  * associated with the grade of the secondary assignment.
60  * @param p_pay_basis_id Salary basis for the secondary assignment.
61  * @param p_assignment_number If a value is passed in, this is used as the
62  * assignment number. If no value is passed in an assignment number is
63  * generated.
64  * @param p_change_reason Reason for the assignment status change. If there is
65  * no change reason the parameter can be null. Valid values are defined in the
66  * 'EMP_ASSIGN_REASON' lookup type.
67  * @param p_comments Comment text.
68  * @param p_date_probation_end End date of probation period.
69  * @param p_default_code_comb_id Identifier for the General Ledger Accounting
70  * Flexfield combination that applies to this assignment.
71  * @param p_employment_category Employment category of the assignment. Valid
72  * values are defined in the 'EMP_CAT' lookup type.
73  * @param p_frequency Frequency associated with the defined normal working
74  * hours. Valid values are defined in the 'FREQUENCY' lookup type.
75  * @param p_internal_address_line Internal address identified with the
76  * secondary assignment.
77  * @param p_manager_flag Indicates whether the employee is a manager.
78  * @param p_normal_hours Normal working hours for this assignment.
79  * @param p_perf_review_period Length of performance review period.
80  * @param p_perf_review_period_frequency Units of performance review period.
81  * Valid values are defined in the 'FREQUENCY' lookup type.
82  * @param p_probation_period Length of probation period.
83  * @param p_probation_unit Units of probation period. Valid values are defined
84  * in the 'QUALIFYING_UNITS' lookup type.
85  * @param p_sal_review_period Length of salary review period.
86  * @param p_sal_review_period_frequency Units of salary review period. Valid
87  * values are defined in the 'FREQUENCY' lookup type.
88  * @param p_set_of_books_id Identifies General Ledger set of books.
89  * @param p_source_type Recruitment activity which this assignment is sourced
90  * from. Valid values are defined in the 'REC_TYPE' lookup type.
91  * @param p_time_normal_finish Work end time.
92  * @param p_time_normal_start Work start time.
93  * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
94  * defined in the 'BARGAINING_UNIT_CODE' lookup type.
95  * @param p_labour_union_member_flag Indicates whether the employee is a labour
96  * union member.
97  * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
98  * is salaried. Valid values are defined in the 'HOURLY_SALARIED_CODE' lookup
99  * type.
100  * @param p_ass_attribute_category This context value determines which
101  * Flexfield Structure to use with the Descriptive flexfield segments.
102  * @param p_ass_attribute1 Descriptive flexfield segment.
103  * @param p_ass_attribute2 Descriptive flexfield segment.
104  * @param p_ass_attribute3 Descriptive flexfield segment.
105  * @param p_ass_attribute4 Descriptive flexfield segment.
106  * @param p_ass_attribute5 Descriptive flexfield segment.
107  * @param p_ass_attribute6 Descriptive flexfield segment.
108  * @param p_ass_attribute7 Descriptive flexfield segment.
109  * @param p_ass_attribute8 Descriptive flexfield segment.
110  * @param p_ass_attribute9 Descriptive flexfield segment.
111  * @param p_ass_attribute10 Descriptive flexfield segment.
112  * @param p_ass_attribute11 Descriptive flexfield segment.
113  * @param p_ass_attribute12 Descriptive flexfield segment.
114  * @param p_ass_attribute13 Descriptive flexfield segment.
115  * @param p_ass_attribute14 Descriptive flexfield segment.
116  * @param p_ass_attribute15 Descriptive flexfield segment.
117  * @param p_ass_attribute16 Descriptive flexfield segment.
118  * @param p_ass_attribute17 Descriptive flexfield segment.
119  * @param p_ass_attribute18 Descriptive flexfield segment.
120  * @param p_ass_attribute19 Descriptive flexfield segment.
121  * @param p_ass_attribute20 Descriptive flexfield segment.
122  * @param p_ass_attribute21 Descriptive flexfield segment.
123  * @param p_ass_attribute22 Descriptive flexfield segment.
124  * @param p_ass_attribute23 Descriptive flexfield segment.
125  * @param p_ass_attribute24 Descriptive flexfield segment.
126  * @param p_ass_attribute25 Descriptive flexfield segment.
127  * @param p_ass_attribute26 Descriptive flexfield segment.
128  * @param p_ass_attribute27 Descriptive flexfield segment.
129  * @param p_ass_attribute28 Descriptive flexfield segment.
130  * @param p_ass_attribute29 Descriptive flexfield segment.
131  * @param p_ass_attribute30 Descriptive flexfield segment.
132  * @param p_title Obsolete parameter, do not use.
133  * @param p_scl_segment1 Soft Coded key flexfield segment.
134  * @param p_legal_employer Legal Employer of the assignment.
135  * @param p_scl_segment3 Soft Coded key flexfield segment.
136  * @param p_scl_segment4 Soft Coded key flexfield segment.
137  * @param p_scl_segment5 Soft Coded key flexfield segment.
138  * @param p_scl_segment6 Soft Coded key flexfield segment.
139  * @param p_scl_segment7 Soft Coded key flexfield segment.
140  * @param p_scl_segment8 Soft Coded key flexfield segment.
141  * @param p_scl_segment9 Soft Coded key flexfield segment.
142  * @param p_scl_segment10 Soft Coded key flexfield segment.
143  * @param p_scl_segment11 Soft Coded key flexfield segment.
144  * @param p_scl_segment12 Soft Coded key flexfield segment.
145  * @param p_scl_segment13 Soft Coded key flexfield segment.
146  * @param p_scl_segment14 Soft Coded key flexfield segment.
147  * @param p_scl_segment15 Soft Coded key flexfield segment.
148  * @param p_scl_segment16 Soft Coded key flexfield segment.
149  * @param p_scl_segment17 Soft Coded key flexfield segment.
150  * @param p_scl_segment18 Soft Coded key flexfield segment.
151  * @param p_scl_segment19 Soft Coded key flexfield segment.
152  * @param p_scl_segment20 Soft Coded key flexfield segment.
153  * @param p_scl_segment21 Soft Coded key flexfield segment.
154  * @param p_scl_segment22 Soft Coded key flexfield segment.
155  * @param p_scl_segment23 Soft Coded key flexfield segment.
156  * @param p_scl_segment24 Soft Coded key flexfield segment.
157  * @param p_scl_segment25 Soft Coded key flexfield segment.
158  * @param p_scl_segment26 Soft Coded key flexfield segment.
159  * @param p_scl_segment27 Soft Coded key flexfield segment.
160  * @param p_scl_segment28 Soft Coded key flexfield segment.
161  * @param p_scl_segment29 Soft Coded key flexfield segment.
162  * @param p_scl_segment30 Soft Coded key flexfield segment.
163  * @param p_scl_concat_segments Concatenated segments for Soft Coded Key
164  * Flexfield. Concatenated segments can be supplied instead of individual
165  * segments.
166  * @param p_pgp_segment1 People group key flexfield segment.
167  * @param p_pgp_segment2 People group key flexfield segment.
168  * @param p_pgp_segment3 People group key flexfield segment.
169  * @param p_pgp_segment4 People group key flexfield segment.
170  * @param p_pgp_segment5 People group key flexfield segment.
171  * @param p_pgp_segment6 People group key flexfield segment.
172  * @param p_pgp_segment7 People group key flexfield segment.
173  * @param p_pgp_segment8 People group key flexfield segment.
174  * @param p_pgp_segment9 People group key flexfield segment.
175  * @param p_pgp_segment10 People group key flexfield segment.
176  * @param p_pgp_segment11 People group key flexfield segment.
177  * @param p_pgp_segment12 People group key flexfield segment.
178  * @param p_pgp_segment13 People group key flexfield segment.
179  * @param p_pgp_segment14 People group key flexfield segment.
180  * @param p_pgp_segment15 People group key flexfield segment.
181  * @param p_pgp_segment16 People group key flexfield segment.
182  * @param p_pgp_segment17 People group key flexfield segment.
183  * @param p_pgp_segment18 People group key flexfield segment.
184  * @param p_pgp_segment19 People group key flexfield segment.
185  * @param p_pgp_segment20 People group key flexfield segment.
186  * @param p_pgp_segment21 People group key flexfield segment.
187  * @param p_pgp_segment22 People group key flexfield segment.
188  * @param p_pgp_segment23 People group key flexfield segment.
189  * @param p_pgp_segment24 People group key flexfield segment.
190  * @param p_pgp_segment25 People group key flexfield segment.
191  * @param p_pgp_segment26 People group key flexfield segment.
192  * @param p_pgp_segment27 People group key flexfield segment.
193  * @param p_pgp_segment28 People group key flexfield segment.
194  * @param p_pgp_segment29 People group key flexfield segment.
195  * @param p_pgp_segment30 People group key flexfield segment.
196  * @param p_pgp_concat_segments Concatenated segments for People Group Key
197  * Flexfield. Concatenated segments can be supplied instead of individual
198  * segments.
199  * @param p_contract_id Contract associated with this assignment.
200  * @param p_establishment_id This identifies the establishment Legal Entity for
201  * this assignment.
202  * @param p_collective_agreement_id Collective Agreement that applies to this
203  * assignment.
204  * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
205  * flexfield to use for this assignment.
206  * @param p_cag_segment1 CAGR Key Flexfield segment.
207  * @param p_cag_segment2 CAGR Key Flexfield segment.
208  * @param p_cag_segment3 CAGR Key Flexfield segment.
209  * @param p_cag_segment4 CAGR Key Flexfield segment.
210  * @param p_cag_segment5 CAGR Key Flexfield segment.
211  * @param p_cag_segment6 CAGR Key Flexfield segment.
212  * @param p_cag_segment7 CAGR Key Flexfield segment.
213  * @param p_cag_segment8 CAGR Key Flexfield segment.
214  * @param p_cag_segment9 CAGR Key Flexfield segment.
215  * @param p_cag_segment10 CAGR Key Flexfield segment.
216  * @param p_cag_segment11 CAGR Key Flexfield segment.
217  * @param p_cag_segment12 CAGR Key Flexfield segment.
218  * @param p_cag_segment13 CAGR Key Flexfield segment.
219  * @param p_cag_segment14 CAGR Key Flexfield segment.
220  * @param p_cag_segment15 CAGR Key Flexfield segment.
221  * @param p_cag_segment16 CAGR Key Flexfield segment.
222  * @param p_cag_segment17 CAGR Key Flexfield segment.
223  * @param p_cag_segment18 CAGR Key Flexfield segment.
224  * @param p_cag_segment19 CAGR Key Flexfield segment.
225  * @param p_cag_segment20 CAGR Key Flexfield segment.
226  * @param p_notice_period Length of notice period.
227  * @param p_notice_period_uom Units for notice period. Valid values are defined
228  * in the 'QUALIFYING_UNITS' lookup type.
229  * @param p_employee_category Employee Category of the assignment. Valid values
230  * are defined in the 'EMPLOYEE_CATG' lookup type.
231  * @param p_work_at_home Indicates working from home. Valid values are defined
232  * in the 'YES_NO' lookup type.
233  * @param p_job_post_source_name The source of the job posting that was
234  * answered for this assignment.
235  * @param p_grade_ladder_pgm_id Grade Ladder for this assignment.
236  * @param p_supervisor_assignment_id Supervisor's assignment identification
237  * that is responsible for supervising this assignment.
238  * @param p_group_name If p_validate is false, set to the People Group Key
239  * Flexfield concatenated segments. If p_validate is true, set to null.
240  * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
241  * Flexfield concatenated segments, if p_validate is true, set to null.
242  * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
243  * identifies an existing CAGR Key Flexfield combination to associate with the
244  * assignment, and the segment values are ignored. If a value is not passed in,
245  * then the individual CAGR Key Flexfield segments supplied will be used to
246  * choose an existing combination or create a new combination. When the API
247  * completes, if p_validate is false, then this uniquely identifies the
248  * associated combination of the CAGR Key flexfield for this assignment. If
249  * p_validate is true, then set to null.
250  * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
251  * segments.
252  * @param p_assignment_id If p_validate is false, then this uniquely identifies
253  * the created assignment. If p_validate is true, then set to null.
254  * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
255  * it identifies an existing Soft Coded Key Flexfield combination to associate
256  * with the assignment, and segment values are ignored. If a value is not
257  * passed in, then the individual Soft Coded Key Flexfield segments supplied
258  * will be used to choose an existing combination or create a new combination.
259  * When the API completes, if p_validate is false, then this uniquely
260  * identifies the associated combination of the Soft Coded Key flexfield for
261  * this assignment. If p_validate is true, then set to null.
262  * @param p_people_group_id If a value is passed in for this parameter, it
263  * identifies an existing People Group Key Flexfield combination to associate
264  * with the assignment, and segment values are ignored. If a value is not
265  * passed in, then the individual People Group Key Flexfield segments supplied
266  * will be used to choose an existing combination or create a new combination.
267  * When the API completes, if p_validate is false, then this uniquely
268  * identifies the associated combination of the People Group Key flexfield for
269  * this assignment. If p_validate is true, then set to null.
270  * @param p_object_version_number If p_validate is false, then set to the
271  * version number of the created assignment. If p_validate is true, then the
272  * value will be null.
273  * @param p_effective_start_date If p_validate is false, then set to the
274  * earliest effective start date for the created assignment. If p_validate is
275  * true, then set to null.
276  * @param p_effective_end_date If p_validate is false, then set to the
277  * effective end date for the created assignment. If p_validate is true, then
278  * set to null.
279  * @param p_assignment_sequence If p_validate is false, then an automatically
280  * incremented number is associated with this assignment, depending on the
284  * then will be set to the identifier of the created assignment comment record.
281  * number of assignment which already exist. If p_validate is true then set to
282  * null.
283  * @param p_comment_id If p_validate is false and comment text was provided,
285  * If p_validate is true or no comment text was provided, then will be null.
286  * @param p_other_manager_warning If set to true, then a manager existed in the
287  * organization prior to calling this API and the manager flag has been set to
288  * 'Y' for yes.
289  * @param p_hourly_salaried_warning Set to true if values entered for Salary
290  * Basis and Hourly Salaried Code are invalid as of p_effective_date.
291  * @param p_gsp_post_process_warning Set to the name of a warning message from
292  * the Message Dictionary if any Grade Ladder related errors have been
293  * encountered while running this API.
294  * @rep:displayname Create Secondary Employee Assignment for Poland
295  * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
296  * @rep:lifecycle deprecated
297  * @rep:scope public
298  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
299 */
300 --
301 -- {End Of Comments}
302 --
303 Procedure create_pl_secondary_emp_asg
304   (p_validate                     in     boolean  default false
305   ,p_effective_date               in     date
306   ,p_person_id                    in     number
307   ,p_organization_id              in     number
308   ,p_grade_id                     in     number   default null
309   ,p_position_id                  in     number   default null
310   ,p_job_id                       in     number   default null
311   ,p_assignment_status_type_id    in     number   default null
312   ,p_payroll_id                   in     number   default null
313   ,p_location_id                  in     number   default null
314   ,p_supervisor_id                in     number   default null
315   ,p_special_ceiling_step_id      in     number   default null
316   ,p_pay_basis_id                 in     number   default null
317   ,p_assignment_number            in out nocopy varchar2
318   ,p_change_reason                in     varchar2 default null
319   ,p_comments                     in     varchar2 default null
320   ,p_date_probation_end           in     date     default null
321   ,p_default_code_comb_id         in     number   default null
322   ,p_employment_category          in     varchar2 default null
323   ,p_frequency                    in     varchar2 default null
324   ,p_internal_address_line        in     varchar2 default null
325   ,p_manager_flag                 in     varchar2 default null
326   ,p_normal_hours                 in     number   default null
327   ,p_perf_review_period           in     number   default null
328   ,p_perf_review_period_frequency in     varchar2 default null
329   ,p_probation_period             in     number   default null
330   ,p_probation_unit               in     varchar2 default null
331   ,p_sal_review_period            in     number   default null
332   ,p_sal_review_period_frequency  in     varchar2 default null
333   ,p_set_of_books_id              in     number   default null
334   ,p_source_type                  in     varchar2 default null
335   ,p_time_normal_finish           in     varchar2 default null
336   ,p_time_normal_start            in     varchar2 default null
337   ,p_bargaining_unit_code         in     varchar2 default null
338   ,p_labour_union_member_flag     in     varchar2 default 'N'
339   ,p_hourly_salaried_code         in     varchar2 default null
340   ,p_ass_attribute_category       in     varchar2 default null
341   ,p_ass_attribute1               in     varchar2 default null
342   ,p_ass_attribute2               in     varchar2 default null
343   ,p_ass_attribute3               in     varchar2 default null
344   ,p_ass_attribute4               in     varchar2 default null
345   ,p_ass_attribute5               in     varchar2 default null
346   ,p_ass_attribute6               in     varchar2 default null
347   ,p_ass_attribute7               in     varchar2 default null
348   ,p_ass_attribute8               in     varchar2 default null
349   ,p_ass_attribute9               in     varchar2 default null
350   ,p_ass_attribute10              in     varchar2 default null
351   ,p_ass_attribute11              in     varchar2 default null
352   ,p_ass_attribute12              in     varchar2 default null
353   ,p_ass_attribute13              in     varchar2 default null
354   ,p_ass_attribute14              in     varchar2 default null
355   ,p_ass_attribute15              in     varchar2 default null
356   ,p_ass_attribute16              in     varchar2 default null
357   ,p_ass_attribute17              in     varchar2 default null
358   ,p_ass_attribute18              in     varchar2 default null
359   ,p_ass_attribute19              in     varchar2 default null
360   ,p_ass_attribute20              in     varchar2 default null
361   ,p_ass_attribute21              in     varchar2 default null
362   ,p_ass_attribute22              in     varchar2 default null
363   ,p_ass_attribute23              in     varchar2 default null
364   ,p_ass_attribute24              in     varchar2 default null
365   ,p_ass_attribute25              in     varchar2 default null
366   ,p_ass_attribute26              in     varchar2 default null
367   ,p_ass_attribute27              in     varchar2 default null
368   ,p_ass_attribute28              in     varchar2 default null
369   ,p_ass_attribute29              in     varchar2 default null
370   ,p_ass_attribute30              in     varchar2 default null
371   ,p_title                        in     varchar2 default null
372   ,p_scl_segment1		          in     varchar2 default null
373   ,p_legal_employer               in     varchar2 default null
374   ,p_scl_segment3                 in     varchar2 default null
375   ,p_scl_segment4                 in     varchar2 default null
379   ,p_scl_segment8                 in     varchar2 default null
376   ,p_scl_segment5                 in     varchar2 default null
377   ,p_scl_segment6                 in     varchar2 default null
378   ,p_scl_segment7                 in     varchar2 default null
380   ,p_scl_segment9                 in     varchar2 default null
381   ,p_scl_segment10                in     varchar2 default null
382   ,p_scl_segment11                in     varchar2 default null
383   ,p_scl_segment12                in     varchar2 default null
384   ,p_scl_segment13                in     varchar2 default null
385   ,p_scl_segment14                in     varchar2 default null
386   ,p_scl_segment15                in     varchar2 default null
387   ,p_scl_segment16                in     varchar2 default null
388   ,p_scl_segment17                in     varchar2 default null
389   ,p_scl_segment18                in     varchar2 default null
390   ,p_scl_segment19                in     varchar2 default null
391   ,p_scl_segment20                in     varchar2 default null
392   ,p_scl_segment21                in     varchar2 default null
393   ,p_scl_segment22                in     varchar2 default null
394   ,p_scl_segment23                in     varchar2 default null
395   ,p_scl_segment24                in     varchar2 default null
396   ,p_scl_segment25                in     varchar2 default null
397   ,p_scl_segment26                in     varchar2 default null
398   ,p_scl_segment27                in     varchar2 default null
399   ,p_scl_segment28                in     varchar2 default null
400   ,p_scl_segment29                in     varchar2 default null
401   ,p_scl_segment30                in     varchar2 default null
402   ,p_scl_concat_segments          in     varchar2 default null
403   ,p_pgp_segment1                 in     varchar2 default null
404   ,p_pgp_segment2                 in     varchar2 default null
405   ,p_pgp_segment3                 in     varchar2 default null
406   ,p_pgp_segment4                 in     varchar2 default null
407   ,p_pgp_segment5                 in     varchar2 default null
408   ,p_pgp_segment6                 in     varchar2 default null
409   ,p_pgp_segment7                 in     varchar2 default null
410   ,p_pgp_segment8                 in     varchar2 default null
411   ,p_pgp_segment9                 in     varchar2 default null
412   ,p_pgp_segment10                in     varchar2 default null
413   ,p_pgp_segment11                in     varchar2 default null
414   ,p_pgp_segment12                in     varchar2 default null
415   ,p_pgp_segment13                in     varchar2 default null
416   ,p_pgp_segment14                in     varchar2 default null
417   ,p_pgp_segment15                in     varchar2 default null
418   ,p_pgp_segment16                in     varchar2 default null
419   ,p_pgp_segment17                in     varchar2 default null
420   ,p_pgp_segment18                in     varchar2 default null
421   ,p_pgp_segment19                in     varchar2 default null
422   ,p_pgp_segment20                in     varchar2 default null
423   ,p_pgp_segment21                in     varchar2 default null
424   ,p_pgp_segment22                in     varchar2 default null
425   ,p_pgp_segment23                in     varchar2 default null
426   ,p_pgp_segment24                in     varchar2 default null
427   ,p_pgp_segment25                in     varchar2 default null
428   ,p_pgp_segment26                in     varchar2 default null
429   ,p_pgp_segment27                in     varchar2 default null
430   ,p_pgp_segment28                in     varchar2 default null
431   ,p_pgp_segment29                in     varchar2 default null
432   ,p_pgp_segment30                in     varchar2 default null
433   ,p_pgp_concat_segments	  in     varchar2 default null
434   ,p_contract_id                  in     number default null
435   ,p_establishment_id             in     number default null
436   ,p_collective_agreement_id      in     number default null
437   ,p_cagr_id_flex_num             in     number default null
438   ,p_cag_segment1                 in     varchar2 default null
439   ,p_cag_segment2                 in     varchar2 default null
440   ,p_cag_segment3                 in     varchar2 default null
441   ,p_cag_segment4                 in     varchar2 default null
442   ,p_cag_segment5                 in     varchar2 default null
443   ,p_cag_segment6                 in     varchar2 default null
444   ,p_cag_segment7                 in     varchar2 default null
445   ,p_cag_segment8                 in     varchar2 default null
446   ,p_cag_segment9                 in     varchar2 default null
447   ,p_cag_segment10                in     varchar2 default null
448   ,p_cag_segment11                in     varchar2 default null
449   ,p_cag_segment12                in     varchar2 default null
450   ,p_cag_segment13                in     varchar2 default null
451   ,p_cag_segment14                in     varchar2 default null
452   ,p_cag_segment15                in     varchar2 default null
453   ,p_cag_segment16                in     varchar2 default null
454   ,p_cag_segment17                in     varchar2 default null
455   ,p_cag_segment18                in     varchar2 default null
456   ,p_cag_segment19                in     varchar2 default null
457   ,p_cag_segment20                in     varchar2 default null
458   ,p_notice_period		  in	 number   default null
459   ,p_notice_period_uom		  in     varchar2 default null
460   ,p_employee_category		  in     varchar2 default null
461   ,p_work_at_home		  in	 varchar2 default null
462   ,p_job_post_source_name         in     varchar2 default null
463   ,p_grade_ladder_pgm_id	  in	 number   default null
464   ,p_supervisor_assignment_id	  in	 number   default null
465   ,p_group_name                   out nocopy varchar2
466   ,p_concatenated_segments           out nocopy varchar2
467   ,p_cagr_grade_def_id            in out nocopy number
468   ,p_cagr_concatenated_segments      out nocopy varchar2
469   ,p_assignment_id                   out nocopy number
470   ,p_soft_coding_keyflex_id       in out nocopy number
471   ,p_people_group_id              in out nocopy number
472   ,p_object_version_number           out nocopy number
473   ,p_effective_start_date            out nocopy date
474   ,p_effective_end_date              out nocopy date
475   ,p_assignment_sequence             out nocopy number
476   ,p_comment_id                      out nocopy number
477   ,p_other_manager_warning           out nocopy boolean
478   ,p_hourly_salaried_warning         out nocopy boolean
482 -- ----------------------------------------------------------------------------
479   ,p_gsp_post_process_warning        out nocopy varchar2
480   );
481 --
483 -- |----------------------------< update_pl_emp_asg >-------------------------|
484 -- ----------------------------------------------------------------------------
485 --
486 -- {Start Of Comments}
487 /*#
488  * This API(older version) updates employee assignment details which do not
489  * affect entitlement to element entries.
490  *
491  * This API is an alternative to the API update_emp_asg. If p_validate is set
492  * to false, then the assignment record is updated. Also this API updates an
493  * employee assignment status. The new status must have a system status of
494  * ACTIVE_ASSIGN. If the assignment status is already a type of ACTIVE_ASSIGN,
495  * this API can be used to set a different active status. If the calling
496  * routine does not explicitly pass in a status, the API uses the default
497  * ACTIVE_ASSIGN status for the assignment's business group. Note: Only
498  * employee assignments can be altered with this API. Updates to an applicant
499  * assignment status are not allowed.
500  *
501  * <P> This version of the API is now out-of-date however it has been provided
502  * to you for backward compatibility support and will be removed in the future.
503  * Oracle recommends you to modify existing calling programs in advance of the
504  * support being withdrawn thus avoiding any potential disruption.
505  *
506  * <p><b>Licensing</b><br>
507  * This API is licensed for use with Human Resources.
508  *
509  * <p><b>Prerequisites</b><br>
510  * The assignment must exist as of the effective date and must be an employee
511  * assignment.
512  *
513  * <p><b>Post Success</b><br>
514  * The assignment will have been updated.
515  *
516  * <p><b>Post Failure</b><br>
517  * The assignment will not be updated and an error will be raised.
518  *
519  * @param p_validate If true, then validation alone will be performed and the
520  * database will remain unchanged. If false and all validation checks pass,
521  * then the database will be modified.
522  * @param p_effective_date Determines when the DateTrack operation comes into
523  * force.
524  * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
525  * updating the record. You must set to either UPDATE, CORRECTION,
526  * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
527  * particular record depend on the dates of previous record changes and the
528  * effective date of this change.
529  * @param p_assignment_id Identifies the assignment record to modify.
530  * @param p_object_version_number Pass in the current version number of the
531  * assignment to be updated. When the API completes if p_validate is false,
532  * will be set to the new version number of the updated assignment. If
533  * p_validate is true will be set to the same value which was passed in.
534  * @param p_supervisor_id Supervisor for the assignment. The value refers to
535  * the supervisor's person record.
536  * @param p_assignment_number Assignment number.
537  * @param p_change_reason Reason for the assignment status change. If there is
538  * no change reason, then the parameter can be null. Valid values are defined
539  * in the 'EMP_ASSIGN_REASON' lookup type.
540  * @param p_assignment_status_type_id Assignment status. The system status must
544  * @param p_date_probation_end End date of probation period.
541  * be the same as before the update, otherwise one of the status change APIs
542  * should be used.
543  * @param p_comments Comment text.
545  * @param p_default_code_comb_id Identifier for the General Ledger Accounting
546  * Flexfield combination that applies to this assignment.
547  * @param p_frequency Frequency associated with the defined normal working
548  * hours. Valid values are defined in the 'FREQUENCY' lookup type.
549  * @param p_internal_address_line Internal address identified with this
550  * assignment.
551  * @param p_manager_flag Indicates whether the employee is a manager.
552  * @param p_normal_hours Normal working hours for this assignment.
553  * @param p_perf_review_period Length of performance review period.
554  * @param p_perf_review_period_frequency Units of performance review period.
555  * Valid values are defined in the 'FREQUENCY' lookup type.
556  * @param p_probation_period Length of probation period.
557  * @param p_probation_unit Units of probation period. Valid values are defined
558  * in the 'QUALIFYING_UNITS' lookup type.
559  * @param p_sal_review_period Length of salary review period.
560  * @param p_sal_review_period_frequency Units of salary review period. Valid
561  * values are defined in the 'FREQUENCY' lookup type.
562  * @param p_set_of_books_id Identifies General Ledger set of books.
563  * @param p_source_type Recruitment activity which this assignment is sourced
564  * from. Valid values are defined in the 'REC_TYPE' lookup type.
565  * @param p_time_normal_finish Work end time.
566  * @param p_time_normal_start Work start time.
567  * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
568  * defined in the 'BARGAINING_UNIT_CODE' lookup type.
569  * @param p_labour_union_member_flag Indicates whether the employee is a labour
570  * union member.
571  * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
572  * is salaried. Valid values defined in the 'HOURLY_SALARIED_CODE' lookup type.
573  * @param p_ass_attribute_category This context value determines which
574  * Flexfield Structure to use with the Descriptive flexfield segments.
575  * @param p_ass_attribute1 Descriptive flexfield segment.
576  * @param p_ass_attribute2 Descriptive flexfield segment.
577  * @param p_ass_attribute3 Descriptive flexfield segment.
578  * @param p_ass_attribute4 Descriptive flexfield segment.
579  * @param p_ass_attribute5 Descriptive flexfield segment.
580  * @param p_ass_attribute6 Descriptive flexfield segment.
581  * @param p_ass_attribute7 Descriptive flexfield segment.
582  * @param p_ass_attribute8 Descriptive flexfield segment.
583  * @param p_ass_attribute9 Descriptive flexfield segment.
584  * @param p_ass_attribute10 Descriptive flexfield segment.
585  * @param p_ass_attribute11 Descriptive flexfield segment.
586  * @param p_ass_attribute12 Descriptive flexfield segment.
587  * @param p_ass_attribute13 Descriptive flexfield segment.
588  * @param p_ass_attribute14 Descriptive flexfield segment.
589  * @param p_ass_attribute15 Descriptive flexfield segment.
590  * @param p_ass_attribute16 Descriptive flexfield segment.
591  * @param p_ass_attribute17 Descriptive flexfield segment.
592  * @param p_ass_attribute18 Descriptive flexfield segment.
593  * @param p_ass_attribute19 Descriptive flexfield segment.
594  * @param p_ass_attribute20 Descriptive flexfield segment.
595  * @param p_ass_attribute21 Descriptive flexfield segment.
596  * @param p_ass_attribute22 Descriptive flexfield segment.
597  * @param p_ass_attribute23 Descriptive flexfield segment.
598  * @param p_ass_attribute24 Descriptive flexfield segment.
599  * @param p_ass_attribute25 Descriptive flexfield segment.
600  * @param p_ass_attribute26 Descriptive flexfield segment.
601  * @param p_ass_attribute27 Descriptive flexfield segment.
602  * @param p_ass_attribute28 Descriptive flexfield segment.
603  * @param p_ass_attribute29 Descriptive flexfield segment.
604  * @param p_ass_attribute30 Descriptive flexfield segment.
605  * @param p_title Obsolete parameter, do not use.
606  * @param p_segment1 Key flexfield segment.
607  * @param p_legal_employer Legal Employer of the assignment.
608  * @param p_segment3 Key flexfield segment.
609  * @param p_segment4 Key flexfield segment.
610  * @param p_segment5 Key flexfield segment.
611  * @param p_segment6 Key flexfield segment.
612  * @param p_segment7 Key flexfield segment.
613  * @param p_segment8 Key flexfield segment.
614  * @param p_segment9 Key flexfield segment.
615  * @param p_segment10 Key flexfield segment.
616  * @param p_segment11 Key flexfield segment.
617  * @param p_segment12 Key flexfield segment.
618  * @param p_segment13 Key flexfield segment.
619  * @param p_segment14 Key flexfield segment.
620  * @param p_segment15 Key flexfield segment.
621  * @param p_segment16 Key flexfield segment.
625  * @param p_segment20 Key flexfield segment.
622  * @param p_segment17 Key flexfield segment.
623  * @param p_segment18 Key flexfield segment.
624  * @param p_segment19 Key flexfield segment.
626  * @param p_segment21 Key flexfield segment.
627  * @param p_segment22 Key flexfield segment.
628  * @param p_segment23 Key flexfield segment.
629  * @param p_segment24 Key flexfield segment.
630  * @param p_segment25 Key flexfield segment.
631  * @param p_segment26 Key flexfield segment.
632  * @param p_segment27 Key flexfield segment.
633  * @param p_segment28 Key flexfield segment.
634  * @param p_segment29 Key flexfield segment.
635  * @param p_segment30 Key flexfield segment.
636  * @param p_concat_segments Concatenated segments for Soft Coded Key Flexfield.
637  * Concatenated segments can be supplied instead of individual segments.
638  * @param p_contract_id Contract associated with this assignment.
639  * @param p_establishment_id This identifies the establishment Legal Entity for
640  * this assignment.
641  * @param p_collective_agreement_id Collective Agreement that applies to this
642  * assignment.
643  * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
644  * flexfield to use for this assignment.
645  * @param p_cag_segment1 CAGR Key Flexfield segment.
646  * @param p_cag_segment2 CAGR Key Flexfield segment.
647  * @param p_cag_segment3 CAGR Key Flexfield segment.
648  * @param p_cag_segment4 CAGR Key Flexfield segment.
649  * @param p_cag_segment5 CAGR Key Flexfield segment.
650  * @param p_cag_segment6 CAGR Key Flexfield segment.
651  * @param p_cag_segment7 CAGR Key Flexfield segment.
652  * @param p_cag_segment8 CAGR Key Flexfield segment.
653  * @param p_cag_segment9 CAGR Key Flexfield segment.
654  * @param p_cag_segment10 CAGR Key Flexfield segment.
655  * @param p_cag_segment11 CAGR Key Flexfield segment.
656  * @param p_cag_segment12 CAGR Key Flexfield segment.
657  * @param p_cag_segment13 CAGR Key Flexfield segment.
658  * @param p_cag_segment14 CAGR Key Flexfield segment.
659  * @param p_cag_segment15 CAGR Key Flexfield segment.
660  * @param p_cag_segment16 CAGR Key Flexfield segment.
661  * @param p_cag_segment17 CAGR Key Flexfield segment.
662  * @param p_cag_segment18 CAGR Key Flexfield segment.
663  * @param p_cag_segment19 CAGR Key Flexfield segment.
664  * @param p_cag_segment20 CAGR Key Flexfield segment.
665  * @param p_notice_period Length of notice period.
666  * @param p_notice_period_uom Units for notice period. Valid values are defined
667  * in the 'QUALIFYING_UNITS' lookup type.
668  * @param p_employee_category Employee Category of the assignment. Valid values
669  * are defined in the 'EMPLOYEE_CATG' lookup type.
670  * @param p_work_at_home Indicates working from home. Valid values are defined
671  * in the 'YES_NO' lookup type.
672  * @param p_job_post_source_name Name of the source of the job posting that was
673  * answered for this assignment.
674  * @param p_supervisor_assignment_id Supervisor's assignment identification
675  * that is responsible for supervising this assignment.
676  * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
677  * identifies an existing CAGR Key Flexfield combination to associate with the
678  * assignment, and the segment values are ignored. If a value is not passed in,
679  * then the individual CAGR Key Flexfield segments supplied will be used to
680  * choose an existing combination or create a new combination. When the API
681  * completes, if p_validate is false, then this uniquely identifies the
682  * associated combination of the CAGR Key flexfield for this assignment. If
683  * p_validate is true, then set to null.
684  * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
685  * segments.
686  * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
687  * Flexfield concatenated segments, if p_validate is true, set to null.
688  * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
689  * it identifies an existing Soft Coded Key Flexfield combination to associate
690  * with the assignment, and segment values are ignored. If a value is not
691  * passed in, then the individual Soft Coded Key Flexfield segments supplied
692  * will be used to choose an existing combination or create a new combination.
693  * When the API completes, if p_validate is false, then this uniquely
694  * identifies the associated combination of the Soft Coded Key flexfield for
695  * this assignment. If p_validate is true, then set to null.
696  * @param p_comment_id If p_validate is false and comment text was provided,
700  * the effective date. If p_validate is true, then set to null.
697  * then will be set to the identifier of the created assignment comment record.
698  * @param p_effective_start_date If p_validate is false, then set to the
699  * effective start date on the updated assignment row which now exists as of
701  * @param p_effective_end_date If p_validate is false, then set to the
702  * effective end date on the updated assignment row which now exists as of the
703  * effective date. If p_validate is true, then set to null.
704  * @param p_no_managers_warning Set to true if as a result of the update there
705  * is no manager in the organization. Otherwise set to false.
706  * @param p_other_manager_warning If set to true, then a manager existed in the
707  * organization prior to calling this API and the manager flag has been set to
708  * 'Y' for yes.
709  * @param p_hourly_salaried_warning Set to true if values entered for Salary
710  * Basis and Hourly Salaried Code are invalid as of the effective date.
711  * @param p_gsp_post_process_warning Set to the name of the warning message
712  * from the Message Dictionary if any Grade Ladder related errors have been
713  * encountered while running this API.
714  * @rep:displayname Updates Employee Assignment for Poland
715  * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
716  * @rep:lifecycle deprecated
717  * @rep:scope public
718  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
719 */
720 --
721 -- {End Of Comments}
722 --
723 procedure update_pl_emp_asg
724   (p_validate                     in     boolean  default false
725   ,p_effective_date               in     date
726   ,p_datetrack_update_mode        in     varchar2
727   ,p_assignment_id                in     number
728   ,p_object_version_number        in out nocopy number
729   ,p_supervisor_id                in     number   default hr_api.g_number
730   ,p_assignment_number            in     varchar2 default hr_api.g_varchar2
731   ,p_change_reason                in     varchar2 default hr_api.g_varchar2
732   ,p_assignment_status_type_id    in     number   default hr_api.g_number
733   ,p_comments                     in     varchar2 default hr_api.g_varchar2
734   ,p_date_probation_end           in     date     default hr_api.g_date
735   ,p_default_code_comb_id         in     number   default hr_api.g_number
736   ,p_frequency                    in     varchar2 default hr_api.g_varchar2
737   ,p_internal_address_line        in     varchar2 default hr_api.g_varchar2
738   ,p_manager_flag                 in     varchar2 default hr_api.g_varchar2
739   ,p_normal_hours                 in     number   default hr_api.g_number
740   ,p_perf_review_period           in     number   default hr_api.g_number
741   ,p_perf_review_period_frequency in     varchar2 default hr_api.g_varchar2
742   ,p_probation_period             in     number   default hr_api.g_number
743   ,p_probation_unit               in     varchar2 default hr_api.g_varchar2
744   ,p_sal_review_period            in     number   default hr_api.g_number
745   ,p_sal_review_period_frequency  in     varchar2 default hr_api.g_varchar2
746   ,p_set_of_books_id              in     number   default hr_api.g_number
747   ,p_source_type                  in     varchar2 default hr_api.g_varchar2
748   ,p_time_normal_finish           in     varchar2 default hr_api.g_varchar2
749   ,p_time_normal_start            in     varchar2 default hr_api.g_varchar2
750   ,p_bargaining_unit_code         in     varchar2 default hr_api.g_varchar2
751   ,p_labour_union_member_flag     in     varchar2 default hr_api.g_varchar2
752   ,p_hourly_salaried_code         in     varchar2 default hr_api.g_varchar2
753   ,p_ass_attribute_category       in     varchar2 default hr_api.g_varchar2
754   ,p_ass_attribute1               in     varchar2 default hr_api.g_varchar2
755   ,p_ass_attribute2               in     varchar2 default hr_api.g_varchar2
756   ,p_ass_attribute3               in     varchar2 default hr_api.g_varchar2
757   ,p_ass_attribute4               in     varchar2 default hr_api.g_varchar2
758   ,p_ass_attribute5               in     varchar2 default hr_api.g_varchar2
759   ,p_ass_attribute6               in     varchar2 default hr_api.g_varchar2
760   ,p_ass_attribute7               in     varchar2 default hr_api.g_varchar2
761   ,p_ass_attribute8               in     varchar2 default hr_api.g_varchar2
762   ,p_ass_attribute9               in     varchar2 default hr_api.g_varchar2
763   ,p_ass_attribute10              in     varchar2 default hr_api.g_varchar2
764   ,p_ass_attribute11              in     varchar2 default hr_api.g_varchar2
765   ,p_ass_attribute12              in     varchar2 default hr_api.g_varchar2
766   ,p_ass_attribute13              in     varchar2 default hr_api.g_varchar2
767   ,p_ass_attribute14              in     varchar2 default hr_api.g_varchar2
768   ,p_ass_attribute15              in     varchar2 default hr_api.g_varchar2
769   ,p_ass_attribute16              in     varchar2 default hr_api.g_varchar2
770   ,p_ass_attribute17              in     varchar2 default hr_api.g_varchar2
771   ,p_ass_attribute18              in     varchar2 default hr_api.g_varchar2
772   ,p_ass_attribute19              in     varchar2 default hr_api.g_varchar2
773   ,p_ass_attribute20              in     varchar2 default hr_api.g_varchar2
774   ,p_ass_attribute21              in     varchar2 default hr_api.g_varchar2
775   ,p_ass_attribute22              in     varchar2 default hr_api.g_varchar2
776   ,p_ass_attribute23              in     varchar2 default hr_api.g_varchar2
777   ,p_ass_attribute24              in     varchar2 default hr_api.g_varchar2
778   ,p_ass_attribute25              in     varchar2 default hr_api.g_varchar2
779   ,p_ass_attribute26              in     varchar2 default hr_api.g_varchar2
780   ,p_ass_attribute27              in     varchar2 default hr_api.g_varchar2
781   ,p_ass_attribute28              in     varchar2 default hr_api.g_varchar2
782   ,p_ass_attribute29              in     varchar2 default hr_api.g_varchar2
783   ,p_ass_attribute30              in     varchar2 default hr_api.g_varchar2
784   ,p_title                        in     varchar2 default hr_api.g_varchar2
785   ,p_segment1                    in     varchar2 default hr_api.g_varchar2
786   ,p_legal_employer                  in     varchar2 default hr_api.g_varchar2
787   ,p_segment3                     in     varchar2 default hr_api.g_varchar2
788   ,p_segment4                     in     varchar2 default hr_api.g_varchar2
789   ,p_segment5                     in     varchar2 default hr_api.g_varchar2
790   ,p_segment6                     in     varchar2 default hr_api.g_varchar2
791   ,p_segment7                     in     varchar2 default hr_api.g_varchar2
795   ,p_segment11                    in     varchar2 default hr_api.g_varchar2
792   ,p_segment8                     in     varchar2 default hr_api.g_varchar2
793   ,p_segment9                     in     varchar2 default hr_api.g_varchar2
794   ,p_segment10                    in     varchar2 default hr_api.g_varchar2
796   ,p_segment12                    in     varchar2 default hr_api.g_varchar2
797   ,p_segment13                    in     varchar2 default hr_api.g_varchar2
798   ,p_segment14                    in     varchar2 default hr_api.g_varchar2
799   ,p_segment15                    in     varchar2 default hr_api.g_varchar2
800   ,p_segment16                    in     varchar2 default hr_api.g_varchar2
801   ,p_segment17                    in     varchar2 default hr_api.g_varchar2
802   ,p_segment18                    in     varchar2 default hr_api.g_varchar2
803   ,p_segment19                    in     varchar2 default hr_api.g_varchar2
804   ,p_segment20                    in     varchar2 default hr_api.g_varchar2
805   ,p_segment21                    in     varchar2 default hr_api.g_varchar2
806   ,p_segment22                    in     varchar2 default hr_api.g_varchar2
807   ,p_segment23                    in     varchar2 default hr_api.g_varchar2
808   ,p_segment24                    in     varchar2 default hr_api.g_varchar2
809   ,p_segment25                    in     varchar2 default hr_api.g_varchar2
810   ,p_segment26                    in     varchar2 default hr_api.g_varchar2
811   ,p_segment27                    in     varchar2 default hr_api.g_varchar2
812   ,p_segment28                    in     varchar2 default hr_api.g_varchar2
813   ,p_segment29                    in     varchar2 default hr_api.g_varchar2
814   ,p_segment30                    in     varchar2 default hr_api.g_varchar2
815   ,p_concat_segments              in     varchar2 default hr_api.g_varchar2
816   ,p_contract_id                  in     number default hr_api.g_number
817   ,p_establishment_id             in     number default hr_api.g_number
818   ,p_collective_agreement_id      in     number default hr_api.g_number
819   ,p_cagr_id_flex_num             in     number default hr_api.g_number
820   ,p_cag_segment1                 in     varchar2 default hr_api.g_varchar2
821   ,p_cag_segment2                 in     varchar2 default hr_api.g_varchar2
822   ,p_cag_segment3                 in     varchar2 default hr_api.g_varchar2
823   ,p_cag_segment4                 in     varchar2 default hr_api.g_varchar2
824   ,p_cag_segment5                 in     varchar2 default hr_api.g_varchar2
825   ,p_cag_segment6                 in     varchar2 default hr_api.g_varchar2
829   ,p_cag_segment10                in     varchar2 default hr_api.g_varchar2
826   ,p_cag_segment7                 in     varchar2 default hr_api.g_varchar2
827   ,p_cag_segment8                 in     varchar2 default hr_api.g_varchar2
828   ,p_cag_segment9                 in     varchar2 default hr_api.g_varchar2
830   ,p_cag_segment11                in     varchar2 default hr_api.g_varchar2
831   ,p_cag_segment12                in     varchar2 default hr_api.g_varchar2
832   ,p_cag_segment13                in     varchar2 default hr_api.g_varchar2
833   ,p_cag_segment14                in     varchar2 default hr_api.g_varchar2
834   ,p_cag_segment15                in     varchar2 default hr_api.g_varchar2
835   ,p_cag_segment16                in     varchar2 default hr_api.g_varchar2
836   ,p_cag_segment17                in     varchar2 default hr_api.g_varchar2
837   ,p_cag_segment18                in     varchar2 default hr_api.g_varchar2
838   ,p_cag_segment19                in     varchar2 default hr_api.g_varchar2
839   ,p_cag_segment20                in     varchar2 default hr_api.g_varchar2
840   ,p_notice_period		  in     number   default hr_api.g_number
841   ,p_notice_period_uom	      	  in     varchar2 default hr_api.g_varchar2
842   ,p_employee_category	          in     varchar2 default hr_api.g_varchar2
843   ,p_work_at_home		  in     varchar2 default hr_api.g_varchar2
844   ,p_job_post_source_name	  in     varchar2 default hr_api.g_varchar2
845   ,p_supervisor_assignment_id     in     number   default hr_api.g_number
846   ,p_cagr_grade_def_id            in out nocopy number
847   ,p_cagr_concatenated_segments      out nocopy varchar2
848   ,p_concatenated_segments           out nocopy varchar2
849   ,p_soft_coding_keyflex_id       in out nocopy number
850   ,p_comment_id                      out nocopy number
851   ,p_effective_start_date            out nocopy date
852   ,p_effective_end_date              out nocopy date
853   ,p_no_managers_warning             out nocopy boolean
854   ,p_other_manager_warning           out nocopy boolean
855   ,p_hourly_salaried_warning         out nocopy boolean
856   ,p_gsp_post_process_warning        out nocopy varchar2
857   );
858 --
859 -- ----------------------------------------------------------------------------
860 -- |-----------------------< create_pl_secondary_emp_asg >--------------------|
861 -- ----------------------------------------------------------------------------
862 --
863 -- {Start Of Comments}
864 /*#
865  * This API creates secondary assignment for an employee.
866  *
867  * This API is an alternative to the API create_secondary_emp_asg. If
868  * p_validate is set to false, an assignment is created.
869  *
870  * <p><b>Licensing</b><br>
871  * This API is licensed for use with Human Resources.
872  *
873  * <p><b>Prerequisites</b><br>
874  * The employee must have been created already and must exist at the effective
875  * start date of the assignment.
876  *
877  * <p><b>Post Success</b><br>
878  * A new secondary assignment is created for the employee.
879  *
880  * <p><b>Post Failure</b><br>
881  * The API does not create the assignment and raises an error.
882  *
883  * @param p_validate If true, then validation alone will be performed and the
884  * database will remain unchanged. If false and all validation checks pass,
885  * then the database will be modified.
886  * @param p_effective_date Determines when the DateTrack operation comes into
887  * force.
888  * @param p_person_id Identifies the person for whom you create the secondary
889  * assignment record.
890  * @param p_organization_id Identifies the organization of the secondary
891  * assignment.
892  * @param p_grade_id Identifies the grade of the secondary assignment.
893  * @param p_position_id Identifies the position of the secondary assignment.
894  * @param p_job_id Identifies the job of the secondary assignment.
895  * @param p_assignment_status_type_id Identifies the assignment status of the
896  * secondary assignment. Valid values are defined by 'PER_ASS_SYS_STATUS'
897  * lookup type.
898  * @param p_payroll_id Identifies the payroll for the secondary assignment.
899  * @param p_location_id Identifies the location of the secondary assignment.
900  * @param p_supervisor_id Identifies the supervisor for the secondary
901  * assignment. The value refers to the supervisor's person record.
902  * @param p_special_ceiling_step_id Highest allowed step for the grade scale
903  * associated with the grade of the secondary assignment.
904  * @param p_pay_basis_id Salary basis for the secondary assignment.
905  * @param p_assignment_number If a value is passed in, this is used as the
906  * assignment number. If no value is passed in an assignment number is
907  * generated.
908  * @param p_change_reason Reason for the assignment status change. If there is
909  * no change reason the parameter can be null. Valid values are defined in the
910  * 'EMP_ASSIGN_REASON' lookup type.
911  * @param p_comments Comment text.
912  * @param p_date_probation_end End date of probation period.
913  * @param p_default_code_comb_id Identifier for the General Ledger Accounting
914  * Flexfield combination that applies to this assignment.
915  * @param p_employment_category Employment category of the assignment. Valid
916  * values are defined in the 'EMP_CAT' lookup type.
917  * @param p_frequency Frequency associated with the defined normal working
918  * hours. Valid values are defined in the 'FREQUENCY' lookup type.
919  * @param p_internal_address_line Internal address identified with the
920  * secondary assignment.
921  * @param p_manager_flag Indicates whether the employee is a manager.
922  * @param p_normal_hours Normal working hours for this assignment.
923  * @param p_perf_review_period Length of performance review period.
924  * @param p_perf_review_period_frequency Units of performance review period.
928  * in the 'QUALIFYING_UNITS' lookup type.
925  * Valid values are defined in the 'FREQUENCY' lookup type.
926  * @param p_probation_period Length of probation period.
927  * @param p_probation_unit Units of probation period. Valid values are defined
929  * @param p_sal_review_period Length of salary review period.
930  * @param p_sal_review_period_frequency Units of salary review period. Valid
931  * values are defined in the 'FREQUENCY' lookup type.
932  * @param p_set_of_books_id Identifies General Ledger set of books.
933  * @param p_source_type Recruitment activity which this assignment is sourced
934  * from. Valid values are defined in the 'REC_TYPE' lookup type.
935  * @param p_time_normal_finish Work end time.
936  * @param p_time_normal_start Work start time.
937  * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
938  * defined in the 'BARGAINING_UNIT_CODE' lookup type.
939  * @param p_labour_union_member_flag Indicates whether the employee is a labour
940  * union member.
941  * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
942  * is salaried. Valid values are defined in the 'HOURLY_SALARIED_CODE' lookup
943  * type.
944  * @param p_ass_attribute_category This context value determines which
945  * Flexfield Structure to use with the Descriptive flexfield segments.
946  * @param p_ass_attribute1 Descriptive flexfield segment.
947  * @param p_ass_attribute2 Descriptive flexfield segment.
948  * @param p_ass_attribute3 Descriptive flexfield segment.
949  * @param p_ass_attribute4 Descriptive flexfield segment.
950  * @param p_ass_attribute5 Descriptive flexfield segment.
951  * @param p_ass_attribute6 Descriptive flexfield segment.
952  * @param p_ass_attribute7 Descriptive flexfield segment.
953  * @param p_ass_attribute8 Descriptive flexfield segment.
954  * @param p_ass_attribute9 Descriptive flexfield segment.
955  * @param p_ass_attribute10 Descriptive flexfield segment.
956  * @param p_ass_attribute11 Descriptive flexfield segment.
957  * @param p_ass_attribute12 Descriptive flexfield segment.
958  * @param p_ass_attribute13 Descriptive flexfield segment.
959  * @param p_ass_attribute14 Descriptive flexfield segment.
960  * @param p_ass_attribute15 Descriptive flexfield segment.
961  * @param p_ass_attribute16 Descriptive flexfield segment.
962  * @param p_ass_attribute17 Descriptive flexfield segment.
963  * @param p_ass_attribute18 Descriptive flexfield segment.
964  * @param p_ass_attribute19 Descriptive flexfield segment.
965  * @param p_ass_attribute20 Descriptive flexfield segment.
966  * @param p_ass_attribute21 Descriptive flexfield segment.
967  * @param p_ass_attribute22 Descriptive flexfield segment.
968  * @param p_ass_attribute23 Descriptive flexfield segment.
969  * @param p_ass_attribute24 Descriptive flexfield segment.
970  * @param p_ass_attribute25 Descriptive flexfield segment.
971  * @param p_ass_attribute26 Descriptive flexfield segment.
972  * @param p_ass_attribute27 Descriptive flexfield segment.
973  * @param p_ass_attribute28 Descriptive flexfield segment.
974  * @param p_ass_attribute29 Descriptive flexfield segment.
975  * @param p_ass_attribute30 Descriptive flexfield segment.
976  * @param p_title Obsolete parameter, do not use.
977  * @param p_contract_category This specifies the contract category of
978  * the assignment.The lookup type 'PL_CONTRACT_CATEGORY' defines
979  * the valid values for the Polish legislation.
980  * @param p_contract_type This specifies the Contract type of the
981  * assignment. If the contract category is 'CIVIL',then the lookup
982  * 'PL_CONTRACT_TYPE_CIVIL' defines the valid values.If the contract
983  * category is 'NORMAL',then the lookup 'PL_CONTRACT_TYPE_NORMAL'
984  * defines the valid values for the Polish legislation.
985  * @param p_contract_number This indicates the contract number of the assignment.
986  * @param p_change_of_contract_reason This indicates the reason for changing
987  * the contract type.The lookup 'PL_CONTRACT_END_REASON' defines the
988  * valid values for the Polish legislation.
989  * @param p_job This identifies the job(SII) of the contract.The lookup
990  * 'PL_JOB' defines the valid values for the Polish legislation.
991  * @param p_work_in_special_condition Identifies whether this assignment
992  * involves working under any special conditions.The lookup
993  * 'PL_WORK_IN_SPECIAL_COND' defines the valid values for the Polish legislation.
994  * @param p_end_of_contract_addl_details This specifies any additional
995  * details about the end of contract.
996  * @param p_contract_start_date This specifies the contract start
997  * date for the assignment.
998  * @param p_planned_valid_to_date This specifies the planned end date
999  * of the contract.
1000  * @param p_contract_type_change_date This specifies the date on which
1001  * the contract type is changed.
1002  * @param p_date_contract_signed This specifies the date on which
1003  * the contract is signed.
1004  * @param p_notice_period_date This specifies the date on which notice is
1005  * given to end the contract.
1006  * @param p_notice_period_end_date This is the specified date on
1007  * which contract will end.
1008  * @param p_scl_concat_segments Concatenated segments for Soft Coded Key
1009  * Flexfield. Concatenated segments can be supplied instead of individual
1010  * segments.
1011  * @param p_pgp_segment1 People group key flexfield segment.
1012  * @param p_pgp_segment2 People group key flexfield segment.
1013  * @param p_pgp_segment3 People group key flexfield segment.
1014  * @param p_pgp_segment4 People group key flexfield segment.
1015  * @param p_pgp_segment5 People group key flexfield segment.
1016  * @param p_pgp_segment6 People group key flexfield segment.
1017  * @param p_pgp_segment7 People group key flexfield segment.
1018  * @param p_pgp_segment8 People group key flexfield segment.
1019  * @param p_pgp_segment9 People group key flexfield segment.
1023  * @param p_pgp_segment13 People group key flexfield segment.
1020  * @param p_pgp_segment10 People group key flexfield segment.
1021  * @param p_pgp_segment11 People group key flexfield segment.
1022  * @param p_pgp_segment12 People group key flexfield segment.
1024  * @param p_pgp_segment14 People group key flexfield segment.
1025  * @param p_pgp_segment15 People group key flexfield segment.
1026  * @param p_pgp_segment16 People group key flexfield segment.
1027  * @param p_pgp_segment17 People group key flexfield segment.
1028  * @param p_pgp_segment18 People group key flexfield segment.
1029  * @param p_pgp_segment19 People group key flexfield segment.
1030  * @param p_pgp_segment20 People group key flexfield segment.
1031  * @param p_pgp_segment21 People group key flexfield segment.
1032  * @param p_pgp_segment22 People group key flexfield segment.
1033  * @param p_pgp_segment23 People group key flexfield segment.
1034  * @param p_pgp_segment24 People group key flexfield segment.
1035  * @param p_pgp_segment25 People group key flexfield segment.
1036  * @param p_pgp_segment26 People group key flexfield segment.
1037  * @param p_pgp_segment27 People group key flexfield segment.
1038  * @param p_pgp_segment28 People group key flexfield segment.
1039  * @param p_pgp_segment29 People group key flexfield segment.
1040  * @param p_pgp_segment30 People group key flexfield segment.
1041  * @param p_pgp_concat_segments Concatenated segments for People Group Key
1042  * Flexfield. Concatenated segments can be supplied instead of individual
1043  * segments.
1044  * @param p_contract_id Contract associated with this assignment.
1045  * @param p_establishment_id This identifies the establishment Legal Entity for
1046  * this assignment.
1047  * @param p_collective_agreement_id Collective Agreement that applies to this
1048  * assignment.
1049  * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
1050  * flexfield to use for this assignment.
1051  * @param p_cag_segment1 CAGR Key Flexfield segment.
1052  * @param p_cag_segment2 CAGR Key Flexfield segment.
1053  * @param p_cag_segment3 CAGR Key Flexfield segment.
1054  * @param p_cag_segment4 CAGR Key Flexfield segment.
1055  * @param p_cag_segment5 CAGR Key Flexfield segment.
1056  * @param p_cag_segment6 CAGR Key Flexfield segment.
1057  * @param p_cag_segment7 CAGR Key Flexfield segment.
1058  * @param p_cag_segment8 CAGR Key Flexfield segment.
1059  * @param p_cag_segment9 CAGR Key Flexfield segment.
1060  * @param p_cag_segment10 CAGR Key Flexfield segment.
1061  * @param p_cag_segment11 CAGR Key Flexfield segment.
1062  * @param p_cag_segment12 CAGR Key Flexfield segment.
1063  * @param p_cag_segment13 CAGR Key Flexfield segment.
1064  * @param p_cag_segment14 CAGR Key Flexfield segment.
1065  * @param p_cag_segment15 CAGR Key Flexfield segment.
1066  * @param p_cag_segment16 CAGR Key Flexfield segment.
1067  * @param p_cag_segment17 CAGR Key Flexfield segment.
1068  * @param p_cag_segment18 CAGR Key Flexfield segment.
1069  * @param p_cag_segment19 CAGR Key Flexfield segment.
1070  * @param p_cag_segment20 CAGR Key Flexfield segment.
1071  * @param p_notice_period Length of notice period.
1072  * @param p_notice_period_uom Units for notice period. Valid values are defined
1073  * in the 'QUALIFYING_UNITS' lookup type.
1074  * @param p_employee_category Employee Category of the assignment. Valid values
1075  * are defined in the 'EMPLOYEE_CATG' lookup type.
1076  * @param p_work_at_home Indicates working from home. Valid values are defined
1077  * in the 'YES_NO' lookup type.
1078  * @param p_job_post_source_name The source of the job posting that was
1079  * answered for this assignment.
1080  * @param p_grade_ladder_pgm_id Grade Ladder for this assignment.
1081  * @param p_supervisor_assignment_id Supervisor's assignment identification
1082  * that is responsible for supervising this assignment.
1083  * @param p_group_name If p_validate is false, set to the People Group Key
1084  * Flexfield concatenated segments. If p_validate is true, set to null.
1085  * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
1086  * Flexfield concatenated segments, if p_validate is true, set to null.
1087  * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
1088  * identifies an existing CAGR Key Flexfield combination to associate with the
1089  * assignment, and the segment values are ignored. If a value is not passed in,
1090  * then the individual CAGR Key Flexfield segments supplied will be used to
1091  * choose an existing combination or create a new combination. When the API
1092  * completes, if p_validate is false, then this uniquely identifies the
1093  * associated combination of the CAGR Key flexfield for this assignment. If
1094  * p_validate is true, then set to null.
1095  * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
1096  * segments.
1097  * @param p_assignment_id If p_validate is false, then this uniquely identifies
1098  * the created assignment. If p_validate is true, then set to null.
1099  * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
1100  * it identifies an existing Soft Coded Key Flexfield combination to associate
1101  * with the assignment, and segment values are ignored. If a value is not
1102  * passed in, then the individual Soft Coded Key Flexfield segments supplied
1103  * will be used to choose an existing combination or create a new combination.
1104  * When the API completes, if p_validate is false, then this uniquely
1105  * identifies the associated combination of the Soft Coded Key flexfield for
1106  * this assignment. If p_validate is true, then set to null.
1107  * @param p_people_group_id If a value is passed in for this parameter, it
1108  * identifies an existing People Group Key Flexfield combination to associate
1109  * with the assignment, and segment values are ignored. If a value is not
1110  * passed in, then the individual People Group Key Flexfield segments supplied
1114  * this assignment. If p_validate is true, then set to null.
1111  * will be used to choose an existing combination or create a new combination.
1112  * When the API completes, if p_validate is false, then this uniquely
1113  * identifies the associated combination of the People Group Key flexfield for
1115  * @param p_object_version_number If p_validate is false, then set to the
1116  * version number of the created assignment. If p_validate is true, then the
1117  * value will be null.
1118  * @param p_effective_start_date If p_validate is false, then set to the
1119  * earliest effective start date for the created assignment. If p_validate is
1120  * true, then set to null.
1121  * @param p_effective_end_date If p_validate is false, then set to the
1122  * effective end date for the created assignment. If p_validate is true, then
1123  * set to null.
1124  * @param p_assignment_sequence If p_validate is false, then an automatically
1125  * incremented number is associated with this assignment, depending on the
1126  * number of assignment which already exist. If p_validate is true then set to
1127  * null.
1128  * @param p_comment_id If p_validate is false and comment text was provided,
1129  * then will be set to the identifier of the created assignment comment record.
1130  * If p_validate is true or no comment text was provided, then will be null.
1131  * @param p_other_manager_warning If set to true, then a manager existed in the
1132  * organization prior to calling this API and the manager flag has been set to
1133  * 'Y' for yes.
1134  * @param p_hourly_salaried_warning Set to true if values entered for Salary
1135  * Basis and Hourly Salaried Code are invalid as of p_effective_date.
1136  * @param p_gsp_post_process_warning Set to the name of a warning message from
1137  * the Message Dictionary if any Grade Ladder related errors have been
1138  * encountered while running this API.
1139  * @rep:displayname Create Secondary Employee Assignment for Poland
1140  * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
1141  * @rep:lifecycle active
1142  * @rep:primaryinstance
1143  * @rep:scope public
1144  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1145 */
1146 --
1147 -- {End Of Comments}
1148 --
1149 Procedure create_pl_secondary_emp_asg
1150   (p_validate                     in     boolean  default false
1151   ,p_effective_date               in     date
1152   ,p_person_id                    in     number
1153   ,p_organization_id              in     number
1154   ,p_grade_id                     in     number   default null
1155   ,p_position_id                  in     number   default null
1156   ,p_job_id                       in     number   default null
1157   ,p_assignment_status_type_id    in     number   default null
1158   ,p_payroll_id                   in     number   default null
1159   ,p_location_id                  in     number   default null
1160   ,p_supervisor_id                in     number   default null
1161   ,p_special_ceiling_step_id      in     number   default null
1162   ,p_pay_basis_id                 in     number   default null
1163   ,p_assignment_number            in out nocopy varchar2
1164   ,p_change_reason                in     varchar2 default null
1165   ,p_comments                     in     varchar2 default null
1166   ,p_date_probation_end           in     date     default null
1167   ,p_default_code_comb_id         in     number   default null
1168   ,p_employment_category          in     varchar2 default null
1169   ,p_frequency                    in     varchar2 default null
1170   ,p_internal_address_line        in     varchar2 default null
1171   ,p_manager_flag                 in     varchar2 default null
1172   ,p_normal_hours                 in     number   default null
1173   ,p_perf_review_period           in     number   default null
1174   ,p_perf_review_period_frequency in     varchar2 default null
1175   ,p_probation_period             in     number   default null
1176   ,p_probation_unit               in     varchar2 default null
1177   ,p_sal_review_period            in     number   default null
1178   ,p_sal_review_period_frequency  in     varchar2 default null
1179   ,p_set_of_books_id              in     number   default null
1180   ,p_source_type                  in     varchar2 default null
1181   ,p_time_normal_finish           in     varchar2 default null
1182   ,p_time_normal_start            in     varchar2 default null
1183   ,p_bargaining_unit_code         in     varchar2 default null
1184   ,p_labour_union_member_flag     in     varchar2 default 'N'
1185   ,p_hourly_salaried_code         in     varchar2 default null
1186   ,p_ass_attribute_category       in     varchar2 default null
1187   ,p_ass_attribute1               in     varchar2 default null
1188   ,p_ass_attribute2               in     varchar2 default null
1189   ,p_ass_attribute3               in     varchar2 default null
1190   ,p_ass_attribute4               in     varchar2 default null
1191   ,p_ass_attribute5               in     varchar2 default null
1192   ,p_ass_attribute6               in     varchar2 default null
1193   ,p_ass_attribute7               in     varchar2 default null
1194   ,p_ass_attribute8               in     varchar2 default null
1195   ,p_ass_attribute9               in     varchar2 default null
1196   ,p_ass_attribute10              in     varchar2 default null
1197   ,p_ass_attribute11              in     varchar2 default null
1198   ,p_ass_attribute12              in     varchar2 default null
1199   ,p_ass_attribute13              in     varchar2 default null
1200   ,p_ass_attribute14              in     varchar2 default null
1201   ,p_ass_attribute15              in     varchar2 default null
1202   ,p_ass_attribute16              in     varchar2 default null
1203   ,p_ass_attribute17              in     varchar2 default null
1204   ,p_ass_attribute18              in     varchar2 default null
1205   ,p_ass_attribute19              in     varchar2 default null
1206   ,p_ass_attribute20              in     varchar2 default null
1207   ,p_ass_attribute21              in     varchar2 default null
1208   ,p_ass_attribute22              in     varchar2 default null
1212   ,p_ass_attribute26              in     varchar2 default null
1209   ,p_ass_attribute23              in     varchar2 default null
1210   ,p_ass_attribute24              in     varchar2 default null
1211   ,p_ass_attribute25              in     varchar2 default null
1213   ,p_ass_attribute27              in     varchar2 default null
1214   ,p_ass_attribute28              in     varchar2 default null
1215   ,p_ass_attribute29              in     varchar2 default null
1216   ,p_ass_attribute30              in     varchar2 default null
1217   ,p_title                        in     varchar2 default null
1218   ,p_contract_category            in     varchar2
1219   ,p_contract_type                in     varchar2
1220   ,p_contract_number              in     varchar2
1221   ,p_change_of_contract_reason    in     varchar2 default null
1222   ,p_job                          in     varchar2 default null
1223   ,p_work_in_special_condition    in     varchar2 default null
1224   ,p_end_of_contract_addl_details in     varchar2 default null
1225   ,p_contract_start_date          in     varchar2
1226   ,p_planned_valid_to_date        in     varchar2 default null
1227   ,p_contract_type_change_date    in     varchar2 default null
1228   ,p_date_contract_signed         in     varchar2
1229   ,p_notice_period_date           in     varchar2 default null
1230   ,p_notice_period_end_date       in     varchar2 default null
1231   ,p_scl_concat_segments          in     varchar2 default null
1232   ,p_pgp_segment1                 in     varchar2 default null
1233   ,p_pgp_segment2                 in     varchar2 default null
1234   ,p_pgp_segment3                 in     varchar2 default null
1235   ,p_pgp_segment4                 in     varchar2 default null
1236   ,p_pgp_segment5                 in     varchar2 default null
1237   ,p_pgp_segment6                 in     varchar2 default null
1238   ,p_pgp_segment7                 in     varchar2 default null
1239   ,p_pgp_segment8                 in     varchar2 default null
1240   ,p_pgp_segment9                 in     varchar2 default null
1241   ,p_pgp_segment10                in     varchar2 default null
1242   ,p_pgp_segment11                in     varchar2 default null
1243   ,p_pgp_segment12                in     varchar2 default null
1244   ,p_pgp_segment13                in     varchar2 default null
1245   ,p_pgp_segment14                in     varchar2 default null
1246   ,p_pgp_segment15                in     varchar2 default null
1247   ,p_pgp_segment16                in     varchar2 default null
1248   ,p_pgp_segment17                in     varchar2 default null
1249   ,p_pgp_segment18                in     varchar2 default null
1250   ,p_pgp_segment19                in     varchar2 default null
1251   ,p_pgp_segment20                in     varchar2 default null
1252   ,p_pgp_segment21                in     varchar2 default null
1253   ,p_pgp_segment22                in     varchar2 default null
1254   ,p_pgp_segment23                in     varchar2 default null
1255   ,p_pgp_segment24                in     varchar2 default null
1256   ,p_pgp_segment25                in     varchar2 default null
1257   ,p_pgp_segment26                in     varchar2 default null
1258   ,p_pgp_segment27                in     varchar2 default null
1259   ,p_pgp_segment28                in     varchar2 default null
1260   ,p_pgp_segment29                in     varchar2 default null
1261   ,p_pgp_segment30                in     varchar2 default null
1262   ,p_pgp_concat_segments	  in     varchar2 default null
1263   ,p_contract_id                  in     number default null
1264   ,p_establishment_id             in     number default null
1265   ,p_collective_agreement_id      in     number default null
1266   ,p_cagr_id_flex_num             in     number default null
1267   ,p_cag_segment1                 in     varchar2 default null
1268   ,p_cag_segment2                 in     varchar2 default null
1269   ,p_cag_segment3                 in     varchar2 default null
1270   ,p_cag_segment4                 in     varchar2 default null
1274   ,p_cag_segment8                 in     varchar2 default null
1271   ,p_cag_segment5                 in     varchar2 default null
1272   ,p_cag_segment6                 in     varchar2 default null
1273   ,p_cag_segment7                 in     varchar2 default null
1275   ,p_cag_segment9                 in     varchar2 default null
1276   ,p_cag_segment10                in     varchar2 default null
1277   ,p_cag_segment11                in     varchar2 default null
1278   ,p_cag_segment12                in     varchar2 default null
1279   ,p_cag_segment13                in     varchar2 default null
1280   ,p_cag_segment14                in     varchar2 default null
1281   ,p_cag_segment15                in     varchar2 default null
1282   ,p_cag_segment16                in     varchar2 default null
1283   ,p_cag_segment17                in     varchar2 default null
1284   ,p_cag_segment18                in     varchar2 default null
1285   ,p_cag_segment19                in     varchar2 default null
1286   ,p_cag_segment20                in     varchar2 default null
1287   ,p_notice_period		  in	 number   default null
1288   ,p_notice_period_uom		  in     varchar2 default null
1289   ,p_employee_category		  in     varchar2 default null
1290   ,p_work_at_home		  in	 varchar2 default null
1291   ,p_job_post_source_name         in     varchar2 default null
1292   ,p_grade_ladder_pgm_id	  in	 number   default null
1293   ,p_supervisor_assignment_id	  in	 number   default null
1294   ,p_group_name                   out nocopy varchar2
1295   ,p_concatenated_segments           out nocopy varchar2
1296   ,p_cagr_grade_def_id            in out nocopy number
1297   ,p_cagr_concatenated_segments      out nocopy varchar2
1298   ,p_assignment_id                   out nocopy number
1299   ,p_soft_coding_keyflex_id       in out nocopy number
1300   ,p_people_group_id              in out nocopy number
1301   ,p_object_version_number           out nocopy number
1302   ,p_effective_start_date            out nocopy date
1303   ,p_effective_end_date              out nocopy date
1304   ,p_assignment_sequence             out nocopy number
1305   ,p_comment_id                      out nocopy number
1306   ,p_other_manager_warning           out nocopy boolean
1307   ,p_hourly_salaried_warning         out nocopy boolean
1308   ,p_gsp_post_process_warning        out nocopy varchar2
1309   );
1310 --
1311 -- ----------------------------------------------------------------------------
1312 -- |----------------------------< update_pl_emp_asg >-------------------------|
1313 -- ----------------------------------------------------------------------------
1314 --
1315 -- {Start Of Comments}
1316 /*#
1317  * This API updates employee assignment details which do not affect entitlement
1318  * to element entries.
1319  *
1320  * This API is an alternative to the API update_emp_asg. If p_validate is set
1321  * to false, then the assignment record is updated. Also this API updates an
1322  * employee assignment status. The new status must have a system status of
1323  * ACTIVE_ASSIGN. If the assignment status is already a type of ACTIVE_ASSIGN,
1324  * this API can be used to set a different active status. If the calling
1325  * routine does not explicitly pass in a status, the API uses the default
1326  * ACTIVE_ASSIGN status for the assignment's business group. Note: Only
1327  * employee assignments can be altered with this API. Updates to an applicant
1328  * assignment status are not allowed.
1329  *
1330  * <p><b>Licensing</b><br>
1331  * This API is licensed for use with Human Resources.
1332  *
1333  * <p><b>Prerequisites</b><br>
1334  * The assignment must exist as of the effective date and must be an employee
1335  * assignment.
1336  *
1337  * <p><b>Post Success</b><br>
1338  * The assignment will have been updated.
1339  *
1340  * <p><b>Post Failure</b><br>
1341  * The assignment will not be updated and an error will be raised.
1342  *
1343  * @param p_validate If true, then validation alone will be performed and the
1344  * database will remain unchanged. If false and all validation checks pass,
1345  * then the database will be modified.
1346  * @param p_effective_date Determines when the DateTrack operation comes into
1347  * force.
1348  * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
1349  * updating the record. You must set to either UPDATE, CORRECTION,
1350  * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
1351  * particular record depend on the dates of previous record changes and the
1355  * assignment to be updated. When the API completes if p_validate is false,
1352  * effective date of this change.
1353  * @param p_assignment_id Identifies the assignment record to modify.
1354  * @param p_object_version_number Pass in the current version number of the
1356  * will be set to the new version number of the updated assignment. If
1357  * p_validate is true will be set to the same value which was passed in.
1358  * @param p_supervisor_id Supervisor for the assignment. The value refers to
1359  * the supervisor's person record.
1360  * @param p_assignment_number Assignment number.
1361  * @param p_change_reason Reason for the assignment status change. If there is
1362  * no change reason, then the parameter can be null. Valid values are defined
1363  * in the 'EMP_ASSIGN_REASON' lookup type.
1364  * @param p_assignment_status_type_id Assignment status. The system status must
1365  * be the same as before the update, otherwise one of the status change APIs
1366  * should be used.
1367  * @param p_comments Comment text.
1368  * @param p_date_probation_end End date of probation period.
1369  * @param p_default_code_comb_id Identifier for the General Ledger Accounting
1370  * Flexfield combination that applies to this assignment.
1371  * @param p_frequency Frequency associated with the defined normal working
1372  * hours. Valid values are defined in the 'FREQUENCY' lookup type.
1373  * @param p_internal_address_line Internal address identified with this
1374  * assignment.
1375  * @param p_manager_flag Indicates whether the employee is a manager.
1376  * @param p_normal_hours Normal working hours for this assignment.
1377  * @param p_perf_review_period Length of performance review period.
1378  * @param p_perf_review_period_frequency Units of performance review period.
1379  * Valid values are defined in the 'FREQUENCY' lookup type.
1380  * @param p_probation_period Length of probation period.
1381  * @param p_probation_unit Units of probation period. Valid values are defined
1382  * in the 'QUALIFYING_UNITS' lookup type.
1383  * @param p_sal_review_period Length of salary review period.
1384  * @param p_sal_review_period_frequency Units of salary review period. Valid
1385  * values are defined in the 'FREQUENCY' lookup type.
1386  * @param p_set_of_books_id Identifies General Ledger set of books.
1387  * @param p_source_type Recruitment activity which this assignment is sourced
1388  * from. Valid values are defined in the 'REC_TYPE' lookup type.
1389  * @param p_time_normal_finish Work end time.
1390  * @param p_time_normal_start Work start time.
1391  * @param p_bargaining_unit_code Code for bargaining unit. Valid values are
1392  * defined in the 'BARGAINING_UNIT_CODE' lookup type.
1393  * @param p_labour_union_member_flag Indicates whether the employee is a labour
1394  * union member.
1395  * @param p_hourly_salaried_code Identifies if the assignment is paid hourly or
1396  * is salaried. Valid values defined in the 'HOURLY_SALARIED_CODE' lookup type.
1397  * @param p_ass_attribute_category This context value determines which
1398  * Flexfield Structure to use with the Descriptive flexfield segments.
1399  * @param p_ass_attribute1 Descriptive flexfield segment.
1400  * @param p_ass_attribute2 Descriptive flexfield segment.
1401  * @param p_ass_attribute3 Descriptive flexfield segment.
1402  * @param p_ass_attribute4 Descriptive flexfield segment.
1403  * @param p_ass_attribute5 Descriptive flexfield segment.
1404  * @param p_ass_attribute6 Descriptive flexfield segment.
1405  * @param p_ass_attribute7 Descriptive flexfield segment.
1406  * @param p_ass_attribute8 Descriptive flexfield segment.
1407  * @param p_ass_attribute9 Descriptive flexfield segment.
1408  * @param p_ass_attribute10 Descriptive flexfield segment.
1409  * @param p_ass_attribute11 Descriptive flexfield segment.
1410  * @param p_ass_attribute12 Descriptive flexfield segment.
1411  * @param p_ass_attribute13 Descriptive flexfield segment.
1412  * @param p_ass_attribute14 Descriptive flexfield segment.
1413  * @param p_ass_attribute15 Descriptive flexfield segment.
1414  * @param p_ass_attribute16 Descriptive flexfield segment.
1415  * @param p_ass_attribute17 Descriptive flexfield segment.
1416  * @param p_ass_attribute18 Descriptive flexfield segment.
1417  * @param p_ass_attribute19 Descriptive flexfield segment.
1418  * @param p_ass_attribute20 Descriptive flexfield segment.
1419  * @param p_ass_attribute21 Descriptive flexfield segment.
1420  * @param p_ass_attribute22 Descriptive flexfield segment.
1421  * @param p_ass_attribute23 Descriptive flexfield segment.
1422  * @param p_ass_attribute24 Descriptive flexfield segment.
1423  * @param p_ass_attribute25 Descriptive flexfield segment.
1424  * @param p_ass_attribute26 Descriptive flexfield segment.
1425  * @param p_ass_attribute27 Descriptive flexfield segment.
1426  * @param p_ass_attribute28 Descriptive flexfield segment.
1427  * @param p_ass_attribute29 Descriptive flexfield segment.
1428  * @param p_ass_attribute30 Descriptive flexfield segment.
1429  * @param p_title Obsolete parameter, do not use.
1430  * @param p_contract_category This specifies the contract category of
1431  * the assignment.The lookup type 'PL_CONTRACT_CATEGORY' defines
1432  * the valid values for the Polish legislation.
1433  * @param p_contract_type This specifies the Contract type of the
1434  * assignment. If the contract category is 'CIVIL',then the lookup
1435  * 'PL_CONTRACT_TYPE_CIVIL' defines the valid values.If the contract
1436  * category is 'NORMAL',then the lookup 'PL_CONTRACT_TYPE_NORMAL'
1437  * defines the valid values for the Polish legislation.
1438  * @param p_contract_number This indicates the contract number of the assignment.
1439  * @param p_change_of_contract_reason This indicates the reason for changing
1440  * the contract type.The lookup 'PL_CONTRACT_END_REASON' defines the
1441  * valid values for the Polish legislation.
1442  * @param p_job This identifies the job(SII) of the contract.The lookup
1443  * 'PL_JOB' defines the valid values for the Polish legislation.
1444  * @param p_work_in_special_condition Identifies whether this assignment
1448  * details about the end of contract.
1445  * involves working under any special conditions.The lookup
1446  * 'PL_WORK_IN_SPECIAL_COND' defines the valid values for the Polish legislation.
1447  * @param p_end_of_contract_addl_details This specifies any additional
1449  * @param p_contract_start_date This specifies the contract start
1450  * date for the assignment.
1451  * @param p_planned_valid_to_date This specifies the planned end date
1452  * of the contract.
1453  * @param p_contract_type_change_date This specifies the date on which
1454  * the contract type is changed.
1455  * @param p_date_contract_signed This specifies the date on which
1456  * the contract is signed.
1457  * @param p_notice_period_date This specifies the date on which notice is
1458  * given to end the contract.
1459  * @param p_notice_period_end_date This is the specified date on
1460  * which contract will end.
1461  * @param p_concat_segments Concatenated segments for Soft Coded Key Flexfield.
1462  * Concatenated segments can be supplied instead of individual segments.
1463  * @param p_contract_id Contract associated with this assignment.
1464  * @param p_establishment_id This identifies the establishment Legal Entity for
1465  * this assignment.
1466  * @param p_collective_agreement_id Collective Agreement that applies to this
1467  * assignment.
1468  * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
1469  * flexfield to use for this assignment.
1470  * @param p_cag_segment1 CAGR Key Flexfield segment.
1471  * @param p_cag_segment2 CAGR Key Flexfield segment.
1472  * @param p_cag_segment3 CAGR Key Flexfield segment.
1473  * @param p_cag_segment4 CAGR Key Flexfield segment.
1474  * @param p_cag_segment5 CAGR Key Flexfield segment.
1475  * @param p_cag_segment6 CAGR Key Flexfield segment.
1476  * @param p_cag_segment7 CAGR Key Flexfield segment.
1477  * @param p_cag_segment8 CAGR Key Flexfield segment.
1478  * @param p_cag_segment9 CAGR Key Flexfield segment.
1479  * @param p_cag_segment10 CAGR Key Flexfield segment.
1480  * @param p_cag_segment11 CAGR Key Flexfield segment.
1481  * @param p_cag_segment12 CAGR Key Flexfield segment.
1482  * @param p_cag_segment13 CAGR Key Flexfield segment.
1483  * @param p_cag_segment14 CAGR Key Flexfield segment.
1484  * @param p_cag_segment15 CAGR Key Flexfield segment.
1485  * @param p_cag_segment16 CAGR Key Flexfield segment.
1486  * @param p_cag_segment17 CAGR Key Flexfield segment.
1487  * @param p_cag_segment18 CAGR Key Flexfield segment.
1488  * @param p_cag_segment19 CAGR Key Flexfield segment.
1489  * @param p_cag_segment20 CAGR Key Flexfield segment.
1490  * @param p_notice_period Length of notice period.
1491  * @param p_notice_period_uom Units for notice period. Valid values are defined
1492  * in the 'QUALIFYING_UNITS' lookup type.
1493  * @param p_employee_category Employee Category of the assignment. Valid values
1494  * are defined in the 'EMPLOYEE_CATG' lookup type.
1495  * @param p_work_at_home Indicates working from home. Valid values are defined
1496  * in the 'YES_NO' lookup type.
1497  * @param p_job_post_source_name Name of the source of the job posting that was
1498  * answered for this assignment.
1499  * @param p_supervisor_assignment_id Supervisor's assignment identification
1500  * that is responsible for supervising this assignment.
1501  * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
1502  * identifies an existing CAGR Key Flexfield combination to associate with the
1503  * assignment, and the segment values are ignored. If a value is not passed in,
1504  * then the individual CAGR Key Flexfield segments supplied will be used to
1505  * choose an existing combination or create a new combination. When the API
1506  * completes, if p_validate is false, then this uniquely identifies the
1507  * associated combination of the CAGR Key flexfield for this assignment. If
1508  * p_validate is true, then set to null.
1509  * @param p_cagr_concatenated_segments CAGR Key Flexfield concatenated
1510  * segments.
1511  * @param p_concatenated_segments If p_validate is false, set to Soft Coded Key
1512  * Flexfield concatenated segments, if p_validate is true, set to null.
1513  * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
1514  * it identifies an existing Soft Coded Key Flexfield combination to associate
1515  * with the assignment, and segment values are ignored. If a value is not
1516  * passed in, then the individual Soft Coded Key Flexfield segments supplied
1517  * will be used to choose an existing combination or create a new combination.
1518  * When the API completes, if p_validate is false, then this uniquely
1519  * identifies the associated combination of the Soft Coded Key flexfield for
1520  * this assignment. If p_validate is true, then set to null.
1521  * @param p_comment_id If p_validate is false and comment text was provided,
1522  * then will be set to the identifier of the created assignment comment record.
1523  * @param p_effective_start_date If p_validate is false, then set to the
1524  * effective start date on the updated assignment row which now exists as of
1525  * the effective date. If p_validate is true, then set to null.
1526  * @param p_effective_end_date If p_validate is false, then set to the
1527  * effective end date on the updated assignment row which now exists as of the
1528  * effective date. If p_validate is true, then set to null.
1529  * @param p_no_managers_warning Set to true if as a result of the update there
1530  * is no manager in the organization. Otherwise set to false.
1531  * @param p_other_manager_warning If set to true, then a manager existed in the
1532  * organization prior to calling this API and the manager flag has been set to
1533  * 'Y' for yes.
1534  * @param p_hourly_salaried_warning Set to true if values entered for Salary
1535  * Basis and Hourly Salaried Code are invalid as of the effective date.
1536  * @param p_gsp_post_process_warning Set to the name of the warning message
1537  * from the Message Dictionary if any Grade Ladder related errors have been
1538  * encountered while running this API.
1539  * @rep:displayname Updates Employee Assignment for Poland
1540  * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
1541  * @rep:lifecycle active
1542  * @rep:primaryinstance
1543  * @rep:scope public
1544  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1545 */
1546 --
1547 -- {End Of Comments}
1548 --
1549 procedure update_pl_emp_asg
1550   (p_validate                     in     boolean  default false
1551   ,p_effective_date               in     date
1552   ,p_datetrack_update_mode        in     varchar2
1553   ,p_assignment_id                in     number
1554   ,p_object_version_number        in out nocopy number
1555   ,p_supervisor_id                in     number   default hr_api.g_number
1556   ,p_assignment_number            in     varchar2 default hr_api.g_varchar2
1557   ,p_change_reason                in     varchar2 default hr_api.g_varchar2
1558   ,p_assignment_status_type_id    in     number   default hr_api.g_number
1559   ,p_comments                     in     varchar2 default hr_api.g_varchar2
1560   ,p_date_probation_end           in     date     default hr_api.g_date
1561   ,p_default_code_comb_id         in     number   default hr_api.g_number
1562   ,p_frequency                    in     varchar2 default hr_api.g_varchar2
1563   ,p_internal_address_line        in     varchar2 default hr_api.g_varchar2
1564   ,p_manager_flag                 in     varchar2 default hr_api.g_varchar2
1565   ,p_normal_hours                 in     number   default hr_api.g_number
1566   ,p_perf_review_period           in     number   default hr_api.g_number
1567   ,p_perf_review_period_frequency in     varchar2 default hr_api.g_varchar2
1568   ,p_probation_period             in     number   default hr_api.g_number
1569   ,p_probation_unit               in     varchar2 default hr_api.g_varchar2
1570   ,p_sal_review_period            in     number   default hr_api.g_number
1571   ,p_sal_review_period_frequency  in     varchar2 default hr_api.g_varchar2
1572   ,p_set_of_books_id              in     number   default hr_api.g_number
1573   ,p_source_type                  in     varchar2 default hr_api.g_varchar2
1574   ,p_time_normal_finish           in     varchar2 default hr_api.g_varchar2
1575   ,p_time_normal_start            in     varchar2 default hr_api.g_varchar2
1576   ,p_bargaining_unit_code         in     varchar2 default hr_api.g_varchar2
1577   ,p_labour_union_member_flag     in     varchar2 default hr_api.g_varchar2
1578   ,p_hourly_salaried_code         in     varchar2 default hr_api.g_varchar2
1579   ,p_ass_attribute_category       in     varchar2 default hr_api.g_varchar2
1580   ,p_ass_attribute1               in     varchar2 default hr_api.g_varchar2
1581   ,p_ass_attribute2               in     varchar2 default hr_api.g_varchar2
1582   ,p_ass_attribute3               in     varchar2 default hr_api.g_varchar2
1583   ,p_ass_attribute4               in     varchar2 default hr_api.g_varchar2
1584   ,p_ass_attribute5               in     varchar2 default hr_api.g_varchar2
1585   ,p_ass_attribute6               in     varchar2 default hr_api.g_varchar2
1586   ,p_ass_attribute7               in     varchar2 default hr_api.g_varchar2
1587   ,p_ass_attribute8               in     varchar2 default hr_api.g_varchar2
1588   ,p_ass_attribute9               in     varchar2 default hr_api.g_varchar2
1589   ,p_ass_attribute10              in     varchar2 default hr_api.g_varchar2
1590   ,p_ass_attribute11              in     varchar2 default hr_api.g_varchar2
1591   ,p_ass_attribute12              in     varchar2 default hr_api.g_varchar2
1592   ,p_ass_attribute13              in     varchar2 default hr_api.g_varchar2
1593   ,p_ass_attribute14              in     varchar2 default hr_api.g_varchar2
1594   ,p_ass_attribute15              in     varchar2 default hr_api.g_varchar2
1595   ,p_ass_attribute16              in     varchar2 default hr_api.g_varchar2
1596   ,p_ass_attribute17              in     varchar2 default hr_api.g_varchar2
1597   ,p_ass_attribute18              in     varchar2 default hr_api.g_varchar2
1598   ,p_ass_attribute19              in     varchar2 default hr_api.g_varchar2
1599   ,p_ass_attribute20              in     varchar2 default hr_api.g_varchar2
1600   ,p_ass_attribute21              in     varchar2 default hr_api.g_varchar2
1601   ,p_ass_attribute22              in     varchar2 default hr_api.g_varchar2
1602   ,p_ass_attribute23              in     varchar2 default hr_api.g_varchar2
1603   ,p_ass_attribute24              in     varchar2 default hr_api.g_varchar2
1604   ,p_ass_attribute25              in     varchar2 default hr_api.g_varchar2
1605   ,p_ass_attribute26              in     varchar2 default hr_api.g_varchar2
1606   ,p_ass_attribute27              in     varchar2 default hr_api.g_varchar2
1607   ,p_ass_attribute28              in     varchar2 default hr_api.g_varchar2
1608   ,p_ass_attribute29              in     varchar2 default hr_api.g_varchar2
1609   ,p_ass_attribute30              in     varchar2 default hr_api.g_varchar2
1610   ,p_title                        in     varchar2 default hr_api.g_varchar2
1611   ,p_contract_category            in     varchar2 default hr_api.g_varchar2
1612   ,p_contract_type                in     varchar2 default hr_api.g_varchar2
1613   ,p_contract_number              in     varchar2 default hr_api.g_varchar2
1614   ,p_change_of_contract_reason    in     varchar2 default hr_api.g_varchar2
1615   ,p_job                          in     varchar2 default hr_api.g_varchar2
1616   ,p_work_in_special_condition    in     varchar2 default hr_api.g_varchar2
1617   ,p_end_of_contract_addl_details in     varchar2 default hr_api.g_varchar2
1618   ,p_contract_start_date          in     varchar2 default hr_api.g_varchar2
1619   ,p_planned_valid_to_date        in     varchar2 default hr_api.g_varchar2
1620   ,p_contract_type_change_date    in     varchar2 default hr_api.g_varchar2
1621   ,p_date_contract_signed         in     varchar2 default hr_api.g_varchar2
1622   ,p_notice_period_date           in     varchar2 default hr_api.g_varchar2
1623   ,p_notice_period_end_date       in     varchar2 default hr_api.g_varchar2
1624   ,p_concat_segments              in     varchar2 default hr_api.g_varchar2
1625   ,p_contract_id                  in     number default hr_api.g_number
1626   ,p_establishment_id             in     number default hr_api.g_number
1627   ,p_collective_agreement_id      in     number default hr_api.g_number
1628   ,p_cagr_id_flex_num             in     number default hr_api.g_number
1629   ,p_cag_segment1                 in     varchar2 default hr_api.g_varchar2
1630   ,p_cag_segment2                 in     varchar2 default hr_api.g_varchar2
1631   ,p_cag_segment3                 in     varchar2 default hr_api.g_varchar2
1632   ,p_cag_segment4                 in     varchar2 default hr_api.g_varchar2
1633   ,p_cag_segment5                 in     varchar2 default hr_api.g_varchar2
1634   ,p_cag_segment6                 in     varchar2 default hr_api.g_varchar2
1635   ,p_cag_segment7                 in     varchar2 default hr_api.g_varchar2
1636   ,p_cag_segment8                 in     varchar2 default hr_api.g_varchar2
1637   ,p_cag_segment9                 in     varchar2 default hr_api.g_varchar2
1638   ,p_cag_segment10                in     varchar2 default hr_api.g_varchar2
1639   ,p_cag_segment11                in     varchar2 default hr_api.g_varchar2
1640   ,p_cag_segment12                in     varchar2 default hr_api.g_varchar2
1641   ,p_cag_segment13                in     varchar2 default hr_api.g_varchar2
1642   ,p_cag_segment14                in     varchar2 default hr_api.g_varchar2
1643   ,p_cag_segment15                in     varchar2 default hr_api.g_varchar2
1644   ,p_cag_segment16                in     varchar2 default hr_api.g_varchar2
1645   ,p_cag_segment17                in     varchar2 default hr_api.g_varchar2
1646   ,p_cag_segment18                in     varchar2 default hr_api.g_varchar2
1647   ,p_cag_segment19                in     varchar2 default hr_api.g_varchar2
1648   ,p_cag_segment20                in     varchar2 default hr_api.g_varchar2
1649   ,p_notice_period		  in     number   default hr_api.g_number
1650   ,p_notice_period_uom	      	  in     varchar2 default hr_api.g_varchar2
1651   ,p_employee_category	          in     varchar2 default hr_api.g_varchar2
1652   ,p_work_at_home		  in     varchar2 default hr_api.g_varchar2
1653   ,p_job_post_source_name	  in     varchar2 default hr_api.g_varchar2
1654   ,p_supervisor_assignment_id     in     number   default hr_api.g_number
1655   ,p_cagr_grade_def_id            in out nocopy number
1656   ,p_cagr_concatenated_segments      out nocopy varchar2
1657   ,p_concatenated_segments           out nocopy varchar2
1658   ,p_soft_coding_keyflex_id       in out nocopy number
1659   ,p_comment_id                      out nocopy number
1660   ,p_effective_start_date            out nocopy date
1661   ,p_effective_end_date              out nocopy date
1662   ,p_no_managers_warning             out nocopy boolean
1663   ,p_other_manager_warning           out nocopy boolean
1664   ,p_hourly_salaried_warning         out nocopy boolean
1665   ,p_gsp_post_process_warning        out nocopy varchar2
1666   );
1667 
1668 
1669 END hr_pl_assignment_api;