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.PE_PEI_RKI

Source


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