DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_NZ_APPLICANT_API

Source


1 PACKAGE BODY hr_nz_applicant_api AS
2 /* $Header: hrnzwrap.pkb 120.2 2005/10/05 22:25:40 rpalli noship $ */
3 
4   -- Package Variables
5   --
6   g_package  VARCHAR2(33) := 'hr_nz_applicant_api.';
7 
8   ------------------------------------------------------------
9   -- Private Procedures
10   ------------------------------------------------------------
11 
12 
13   ------------------------------------------------------------
14   --  Private Functions
15   ------------------------------------------------------------
16 
17   ------------------------------------------------------------
18   -- Public Procedures
19   ------------------------------------------------------------
20 
21 
22   ------------------------------------------------------------
23   -- create_nz_applicant
24   ------------------------------------------------------------
25 procedure create_nz_applicant
26   (p_validate                      IN     BOOLEAN  DEFAULT FALSE
27   ,p_date_received                 IN     DATE
28   ,p_business_group_id             IN     NUMBER
29   ,p_last_name                     IN     VARCHAR2
30   ,p_sex                           IN     VARCHAR2 DEFAULT NULL
31   ,p_person_type_id                IN     NUMBER   DEFAULT NULL
32   ,p_applicant_number              IN OUT NOCOPY VARCHAR2
33   ,p_comments                      IN     VARCHAR2 DEFAULT NULL
34   ,p_date_employee_data_verified   IN     DATE     DEFAULT NULL
35   ,p_date_of_birth                 IN     DATE     DEFAULT NULL
36   ,p_email_address                 IN     VARCHAR2 DEFAULT NULL
37   ,p_expense_check_send_to_addres  IN     VARCHAR2 DEFAULT NULL
38   ,p_first_name                    IN     VARCHAR2 DEFAULT NULL
39   ,p_known_as                      IN     VARCHAR2 DEFAULT NULL
40   ,p_marital_status                IN     VARCHAR2 DEFAULT NULL
41   ,p_middle_names                  IN     VARCHAR2 DEFAULT NULL
42   ,p_nationality                   IN     VARCHAR2 DEFAULT NULL
43   ,p_ird_number                    IN     VARCHAR2 DEFAULT NULL
44   ,p_previous_last_name            IN     VARCHAR2 DEFAULT NULL
45   ,p_registered_disabled_flag      IN     VARCHAR2 DEFAULT NULL
46   ,p_title                         IN     VARCHAR2 DEFAULT NULL
47   ,p_work_telephone                IN     VARCHAR2 DEFAULT NULL
48   ,p_attribute_category            IN     VARCHAR2 DEFAULT NULL
49   ,p_attribute1                    IN     VARCHAR2 DEFAULT NULL
50   ,p_attribute2                    IN     VARCHAR2 DEFAULT NULL
51   ,p_attribute3                    IN     VARCHAR2 DEFAULT NULL
52   ,p_attribute4                    IN     VARCHAR2 DEFAULT NULL
53   ,p_attribute5                    IN     VARCHAR2 DEFAULT NULL
54   ,p_attribute6                    IN     VARCHAR2 DEFAULT NULL
55   ,p_attribute7                    IN     VARCHAR2 DEFAULT NULL
56   ,p_attribute8                    IN     VARCHAR2 DEFAULT NULL
57   ,p_attribute9                    IN     VARCHAR2 DEFAULT NULL
58   ,p_attribute10                   IN     VARCHAR2 DEFAULT NULL
59   ,p_attribute11                   IN     VARCHAR2 DEFAULT NULL
60   ,p_attribute12                   IN     VARCHAR2 DEFAULT NULL
61   ,p_attribute13                   IN     VARCHAR2 DEFAULT NULL
62   ,p_attribute14                   IN     VARCHAR2 DEFAULT NULL
63   ,p_attribute15                   IN     VARCHAR2 DEFAULT NULL
64   ,p_attribute16                   IN     VARCHAR2 DEFAULT NULL
65   ,p_attribute17                   IN     VARCHAR2 DEFAULT NULL
66   ,p_attribute18                   IN     VARCHAR2 DEFAULT NULL
67   ,p_attribute19                   IN     VARCHAR2 DEFAULT NULL
68   ,p_attribute20                   IN     VARCHAR2 DEFAULT NULL
69   ,p_attribute21                   IN     VARCHAR2 DEFAULT NULL
70   ,p_attribute22                   IN     VARCHAR2 DEFAULT NULL
71   ,p_attribute23                   IN     VARCHAR2 DEFAULT NULL
72   ,p_attribute24                   IN     VARCHAR2 DEFAULT NULL
73   ,p_attribute25                   IN     VARCHAR2 DEFAULT NULL
74   ,p_attribute26                   IN     VARCHAR2 DEFAULT NULL
75   ,p_attribute27                   IN     VARCHAR2 DEFAULT NULL
76   ,p_attribute28                   IN     VARCHAR2 DEFAULT NULL
77   ,p_attribute29                   IN     VARCHAR2 DEFAULT NULL
78   ,p_attribute30                   IN     VARCHAR2 DEFAULT NULL
79   ,p_country_born           	   IN     VARCHAR2 DEFAULT NULL
80   ,p_work_permit_number			   IN     VARCHAR2 DEFAULT NULL
81   ,p_work_permit_expiry_date 	   IN     VARCHAR2 DEFAULT NULL
82   ,p_ethnic_origin 				   IN     VARCHAR2 DEFAULT NULL
83   ,p_tribal_group 				   IN     VARCHAR2 DEFAULT NULL
84   ,p_district_of_origin 		   IN     VARCHAR2 DEFAULT NULL
85   ,p_employment_category           IN     VARCHAR2 DEFAULT NULL
86   ,p_working_time                  IN     VARCHAR2 DEFAULT NULL
87   ,p_background_check_status       IN     VARCHAR2 DEFAULT NULL
88   ,p_background_date_check         IN     DATE     DEFAULT NULL
89   ,p_correspondence_language       IN     VARCHAR2 DEFAULT NULL
90   ,p_fte_capacity                  IN     NUMBER   DEFAULT NULL
91   ,p_hold_applicant_date_until     IN     DATE     DEFAULT NULL
92   ,p_honors                        IN     VARCHAR2 DEFAULT NULL
93   ,p_mailstop                      IN     VARCHAR2 DEFAULT NULL
94   ,p_office_number                 IN     VARCHAR2 DEFAULT NULL
95   ,p_on_military_service           IN     VARCHAR2 DEFAULT NULL
96   ,p_pre_name_adjunct              IN     VARCHAR2 DEFAULT NULL
97   ,p_projected_start_date          IN     DATE     DEFAULT NULL
98   ,p_resume_exists                 IN     VARCHAR2 DEFAULT NULL
99   ,p_resume_last_updated           IN     DATE     DEFAULT NULL
100   ,p_student_status                IN     VARCHAR2 DEFAULT NULL
101   ,p_work_schedule                 IN     VARCHAR2 DEFAULT NULL
102   ,p_suffix                        IN     VARCHAR2 DEFAULT NULL
103   ,p_date_of_death                 IN     DATE     DEFAULT NULL
104   ,p_benefit_group_id              IN     NUMBER   DEFAULT NULL
105   ,p_receipt_of_death_cert_date    IN     DATE     DEFAULT NULL
106   ,p_coord_ben_med_pln_no          IN     VARCHAR2 DEFAULT NULL
107   ,p_coord_ben_no_cvg_flag         IN     VARCHAR2 DEFAULT 'N'
108   ,p_uses_tobacco_flag             IN     VARCHAR2 DEFAULT NULL
109   ,p_dpdnt_adoption_date           IN     DATE     DEFAULT NULL
110   ,p_dpdnt_vlntry_svce_flag        IN     VARCHAR2 DEFAULT 'N'
111   ,p_original_date_of_hire         IN     DATE     DEFAULT NULL
112   ,p_town_of_birth                 IN     VARCHAR2 DEFAULT NULL
113   ,p_region_of_birth               IN     VARCHAR2 DEFAULT NULL
114   ,p_country_of_birth              IN     VARCHAR2 DEFAULT NULL
115   ,p_global_person_id              IN     VARCHAR2 DEFAULT NULL
116   ,p_party_id                      IN     NUMBER   DEFAULT NULL
117   ,p_vacancy_id                    IN     NUMBER   DEFAULT NULL
118   ,p_person_id                        OUT NOCOPY NUMBER
119   ,p_assignment_id                    OUT NOCOPY NUMBER
120   ,p_application_id                   OUT NOCOPY NUMBER
121   ,p_per_object_version_number        OUT NOCOPY NUMBER
122   ,p_asg_object_version_number        OUT NOCOPY NUMBER
123   ,p_apl_object_version_number        OUT NOCOPY NUMBER
124   ,p_per_effective_start_date         OUT NOCOPY DATE
125   ,p_per_effective_end_date           OUT NOCOPY DATE
126   ,p_full_name                        OUT NOCOPY VARCHAR2
127   ,p_per_comment_id                   OUT NOCOPY NUMBER
128   ,p_assignment_sequence              OUT NOCOPY NUMBER
129   ,p_name_combination_warning         OUT NOCOPY BOOLEAN
130   ,p_orig_hire_warning                OUT NOCOPY BOOLEAN
131   ) IS
132   --
133   -- Declare cursors and local variables
134   --
135   l_proc                 VARCHAR2(72) := g_package||'create_gb_applicant';
136   l_legislation_code     VARCHAR2(2);
137   --
138   CURSOR csr_bg IS
139     SELECT legislation_code
140     FROM per_business_groups pbg
141     WHERE pbg.business_group_id = p_business_group_id;
142   --
143 begin
144   hr_utility.set_location('Entering:'|| l_proc, 45);
145   --
146   -- Validation in addition to Table Handlers
147   --
148   -- Check that the specified business group is valid.
149   --
150   OPEN csr_bg;
151   FETCH csr_bg
152   INTO l_legislation_code;
153   IF csr_bg%notfound THEN
154     CLOSE csr_bg;
155     hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
156     hr_utility.raise_error;
157   END IF;
158   CLOSE csr_bg;
159   --
160   -- Check that the legislation of the specified business group is 'GB'.
161   --
162   IF l_legislation_code <> 'NZ' THEN
163     hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
164     hr_utility.set_message_token('LEG_CODE','GB');
165     hr_utility.raise_error;
166   END IF;
167 
168   hr_utility.set_location(l_proc, 50);
169   --
170   -- Call the person business process
171   --
172   hr_applicant_api.create_applicant
173   (p_validate                     => p_validate
174   ,p_date_received                => p_date_received
175   ,p_business_group_id            => p_business_group_id
176   ,p_last_name                    => p_last_name
177   ,p_sex                          => p_sex
178   ,p_person_type_id               => p_person_type_id
179   ,p_per_comments                 => p_comments
180   ,p_date_employee_data_verified  => p_date_employee_data_verified
181   ,p_date_of_birth                => p_date_of_birth
182   ,p_email_address                => p_email_address
183   ,p_applicant_number             => p_applicant_number
184   ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
185   ,p_first_name                   => p_first_name
186   ,p_known_as                     => p_known_as
187   ,p_marital_status               => p_marital_status
188   ,p_middle_names                 => p_middle_names
189   ,p_nationality                  => p_nationality
190   ,p_national_identifier          => p_ird_number
191   ,p_previous_last_name           => p_previous_last_name
192   ,p_registered_disabled_flag     => p_registered_disabled_flag
193   ,p_title                        => p_title
194   ,p_work_telephone               => p_work_telephone
195   ,p_attribute_category           => p_attribute_category
196   ,p_attribute1                   => p_attribute1
197   ,p_attribute2                   => p_attribute2
198   ,p_attribute3                   => p_attribute3
199   ,p_attribute4                   => p_attribute4
200   ,p_attribute5                   => p_attribute5
201   ,p_attribute6                   => p_attribute6
202   ,p_attribute7                   => p_attribute7
203   ,p_attribute8                   => p_attribute8
204   ,p_attribute9                   => p_attribute9
205   ,p_attribute10                  => p_attribute10
206   ,p_attribute11                  => p_attribute11
207   ,p_attribute12                  => p_attribute12
208   ,p_attribute13                  => p_attribute13
209   ,p_attribute14                  => p_attribute14
210   ,p_attribute15                  => p_attribute15
211   ,p_attribute16                  => p_attribute16
212   ,p_attribute17                  => p_attribute17
213   ,p_attribute18                  => p_attribute18
214   ,p_attribute19                  => p_attribute19
215   ,p_attribute20                  => p_attribute20
216   ,p_attribute21                  => p_attribute21
217   ,p_attribute22                  => p_attribute22
218   ,p_attribute23                  => p_attribute23
219   ,p_attribute24                  => p_attribute24
220   ,p_attribute25                  => p_attribute25
221   ,p_attribute26                  => p_attribute26
222   ,p_attribute27                  => p_attribute27
223   ,p_attribute28                  => p_attribute28
224   ,p_attribute29                  => p_attribute29
225   ,p_attribute30                  => p_attribute30
226   ,p_per_information_category     => 'NZ'
227   ,p_country_of_birth             => p_country_born
228   ,p_per_information2             => p_work_permit_number
229   ,p_per_information3             => p_work_permit_expiry_date
230   ,p_per_information4             => p_ethnic_origin
231   ,p_per_information5             => p_tribal_group
232   ,p_per_information6             => p_district_of_origin
233   ,p_per_information7             => p_employment_category
234   ,p_per_information8             => p_working_time
235   ,p_background_check_status      => p_background_check_status
236   ,p_background_date_check        => p_background_date_check
237   ,p_correspondence_language      => p_correspondence_language
238   ,p_fte_capacity                 => p_fte_capacity
239   ,p_hold_applicant_date_until    => p_hold_applicant_date_until
240   ,p_honors                       => p_honors
241   ,p_mailstop                     => p_mailstop
242   ,p_office_number                => p_office_number
243   ,p_on_military_service          => p_on_military_service
244   ,p_pre_name_adjunct             => p_pre_name_adjunct
245   ,p_projected_start_date         => p_projected_start_date
246   ,p_resume_exists                => p_resume_exists
247   ,p_resume_last_updated          => p_resume_last_updated
248   ,p_student_status               => p_student_status
249   ,p_work_schedule                => p_work_schedule
250   ,p_suffix                       => p_suffix
251   ,p_date_of_death                => p_date_of_death
252   ,p_benefit_group_id             => p_benefit_group_id
253   ,p_receipt_of_death_cert_date   => p_receipt_of_death_cert_date
254   ,p_coord_ben_med_pln_no         => p_coord_ben_med_pln_no
255   ,p_coord_ben_no_cvg_flag        => p_coord_ben_no_cvg_flag
256   ,p_uses_tobacco_flag            => p_uses_tobacco_flag
257   ,p_dpdnt_adoption_date          => p_dpdnt_adoption_date
258   ,p_dpdnt_vlntry_svce_flag       => p_dpdnt_vlntry_svce_flag
259   ,p_original_date_of_hire        => p_original_date_of_hire
260   --
261   ,p_town_of_birth                => p_town_of_birth
262   ,p_region_of_birth              => p_region_of_birth
263   ,p_global_person_id             => p_global_person_id
264   ,p_party_id                     => p_party_id
265   ,p_vacancy_id                   => p_vacancy_id
266   ,p_person_id                    => p_person_id
267   ,p_assignment_id                => p_assignment_id
268   ,p_application_id               => p_application_id
269   ,p_per_object_version_number    => p_per_object_version_number
270   ,p_asg_object_version_number    => p_asg_object_version_number
271   ,p_apl_object_version_number    => p_apl_object_version_number
272   ,p_per_effective_start_date     => p_per_effective_start_date
273   ,p_per_effective_end_date       => p_per_effective_end_date
274   ,p_full_name                    => p_full_name
275   ,p_per_comment_id               => p_per_comment_id
276   ,p_assignment_sequence          => p_assignment_sequence
277   ,p_name_combination_warning     => p_name_combination_warning
278   ,p_orig_hire_warning            => p_orig_hire_warning
279   );
280   --
281   hr_utility.set_location(' Leaving:'||l_proc, 55);
282 END create_nz_applicant;
283 END hr_nz_applicant_api;