eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HR_PERSON_EXTRA_INFO_BK1

Source


1 package body HR_PERSON_EXTRA_INFO_BK1 as
2 /* $Header: pepeiapi.pkb 120.2 2010/05/27 06:06:48 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:46:56 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_PERSON_EXTRA_INFO_A
6 (P_PERSON_EXTRA_INFO_ID in NUMBER
7 ,P_PERSON_ID in NUMBER
8 ,P_INFORMATION_TYPE in VARCHAR2
9 ,P_PEI_ATTRIBUTE_CATEGORY in VARCHAR2
10 ,P_PEI_ATTRIBUTE1 in VARCHAR2
11 ,P_PEI_ATTRIBUTE2 in VARCHAR2
12 ,P_PEI_ATTRIBUTE3 in VARCHAR2
13 ,P_PEI_ATTRIBUTE4 in VARCHAR2
14 ,P_PEI_ATTRIBUTE5 in VARCHAR2
15 ,P_PEI_ATTRIBUTE6 in VARCHAR2
16 ,P_PEI_ATTRIBUTE7 in VARCHAR2
17 ,P_PEI_ATTRIBUTE8 in VARCHAR2
18 ,P_PEI_ATTRIBUTE9 in VARCHAR2
19 ,P_PEI_ATTRIBUTE10 in VARCHAR2
20 ,P_PEI_ATTRIBUTE11 in VARCHAR2
21 ,P_PEI_ATTRIBUTE12 in VARCHAR2
22 ,P_PEI_ATTRIBUTE13 in VARCHAR2
23 ,P_PEI_ATTRIBUTE14 in VARCHAR2
24 ,P_PEI_ATTRIBUTE15 in VARCHAR2
25 ,P_PEI_ATTRIBUTE16 in VARCHAR2
26 ,P_PEI_ATTRIBUTE17 in VARCHAR2
27 ,P_PEI_ATTRIBUTE18 in VARCHAR2
28 ,P_PEI_ATTRIBUTE19 in VARCHAR2
29 ,P_PEI_ATTRIBUTE20 in VARCHAR2
30 ,P_PEI_INFORMATION_CATEGORY in VARCHAR2
31 ,P_PEI_INFORMATION1 in VARCHAR2
32 ,P_PEI_INFORMATION2 in VARCHAR2
33 ,P_PEI_INFORMATION3 in VARCHAR2
34 ,P_PEI_INFORMATION4 in VARCHAR2
35 ,P_PEI_INFORMATION5 in VARCHAR2
36 ,P_PEI_INFORMATION6 in VARCHAR2
37 ,P_PEI_INFORMATION7 in VARCHAR2
38 ,P_PEI_INFORMATION8 in VARCHAR2
39 ,P_PEI_INFORMATION9 in VARCHAR2
40 ,P_PEI_INFORMATION10 in VARCHAR2
41 ,P_PEI_INFORMATION11 in VARCHAR2
42 ,P_PEI_INFORMATION12 in VARCHAR2
43 ,P_PEI_INFORMATION13 in VARCHAR2
44 ,P_PEI_INFORMATION14 in VARCHAR2
45 ,P_PEI_INFORMATION15 in VARCHAR2
46 ,P_PEI_INFORMATION16 in VARCHAR2
47 ,P_PEI_INFORMATION17 in VARCHAR2
48 ,P_PEI_INFORMATION18 in VARCHAR2
49 ,P_PEI_INFORMATION19 in VARCHAR2
50 ,P_PEI_INFORMATION20 in VARCHAR2
51 ,P_PEI_INFORMATION21 in VARCHAR2
52 ,P_PEI_INFORMATION22 in VARCHAR2
53 ,P_PEI_INFORMATION23 in VARCHAR2
54 ,P_PEI_INFORMATION24 in VARCHAR2
55 ,P_PEI_INFORMATION25 in VARCHAR2
56 ,P_PEI_INFORMATION26 in VARCHAR2
57 ,P_PEI_INFORMATION27 in VARCHAR2
58 ,P_PEI_INFORMATION28 in VARCHAR2
59 ,P_PEI_INFORMATION29 in VARCHAR2
60 ,P_PEI_INFORMATION30 in VARCHAR2
61 ,P_OBJECT_VERSION_NUMBER in NUMBER
62 )is
63 l_commit_unit_number number;
64 l_legislation_code   varchar2(30);
65 begin
66 hr_utility.set_location('Entering: HR_PERSON_EXTRA_INFO_BK1.CREATE_PERSON_EXTRA_INFO_A', 10);
67 l_commit_unit_number := hr_api.return_commit_unit;
68 if hr_api.call_app_hooks then
69 hr_person_extra_info_be1.CREATE_PERSON_EXTRA_INFO_A
70 (P_PERSON_EXTRA_INFO_ID => P_PERSON_EXTRA_INFO_ID
71 ,P_PERSON_ID => P_PERSON_ID
72 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
73 ,P_PEI_ATTRIBUTE_CATEGORY => P_PEI_ATTRIBUTE_CATEGORY
74 ,P_PEI_ATTRIBUTE1 => P_PEI_ATTRIBUTE1
75 ,P_PEI_ATTRIBUTE2 => P_PEI_ATTRIBUTE2
76 ,P_PEI_ATTRIBUTE3 => P_PEI_ATTRIBUTE3
77 ,P_PEI_ATTRIBUTE4 => P_PEI_ATTRIBUTE4
78 ,P_PEI_ATTRIBUTE5 => P_PEI_ATTRIBUTE5
79 ,P_PEI_ATTRIBUTE6 => P_PEI_ATTRIBUTE6
80 ,P_PEI_ATTRIBUTE7 => P_PEI_ATTRIBUTE7
81 ,P_PEI_ATTRIBUTE8 => P_PEI_ATTRIBUTE8
82 ,P_PEI_ATTRIBUTE9 => P_PEI_ATTRIBUTE9
83 ,P_PEI_ATTRIBUTE10 => P_PEI_ATTRIBUTE10
84 ,P_PEI_ATTRIBUTE11 => P_PEI_ATTRIBUTE11
85 ,P_PEI_ATTRIBUTE12 => P_PEI_ATTRIBUTE12
86 ,P_PEI_ATTRIBUTE13 => P_PEI_ATTRIBUTE13
87 ,P_PEI_ATTRIBUTE14 => P_PEI_ATTRIBUTE14
88 ,P_PEI_ATTRIBUTE15 => P_PEI_ATTRIBUTE15
89 ,P_PEI_ATTRIBUTE16 => P_PEI_ATTRIBUTE16
90 ,P_PEI_ATTRIBUTE17 => P_PEI_ATTRIBUTE17
91 ,P_PEI_ATTRIBUTE18 => P_PEI_ATTRIBUTE18
92 ,P_PEI_ATTRIBUTE19 => P_PEI_ATTRIBUTE19
93 ,P_PEI_ATTRIBUTE20 => P_PEI_ATTRIBUTE20
94 ,P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
95 ,P_PEI_INFORMATION1 => P_PEI_INFORMATION1
96 ,P_PEI_INFORMATION2 => P_PEI_INFORMATION2
97 ,P_PEI_INFORMATION3 => P_PEI_INFORMATION3
98 ,P_PEI_INFORMATION4 => P_PEI_INFORMATION4
99 ,P_PEI_INFORMATION5 => P_PEI_INFORMATION5
100 ,P_PEI_INFORMATION6 => P_PEI_INFORMATION6
101 ,P_PEI_INFORMATION7 => P_PEI_INFORMATION7
102 ,P_PEI_INFORMATION8 => P_PEI_INFORMATION8
103 ,P_PEI_INFORMATION9 => P_PEI_INFORMATION9
104 ,P_PEI_INFORMATION10 => P_PEI_INFORMATION10
105 ,P_PEI_INFORMATION11 => P_PEI_INFORMATION11
106 ,P_PEI_INFORMATION12 => P_PEI_INFORMATION12
107 ,P_PEI_INFORMATION13 => P_PEI_INFORMATION13
108 ,P_PEI_INFORMATION14 => P_PEI_INFORMATION14
109 ,P_PEI_INFORMATION15 => P_PEI_INFORMATION15
110 ,P_PEI_INFORMATION16 => P_PEI_INFORMATION16
111 ,P_PEI_INFORMATION17 => P_PEI_INFORMATION17
112 ,P_PEI_INFORMATION18 => P_PEI_INFORMATION18
113 ,P_PEI_INFORMATION19 => P_PEI_INFORMATION19
114 ,P_PEI_INFORMATION20 => P_PEI_INFORMATION20
115 ,P_PEI_INFORMATION21 => P_PEI_INFORMATION21
116 ,P_PEI_INFORMATION22 => P_PEI_INFORMATION22
117 ,P_PEI_INFORMATION23 => P_PEI_INFORMATION23
118 ,P_PEI_INFORMATION24 => P_PEI_INFORMATION24
119 ,P_PEI_INFORMATION25 => P_PEI_INFORMATION25
120 ,P_PEI_INFORMATION26 => P_PEI_INFORMATION26
121 ,P_PEI_INFORMATION27 => P_PEI_INFORMATION27
122 ,P_PEI_INFORMATION28 => P_PEI_INFORMATION28
123 ,P_PEI_INFORMATION29 => P_PEI_INFORMATION29
124 ,P_PEI_INFORMATION30 => P_PEI_INFORMATION30
125 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
126 );
127 end if;
128 hr_multi_message.end_validation_set;
129 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_PERSON_EXTRA_INFO', 'AP');
130 hr_utility.set_location(' Leaving: HR_PERSON_EXTRA_INFO_BK1.CREATE_PERSON_EXTRA_INFO_A', 20);
131 end CREATE_PERSON_EXTRA_INFO_A;
132 procedure CREATE_PERSON_EXTRA_INFO_B
133 (P_PERSON_ID in NUMBER
134 ,P_INFORMATION_TYPE in VARCHAR2
135 ,P_PEI_ATTRIBUTE_CATEGORY in VARCHAR2
136 ,P_PEI_ATTRIBUTE1 in VARCHAR2
137 ,P_PEI_ATTRIBUTE2 in VARCHAR2
138 ,P_PEI_ATTRIBUTE3 in VARCHAR2
139 ,P_PEI_ATTRIBUTE4 in VARCHAR2
140 ,P_PEI_ATTRIBUTE5 in VARCHAR2
141 ,P_PEI_ATTRIBUTE6 in VARCHAR2
142 ,P_PEI_ATTRIBUTE7 in VARCHAR2
143 ,P_PEI_ATTRIBUTE8 in VARCHAR2
144 ,P_PEI_ATTRIBUTE9 in VARCHAR2
145 ,P_PEI_ATTRIBUTE10 in VARCHAR2
146 ,P_PEI_ATTRIBUTE11 in VARCHAR2
147 ,P_PEI_ATTRIBUTE12 in VARCHAR2
148 ,P_PEI_ATTRIBUTE13 in VARCHAR2
149 ,P_PEI_ATTRIBUTE14 in VARCHAR2
150 ,P_PEI_ATTRIBUTE15 in VARCHAR2
151 ,P_PEI_ATTRIBUTE16 in VARCHAR2
152 ,P_PEI_ATTRIBUTE17 in VARCHAR2
153 ,P_PEI_ATTRIBUTE18 in VARCHAR2
154 ,P_PEI_ATTRIBUTE19 in VARCHAR2
155 ,P_PEI_ATTRIBUTE20 in VARCHAR2
156 ,P_PEI_INFORMATION_CATEGORY in VARCHAR2
157 ,P_PEI_INFORMATION1 in VARCHAR2
158 ,P_PEI_INFORMATION2 in VARCHAR2
159 ,P_PEI_INFORMATION3 in VARCHAR2
160 ,P_PEI_INFORMATION4 in VARCHAR2
161 ,P_PEI_INFORMATION5 in VARCHAR2
162 ,P_PEI_INFORMATION6 in VARCHAR2
163 ,P_PEI_INFORMATION7 in VARCHAR2
164 ,P_PEI_INFORMATION8 in VARCHAR2
165 ,P_PEI_INFORMATION9 in VARCHAR2
166 ,P_PEI_INFORMATION10 in VARCHAR2
167 ,P_PEI_INFORMATION11 in VARCHAR2
168 ,P_PEI_INFORMATION12 in VARCHAR2
169 ,P_PEI_INFORMATION13 in VARCHAR2
170 ,P_PEI_INFORMATION14 in VARCHAR2
171 ,P_PEI_INFORMATION15 in VARCHAR2
172 ,P_PEI_INFORMATION16 in VARCHAR2
173 ,P_PEI_INFORMATION17 in VARCHAR2
174 ,P_PEI_INFORMATION18 in VARCHAR2
175 ,P_PEI_INFORMATION19 in VARCHAR2
176 ,P_PEI_INFORMATION20 in VARCHAR2
177 ,P_PEI_INFORMATION21 in VARCHAR2
178 ,P_PEI_INFORMATION22 in VARCHAR2
179 ,P_PEI_INFORMATION23 in VARCHAR2
180 ,P_PEI_INFORMATION24 in VARCHAR2
181 ,P_PEI_INFORMATION25 in VARCHAR2
182 ,P_PEI_INFORMATION26 in VARCHAR2
183 ,P_PEI_INFORMATION27 in VARCHAR2
184 ,P_PEI_INFORMATION28 in VARCHAR2
185 ,P_PEI_INFORMATION29 in VARCHAR2
186 ,P_PEI_INFORMATION30 in VARCHAR2
187 )is
188 l_commit_unit_number number;
189 l_legislation_code   varchar2(30);
190 begin
191 hr_utility.set_location('Entering: HR_PERSON_EXTRA_INFO_BK1.CREATE_PERSON_EXTRA_INFO_B', 10);
192 l_commit_unit_number := hr_api.return_commit_unit;
193 if hr_api.call_leg_hooks then
194 l_legislation_code := PER_PER_BUS.return_legislation_code(P_PERSON_ID => P_PERSON_ID
195 );
196 if l_legislation_code = 'DE' then
197 HR_DE_EXTRA_PERSON_CHECKS.PERSON_INFORMATION_CHECKS
198 (P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
199 ,P_PEI_INFORMATION1 => P_PEI_INFORMATION1
200 ,P_PEI_INFORMATION2 => P_PEI_INFORMATION2
201 ,P_PEI_INFORMATION6 => P_PEI_INFORMATION6
202 ,P_PEI_INFORMATION7 => P_PEI_INFORMATION7
203 );
204 PQH_DE_CONT_EMPLOYMENT_PKG.CHECK_CONTACT_EMPLOYMENT
205 (P_INFORMATION_TYPE => P_INFORMATION_TYPE
206 ,P_PEI_INFORMATION1 => P_PEI_INFORMATION1
207 ,P_PEI_INFORMATION2 => P_PEI_INFORMATION2
208 ,P_PEI_INFORMATION3 => P_PEI_INFORMATION3
209 ,P_PEI_INFORMATION4 => P_PEI_INFORMATION4
210 );
211 elsif l_legislation_code = 'GB' then
212 PER_GB_EXTRA_PERSON_CHECKS.CREATE_GB_PERSON_EXTRA_INFO
213 (P_PERSON_ID => P_PERSON_ID
214 ,P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
215 ,P_PEI_INFORMATION1 => P_PEI_INFORMATION1
216 ,P_PEI_INFORMATION2 => P_PEI_INFORMATION2
217 ,P_PEI_INFORMATION3 => P_PEI_INFORMATION3
218 ,P_PEI_INFORMATION4 => P_PEI_INFORMATION4
219 ,P_PEI_INFORMATION5 => P_PEI_INFORMATION5
220 ,P_PEI_INFORMATION6 => P_PEI_INFORMATION6
221 ,P_PEI_INFORMATION7 => P_PEI_INFORMATION7
222 ,P_PEI_INFORMATION8 => P_PEI_INFORMATION8
223 ,P_PEI_INFORMATION9 => P_PEI_INFORMATION9
224 ,P_PEI_INFORMATION10 => P_PEI_INFORMATION10
225 );
226 elsif l_legislation_code = 'HU' then
227 PER_HU_PERSON_EXTRA_INFO.CREATE_HU_PERSON_EXTRA_INFO
228 (P_PERSON_ID => P_PERSON_ID
229 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
230 ,P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
231 ,P_PEI_INFORMATION3 => P_PEI_INFORMATION3
232 ,P_PEI_INFORMATION4 => P_PEI_INFORMATION4
233 );
234 elsif l_legislation_code = 'IN' then
235 PER_IN_EXTRA_PER_INFO_LEG_HOOK.VALIDATE_ISSUE_EXPIRY_DATE
236 (P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
237 ,P_PEI_INFORMATION4 => P_PEI_INFORMATION4
238 ,P_PEI_INFORMATION5 => P_PEI_INFORMATION5
239 );
240 elsif l_legislation_code = 'PL' then
241 PER_PL_PERSON_EXTRA_INFO.CREATE_PL_PERSON_EXTRA_INFO
242 (P_PERSON_ID => P_PERSON_ID
243 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
244 ,P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
245 ,P_PEI_INFORMATION1 => P_PEI_INFORMATION1
246 ,P_PEI_INFORMATION2 => P_PEI_INFORMATION2
247 ,P_PEI_INFORMATION3 => P_PEI_INFORMATION3
248 ,P_PEI_INFORMATION4 => P_PEI_INFORMATION4
249 ,P_PEI_INFORMATION5 => P_PEI_INFORMATION5
250 ,P_PEI_INFORMATION6 => P_PEI_INFORMATION6
251 ,P_PEI_INFORMATION7 => P_PEI_INFORMATION7
252 ,P_PEI_INFORMATION8 => P_PEI_INFORMATION8
253 ,P_PEI_INFORMATION9 => P_PEI_INFORMATION9
254 ,P_PEI_INFORMATION10 => P_PEI_INFORMATION10
255 ,P_PEI_INFORMATION11 => P_PEI_INFORMATION11
256 ,P_PEI_INFORMATION12 => P_PEI_INFORMATION12
257 ,P_PEI_INFORMATION13 => P_PEI_INFORMATION13
258 ,P_PEI_INFORMATION14 => P_PEI_INFORMATION14
259 ,P_PEI_INFORMATION15 => P_PEI_INFORMATION15
260 ,P_PEI_INFORMATION16 => P_PEI_INFORMATION16
261 ,P_PEI_INFORMATION17 => P_PEI_INFORMATION17
262 ,P_PEI_INFORMATION18 => P_PEI_INFORMATION18
263 ,P_PEI_INFORMATION19 => P_PEI_INFORMATION19
264 ,P_PEI_INFORMATION20 => P_PEI_INFORMATION20
265 ,P_PEI_INFORMATION21 => P_PEI_INFORMATION21
266 ,P_PEI_INFORMATION22 => P_PEI_INFORMATION22
267 ,P_PEI_INFORMATION23 => P_PEI_INFORMATION23
268 ,P_PEI_INFORMATION24 => P_PEI_INFORMATION24
269 ,P_PEI_INFORMATION25 => P_PEI_INFORMATION25
270 ,P_PEI_INFORMATION26 => P_PEI_INFORMATION26
271 ,P_PEI_INFORMATION27 => P_PEI_INFORMATION27
272 ,P_PEI_INFORMATION28 => P_PEI_INFORMATION28
273 ,P_PEI_INFORMATION29 => P_PEI_INFORMATION29
274 ,P_PEI_INFORMATION30 => P_PEI_INFORMATION30
275 );
276 elsif l_legislation_code = 'SA' then
277 HR_SA_VALIDATE_PKG.CREATE_PERSON_EIT_VALIDATE
278 (P_PERSON_ID => P_PERSON_ID
279 ,P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
280 ,P_PEI_INFORMATION1 => P_PEI_INFORMATION1
281 ,P_PEI_INFORMATION2 => P_PEI_INFORMATION2
282 ,P_PEI_INFORMATION3 => P_PEI_INFORMATION3
283 ,P_PEI_INFORMATION4 => P_PEI_INFORMATION4
284 ,P_PEI_INFORMATION5 => P_PEI_INFORMATION5
285 ,P_PEI_INFORMATION6 => P_PEI_INFORMATION6
286 ,P_PEI_INFORMATION7 => P_PEI_INFORMATION7
287 ,P_PEI_INFORMATION8 => P_PEI_INFORMATION8
288 ,P_PEI_INFORMATION9 => P_PEI_INFORMATION9
289 ,P_PEI_INFORMATION10 => P_PEI_INFORMATION10
290 );
291 elsif l_legislation_code = 'US' then
292 PAY_US_EXTRA_PER_INFO_LEG_HOOK.PERSON_CHECK_NRA_STATUS_CREATE
293 (P_PERSON_ID => P_PERSON_ID
294 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
295 ,P_PEI_INFORMATION_CATEGORY => P_PEI_INFORMATION_CATEGORY
296 ,P_PEI_INFORMATION5 => P_PEI_INFORMATION5
297 ,P_PEI_INFORMATION9 => P_PEI_INFORMATION9
298 );
299 end if;
300 end if;
301 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_PERSON_EXTRA_INFO', 'BP');
302 hr_utility.set_location(' Leaving: HR_PERSON_EXTRA_INFO_BK1.CREATE_PERSON_EXTRA_INFO_B', 20);
303 end CREATE_PERSON_EXTRA_INFO_B;
304 end HR_PERSON_EXTRA_INFO_BK1;