[Home] [Help]
PACKAGE BODY: APPS.BEN_CWB_PERSON_INFO_API
Source
1 Package Body BEN_CWB_PERSON_INFO_API as
2 /* $Header: becpiapi.pkb 120.1.12020000.2 2013/02/04 07:44:04 sgnanama ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' BEN_CWB_PERSON_INFO_API.';
7 g_debug boolean := hr_utility.debug_enabled;
8 --
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------< create_audit_record >--------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- Description
15 -- This is an internal procedure to write into the BEN_CWB_AUDIT table to
16 -- record particular changes in the values of BEN_CWB_PERSON_RATES.
17 -- Changes evaluated:
18 -- Code Desciption
19 -- BS Update Base Salary
20 -- CM Update Employee Notes
21 -- CF1-30 Update CPI Flex 1-30
22 -- CU1-20 Update Custom Segment 1-20
23 --
24 procedure create_audit_record
25 (p_info_old ben_cwb_person_info%rowtype
26 ) is
27
28 l_info_new ben_cwb_person_info%rowtype;
29 l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
30 l_object_version_number ben_cwb_audit.object_version_number%type;
31 l_cd_meaning_old hr_lookups.meaning%type;
32 l_cd_meaning_new hr_lookups.meaning%type;
33 l_group_pl_id ben_cwb_audit.group_pl_id%type;
34 l_lf_evt_ocrd_dt ben_cwb_audit.lf_evt_ocrd_dt%type;
35 l_group_oipl_id ben_cwb_audit.group_oipl_id%type;
36 l_person_id fnd_user.employee_id%type;
37 old_ws_comments ben_cwb_audit.old_val_varchar%type;
38
39 begin
40
41 select * into l_info_new
42 from ben_cwb_person_info
43 where group_per_in_ler_id = p_info_old.group_per_in_ler_id;
44
45 select group_pl_id,lf_evt_ocrd_dt
46 into l_group_pl_id, l_lf_evt_ocrd_dt
47 from ben_per_in_ler
48 where per_in_ler_id = p_info_old.group_per_in_ler_id;
49
50 l_group_oipl_id := -1;
51
52 select employee_id into l_person_id
53 from fnd_user
54 where user_id = l_info_new.last_updated_by;
55
56 if( ((p_info_old.base_salary is null)
57 and (l_info_new.base_salary is not null))
58 or ((l_info_new.base_salary is null)
59 and (p_info_old.base_salary is not null))
60 or (p_info_old.base_salary <> l_info_new.base_salary) ) then
61 if(ben_cwb_audit_api.return_lookup_validity('BS')=true) then
62 ben_cwb_audit_api.create_audit_entry
63 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
64 ,p_group_pl_id => l_group_pl_id
65 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
66 ,p_pl_id => l_group_pl_id
67 ,p_group_oipl_id => l_group_oipl_id
68 ,p_audit_type_cd => 'BS'
69 ,p_old_val_number => p_info_old.base_salary
70 ,p_new_val_number => l_info_new.base_salary
71 ,p_date_stamp => sysdate
72 ,p_change_made_by_person_id => l_person_id
73 ,p_cwb_audit_id => l_cwb_audit_id
74 ,p_object_version_number => l_object_version_number
75 );
76 end if;
77 end if;
78 if( ((p_info_old.ws_comments is null)
79 and (l_info_new.ws_comments is not null))
80 or ((l_info_new.ws_comments is null)
81 and (p_info_old.ws_comments is not null))
82 or (p_info_old.ws_comments <> l_info_new.ws_comments) ) then
83 if(ben_cwb_audit_api.return_lookup_validity('CM')=true) then
84
85 if lengthb(p_info_old.ws_comments) > 190 then
86 old_ws_comments := substrb(p_info_old.ws_comments,0,190)||'...';
87 else
88 old_ws_comments := p_info_old.ws_comments;
89 end if;
90
91 if lengthb(l_info_new.ws_comments) > 190 then
92 l_info_new.ws_comments := substrb(l_info_new.ws_comments,0,190)||'...';
93 end if;
94
95 ben_cwb_audit_api.create_audit_entry
96 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
97 ,p_group_pl_id => l_group_pl_id
98 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
99 ,p_pl_id => l_group_pl_id
100 ,p_group_oipl_id => l_group_oipl_id
101 ,p_audit_type_cd => 'CM'
102 ,p_old_val_varchar => old_ws_comments
103 ,p_new_val_varchar => l_info_new.ws_comments
104 ,p_date_stamp => sysdate
105 ,p_change_made_by_person_id => l_person_id
106 ,p_cwb_audit_id => l_cwb_audit_id
107 ,p_object_version_number => l_object_version_number
108 );
109 end if;
110 end if;
111 if( ((p_info_old.cpi_attribute1 is null)
112 and (l_info_new.cpi_attribute1 is not null))
113 or ((l_info_new.cpi_attribute1 is null)
114 and (p_info_old.cpi_attribute1 is not null))
115 or (p_info_old.cpi_attribute1 <> l_info_new.cpi_attribute1) ) then
116 if(ben_cwb_audit_api.return_lookup_validity('CF1')=true) then
117 ben_cwb_audit_api.create_audit_entry
118 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
119 ,p_group_pl_id => l_group_pl_id
120 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
121 ,p_pl_id => l_group_pl_id
122 ,p_group_oipl_id => l_group_oipl_id
123 ,p_audit_type_cd => 'CF1'
124 ,p_old_val_varchar => p_info_old.cpi_attribute1
125 ,p_new_val_varchar => l_info_new.cpi_attribute1
126 ,p_date_stamp => sysdate
127 ,p_change_made_by_person_id => l_person_id
128 ,p_cwb_audit_id => l_cwb_audit_id
129 ,p_object_version_number => l_object_version_number
130 );
131 end if;
132 end if;
133 if( ((p_info_old.cpi_attribute2 is null)
134 and (l_info_new.cpi_attribute2 is not null))
135 or ((l_info_new.cpi_attribute2 is null)
136 and (p_info_old.cpi_attribute2 is not null))
137 or (p_info_old.cpi_attribute2 <> l_info_new.cpi_attribute2) ) then
138 if(ben_cwb_audit_api.return_lookup_validity('CF2')=true) then
139 ben_cwb_audit_api.create_audit_entry
140 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
141 ,p_group_pl_id => l_group_pl_id
142 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
143 ,p_pl_id => l_group_pl_id
144 ,p_group_oipl_id => l_group_oipl_id
145 ,p_audit_type_cd => 'CF2'
146 ,p_old_val_varchar => p_info_old.cpi_attribute2
147 ,p_new_val_varchar => l_info_new.cpi_attribute2
148 ,p_date_stamp => sysdate
149 ,p_change_made_by_person_id => l_person_id
150 ,p_cwb_audit_id => l_cwb_audit_id
151 ,p_object_version_number => l_object_version_number
152 );
153 end if;
154 end if;
155 if( ((p_info_old.cpi_attribute3 is null)
156 and (l_info_new.cpi_attribute3 is not null))
157 or ((l_info_new.cpi_attribute3 is null)
158 and (p_info_old.cpi_attribute3 is not null))
159 or (p_info_old.cpi_attribute3 <> l_info_new.cpi_attribute3) ) then
160 if(ben_cwb_audit_api.return_lookup_validity('CF3')=true) then
161 ben_cwb_audit_api.create_audit_entry
162 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
163 ,p_group_pl_id => l_group_pl_id
164 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
165 ,p_pl_id => l_group_pl_id
166 ,p_group_oipl_id => l_group_oipl_id
167 ,p_audit_type_cd => 'CF3'
168 ,p_old_val_varchar => p_info_old.cpi_attribute3
169 ,p_new_val_varchar => l_info_new.cpi_attribute3
170 ,p_date_stamp => sysdate
171 ,p_change_made_by_person_id => l_person_id
172 ,p_cwb_audit_id => l_cwb_audit_id
173 ,p_object_version_number => l_object_version_number
174 );
175 end if;
176 end if;
177 if( ((p_info_old.cpi_attribute4 is null)
178 and (l_info_new.cpi_attribute4 is not null))
179 or ((l_info_new.cpi_attribute4 is null)
180 and (p_info_old.cpi_attribute4 is not null))
181 or (p_info_old.cpi_attribute4 <> l_info_new.cpi_attribute4) ) then
182 if(ben_cwb_audit_api.return_lookup_validity('CF4')=true) then
183 ben_cwb_audit_api.create_audit_entry
184 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
185 ,p_group_pl_id => l_group_pl_id
186 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
187 ,p_pl_id => l_group_pl_id
188 ,p_group_oipl_id => l_group_oipl_id
189 ,p_audit_type_cd => 'CF4'
190 ,p_old_val_varchar => p_info_old.cpi_attribute4
191 ,p_new_val_varchar => l_info_new.cpi_attribute4
192 ,p_date_stamp => sysdate
193 ,p_change_made_by_person_id => l_person_id
194 ,p_cwb_audit_id => l_cwb_audit_id
195 ,p_object_version_number => l_object_version_number
196 );
197 end if;
198 end if;
199 if( ((p_info_old.cpi_attribute5 is null)
200 and (l_info_new.cpi_attribute5 is not null))
201 or ((l_info_new.cpi_attribute5 is null)
202 and (p_info_old.cpi_attribute5 is not null))
203 or (p_info_old.cpi_attribute5 <> l_info_new.cpi_attribute5) ) then
204 if(ben_cwb_audit_api.return_lookup_validity('CF5')=true) then
205 ben_cwb_audit_api.create_audit_entry
206 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
207 ,p_group_pl_id => l_group_pl_id
208 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
209 ,p_pl_id => l_group_pl_id
210 ,p_group_oipl_id => l_group_oipl_id
211 ,p_audit_type_cd => 'CF5'
212 ,p_old_val_varchar => p_info_old.cpi_attribute5
213 ,p_new_val_varchar => l_info_new.cpi_attribute5
214 ,p_date_stamp => sysdate
215 ,p_change_made_by_person_id => l_person_id
216 ,p_cwb_audit_id => l_cwb_audit_id
217 ,p_object_version_number => l_object_version_number
218 );
219 end if;
220 end if;
221 if( ((p_info_old.cpi_attribute6 is null)
222 and (l_info_new.cpi_attribute6 is not null))
223 or ((l_info_new.cpi_attribute6 is null)
224 and (p_info_old.cpi_attribute6 is not null))
225 or (p_info_old.cpi_attribute6 <> l_info_new.cpi_attribute6) ) then
226 if(ben_cwb_audit_api.return_lookup_validity('CF6')=true) then
227 ben_cwb_audit_api.create_audit_entry
228 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
229 ,p_group_pl_id => l_group_pl_id
230 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
231 ,p_pl_id => l_group_pl_id
232 ,p_group_oipl_id => l_group_oipl_id
233 ,p_audit_type_cd => 'CF6'
234 ,p_old_val_varchar => p_info_old.cpi_attribute6
235 ,p_new_val_varchar => l_info_new.cpi_attribute6
236 ,p_date_stamp => sysdate
237 ,p_change_made_by_person_id => l_person_id
238 ,p_cwb_audit_id => l_cwb_audit_id
239 ,p_object_version_number => l_object_version_number
240 );
241 end if;
242 end if;
243 if( ((p_info_old.cpi_attribute7 is null)
244 and (l_info_new.cpi_attribute7 is not null))
245 or ((l_info_new.cpi_attribute7 is null)
246 and (p_info_old.cpi_attribute7 is not null))
247 or (p_info_old.cpi_attribute7 <> l_info_new.cpi_attribute7) ) then
248 if(ben_cwb_audit_api.return_lookup_validity('CF7')=true) then
249 ben_cwb_audit_api.create_audit_entry
250 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
251 ,p_group_pl_id => l_group_pl_id
252 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
253 ,p_pl_id => l_group_pl_id
254 ,p_group_oipl_id => l_group_oipl_id
255 ,p_audit_type_cd => 'CF7'
256 ,p_old_val_varchar => p_info_old.cpi_attribute7
257 ,p_new_val_varchar => l_info_new.cpi_attribute7
258 ,p_date_stamp => sysdate
259 ,p_change_made_by_person_id => l_person_id
260 ,p_cwb_audit_id => l_cwb_audit_id
261 ,p_object_version_number => l_object_version_number
262 );
263 end if;
264 end if;
265 if( ((p_info_old.cpi_attribute8 is null)
266 and (l_info_new.cpi_attribute8 is not null))
267 or ((l_info_new.cpi_attribute8 is null)
268 and (p_info_old.cpi_attribute8 is not null))
269 or (p_info_old.cpi_attribute8 <> l_info_new.cpi_attribute8) ) then
270 if(ben_cwb_audit_api.return_lookup_validity('CF8')=true) then
271 ben_cwb_audit_api.create_audit_entry
272 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
273 ,p_group_pl_id => l_group_pl_id
274 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
275 ,p_pl_id => l_group_pl_id
276 ,p_group_oipl_id => l_group_oipl_id
277 ,p_audit_type_cd => 'CF8'
278 ,p_old_val_varchar => p_info_old.cpi_attribute8
279 ,p_new_val_varchar => l_info_new.cpi_attribute8
280 ,p_date_stamp => sysdate
281 ,p_change_made_by_person_id => l_person_id
282 ,p_cwb_audit_id => l_cwb_audit_id
283 ,p_object_version_number => l_object_version_number
284 );
285 end if;
286 end if;
287 if( ((p_info_old.cpi_attribute9 is null)
288 and (l_info_new.cpi_attribute9 is not null))
289 or ((l_info_new.cpi_attribute9 is null)
290 and (p_info_old.cpi_attribute9 is not null))
291 or (p_info_old.cpi_attribute9 <> l_info_new.cpi_attribute9) ) then
292 if(ben_cwb_audit_api.return_lookup_validity('CF9')=true) then
293 ben_cwb_audit_api.create_audit_entry
294 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
295 ,p_group_pl_id => l_group_pl_id
296 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
297 ,p_pl_id => l_group_pl_id
298 ,p_group_oipl_id => l_group_oipl_id
299 ,p_audit_type_cd => 'CF9'
300 ,p_old_val_varchar => p_info_old.cpi_attribute9
301 ,p_new_val_varchar => l_info_new.cpi_attribute9
302 ,p_date_stamp => sysdate
303 ,p_change_made_by_person_id => l_person_id
304 ,p_cwb_audit_id => l_cwb_audit_id
305 ,p_object_version_number => l_object_version_number
306 );
307 end if;
308 end if;
309 if( ((p_info_old.cpi_attribute10 is null)
310 and (l_info_new.cpi_attribute10 is not null))
311 or ((l_info_new.cpi_attribute10 is null)
312 and (p_info_old.cpi_attribute10 is not null))
313 or (p_info_old.cpi_attribute10 <> l_info_new.cpi_attribute10) ) then
314 if(ben_cwb_audit_api.return_lookup_validity('CF10')=true) then
315 ben_cwb_audit_api.create_audit_entry
316 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
317 ,p_group_pl_id => l_group_pl_id
318 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
319 ,p_pl_id => l_group_pl_id
320 ,p_group_oipl_id => l_group_oipl_id
321 ,p_audit_type_cd => 'CF10'
322 ,p_old_val_varchar => p_info_old.cpi_attribute10
323 ,p_new_val_varchar => l_info_new.cpi_attribute10
324 ,p_date_stamp => sysdate
325 ,p_change_made_by_person_id => l_person_id
326 ,p_cwb_audit_id => l_cwb_audit_id
327 ,p_object_version_number => l_object_version_number
328 );
329 end if;
330 end if;
331 if( ((p_info_old.cpi_attribute11 is null)
332 and (l_info_new.cpi_attribute11 is not null))
333 or ((l_info_new.cpi_attribute11 is null)
334 and (p_info_old.cpi_attribute11 is not null))
335 or (p_info_old.cpi_attribute11 <> l_info_new.cpi_attribute11) ) then
336 if(ben_cwb_audit_api.return_lookup_validity('CF11')=true) then
337 ben_cwb_audit_api.create_audit_entry
338 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
339 ,p_group_pl_id => l_group_pl_id
340 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
341 ,p_pl_id => l_group_pl_id
342 ,p_group_oipl_id => l_group_oipl_id
343 ,p_audit_type_cd => 'CF11'
344 ,p_old_val_varchar => p_info_old.cpi_attribute11
345 ,p_new_val_varchar => l_info_new.cpi_attribute11
346 ,p_date_stamp => sysdate
347 ,p_change_made_by_person_id => l_person_id
348 ,p_cwb_audit_id => l_cwb_audit_id
349 ,p_object_version_number => l_object_version_number
350 );
351 end if;
352 end if;
353 if( ((p_info_old.cpi_attribute12 is null)
354 and (l_info_new.cpi_attribute12 is not null))
355 or ((l_info_new.cpi_attribute12 is null)
356 and (p_info_old.cpi_attribute12 is not null))
357 or (p_info_old.cpi_attribute12 <> l_info_new.cpi_attribute12) ) then
358 if(ben_cwb_audit_api.return_lookup_validity('CF12')=true) then
359 ben_cwb_audit_api.create_audit_entry
360 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
361 ,p_group_pl_id => l_group_pl_id
362 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
363 ,p_pl_id => l_group_pl_id
364 ,p_group_oipl_id => l_group_oipl_id
365 ,p_audit_type_cd => 'CF12'
366 ,p_old_val_varchar => p_info_old.cpi_attribute12
367 ,p_new_val_varchar => l_info_new.cpi_attribute12
368 ,p_date_stamp => sysdate
369 ,p_change_made_by_person_id => l_person_id
370 ,p_cwb_audit_id => l_cwb_audit_id
371 ,p_object_version_number => l_object_version_number
372 );
373 end if;
374 end if;
375 if( ((p_info_old.cpi_attribute13 is null)
376 and (l_info_new.cpi_attribute13 is not null))
377 or ((l_info_new.cpi_attribute13 is null)
378 and (p_info_old.cpi_attribute13 is not null))
379 or (p_info_old.cpi_attribute13 <> l_info_new.cpi_attribute13) ) then
380 if(ben_cwb_audit_api.return_lookup_validity('CF13')=true) then
381 ben_cwb_audit_api.create_audit_entry
382 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
383 ,p_group_pl_id => l_group_pl_id
384 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
385 ,p_pl_id => l_group_pl_id
386 ,p_group_oipl_id => l_group_oipl_id
387 ,p_audit_type_cd => 'CF13'
388 ,p_old_val_varchar => p_info_old.cpi_attribute13
389 ,p_new_val_varchar => l_info_new.cpi_attribute13
390 ,p_date_stamp => sysdate
391 ,p_change_made_by_person_id => l_person_id
392 ,p_cwb_audit_id => l_cwb_audit_id
393 ,p_object_version_number => l_object_version_number
394 );
395 end if;
396 end if;
397 if( ((p_info_old.cpi_attribute14 is null)
398 and (l_info_new.cpi_attribute14 is not null))
399 or ((l_info_new.cpi_attribute14 is null)
400 and (p_info_old.cpi_attribute14 is not null))
401 or (p_info_old.cpi_attribute14 <> l_info_new.cpi_attribute14) ) then
402 if(ben_cwb_audit_api.return_lookup_validity('CF14')=true) then
403 ben_cwb_audit_api.create_audit_entry
404 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
405 ,p_group_pl_id => l_group_pl_id
406 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
407 ,p_pl_id => l_group_pl_id
408 ,p_group_oipl_id => l_group_oipl_id
409 ,p_audit_type_cd => 'CF14'
410 ,p_old_val_varchar => p_info_old.cpi_attribute14
411 ,p_new_val_varchar => l_info_new.cpi_attribute14
412 ,p_date_stamp => sysdate
413 ,p_change_made_by_person_id => l_person_id
414 ,p_cwb_audit_id => l_cwb_audit_id
415 ,p_object_version_number => l_object_version_number
416 );
417 end if;
418 end if;
419 if( ((p_info_old.cpi_attribute15 is null)
420 and (l_info_new.cpi_attribute15 is not null))
421 or ((l_info_new.cpi_attribute15 is null)
422 and (p_info_old.cpi_attribute15 is not null))
423 or (p_info_old.cpi_attribute15 <> l_info_new.cpi_attribute15) ) then
424 if(ben_cwb_audit_api.return_lookup_validity('CF15')=true) then
425 ben_cwb_audit_api.create_audit_entry
426 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
427 ,p_group_pl_id => l_group_pl_id
428 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
429 ,p_pl_id => l_group_pl_id
430 ,p_group_oipl_id => l_group_oipl_id
431 ,p_audit_type_cd => 'CF15'
432 ,p_old_val_varchar => p_info_old.cpi_attribute15
433 ,p_new_val_varchar => l_info_new.cpi_attribute15
434 ,p_date_stamp => sysdate
435 ,p_change_made_by_person_id => l_person_id
436 ,p_cwb_audit_id => l_cwb_audit_id
437 ,p_object_version_number => l_object_version_number
438 );
439 end if;
440 end if;
441 if( ((p_info_old.cpi_attribute16 is null)
442 and (l_info_new.cpi_attribute16 is not null))
443 or ((l_info_new.cpi_attribute16 is null)
444 and (p_info_old.cpi_attribute16 is not null))
445 or (p_info_old.cpi_attribute16 <> l_info_new.cpi_attribute16) ) then
446 if(ben_cwb_audit_api.return_lookup_validity('CF16')=true) then
447 ben_cwb_audit_api.create_audit_entry
448 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
449 ,p_group_pl_id => l_group_pl_id
450 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
451 ,p_pl_id => l_group_pl_id
452 ,p_group_oipl_id => l_group_oipl_id
453 ,p_audit_type_cd => 'CF16'
454 ,p_old_val_varchar => p_info_old.cpi_attribute16
455 ,p_new_val_varchar => l_info_new.cpi_attribute16
456 ,p_date_stamp => sysdate
457 ,p_change_made_by_person_id => l_person_id
458 ,p_cwb_audit_id => l_cwb_audit_id
459 ,p_object_version_number => l_object_version_number
460 );
461 end if;
462 end if;
463 if( ((p_info_old.cpi_attribute17 is null)
464 and (l_info_new.cpi_attribute17 is not null))
465 or ((l_info_new.cpi_attribute17 is null)
466 and (p_info_old.cpi_attribute17 is not null))
467 or (p_info_old.cpi_attribute17 <> l_info_new.cpi_attribute17) ) then
468 if(ben_cwb_audit_api.return_lookup_validity('CF17')=true) then
469 ben_cwb_audit_api.create_audit_entry
470 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
471 ,p_group_pl_id => l_group_pl_id
472 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
473 ,p_pl_id => l_group_pl_id
474 ,p_group_oipl_id => l_group_oipl_id
475 ,p_audit_type_cd => 'CF17'
476 ,p_old_val_varchar => p_info_old.cpi_attribute17
477 ,p_new_val_varchar => l_info_new.cpi_attribute17
478 ,p_date_stamp => sysdate
479 ,p_change_made_by_person_id => l_person_id
480 ,p_cwb_audit_id => l_cwb_audit_id
481 ,p_object_version_number => l_object_version_number
482 );
483 end if;
484 end if;
485 if( ((p_info_old.cpi_attribute18 is null)
486 and (l_info_new.cpi_attribute18 is not null))
487 or ((l_info_new.cpi_attribute18 is null)
488 and (p_info_old.cpi_attribute18 is not null))
489 or (p_info_old.cpi_attribute18 <> l_info_new.cpi_attribute18) ) then
490 if(ben_cwb_audit_api.return_lookup_validity('CF18')=true) then
491 ben_cwb_audit_api.create_audit_entry
492 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
493 ,p_group_pl_id => l_group_pl_id
494 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
495 ,p_pl_id => l_group_pl_id
496 ,p_group_oipl_id => l_group_oipl_id
497 ,p_audit_type_cd => 'CF18'
498 ,p_old_val_varchar => p_info_old.cpi_attribute18
499 ,p_new_val_varchar => l_info_new.cpi_attribute18
500 ,p_date_stamp => sysdate
501 ,p_change_made_by_person_id => l_person_id
502 ,p_cwb_audit_id => l_cwb_audit_id
503 ,p_object_version_number => l_object_version_number
504 );
505 end if;
506 end if;
507 if( ((p_info_old.cpi_attribute19 is null)
508 and (l_info_new.cpi_attribute19 is not null))
509 or ((l_info_new.cpi_attribute19 is null)
510 and (p_info_old.cpi_attribute19 is not null))
511 or (p_info_old.cpi_attribute19 <> l_info_new.cpi_attribute19) ) then
512 if(ben_cwb_audit_api.return_lookup_validity('CF19')=true) then
513 ben_cwb_audit_api.create_audit_entry
514 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
515 ,p_group_pl_id => l_group_pl_id
516 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
517 ,p_pl_id => l_group_pl_id
518 ,p_group_oipl_id => l_group_oipl_id
519 ,p_audit_type_cd => 'CF19'
520 ,p_old_val_varchar => p_info_old.cpi_attribute1
521 ,p_new_val_varchar => l_info_new.cpi_attribute1
522 ,p_date_stamp => sysdate
523 ,p_change_made_by_person_id => l_person_id
524 ,p_cwb_audit_id => l_cwb_audit_id
525 ,p_object_version_number => l_object_version_number
526 );
527 end if;
528 end if;
529 if( ((p_info_old.cpi_attribute20 is null)
530 and (l_info_new.cpi_attribute20 is not null))
531 or ((l_info_new.cpi_attribute20 is null)
532 and (p_info_old.cpi_attribute20 is not null))
533 or (p_info_old.cpi_attribute20 <> l_info_new.cpi_attribute20) ) then
534 if(ben_cwb_audit_api.return_lookup_validity('CF20')=true) then
535 ben_cwb_audit_api.create_audit_entry
536 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
537 ,p_group_pl_id => l_group_pl_id
538 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
539 ,p_pl_id => l_group_pl_id
540 ,p_group_oipl_id => l_group_oipl_id
541 ,p_audit_type_cd => 'CF20'
542 ,p_old_val_varchar => p_info_old.cpi_attribute20
543 ,p_new_val_varchar => l_info_new.cpi_attribute20
544 ,p_date_stamp => sysdate
545 ,p_change_made_by_person_id => l_person_id
546 ,p_cwb_audit_id => l_cwb_audit_id
547 ,p_object_version_number => l_object_version_number
548 );
549 end if;
550 end if;
551 if( ((p_info_old.cpi_attribute21 is null)
552 and (l_info_new.cpi_attribute21 is not null))
553 or ((l_info_new.cpi_attribute21 is null)
554 and (p_info_old.cpi_attribute21 is not null))
555 or (p_info_old.cpi_attribute21 <> l_info_new.cpi_attribute21) ) then
556 if(ben_cwb_audit_api.return_lookup_validity('CF21')=true) then
557 ben_cwb_audit_api.create_audit_entry
558 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
559 ,p_group_pl_id => l_group_pl_id
560 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
561 ,p_pl_id => l_group_pl_id
562 ,p_group_oipl_id => l_group_oipl_id
563 ,p_audit_type_cd => 'CF21'
564 ,p_old_val_varchar => p_info_old.cpi_attribute21
565 ,p_new_val_varchar => l_info_new.cpi_attribute21
566 ,p_date_stamp => sysdate
567 ,p_change_made_by_person_id => l_person_id
568 ,p_cwb_audit_id => l_cwb_audit_id
569 ,p_object_version_number => l_object_version_number
570 );
571 end if;
572 end if;
573 if( ((p_info_old.cpi_attribute22 is null)
574 and (l_info_new.cpi_attribute22 is not null))
575 or ((l_info_new.cpi_attribute22 is null)
576 and (p_info_old.cpi_attribute22 is not null))
577 or (p_info_old.cpi_attribute22 <> l_info_new.cpi_attribute22) ) then
578 if(ben_cwb_audit_api.return_lookup_validity('CF22')=true) then
579 ben_cwb_audit_api.create_audit_entry
580 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
581 ,p_group_pl_id => l_group_pl_id
582 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
583 ,p_pl_id => l_group_pl_id
584 ,p_group_oipl_id => l_group_oipl_id
585 ,p_audit_type_cd => 'CF22'
586 ,p_old_val_varchar => p_info_old.cpi_attribute22
587 ,p_new_val_varchar => l_info_new.cpi_attribute22
588 ,p_date_stamp => sysdate
589 ,p_change_made_by_person_id => l_person_id
590 ,p_cwb_audit_id => l_cwb_audit_id
591 ,p_object_version_number => l_object_version_number
592 );
593 end if;
594 end if;
595 if( ((p_info_old.cpi_attribute23 is null)
596 and (l_info_new.cpi_attribute23 is not null))
597 or ((l_info_new.cpi_attribute23 is null)
598 and (p_info_old.cpi_attribute23 is not null))
599 or (p_info_old.cpi_attribute23 <> l_info_new.cpi_attribute23) ) then
600 if(ben_cwb_audit_api.return_lookup_validity('CF23')=true) then
601 ben_cwb_audit_api.create_audit_entry
602 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
603 ,p_group_pl_id => l_group_pl_id
604 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
605 ,p_pl_id => l_group_pl_id
606 ,p_group_oipl_id => l_group_oipl_id
607 ,p_audit_type_cd => 'CF23'
608 ,p_old_val_varchar => p_info_old.cpi_attribute23
609 ,p_new_val_varchar => l_info_new.cpi_attribute23
610 ,p_date_stamp => sysdate
611 ,p_change_made_by_person_id => l_person_id
612 ,p_cwb_audit_id => l_cwb_audit_id
613 ,p_object_version_number => l_object_version_number
614 );
615 end if;
616 end if;
617 if( ((p_info_old.cpi_attribute24 is null)
618 and (l_info_new.cpi_attribute24 is not null))
619 or ((l_info_new.cpi_attribute24 is null)
620 and (p_info_old.cpi_attribute24 is not null))
621 or (p_info_old.cpi_attribute24 <> l_info_new.cpi_attribute24) ) then
622 if(ben_cwb_audit_api.return_lookup_validity('CF24')=true) then
623 ben_cwb_audit_api.create_audit_entry
624 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
625 ,p_group_pl_id => l_group_pl_id
626 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
627 ,p_pl_id => l_group_pl_id
628 ,p_group_oipl_id => l_group_oipl_id
629 ,p_audit_type_cd => 'CF24'
630 ,p_old_val_varchar => p_info_old.cpi_attribute24
631 ,p_new_val_varchar => l_info_new.cpi_attribute24
632 ,p_date_stamp => sysdate
633 ,p_change_made_by_person_id => l_person_id
634 ,p_cwb_audit_id => l_cwb_audit_id
635 ,p_object_version_number => l_object_version_number
636 );
637 end if;
638 end if;
639 if( ((p_info_old.cpi_attribute25 is null)
640 and (l_info_new.cpi_attribute25 is not null))
641 or ((l_info_new.cpi_attribute25 is null)
642 and (p_info_old.cpi_attribute25 is not null))
643 or (p_info_old.cpi_attribute25 <> l_info_new.cpi_attribute25) ) then
644 if(ben_cwb_audit_api.return_lookup_validity('CF25')=true) then
645 ben_cwb_audit_api.create_audit_entry
646 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
647 ,p_group_pl_id => l_group_pl_id
648 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
649 ,p_pl_id => l_group_pl_id
650 ,p_group_oipl_id => l_group_oipl_id
651 ,p_audit_type_cd => 'CF25'
652 ,p_old_val_varchar => p_info_old.cpi_attribute25
653 ,p_new_val_varchar => l_info_new.cpi_attribute25
654 ,p_date_stamp => sysdate
655 ,p_change_made_by_person_id => l_person_id
656 ,p_cwb_audit_id => l_cwb_audit_id
657 ,p_object_version_number => l_object_version_number
658 );
659 end if;
660 end if;
661 if( ((p_info_old.cpi_attribute26 is null)
662 and (l_info_new.cpi_attribute26 is not null))
663 or ((l_info_new.cpi_attribute26 is null)
664 and (p_info_old.cpi_attribute26 is not null))
665 or (p_info_old.cpi_attribute26 <> l_info_new.cpi_attribute26) ) then
666 if(ben_cwb_audit_api.return_lookup_validity('CF26')=true) then
667 ben_cwb_audit_api.create_audit_entry
668 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
669 ,p_group_pl_id => l_group_pl_id
670 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
671 ,p_pl_id => l_group_pl_id
672 ,p_group_oipl_id => l_group_oipl_id
673 ,p_audit_type_cd => 'CF26'
674 ,p_old_val_varchar => p_info_old.cpi_attribute26
675 ,p_new_val_varchar => l_info_new.cpi_attribute26
676 ,p_date_stamp => sysdate
677 ,p_change_made_by_person_id => l_person_id
678 ,p_cwb_audit_id => l_cwb_audit_id
679 ,p_object_version_number => l_object_version_number
680 );
681 end if;
682 end if;
683 if( ((p_info_old.cpi_attribute27 is null)
684 and (l_info_new.cpi_attribute27 is not null))
685 or ((l_info_new.cpi_attribute27 is null)
686 and (p_info_old.cpi_attribute27 is not null))
687 or (p_info_old.cpi_attribute27 <> l_info_new.cpi_attribute27) ) then
688 if(ben_cwb_audit_api.return_lookup_validity('CF27')=true) then
689 ben_cwb_audit_api.create_audit_entry
690 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
691 ,p_group_pl_id => l_group_pl_id
692 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
693 ,p_pl_id => l_group_pl_id
694 ,p_group_oipl_id => l_group_oipl_id
695 ,p_audit_type_cd => 'CF27'
696 ,p_old_val_varchar => p_info_old.cpi_attribute27
697 ,p_new_val_varchar => l_info_new.cpi_attribute27
698 ,p_date_stamp => sysdate
699 ,p_change_made_by_person_id => l_person_id
700 ,p_cwb_audit_id => l_cwb_audit_id
701 ,p_object_version_number => l_object_version_number
702 );
703 end if;
704 end if;
705 if( ((p_info_old.cpi_attribute28 is null)
706 and (l_info_new.cpi_attribute28 is not null))
707 or ((l_info_new.cpi_attribute28 is null)
708 and (p_info_old.cpi_attribute28 is not null))
709 or (p_info_old.cpi_attribute28 <> l_info_new.cpi_attribute28) ) then
710 if(ben_cwb_audit_api.return_lookup_validity('CF28')=true) then
711 ben_cwb_audit_api.create_audit_entry
712 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
713 ,p_group_pl_id => l_group_pl_id
714 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
715 ,p_pl_id => l_group_pl_id
716 ,p_group_oipl_id => l_group_oipl_id
717 ,p_audit_type_cd => 'CF28'
718 ,p_old_val_varchar => p_info_old.cpi_attribute28
719 ,p_new_val_varchar => l_info_new.cpi_attribute28
720 ,p_date_stamp => sysdate
721 ,p_change_made_by_person_id => l_person_id
722 ,p_cwb_audit_id => l_cwb_audit_id
723 ,p_object_version_number => l_object_version_number
724 );
725 end if;
726 end if;
727 if( ((p_info_old.cpi_attribute29 is null)
728 and (l_info_new.cpi_attribute29 is not null))
729 or ((l_info_new.cpi_attribute29 is null)
730 and (p_info_old.cpi_attribute29 is not null))
731 or (p_info_old.cpi_attribute29 <> l_info_new.cpi_attribute29) ) then
732 if(ben_cwb_audit_api.return_lookup_validity('CF29')=true) then
733 ben_cwb_audit_api.create_audit_entry
734 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
735 ,p_group_pl_id => l_group_pl_id
736 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
737 ,p_pl_id => l_group_pl_id
738 ,p_group_oipl_id => l_group_oipl_id
739 ,p_audit_type_cd => 'CF29'
740 ,p_old_val_varchar => p_info_old.cpi_attribute29
741 ,p_new_val_varchar => l_info_new.cpi_attribute29
742 ,p_date_stamp => sysdate
743 ,p_change_made_by_person_id => l_person_id
744 ,p_cwb_audit_id => l_cwb_audit_id
745 ,p_object_version_number => l_object_version_number
746 );
747 end if;
748 end if;
749 if( ((p_info_old.cpi_attribute30 is null)
750 and (l_info_new.cpi_attribute30 is not null))
751 or ((l_info_new.cpi_attribute30 is null)
752 and (p_info_old.cpi_attribute30 is not null))
753 or (p_info_old.cpi_attribute30 <> l_info_new.cpi_attribute30) ) then
754 if(ben_cwb_audit_api.return_lookup_validity('CF30')=true) then
755 ben_cwb_audit_api.create_audit_entry
756 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
757 ,p_group_pl_id => l_group_pl_id
758 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
759 ,p_pl_id => l_group_pl_id
760 ,p_group_oipl_id => l_group_oipl_id
761 ,p_audit_type_cd => 'CF30'
762 ,p_old_val_varchar => p_info_old.cpi_attribute30
763 ,p_new_val_varchar => l_info_new.cpi_attribute30
764 ,p_date_stamp => sysdate
765 ,p_change_made_by_person_id => l_person_id
766 ,p_cwb_audit_id => l_cwb_audit_id
767 ,p_object_version_number => l_object_version_number
768 );
769 end if;
770 end if;
771 if( ((p_info_old.custom_segment1 is null)
772 and (l_info_new.custom_segment1 is not null))
773 or ((l_info_new.custom_segment1 is null)
774 and (p_info_old.custom_segment1 is not null))
775 or (p_info_old.custom_segment1 <> l_info_new.custom_segment1) ) then
776 if(ben_cwb_audit_api.return_lookup_validity('CU1')=true) then
777 hr_utility.set_location('CU1',9);
778 ben_cwb_audit_api.create_audit_entry
779 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
780 ,p_group_pl_id => l_group_pl_id
781 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
782 ,p_pl_id => l_group_pl_id
783 ,p_group_oipl_id => l_group_oipl_id
784 ,p_audit_type_cd => 'CU1'
785 ,p_old_val_varchar => p_info_old.custom_segment1
786 ,p_new_val_varchar => l_info_new.custom_segment1
787 ,p_date_stamp => sysdate
788 ,p_change_made_by_person_id => l_person_id
789 ,p_cwb_audit_id => l_cwb_audit_id
790 ,p_object_version_number => l_object_version_number
791 );
792 end if;
793 end if;
794 if( ((p_info_old.custom_segment2 is null)
795 and (l_info_new.custom_segment2 is not null))
796 or ((l_info_new.custom_segment2 is null)
797 and (p_info_old.custom_segment2 is not null))
798 or (p_info_old.custom_segment2 <> l_info_new.custom_segment2) ) then
799 if(ben_cwb_audit_api.return_lookup_validity('CU2')=true) then
800 hr_utility.set_location('CU2',9);
801 ben_cwb_audit_api.create_audit_entry
802 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
803 ,p_group_pl_id => l_group_pl_id
804 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
805 ,p_pl_id => l_group_pl_id
806 ,p_group_oipl_id => l_group_oipl_id
807 ,p_audit_type_cd => 'CU2'
808 ,p_old_val_varchar => p_info_old.custom_segment2
809 ,p_new_val_varchar => l_info_new.custom_segment2
810 ,p_date_stamp => sysdate
811 ,p_change_made_by_person_id => l_person_id
812 ,p_cwb_audit_id => l_cwb_audit_id
813 ,p_object_version_number => l_object_version_number
814 );
815 end if;
816 end if;
817 if( ((p_info_old.custom_segment3 is null)
818 and (l_info_new.custom_segment3 is not null))
819 or ((l_info_new.custom_segment3 is null)
820 and (p_info_old.custom_segment3 is not null))
821 or (p_info_old.custom_segment3 <> l_info_new.custom_segment3) ) then
822 if(ben_cwb_audit_api.return_lookup_validity('CU3')=true) then
823 ben_cwb_audit_api.create_audit_entry
824 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
825 ,p_group_pl_id => l_group_pl_id
826 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
827 ,p_pl_id => l_group_pl_id
828 ,p_group_oipl_id => l_group_oipl_id
829 ,p_audit_type_cd => 'CU3'
830 ,p_old_val_varchar => p_info_old.custom_segment3
831 ,p_new_val_varchar => l_info_new.custom_segment3
832 ,p_date_stamp => sysdate
833 ,p_change_made_by_person_id => l_person_id
834 ,p_cwb_audit_id => l_cwb_audit_id
835 ,p_object_version_number => l_object_version_number
836 );
837 end if;
838 end if;
839 if( ((p_info_old.custom_segment4 is null)
840 and (l_info_new.custom_segment4 is not null))
841 or ((l_info_new.custom_segment4 is null)
842 and (p_info_old.custom_segment4 is not null))
843 or (p_info_old.custom_segment4 <> l_info_new.custom_segment4) ) then
844 if(ben_cwb_audit_api.return_lookup_validity('CU4')=true) then
845 ben_cwb_audit_api.create_audit_entry
846 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
847 ,p_group_pl_id => l_group_pl_id
848 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
849 ,p_pl_id => l_group_pl_id
850 ,p_group_oipl_id => l_group_oipl_id
851 ,p_audit_type_cd => 'CU4'
852 ,p_old_val_varchar => p_info_old.custom_segment4
853 ,p_new_val_varchar => l_info_new.custom_segment4
854 ,p_date_stamp => sysdate
855 ,p_change_made_by_person_id => l_person_id
856 ,p_cwb_audit_id => l_cwb_audit_id
857 ,p_object_version_number => l_object_version_number
858 );
859 end if;
860 end if;
861 if( ((p_info_old.custom_segment5 is null)
862 and (l_info_new.custom_segment5 is not null))
863 or ((l_info_new.custom_segment5 is null)
864 and (p_info_old.custom_segment5 is not null))
865 or (p_info_old.custom_segment5 <> l_info_new.custom_segment5) ) then
866 if(ben_cwb_audit_api.return_lookup_validity('CU5')=true) then
867 ben_cwb_audit_api.create_audit_entry
868 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
869 ,p_group_pl_id => l_group_pl_id
870 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
871 ,p_pl_id => l_group_pl_id
872 ,p_group_oipl_id => l_group_oipl_id
873 ,p_audit_type_cd => 'CU5'
874 ,p_old_val_varchar => p_info_old.custom_segment5
875 ,p_new_val_varchar => l_info_new.custom_segment5
876 ,p_date_stamp => sysdate
877 ,p_change_made_by_person_id => l_person_id
878 ,p_cwb_audit_id => l_cwb_audit_id
879 ,p_object_version_number => l_object_version_number
880 );
881 end if;
882 end if;
883 if( ((p_info_old.custom_segment6 is null)
884 and (l_info_new.custom_segment6 is not null))
885 or ((l_info_new.custom_segment6 is null)
886 and (p_info_old.custom_segment6 is not null))
887 or (p_info_old.custom_segment6 <> l_info_new.custom_segment6) ) then
888 if(ben_cwb_audit_api.return_lookup_validity('CU6')=true) then
889 ben_cwb_audit_api.create_audit_entry
890 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
891 ,p_group_pl_id => l_group_pl_id
892 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
893 ,p_pl_id => l_group_pl_id
894 ,p_group_oipl_id => l_group_oipl_id
895 ,p_audit_type_cd => 'CU6'
896 ,p_old_val_varchar => p_info_old.custom_segment6
897 ,p_new_val_varchar => l_info_new.custom_segment6
898 ,p_date_stamp => sysdate
899 ,p_change_made_by_person_id => l_person_id
900 ,p_cwb_audit_id => l_cwb_audit_id
901 ,p_object_version_number => l_object_version_number
902 );
903 end if;
904 end if;
905 if( ((p_info_old.custom_segment7 is null)
906 and (l_info_new.custom_segment7 is not null))
907 or ((l_info_new.custom_segment7 is null)
908 and (p_info_old.custom_segment7 is not null))
909 or (p_info_old.custom_segment7 <> l_info_new.custom_segment7) ) then
910 if(ben_cwb_audit_api.return_lookup_validity('CU7')=true) then
911 ben_cwb_audit_api.create_audit_entry
912 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
913 ,p_group_pl_id => l_group_pl_id
914 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
915 ,p_pl_id => l_group_pl_id
916 ,p_group_oipl_id => l_group_oipl_id
917 ,p_audit_type_cd => 'CU7'
918 ,p_old_val_varchar => p_info_old.custom_segment7
919 ,p_new_val_varchar => l_info_new.custom_segment7
920 ,p_date_stamp => sysdate
921 ,p_change_made_by_person_id => l_person_id
922 ,p_cwb_audit_id => l_cwb_audit_id
923 ,p_object_version_number => l_object_version_number
924 );
925 end if;
926 end if;
927 if( ((p_info_old.custom_segment8 is null)
928 and (l_info_new.custom_segment8 is not null))
929 or ((l_info_new.custom_segment8 is null)
930 and (p_info_old.custom_segment8 is not null))
931 or (p_info_old.custom_segment8 <> l_info_new.custom_segment8) ) then
932 if(ben_cwb_audit_api.return_lookup_validity('CU8')=true) then
933 ben_cwb_audit_api.create_audit_entry
934 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
935 ,p_group_pl_id => l_group_pl_id
936 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
937 ,p_pl_id => l_group_pl_id
938 ,p_group_oipl_id => l_group_oipl_id
939 ,p_audit_type_cd => 'CU8'
940 ,p_old_val_varchar => p_info_old.custom_segment8
941 ,p_new_val_varchar => l_info_new.custom_segment8
942 ,p_date_stamp => sysdate
943 ,p_change_made_by_person_id => l_person_id
944 ,p_cwb_audit_id => l_cwb_audit_id
945 ,p_object_version_number => l_object_version_number
946 );
947 end if;
948 end if;
949 if( ((p_info_old.custom_segment9 is null)
950 and (l_info_new.custom_segment9 is not null))
951 or ((l_info_new.custom_segment9 is null)
952 and (p_info_old.custom_segment9 is not null))
953 or (p_info_old.custom_segment9 <> l_info_new.custom_segment9) ) then
954 if(ben_cwb_audit_api.return_lookup_validity('CU9')=true) then
955 ben_cwb_audit_api.create_audit_entry
956 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
957 ,p_group_pl_id => l_group_pl_id
958 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
959 ,p_pl_id => l_group_pl_id
960 ,p_group_oipl_id => l_group_oipl_id
961 ,p_audit_type_cd => 'CU9'
962 ,p_old_val_varchar => p_info_old.custom_segment9
963 ,p_new_val_varchar => l_info_new.custom_segment9
964 ,p_date_stamp => sysdate
965 ,p_change_made_by_person_id => l_person_id
966 ,p_cwb_audit_id => l_cwb_audit_id
967 ,p_object_version_number => l_object_version_number
968 );
969 end if;
970 end if;
971 if( ((p_info_old.custom_segment10 is null)
972 and (l_info_new.custom_segment10 is not null))
973 or ((l_info_new.custom_segment10 is null)
974 and (p_info_old.custom_segment10 is not null))
975 or (p_info_old.custom_segment10 <> l_info_new.custom_segment10) ) then
976 if(ben_cwb_audit_api.return_lookup_validity('CU10')=true) then
977 ben_cwb_audit_api.create_audit_entry
978 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
979 ,p_group_pl_id => l_group_pl_id
980 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
981 ,p_pl_id => l_group_pl_id
982 ,p_group_oipl_id => l_group_oipl_id
983 ,p_audit_type_cd => 'CU10'
984 ,p_old_val_varchar => p_info_old.custom_segment10
985 ,p_new_val_varchar => l_info_new.custom_segment10
986 ,p_date_stamp => sysdate
987 ,p_change_made_by_person_id => l_person_id
988 ,p_cwb_audit_id => l_cwb_audit_id
989 ,p_object_version_number => l_object_version_number
990 );
991 end if;
992 end if;
993 if( ((p_info_old.custom_segment11 is null)
994 and (l_info_new.custom_segment11 is not null))
995 or ((l_info_new.custom_segment11 is null)
996 and (p_info_old.custom_segment11 is not null))
997 or (p_info_old.custom_segment11 <> l_info_new.custom_segment11) ) then
998 if(ben_cwb_audit_api.return_lookup_validity('CU11')=true) then
999 ben_cwb_audit_api.create_audit_entry
1000 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1001 ,p_group_pl_id => l_group_pl_id
1002 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1003 ,p_pl_id => l_group_pl_id
1004 ,p_group_oipl_id => l_group_oipl_id
1005 ,p_audit_type_cd => 'CU11'
1006 ,p_old_val_number => p_info_old.custom_segment11
1007 ,p_new_val_number => l_info_new.custom_segment11
1008 ,p_date_stamp => sysdate
1009 ,p_change_made_by_person_id => l_person_id
1010 ,p_cwb_audit_id => l_cwb_audit_id
1011 ,p_object_version_number => l_object_version_number
1012 );
1013 end if;
1014 end if;
1015 if( ((p_info_old.custom_segment12 is null)
1016 and (l_info_new.custom_segment12 is not null))
1017 or ((l_info_new.custom_segment12 is null)
1018 and (p_info_old.custom_segment12 is not null))
1019 or (p_info_old.custom_segment12 <> l_info_new.custom_segment12) ) then
1020 if(ben_cwb_audit_api.return_lookup_validity('CU12')=true) then
1021 hr_utility.set_location('CU12',9);
1022 ben_cwb_audit_api.create_audit_entry
1023 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1024 ,p_group_pl_id => l_group_pl_id
1025 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1026 ,p_pl_id => l_group_pl_id
1027 ,p_group_oipl_id => l_group_oipl_id
1028 ,p_audit_type_cd => 'CU12'
1029 ,p_old_val_number => p_info_old.custom_segment12
1030 ,p_new_val_number => l_info_new.custom_segment12
1031 ,p_date_stamp => sysdate
1032 ,p_change_made_by_person_id => l_person_id
1033 ,p_cwb_audit_id => l_cwb_audit_id
1034 ,p_object_version_number => l_object_version_number
1035 );
1036 end if;
1037 end if;
1038 if( ((p_info_old.custom_segment13 is null)
1039 and (l_info_new.custom_segment13 is not null))
1040 or ((l_info_new.custom_segment13 is null)
1041 and (p_info_old.custom_segment13 is not null))
1042 or (p_info_old.custom_segment13 <> l_info_new.custom_segment13) ) then
1043 if(ben_cwb_audit_api.return_lookup_validity('CU13')=true) then
1044 ben_cwb_audit_api.create_audit_entry
1045 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1046 ,p_group_pl_id => l_group_pl_id
1047 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1048 ,p_pl_id => l_group_pl_id
1049 ,p_group_oipl_id => l_group_oipl_id
1050 ,p_audit_type_cd => 'CU13'
1051 ,p_old_val_number => p_info_old.custom_segment13
1052 ,p_new_val_number => l_info_new.custom_segment13
1053 ,p_date_stamp => sysdate
1054 ,p_change_made_by_person_id => l_person_id
1055 ,p_cwb_audit_id => l_cwb_audit_id
1056 ,p_object_version_number => l_object_version_number
1057 );
1058 end if;
1059 end if;
1060 if( ((p_info_old.custom_segment14 is null)
1061 and (l_info_new.custom_segment14 is not null))
1062 or ((l_info_new.custom_segment14 is null)
1063 and (p_info_old.custom_segment14 is not null))
1064 or (p_info_old.custom_segment14 <> l_info_new.custom_segment14) ) then
1065 if(ben_cwb_audit_api.return_lookup_validity('CU14')=true) then
1066 ben_cwb_audit_api.create_audit_entry
1067 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1068 ,p_group_pl_id => l_group_pl_id
1069 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1070 ,p_pl_id => l_group_pl_id
1071 ,p_group_oipl_id => l_group_oipl_id
1072 ,p_audit_type_cd => 'CU14'
1073 ,p_old_val_number => p_info_old.custom_segment14
1074 ,p_new_val_number => l_info_new.custom_segment14
1075 ,p_date_stamp => sysdate
1076 ,p_change_made_by_person_id => l_person_id
1077 ,p_cwb_audit_id => l_cwb_audit_id
1078 ,p_object_version_number => l_object_version_number
1079 );
1080 end if;
1081 end if;
1082 if( ((p_info_old.custom_segment15 is null)
1083 and (l_info_new.custom_segment15 is not null))
1084 or ((l_info_new.custom_segment15 is null)
1085 and (p_info_old.custom_segment15 is not null))
1086 or (p_info_old.custom_segment15 <> l_info_new.custom_segment15) ) then
1087 if(ben_cwb_audit_api.return_lookup_validity('CU15')=true) then
1088 ben_cwb_audit_api.create_audit_entry
1089 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1090 ,p_group_pl_id => l_group_pl_id
1091 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1092 ,p_pl_id => l_group_pl_id
1093 ,p_group_oipl_id => l_group_oipl_id
1094 ,p_audit_type_cd => 'CU15'
1095 ,p_old_val_number => p_info_old.custom_segment15
1096 ,p_new_val_number => l_info_new.custom_segment15
1097 ,p_date_stamp => sysdate
1098 ,p_change_made_by_person_id => l_person_id
1099 ,p_cwb_audit_id => l_cwb_audit_id
1100 ,p_object_version_number => l_object_version_number
1101 );
1102 end if;
1103 end if;
1104 if( ((p_info_old.custom_segment16 is null)
1105 and (l_info_new.custom_segment16 is not null))
1106 or ((l_info_new.custom_segment16 is null)
1107 and (p_info_old.custom_segment16 is not null))
1108 or (p_info_old.custom_segment16 <> l_info_new.custom_segment16) ) then
1109 if(ben_cwb_audit_api.return_lookup_validity('CU16')=true) then
1110 hr_utility.set_location('CU16',9);
1111 ben_cwb_audit_api.create_audit_entry
1112 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1113 ,p_group_pl_id => l_group_pl_id
1114 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1115 ,p_pl_id => l_group_pl_id
1116 ,p_group_oipl_id => l_group_oipl_id
1117 ,p_audit_type_cd => 'CU16'
1118 ,p_old_val_number => p_info_old.custom_segment16
1119 ,p_new_val_number => l_info_new.custom_segment16
1120 ,p_date_stamp => sysdate
1121 ,p_change_made_by_person_id => l_person_id
1122 ,p_cwb_audit_id => l_cwb_audit_id
1123 ,p_object_version_number => l_object_version_number
1124 );
1125 end if;
1126 end if;
1127 if( ((p_info_old.custom_segment17 is null)
1128 and (l_info_new.custom_segment17 is not null))
1129 or ((l_info_new.custom_segment17 is null)
1130 and (p_info_old.custom_segment17 is not null))
1131 or (p_info_old.custom_segment17 <> l_info_new.custom_segment17) ) then
1132 if(ben_cwb_audit_api.return_lookup_validity('CU17')=true) then
1133 hr_utility.set_location('CU17',9);
1134 ben_cwb_audit_api.create_audit_entry
1135 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1136 ,p_group_pl_id => l_group_pl_id
1137 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1138 ,p_pl_id => l_group_pl_id
1139 ,p_group_oipl_id => l_group_oipl_id
1140 ,p_audit_type_cd => 'CU17'
1141 ,p_old_val_number => p_info_old.custom_segment17
1142 ,p_new_val_number => l_info_new.custom_segment17
1143 ,p_date_stamp => sysdate
1144 ,p_change_made_by_person_id => l_person_id
1145 ,p_cwb_audit_id => l_cwb_audit_id
1146 ,p_object_version_number => l_object_version_number
1147 );
1148 end if;
1149 end if;
1150 if( ((p_info_old.custom_segment18 is null)
1151 and (l_info_new.custom_segment18 is not null))
1152 or ((l_info_new.custom_segment18 is null)
1153 and (p_info_old.custom_segment18 is not null))
1154 or (p_info_old.custom_segment18 <> l_info_new.custom_segment18) ) then
1155 if(ben_cwb_audit_api.return_lookup_validity('CU18')=true) then
1156 ben_cwb_audit_api.create_audit_entry
1157 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1158 ,p_group_pl_id => l_group_pl_id
1159 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1160 ,p_pl_id => l_group_pl_id
1161 ,p_group_oipl_id => l_group_oipl_id
1162 ,p_audit_type_cd => 'CU18'
1163 ,p_old_val_number => p_info_old.custom_segment18
1164 ,p_new_val_number => l_info_new.custom_segment18
1165 ,p_date_stamp => sysdate
1166 ,p_change_made_by_person_id => l_person_id
1167 ,p_cwb_audit_id => l_cwb_audit_id
1168 ,p_object_version_number => l_object_version_number
1169 );
1170 end if;
1171 end if;
1172 if( ((p_info_old.custom_segment19 is null)
1173 and (l_info_new.custom_segment19 is not null))
1174 or ((l_info_new.custom_segment19 is null)
1175 and (p_info_old.custom_segment19 is not null))
1176 or (p_info_old.custom_segment19 <> l_info_new.custom_segment19) ) then
1177 if(ben_cwb_audit_api.return_lookup_validity('CU19')=true) then
1178 ben_cwb_audit_api.create_audit_entry
1179 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1180 ,p_group_pl_id => l_group_pl_id
1181 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1182 ,p_pl_id => l_group_pl_id
1183 ,p_group_oipl_id => l_group_oipl_id
1184 ,p_audit_type_cd => 'CU19'
1185 ,p_old_val_number => p_info_old.custom_segment19
1186 ,p_new_val_number => l_info_new.custom_segment19
1187 ,p_date_stamp => sysdate
1188 ,p_change_made_by_person_id => l_person_id
1189 ,p_cwb_audit_id => l_cwb_audit_id
1190 ,p_object_version_number => l_object_version_number
1191 );
1192 end if;
1193 end if;
1194 if( ((p_info_old.custom_segment20 is null)
1195 and (l_info_new.custom_segment20 is not null))
1196 or ((l_info_new.custom_segment20 is null)
1197 and (p_info_old.custom_segment20 is not null))
1198 or (p_info_old.custom_segment20 <> l_info_new.custom_segment20) ) then
1199 if(ben_cwb_audit_api.return_lookup_validity('CU20')=true) then
1200 ben_cwb_audit_api.create_audit_entry
1201 (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1202 ,p_group_pl_id => l_group_pl_id
1203 ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1204 ,p_pl_id => l_group_pl_id
1205 ,p_group_oipl_id => l_group_oipl_id
1206 ,p_audit_type_cd => 'CU20'
1207 ,p_old_val_number => p_info_old.custom_segment20
1208 ,p_new_val_number => l_info_new.custom_segment20
1209 ,p_date_stamp => sysdate
1210 ,p_change_made_by_person_id => l_person_id
1211 ,p_cwb_audit_id => l_cwb_audit_id
1212 ,p_object_version_number => l_object_version_number
1213 );
1214 end if;
1215 end if;
1216 end create_audit_record;
1217 --
1218 -- ----------------------------------------------------------------------------
1219 -- |--------------------------< create_person_info >--------------------------|
1220 -- ----------------------------------------------------------------------------
1221 --
1222 procedure create_person_info
1223 (p_validate in boolean default false
1224 ,p_group_per_in_ler_id in number
1225 ,p_assignment_id in number
1226 ,p_person_id in number
1227 ,p_supervisor_id in number default null
1228 ,p_effective_date in date default null
1229 ,p_full_name in varchar2 default null
1230 ,p_brief_name in varchar2 default null
1231 ,p_custom_name in varchar2 default null
1232 ,p_supervisor_full_name in varchar2 default null
1233 ,p_supervisor_brief_name in varchar2 default null
1234 ,p_supervisor_custom_name in varchar2 default null
1235 ,p_legislation_code in varchar2 default null
1236 ,p_years_employed in number default null
1237 ,p_years_in_job in number default null
1238 ,p_years_in_position in number default null
1239 ,p_years_in_grade in number default null
1240 ,p_employee_number in varchar2 default null
1241 ,p_start_date in date default null
1242 ,p_original_start_date in date default null
1243 ,p_adjusted_svc_date in date default null
1244 ,p_base_salary in number default null
1245 ,p_base_salary_change_date in date default null
1246 ,p_payroll_name in varchar2 default null
1247 ,p_performance_rating in varchar2 default null
1248 ,p_performance_rating_type in varchar2 default null
1249 ,p_performance_rating_date in date default null
1250 ,p_business_group_id in number default null
1251 ,p_organization_id in number default null
1252 ,p_job_id in number default null
1253 ,p_grade_id in number default null
1254 ,p_position_id in number default null
1255 ,p_people_group_id in number default null
1256 ,p_soft_coding_keyflex_id in number default null
1257 ,p_location_id in number default null
1258 ,p_pay_rate_id in number default null
1259 ,p_assignment_status_type_id in number default null
1260 ,p_frequency in varchar2 default null
1261 ,p_grade_annulization_factor in number default null
1262 ,p_pay_annulization_factor in number default null
1263 ,p_grd_min_val in number default null
1264 ,p_grd_max_val in number default null
1265 ,p_grd_mid_point in number default null
1266 ,p_grd_quartile in varchar2 default null
1267 ,p_grd_comparatio in number default null
1268 ,p_emp_category in varchar2 default null
1269 ,p_change_reason in varchar2 default null
1270 ,p_normal_hours in number default null
1271 ,p_email_address in varchar2 default null
1272 ,p_base_salary_frequency in varchar2 default null
1273 ,p_new_assgn_ovn in number default null
1274 ,p_new_perf_event_id in number default null
1275 ,p_new_perf_review_id in number default null
1276 ,p_post_process_stat_cd in varchar2 default null
1277 ,p_feedback_rating in varchar2 default null
1278 ,p_feedback_comments in varchar2 default null
1279 ,p_custom_segment1 in varchar2 default null
1280 ,p_custom_segment2 in varchar2 default null
1281 ,p_custom_segment3 in varchar2 default null
1282 ,p_custom_segment4 in varchar2 default null
1283 ,p_custom_segment5 in varchar2 default null
1284 ,p_custom_segment6 in varchar2 default null
1285 ,p_custom_segment7 in varchar2 default null
1286 ,p_custom_segment8 in varchar2 default null
1287 ,p_custom_segment9 in varchar2 default null
1288 ,p_custom_segment10 in varchar2 default null
1289 ,p_custom_segment11 in number default null
1290 ,p_custom_segment12 in number default null
1291 ,p_custom_segment13 in number default null
1292 ,p_custom_segment14 in number default null
1293 ,p_custom_segment15 in number default null
1294 ,p_custom_segment16 in number default null
1295 ,p_custom_segment17 in number default null
1296 ,p_custom_segment18 in number default null
1297 ,p_custom_segment19 in number default null
1298 ,p_custom_segment20 in number default null
1299 ,p_ass_attribute_category in varchar2 default null
1300 ,p_ass_attribute1 in varchar2 default null
1301 ,p_ass_attribute2 in varchar2 default null
1302 ,p_ass_attribute3 in varchar2 default null
1303 ,p_ass_attribute4 in varchar2 default null
1304 ,p_ass_attribute5 in varchar2 default null
1305 ,p_ass_attribute6 in varchar2 default null
1306 ,p_ass_attribute7 in varchar2 default null
1307 ,p_ass_attribute8 in varchar2 default null
1308 ,p_ass_attribute9 in varchar2 default null
1309 ,p_ass_attribute10 in varchar2 default null
1310 ,p_ass_attribute11 in varchar2 default null
1311 ,p_ass_attribute12 in varchar2 default null
1312 ,p_ass_attribute13 in varchar2 default null
1313 ,p_ass_attribute14 in varchar2 default null
1314 ,p_ass_attribute15 in varchar2 default null
1315 ,p_ass_attribute16 in varchar2 default null
1316 ,p_ass_attribute17 in varchar2 default null
1317 ,p_ass_attribute18 in varchar2 default null
1318 ,p_ass_attribute19 in varchar2 default null
1319 ,p_ass_attribute20 in varchar2 default null
1320 ,p_ass_attribute21 in varchar2 default null
1321 ,p_ass_attribute22 in varchar2 default null
1322 ,p_ass_attribute23 in varchar2 default null
1323 ,p_ass_attribute24 in varchar2 default null
1324 ,p_ass_attribute25 in varchar2 default null
1325 ,p_ass_attribute26 in varchar2 default null
1326 ,p_ass_attribute27 in varchar2 default null
1327 ,p_ass_attribute28 in varchar2 default null
1328 ,p_ass_attribute29 in varchar2 default null
1329 ,p_ass_attribute30 in varchar2 default null
1330 ,p_ws_comments in varchar2 default null
1331 ,p_people_group_name in varchar2 default null
1332 ,p_people_group_segment1 in varchar2 default null
1333 ,p_people_group_segment2 in varchar2 default null
1334 ,p_people_group_segment3 in varchar2 default null
1335 ,p_people_group_segment4 in varchar2 default null
1336 ,p_people_group_segment5 in varchar2 default null
1337 ,p_people_group_segment6 in varchar2 default null
1338 ,p_people_group_segment7 in varchar2 default null
1339 ,p_people_group_segment8 in varchar2 default null
1340 ,p_people_group_segment9 in varchar2 default null
1341 ,p_people_group_segment10 in varchar2 default null
1342 ,p_people_group_segment11 in varchar2 default null
1343 ,p_cpi_attribute_category in varchar2 default null
1344 ,p_cpi_attribute1 in varchar2 default null
1345 ,p_cpi_attribute2 in varchar2 default null
1346 ,p_cpi_attribute3 in varchar2 default null
1347 ,p_cpi_attribute4 in varchar2 default null
1348 ,p_cpi_attribute5 in varchar2 default null
1349 ,p_cpi_attribute6 in varchar2 default null
1350 ,p_cpi_attribute7 in varchar2 default null
1351 ,p_cpi_attribute8 in varchar2 default null
1352 ,p_cpi_attribute9 in varchar2 default null
1353 ,p_cpi_attribute10 in varchar2 default null
1354 ,p_cpi_attribute11 in varchar2 default null
1355 ,p_cpi_attribute12 in varchar2 default null
1356 ,p_cpi_attribute13 in varchar2 default null
1357 ,p_cpi_attribute14 in varchar2 default null
1358 ,p_cpi_attribute15 in varchar2 default null
1359 ,p_cpi_attribute16 in varchar2 default null
1360 ,p_cpi_attribute17 in varchar2 default null
1361 ,p_cpi_attribute18 in varchar2 default null
1362 ,p_cpi_attribute19 in varchar2 default null
1363 ,p_cpi_attribute20 in varchar2 default null
1364 ,p_cpi_attribute21 in varchar2 default null
1365 ,p_cpi_attribute22 in varchar2 default null
1366 ,p_cpi_attribute23 in varchar2 default null
1367 ,p_cpi_attribute24 in varchar2 default null
1368 ,p_cpi_attribute25 in varchar2 default null
1369 ,p_cpi_attribute26 in varchar2 default null
1370 ,p_cpi_attribute27 in varchar2 default null
1371 ,p_cpi_attribute28 in varchar2 default null
1372 ,p_cpi_attribute29 in varchar2 default null
1373 ,p_cpi_attribute30 in varchar2 default null
1374 ,p_feedback_date in date default null
1375 ,p_object_version_number out nocopy number
1376 ) is
1377 --
1378 -- Declare cursors and local variables
1379 --
1380 l_object_version_number number;
1381 --
1382 l_proc varchar2(72) := g_package||'create_person_info';
1383 begin
1384 if g_debug then
1385 hr_utility.set_location('Entering:'|| l_proc, 10);
1386 end if;
1387 --
1388 -- Issue a savepoint
1389 --
1390 savepoint create_person_info;
1391 --
1392 -- Call Before Process User Hook
1393 --
1394 begin
1395 ben_cwb_person_info_bk1.create_person_info_b
1396 (p_group_per_in_ler_id => p_group_per_in_ler_id
1397 ,p_assignment_id => p_assignment_id
1398 ,p_person_id => p_person_id
1399 ,p_supervisor_id => p_supervisor_id
1400 ,p_effective_date => p_effective_date
1401 ,p_full_name => p_full_name
1402 ,p_brief_name => p_brief_name
1403 ,p_custom_name => p_custom_name
1404 ,p_supervisor_full_name => p_supervisor_full_name
1405 ,p_supervisor_brief_name => p_supervisor_brief_name
1406 ,p_supervisor_custom_name => p_supervisor_custom_name
1407 ,p_legislation_code => p_legislation_code
1408 ,p_years_employed => p_years_employed
1409 ,p_years_in_job => p_years_in_job
1410 ,p_years_in_position => p_years_in_position
1411 ,p_years_in_grade => p_years_in_grade
1412 ,p_employee_number => p_employee_number
1413 ,p_start_date => p_start_date
1414 ,p_original_start_date => p_original_start_date
1415 ,p_adjusted_svc_date => p_adjusted_svc_date
1416 ,p_base_salary => p_base_salary
1417 ,p_base_salary_change_date => p_base_salary_change_date
1418 ,p_payroll_name => p_payroll_name
1419 ,p_performance_rating => p_performance_rating
1420 ,p_performance_rating_type => p_performance_rating_type
1421 ,p_performance_rating_date => p_performance_rating_date
1422 ,p_business_group_id => p_business_group_id
1423 ,p_organization_id => p_organization_id
1424 ,p_job_id => p_job_id
1425 ,p_grade_id => p_grade_id
1426 ,p_position_id => p_position_id
1427 ,p_people_group_id => p_people_group_id
1428 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
1429 ,p_location_id => p_location_id
1430 ,p_pay_rate_id => p_pay_rate_id
1431 ,p_assignment_status_type_id => p_assignment_status_type_id
1432 ,p_frequency => p_frequency
1433 ,p_grade_annulization_factor => p_grade_annulization_factor
1434 ,p_pay_annulization_factor => p_pay_annulization_factor
1435 ,p_grd_min_val => p_grd_min_val
1436 ,p_grd_max_val => p_grd_max_val
1437 ,p_grd_mid_point => p_grd_mid_point
1438 ,p_grd_quartile => p_grd_quartile
1439 ,p_grd_comparatio => p_grd_comparatio
1440 ,p_emp_category => p_emp_category
1441 ,p_change_reason => p_change_reason
1442 ,p_normal_hours => p_normal_hours
1443 ,p_email_address => p_email_address
1444 ,p_base_salary_frequency => p_base_salary_frequency
1445 ,p_new_assgn_ovn => p_new_assgn_ovn
1446 ,p_new_perf_event_id => p_new_perf_event_id
1447 ,p_new_perf_review_id => p_new_perf_review_id
1448 ,p_post_process_stat_cd => p_post_process_stat_cd
1449 ,p_feedback_rating => p_feedback_rating
1450 ,p_feedback_comments => p_feedback_comments
1451 ,p_custom_segment1 => p_custom_segment1
1452 ,p_custom_segment2 => p_custom_segment2
1453 ,p_custom_segment3 => p_custom_segment3
1454 ,p_custom_segment4 => p_custom_segment4
1455 ,p_custom_segment5 => p_custom_segment5
1456 ,p_custom_segment6 => p_custom_segment6
1457 ,p_custom_segment7 => p_custom_segment7
1458 ,p_custom_segment8 => p_custom_segment8
1459 ,p_custom_segment9 => p_custom_segment9
1460 ,p_custom_segment10 => p_custom_segment10
1461 ,p_custom_segment11 => p_custom_segment11
1462 ,p_custom_segment12 => p_custom_segment12
1463 ,p_custom_segment13 => p_custom_segment13
1464 ,p_custom_segment14 => p_custom_segment14
1465 ,p_custom_segment15 => p_custom_segment15
1466 ,p_custom_segment16 => p_custom_segment16
1467 ,p_custom_segment17 => p_custom_segment17
1468 ,p_custom_segment18 => p_custom_segment18
1469 ,p_custom_segment19 => p_custom_segment19
1470 ,p_custom_segment20 => p_custom_segment20
1471 ,p_ass_attribute_category => p_ass_attribute_category
1472 ,p_ass_attribute1 => p_ass_attribute1
1473 ,p_ass_attribute2 => p_ass_attribute2
1474 ,p_ass_attribute3 => p_ass_attribute3
1475 ,p_ass_attribute4 => p_ass_attribute4
1476 ,p_ass_attribute5 => p_ass_attribute5
1477 ,p_ass_attribute6 => p_ass_attribute6
1478 ,p_ass_attribute7 => p_ass_attribute7
1479 ,p_ass_attribute8 => p_ass_attribute8
1480 ,p_ass_attribute9 => p_ass_attribute9
1481 ,p_ass_attribute10 => p_ass_attribute10
1482 ,p_ass_attribute11 => p_ass_attribute11
1483 ,p_ass_attribute12 => p_ass_attribute12
1484 ,p_ass_attribute13 => p_ass_attribute13
1485 ,p_ass_attribute14 => p_ass_attribute14
1486 ,p_ass_attribute15 => p_ass_attribute15
1487 ,p_ass_attribute16 => p_ass_attribute16
1488 ,p_ass_attribute17 => p_ass_attribute17
1489 ,p_ass_attribute18 => p_ass_attribute18
1490 ,p_ass_attribute19 => p_ass_attribute19
1491 ,p_ass_attribute20 => p_ass_attribute20
1492 ,p_ass_attribute21 => p_ass_attribute21
1493 ,p_ass_attribute22 => p_ass_attribute22
1494 ,p_ass_attribute23 => p_ass_attribute23
1495 ,p_ass_attribute24 => p_ass_attribute24
1496 ,p_ass_attribute25 => p_ass_attribute25
1497 ,p_ass_attribute26 => p_ass_attribute26
1498 ,p_ass_attribute27 => p_ass_attribute27
1499 ,p_ass_attribute28 => p_ass_attribute28
1500 ,p_ass_attribute29 => p_ass_attribute29
1501 ,p_ass_attribute30 => p_ass_attribute30
1502 ,p_ws_comments => p_ws_comments
1503 ,p_people_group_name => p_people_group_name
1504 ,p_people_group_segment1 => p_people_group_segment1
1505 ,p_people_group_segment2 => p_people_group_segment2
1506 ,p_people_group_segment3 => p_people_group_segment3
1507 ,p_people_group_segment4 => p_people_group_segment4
1508 ,p_people_group_segment5 => p_people_group_segment5
1509 ,p_people_group_segment6 => p_people_group_segment6
1510 ,p_people_group_segment7 => p_people_group_segment7
1511 ,p_people_group_segment8 => p_people_group_segment8
1512 ,p_people_group_segment9 => p_people_group_segment9
1513 ,p_people_group_segment10 => p_people_group_segment10
1514 ,p_people_group_segment11 => p_people_group_segment11
1515 ,p_cpi_attribute_category => p_cpi_attribute_category
1516 ,p_cpi_attribute1 => p_cpi_attribute1
1517 ,p_cpi_attribute2 => p_cpi_attribute2
1518 ,p_cpi_attribute3 => p_cpi_attribute3
1519 ,p_cpi_attribute4 => p_cpi_attribute4
1520 ,p_cpi_attribute5 => p_cpi_attribute5
1521 ,p_cpi_attribute6 => p_cpi_attribute6
1522 ,p_cpi_attribute7 => p_cpi_attribute7
1523 ,p_cpi_attribute8 => p_cpi_attribute8
1524 ,p_cpi_attribute9 => p_cpi_attribute9
1525 ,p_cpi_attribute10 => p_cpi_attribute10
1526 ,p_cpi_attribute11 => p_cpi_attribute11
1527 ,p_cpi_attribute12 => p_cpi_attribute12
1528 ,p_cpi_attribute13 => p_cpi_attribute13
1529 ,p_cpi_attribute14 => p_cpi_attribute14
1530 ,p_cpi_attribute15 => p_cpi_attribute15
1531 ,p_cpi_attribute16 => p_cpi_attribute16
1532 ,p_cpi_attribute17 => p_cpi_attribute17
1533 ,p_cpi_attribute18 => p_cpi_attribute18
1534 ,p_cpi_attribute19 => p_cpi_attribute19
1535 ,p_cpi_attribute20 => p_cpi_attribute20
1536 ,p_cpi_attribute21 => p_cpi_attribute21
1537 ,p_cpi_attribute22 => p_cpi_attribute22
1538 ,p_cpi_attribute23 => p_cpi_attribute23
1539 ,p_cpi_attribute24 => p_cpi_attribute24
1540 ,p_cpi_attribute25 => p_cpi_attribute25
1541 ,p_cpi_attribute26 => p_cpi_attribute26
1542 ,p_cpi_attribute27 => p_cpi_attribute27
1543 ,p_cpi_attribute28 => p_cpi_attribute28
1544 ,p_cpi_attribute29 => p_cpi_attribute29
1545 ,p_cpi_attribute30 => p_cpi_attribute30
1546 ,p_feedback_date => p_feedback_date
1547 );
1548 exception
1549 when hr_api.cannot_find_prog_unit then
1550 hr_api.cannot_find_prog_unit_error
1551 (p_module_name => 'CREATE_PERSON_INFO'
1552 ,p_hook_type => 'BP'
1553 );
1554 end;
1555 --
1556 -- Validation in addition to Row Handlers
1557 --
1558
1559 --
1560 -- Process Logic
1561 --
1562 ben_cpi_ins.ins
1563 (p_group_per_in_ler_id => p_group_per_in_ler_id
1564 ,p_assignment_id => p_assignment_id
1565 ,p_person_id => p_person_id
1566 ,p_supervisor_id => p_supervisor_id
1567 ,p_effective_date => p_effective_date
1568 ,p_full_name => p_full_name
1569 ,p_brief_name => p_brief_name
1570 ,p_custom_name => p_custom_name
1571 ,p_supervisor_full_name => p_supervisor_full_name
1572 ,p_supervisor_brief_name => p_supervisor_brief_name
1573 ,p_supervisor_custom_name => p_supervisor_custom_name
1574 ,p_legislation_code => p_legislation_code
1575 ,p_years_employed => p_years_employed
1576 ,p_years_in_job => p_years_in_job
1577 ,p_years_in_position => p_years_in_position
1578 ,p_years_in_grade => p_years_in_grade
1579 ,p_employee_number => p_employee_number
1580 ,p_start_date => p_start_date
1581 ,p_original_start_date => p_original_start_date
1582 ,p_adjusted_svc_date => p_adjusted_svc_date
1583 ,p_base_salary => p_base_salary
1584 ,p_base_salary_change_date => p_base_salary_change_date
1585 ,p_payroll_name => p_payroll_name
1586 ,p_performance_rating => p_performance_rating
1587 ,p_performance_rating_type => p_performance_rating_type
1588 ,p_performance_rating_date => p_performance_rating_date
1589 ,p_business_group_id => p_business_group_id
1590 ,p_organization_id => p_organization_id
1591 ,p_job_id => p_job_id
1592 ,p_grade_id => p_grade_id
1593 ,p_position_id => p_position_id
1594 ,p_people_group_id => p_people_group_id
1595 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
1596 ,p_location_id => p_location_id
1597 ,p_pay_rate_id => p_pay_rate_id
1598 ,p_assignment_status_type_id => p_assignment_status_type_id
1599 ,p_frequency => p_frequency
1600 ,p_grade_annulization_factor => p_grade_annulization_factor
1601 ,p_pay_annulization_factor => p_pay_annulization_factor
1602 ,p_grd_min_val => p_grd_min_val
1603 ,p_grd_max_val => p_grd_max_val
1604 ,p_grd_mid_point => p_grd_mid_point
1605 ,p_grd_quartile => p_grd_quartile
1606 ,p_grd_comparatio => p_grd_comparatio
1607 ,p_emp_category => p_emp_category
1608 ,p_change_reason => p_change_reason
1609 ,p_normal_hours => p_normal_hours
1610 ,p_email_address => p_email_address
1611 ,p_base_salary_frequency => p_base_salary_frequency
1612 ,p_new_assgn_ovn => p_new_assgn_ovn
1613 ,p_new_perf_event_id => p_new_perf_event_id
1614 ,p_new_perf_review_id => p_new_perf_review_id
1615 ,p_post_process_stat_cd => p_post_process_stat_cd
1616 ,p_feedback_rating => p_feedback_rating
1617 ,p_feedback_comments => p_feedback_comments
1618 ,p_custom_segment1 => p_custom_segment1
1619 ,p_custom_segment2 => p_custom_segment2
1620 ,p_custom_segment3 => p_custom_segment3
1621 ,p_custom_segment4 => p_custom_segment4
1622 ,p_custom_segment5 => p_custom_segment5
1623 ,p_custom_segment6 => p_custom_segment6
1624 ,p_custom_segment7 => p_custom_segment7
1625 ,p_custom_segment8 => p_custom_segment8
1626 ,p_custom_segment9 => p_custom_segment9
1627 ,p_custom_segment10 => p_custom_segment10
1628 ,p_custom_segment11 => p_custom_segment11
1629 ,p_custom_segment12 => p_custom_segment12
1630 ,p_custom_segment13 => p_custom_segment13
1631 ,p_custom_segment14 => p_custom_segment14
1632 ,p_custom_segment15 => p_custom_segment15
1633 ,p_custom_segment16 => p_custom_segment16
1634 ,p_custom_segment17 => p_custom_segment17
1635 ,p_custom_segment18 => p_custom_segment18
1636 ,p_custom_segment19 => p_custom_segment19
1637 ,p_custom_segment20 => p_custom_segment20
1638 ,p_ass_attribute_category => p_ass_attribute_category
1639 ,p_ass_attribute1 => p_ass_attribute1
1640 ,p_ass_attribute2 => p_ass_attribute2
1641 ,p_ass_attribute3 => p_ass_attribute3
1642 ,p_ass_attribute4 => p_ass_attribute4
1643 ,p_ass_attribute5 => p_ass_attribute5
1644 ,p_ass_attribute6 => p_ass_attribute6
1645 ,p_ass_attribute7 => p_ass_attribute7
1646 ,p_ass_attribute8 => p_ass_attribute8
1647 ,p_ass_attribute9 => p_ass_attribute9
1648 ,p_ass_attribute10 => p_ass_attribute10
1649 ,p_ass_attribute11 => p_ass_attribute11
1650 ,p_ass_attribute12 => p_ass_attribute12
1651 ,p_ass_attribute13 => p_ass_attribute13
1652 ,p_ass_attribute14 => p_ass_attribute14
1653 ,p_ass_attribute15 => p_ass_attribute15
1654 ,p_ass_attribute16 => p_ass_attribute16
1655 ,p_ass_attribute17 => p_ass_attribute17
1656 ,p_ass_attribute18 => p_ass_attribute18
1657 ,p_ass_attribute19 => p_ass_attribute19
1658 ,p_ass_attribute20 => p_ass_attribute20
1659 ,p_ass_attribute21 => p_ass_attribute21
1660 ,p_ass_attribute22 => p_ass_attribute22
1661 ,p_ass_attribute23 => p_ass_attribute23
1662 ,p_ass_attribute24 => p_ass_attribute24
1663 ,p_ass_attribute25 => p_ass_attribute25
1664 ,p_ass_attribute26 => p_ass_attribute26
1665 ,p_ass_attribute27 => p_ass_attribute27
1666 ,p_ass_attribute28 => p_ass_attribute28
1667 ,p_ass_attribute29 => p_ass_attribute29
1668 ,p_ass_attribute30 => p_ass_attribute30
1669 ,p_ws_comments => p_ws_comments
1670 ,p_people_group_name => p_people_group_name
1671 ,p_people_group_segment1 => p_people_group_segment1
1672 ,p_people_group_segment2 => p_people_group_segment2
1673 ,p_people_group_segment3 => p_people_group_segment3
1674 ,p_people_group_segment4 => p_people_group_segment4
1675 ,p_people_group_segment5 => p_people_group_segment5
1676 ,p_people_group_segment6 => p_people_group_segment6
1677 ,p_people_group_segment7 => p_people_group_segment7
1678 ,p_people_group_segment8 => p_people_group_segment8
1679 ,p_people_group_segment9 => p_people_group_segment9
1680 ,p_people_group_segment10 => p_people_group_segment10
1681 ,p_people_group_segment11 => p_people_group_segment11
1682 ,p_cpi_attribute_category => p_cpi_attribute_category
1683 ,p_cpi_attribute1 => p_cpi_attribute1
1684 ,p_cpi_attribute2 => p_cpi_attribute2
1685 ,p_cpi_attribute3 => p_cpi_attribute3
1686 ,p_cpi_attribute4 => p_cpi_attribute4
1687 ,p_cpi_attribute5 => p_cpi_attribute5
1688 ,p_cpi_attribute6 => p_cpi_attribute6
1689 ,p_cpi_attribute7 => p_cpi_attribute7
1690 ,p_cpi_attribute8 => p_cpi_attribute8
1691 ,p_cpi_attribute9 => p_cpi_attribute9
1692 ,p_cpi_attribute10 => p_cpi_attribute10
1693 ,p_cpi_attribute11 => p_cpi_attribute11
1694 ,p_cpi_attribute12 => p_cpi_attribute12
1695 ,p_cpi_attribute13 => p_cpi_attribute13
1696 ,p_cpi_attribute14 => p_cpi_attribute14
1697 ,p_cpi_attribute15 => p_cpi_attribute15
1698 ,p_cpi_attribute16 => p_cpi_attribute16
1699 ,p_cpi_attribute17 => p_cpi_attribute17
1700 ,p_cpi_attribute18 => p_cpi_attribute18
1701 ,p_cpi_attribute19 => p_cpi_attribute19
1702 ,p_cpi_attribute20 => p_cpi_attribute20
1703 ,p_cpi_attribute21 => p_cpi_attribute21
1704 ,p_cpi_attribute22 => p_cpi_attribute22
1705 ,p_cpi_attribute23 => p_cpi_attribute23
1706 ,p_cpi_attribute24 => p_cpi_attribute24
1707 ,p_cpi_attribute25 => p_cpi_attribute25
1708 ,p_cpi_attribute26 => p_cpi_attribute26
1709 ,p_cpi_attribute27 => p_cpi_attribute27
1710 ,p_cpi_attribute28 => p_cpi_attribute28
1711 ,p_cpi_attribute29 => p_cpi_attribute29
1712 ,p_cpi_attribute30 => p_cpi_attribute30
1713 ,p_feedback_date => p_feedback_date
1714 ,p_object_version_number => l_object_version_number
1715 );
1716 --
1717 -- Call After Process User Hook
1718 --
1719 --
1720 begin
1721 ben_cwb_person_info_bk1.create_person_info_a
1722 (p_group_per_in_ler_id => p_group_per_in_ler_id
1723 ,p_assignment_id => p_assignment_id
1724 ,p_person_id => p_person_id
1725 ,p_supervisor_id => p_supervisor_id
1726 ,p_effective_date => p_effective_date
1727 ,p_full_name => p_full_name
1728 ,p_brief_name => p_brief_name
1729 ,p_custom_name => p_custom_name
1730 ,p_supervisor_full_name => p_supervisor_full_name
1731 ,p_supervisor_brief_name => p_supervisor_brief_name
1732 ,p_supervisor_custom_name => p_supervisor_custom_name
1733 ,p_legislation_code => p_legislation_code
1734 ,p_years_employed => p_years_employed
1735 ,p_years_in_job => p_years_in_job
1736 ,p_years_in_position => p_years_in_position
1737 ,p_years_in_grade => p_years_in_grade
1738 ,p_employee_number => p_employee_number
1739 ,p_start_date => p_start_date
1740 ,p_original_start_date => p_original_start_date
1741 ,p_adjusted_svc_date => p_adjusted_svc_date
1742 ,p_base_salary => p_base_salary
1743 ,p_base_salary_change_date => p_base_salary_change_date
1744 ,p_payroll_name => p_payroll_name
1745 ,p_performance_rating => p_performance_rating
1746 ,p_performance_rating_type => p_performance_rating_type
1747 ,p_performance_rating_date => p_performance_rating_date
1748 ,p_business_group_id => p_business_group_id
1749 ,p_organization_id => p_organization_id
1750 ,p_job_id => p_job_id
1751 ,p_grade_id => p_grade_id
1752 ,p_position_id => p_position_id
1753 ,p_people_group_id => p_people_group_id
1754 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
1755 ,p_location_id => p_location_id
1756 ,p_pay_rate_id => p_pay_rate_id
1757 ,p_assignment_status_type_id => p_assignment_status_type_id
1758 ,p_frequency => p_frequency
1759 ,p_grade_annulization_factor => p_grade_annulization_factor
1760 ,p_pay_annulization_factor => p_pay_annulization_factor
1761 ,p_grd_min_val => p_grd_min_val
1762 ,p_grd_max_val => p_grd_max_val
1763 ,p_grd_mid_point => p_grd_mid_point
1764 ,p_grd_quartile => p_grd_quartile
1765 ,p_grd_comparatio => p_grd_comparatio
1766 ,p_emp_category => p_emp_category
1767 ,p_change_reason => p_change_reason
1768 ,p_normal_hours => p_normal_hours
1769 ,p_email_address => p_email_address
1770 ,p_base_salary_frequency => p_base_salary_frequency
1771 ,p_new_assgn_ovn => p_new_assgn_ovn
1772 ,p_new_perf_event_id => p_new_perf_event_id
1773 ,p_new_perf_review_id => p_new_perf_review_id
1774 ,p_post_process_stat_cd => p_post_process_stat_cd
1775 ,p_feedback_rating => p_feedback_rating
1776 ,p_feedback_comments => p_feedback_comments
1777 ,p_custom_segment1 => p_custom_segment1
1778 ,p_custom_segment2 => p_custom_segment2
1779 ,p_custom_segment3 => p_custom_segment3
1780 ,p_custom_segment4 => p_custom_segment4
1781 ,p_custom_segment5 => p_custom_segment5
1782 ,p_custom_segment6 => p_custom_segment6
1783 ,p_custom_segment7 => p_custom_segment7
1784 ,p_custom_segment8 => p_custom_segment8
1785 ,p_custom_segment9 => p_custom_segment9
1786 ,p_custom_segment10 => p_custom_segment10
1787 ,p_custom_segment11 => p_custom_segment11
1788 ,p_custom_segment12 => p_custom_segment12
1789 ,p_custom_segment13 => p_custom_segment13
1790 ,p_custom_segment14 => p_custom_segment14
1791 ,p_custom_segment15 => p_custom_segment15
1792 ,p_custom_segment16 => p_custom_segment16
1793 ,p_custom_segment17 => p_custom_segment17
1794 ,p_custom_segment18 => p_custom_segment18
1795 ,p_custom_segment19 => p_custom_segment19
1796 ,p_custom_segment20 => p_custom_segment20
1797 ,p_ass_attribute_category => p_ass_attribute_category
1798 ,p_ass_attribute1 => p_ass_attribute1
1799 ,p_ass_attribute2 => p_ass_attribute2
1800 ,p_ass_attribute3 => p_ass_attribute3
1801 ,p_ass_attribute4 => p_ass_attribute4
1802 ,p_ass_attribute5 => p_ass_attribute5
1803 ,p_ass_attribute6 => p_ass_attribute6
1804 ,p_ass_attribute7 => p_ass_attribute7
1805 ,p_ass_attribute8 => p_ass_attribute8
1806 ,p_ass_attribute9 => p_ass_attribute9
1807 ,p_ass_attribute10 => p_ass_attribute10
1808 ,p_ass_attribute11 => p_ass_attribute11
1809 ,p_ass_attribute12 => p_ass_attribute12
1810 ,p_ass_attribute13 => p_ass_attribute13
1811 ,p_ass_attribute14 => p_ass_attribute14
1812 ,p_ass_attribute15 => p_ass_attribute15
1813 ,p_ass_attribute16 => p_ass_attribute16
1814 ,p_ass_attribute17 => p_ass_attribute17
1815 ,p_ass_attribute18 => p_ass_attribute18
1816 ,p_ass_attribute19 => p_ass_attribute19
1817 ,p_ass_attribute20 => p_ass_attribute20
1818 ,p_ass_attribute21 => p_ass_attribute21
1819 ,p_ass_attribute22 => p_ass_attribute22
1820 ,p_ass_attribute23 => p_ass_attribute23
1821 ,p_ass_attribute24 => p_ass_attribute24
1822 ,p_ass_attribute25 => p_ass_attribute25
1823 ,p_ass_attribute26 => p_ass_attribute26
1824 ,p_ass_attribute27 => p_ass_attribute27
1825 ,p_ass_attribute28 => p_ass_attribute28
1826 ,p_ass_attribute29 => p_ass_attribute29
1827 ,p_ass_attribute30 => p_ass_attribute30
1828 ,p_ws_comments => p_ws_comments
1829 ,p_people_group_name => p_people_group_name
1830 ,p_people_group_segment1 => p_people_group_segment1
1831 ,p_people_group_segment2 => p_people_group_segment2
1832 ,p_people_group_segment3 => p_people_group_segment3
1833 ,p_people_group_segment4 => p_people_group_segment4
1834 ,p_people_group_segment5 => p_people_group_segment5
1835 ,p_people_group_segment6 => p_people_group_segment6
1836 ,p_people_group_segment7 => p_people_group_segment7
1837 ,p_people_group_segment8 => p_people_group_segment8
1838 ,p_people_group_segment9 => p_people_group_segment9
1839 ,p_people_group_segment10 => p_people_group_segment10
1840 ,p_people_group_segment11 => p_people_group_segment11
1841 ,p_cpi_attribute_category => p_cpi_attribute_category
1842 ,p_cpi_attribute1 => p_cpi_attribute1
1843 ,p_cpi_attribute2 => p_cpi_attribute2
1844 ,p_cpi_attribute3 => p_cpi_attribute3
1845 ,p_cpi_attribute4 => p_cpi_attribute4
1846 ,p_cpi_attribute5 => p_cpi_attribute5
1847 ,p_cpi_attribute6 => p_cpi_attribute6
1848 ,p_cpi_attribute7 => p_cpi_attribute7
1849 ,p_cpi_attribute8 => p_cpi_attribute8
1850 ,p_cpi_attribute9 => p_cpi_attribute9
1851 ,p_cpi_attribute10 => p_cpi_attribute10
1852 ,p_cpi_attribute11 => p_cpi_attribute11
1853 ,p_cpi_attribute12 => p_cpi_attribute12
1854 ,p_cpi_attribute13 => p_cpi_attribute13
1855 ,p_cpi_attribute14 => p_cpi_attribute14
1856 ,p_cpi_attribute15 => p_cpi_attribute15
1857 ,p_cpi_attribute16 => p_cpi_attribute16
1858 ,p_cpi_attribute17 => p_cpi_attribute17
1859 ,p_cpi_attribute18 => p_cpi_attribute18
1860 ,p_cpi_attribute19 => p_cpi_attribute19
1861 ,p_cpi_attribute20 => p_cpi_attribute20
1862 ,p_cpi_attribute21 => p_cpi_attribute21
1863 ,p_cpi_attribute22 => p_cpi_attribute22
1864 ,p_cpi_attribute23 => p_cpi_attribute23
1865 ,p_cpi_attribute24 => p_cpi_attribute24
1866 ,p_cpi_attribute25 => p_cpi_attribute25
1867 ,p_cpi_attribute26 => p_cpi_attribute26
1868 ,p_cpi_attribute27 => p_cpi_attribute27
1869 ,p_cpi_attribute28 => p_cpi_attribute28
1870 ,p_cpi_attribute29 => p_cpi_attribute29
1871 ,p_cpi_attribute30 => p_cpi_attribute30
1872 ,p_feedback_date => p_feedback_date
1873 ,p_object_version_number => l_object_version_number
1874 );
1875 exception
1876 when hr_api.cannot_find_prog_unit then
1877 hr_api.cannot_find_prog_unit_error
1878 (p_module_name => 'CREATE_PERSON_INFO'
1879 ,p_hook_type => 'AP'
1880 );
1881 end;
1882 --
1883 -- When in validation only mode raise the Validate_Enabled exception
1884 --
1885 if p_validate then
1886 raise hr_api.validate_enabled;
1887 end if;
1888 --
1889 -- Set all IN OUT and OUT parameters with out values
1890 --
1891 p_object_version_number := l_object_version_number;
1892 --
1893 if g_debug then
1894 hr_utility.set_location(' Leaving:'||l_proc, 70);
1895 end if;
1896 exception
1897 when hr_api.validate_enabled then
1898 --
1899 -- As the Validate_Enabled exception has been raised
1900 -- we must rollback to the savepoint
1901 --
1902 rollback to create_person_info;
1903 --
1904 if g_debug then
1905 hr_utility.set_location(' Leaving:'||l_proc, 80);
1906 end if;
1907 when others then
1908 --
1909 -- A validation or unexpected error has occured
1910 --
1911 rollback to create_person_info;
1912 --
1913 if g_debug then
1914 hr_utility.set_location(' Leaving:'||l_proc, 90);
1915 end if;
1916 raise;
1917 end create_person_info;
1918 --
1919 -- ----------------------------------------------------------------------------
1920 -- |--------------------------< update_person_info >--------------------------|
1921 -- ----------------------------------------------------------------------------
1922 --
1923 procedure update_person_info
1924 (p_validate in boolean default false
1925 ,p_group_per_in_ler_id in number
1926 ,p_assignment_id in number default hr_api.g_number
1927 ,p_person_id in number default hr_api.g_number
1928 ,p_supervisor_id in number default hr_api.g_number
1929 ,p_effective_date in date default hr_api.g_date
1930 ,p_full_name in varchar2 default hr_api.g_varchar2
1931 ,p_brief_name in varchar2 default hr_api.g_varchar2
1932 ,p_custom_name in varchar2 default hr_api.g_varchar2
1933 ,p_supervisor_full_name in varchar2 default hr_api.g_varchar2
1934 ,p_supervisor_brief_name in varchar2 default hr_api.g_varchar2
1935 ,p_supervisor_custom_name in varchar2 default hr_api.g_varchar2
1936 ,p_legislation_code in varchar2 default hr_api.g_varchar2
1937 ,p_years_employed in number default hr_api.g_number
1938 ,p_years_in_job in number default hr_api.g_number
1939 ,p_years_in_position in number default hr_api.g_number
1940 ,p_years_in_grade in number default hr_api.g_number
1941 ,p_employee_number in varchar2 default hr_api.g_varchar2
1942 ,p_start_date in date default hr_api.g_date
1943 ,p_original_start_date in date default hr_api.g_date
1944 ,p_adjusted_svc_date in date default hr_api.g_date
1945 ,p_base_salary in number default hr_api.g_number
1946 ,p_base_salary_change_date in date default hr_api.g_date
1947 ,p_payroll_name in varchar2 default hr_api.g_varchar2
1948 ,p_performance_rating in varchar2 default hr_api.g_varchar2
1949 ,p_performance_rating_type in varchar2 default hr_api.g_varchar2
1950 ,p_performance_rating_date in date default hr_api.g_date
1951 ,p_business_group_id in number default hr_api.g_number
1952 ,p_organization_id in number default hr_api.g_number
1953 ,p_job_id in number default hr_api.g_number
1954 ,p_grade_id in number default hr_api.g_number
1955 ,p_position_id in number default hr_api.g_number
1956 ,p_people_group_id in number default hr_api.g_number
1957 ,p_soft_coding_keyflex_id in number default hr_api.g_number
1958 ,p_location_id in number default hr_api.g_number
1959 ,p_pay_rate_id in number default hr_api.g_number
1960 ,p_assignment_status_type_id in Number default hr_api.g_number
1961 ,p_frequency in varchar2 default hr_api.g_varchar2
1962 ,p_grade_annulization_factor in number default hr_api.g_number
1963 ,p_pay_annulization_factor in number default hr_api.g_number
1964 ,p_grd_min_val in number default hr_api.g_number
1965 ,p_grd_max_val in number default hr_api.g_number
1966 ,p_grd_mid_point in number default hr_api.g_number
1967 ,p_grd_quartile in varchar2 default hr_api.g_varchar2
1968 ,p_grd_comparatio in Number default hr_api.g_number
1969 ,p_emp_category in varchar2 default hr_api.g_varchar2
1970 ,p_change_reason in varchar2 default hr_api.g_varchar2
1971 ,p_normal_hours in number default hr_api.g_number
1972 ,p_email_address in varchar2 default hr_api.g_varchar2
1973 ,p_base_salary_frequency in varchar2 default hr_api.g_varchar2
1974 ,p_new_assgn_ovn in number default hr_api.g_number
1975 ,p_new_perf_event_id in number default hr_api.g_number
1976 ,p_new_perf_review_id in number default hr_api.g_number
1977 ,p_post_process_stat_cd in varchar2 default hr_api.g_varchar2
1978 ,p_feedback_rating in varchar2 default hr_api.g_varchar2
1979 ,p_feedback_comments in varchar2 default hr_api.g_varchar2
1980 ,p_custom_segment1 in Varchar2 default hr_api.g_varchar2
1981 ,p_custom_segment2 in Varchar2 default hr_api.g_varchar2
1982 ,p_custom_segment3 in Varchar2 default hr_api.g_varchar2
1983 ,p_custom_segment4 in Varchar2 default hr_api.g_varchar2
1984 ,p_custom_segment5 in Varchar2 default hr_api.g_varchar2
1985 ,p_custom_segment6 in Varchar2 default hr_api.g_varchar2
1986 ,p_custom_segment7 in Varchar2 default hr_api.g_varchar2
1987 ,p_custom_segment8 in Varchar2 default hr_api.g_varchar2
1988 ,p_custom_segment9 in Varchar2 default hr_api.g_varchar2
1989 ,p_custom_segment10 in Varchar2 default hr_api.g_varchar2
1990 ,p_custom_segment11 in number default hr_api.g_number
1991 ,p_custom_segment12 in number default hr_api.g_number
1992 ,p_custom_segment13 in number default hr_api.g_number
1993 ,p_custom_segment14 in number default hr_api.g_number
1994 ,p_custom_segment15 in number default hr_api.g_number
1995 ,p_custom_segment16 in number default hr_api.g_number
1996 ,p_custom_segment17 in number default hr_api.g_number
1997 ,p_custom_segment18 in number default hr_api.g_number
1998 ,p_custom_segment19 in number default hr_api.g_number
1999 ,p_custom_segment20 in number default hr_api.g_number
2000 ,p_ass_attribute_category in Varchar2 default hr_api.g_varchar2
2001 ,p_ass_attribute1 in Varchar2 default hr_api.g_varchar2
2002 ,p_ass_attribute2 in Varchar2 default hr_api.g_varchar2
2003 ,p_ass_attribute3 in Varchar2 default hr_api.g_varchar2
2004 ,p_ass_attribute4 in Varchar2 default hr_api.g_varchar2
2005 ,p_ass_attribute5 in Varchar2 default hr_api.g_varchar2
2006 ,p_ass_attribute6 in Varchar2 default hr_api.g_varchar2
2007 ,p_ass_attribute7 in Varchar2 default hr_api.g_varchar2
2008 ,p_ass_attribute8 in Varchar2 default hr_api.g_varchar2
2009 ,p_ass_attribute9 in Varchar2 default hr_api.g_varchar2
2010 ,p_ass_attribute10 in Varchar2 default hr_api.g_varchar2
2011 ,p_ass_attribute11 in Varchar2 default hr_api.g_varchar2
2012 ,p_ass_attribute12 in Varchar2 default hr_api.g_varchar2
2013 ,p_ass_attribute13 in Varchar2 default hr_api.g_varchar2
2014 ,p_ass_attribute14 in Varchar2 default hr_api.g_varchar2
2015 ,p_ass_attribute15 in Varchar2 default hr_api.g_varchar2
2016 ,p_ass_attribute16 in Varchar2 default hr_api.g_varchar2
2017 ,p_ass_attribute17 in Varchar2 default hr_api.g_varchar2
2018 ,p_ass_attribute18 in Varchar2 default hr_api.g_varchar2
2019 ,p_ass_attribute19 in Varchar2 default hr_api.g_varchar2
2020 ,p_ass_attribute20 in Varchar2 default hr_api.g_varchar2
2021 ,p_ass_attribute21 in Varchar2 default hr_api.g_varchar2
2022 ,p_ass_attribute22 in Varchar2 default hr_api.g_varchar2
2023 ,p_ass_attribute23 in Varchar2 default hr_api.g_varchar2
2024 ,p_ass_attribute24 in Varchar2 default hr_api.g_varchar2
2025 ,p_ass_attribute25 in Varchar2 default hr_api.g_varchar2
2026 ,p_ass_attribute26 in Varchar2 default hr_api.g_varchar2
2027 ,p_ass_attribute27 in Varchar2 default hr_api.g_varchar2
2028 ,p_ass_attribute28 in Varchar2 default hr_api.g_varchar2
2029 ,p_ass_attribute29 in Varchar2 default hr_api.g_varchar2
2030 ,p_ass_attribute30 in Varchar2 default hr_api.g_varchar2
2031 ,p_ws_comments in Varchar2 default hr_api.g_varchar2
2032 ,p_people_group_name in varchar2 default hr_api.g_varchar2
2033 ,p_people_group_segment1 in varchar2 default hr_api.g_varchar2
2034 ,p_people_group_segment2 in varchar2 default hr_api.g_varchar2
2035 ,p_people_group_segment3 in varchar2 default hr_api.g_varchar2
2036 ,p_people_group_segment4 in varchar2 default hr_api.g_varchar2
2037 ,p_people_group_segment5 in varchar2 default hr_api.g_varchar2
2038 ,p_people_group_segment6 in varchar2 default hr_api.g_varchar2
2039 ,p_people_group_segment7 in varchar2 default hr_api.g_varchar2
2040 ,p_people_group_segment8 in varchar2 default hr_api.g_varchar2
2041 ,p_people_group_segment9 in varchar2 default hr_api.g_varchar2
2042 ,p_people_group_segment10 in varchar2 default hr_api.g_varchar2
2043 ,p_people_group_segment11 in varchar2 default hr_api.g_varchar2
2044 ,p_cpi_attribute_category in varchar2 default hr_api.g_varchar2
2045 ,p_cpi_attribute1 in varchar2 default hr_api.g_varchar2
2046 ,p_cpi_attribute2 in varchar2 default hr_api.g_varchar2
2047 ,p_cpi_attribute3 in varchar2 default hr_api.g_varchar2
2048 ,p_cpi_attribute4 in varchar2 default hr_api.g_varchar2
2049 ,p_cpi_attribute5 in varchar2 default hr_api.g_varchar2
2050 ,p_cpi_attribute6 in varchar2 default hr_api.g_varchar2
2051 ,p_cpi_attribute7 in varchar2 default hr_api.g_varchar2
2052 ,p_cpi_attribute8 in varchar2 default hr_api.g_varchar2
2053 ,p_cpi_attribute9 in varchar2 default hr_api.g_varchar2
2054 ,p_cpi_attribute10 in varchar2 default hr_api.g_varchar2
2055 ,p_cpi_attribute11 in varchar2 default hr_api.g_varchar2
2056 ,p_cpi_attribute12 in varchar2 default hr_api.g_varchar2
2057 ,p_cpi_attribute13 in varchar2 default hr_api.g_varchar2
2058 ,p_cpi_attribute14 in varchar2 default hr_api.g_varchar2
2059 ,p_cpi_attribute15 in varchar2 default hr_api.g_varchar2
2060 ,p_cpi_attribute16 in varchar2 default hr_api.g_varchar2
2061 ,p_cpi_attribute17 in varchar2 default hr_api.g_varchar2
2062 ,p_cpi_attribute18 in varchar2 default hr_api.g_varchar2
2063 ,p_cpi_attribute19 in varchar2 default hr_api.g_varchar2
2064 ,p_cpi_attribute20 in varchar2 default hr_api.g_varchar2
2065 ,p_cpi_attribute21 in varchar2 default hr_api.g_varchar2
2066 ,p_cpi_attribute22 in varchar2 default hr_api.g_varchar2
2067 ,p_cpi_attribute23 in varchar2 default hr_api.g_varchar2
2068 ,p_cpi_attribute24 in varchar2 default hr_api.g_varchar2
2069 ,p_cpi_attribute25 in varchar2 default hr_api.g_varchar2
2070 ,p_cpi_attribute26 in varchar2 default hr_api.g_varchar2
2071 ,p_cpi_attribute27 in varchar2 default hr_api.g_varchar2
2072 ,p_cpi_attribute28 in varchar2 default hr_api.g_varchar2
2073 ,p_cpi_attribute29 in varchar2 default hr_api.g_varchar2
2074 ,p_cpi_attribute30 in varchar2 default hr_api.g_varchar2
2075 ,p_feedback_date in date default hr_api.g_date
2076 ,p_object_version_number in out nocopy number
2077 ) is
2078 --
2079 -- Declare cursors and local variables
2080 --
2081 l_object_version_number number;
2082 --
2083 l_proc varchar2(72) := g_package||'update_person_info';
2084 l_old_record ben_cwb_person_info%rowtype;
2085 begin
2086 -- get old record
2087
2088 select * into l_old_record
2089 from ben_cwb_person_info
2090 where group_per_in_ler_id = p_group_per_in_ler_id;
2091
2092 if g_debug then
2093 hr_utility.set_location('Entering:'|| l_proc, 10);
2094 end if;
2095 --
2096 -- Issue a savepoint
2097 --
2098 savepoint update_person_info;
2099 --
2100 -- Remember IN OUT parameter IN values
2101 --
2102 l_object_version_number := p_object_version_number;
2103 --
2104 -- Call Before Process User Hook
2105 --
2106 begin
2107 ben_cwb_person_info_bk2.update_person_info_b
2108 (p_group_per_in_ler_id => p_group_per_in_ler_id
2109 ,p_assignment_id => p_assignment_id
2110 ,p_person_id => p_person_id
2111 ,p_supervisor_id => p_supervisor_id
2112 ,p_effective_date => p_effective_date
2113 ,p_full_name => p_full_name
2114 ,p_brief_name => p_brief_name
2115 ,p_custom_name => p_custom_name
2116 ,p_supervisor_full_name => p_supervisor_full_name
2117 ,p_supervisor_brief_name => p_supervisor_brief_name
2118 ,p_supervisor_custom_name => p_supervisor_custom_name
2119 ,p_legislation_code => p_legislation_code
2120 ,p_years_employed => p_years_employed
2121 ,p_years_in_job => p_years_in_job
2122 ,p_years_in_position => p_years_in_position
2123 ,p_years_in_grade => p_years_in_grade
2124 ,p_employee_number => p_employee_number
2125 ,p_start_date => p_start_date
2126 ,p_original_start_date => p_original_start_date
2127 ,p_adjusted_svc_date => p_adjusted_svc_date
2128 ,p_base_salary => p_base_salary
2129 ,p_base_salary_change_date => p_base_salary_change_date
2130 ,p_payroll_name => p_payroll_name
2131 ,p_performance_rating => p_performance_rating
2132 ,p_performance_rating_type => p_performance_rating_type
2133 ,p_performance_rating_date => p_performance_rating_date
2134 ,p_business_group_id => p_business_group_id
2135 ,p_organization_id => p_organization_id
2136 ,p_job_id => p_job_id
2137 ,p_grade_id => p_grade_id
2138 ,p_position_id => p_position_id
2139 ,p_people_group_id => p_people_group_id
2140 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
2141 ,p_location_id => p_location_id
2142 ,p_pay_rate_id => p_pay_rate_id
2143 ,p_assignment_status_type_id => p_assignment_status_type_id
2144 ,p_frequency => p_frequency
2145 ,p_grade_annulization_factor => p_grade_annulization_factor
2146 ,p_pay_annulization_factor => p_pay_annulization_factor
2147 ,p_grd_min_val => p_grd_min_val
2148 ,p_grd_max_val => p_grd_max_val
2149 ,p_grd_mid_point => p_grd_mid_point
2150 ,p_grd_quartile => p_grd_quartile
2151 ,p_grd_comparatio => p_grd_comparatio
2152 ,p_emp_category => p_emp_category
2153 ,p_change_reason => p_change_reason
2154 ,p_normal_hours => p_normal_hours
2155 ,p_email_address => p_email_address
2156 ,p_base_salary_frequency => p_base_salary_frequency
2157 ,p_new_assgn_ovn => p_new_assgn_ovn
2158 ,p_new_perf_event_id => p_new_perf_event_id
2159 ,p_new_perf_review_id => p_new_perf_review_id
2160 ,p_post_process_stat_cd => p_post_process_stat_cd
2161 ,p_feedback_rating => p_feedback_rating
2162 ,p_feedback_comments => p_feedback_comments
2163 ,p_custom_segment1 => p_custom_segment1
2164 ,p_custom_segment2 => p_custom_segment2
2165 ,p_custom_segment3 => p_custom_segment3
2166 ,p_custom_segment4 => p_custom_segment4
2167 ,p_custom_segment5 => p_custom_segment5
2168 ,p_custom_segment6 => p_custom_segment6
2169 ,p_custom_segment7 => p_custom_segment7
2170 ,p_custom_segment8 => p_custom_segment8
2171 ,p_custom_segment9 => p_custom_segment9
2172 ,p_custom_segment10 => p_custom_segment10
2173 ,p_custom_segment11 => p_custom_segment11
2174 ,p_custom_segment12 => p_custom_segment12
2175 ,p_custom_segment13 => p_custom_segment13
2176 ,p_custom_segment14 => p_custom_segment14
2177 ,p_custom_segment15 => p_custom_segment15
2178 ,p_custom_segment16 => p_custom_segment16
2179 ,p_custom_segment17 => p_custom_segment17
2180 ,p_custom_segment18 => p_custom_segment18
2181 ,p_custom_segment19 => p_custom_segment19
2182 ,p_custom_segment20 => p_custom_segment20
2183 ,p_ass_attribute_category => p_ass_attribute_category
2184 ,p_ass_attribute1 => p_ass_attribute1
2185 ,p_ass_attribute2 => p_ass_attribute2
2186 ,p_ass_attribute3 => p_ass_attribute3
2187 ,p_ass_attribute4 => p_ass_attribute4
2188 ,p_ass_attribute5 => p_ass_attribute5
2189 ,p_ass_attribute6 => p_ass_attribute6
2190 ,p_ass_attribute7 => p_ass_attribute7
2191 ,p_ass_attribute8 => p_ass_attribute8
2192 ,p_ass_attribute9 => p_ass_attribute9
2193 ,p_ass_attribute10 => p_ass_attribute10
2194 ,p_ass_attribute11 => p_ass_attribute11
2195 ,p_ass_attribute12 => p_ass_attribute12
2196 ,p_ass_attribute13 => p_ass_attribute13
2197 ,p_ass_attribute14 => p_ass_attribute14
2198 ,p_ass_attribute15 => p_ass_attribute15
2199 ,p_ass_attribute16 => p_ass_attribute16
2200 ,p_ass_attribute17 => p_ass_attribute17
2201 ,p_ass_attribute18 => p_ass_attribute18
2202 ,p_ass_attribute19 => p_ass_attribute19
2203 ,p_ass_attribute20 => p_ass_attribute20
2204 ,p_ass_attribute21 => p_ass_attribute21
2205 ,p_ass_attribute22 => p_ass_attribute22
2206 ,p_ass_attribute23 => p_ass_attribute23
2207 ,p_ass_attribute24 => p_ass_attribute24
2208 ,p_ass_attribute25 => p_ass_attribute25
2209 ,p_ass_attribute26 => p_ass_attribute26
2210 ,p_ass_attribute27 => p_ass_attribute27
2211 ,p_ass_attribute28 => p_ass_attribute28
2212 ,p_ass_attribute29 => p_ass_attribute29
2213 ,p_ass_attribute30 => p_ass_attribute30
2214 ,p_ws_comments => p_ws_comments
2215 ,p_people_group_name => p_people_group_name
2216 ,p_people_group_segment1 => p_people_group_segment1
2217 ,p_people_group_segment2 => p_people_group_segment2
2218 ,p_people_group_segment3 => p_people_group_segment3
2219 ,p_people_group_segment4 => p_people_group_segment4
2220 ,p_people_group_segment5 => p_people_group_segment5
2221 ,p_people_group_segment6 => p_people_group_segment6
2222 ,p_people_group_segment7 => p_people_group_segment7
2223 ,p_people_group_segment8 => p_people_group_segment8
2224 ,p_people_group_segment9 => p_people_group_segment9
2225 ,p_people_group_segment10 => p_people_group_segment10
2226 ,p_people_group_segment11 => p_people_group_segment11
2227 ,p_cpi_attribute_category => p_cpi_attribute_category
2228 ,p_cpi_attribute1 => p_cpi_attribute1
2229 ,p_cpi_attribute2 => p_cpi_attribute2
2230 ,p_cpi_attribute3 => p_cpi_attribute3
2231 ,p_cpi_attribute4 => p_cpi_attribute4
2232 ,p_cpi_attribute5 => p_cpi_attribute5
2233 ,p_cpi_attribute6 => p_cpi_attribute6
2234 ,p_cpi_attribute7 => p_cpi_attribute7
2235 ,p_cpi_attribute8 => p_cpi_attribute8
2236 ,p_cpi_attribute9 => p_cpi_attribute9
2237 ,p_cpi_attribute10 => p_cpi_attribute10
2238 ,p_cpi_attribute11 => p_cpi_attribute11
2239 ,p_cpi_attribute12 => p_cpi_attribute12
2240 ,p_cpi_attribute13 => p_cpi_attribute13
2241 ,p_cpi_attribute14 => p_cpi_attribute14
2242 ,p_cpi_attribute15 => p_cpi_attribute15
2243 ,p_cpi_attribute16 => p_cpi_attribute16
2244 ,p_cpi_attribute17 => p_cpi_attribute17
2245 ,p_cpi_attribute18 => p_cpi_attribute18
2246 ,p_cpi_attribute19 => p_cpi_attribute19
2247 ,p_cpi_attribute20 => p_cpi_attribute20
2248 ,p_cpi_attribute21 => p_cpi_attribute21
2249 ,p_cpi_attribute22 => p_cpi_attribute22
2250 ,p_cpi_attribute23 => p_cpi_attribute23
2251 ,p_cpi_attribute24 => p_cpi_attribute24
2252 ,p_cpi_attribute25 => p_cpi_attribute25
2253 ,p_cpi_attribute26 => p_cpi_attribute26
2254 ,p_cpi_attribute27 => p_cpi_attribute27
2255 ,p_cpi_attribute28 => p_cpi_attribute28
2256 ,p_cpi_attribute29 => p_cpi_attribute29
2257 ,p_cpi_attribute30 => p_cpi_attribute30
2258 ,p_feedback_date => p_feedback_date
2259 ,p_object_version_number => l_object_version_number
2260 );
2261 exception
2262 when hr_api.cannot_find_prog_unit then
2263 hr_api.cannot_find_prog_unit_error
2264 (p_module_name => 'UPDATE_PERSON_INFO'
2265 ,p_hook_type => 'BP'
2266 );
2267 end;
2268 --
2269 -- Validation in addition to Row Handlers
2270 --
2271
2272 --
2273 -- Process Logic
2274 --
2275 ben_cpi_upd.upd
2276 (p_group_per_in_ler_id => p_group_per_in_ler_id
2277 ,p_assignment_id => p_assignment_id
2278 ,p_person_id => p_person_id
2279 ,p_supervisor_id => p_supervisor_id
2280 ,p_effective_date => p_effective_date
2281 ,p_full_name => p_full_name
2282 ,p_brief_name => p_brief_name
2283 ,p_custom_name => p_custom_name
2284 ,p_supervisor_full_name => p_supervisor_full_name
2285 ,p_supervisor_brief_name => p_supervisor_brief_name
2286 ,p_supervisor_custom_name => p_supervisor_custom_name
2287 ,p_legislation_code => p_legislation_code
2288 ,p_years_employed => p_years_employed
2289 ,p_years_in_job => p_years_in_job
2290 ,p_years_in_position => p_years_in_position
2291 ,p_years_in_grade => p_years_in_grade
2292 ,p_employee_number => p_employee_number
2293 ,p_start_date => p_start_date
2294 ,p_original_start_date => p_original_start_date
2295 ,p_adjusted_svc_date => p_adjusted_svc_date
2296 ,p_base_salary => p_base_salary
2297 ,p_base_salary_change_date => p_base_salary_change_date
2298 ,p_payroll_name => p_payroll_name
2299 ,p_performance_rating => p_performance_rating
2300 ,p_performance_rating_type => p_performance_rating_type
2301 ,p_performance_rating_date => p_performance_rating_date
2302 ,p_business_group_id => p_business_group_id
2303 ,p_organization_id => p_organization_id
2304 ,p_job_id => p_job_id
2305 ,p_grade_id => p_grade_id
2306 ,p_position_id => p_position_id
2307 ,p_people_group_id => p_people_group_id
2308 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
2309 ,p_location_id => p_location_id
2310 ,p_pay_rate_id => p_pay_rate_id
2311 ,p_assignment_status_type_id => p_assignment_status_type_id
2312 ,p_frequency => p_frequency
2313 ,p_grade_annulization_factor => p_grade_annulization_factor
2314 ,p_pay_annulization_factor => p_pay_annulization_factor
2315 ,p_grd_min_val => p_grd_min_val
2316 ,p_grd_max_val => p_grd_max_val
2317 ,p_grd_mid_point => p_grd_mid_point
2318 ,p_grd_quartile => p_grd_quartile
2319 ,p_grd_comparatio => p_grd_comparatio
2320 ,p_emp_category => p_emp_category
2321 ,p_change_reason => p_change_reason
2322 ,p_normal_hours => p_normal_hours
2323 ,p_email_address => p_email_address
2324 ,p_base_salary_frequency => p_base_salary_frequency
2325 ,p_new_assgn_ovn => p_new_assgn_ovn
2326 ,p_new_perf_event_id => p_new_perf_event_id
2327 ,p_new_perf_review_id => p_new_perf_review_id
2328 ,p_post_process_stat_cd => p_post_process_stat_cd
2329 ,p_feedback_rating => p_feedback_rating
2330 ,p_feedback_comments => p_feedback_comments
2331 ,p_custom_segment1 => p_custom_segment1
2332 ,p_custom_segment2 => p_custom_segment2
2333 ,p_custom_segment3 => p_custom_segment3
2334 ,p_custom_segment4 => p_custom_segment4
2335 ,p_custom_segment5 => p_custom_segment5
2336 ,p_custom_segment6 => p_custom_segment6
2337 ,p_custom_segment7 => p_custom_segment7
2338 ,p_custom_segment8 => p_custom_segment8
2339 ,p_custom_segment9 => p_custom_segment9
2340 ,p_custom_segment10 => p_custom_segment10
2341 ,p_custom_segment11 => p_custom_segment11
2342 ,p_custom_segment12 => p_custom_segment12
2343 ,p_custom_segment13 => p_custom_segment13
2344 ,p_custom_segment14 => p_custom_segment14
2345 ,p_custom_segment15 => p_custom_segment15
2346 ,p_custom_segment16 => p_custom_segment16
2347 ,p_custom_segment17 => p_custom_segment17
2348 ,p_custom_segment18 => p_custom_segment18
2349 ,p_custom_segment19 => p_custom_segment19
2350 ,p_custom_segment20 => p_custom_segment20
2351 ,p_ass_attribute_category => p_ass_attribute_category
2352 ,p_ass_attribute1 => p_ass_attribute1
2353 ,p_ass_attribute2 => p_ass_attribute2
2354 ,p_ass_attribute3 => p_ass_attribute3
2355 ,p_ass_attribute4 => p_ass_attribute4
2356 ,p_ass_attribute5 => p_ass_attribute5
2357 ,p_ass_attribute6 => p_ass_attribute6
2358 ,p_ass_attribute7 => p_ass_attribute7
2359 ,p_ass_attribute8 => p_ass_attribute8
2360 ,p_ass_attribute9 => p_ass_attribute9
2361 ,p_ass_attribute10 => p_ass_attribute10
2362 ,p_ass_attribute11 => p_ass_attribute11
2363 ,p_ass_attribute12 => p_ass_attribute12
2364 ,p_ass_attribute13 => p_ass_attribute13
2365 ,p_ass_attribute14 => p_ass_attribute14
2366 ,p_ass_attribute15 => p_ass_attribute15
2367 ,p_ass_attribute16 => p_ass_attribute16
2368 ,p_ass_attribute17 => p_ass_attribute17
2369 ,p_ass_attribute18 => p_ass_attribute18
2370 ,p_ass_attribute19 => p_ass_attribute19
2371 ,p_ass_attribute20 => p_ass_attribute20
2372 ,p_ass_attribute21 => p_ass_attribute21
2373 ,p_ass_attribute22 => p_ass_attribute22
2374 ,p_ass_attribute23 => p_ass_attribute23
2375 ,p_ass_attribute24 => p_ass_attribute24
2376 ,p_ass_attribute25 => p_ass_attribute25
2377 ,p_ass_attribute26 => p_ass_attribute26
2378 ,p_ass_attribute27 => p_ass_attribute27
2379 ,p_ass_attribute28 => p_ass_attribute28
2380 ,p_ass_attribute29 => p_ass_attribute29
2381 ,p_ass_attribute30 => p_ass_attribute30
2382 ,p_ws_comments => p_ws_comments
2383 ,p_people_group_name => p_people_group_name
2384 ,p_people_group_segment1 => p_people_group_segment1
2385 ,p_people_group_segment2 => p_people_group_segment2
2386 ,p_people_group_segment3 => p_people_group_segment3
2387 ,p_people_group_segment4 => p_people_group_segment4
2388 ,p_people_group_segment5 => p_people_group_segment5
2389 ,p_people_group_segment6 => p_people_group_segment6
2390 ,p_people_group_segment7 => p_people_group_segment7
2391 ,p_people_group_segment8 => p_people_group_segment8
2392 ,p_people_group_segment9 => p_people_group_segment9
2393 ,p_people_group_segment10 => p_people_group_segment10
2394 ,p_people_group_segment11 => p_people_group_segment11
2395 ,p_cpi_attribute_category => p_cpi_attribute_category
2396 ,p_cpi_attribute1 => p_cpi_attribute1
2397 ,p_cpi_attribute2 => p_cpi_attribute2
2398 ,p_cpi_attribute3 => p_cpi_attribute3
2399 ,p_cpi_attribute4 => p_cpi_attribute4
2400 ,p_cpi_attribute5 => p_cpi_attribute5
2401 ,p_cpi_attribute6 => p_cpi_attribute6
2402 ,p_cpi_attribute7 => p_cpi_attribute7
2403 ,p_cpi_attribute8 => p_cpi_attribute8
2404 ,p_cpi_attribute9 => p_cpi_attribute9
2405 ,p_cpi_attribute10 => p_cpi_attribute10
2406 ,p_cpi_attribute11 => p_cpi_attribute11
2407 ,p_cpi_attribute12 => p_cpi_attribute12
2408 ,p_cpi_attribute13 => p_cpi_attribute13
2409 ,p_cpi_attribute14 => p_cpi_attribute14
2410 ,p_cpi_attribute15 => p_cpi_attribute15
2411 ,p_cpi_attribute16 => p_cpi_attribute16
2412 ,p_cpi_attribute17 => p_cpi_attribute17
2413 ,p_cpi_attribute18 => p_cpi_attribute18
2414 ,p_cpi_attribute19 => p_cpi_attribute19
2415 ,p_cpi_attribute20 => p_cpi_attribute20
2416 ,p_cpi_attribute21 => p_cpi_attribute21
2417 ,p_cpi_attribute22 => p_cpi_attribute22
2418 ,p_cpi_attribute23 => p_cpi_attribute23
2419 ,p_cpi_attribute24 => p_cpi_attribute24
2420 ,p_cpi_attribute25 => p_cpi_attribute25
2421 ,p_cpi_attribute26 => p_cpi_attribute26
2422 ,p_cpi_attribute27 => p_cpi_attribute27
2423 ,p_cpi_attribute28 => p_cpi_attribute28
2424 ,p_cpi_attribute29 => p_cpi_attribute29
2425 ,p_cpi_attribute30 => p_cpi_attribute30
2426 ,p_feedback_date => p_feedback_date
2427 ,p_object_version_number => l_object_version_number
2428 );
2429 --
2430 -- Call After Process User Hook
2431 --
2432 --
2433 begin
2434 ben_cwb_person_info_bk2.update_person_info_a
2435 (p_group_per_in_ler_id => p_group_per_in_ler_id
2436 ,p_assignment_id => p_assignment_id
2437 ,p_person_id => p_person_id
2438 ,p_supervisor_id => p_supervisor_id
2439 ,p_effective_date => p_effective_date
2440 ,p_full_name => p_full_name
2441 ,p_brief_name => p_brief_name
2442 ,p_custom_name => p_custom_name
2443 ,p_supervisor_full_name => p_supervisor_full_name
2444 ,p_supervisor_brief_name => p_supervisor_brief_name
2445 ,p_supervisor_custom_name => p_supervisor_custom_name
2446 ,p_legislation_code => p_legislation_code
2447 ,p_years_employed => p_years_employed
2448 ,p_years_in_job => p_years_in_job
2449 ,p_years_in_position => p_years_in_position
2450 ,p_years_in_grade => p_years_in_grade
2451 ,p_employee_number => p_employee_number
2452 ,p_start_date => p_start_date
2453 ,p_original_start_date => p_original_start_date
2454 ,p_adjusted_svc_date => p_adjusted_svc_date
2455 ,p_base_salary => p_base_salary
2456 ,p_base_salary_change_date => p_base_salary_change_date
2457 ,p_payroll_name => p_payroll_name
2458 ,p_performance_rating => p_performance_rating
2459 ,p_performance_rating_type => p_performance_rating_type
2460 ,p_performance_rating_date => p_performance_rating_date
2461 ,p_business_group_id => p_business_group_id
2462 ,p_organization_id => p_organization_id
2463 ,p_job_id => p_job_id
2464 ,p_grade_id => p_grade_id
2465 ,p_position_id => p_position_id
2466 ,p_people_group_id => p_people_group_id
2467 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
2468 ,p_location_id => p_location_id
2469 ,p_pay_rate_id => p_pay_rate_id
2470 ,p_assignment_status_type_id => p_assignment_status_type_id
2471 ,p_frequency => p_frequency
2472 ,p_grade_annulization_factor => p_grade_annulization_factor
2473 ,p_pay_annulization_factor => p_pay_annulization_factor
2474 ,p_grd_min_val => p_grd_min_val
2475 ,p_grd_max_val => p_grd_max_val
2476 ,p_grd_mid_point => p_grd_mid_point
2477 ,p_grd_quartile => p_grd_quartile
2478 ,p_grd_comparatio => p_grd_comparatio
2479 ,p_emp_category => p_emp_category
2480 ,p_change_reason => p_change_reason
2481 ,p_normal_hours => p_normal_hours
2482 ,p_email_address => p_email_address
2483 ,p_base_salary_frequency => p_base_salary_frequency
2484 ,p_new_assgn_ovn => p_new_assgn_ovn
2485 ,p_new_perf_event_id => p_new_perf_event_id
2486 ,p_new_perf_review_id => p_new_perf_review_id
2487 ,p_post_process_stat_cd => p_post_process_stat_cd
2488 ,p_feedback_rating => p_feedback_rating
2489 ,p_feedback_comments => p_feedback_comments
2490 ,p_custom_segment1 => p_custom_segment1
2491 ,p_custom_segment2 => p_custom_segment2
2492 ,p_custom_segment3 => p_custom_segment3
2493 ,p_custom_segment4 => p_custom_segment4
2494 ,p_custom_segment5 => p_custom_segment5
2495 ,p_custom_segment6 => p_custom_segment6
2496 ,p_custom_segment7 => p_custom_segment7
2497 ,p_custom_segment8 => p_custom_segment8
2498 ,p_custom_segment9 => p_custom_segment9
2499 ,p_custom_segment10 => p_custom_segment10
2500 ,p_custom_segment11 => p_custom_segment11
2501 ,p_custom_segment12 => p_custom_segment12
2502 ,p_custom_segment13 => p_custom_segment13
2503 ,p_custom_segment14 => p_custom_segment14
2504 ,p_custom_segment15 => p_custom_segment15
2505 ,p_custom_segment16 => p_custom_segment16
2506 ,p_custom_segment17 => p_custom_segment17
2507 ,p_custom_segment18 => p_custom_segment18
2508 ,p_custom_segment19 => p_custom_segment19
2509 ,p_custom_segment20 => p_custom_segment20
2510 ,p_ass_attribute_category => p_ass_attribute_category
2511 ,p_ass_attribute1 => p_ass_attribute1
2512 ,p_ass_attribute2 => p_ass_attribute2
2513 ,p_ass_attribute3 => p_ass_attribute3
2514 ,p_ass_attribute4 => p_ass_attribute4
2515 ,p_ass_attribute5 => p_ass_attribute5
2516 ,p_ass_attribute6 => p_ass_attribute6
2517 ,p_ass_attribute7 => p_ass_attribute7
2518 ,p_ass_attribute8 => p_ass_attribute8
2519 ,p_ass_attribute9 => p_ass_attribute9
2520 ,p_ass_attribute10 => p_ass_attribute10
2521 ,p_ass_attribute11 => p_ass_attribute11
2522 ,p_ass_attribute12 => p_ass_attribute12
2523 ,p_ass_attribute13 => p_ass_attribute13
2524 ,p_ass_attribute14 => p_ass_attribute14
2525 ,p_ass_attribute15 => p_ass_attribute15
2526 ,p_ass_attribute16 => p_ass_attribute16
2527 ,p_ass_attribute17 => p_ass_attribute17
2528 ,p_ass_attribute18 => p_ass_attribute18
2529 ,p_ass_attribute19 => p_ass_attribute19
2530 ,p_ass_attribute20 => p_ass_attribute20
2531 ,p_ass_attribute21 => p_ass_attribute21
2532 ,p_ass_attribute22 => p_ass_attribute22
2533 ,p_ass_attribute23 => p_ass_attribute23
2534 ,p_ass_attribute24 => p_ass_attribute24
2535 ,p_ass_attribute25 => p_ass_attribute25
2536 ,p_ass_attribute26 => p_ass_attribute26
2537 ,p_ass_attribute27 => p_ass_attribute27
2538 ,p_ass_attribute28 => p_ass_attribute28
2539 ,p_ass_attribute29 => p_ass_attribute29
2540 ,p_ass_attribute30 => p_ass_attribute30
2541 ,p_ws_comments => p_ws_comments
2542 ,p_people_group_name => p_people_group_name
2543 ,p_people_group_segment1 => p_people_group_segment1
2544 ,p_people_group_segment2 => p_people_group_segment2
2545 ,p_people_group_segment3 => p_people_group_segment3
2546 ,p_people_group_segment4 => p_people_group_segment4
2547 ,p_people_group_segment5 => p_people_group_segment5
2548 ,p_people_group_segment6 => p_people_group_segment6
2549 ,p_people_group_segment7 => p_people_group_segment7
2550 ,p_people_group_segment8 => p_people_group_segment8
2551 ,p_people_group_segment9 => p_people_group_segment9
2552 ,p_people_group_segment10 => p_people_group_segment10
2553 ,p_people_group_segment11 => p_people_group_segment11
2554 ,p_cpi_attribute_category => p_cpi_attribute_category
2555 ,p_cpi_attribute1 => p_cpi_attribute1
2556 ,p_cpi_attribute2 => p_cpi_attribute2
2557 ,p_cpi_attribute3 => p_cpi_attribute3
2558 ,p_cpi_attribute4 => p_cpi_attribute4
2559 ,p_cpi_attribute5 => p_cpi_attribute5
2560 ,p_cpi_attribute6 => p_cpi_attribute6
2561 ,p_cpi_attribute7 => p_cpi_attribute7
2562 ,p_cpi_attribute8 => p_cpi_attribute8
2563 ,p_cpi_attribute9 => p_cpi_attribute9
2564 ,p_cpi_attribute10 => p_cpi_attribute10
2565 ,p_cpi_attribute11 => p_cpi_attribute11
2566 ,p_cpi_attribute12 => p_cpi_attribute12
2567 ,p_cpi_attribute13 => p_cpi_attribute13
2568 ,p_cpi_attribute14 => p_cpi_attribute14
2569 ,p_cpi_attribute15 => p_cpi_attribute15
2570 ,p_cpi_attribute16 => p_cpi_attribute16
2571 ,p_cpi_attribute17 => p_cpi_attribute17
2572 ,p_cpi_attribute18 => p_cpi_attribute18
2573 ,p_cpi_attribute19 => p_cpi_attribute19
2574 ,p_cpi_attribute20 => p_cpi_attribute20
2575 ,p_cpi_attribute21 => p_cpi_attribute21
2576 ,p_cpi_attribute22 => p_cpi_attribute22
2577 ,p_cpi_attribute23 => p_cpi_attribute23
2578 ,p_cpi_attribute24 => p_cpi_attribute24
2579 ,p_cpi_attribute25 => p_cpi_attribute25
2580 ,p_cpi_attribute26 => p_cpi_attribute26
2581 ,p_cpi_attribute27 => p_cpi_attribute27
2582 ,p_cpi_attribute28 => p_cpi_attribute28
2583 ,p_cpi_attribute29 => p_cpi_attribute29
2584 ,p_cpi_attribute30 => p_cpi_attribute30
2585 ,p_feedback_date => p_feedback_date
2586 ,p_object_version_number => l_object_version_number
2587 );
2588 exception
2589 when hr_api.cannot_find_prog_unit then
2590 hr_api.cannot_find_prog_unit_error
2591 (p_module_name => 'UPDATE_PERSON_INFO'
2592 ,p_hook_type => 'AP'
2593 );
2594 end;
2595 --
2596 -- When in validation only mode raise the Validate_Enabled exception
2597 --
2598 if p_validate then
2599 raise hr_api.validate_enabled;
2600 end if;
2601 --
2602 -- Set all IN OUT and OUT parameters with out values
2603 --
2604 p_object_version_number := l_object_version_number;
2605 --
2606 if g_debug then
2607 hr_utility.set_location(' Leaving:'||l_proc, 70);
2608 end if;
2609
2610 -- calling the create_audit_record procedure to write into
2611 -- the ben_cwb_audit table with the old record
2612 create_audit_record(l_old_record);
2613
2614 exception
2615 when hr_api.validate_enabled then
2616 --
2617 -- As the Validate_Enabled exception has been raised
2618 -- we must rollback to the savepoint
2619 --
2620 rollback to update_person_info;
2621 --
2622 if g_debug then
2623 hr_utility.set_location(' Leaving:'||l_proc, 80);
2624 end if;
2625 when others then
2626 --
2627 -- A validation or unexpected error has occured
2628 --
2629 rollback to update_person_info;
2630 --
2631 if g_debug then
2632 hr_utility.set_location(' Leaving:'||l_proc, 90);
2633 end if;
2634 raise;
2635 end update_person_info;
2636 --
2637 -- ----------------------------------------------------------------------------
2638 -- |--------------------------< delete_person_info >--------------------------|
2639 -- ----------------------------------------------------------------------------
2640 --
2641 procedure delete_person_info
2642 (p_validate in boolean default false
2643 ,p_group_per_in_ler_id in number
2644 ,p_object_version_number in number
2645 ) is
2646 --
2647 --
2648 l_proc varchar2(72) := g_package||'delete_person_info';
2649 --
2650 begin
2651 if g_debug then
2652 hr_utility.set_location('Entering:'|| l_proc, 10);
2653 end if;
2654 --
2655 -- Issue a savepoint
2656 --
2657 savepoint delete_person_info;
2658 --
2659 -- Remember IN OUT parameter IN values
2660 --
2661 -- Call Before Process User Hook
2662 --
2663 begin
2664 ben_cwb_person_info_bk3.delete_person_info_b
2665 (p_group_per_in_ler_id => p_group_per_in_ler_id
2666 ,p_object_version_number => p_object_version_number
2667 );
2668 exception
2669 when hr_api.cannot_find_prog_unit then
2670 hr_api.cannot_find_prog_unit_error
2671 (p_module_name => 'DELETE_PERSON_INFO'
2672 ,p_hook_type => 'BP'
2673 );
2674 end;
2675 --
2676 -- Validation in addition to Row Handlers
2677 --
2678
2679 --
2680 -- Process Logic
2681 --
2682 ben_cpi_del.del
2683 (p_group_per_in_ler_id => p_group_per_in_ler_id
2684 ,p_object_version_number => p_object_version_number
2685 );
2686 --
2687 -- Call After Process User Hook
2688 --
2689 --
2690 begin
2691 ben_cwb_person_info_bk3.delete_person_info_a
2692 (p_group_per_in_ler_id => p_group_per_in_ler_id
2693 ,p_object_version_number => p_object_version_number
2694 );
2695 exception
2696 when hr_api.cannot_find_prog_unit then
2697 hr_api.cannot_find_prog_unit_error
2698 (p_module_name => 'DELETE_PERSON_INFO'
2699 ,p_hook_type => 'AP'
2700 );
2701 end;
2702
2703
2704 if g_debug then
2705 hr_utility.set_location(' Reached '||l_proc, 10);
2706 end if;
2707
2708 --****************audit changes**************--
2709 -- writing into audit log for backing out event --
2710 if g_debug then
2711 hr_utility.set_location(' about to BEN_CWB_AUDIT '|| l_proc, 100);
2712 end if;
2713 ben_cwb_audit_api.update_per_record(p_group_per_in_ler_id);
2714 -- ******************************************--
2715
2716 --
2717 -- When in validation only mode raise the Validate_Enabled exception
2718 --
2719
2720 if p_validate then
2721 raise hr_api.validate_enabled;
2722 end if;
2723 --
2724 -- Set all IN OUT and OUT parameters with out values
2725 --
2726 if g_debug then
2727 hr_utility.set_location(' Leaving:'||l_proc, 70);
2728 end if;
2729 exception
2730 when hr_api.validate_enabled then
2731 --
2732 -- As the Validate_Enabled exception has been raised
2733 -- we must rollback to the savepoint
2734 --
2735 rollback to delete_person_info;
2736 --
2737 if g_debug then
2738 hr_utility.set_location(' Leaving:'||l_proc, 80);
2739 end if;
2740 when others then
2741 --
2742 -- A validation or unexpected error has occured
2743 --
2744 rollback to delete_person_info;
2745 --
2746 if g_debug then
2747 hr_utility.set_location(' Leaving:'||l_proc, 90);
2748 end if;
2749 raise;
2750 end delete_person_info;
2751 --
2752 end ben_cwb_person_info_api;