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_API

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 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 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 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 1259: end ben_cwb_audit_api;

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