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_ASG_UPDATE dependencies on BEN_CWB_AUDIT_API

Line 249: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then

245: fetch c_lookup into l_cd_meaning_new;
246: close c_lookup;
247: --
248: --
249: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
250: ben_cwb_audit_api.create_audit_entry
251: (p_group_per_in_ler_id => l_per_in_ler_id
252: ,p_group_pl_id => l_pl_id
253: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 250: ben_cwb_audit_api.create_audit_entry

246: close c_lookup;
247: --
248: --
249: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
250: ben_cwb_audit_api.create_audit_entry
251: (p_group_per_in_ler_id => l_per_in_ler_id
252: ,p_group_pl_id => l_pl_id
253: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
254: ,p_pl_id => l_pl_id

Line 277: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then

273: --
274: l_cd_meaning_new := null;
275: --
276: --
277: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
278: ben_cwb_audit_api.create_audit_entry
279: (p_group_per_in_ler_id => l_per_in_ler_id
280: ,p_group_pl_id => l_pl_id
281: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 278: ben_cwb_audit_api.create_audit_entry

274: l_cd_meaning_new := null;
275: --
276: --
277: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
278: ben_cwb_audit_api.create_audit_entry
279: (p_group_per_in_ler_id => l_per_in_ler_id
280: ,p_group_pl_id => l_pl_id
281: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
282: ,p_pl_id => l_pl_id

Line 435: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then

431: close c_job;
432: --
433: --
434: --
435: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
436: ben_cwb_audit_api.create_audit_entry
437: (p_group_per_in_ler_id => l_per_in_ler_id
438: ,p_group_pl_id => l_pl_id
439: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 436: ben_cwb_audit_api.create_audit_entry

432: --
433: --
434: --
435: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
436: ben_cwb_audit_api.create_audit_entry
437: (p_group_per_in_ler_id => l_per_in_ler_id
438: ,p_group_pl_id => l_pl_id
439: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
440: ,p_pl_id => l_pl_id

Line 468: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then

464: fetch c_lookup into l_cd_meaning_new;
465: close c_lookup;
466: --
467: --
468: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
469: ben_cwb_audit_api.create_audit_entry
470: (p_group_per_in_ler_id => l_per_in_ler_id
471: ,p_group_pl_id => l_pl_id
472: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 469: ben_cwb_audit_api.create_audit_entry

465: close c_lookup;
466: --
467: --
468: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
469: ben_cwb_audit_api.create_audit_entry
470: (p_group_per_in_ler_id => l_per_in_ler_id
471: ,p_group_pl_id => l_pl_id
472: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
473: ,p_pl_id => l_pl_id

Line 502: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then

498: close c_grade;
499: --
500: --
501: --
502: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
503: ben_cwb_audit_api.create_audit_entry
504: (p_group_per_in_ler_id => l_per_in_ler_id
505: ,p_group_pl_id => l_pl_id
506: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 503: ben_cwb_audit_api.create_audit_entry

499: --
500: --
501: --
502: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
503: ben_cwb_audit_api.create_audit_entry
504: (p_group_per_in_ler_id => l_per_in_ler_id
505: ,p_group_pl_id => l_pl_id
506: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
507: ,p_pl_id => l_pl_id

Line 526: if(ben_cwb_audit_api.return_lookup_validity('PG')=true) then

522: or ((l_txn_new.attribute8 is null)
523: and (p_txn_old.attribute8 is not null))
524: or (p_txn_old.attribute8 <> l_txn_new.attribute8) ) then
525: --
526: if(ben_cwb_audit_api.return_lookup_validity('PG')=true) then
527: ben_cwb_audit_api.create_audit_entry
528: (p_group_per_in_ler_id => l_per_in_ler_id
529: ,p_group_pl_id => l_pl_id
530: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 527: ben_cwb_audit_api.create_audit_entry

523: and (p_txn_old.attribute8 is not null))
524: or (p_txn_old.attribute8 <> l_txn_new.attribute8) ) then
525: --
526: if(ben_cwb_audit_api.return_lookup_validity('PG')=true) then
527: ben_cwb_audit_api.create_audit_entry
528: (p_group_per_in_ler_id => l_per_in_ler_id
529: ,p_group_pl_id => l_pl_id
530: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
531: ,p_pl_id => l_pl_id

Line 558: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then

554: fetch c_position into l_cd_meaning_new;
555: close c_position;
556: --
557: --
558: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
559: ben_cwb_audit_api.create_audit_entry
560: (p_group_per_in_ler_id => l_per_in_ler_id
561: ,p_group_pl_id => l_pl_id
562: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 559: ben_cwb_audit_api.create_audit_entry

555: close c_position;
556: --
557: --
558: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
559: ben_cwb_audit_api.create_audit_entry
560: (p_group_per_in_ler_id => l_per_in_ler_id
561: ,p_group_pl_id => l_pl_id
562: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
563: ,p_pl_id => l_pl_id

Line 581: if(ben_cwb_audit_api.return_lookup_validity('SCL')=true) then

577: or ((l_txn_new.attribute9 is null)
578: and (p_txn_old.attribute9 is not null))
579: or (p_txn_old.attribute9 <> l_txn_new.attribute9) ) then
580: --
581: if(ben_cwb_audit_api.return_lookup_validity('SCL')=true) then
582: ben_cwb_audit_api.create_audit_entry
583: (p_group_per_in_ler_id => l_per_in_ler_id
584: ,p_group_pl_id => l_pl_id
585: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 582: ben_cwb_audit_api.create_audit_entry

578: and (p_txn_old.attribute9 is not null))
579: or (p_txn_old.attribute9 <> l_txn_new.attribute9) ) then
580: --
581: if(ben_cwb_audit_api.return_lookup_validity('SCL')=true) then
582: ben_cwb_audit_api.create_audit_entry
583: (p_group_per_in_ler_id => l_per_in_ler_id
584: ,p_group_pl_id => l_pl_id
585: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
586: ,p_pl_id => l_pl_id

Line 604: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then

600: or ((l_txn_new.attribute11 is null)
601: and (p_txn_old.attribute11 is not null))
602: or (p_txn_old.attribute11 <> l_txn_new.attribute11) ) then
603: --
604: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then
605: ben_cwb_audit_api.create_audit_entry
606: (p_group_per_in_ler_id => l_per_in_ler_id
607: ,p_group_pl_id => l_pl_id
608: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 605: ben_cwb_audit_api.create_audit_entry

601: and (p_txn_old.attribute11 is not null))
602: or (p_txn_old.attribute11 <> l_txn_new.attribute11) ) then
603: --
604: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then
605: ben_cwb_audit_api.create_audit_entry
606: (p_group_per_in_ler_id => l_per_in_ler_id
607: ,p_group_pl_id => l_pl_id
608: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
609: ,p_pl_id => l_pl_id

Line 627: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then

623: or ((l_txn_new.attribute12 is null)
624: and (p_txn_old.attribute12 is not null))
625: or (p_txn_old.attribute12 <> l_txn_new.attribute12) ) then
626: --
627: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then
628: ben_cwb_audit_api.create_audit_entry
629: (p_group_per_in_ler_id => l_per_in_ler_id
630: ,p_group_pl_id => l_pl_id
631: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 628: ben_cwb_audit_api.create_audit_entry

624: and (p_txn_old.attribute12 is not null))
625: or (p_txn_old.attribute12 <> l_txn_new.attribute12) ) then
626: --
627: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then
628: ben_cwb_audit_api.create_audit_entry
629: (p_group_per_in_ler_id => l_per_in_ler_id
630: ,p_group_pl_id => l_pl_id
631: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
632: ,p_pl_id => l_pl_id

Line 650: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then

646: or ((l_txn_new.attribute13 is null)
647: and (p_txn_old.attribute13 is not null))
648: or (p_txn_old.attribute13 <> l_txn_new.attribute13) ) then
649: --
650: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then
651: ben_cwb_audit_api.create_audit_entry
652: (p_group_per_in_ler_id => l_per_in_ler_id
653: ,p_group_pl_id => l_pl_id
654: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 651: ben_cwb_audit_api.create_audit_entry

647: and (p_txn_old.attribute13 is not null))
648: or (p_txn_old.attribute13 <> l_txn_new.attribute13) ) then
649: --
650: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then
651: ben_cwb_audit_api.create_audit_entry
652: (p_group_per_in_ler_id => l_per_in_ler_id
653: ,p_group_pl_id => l_pl_id
654: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
655: ,p_pl_id => l_pl_id

Line 673: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then

669: or ((l_txn_new.attribute14 is null)
670: and (p_txn_old.attribute14 is not null))
671: or (p_txn_old.attribute14 <> l_txn_new.attribute14) ) then
672: --
673: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then
674: ben_cwb_audit_api.create_audit_entry
675: (p_group_per_in_ler_id => l_per_in_ler_id
676: ,p_group_pl_id => l_pl_id
677: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 674: ben_cwb_audit_api.create_audit_entry

670: and (p_txn_old.attribute14 is not null))
671: or (p_txn_old.attribute14 <> l_txn_new.attribute14) ) then
672: --
673: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then
674: ben_cwb_audit_api.create_audit_entry
675: (p_group_per_in_ler_id => l_per_in_ler_id
676: ,p_group_pl_id => l_pl_id
677: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
678: ,p_pl_id => l_pl_id

Line 696: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then

692: or ((l_txn_new.attribute15 is null)
693: and (p_txn_old.attribute15 is not null))
694: or (p_txn_old.attribute15 <> l_txn_new.attribute15) ) then
695: --
696: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then
697: ben_cwb_audit_api.create_audit_entry
698: (p_group_per_in_ler_id => l_per_in_ler_id
699: ,p_group_pl_id => l_pl_id
700: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 697: ben_cwb_audit_api.create_audit_entry

693: and (p_txn_old.attribute15 is not null))
694: or (p_txn_old.attribute15 <> l_txn_new.attribute15) ) then
695: --
696: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then
697: ben_cwb_audit_api.create_audit_entry
698: (p_group_per_in_ler_id => l_per_in_ler_id
699: ,p_group_pl_id => l_pl_id
700: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
701: ,p_pl_id => l_pl_id

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

715: or ((l_txn_new.attribute16 is null)
716: and (p_txn_old.attribute16 is not null))
717: or (p_txn_old.attribute16 <> l_txn_new.attribute16) ) then
718: --
719: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then
720: ben_cwb_audit_api.create_audit_entry
721: (p_group_per_in_ler_id => l_per_in_ler_id
722: ,p_group_pl_id => l_pl_id
723: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 720: ben_cwb_audit_api.create_audit_entry

716: and (p_txn_old.attribute16 is not null))
717: or (p_txn_old.attribute16 <> l_txn_new.attribute16) ) then
718: --
719: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then
720: ben_cwb_audit_api.create_audit_entry
721: (p_group_per_in_ler_id => l_per_in_ler_id
722: ,p_group_pl_id => l_pl_id
723: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
724: ,p_pl_id => l_pl_id

Line 742: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then

738: or ((l_txn_new.attribute17 is null)
739: and (p_txn_old.attribute17 is not null))
740: or (p_txn_old.attribute17 <> l_txn_new.attribute17) ) then
741: --
742: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then
743: ben_cwb_audit_api.create_audit_entry
744: (p_group_per_in_ler_id => l_per_in_ler_id
745: ,p_group_pl_id => l_pl_id
746: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 743: ben_cwb_audit_api.create_audit_entry

739: and (p_txn_old.attribute17 is not null))
740: or (p_txn_old.attribute17 <> l_txn_new.attribute17) ) then
741: --
742: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then
743: ben_cwb_audit_api.create_audit_entry
744: (p_group_per_in_ler_id => l_per_in_ler_id
745: ,p_group_pl_id => l_pl_id
746: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
747: ,p_pl_id => l_pl_id

Line 765: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then

761: or ((l_txn_new.attribute18 is null)
762: and (p_txn_old.attribute18 is not null))
763: or (p_txn_old.attribute18 <> l_txn_new.attribute18) ) then
764: --
765: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then
766: ben_cwb_audit_api.create_audit_entry
767: (p_group_per_in_ler_id => l_per_in_ler_id
768: ,p_group_pl_id => l_pl_id
769: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 766: ben_cwb_audit_api.create_audit_entry

762: and (p_txn_old.attribute18 is not null))
763: or (p_txn_old.attribute18 <> l_txn_new.attribute18) ) then
764: --
765: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then
766: ben_cwb_audit_api.create_audit_entry
767: (p_group_per_in_ler_id => l_per_in_ler_id
768: ,p_group_pl_id => l_pl_id
769: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
770: ,p_pl_id => l_pl_id

Line 788: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then

784: or ((l_txn_new.attribute19 is null)
785: and (p_txn_old.attribute19 is not null))
786: or (p_txn_old.attribute19 <> l_txn_new.attribute19) ) then
787: --
788: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then
789: ben_cwb_audit_api.create_audit_entry
790: (p_group_per_in_ler_id => l_per_in_ler_id
791: ,p_group_pl_id => l_pl_id
792: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 789: ben_cwb_audit_api.create_audit_entry

785: and (p_txn_old.attribute19 is not null))
786: or (p_txn_old.attribute19 <> l_txn_new.attribute19) ) then
787: --
788: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then
789: ben_cwb_audit_api.create_audit_entry
790: (p_group_per_in_ler_id => l_per_in_ler_id
791: ,p_group_pl_id => l_pl_id
792: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
793: ,p_pl_id => l_pl_id

Line 811: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then

807: or ((l_txn_new.attribute20 is null)
808: and (p_txn_old.attribute20 is not null))
809: or (p_txn_old.attribute20 <> l_txn_new.attribute20) ) then
810: --
811: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then
812: ben_cwb_audit_api.create_audit_entry
813: (p_group_per_in_ler_id => l_per_in_ler_id
814: ,p_group_pl_id => l_pl_id
815: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 812: ben_cwb_audit_api.create_audit_entry

808: and (p_txn_old.attribute20 is not null))
809: or (p_txn_old.attribute20 <> l_txn_new.attribute20) ) then
810: --
811: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then
812: ben_cwb_audit_api.create_audit_entry
813: (p_group_per_in_ler_id => l_per_in_ler_id
814: ,p_group_pl_id => l_pl_id
815: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
816: ,p_pl_id => l_pl_id

Line 834: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then

830: or ((l_txn_new.attribute21 is null)
831: and (p_txn_old.attribute21 is not null))
832: or (p_txn_old.attribute21 <> l_txn_new.attribute21) ) then
833: --
834: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then
835: ben_cwb_audit_api.create_audit_entry
836: (p_group_per_in_ler_id => l_per_in_ler_id
837: ,p_group_pl_id => l_pl_id
838: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 835: ben_cwb_audit_api.create_audit_entry

831: and (p_txn_old.attribute21 is not null))
832: or (p_txn_old.attribute21 <> l_txn_new.attribute21) ) then
833: --
834: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then
835: ben_cwb_audit_api.create_audit_entry
836: (p_group_per_in_ler_id => l_per_in_ler_id
837: ,p_group_pl_id => l_pl_id
838: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
839: ,p_pl_id => l_pl_id

Line 857: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then

853: or ((l_txn_new.attribute22 is null)
854: and (p_txn_old.attribute22 is not null))
855: or (p_txn_old.attribute22 <> l_txn_new.attribute22) ) then
856: --
857: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then
858: ben_cwb_audit_api.create_audit_entry
859: (p_group_per_in_ler_id => l_per_in_ler_id
860: ,p_group_pl_id => l_pl_id
861: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 858: ben_cwb_audit_api.create_audit_entry

854: and (p_txn_old.attribute22 is not null))
855: or (p_txn_old.attribute22 <> l_txn_new.attribute22) ) then
856: --
857: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then
858: ben_cwb_audit_api.create_audit_entry
859: (p_group_per_in_ler_id => l_per_in_ler_id
860: ,p_group_pl_id => l_pl_id
861: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
862: ,p_pl_id => l_pl_id

Line 880: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then

876: or ((l_txn_new.attribute23 is null)
877: and (p_txn_old.attribute23 is not null))
878: or (p_txn_old.attribute23 <> l_txn_new.attribute23) ) then
879: --
880: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then
881: ben_cwb_audit_api.create_audit_entry
882: (p_group_per_in_ler_id => l_per_in_ler_id
883: ,p_group_pl_id => l_pl_id
884: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 881: ben_cwb_audit_api.create_audit_entry

877: and (p_txn_old.attribute23 is not null))
878: or (p_txn_old.attribute23 <> l_txn_new.attribute23) ) then
879: --
880: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then
881: ben_cwb_audit_api.create_audit_entry
882: (p_group_per_in_ler_id => l_per_in_ler_id
883: ,p_group_pl_id => l_pl_id
884: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
885: ,p_pl_id => l_pl_id

Line 903: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then

899: or ((l_txn_new.attribute24 is null)
900: and (p_txn_old.attribute24 is not null))
901: or (p_txn_old.attribute24 <> l_txn_new.attribute24) ) then
902: --
903: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then
904: ben_cwb_audit_api.create_audit_entry
905: (p_group_per_in_ler_id => l_per_in_ler_id
906: ,p_group_pl_id => l_pl_id
907: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 904: ben_cwb_audit_api.create_audit_entry

900: and (p_txn_old.attribute24 is not null))
901: or (p_txn_old.attribute24 <> l_txn_new.attribute24) ) then
902: --
903: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then
904: ben_cwb_audit_api.create_audit_entry
905: (p_group_per_in_ler_id => l_per_in_ler_id
906: ,p_group_pl_id => l_pl_id
907: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
908: ,p_pl_id => l_pl_id

Line 926: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then

922: or ((l_txn_new.attribute25 is null)
923: and (p_txn_old.attribute25 is not null))
924: or (p_txn_old.attribute25 <> l_txn_new.attribute25) ) then
925: --
926: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then
927: ben_cwb_audit_api.create_audit_entry
928: (p_group_per_in_ler_id => l_per_in_ler_id
929: ,p_group_pl_id => l_pl_id
930: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 927: ben_cwb_audit_api.create_audit_entry

923: and (p_txn_old.attribute25 is not null))
924: or (p_txn_old.attribute25 <> l_txn_new.attribute25) ) then
925: --
926: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then
927: ben_cwb_audit_api.create_audit_entry
928: (p_group_per_in_ler_id => l_per_in_ler_id
929: ,p_group_pl_id => l_pl_id
930: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
931: ,p_pl_id => l_pl_id

Line 949: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then

945: or ((l_txn_new.attribute26 is null)
946: and (p_txn_old.attribute26 is not null))
947: or (p_txn_old.attribute26 <> l_txn_new.attribute26) ) then
948: --
949: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then
950: ben_cwb_audit_api.create_audit_entry
951: (p_group_per_in_ler_id => l_per_in_ler_id
952: ,p_group_pl_id => l_pl_id
953: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 950: ben_cwb_audit_api.create_audit_entry

946: and (p_txn_old.attribute26 is not null))
947: or (p_txn_old.attribute26 <> l_txn_new.attribute26) ) then
948: --
949: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then
950: ben_cwb_audit_api.create_audit_entry
951: (p_group_per_in_ler_id => l_per_in_ler_id
952: ,p_group_pl_id => l_pl_id
953: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
954: ,p_pl_id => l_pl_id

Line 972: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then

968: or ((l_txn_new.attribute27 is null)
969: and (p_txn_old.attribute27 is not null))
970: or (p_txn_old.attribute27 <> l_txn_new.attribute27) ) then
971: --
972: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then
973: ben_cwb_audit_api.create_audit_entry
974: (p_group_per_in_ler_id => l_per_in_ler_id
975: ,p_group_pl_id => l_pl_id
976: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 973: ben_cwb_audit_api.create_audit_entry

969: and (p_txn_old.attribute27 is not null))
970: or (p_txn_old.attribute27 <> l_txn_new.attribute27) ) then
971: --
972: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then
973: ben_cwb_audit_api.create_audit_entry
974: (p_group_per_in_ler_id => l_per_in_ler_id
975: ,p_group_pl_id => l_pl_id
976: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
977: ,p_pl_id => l_pl_id

Line 995: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then

991: or ((l_txn_new.attribute28 is null)
992: and (p_txn_old.attribute28 is not null))
993: or (p_txn_old.attribute28 <> l_txn_new.attribute28) ) then
994: --
995: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then
996: ben_cwb_audit_api.create_audit_entry
997: (p_group_per_in_ler_id => l_per_in_ler_id
998: ,p_group_pl_id => l_pl_id
999: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 996: ben_cwb_audit_api.create_audit_entry

992: and (p_txn_old.attribute28 is not null))
993: or (p_txn_old.attribute28 <> l_txn_new.attribute28) ) then
994: --
995: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then
996: ben_cwb_audit_api.create_audit_entry
997: (p_group_per_in_ler_id => l_per_in_ler_id
998: ,p_group_pl_id => l_pl_id
999: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1000: ,p_pl_id => l_pl_id

Line 1018: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then

1014: or ((l_txn_new.attribute29 is null)
1015: and (p_txn_old.attribute29 is not null))
1016: or (p_txn_old.attribute29 <> l_txn_new.attribute29) ) then
1017: --
1018: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then
1019: ben_cwb_audit_api.create_audit_entry
1020: (p_group_per_in_ler_id => l_per_in_ler_id
1021: ,p_group_pl_id => l_pl_id
1022: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1019: ben_cwb_audit_api.create_audit_entry

1015: and (p_txn_old.attribute29 is not null))
1016: or (p_txn_old.attribute29 <> l_txn_new.attribute29) ) then
1017: --
1018: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then
1019: ben_cwb_audit_api.create_audit_entry
1020: (p_group_per_in_ler_id => l_per_in_ler_id
1021: ,p_group_pl_id => l_pl_id
1022: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1023: ,p_pl_id => l_pl_id

Line 1041: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then

1037: or ((l_txn_new.attribute30 is null)
1038: and (p_txn_old.attribute30 is not null))
1039: or (p_txn_old.attribute30 <> l_txn_new.attribute30) ) then
1040: --
1041: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then
1042: ben_cwb_audit_api.create_audit_entry
1043: (p_group_per_in_ler_id => l_per_in_ler_id
1044: ,p_group_pl_id => l_pl_id
1045: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1042: ben_cwb_audit_api.create_audit_entry

1038: and (p_txn_old.attribute30 is not null))
1039: or (p_txn_old.attribute30 <> l_txn_new.attribute30) ) then
1040: --
1041: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then
1042: ben_cwb_audit_api.create_audit_entry
1043: (p_group_per_in_ler_id => l_per_in_ler_id
1044: ,p_group_pl_id => l_pl_id
1045: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1046: ,p_pl_id => l_pl_id

Line 1064: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then

1060: or ((l_txn_new.attribute31 is null)
1061: and (p_txn_old.attribute31 is not null))
1062: or (p_txn_old.attribute31 <> l_txn_new.attribute31) ) then
1063: --
1064: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then
1065: ben_cwb_audit_api.create_audit_entry
1066: (p_group_per_in_ler_id => l_per_in_ler_id
1067: ,p_group_pl_id => l_pl_id
1068: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1065: ben_cwb_audit_api.create_audit_entry

1061: and (p_txn_old.attribute31 is not null))
1062: or (p_txn_old.attribute31 <> l_txn_new.attribute31) ) then
1063: --
1064: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then
1065: ben_cwb_audit_api.create_audit_entry
1066: (p_group_per_in_ler_id => l_per_in_ler_id
1067: ,p_group_pl_id => l_pl_id
1068: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1069: ,p_pl_id => l_pl_id

Line 1087: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then

1083: or ((l_txn_new.attribute32 is null)
1084: and (p_txn_old.attribute32 is not null))
1085: or (p_txn_old.attribute32 <> l_txn_new.attribute32) ) then
1086: --
1087: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then
1088: ben_cwb_audit_api.create_audit_entry
1089: (p_group_per_in_ler_id => l_per_in_ler_id
1090: ,p_group_pl_id => l_pl_id
1091: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1088: ben_cwb_audit_api.create_audit_entry

1084: and (p_txn_old.attribute32 is not null))
1085: or (p_txn_old.attribute32 <> l_txn_new.attribute32) ) then
1086: --
1087: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then
1088: ben_cwb_audit_api.create_audit_entry
1089: (p_group_per_in_ler_id => l_per_in_ler_id
1090: ,p_group_pl_id => l_pl_id
1091: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1092: ,p_pl_id => l_pl_id

Line 1110: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then

1106: or ((l_txn_new.attribute33 is null)
1107: and (p_txn_old.attribute33 is not null))
1108: or (p_txn_old.attribute33 <> l_txn_new.attribute33) ) then
1109: --
1110: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then
1111: ben_cwb_audit_api.create_audit_entry
1112: (p_group_per_in_ler_id => l_per_in_ler_id
1113: ,p_group_pl_id => l_pl_id
1114: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1111: ben_cwb_audit_api.create_audit_entry

1107: and (p_txn_old.attribute33 is not null))
1108: or (p_txn_old.attribute33 <> l_txn_new.attribute33) ) then
1109: --
1110: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then
1111: ben_cwb_audit_api.create_audit_entry
1112: (p_group_per_in_ler_id => l_per_in_ler_id
1113: ,p_group_pl_id => l_pl_id
1114: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1115: ,p_pl_id => l_pl_id

Line 1133: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then

1129: or ((l_txn_new.attribute34 is null)
1130: and (p_txn_old.attribute34 is not null))
1131: or (p_txn_old.attribute34 <> l_txn_new.attribute34) ) then
1132: --
1133: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then
1134: ben_cwb_audit_api.create_audit_entry
1135: (p_group_per_in_ler_id => l_per_in_ler_id
1136: ,p_group_pl_id => l_pl_id
1137: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1134: ben_cwb_audit_api.create_audit_entry

1130: and (p_txn_old.attribute34 is not null))
1131: or (p_txn_old.attribute34 <> l_txn_new.attribute34) ) then
1132: --
1133: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then
1134: ben_cwb_audit_api.create_audit_entry
1135: (p_group_per_in_ler_id => l_per_in_ler_id
1136: ,p_group_pl_id => l_pl_id
1137: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1138: ,p_pl_id => l_pl_id

Line 1156: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then

1152: or ((l_txn_new.attribute35 is null)
1153: and (p_txn_old.attribute35 is not null))
1154: or (p_txn_old.attribute35 <> l_txn_new.attribute35) ) then
1155: --
1156: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then
1157: ben_cwb_audit_api.create_audit_entry
1158: (p_group_per_in_ler_id => l_per_in_ler_id
1159: ,p_group_pl_id => l_pl_id
1160: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1157: ben_cwb_audit_api.create_audit_entry

1153: and (p_txn_old.attribute35 is not null))
1154: or (p_txn_old.attribute35 <> l_txn_new.attribute35) ) then
1155: --
1156: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then
1157: ben_cwb_audit_api.create_audit_entry
1158: (p_group_per_in_ler_id => l_per_in_ler_id
1159: ,p_group_pl_id => l_pl_id
1160: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1161: ,p_pl_id => l_pl_id

Line 1179: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then

1175: or ((l_txn_new.attribute36 is null)
1176: and (p_txn_old.attribute36 is not null))
1177: or (p_txn_old.attribute36 <> l_txn_new.attribute36) ) then
1178: --
1179: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then
1180: ben_cwb_audit_api.create_audit_entry
1181: (p_group_per_in_ler_id => l_per_in_ler_id
1182: ,p_group_pl_id => l_pl_id
1183: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1180: ben_cwb_audit_api.create_audit_entry

1176: and (p_txn_old.attribute36 is not null))
1177: or (p_txn_old.attribute36 <> l_txn_new.attribute36) ) then
1178: --
1179: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then
1180: ben_cwb_audit_api.create_audit_entry
1181: (p_group_per_in_ler_id => l_per_in_ler_id
1182: ,p_group_pl_id => l_pl_id
1183: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1184: ,p_pl_id => l_pl_id

Line 1202: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then

1198: or ((l_txn_new.attribute37 is null)
1199: and (p_txn_old.attribute37 is not null))
1200: or (p_txn_old.attribute37 <> l_txn_new.attribute37) ) then
1201: --
1202: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then
1203: ben_cwb_audit_api.create_audit_entry
1204: (p_group_per_in_ler_id => l_per_in_ler_id
1205: ,p_group_pl_id => l_pl_id
1206: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1203: ben_cwb_audit_api.create_audit_entry

1199: and (p_txn_old.attribute37 is not null))
1200: or (p_txn_old.attribute37 <> l_txn_new.attribute37) ) then
1201: --
1202: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then
1203: ben_cwb_audit_api.create_audit_entry
1204: (p_group_per_in_ler_id => l_per_in_ler_id
1205: ,p_group_pl_id => l_pl_id
1206: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1207: ,p_pl_id => l_pl_id

Line 1225: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then

1221: or ((l_txn_new.attribute38 is null)
1222: and (p_txn_old.attribute38 is not null))
1223: or (p_txn_old.attribute38 <> l_txn_new.attribute38) ) then
1224: --
1225: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then
1226: ben_cwb_audit_api.create_audit_entry
1227: (p_group_per_in_ler_id => l_per_in_ler_id
1228: ,p_group_pl_id => l_pl_id
1229: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1226: ben_cwb_audit_api.create_audit_entry

1222: and (p_txn_old.attribute38 is not null))
1223: or (p_txn_old.attribute38 <> l_txn_new.attribute38) ) then
1224: --
1225: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then
1226: ben_cwb_audit_api.create_audit_entry
1227: (p_group_per_in_ler_id => l_per_in_ler_id
1228: ,p_group_pl_id => l_pl_id
1229: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1230: ,p_pl_id => l_pl_id

Line 1248: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then

1244: or ((l_txn_new.attribute39 is null)
1245: and (p_txn_old.attribute39 is not null))
1246: or (p_txn_old.attribute39 <> l_txn_new.attribute39) ) then
1247: --
1248: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then
1249: ben_cwb_audit_api.create_audit_entry
1250: (p_group_per_in_ler_id => l_per_in_ler_id
1251: ,p_group_pl_id => l_pl_id
1252: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1249: ben_cwb_audit_api.create_audit_entry

1245: and (p_txn_old.attribute39 is not null))
1246: or (p_txn_old.attribute39 <> l_txn_new.attribute39) ) then
1247: --
1248: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then
1249: ben_cwb_audit_api.create_audit_entry
1250: (p_group_per_in_ler_id => l_per_in_ler_id
1251: ,p_group_pl_id => l_pl_id
1252: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1253: ,p_pl_id => l_pl_id

Line 1271: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then

1267: or ((l_txn_new.attribute40 is null)
1268: and (p_txn_old.attribute40 is not null))
1269: or (p_txn_old.attribute40 <> l_txn_new.attribute40) ) then
1270: --
1271: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then
1272: ben_cwb_audit_api.create_audit_entry
1273: (p_group_per_in_ler_id => l_per_in_ler_id
1274: ,p_group_pl_id => l_pl_id
1275: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1272: ben_cwb_audit_api.create_audit_entry

1268: and (p_txn_old.attribute40 is not null))
1269: or (p_txn_old.attribute40 <> l_txn_new.attribute40) ) then
1270: --
1271: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then
1272: ben_cwb_audit_api.create_audit_entry
1273: (p_group_per_in_ler_id => l_per_in_ler_id
1274: ,p_group_pl_id => l_pl_id
1275: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1276: ,p_pl_id => l_pl_id

Line 1298: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then

1294: fetch c_job into l_cd_meaning_old;
1295: close c_job;
1296: --
1297: --
1298: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
1299: ben_cwb_audit_api.create_audit_entry
1300: (p_group_per_in_ler_id => l_per_in_ler_id
1301: ,p_group_pl_id => l_pl_id
1302: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1299: ben_cwb_audit_api.create_audit_entry

1295: close c_job;
1296: --
1297: --
1298: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
1299: ben_cwb_audit_api.create_audit_entry
1300: (p_group_per_in_ler_id => l_per_in_ler_id
1301: ,p_group_pl_id => l_pl_id
1302: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1303: ,p_pl_id => l_pl_id

Line 1322: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then

1318: fetch c_lookup into l_cd_meaning_old;
1319: close c_lookup;
1320: --
1321: --
1322: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
1323: ben_cwb_audit_api.create_audit_entry
1324: (p_group_per_in_ler_id => l_per_in_ler_id
1325: ,p_group_pl_id => l_pl_id
1326: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1323: ben_cwb_audit_api.create_audit_entry

1319: close c_lookup;
1320: --
1321: --
1322: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
1323: ben_cwb_audit_api.create_audit_entry
1324: (p_group_per_in_ler_id => l_per_in_ler_id
1325: ,p_group_pl_id => l_pl_id
1326: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1327: ,p_pl_id => l_pl_id

Line 1348: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then

1344: close c_grade;
1345: --
1346: --
1347: --
1348: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
1349: ben_cwb_audit_api.create_audit_entry
1350: (p_group_per_in_ler_id => l_per_in_ler_id
1351: ,p_group_pl_id => l_pl_id
1352: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1349: ben_cwb_audit_api.create_audit_entry

1345: --
1346: --
1347: --
1348: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
1349: ben_cwb_audit_api.create_audit_entry
1350: (p_group_per_in_ler_id => l_per_in_ler_id
1351: ,p_group_pl_id => l_pl_id
1352: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1353: ,p_pl_id => l_pl_id

Line 1368: if(ben_cwb_audit_api.return_lookup_validity('AF')=true) then

1364: end if;
1365: --
1366: if(p_txn_old.attribute8 is not null) then
1367: --
1368: if(ben_cwb_audit_api.return_lookup_validity('AF')=true) then
1369: ben_cwb_audit_api.create_audit_entry
1370: (p_group_per_in_ler_id => l_per_in_ler_id
1371: ,p_group_pl_id => l_pl_id
1372: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1369: ben_cwb_audit_api.create_audit_entry

1365: --
1366: if(p_txn_old.attribute8 is not null) then
1367: --
1368: if(ben_cwb_audit_api.return_lookup_validity('AF')=true) then
1369: ben_cwb_audit_api.create_audit_entry
1370: (p_group_per_in_ler_id => l_per_in_ler_id
1371: ,p_group_pl_id => l_pl_id
1372: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1373: ,p_pl_id => l_pl_id

Line 1393: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then

1389: close c_position;
1390: --
1391: --
1392: --
1393: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
1394: ben_cwb_audit_api.create_audit_entry
1395: (p_group_per_in_ler_id => l_per_in_ler_id
1396: ,p_group_pl_id => l_pl_id
1397: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1394: ben_cwb_audit_api.create_audit_entry

1390: --
1391: --
1392: --
1393: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
1394: ben_cwb_audit_api.create_audit_entry
1395: (p_group_per_in_ler_id => l_per_in_ler_id
1396: ,p_group_pl_id => l_pl_id
1397: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1398: ,p_pl_id => l_pl_id

Line 1412: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then

1408: end if;
1409: end if;
1410: if(p_txn_old.attribute11 is not null) then
1411: --
1412: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then
1413: ben_cwb_audit_api.create_audit_entry
1414: (p_group_per_in_ler_id => l_per_in_ler_id
1415: ,p_group_pl_id => l_pl_id
1416: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1413: ben_cwb_audit_api.create_audit_entry

1409: end if;
1410: if(p_txn_old.attribute11 is not null) then
1411: --
1412: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then
1413: ben_cwb_audit_api.create_audit_entry
1414: (p_group_per_in_ler_id => l_per_in_ler_id
1415: ,p_group_pl_id => l_pl_id
1416: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1417: ,p_pl_id => l_pl_id

Line 1431: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then

1427: end if;
1428: end if;
1429: if(p_txn_old.attribute12 is not null) then
1430: --
1431: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then
1432: ben_cwb_audit_api.create_audit_entry
1433: (p_group_per_in_ler_id => l_per_in_ler_id
1434: ,p_group_pl_id => l_pl_id
1435: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1432: ben_cwb_audit_api.create_audit_entry

1428: end if;
1429: if(p_txn_old.attribute12 is not null) then
1430: --
1431: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then
1432: ben_cwb_audit_api.create_audit_entry
1433: (p_group_per_in_ler_id => l_per_in_ler_id
1434: ,p_group_pl_id => l_pl_id
1435: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1436: ,p_pl_id => l_pl_id

Line 1450: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then

1446: end if;
1447: end if;
1448: if(p_txn_old.attribute13 is not null) then
1449: --
1450: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then
1451: ben_cwb_audit_api.create_audit_entry
1452: (p_group_per_in_ler_id => l_per_in_ler_id
1453: ,p_group_pl_id => l_pl_id
1454: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1451: ben_cwb_audit_api.create_audit_entry

1447: end if;
1448: if(p_txn_old.attribute13 is not null) then
1449: --
1450: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then
1451: ben_cwb_audit_api.create_audit_entry
1452: (p_group_per_in_ler_id => l_per_in_ler_id
1453: ,p_group_pl_id => l_pl_id
1454: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1455: ,p_pl_id => l_pl_id

Line 1469: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then

1465: end if;
1466: end if;
1467: if(p_txn_old.attribute14 is not null) then
1468: --
1469: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then
1470: ben_cwb_audit_api.create_audit_entry
1471: (p_group_per_in_ler_id => l_per_in_ler_id
1472: ,p_group_pl_id => l_pl_id
1473: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1470: ben_cwb_audit_api.create_audit_entry

1466: end if;
1467: if(p_txn_old.attribute14 is not null) then
1468: --
1469: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then
1470: ben_cwb_audit_api.create_audit_entry
1471: (p_group_per_in_ler_id => l_per_in_ler_id
1472: ,p_group_pl_id => l_pl_id
1473: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1474: ,p_pl_id => l_pl_id

Line 1488: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then

1484: end if;
1485: end if;
1486: if(p_txn_old.attribute15 is not null) then
1487: --
1488: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then
1489: ben_cwb_audit_api.create_audit_entry
1490: (p_group_per_in_ler_id => l_per_in_ler_id
1491: ,p_group_pl_id => l_pl_id
1492: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1489: ben_cwb_audit_api.create_audit_entry

1485: end if;
1486: if(p_txn_old.attribute15 is not null) then
1487: --
1488: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then
1489: ben_cwb_audit_api.create_audit_entry
1490: (p_group_per_in_ler_id => l_per_in_ler_id
1491: ,p_group_pl_id => l_pl_id
1492: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1493: ,p_pl_id => l_pl_id

Line 1507: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then

1503: end if;
1504: end if;
1505: if(p_txn_old.attribute16 is not null) then
1506: --
1507: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then
1508: ben_cwb_audit_api.create_audit_entry
1509: (p_group_per_in_ler_id => l_per_in_ler_id
1510: ,p_group_pl_id => l_pl_id
1511: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1508: ben_cwb_audit_api.create_audit_entry

1504: end if;
1505: if(p_txn_old.attribute16 is not null) then
1506: --
1507: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then
1508: ben_cwb_audit_api.create_audit_entry
1509: (p_group_per_in_ler_id => l_per_in_ler_id
1510: ,p_group_pl_id => l_pl_id
1511: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1512: ,p_pl_id => l_pl_id

Line 1526: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then

1522: end if;
1523: end if;
1524: if(p_txn_old.attribute17 is not null) then
1525: --
1526: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then
1527: ben_cwb_audit_api.create_audit_entry
1528: (p_group_per_in_ler_id => l_per_in_ler_id
1529: ,p_group_pl_id => l_pl_id
1530: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1527: ben_cwb_audit_api.create_audit_entry

1523: end if;
1524: if(p_txn_old.attribute17 is not null) then
1525: --
1526: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then
1527: ben_cwb_audit_api.create_audit_entry
1528: (p_group_per_in_ler_id => l_per_in_ler_id
1529: ,p_group_pl_id => l_pl_id
1530: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1531: ,p_pl_id => l_pl_id

Line 1545: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then

1541: end if;
1542: end if;
1543: if(p_txn_old.attribute18 is not null) then
1544: --
1545: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then
1546: ben_cwb_audit_api.create_audit_entry
1547: (p_group_per_in_ler_id => l_per_in_ler_id
1548: ,p_group_pl_id => l_pl_id
1549: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1546: ben_cwb_audit_api.create_audit_entry

1542: end if;
1543: if(p_txn_old.attribute18 is not null) then
1544: --
1545: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then
1546: ben_cwb_audit_api.create_audit_entry
1547: (p_group_per_in_ler_id => l_per_in_ler_id
1548: ,p_group_pl_id => l_pl_id
1549: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1550: ,p_pl_id => l_pl_id

Line 1564: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then

1560: end if;
1561: end if;
1562: if(p_txn_old.attribute19 is not null) then
1563: --
1564: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then
1565: ben_cwb_audit_api.create_audit_entry
1566: (p_group_per_in_ler_id => l_per_in_ler_id
1567: ,p_group_pl_id => l_pl_id
1568: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1565: ben_cwb_audit_api.create_audit_entry

1561: end if;
1562: if(p_txn_old.attribute19 is not null) then
1563: --
1564: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then
1565: ben_cwb_audit_api.create_audit_entry
1566: (p_group_per_in_ler_id => l_per_in_ler_id
1567: ,p_group_pl_id => l_pl_id
1568: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1569: ,p_pl_id => l_pl_id

Line 1583: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then

1579: end if;
1580: end if;
1581: if(p_txn_old.attribute20 is not null) then
1582: --
1583: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then
1584: ben_cwb_audit_api.create_audit_entry
1585: (p_group_per_in_ler_id => l_per_in_ler_id
1586: ,p_group_pl_id => l_pl_id
1587: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1584: ben_cwb_audit_api.create_audit_entry

1580: end if;
1581: if(p_txn_old.attribute20 is not null) then
1582: --
1583: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then
1584: ben_cwb_audit_api.create_audit_entry
1585: (p_group_per_in_ler_id => l_per_in_ler_id
1586: ,p_group_pl_id => l_pl_id
1587: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1588: ,p_pl_id => l_pl_id

Line 1602: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then

1598: end if;
1599: end if;
1600: if(p_txn_old.attribute21 is not null) then
1601: --
1602: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then
1603: ben_cwb_audit_api.create_audit_entry
1604: (p_group_per_in_ler_id => l_per_in_ler_id
1605: ,p_group_pl_id => l_pl_id
1606: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1603: ben_cwb_audit_api.create_audit_entry

1599: end if;
1600: if(p_txn_old.attribute21 is not null) then
1601: --
1602: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then
1603: ben_cwb_audit_api.create_audit_entry
1604: (p_group_per_in_ler_id => l_per_in_ler_id
1605: ,p_group_pl_id => l_pl_id
1606: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1607: ,p_pl_id => l_pl_id

Line 1621: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then

1617: end if;
1618: end if;
1619: if(p_txn_old.attribute22 is not null) then
1620: --
1621: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then
1622: ben_cwb_audit_api.create_audit_entry
1623: (p_group_per_in_ler_id => l_per_in_ler_id
1624: ,p_group_pl_id => l_pl_id
1625: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1622: ben_cwb_audit_api.create_audit_entry

1618: end if;
1619: if(p_txn_old.attribute22 is not null) then
1620: --
1621: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then
1622: ben_cwb_audit_api.create_audit_entry
1623: (p_group_per_in_ler_id => l_per_in_ler_id
1624: ,p_group_pl_id => l_pl_id
1625: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1626: ,p_pl_id => l_pl_id

Line 1640: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then

1636: end if;
1637: end if;
1638: if(p_txn_old.attribute23 is not null) then
1639: --
1640: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then
1641: ben_cwb_audit_api.create_audit_entry
1642: (p_group_per_in_ler_id => l_per_in_ler_id
1643: ,p_group_pl_id => l_pl_id
1644: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1641: ben_cwb_audit_api.create_audit_entry

1637: end if;
1638: if(p_txn_old.attribute23 is not null) then
1639: --
1640: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then
1641: ben_cwb_audit_api.create_audit_entry
1642: (p_group_per_in_ler_id => l_per_in_ler_id
1643: ,p_group_pl_id => l_pl_id
1644: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1645: ,p_pl_id => l_pl_id

Line 1659: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then

1655: end if;
1656: end if;
1657: if(p_txn_old.attribute24 is not null) then
1658: --
1659: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then
1660: ben_cwb_audit_api.create_audit_entry
1661: (p_group_per_in_ler_id => l_per_in_ler_id
1662: ,p_group_pl_id => l_pl_id
1663: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1660: ben_cwb_audit_api.create_audit_entry

1656: end if;
1657: if(p_txn_old.attribute24 is not null) then
1658: --
1659: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then
1660: ben_cwb_audit_api.create_audit_entry
1661: (p_group_per_in_ler_id => l_per_in_ler_id
1662: ,p_group_pl_id => l_pl_id
1663: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1664: ,p_pl_id => l_pl_id

Line 1678: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then

1674: end if;
1675: end if;
1676: if(p_txn_old.attribute25 is not null) then
1677: --
1678: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then
1679: ben_cwb_audit_api.create_audit_entry
1680: (p_group_per_in_ler_id => l_per_in_ler_id
1681: ,p_group_pl_id => l_pl_id
1682: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1679: ben_cwb_audit_api.create_audit_entry

1675: end if;
1676: if(p_txn_old.attribute25 is not null) then
1677: --
1678: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then
1679: ben_cwb_audit_api.create_audit_entry
1680: (p_group_per_in_ler_id => l_per_in_ler_id
1681: ,p_group_pl_id => l_pl_id
1682: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1683: ,p_pl_id => l_pl_id

Line 1697: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then

1693: end if;
1694: end if;
1695: if(p_txn_old.attribute26 is not null) then
1696: --
1697: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then
1698: ben_cwb_audit_api.create_audit_entry
1699: (p_group_per_in_ler_id => l_per_in_ler_id
1700: ,p_group_pl_id => l_pl_id
1701: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1698: ben_cwb_audit_api.create_audit_entry

1694: end if;
1695: if(p_txn_old.attribute26 is not null) then
1696: --
1697: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then
1698: ben_cwb_audit_api.create_audit_entry
1699: (p_group_per_in_ler_id => l_per_in_ler_id
1700: ,p_group_pl_id => l_pl_id
1701: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1702: ,p_pl_id => l_pl_id

Line 1716: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then

1712: end if;
1713: end if;
1714: if(p_txn_old.attribute27 is not null) then
1715: --
1716: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then
1717: ben_cwb_audit_api.create_audit_entry
1718: (p_group_per_in_ler_id => l_per_in_ler_id
1719: ,p_group_pl_id => l_pl_id
1720: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1717: ben_cwb_audit_api.create_audit_entry

1713: end if;
1714: if(p_txn_old.attribute27 is not null) then
1715: --
1716: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then
1717: ben_cwb_audit_api.create_audit_entry
1718: (p_group_per_in_ler_id => l_per_in_ler_id
1719: ,p_group_pl_id => l_pl_id
1720: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1721: ,p_pl_id => l_pl_id

Line 1735: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then

1731: end if;
1732: end if;
1733: if(p_txn_old.attribute28 is not null) then
1734: --
1735: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then
1736: ben_cwb_audit_api.create_audit_entry
1737: (p_group_per_in_ler_id => l_per_in_ler_id
1738: ,p_group_pl_id => l_pl_id
1739: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1736: ben_cwb_audit_api.create_audit_entry

1732: end if;
1733: if(p_txn_old.attribute28 is not null) then
1734: --
1735: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then
1736: ben_cwb_audit_api.create_audit_entry
1737: (p_group_per_in_ler_id => l_per_in_ler_id
1738: ,p_group_pl_id => l_pl_id
1739: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1740: ,p_pl_id => l_pl_id

Line 1754: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then

1750: end if;
1751: end if;
1752: if(p_txn_old.attribute29 is not null) then
1753: --
1754: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then
1755: ben_cwb_audit_api.create_audit_entry
1756: (p_group_per_in_ler_id => l_per_in_ler_id
1757: ,p_group_pl_id => l_pl_id
1758: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1755: ben_cwb_audit_api.create_audit_entry

1751: end if;
1752: if(p_txn_old.attribute29 is not null) then
1753: --
1754: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then
1755: ben_cwb_audit_api.create_audit_entry
1756: (p_group_per_in_ler_id => l_per_in_ler_id
1757: ,p_group_pl_id => l_pl_id
1758: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1759: ,p_pl_id => l_pl_id

Line 1773: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then

1769: end if;
1770: end if;
1771: if(p_txn_old.attribute30 is not null) then
1772: --
1773: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then
1774: ben_cwb_audit_api.create_audit_entry
1775: (p_group_per_in_ler_id => l_per_in_ler_id
1776: ,p_group_pl_id => l_pl_id
1777: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1774: ben_cwb_audit_api.create_audit_entry

1770: end if;
1771: if(p_txn_old.attribute30 is not null) then
1772: --
1773: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then
1774: ben_cwb_audit_api.create_audit_entry
1775: (p_group_per_in_ler_id => l_per_in_ler_id
1776: ,p_group_pl_id => l_pl_id
1777: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1778: ,p_pl_id => l_pl_id

Line 1792: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then

1788: end if;
1789: end if;
1790: if(p_txn_old.attribute31 is not null) then
1791: --
1792: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then
1793: ben_cwb_audit_api.create_audit_entry
1794: (p_group_per_in_ler_id => l_per_in_ler_id
1795: ,p_group_pl_id => l_pl_id
1796: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1793: ben_cwb_audit_api.create_audit_entry

1789: end if;
1790: if(p_txn_old.attribute31 is not null) then
1791: --
1792: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then
1793: ben_cwb_audit_api.create_audit_entry
1794: (p_group_per_in_ler_id => l_per_in_ler_id
1795: ,p_group_pl_id => l_pl_id
1796: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1797: ,p_pl_id => l_pl_id

Line 1811: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then

1807: end if;
1808: end if;
1809: if(p_txn_old.attribute32 is not null) then
1810: --
1811: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then
1812: ben_cwb_audit_api.create_audit_entry
1813: (p_group_per_in_ler_id => l_per_in_ler_id
1814: ,p_group_pl_id => l_pl_id
1815: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1812: ben_cwb_audit_api.create_audit_entry

1808: end if;
1809: if(p_txn_old.attribute32 is not null) then
1810: --
1811: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then
1812: ben_cwb_audit_api.create_audit_entry
1813: (p_group_per_in_ler_id => l_per_in_ler_id
1814: ,p_group_pl_id => l_pl_id
1815: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1816: ,p_pl_id => l_pl_id

Line 1830: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then

1826: end if;
1827: end if;
1828: if(p_txn_old.attribute33 is not null) then
1829: --
1830: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then
1831: ben_cwb_audit_api.create_audit_entry
1832: (p_group_per_in_ler_id => l_per_in_ler_id
1833: ,p_group_pl_id => l_pl_id
1834: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1831: ben_cwb_audit_api.create_audit_entry

1827: end if;
1828: if(p_txn_old.attribute33 is not null) then
1829: --
1830: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then
1831: ben_cwb_audit_api.create_audit_entry
1832: (p_group_per_in_ler_id => l_per_in_ler_id
1833: ,p_group_pl_id => l_pl_id
1834: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1835: ,p_pl_id => l_pl_id

Line 1849: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then

1845: end if;
1846: end if;
1847: if(p_txn_old.attribute34 is not null) then
1848: --
1849: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then
1850: ben_cwb_audit_api.create_audit_entry
1851: (p_group_per_in_ler_id => l_per_in_ler_id
1852: ,p_group_pl_id => l_pl_id
1853: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1850: ben_cwb_audit_api.create_audit_entry

1846: end if;
1847: if(p_txn_old.attribute34 is not null) then
1848: --
1849: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then
1850: ben_cwb_audit_api.create_audit_entry
1851: (p_group_per_in_ler_id => l_per_in_ler_id
1852: ,p_group_pl_id => l_pl_id
1853: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1854: ,p_pl_id => l_pl_id

Line 1868: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then

1864: end if;
1865: end if;
1866: if(p_txn_old.attribute35 is not null) then
1867: --
1868: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then
1869: ben_cwb_audit_api.create_audit_entry
1870: (p_group_per_in_ler_id => l_per_in_ler_id
1871: ,p_group_pl_id => l_pl_id
1872: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1869: ben_cwb_audit_api.create_audit_entry

1865: end if;
1866: if(p_txn_old.attribute35 is not null) then
1867: --
1868: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then
1869: ben_cwb_audit_api.create_audit_entry
1870: (p_group_per_in_ler_id => l_per_in_ler_id
1871: ,p_group_pl_id => l_pl_id
1872: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1873: ,p_pl_id => l_pl_id

Line 1887: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then

1883: end if;
1884: end if;
1885: if(p_txn_old.attribute36 is not null) then
1886: --
1887: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then
1888: ben_cwb_audit_api.create_audit_entry
1889: (p_group_per_in_ler_id => l_per_in_ler_id
1890: ,p_group_pl_id => l_pl_id
1891: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1888: ben_cwb_audit_api.create_audit_entry

1884: end if;
1885: if(p_txn_old.attribute36 is not null) then
1886: --
1887: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then
1888: ben_cwb_audit_api.create_audit_entry
1889: (p_group_per_in_ler_id => l_per_in_ler_id
1890: ,p_group_pl_id => l_pl_id
1891: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1892: ,p_pl_id => l_pl_id

Line 1906: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then

1902: end if;
1903: end if;
1904: if(p_txn_old.attribute37 is not null) then
1905: --
1906: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then
1907: ben_cwb_audit_api.create_audit_entry
1908: (p_group_per_in_ler_id => l_per_in_ler_id
1909: ,p_group_pl_id => l_pl_id
1910: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1907: ben_cwb_audit_api.create_audit_entry

1903: end if;
1904: if(p_txn_old.attribute37 is not null) then
1905: --
1906: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then
1907: ben_cwb_audit_api.create_audit_entry
1908: (p_group_per_in_ler_id => l_per_in_ler_id
1909: ,p_group_pl_id => l_pl_id
1910: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1911: ,p_pl_id => l_pl_id

Line 1925: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then

1921: end if;
1922: end if;
1923: if(p_txn_old.attribute38 is not null) then
1924: --
1925: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then
1926: ben_cwb_audit_api.create_audit_entry
1927: (p_group_per_in_ler_id => l_per_in_ler_id
1928: ,p_group_pl_id => l_pl_id
1929: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1926: ben_cwb_audit_api.create_audit_entry

1922: end if;
1923: if(p_txn_old.attribute38 is not null) then
1924: --
1925: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then
1926: ben_cwb_audit_api.create_audit_entry
1927: (p_group_per_in_ler_id => l_per_in_ler_id
1928: ,p_group_pl_id => l_pl_id
1929: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1930: ,p_pl_id => l_pl_id

Line 1944: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then

1940: end if;
1941: end if;
1942: if(p_txn_old.attribute39 is not null) then
1943: --
1944: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then
1945: ben_cwb_audit_api.create_audit_entry
1946: (p_group_per_in_ler_id => l_per_in_ler_id
1947: ,p_group_pl_id => l_pl_id
1948: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1945: ben_cwb_audit_api.create_audit_entry

1941: end if;
1942: if(p_txn_old.attribute39 is not null) then
1943: --
1944: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then
1945: ben_cwb_audit_api.create_audit_entry
1946: (p_group_per_in_ler_id => l_per_in_ler_id
1947: ,p_group_pl_id => l_pl_id
1948: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1949: ,p_pl_id => l_pl_id

Line 1963: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then

1959: end if;
1960: end if;
1961: if(p_txn_old.attribute40 is not null) then
1962: --
1963: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then
1964: ben_cwb_audit_api.create_audit_entry
1965: (p_group_per_in_ler_id => l_per_in_ler_id
1966: ,p_group_pl_id => l_pl_id
1967: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1964: ben_cwb_audit_api.create_audit_entry

1960: end if;
1961: if(p_txn_old.attribute40 is not null) then
1962: --
1963: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then
1964: ben_cwb_audit_api.create_audit_entry
1965: (p_group_per_in_ler_id => l_per_in_ler_id
1966: ,p_group_pl_id => l_pl_id
1967: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1968: ,p_pl_id => l_pl_id