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_BK2

Source


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