[Home] [Help]
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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