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.4 2006/10/27 11:13:22 steotia noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: beaudapi.pkb 120.4 2006/10/27 11:13:22 steotia noship $ */
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 485: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;

481: ,p_object_version_number out nocopy number
482: ) is
483: --
484: l_object_version_number number;
485: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
486: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
487: --
488: l_proc varchar2(72) := g_package||'create_audit_entry';
489: /* l_change_made_by_person_id number;*/

Line 486: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;

482: ) is
483: --
484: l_object_version_number number;
485: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
486: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
487: --
488: l_proc varchar2(72) := g_package||'create_audit_entry';
489: /* l_change_made_by_person_id number;*/
490: begin

Line 542: ben_cwb_audit_bk1.create_audit_entry_b

538: --
539: -- Call Before Process User Hook
540: --
541: begin
542: ben_cwb_audit_bk1.create_audit_entry_b
543: (p_group_per_in_ler_id => p_group_per_in_ler_id
544: ,p_group_pl_id => p_group_pl_id
545: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
546: ,p_pl_id => p_pl_id

Line 598: ben_cwb_audit_bk1.create_audit_entry_a

594: --
595: -- Call After Process User Hook
596: --
597: begin
598: ben_cwb_audit_bk1.create_audit_entry_a
599: (p_group_per_in_ler_id => p_group_per_in_ler_id
600: ,p_group_pl_id => p_group_pl_id
601: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
602: ,p_pl_id => p_pl_id

Line 727: ben_cwb_audit_bk2.update_audit_entry_b

723: --
724: -- Call Before Process User Hook
725: --
726: begin
727: ben_cwb_audit_bk2.update_audit_entry_b
728: (p_cwb_audit_id => p_cwb_audit_id
729: ,p_group_per_in_ler_id => p_group_per_in_ler_id
730: ,p_group_pl_id => p_group_pl_id
731: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 818: ben_cwb_audit_bk2.update_audit_entry_a

814: --
815: -- Call After Process User Hook
816: --
817: begin
818: ben_cwb_audit_bk2.update_audit_entry_a
819: (p_cwb_audit_id => p_cwb_audit_id
820: ,p_group_per_in_ler_id => p_group_per_in_ler_id
821: ,p_group_pl_id => p_group_pl_id
822: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 923: BEN_CWB_AUDIT_BK3.delete_audit_entry_b

919: --
920: -- Call Before Process User Hook
921: --
922: begin
923: BEN_CWB_AUDIT_BK3.delete_audit_entry_b
924: (p_cwb_audit_id => p_cwb_audit_id
925: ,p_object_version_number => l_object_version_number
926: );
927: exception

Line 949: ben_cwb_audit_bk3.delete_audit_entry_a

945: --
946: -- Call After Process User Hook
947: --
948: begin
949: ben_cwb_audit_bk3.delete_audit_entry_a
950: (p_cwb_audit_id => p_cwb_audit_id
951: ,p_object_version_number => l_object_version_number
952: );
953: exception

Line 1146: l_audit_type_cd ben_cwb_audit.audit_type_cd%type;

1142: (p_lookup_code in varchar2
1143: )return boolean is
1144: l_validity boolean;
1145: l_lookup hr_lookups%rowtype;
1146: l_audit_type_cd ben_cwb_audit.audit_type_cd%type;
1147: l_code_flag code_flag;
1148: l_found boolean;
1149: l_index number;
1150: begin

Line 1193: where lookup_type='BEN_CWB_AUDIT_TYPE'

1189:
1190: begin
1191: select * into l_lookup
1192: from hr_lookups
1193: where lookup_type='BEN_CWB_AUDIT_TYPE'
1194: and lookup_code = p_lookup_code;
1195:
1196: l_code_flag.code := l_lookup.lookup_code;
1197:

Line 1230: end ben_cwb_audit_api;

1226: return l_validity;
1227:
1228: end return_lookup_validity;
1229: --
1230: end ben_cwb_audit_api;