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

APPS.BEN_CWB_AUDIT_API dependencies on BEN_CWB_AUDIT

Line 1: Package Body BEN_CWB_AUDIT_API as

1: Package Body BEN_CWB_AUDIT_API as
2: /* $Header: beaudapi.pkb 120.6 2012/01/19 06:15:20 rpahune ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' BEN_CWB_AUDIT_API.';

2: /* $Header: beaudapi.pkb 120.6 2012/01/19 06:15:20 rpahune ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_AUDIT_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: g_lookup_validity g_validity_table_type := g_validity_table_type();
9: --
10: --

Line 18: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;

14: procedure create_per_record
15: (p_per_in_ler_id in number
16: ) is
17: --
18: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
19: l_object_version_number ben_cwb_audit.object_version_number%type;
20: l_proc varchar2(72) := g_package||'create_per_record';
21: l_lf_evt_ocrd_dt ben_cwb_audit.lf_evt_ocrd_dt%type;
22: /*

Line 19: l_object_version_number ben_cwb_audit.object_version_number%type;

15: (p_per_in_ler_id in number
16: ) is
17: --
18: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
19: l_object_version_number ben_cwb_audit.object_version_number%type;
20: l_proc varchar2(72) := g_package||'create_per_record';
21: l_lf_evt_ocrd_dt ben_cwb_audit.lf_evt_ocrd_dt%type;
22: /*
23: l_created_by ben_per_in_ler.created_by%type;

Line 21: l_lf_evt_ocrd_dt ben_cwb_audit.lf_evt_ocrd_dt%type;

17: --
18: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
19: l_object_version_number ben_cwb_audit.object_version_number%type;
20: l_proc varchar2(72) := g_package||'create_per_record';
21: l_lf_evt_ocrd_dt ben_cwb_audit.lf_evt_ocrd_dt%type;
22: /*
23: l_created_by ben_per_in_ler.created_by%type;
24: */
25: l_creation_date ben_per_in_ler.creation_date%type;

Line 27: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;

23: l_created_by ben_per_in_ler.created_by%type;
24: */
25: l_creation_date ben_per_in_ler.creation_date%type;
26: l_last_updated_by ben_per_in_ler.last_updated_by%type;
27: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
28: l_group_pl_id ben_cwb_audit.group_pl_id%type;
29: l_person_id fnd_user.employee_id%type;
30:
31: begin

Line 28: l_group_pl_id ben_cwb_audit.group_pl_id%type;

24: */
25: l_creation_date ben_per_in_ler.creation_date%type;
26: l_last_updated_by ben_per_in_ler.last_updated_by%type;
27: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
28: l_group_pl_id ben_cwb_audit.group_pl_id%type;
29: l_person_id fnd_user.employee_id%type;
30:
31: begin
32: if g_debug then

Line 54: if(ben_cwb_audit_api.return_lookup_validity('BG')=true) then

50: select employee_id into l_person_id
51: from fnd_user
52: where user_id = l_last_updated_by;
53:
54: if(ben_cwb_audit_api.return_lookup_validity('BG')=true) then
55: ben_cwb_audit_api.create_audit_entry
56: (p_group_per_in_ler_id => p_per_in_ler_id
57: ,p_group_pl_id => l_group_pl_id
58: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 55: ben_cwb_audit_api.create_audit_entry

51: from fnd_user
52: where user_id = l_last_updated_by;
53:
54: if(ben_cwb_audit_api.return_lookup_validity('BG')=true) then
55: ben_cwb_audit_api.create_audit_entry
56: (p_group_per_in_ler_id => p_per_in_ler_id
57: ,p_group_pl_id => l_group_pl_id
58: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
59: ,p_pl_id => l_group_pl_id

Line 112: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;

108: procedure update_per_record2
109: (p_group_per_in_ler_id in number
110: ) is
111: --
112: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
113: l_object_version_number ben_cwb_audit.object_version_number%type;
114: l_proc varchar2(72) := g_package||'update_per_record';
115: l_per_record_new ben_per_in_ler%rowtype;
116: l_person_id fnd_user.employee_id%type;

Line 113: l_object_version_number ben_cwb_audit.object_version_number%type;

109: (p_group_per_in_ler_id in number
110: ) is
111: --
112: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
113: l_object_version_number ben_cwb_audit.object_version_number%type;
114: l_proc varchar2(72) := g_package||'update_per_record';
115: l_per_record_new ben_per_in_ler%rowtype;
116: l_person_id fnd_user.employee_id%type;
117:

Line 148: if(ben_cwb_audit_api.return_lookup_validity('MG')=true) then

144: or ((l_per_record_new.ws_mgr_id is null)
145: and (p_per_record_old.ws_mgr_id is not null))
146: or (p_per_record_old.ws_mgr_id <> l_per_record_new.ws_mgr_id) ) then
147:
148: if(ben_cwb_audit_api.return_lookup_validity('MG')=true) then
149:
150: begin
151: select DECODE (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),
152: 'BN', empinfo.brief_name,

Line 179: ben_cwb_audit_api.create_audit_entry

175: l_new_ws_mgr_name := l_per_record_new.ws_mgr_id;
176: end;
177:
178:
179: ben_cwb_audit_api.create_audit_entry
180: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
181: ,p_group_pl_id => l_per_record_new.group_pl_id
182: ,p_lf_evt_ocrd_dt => l_per_record_new.lf_evt_ocrd_dt
183: ,p_pl_id => l_per_record_new.group_pl_id

Line 213: if(ben_cwb_audit_api.return_lookup_validity('EN')=true) then

209:
210: if(l_per_record_new.per_in_ler_stat_cd = 'PROCD') then
211: -- if processed
212:
213: if(ben_cwb_audit_api.return_lookup_validity('EN')=true) then
214:
215: ben_cwb_audit_api.create_audit_entry
216: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
217: ,p_group_pl_id => l_per_record_new.group_pl_id

Line 215: ben_cwb_audit_api.create_audit_entry

211: -- if processed
212:
213: if(ben_cwb_audit_api.return_lookup_validity('EN')=true) then
214:
215: ben_cwb_audit_api.create_audit_entry
216: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
217: ,p_group_pl_id => l_per_record_new.group_pl_id
218: ,p_lf_evt_ocrd_dt => l_per_record_new.lf_evt_ocrd_dt
219: ,p_pl_id => l_per_record_new.group_pl_id

Line 242: if(ben_cwb_audit_api.return_lookup_validity('BO')=true) then

238:
239: if(l_per_record_new.per_in_ler_stat_cd = 'BCKDT') then
240: -- if backed-out
241:
242: if(ben_cwb_audit_api.return_lookup_validity('BO')=true) then
243:
244: ben_cwb_audit_api.create_audit_entry
245: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
246: ,p_group_pl_id => l_per_record_new.group_pl_id

Line 244: ben_cwb_audit_api.create_audit_entry

240: -- if backed-out
241:
242: if(ben_cwb_audit_api.return_lookup_validity('BO')=true) then
243:
244: ben_cwb_audit_api.create_audit_entry
245: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
246: ,p_group_pl_id => l_per_record_new.group_pl_id
247: ,p_lf_evt_ocrd_dt => l_per_record_new.lf_evt_ocrd_dt
248: ,p_pl_id => l_per_record_new.group_pl_id

Line 299: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;

295: l_old_ws_mgr_name ben_cwb_person_info.full_name%type;
296: l_new_ws_mgr_name ben_cwb_person_info.full_name%type;
297: l_per_record_new ben_per_in_ler%rowtype;
298: l_person_id fnd_user.employee_id%type;
299: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
300: l_object_version_number ben_cwb_audit.object_version_number%type;
301: l_personid ben_per_in_ler.ws_mgr_id%type;
302:
303:

Line 300: l_object_version_number ben_cwb_audit.object_version_number%type;

296: l_new_ws_mgr_name ben_cwb_person_info.full_name%type;
297: l_per_record_new ben_per_in_ler%rowtype;
298: l_person_id fnd_user.employee_id%type;
299: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
300: l_object_version_number ben_cwb_audit.object_version_number%type;
301: l_personid ben_per_in_ler.ws_mgr_id%type;
302:
303:
304: begin

Line 348: if(ben_cwb_audit_api.return_lookup_validity('MG')=true) then

344: or ((l_per_record_new.ws_mgr_id is null)
345: and (l_ws_mgr_id is not null))
346: or (l_ws_mgr_id <> l_per_record_new.ws_mgr_id) ) then
347:
348: if(ben_cwb_audit_api.return_lookup_validity('MG')=true) then
349:
350: begin
351:
352: select distinct ppf.person_id, DECODE

Line 417: ben_cwb_audit_api.create_audit_entry

413: l_new_ws_mgr_name := l_per_record_new.ws_mgr_id;
414: end;
415:
416:
417: ben_cwb_audit_api.create_audit_entry
418: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
419: ,p_group_pl_id => l_per_record_new.group_pl_id
420: ,p_lf_evt_ocrd_dt => l_per_record_new.lf_evt_ocrd_dt
421: ,p_pl_id => l_per_record_new.group_pl_id

Line 444: if(ben_cwb_audit_api.return_lookup_validity('BOA')=true) then

440:
441: --11741025
442: if(p_audit_type_cd = 'BOA' ) then
443:
444: if(ben_cwb_audit_api.return_lookup_validity('BOA')=true) then
445:
446: ben_cwb_audit_api.create_audit_entry
447: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
448: ,p_group_pl_id => l_per_record_new.group_pl_id

Line 446: ben_cwb_audit_api.create_audit_entry

442: if(p_audit_type_cd = 'BOA' ) then
443:
444: if(ben_cwb_audit_api.return_lookup_validity('BOA')=true) then
445:
446: ben_cwb_audit_api.create_audit_entry
447: (p_group_per_in_ler_id => l_per_record_new.per_in_ler_id
448: ,p_group_pl_id => l_per_record_new.group_pl_id
449: ,p_lf_evt_ocrd_dt => l_per_record_new.lf_evt_ocrd_dt
450: ,p_pl_id => l_per_record_new.group_pl_id

Line 514: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;

510: ,p_object_version_number out nocopy number
511: ) is
512: --
513: l_object_version_number number;
514: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
515: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
516: --
517: l_proc varchar2(72) := g_package||'create_audit_entry';
518: /* l_change_made_by_person_id number;*/

Line 515: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;

511: ) is
512: --
513: l_object_version_number number;
514: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
515: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
516: --
517: l_proc varchar2(72) := g_package||'create_audit_entry';
518: /* l_change_made_by_person_id number;*/
519: begin

Line 571: ben_cwb_audit_bk1.create_audit_entry_b

567: --
568: -- Call Before Process User Hook
569: --
570: begin
571: ben_cwb_audit_bk1.create_audit_entry_b
572: (p_group_per_in_ler_id => p_group_per_in_ler_id
573: ,p_group_pl_id => p_group_pl_id
574: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
575: ,p_pl_id => p_pl_id

Line 627: ben_cwb_audit_bk1.create_audit_entry_a

623: --
624: -- Call After Process User Hook
625: --
626: begin
627: ben_cwb_audit_bk1.create_audit_entry_a
628: (p_group_per_in_ler_id => p_group_per_in_ler_id
629: ,p_group_pl_id => p_group_pl_id
630: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
631: ,p_pl_id => p_pl_id

Line 756: ben_cwb_audit_bk2.update_audit_entry_b

752: --
753: -- Call Before Process User Hook
754: --
755: begin
756: ben_cwb_audit_bk2.update_audit_entry_b
757: (p_cwb_audit_id => p_cwb_audit_id
758: ,p_group_per_in_ler_id => p_group_per_in_ler_id
759: ,p_group_pl_id => p_group_pl_id
760: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 847: ben_cwb_audit_bk2.update_audit_entry_a

843: --
844: -- Call After Process User Hook
845: --
846: begin
847: ben_cwb_audit_bk2.update_audit_entry_a
848: (p_cwb_audit_id => p_cwb_audit_id
849: ,p_group_per_in_ler_id => p_group_per_in_ler_id
850: ,p_group_pl_id => p_group_pl_id
851: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 952: BEN_CWB_AUDIT_BK3.delete_audit_entry_b

948: --
949: -- Call Before Process User Hook
950: --
951: begin
952: BEN_CWB_AUDIT_BK3.delete_audit_entry_b
953: (p_cwb_audit_id => p_cwb_audit_id
954: ,p_object_version_number => l_object_version_number
955: );
956: exception

Line 978: ben_cwb_audit_bk3.delete_audit_entry_a

974: --
975: -- Call After Process User Hook
976: --
977: begin
978: ben_cwb_audit_bk3.delete_audit_entry_a
979: (p_cwb_audit_id => p_cwb_audit_id
980: ,p_object_version_number => l_object_version_number
981: );
982: exception

Line 1175: l_audit_type_cd ben_cwb_audit.audit_type_cd%type;

1171: (p_lookup_code in varchar2
1172: )return boolean is
1173: l_validity boolean;
1174: l_lookup hr_lookups%rowtype;
1175: l_audit_type_cd ben_cwb_audit.audit_type_cd%type;
1176: l_code_flag code_flag;
1177: l_found boolean;
1178: l_index number;
1179: begin

Line 1222: where lookup_type='BEN_CWB_AUDIT_TYPE'

1218:
1219: begin
1220: select * into l_lookup
1221: from hr_lookups
1222: where lookup_type='BEN_CWB_AUDIT_TYPE'
1223: and lookup_code = p_lookup_code;
1224:
1225: l_code_flag.code := l_lookup.lookup_code;
1226:

Line 1259: end ben_cwb_audit_api;

1255: return l_validity;
1256:
1257: end return_lookup_validity;
1258: --
1259: end ben_cwb_audit_api;