DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_PL_CONTINGENT_WORKER_API

Source


1 Package body hr_pl_contingent_worker_api as
2 /* $Header: pecwkpli.pkb 120.1 2005/09/26 23:58:39 mseshadr noship $ */
3 --
4 --   package variables
5 g_package  varchar2(33);
6 
7 /*old procedure*/
8 procedure create_pl_cwk
9   (p_validate                      in     boolean  default false
10   ,p_start_date                    in     date
11   ,p_business_group_id             in     number
12   ,p_last_name               in     varchar2
13   ,p_person_type_id                in     number   default null
14   ,p_npw_number                    in out nocopy varchar2
15   ,p_background_check_status       in     varchar2 default null
16   ,p_background_date_check         in     date     default null
17   ,p_blood_type                    in     varchar2 default null
18   ,p_comments                      in     varchar2 default null
19   ,p_correspondence_language       in     varchar2 default null
20   ,p_country_of_birth              in     varchar2 default null
21   ,p_date_of_birth                 in     date     default null
22   ,p_date_of_death                 in     date     default null
23   ,p_dpdnt_adoption_date           in     date     default null
24   ,p_dpdnt_vlntry_svce_flag        in     varchar2 default null
25   ,p_email_address                 in     varchar2 default null
26   ,p_first_name                    in     varchar2
27   ,p_fte_capacity                  in     number   default null
28   ,p_honors                        in     varchar2 default null
29   ,p_internal_location             in     varchar2 default null
30   ,p_preferred_name                in     varchar2 default null
31   ,p_last_medical_test_by          in     varchar2 default null
32   ,p_last_medical_test_date        in     date     default null
33   ,p_mailstop                      in     varchar2 default null
34   ,p_marital_status                in     varchar2 default null
35   ,p_middle_names                  in     varchar2 default null
36   ,p_pesel_number                  in     varchar2 default null
37   ,p_nationality                   in     varchar2 default null
38   ,p_office_number                 in     varchar2 default null
39   ,p_on_military_service           in     varchar2 default null
40   ,p_party_id                      in     number   default null
41   ,p_prefix                        in     varchar2 default null
42   ,p_maiden_name                   in     varchar2 default null
43   ,p_projected_placement_end       in     date     default null
44   ,p_receipt_of_death_cert_date    in     date     default null
45   ,p_region_of_birth               in     varchar2 default null
46   ,p_registered_disabled_flag      in     varchar2 default null
47   ,p_resume_exists                 in     varchar2 default null
48   ,p_resume_last_updated           in     date     default null
49   ,p_second_passport_exists        in     varchar2 default null
50   ,p_sex                           in     varchar2 default null
51   ,p_student_status                in     varchar2 default null
52   ,p_suffix                        in     varchar2 default null
53   ,p_title                         in     varchar2 default null
54   ,p_town_of_birth                 in     varchar2 default null
55   ,p_uses_tobacco_flag             in     varchar2 default null
56   ,p_vendor_id                     in     number   default null
57   ,p_work_schedule                 in     varchar2 default null
58   ,p_work_telephone                in     varchar2 default null
59   ,p_exp_check_send_to_address     in     varchar2 default null
60   ,p_hold_applicant_date_until     in     date     default null
61   ,p_date_employee_data_verified   in     date     default null
62   ,p_benefit_group_id              in     number   default null
63   ,p_coord_ben_med_pln_no          in     varchar2 default null
64   ,p_coord_ben_no_cvg_flag         in     varchar2 default null
65   ,p_original_date_of_hire         in     date     default null
66   ,p_attribute_category            in     varchar2 default null
67   ,p_attribute1                    in     varchar2 default null
68   ,p_attribute2                    in     varchar2 default null
69   ,p_attribute3                    in     varchar2 default null
70   ,p_attribute4                    in     varchar2 default null
71   ,p_attribute5                    in     varchar2 default null
72   ,p_attribute6                    in     varchar2 default null
73   ,p_attribute7                    in     varchar2 default null
74   ,p_attribute8                    in     varchar2 default null
75   ,p_attribute9                    in     varchar2 default null
76   ,p_attribute10                   in     varchar2 default null
77   ,p_attribute11                   in     varchar2 default null
78   ,p_attribute12                   in     varchar2 default null
79   ,p_attribute13                   in     varchar2 default null
80   ,p_attribute14                   in     varchar2 default null
81   ,p_attribute15                   in     varchar2 default null
82   ,p_attribute16                   in     varchar2 default null
83   ,p_attribute17                   in     varchar2 default null
84   ,p_attribute18                   in     varchar2 default null
85   ,p_attribute19                   in     varchar2 default null
86   ,p_attribute20                   in     varchar2 default null
87   ,p_attribute21                   in     varchar2 default null
88   ,p_attribute22                   in     varchar2 default null
89   ,p_attribute23                   in     varchar2 default null
90   ,p_attribute24                   in     varchar2 default null
91   ,p_attribute25                   in     varchar2 default null
92   ,p_attribute26                   in     varchar2 default null
93   ,p_attribute27                   in     varchar2 default null
94   ,p_attribute28                   in     varchar2 default null
95   ,p_attribute29                   in     varchar2 default null
96   ,p_attribute30                   in     varchar2 default null
97   ,p_per_information_category      in     varchar2 default null
98   ,p_nip_number                    in     varchar2 default null
99   ,p_per_information2              in     varchar2 default null
100   ,p_per_information3              in     varchar2 default null
101   ,p_per_information4              in     varchar2 default null
102   ,p_per_information5              in     varchar2 default null
103   ,p_per_information6              in     varchar2 default null
104   ,p_per_information7              in     varchar2 default null
105   ,p_per_information8              in     varchar2 default null
106   ,p_per_information9              in     varchar2 default null
107   ,p_per_information10             in     varchar2 default null
108   ,p_per_information11             in     varchar2 default null
109   ,p_per_information12             in     varchar2 default null
110   ,p_per_information13             in     varchar2 default null
111   ,p_per_information14             in     varchar2 default null
112   ,p_per_information15             in     varchar2 default null
113   ,p_per_information16             in       varchar2 default null
114   ,p_per_information17             in       varchar2 default null
115   ,p_per_information18             in       varchar2 default null
116   ,p_per_information19             in       varchar2 default null
117   ,p_per_information20             in       varchar2 default null
118   ,p_per_information21             in       varchar2 default null
119   ,p_per_information22             in       varchar2 default null
120   ,p_per_information23             in       varchar2 default null
121   ,p_per_information24             in       varchar2 default null
122   ,p_per_information25             in       varchar2 default null
123   ,p_per_information26             in       varchar2 default null
124   ,p_per_information27             in       varchar2 default null
125   ,p_per_information28             in       varchar2 default null
126   ,p_per_information29             in       varchar2 default null
127   ,p_per_information30             in       varchar2 default null
128   ,p_person_id                        out nocopy   number
129   ,p_per_object_version_number        out nocopy   number
130   ,p_per_effective_start_date         out nocopy   date
131   ,p_per_effective_end_date           out nocopy   date
132   ,p_pdp_object_version_number        out nocopy   number
133   ,p_full_name                        out nocopy   varchar2
134   ,p_comment_id                       out nocopy   number
135   ,p_assignment_id                    out nocopy   number
136   ,p_asg_object_version_number        out nocopy   number
137   ,p_assignment_sequence              out nocopy   number
138   ,p_assignment_number                out nocopy   varchar2
139   ,p_name_combination_warning         out nocopy   boolean
140   ) is
141 
142   -- Declare cursors and local variables
143   --
144   l_proc                 varchar2(72);
145   l_legislation_code     varchar2(2);
146   --
147   cursor csr_bg is
148     select legislation_code
149     from per_business_groups pbg
150     where pbg.business_group_id = p_business_group_id;
151   --
152 begin
153 g_package := 'hr_pl_contingent_worker_api.';
154 l_proc    := g_package||'create_pl_cwk old';
155   hr_utility.set_location('Entering:'|| l_proc, 5);
156   --
157     -- Check that the specified business group is valid.
158   --
159 /* 4340576 Replace code with call to new overloaded procedure
160 
161   open csr_bg;
162   fetch csr_bg
163   into l_legislation_code;
164   if csr_bg%notfound then
165     close csr_bg;
166     hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
167     hr_utility.raise_error;
168   end if;
169   close csr_bg;
170   --
171   -- Check that the legislation of the specified business group is 'PL'.
172   --
173   if l_legislation_code <> 'PL' then
174     hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
175     hr_utility.set_message_token('LEG_CODE','PL');
176     hr_utility.raise_error;
177   end if;
178 
179 
180   hr_utility.set_location(l_proc, 6);
181 
182 
183   --
184   -- Call the person business process
185 hr_contingent_worker_api.create_cwk */
186 
187 
188  hr_pl_contingent_worker_api.create_pl_cwk
189   (p_validate                      =>p_validate
190   ,p_start_date                    =>p_start_date
191   ,p_business_group_id             =>p_business_group_id
192   ,p_last_name                     =>p_last_name
193   ,p_person_type_id                =>p_person_type_id
194   ,p_npw_number                    =>p_npw_number
195   ,p_background_check_status       =>p_background_check_status
196   ,p_background_date_check         =>p_background_date_check
197   ,p_blood_type                    =>p_blood_type
198   ,p_comments                      =>p_comments
199   ,p_correspondence_language       =>p_correspondence_language
200   ,p_country_of_birth              =>p_country_of_birth
201   ,p_date_of_birth                 =>p_date_of_birth
202   ,p_date_of_death                 =>p_date_of_death
203   ,p_dpdnt_adoption_date           =>p_dpdnt_adoption_date
204   ,p_dpdnt_vlntry_svce_flag        =>p_dpdnt_vlntry_svce_flag
205   ,p_email_address                 =>p_email_address
206   ,p_first_name                    =>p_first_name
207   ,p_fte_capacity                  =>p_fte_capacity
208   ,p_honors                        =>p_honors
209   ,p_internal_location             =>p_internal_location
210   ,p_preferred_name                =>p_preferred_name
211   ,p_last_medical_test_by          =>p_last_medical_test_by
212   ,p_last_medical_test_date        =>p_last_medical_test_date
213   ,p_mailstop                      =>p_mailstop
214   ,p_marital_status                =>p_marital_status
215   ,p_middle_names                  =>p_middle_names
216   ,p_pesel                         =>p_pesel_number
217   ,p_nationality                   =>p_nationality
218   ,p_office_number                 =>p_office_number
219   ,p_on_military_service           =>p_on_military_service
220   ,p_party_id                      =>p_party_id
221   ,p_prefix                        =>p_prefix
222   ,p_maiden_name                   =>p_maiden_name
223   ,p_projected_placement_end       =>p_projected_placement_end
224   ,p_receipt_of_death_cert_date    =>p_receipt_of_death_cert_date
225   ,p_region_of_birth               =>p_region_of_birth
226   ,p_registered_disabled_flag      =>p_registered_disabled_flag
227   ,p_resume_exists                 =>p_resume_exists
228   ,p_resume_last_updated           =>p_resume_last_updated
229   ,p_second_passport_exists        =>p_second_passport_exists
230   ,p_sex                           =>p_sex
231   ,p_student_status                =>p_student_status
232   ,p_suffix                        =>p_suffix
233   ,p_title                         =>p_title
234   ,p_town_of_birth                 =>p_town_of_birth
235   ,p_uses_tobacco_flag             =>p_uses_tobacco_flag
236   ,p_vendor_id                     =>p_vendor_id
237   ,p_work_schedule                 =>p_work_schedule
238   ,p_work_telephone                =>p_work_telephone
239   ,p_exp_check_send_to_address     =>p_exp_check_send_to_address
240   ,p_hold_applicant_date_until     =>p_hold_applicant_date_until
241   ,p_date_employee_data_verified   =>p_date_employee_data_verified
242   ,p_benefit_group_id              =>p_benefit_group_id
243   ,p_coord_ben_med_pln_no          =>p_coord_ben_med_pln_no
244   ,p_coord_ben_no_cvg_flag         =>p_coord_ben_no_cvg_flag
245   ,p_original_date_of_hire         =>p_original_date_of_hire
246   ,p_attribute_category            =>p_attribute_category
247   ,p_attribute1                    =>p_attribute1
248   ,p_attribute2                    =>p_attribute2
249   ,p_attribute3                    =>p_attribute3
250   ,p_attribute4                    =>p_attribute4
251   ,p_attribute5                    =>p_attribute5
252   ,p_attribute6                    =>p_attribute6
253   ,p_attribute7                    =>p_attribute7
254   ,p_attribute8                    =>p_attribute8
255   ,p_attribute9                    =>p_attribute9
256   ,p_attribute10                   =>p_attribute10
257   ,p_attribute11                   =>p_attribute11
258   ,p_attribute12                   =>p_attribute12
259   ,p_attribute13                   =>p_attribute13
260   ,p_attribute14                   =>p_attribute14
261   ,p_attribute15                   =>p_attribute15
262   ,p_attribute16                   =>p_attribute16
263   ,p_attribute17                   =>p_attribute17
264   ,p_attribute18                   =>p_attribute18
265   ,p_attribute19                   =>p_attribute19
266   ,p_attribute20                   =>p_attribute20
267   ,p_attribute21                   =>p_attribute21
268   ,p_attribute22                   =>p_attribute22
269   ,p_attribute23                   =>p_attribute23
270   ,p_attribute24                   =>p_attribute24
271   ,p_attribute25                   =>p_attribute25
272   ,p_attribute26                   =>p_attribute26
273   ,p_attribute27                   =>p_attribute27
274   ,p_attribute28                   =>p_attribute28
275   ,p_attribute29                   =>p_attribute29
276   ,p_attribute30                   =>p_attribute30
277   ,p_per_information_category      =>p_per_information_category
278   ,p_nip                           =>p_nip_number
279   ,p_oldage_pension_rights         =>p_per_information4
280   ,p_national_fund_of_health       =>p_per_information5
281   ,p_tax_office                    =>p_per_information6
282   ,p_legal_employer                =>p_per_information7
283   ,p_citizenship                   =>p_per_information8
284   ,p_person_id                     =>p_person_id
285   ,p_per_object_version_number     =>p_per_object_version_number
286   ,p_per_effective_start_date      =>p_per_effective_start_date
287   ,p_per_effective_end_date        =>p_per_effective_end_date
288   ,p_pdp_object_version_number     =>p_pdp_object_version_number
289   ,p_full_name                     =>p_full_name
290   ,p_comment_id                    =>p_comment_id
291   ,p_assignment_id                 =>p_assignment_id
292   ,p_asg_object_version_number     =>p_asg_object_version_number
293   ,p_assignment_sequence           =>p_assignment_sequence
294   ,p_assignment_number             =>p_assignment_number
295   ,p_name_combination_warning      =>p_name_combination_warning
296   );
297 --
298 hr_utility.set_location('Leaving: '|| l_proc, 15);
299 End create_pl_cwk;
300 --
301 
302 /*New overloaded Procedure*/
303 procedure create_pl_cwk
304   (p_validate                      in     boolean  default false
305   ,p_start_date                    in     date
306   ,p_business_group_id             in     number
307   ,p_last_name                     in     varchar2
308   ,p_person_type_id                in     number   default null
309   ,p_npw_number                    in out nocopy varchar2
310   ,p_background_check_status       in     varchar2 default null
311   ,p_background_date_check         in     date     default null
312   ,p_blood_type                    in     varchar2 default null
313   ,p_comments                      in     varchar2 default null
314   ,p_correspondence_language       in     varchar2 default null
315   ,p_country_of_birth              in     varchar2 default null
316   ,p_date_of_birth                 in     date     default null
317   ,p_date_of_death                 in     date     default null
318   ,p_dpdnt_adoption_date           in     date     default null
319   ,p_dpdnt_vlntry_svce_flag        in     varchar2 default null
320   ,p_email_address                 in     varchar2 default null
321   ,p_first_name                    in     varchar2
322   ,p_fte_capacity                  in     number   default null
323   ,p_honors                        in     varchar2 default null
324   ,p_internal_location             in     varchar2 default null
325   ,p_preferred_name                in     varchar2 default null
326   ,p_last_medical_test_by          in     varchar2 default null
327   ,p_last_medical_test_date        in     date     default null
328   ,p_mailstop                      in     varchar2 default null
329   ,p_marital_status                in     varchar2 default null
330   ,p_middle_names                  in     varchar2 default null
331   ,p_pesel                         in     varchar2 default null
332   ,p_nationality                   in     varchar2 default null
333   ,p_office_number                 in     varchar2 default null
334   ,p_on_military_service           in     varchar2 default null
335   ,p_party_id                      in     number   default null
336   ,p_prefix                        in     varchar2 default null
337   ,p_maiden_name                   in     varchar2 default null
338   ,p_projected_placement_end       in     date     default null
339   ,p_receipt_of_death_cert_date    in     date     default null
340   ,p_region_of_birth               in     varchar2 default null
341   ,p_registered_disabled_flag      in     varchar2 default null
342   ,p_resume_exists                 in     varchar2 default null
343   ,p_resume_last_updated           in     date     default null
344   ,p_second_passport_exists        in     varchar2 default null
345   ,p_sex                           in     varchar2 default null
346   ,p_student_status                in     varchar2 default null
347   ,p_suffix                        in     varchar2 default null
348   ,p_title                         in     varchar2 default null
349   ,p_town_of_birth                 in     varchar2 default null
350   ,p_uses_tobacco_flag             in     varchar2 default null
351   ,p_vendor_id                     in     number   default null
352   ,p_work_schedule                 in     varchar2 default null
353   ,p_work_telephone                in     varchar2 default null
354   ,p_exp_check_send_to_address     in     varchar2 default null
355   ,p_hold_applicant_date_until     in     date     default null
356   ,p_date_employee_data_verified   in     date     default null
357   ,p_benefit_group_id              in     number   default null
358   ,p_coord_ben_med_pln_no          in     varchar2 default null
359   ,p_coord_ben_no_cvg_flag         in     varchar2 default null
360   ,p_original_date_of_hire         in     date     default null
361   ,p_attribute_category            in     varchar2 default null
362   ,p_attribute1                    in     varchar2 default null
363   ,p_attribute2                    in     varchar2 default null
364   ,p_attribute3                    in     varchar2 default null
365   ,p_attribute4                    in     varchar2 default null
366   ,p_attribute5                    in     varchar2 default null
367   ,p_attribute6                    in     varchar2 default null
368   ,p_attribute7                    in     varchar2 default null
369   ,p_attribute8                    in     varchar2 default null
370   ,p_attribute9                    in     varchar2 default null
371   ,p_attribute10                   in     varchar2 default null
372   ,p_attribute11                   in     varchar2 default null
373   ,p_attribute12                   in     varchar2 default null
374   ,p_attribute13                   in     varchar2 default null
375   ,p_attribute14                   in     varchar2 default null
376   ,p_attribute15                   in     varchar2 default null
377   ,p_attribute16                   in     varchar2 default null
378   ,p_attribute17                   in     varchar2 default null
379   ,p_attribute18                   in     varchar2 default null
380   ,p_attribute19                   in     varchar2 default null
381   ,p_attribute20                   in     varchar2 default null
382   ,p_attribute21                   in     varchar2 default null
383   ,p_attribute22                   in     varchar2 default null
384   ,p_attribute23                   in     varchar2 default null
385   ,p_attribute24                   in     varchar2 default null
386   ,p_attribute25                   in     varchar2 default null
387   ,p_attribute26                   in     varchar2 default null
388   ,p_attribute27                   in     varchar2 default null
389   ,p_attribute28                   in     varchar2 default null
390   ,p_attribute29                   in     varchar2 default null
391   ,p_attribute30                   in     varchar2 default null
392   ,p_per_information_category      in     varchar2 default null
393   ,p_nip                           in     varchar2 default null
394   ,p_oldage_pension_rights         in     varchar2 default null
395   ,p_national_fund_of_health       in     varchar2 default null
396   ,p_tax_office                    in     varchar2 default null
397   ,p_legal_employer                in     varchar2 default null
398   ,p_citizenship                   in     varchar2 default null
399   ,p_person_id                        out nocopy   number
400   ,p_per_object_version_number        out nocopy   number
401   ,p_per_effective_start_date         out nocopy   date
402   ,p_per_effective_end_date           out nocopy   date
403   ,p_pdp_object_version_number        out nocopy   number
404   ,p_full_name                        out nocopy   varchar2
405   ,p_comment_id                       out nocopy   number
406   ,p_assignment_id                    out nocopy   number
407   ,p_asg_object_version_number        out nocopy   number
408   ,p_assignment_sequence              out nocopy   number
409   ,p_assignment_number                out nocopy   varchar2
410   ,p_name_combination_warning         out nocopy   boolean
411   ) is
412   l_proc                 varchar2(72);
413   l_legislation_code     varchar2(2);
414   --
415   cursor csr_bg is
416     select legislation_code
417     from per_business_groups pbg
418     where pbg.business_group_id = p_business_group_id;
419   --
420 begin
421 g_package := 'hr_pl_contingent_worker_api.';
422 l_proc    := g_package||'create_pl_cwk';
423   hr_utility.set_location('Entering:'|| l_proc, 5);
424   --
425     -- Check that the specified business group is valid.
426   --
427 
428 
429   open csr_bg;
430   fetch csr_bg
431   into l_legislation_code;
432   if csr_bg%notfound then
433     close csr_bg;
434     hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
435     hr_utility.raise_error;
436   end if;
437   close csr_bg;
438   --
439   -- Check that the legislation of the specified business group is 'PL'.
440   --
441   if l_legislation_code <> 'PL' then
442     hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
443     hr_utility.set_message_token('LEG_CODE','PL');
444     hr_utility.raise_error;
445   end if;
446 
447 
448   hr_utility.set_location(l_proc, 6);
449 
450 
451   --
452   -- Call the person business process
453 hr_contingent_worker_api.create_cwk
454 (p_validate                       => p_validate
455   ,p_start_date                   => p_start_date
456   ,p_business_group_id            => p_business_group_id
457   ,p_last_name                    => p_last_name
458   ,p_person_type_id               => p_person_type_id
459   ,p_npw_number                   => p_npw_number
460   ,p_background_check_status      => p_background_check_status
461   ,p_background_date_check        => p_background_date_check
462   ,p_blood_type                   => p_blood_type
463   ,p_comments                     => p_comments
464   ,p_correspondence_language      => p_correspondence_language
465   ,p_country_of_birth             => p_country_of_birth
466   ,p_date_of_birth                => p_date_of_birth
467   ,p_date_of_death                => p_date_of_death
468   ,p_dpdnt_adoption_date          => p_dpdnt_adoption_date
469   ,p_dpdnt_vlntry_svce_flag       => p_dpdnt_vlntry_svce_flag
470   ,p_email_address                => p_email_address
471   ,p_first_name                   => p_first_name
472   ,p_fte_capacity                 => p_fte_capacity
473   ,p_honors                       => p_honors
474   ,p_internal_location            => p_internal_location
475   ,p_known_As                     => p_preferred_name
476   ,p_last_medical_test_by         => p_last_medical_test_by
477   ,p_last_medical_test_date       => p_last_medical_test_date
478   ,p_mailstop                     => p_mailstop
479   ,p_marital_status               => p_marital_status
480   ,p_middle_names                 => p_middle_names
481   ,p_national_identifier          => p_pesel
482   ,p_nationality                  => p_nationality
483   ,p_office_number                => p_office_number
484   ,p_on_military_service          => p_on_military_service
485   ,p_party_id                     => p_party_id
486   ,p_pre_name_adjunct             => p_prefix
487   ,p_previous_last_name           => p_maiden_name
488   ,p_projected_placement_end      => p_projected_placement_end
489   ,p_receipt_of_death_cert_date   => p_receipt_of_death_cert_date
490   ,p_region_of_birth              => p_region_of_birth
491   ,p_registered_disabled_flag     => p_registered_disabled_flag
492   ,p_resume_exists                => p_resume_exists
493   ,p_resume_last_updated          => p_resume_last_updated
494   ,p_second_passport_exists       => p_second_passport_exists
495   ,p_sex                          => p_sex
496   ,p_student_status               => p_student_status
497   ,p_suffix                       => p_suffix
498   ,p_title                        => p_title
499   ,p_town_of_birth                => p_town_of_birth
500   ,p_uses_tobacco_flag            => p_uses_tobacco_flag
501   ,p_vendor_id                    => p_vendor_id
502   ,p_work_schedule                => p_work_schedule
503   ,p_work_telephone               => p_work_telephone
504   ,p_exp_check_send_to_address    => p_exp_check_send_to_address
505   ,p_hold_applicant_date_until    => p_hold_applicant_date_until
506   ,p_date_employee_data_verified  => p_date_employee_data_verified
507   ,p_benefit_group_id             => p_benefit_group_id
508   ,p_coord_ben_med_pln_no         => p_coord_ben_med_pln_no
509   ,p_coord_ben_no_cvg_flag        => p_coord_ben_no_cvg_flag
510   ,p_original_date_of_hire        => p_original_date_of_hire
511   ,p_attribute_category           => p_attribute_category
512   ,p_attribute1                   => p_attribute1
513   ,p_attribute2                   => p_attribute2
514   ,p_attribute3                   => p_attribute3
515   ,p_attribute4                   => p_attribute4
516   ,p_attribute5                   => p_attribute5
517   ,p_attribute6                   => p_attribute6
518   ,p_attribute7                   => p_attribute7
519   ,p_attribute8                   => p_attribute8
520   ,p_attribute9                   => p_attribute9
521   ,p_attribute10                  => p_attribute10
522   ,p_attribute11                  => p_attribute11
523   ,p_attribute12                  => p_attribute12
524   ,p_attribute13                  => p_attribute13
525   ,p_attribute14                  => p_attribute14
526   ,p_attribute15                  => p_attribute15
527   ,p_attribute16                  => p_attribute16
528   ,p_attribute17                  => p_attribute17
529   ,p_attribute18                  => p_attribute18
530   ,p_attribute19                  => p_attribute19
531   ,p_attribute20                  => p_attribute20
532   ,p_attribute21                  => p_attribute21
533   ,p_attribute22                  => p_attribute22
534   ,p_attribute23                  => p_attribute23
535   ,p_attribute24                  => p_attribute24
536   ,p_attribute25                  => p_attribute25
537   ,p_attribute26                  => p_attribute26
538   ,p_attribute27                  => p_attribute27
539   ,p_attribute28                  => p_attribute28
540   ,p_attribute29                  => p_attribute29
541   ,p_attribute30                  => p_attribute30
542   ,p_per_information_category     => 'PL'
543   ,p_per_information1             => p_nip
544   ,p_per_information4             => p_oldage_pension_rights
545   ,p_per_information5             => p_national_fund_of_health
546   ,p_per_information6             => p_tax_office
547   ,p_per_information7             => p_legal_employer
548   ,p_per_information8             => p_citizenship
549   ,p_person_id                    =>p_person_id
550   ,p_per_object_version_number    => p_per_object_version_number
551   ,p_per_effective_start_date     => p_per_effective_start_date
552   ,p_per_effective_end_date       => p_per_effective_end_date
553   ,p_pdp_object_version_number    => p_pdp_object_version_number
554   ,p_full_name                    => p_full_name
555   ,p_comment_id                   => p_comment_id
556   ,p_assignment_id                => p_assignment_id
557   ,p_asg_object_version_number    => p_asg_object_version_number
558   ,p_assignment_sequence          => p_assignment_sequence
559   ,p_assignment_number            => p_assignment_number
560   ,p_name_combination_warning     => p_name_combination_warning
561   );
562 
563 
564 End create_pl_cwk;
565 End hr_pl_contingent_worker_api;
566