DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_PL_APPLICANT_API

Source


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