APPS.BEN_CWB_PERSON_GROUPS_API dependencies on BEN_CWB_AUDIT_API

Line 617: if(ben_cwb_audit_api.return_lookup_validity('BAD')=true) then

613: or (p_grp_bdgt_old.ws_bdgt_val <> l_grp_bdgt_new.ws_bdgt_val) ) then
614:
615: -- if(nvl(p_grp_bdgt_old.ws_bdgt_val,-1)<>nvl(l_grp_bdgt_new.ws_bdgt_val,-1)) then
616: if(l_pl_dsgn.prsrv_bdgt_cd='A') then
617: if(ben_cwb_audit_api.return_lookup_validity('BAD')=true) then
618:
619: if g_debug then
620: hr_utility.set_location('Entering BAD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 101);
621: end if;

Line 623: ben_cwb_audit_api.create_audit_entry

619: if g_debug then
620: hr_utility.set_location('Entering BAD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 101);
621: end if;
622:
623: ben_cwb_audit_api.create_audit_entry
624: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
625: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
626: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
627: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 639: if(ben_cwb_audit_api.return_lookup_validity('BPD')=true) then

635: ,p_object_version_number => l_object_version_number
636: );
637: end if;
638: elsif(l_pl_dsgn.prsrv_bdgt_cd='P') then
639: if(ben_cwb_audit_api.return_lookup_validity('BPD')=true) then
640: if g_debug then
641: hr_utility.set_location('Entering BPD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 102);
642: end if;
643:

Line 644: ben_cwb_audit_api.create_audit_entry

640: if g_debug then
641: hr_utility.set_location('Entering BPD:'||l_proc||p_grp_bdgt_old.ws_bdgt_val||' '||l_grp_bdgt_new.ws_bdgt_val, 102);
642: end if;
643:
644: ben_cwb_audit_api.create_audit_entry
645: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
646: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
647: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
648: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 669: if(ben_cwb_audit_api.return_lookup_validity('BAA')=true) then

665: and (p_grp_bdgt_old.dist_bdgt_val is not null))
666: or (p_grp_bdgt_old.dist_bdgt_val <> l_grp_bdgt_new.dist_bdgt_val) ) then
667: --if(nvl(p_grp_bdgt_old.dist_bdgt_val,-1)<>nvl(l_grp_bdgt_new.dist_bdgt_val,-1)) then
668: if(l_pl_dsgn.prsrv_bdgt_cd='A') then
669: if(ben_cwb_audit_api.return_lookup_validity('BAA')=true) then
670: if g_debug then
671: hr_utility.set_location('Entering BAA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 103);
672: end if;
673:

Line 674: ben_cwb_audit_api.create_audit_entry

670: if g_debug then
671: hr_utility.set_location('Entering BAA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 103);
672: end if;
673:
674: ben_cwb_audit_api.create_audit_entry
675: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
676: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
677: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
678: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 690: if(ben_cwb_audit_api.return_lookup_validity('BPA')=true) then

686: ,p_object_version_number => l_object_version_number
687: );
688: end if;
689: elsif(l_pl_dsgn.prsrv_bdgt_cd='P') then
690: if(ben_cwb_audit_api.return_lookup_validity('BPA')=true) then
691: if g_debug then
692: hr_utility.set_location('Entering BPA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 104);
693: end if;
694:

Line 695: ben_cwb_audit_api.create_audit_entry

691: if g_debug then
692: hr_utility.set_location('Entering BPA:'||l_proc||p_grp_bdgt_old.dist_bdgt_val||' '||l_grp_bdgt_new.dist_bdgt_val, 104);
693: end if;
694:
695: ben_cwb_audit_api.create_audit_entry
696: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
697: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
698: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
699: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 719: if(ben_cwb_audit_api.return_lookup_validity('BP')=true) then

715: or ((l_grp_bdgt_new.bdgt_pop_cd is null)
716: and (p_grp_bdgt_old.bdgt_pop_cd is not null))
717: or (p_grp_bdgt_old.bdgt_pop_cd <> l_grp_bdgt_new.bdgt_pop_cd) ) then
718: -- if(nvl(p_grp_bdgt_old.bdgt_pop_cd,-1)<>nvl(l_grp_bdgt_new.bdgt_pop_cd,-1)) then
719: if(ben_cwb_audit_api.return_lookup_validity('BP')=true) then
720:
721: if g_debug then
722: hr_utility.set_location('Entering BP:'||l_proc||p_grp_bdgt_old.bdgt_pop_cd||' '||l_grp_bdgt_new.bdgt_pop_cd, 105);
723: end if;

Line 725: ben_cwb_audit_api.create_audit_entry

721: if g_debug then
722: hr_utility.set_location('Entering BP:'||l_proc||p_grp_bdgt_old.bdgt_pop_cd||' '||l_grp_bdgt_new.bdgt_pop_cd, 105);
723: end if;
724:
725: ben_cwb_audit_api.create_audit_entry
726: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
727: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
728: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
729: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 746: if(ben_cwb_audit_api.return_lookup_validity('DD')=true) then

742: and (l_grp_bdgt_new.due_dt is not null))
743: or ((l_grp_bdgt_new.due_dt is null)
744: and (p_grp_bdgt_old.due_dt is not null))
745: or (p_grp_bdgt_old.due_dt <> l_grp_bdgt_new.due_dt) ) then
746: if(ben_cwb_audit_api.return_lookup_validity('DD')=true) then
747:
748: if g_debug then
749: hr_utility.set_location('Entering DD:'||l_proc||p_grp_bdgt_old.due_dt||' '||l_grp_bdgt_new.due_dt, 106);
750: end if;

Line 752: ben_cwb_audit_api.create_audit_entry

748: if g_debug then
749: hr_utility.set_location('Entering DD:'||l_proc||p_grp_bdgt_old.due_dt||' '||l_grp_bdgt_new.due_dt, 106);
750: end if;
751:
752: ben_cwb_audit_api.create_audit_entry
753: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
754: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
755: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
756: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 773: if(ben_cwb_audit_api.return_lookup_validity('SD')=true) then

769: and (l_grp_bdgt_new.submit_date is not null))
770: or ((l_grp_bdgt_new.submit_date is null)
771: and (p_grp_bdgt_old.submit_date is not null))
772: or (p_grp_bdgt_old.submit_date <> l_grp_bdgt_new.submit_date) ) then
773: if(ben_cwb_audit_api.return_lookup_validity('SD')=true) then
774:
775: if g_debug then
776: hr_utility.set_location('Entering SD: '||l_proc||p_grp_bdgt_old.submit_date||' '||l_grp_bdgt_new.submit_date, 107);
777: end if;

Line 779: ben_cwb_audit_api.create_audit_entry

775: if g_debug then
776: hr_utility.set_location('Entering SD: '||l_proc||p_grp_bdgt_old.submit_date||' '||l_grp_bdgt_new.submit_date, 107);
777: end if;
778:
779: ben_cwb_audit_api.create_audit_entry
780: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
781: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
782: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
783: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 800: if(ben_cwb_audit_api.return_lookup_validity('SU')=true) then

796: and (l_grp_bdgt_new.submit_cd is not null))
797: or ((l_grp_bdgt_new.submit_cd is null)
798: and (p_grp_bdgt_old.submit_cd is not null))
799: or (p_grp_bdgt_old.submit_cd <> l_grp_bdgt_new.submit_cd) ) then
800: if(ben_cwb_audit_api.return_lookup_validity('SU')=true) then
801:
802: begin
803: select meaning into l_cd_meaning_old
804: from hr_lookups

Line 826: ben_cwb_audit_api.create_audit_entry

822: if g_debug then
823: hr_utility.set_location('Entering BAD:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 108);
824: end if;
825:
826: ben_cwb_audit_api.create_audit_entry
827: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
828: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
829: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
830: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 847: if(ben_cwb_audit_api.return_lookup_validity('AS')=true) then

843: and (l_grp_bdgt_new.approval_cd is not null))
844: or ((l_grp_bdgt_new.approval_cd is null)
845: and (p_grp_bdgt_old.approval_cd is not null))
846: or (p_grp_bdgt_old.approval_cd <> l_grp_bdgt_new.approval_cd) ) then
847: if(ben_cwb_audit_api.return_lookup_validity('AS')=true) then
848:
849:
850: begin
851: select meaning into l_cd_meaning_old

Line 874: ben_cwb_audit_api.create_audit_entry

870: if g_debug then
871: hr_utility.set_location('Entering AS:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 109);
872: end if;
873:
874: ben_cwb_audit_api.create_audit_entry
875: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
876: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
877: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
878: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 895: if(ben_cwb_audit_api.return_lookup_validity('AD')=true) then

891: and (l_grp_bdgt_new.approval_date is not null))
892: or ((l_grp_bdgt_new.approval_date is null)
893: and (p_grp_bdgt_old.approval_date is not null))
894: or (p_grp_bdgt_old.approval_date <> l_grp_bdgt_new.approval_date) ) then
895: if(ben_cwb_audit_api.return_lookup_validity('AD')=true) then
896: if g_debug then
897: hr_utility.set_location('Entering AD:'||l_proc||p_grp_bdgt_old.approval_date||' '||l_grp_bdgt_new.approval_date, 110);
898: end if;
899:

Line 900: ben_cwb_audit_api.create_audit_entry

896: if g_debug then
897: hr_utility.set_location('Entering AD:'||l_proc||p_grp_bdgt_old.approval_date||' '||l_grp_bdgt_new.approval_date, 110);
898: end if;
899:
900: ben_cwb_audit_api.create_audit_entry
901: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
902: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
903: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
904: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 921: if(ben_cwb_audit_api.return_lookup_validity('RS')=true) then

917: and (l_grp_bdgt_new.rsrv_val is not null))
918: or ((l_grp_bdgt_new.rsrv_val is null)
919: and (p_grp_bdgt_old.rsrv_val is not null))
920: or (p_grp_bdgt_old.rsrv_val <> l_grp_bdgt_new.rsrv_val) ) then
921: if(ben_cwb_audit_api.return_lookup_validity('RS')=true) then
922:
923: if g_debug then
924: hr_utility.set_location('Entering RS:'||l_proc||p_grp_bdgt_old.rsrv_val||' '||l_grp_bdgt_new.rsrv_val, 111);
925: end if;

Line 927: ben_cwb_audit_api.create_audit_entry

923: if g_debug then
924: hr_utility.set_location('Entering RS:'||l_proc||p_grp_bdgt_old.rsrv_val||' '||l_grp_bdgt_new.rsrv_val, 111);
925: end if;
926:
927: ben_cwb_audit_api.create_audit_entry
928: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
929: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
930: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
931: ,p_pl_id => l_grp_bdgt_new.group_pl_id

Line 948: if(ben_cwb_audit_api.return_lookup_validity('AC')=true) then

944: and (l_grp_bdgt_new.access_cd is not null))
945: or ((l_grp_bdgt_new.access_cd is null)
946: and (p_grp_bdgt_old.access_cd is not null))
947: or (p_grp_bdgt_old.access_cd <> l_grp_bdgt_new.access_cd) ) then
948: if(ben_cwb_audit_api.return_lookup_validity('AC')=true) then
949:
950: begin
951: select meaning into l_cd_meaning_old
952: from hr_lookups

Line 975: ben_cwb_audit_api.create_audit_entry

971: hr_utility.set_location('Entering AC:'||l_proc||l_cd_meaning_old||' '||l_cd_meaning_new, 112);
972: end if;
973:
974:
975: ben_cwb_audit_api.create_audit_entry
976: (p_group_per_in_ler_id => l_grp_bdgt_new.group_per_in_ler_id
977: ,p_group_pl_id => l_grp_bdgt_new.group_pl_id
978: ,p_lf_evt_ocrd_dt => l_grp_bdgt_new.lf_evt_ocrd_dt
979: ,p_pl_id => l_grp_bdgt_new.group_pl_id