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 254: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then

250: fetch c_lookup into l_cd_meaning_new;
251: close c_lookup;
252: --
253: --
254: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
255: ben_cwb_audit_api.create_audit_entry
256: (p_group_per_in_ler_id => l_per_in_ler_id
257: ,p_group_pl_id => l_pl_id
258: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 255: ben_cwb_audit_api.create_audit_entry

251: close c_lookup;
252: --
253: --
254: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
255: ben_cwb_audit_api.create_audit_entry
256: (p_group_per_in_ler_id => l_per_in_ler_id
257: ,p_group_pl_id => l_pl_id
258: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
259: ,p_pl_id => l_pl_id

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

278: --
279: l_cd_meaning_new := null;
280: --
281: --
282: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
283: ben_cwb_audit_api.create_audit_entry
284: (p_group_per_in_ler_id => l_per_in_ler_id
285: ,p_group_pl_id => l_pl_id
286: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 283: ben_cwb_audit_api.create_audit_entry

279: l_cd_meaning_new := null;
280: --
281: --
282: if(ben_cwb_audit_api.return_lookup_validity('PR')=true) then
283: ben_cwb_audit_api.create_audit_entry
284: (p_group_per_in_ler_id => l_per_in_ler_id
285: ,p_group_pl_id => l_pl_id
286: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
287: ,p_pl_id => l_pl_id

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

436: close c_job;
437: --
438: --
439: --
440: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
441: ben_cwb_audit_api.create_audit_entry
442: (p_group_per_in_ler_id => l_per_in_ler_id
443: ,p_group_pl_id => l_pl_id
444: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 441: ben_cwb_audit_api.create_audit_entry

437: --
438: --
439: --
440: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
441: ben_cwb_audit_api.create_audit_entry
442: (p_group_per_in_ler_id => l_per_in_ler_id
443: ,p_group_pl_id => l_pl_id
444: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
445: ,p_pl_id => l_pl_id

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

469: fetch c_lookup into l_cd_meaning_new;
470: close c_lookup;
471: --
472: --
473: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
474: ben_cwb_audit_api.create_audit_entry
475: (p_group_per_in_ler_id => l_per_in_ler_id
476: ,p_group_pl_id => l_pl_id
477: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 474: ben_cwb_audit_api.create_audit_entry

470: close c_lookup;
471: --
472: --
473: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
474: ben_cwb_audit_api.create_audit_entry
475: (p_group_per_in_ler_id => l_per_in_ler_id
476: ,p_group_pl_id => l_pl_id
477: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
478: ,p_pl_id => l_pl_id

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

503: close c_grade;
504: --
505: --
506: --
507: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
508: ben_cwb_audit_api.create_audit_entry
509: (p_group_per_in_ler_id => l_per_in_ler_id
510: ,p_group_pl_id => l_pl_id
511: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 508: ben_cwb_audit_api.create_audit_entry

504: --
505: --
506: --
507: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
508: ben_cwb_audit_api.create_audit_entry
509: (p_group_per_in_ler_id => l_per_in_ler_id
510: ,p_group_pl_id => l_pl_id
511: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
512: ,p_pl_id => l_pl_id

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

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

Line 532: ben_cwb_audit_api.create_audit_entry

528: and (p_txn_old.attribute8 is not null))
529: or (p_txn_old.attribute8 <> l_txn_new.attribute8) ) then
530: --
531: if(ben_cwb_audit_api.return_lookup_validity('PG')=true) then
532: ben_cwb_audit_api.create_audit_entry
533: (p_group_per_in_ler_id => l_per_in_ler_id
534: ,p_group_pl_id => l_pl_id
535: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
536: ,p_pl_id => l_pl_id

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

559: fetch c_position into l_cd_meaning_new;
560: close c_position;
561: --
562: --
563: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
564: ben_cwb_audit_api.create_audit_entry
565: (p_group_per_in_ler_id => l_per_in_ler_id
566: ,p_group_pl_id => l_pl_id
567: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 564: ben_cwb_audit_api.create_audit_entry

560: close c_position;
561: --
562: --
563: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
564: ben_cwb_audit_api.create_audit_entry
565: (p_group_per_in_ler_id => l_per_in_ler_id
566: ,p_group_pl_id => l_pl_id
567: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
568: ,p_pl_id => l_pl_id

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

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

Line 587: ben_cwb_audit_api.create_audit_entry

583: and (p_txn_old.attribute9 is not null))
584: or (p_txn_old.attribute9 <> l_txn_new.attribute9) ) then
585: --
586: if(ben_cwb_audit_api.return_lookup_validity('SCL')=true) then
587: ben_cwb_audit_api.create_audit_entry
588: (p_group_per_in_ler_id => l_per_in_ler_id
589: ,p_group_pl_id => l_pl_id
590: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
591: ,p_pl_id => l_pl_id

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

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

Line 610: ben_cwb_audit_api.create_audit_entry

606: and (p_txn_old.attribute11 is not null))
607: or (p_txn_old.attribute11 <> l_txn_new.attribute11) ) then
608: --
609: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then
610: ben_cwb_audit_api.create_audit_entry
611: (p_group_per_in_ler_id => l_per_in_ler_id
612: ,p_group_pl_id => l_pl_id
613: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
614: ,p_pl_id => l_pl_id

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

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

Line 633: ben_cwb_audit_api.create_audit_entry

629: and (p_txn_old.attribute12 is not null))
630: or (p_txn_old.attribute12 <> l_txn_new.attribute12) ) then
631: --
632: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then
633: ben_cwb_audit_api.create_audit_entry
634: (p_group_per_in_ler_id => l_per_in_ler_id
635: ,p_group_pl_id => l_pl_id
636: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
637: ,p_pl_id => l_pl_id

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

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

Line 656: ben_cwb_audit_api.create_audit_entry

652: and (p_txn_old.attribute13 is not null))
653: or (p_txn_old.attribute13 <> l_txn_new.attribute13) ) then
654: --
655: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then
656: ben_cwb_audit_api.create_audit_entry
657: (p_group_per_in_ler_id => l_per_in_ler_id
658: ,p_group_pl_id => l_pl_id
659: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
660: ,p_pl_id => l_pl_id

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

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

Line 679: ben_cwb_audit_api.create_audit_entry

675: and (p_txn_old.attribute14 is not null))
676: or (p_txn_old.attribute14 <> l_txn_new.attribute14) ) then
677: --
678: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then
679: ben_cwb_audit_api.create_audit_entry
680: (p_group_per_in_ler_id => l_per_in_ler_id
681: ,p_group_pl_id => l_pl_id
682: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
683: ,p_pl_id => l_pl_id

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

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

Line 702: ben_cwb_audit_api.create_audit_entry

698: and (p_txn_old.attribute15 is not null))
699: or (p_txn_old.attribute15 <> l_txn_new.attribute15) ) then
700: --
701: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then
702: ben_cwb_audit_api.create_audit_entry
703: (p_group_per_in_ler_id => l_per_in_ler_id
704: ,p_group_pl_id => l_pl_id
705: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
706: ,p_pl_id => l_pl_id

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

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

Line 725: ben_cwb_audit_api.create_audit_entry

721: and (p_txn_old.attribute16 is not null))
722: or (p_txn_old.attribute16 <> l_txn_new.attribute16) ) then
723: --
724: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then
725: ben_cwb_audit_api.create_audit_entry
726: (p_group_per_in_ler_id => l_per_in_ler_id
727: ,p_group_pl_id => l_pl_id
728: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
729: ,p_pl_id => l_pl_id

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

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

Line 748: ben_cwb_audit_api.create_audit_entry

744: and (p_txn_old.attribute17 is not null))
745: or (p_txn_old.attribute17 <> l_txn_new.attribute17) ) then
746: --
747: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then
748: ben_cwb_audit_api.create_audit_entry
749: (p_group_per_in_ler_id => l_per_in_ler_id
750: ,p_group_pl_id => l_pl_id
751: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
752: ,p_pl_id => l_pl_id

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

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

Line 771: ben_cwb_audit_api.create_audit_entry

767: and (p_txn_old.attribute18 is not null))
768: or (p_txn_old.attribute18 <> l_txn_new.attribute18) ) then
769: --
770: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then
771: ben_cwb_audit_api.create_audit_entry
772: (p_group_per_in_ler_id => l_per_in_ler_id
773: ,p_group_pl_id => l_pl_id
774: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
775: ,p_pl_id => l_pl_id

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

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

Line 794: ben_cwb_audit_api.create_audit_entry

790: and (p_txn_old.attribute19 is not null))
791: or (p_txn_old.attribute19 <> l_txn_new.attribute19) ) then
792: --
793: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then
794: ben_cwb_audit_api.create_audit_entry
795: (p_group_per_in_ler_id => l_per_in_ler_id
796: ,p_group_pl_id => l_pl_id
797: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
798: ,p_pl_id => l_pl_id

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

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

Line 817: ben_cwb_audit_api.create_audit_entry

813: and (p_txn_old.attribute20 is not null))
814: or (p_txn_old.attribute20 <> l_txn_new.attribute20) ) then
815: --
816: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then
817: ben_cwb_audit_api.create_audit_entry
818: (p_group_per_in_ler_id => l_per_in_ler_id
819: ,p_group_pl_id => l_pl_id
820: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
821: ,p_pl_id => l_pl_id

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

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

Line 840: ben_cwb_audit_api.create_audit_entry

836: and (p_txn_old.attribute21 is not null))
837: or (p_txn_old.attribute21 <> l_txn_new.attribute21) ) then
838: --
839: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then
840: ben_cwb_audit_api.create_audit_entry
841: (p_group_per_in_ler_id => l_per_in_ler_id
842: ,p_group_pl_id => l_pl_id
843: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
844: ,p_pl_id => l_pl_id

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

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

Line 863: ben_cwb_audit_api.create_audit_entry

859: and (p_txn_old.attribute22 is not null))
860: or (p_txn_old.attribute22 <> l_txn_new.attribute22) ) then
861: --
862: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then
863: ben_cwb_audit_api.create_audit_entry
864: (p_group_per_in_ler_id => l_per_in_ler_id
865: ,p_group_pl_id => l_pl_id
866: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
867: ,p_pl_id => l_pl_id

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

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

Line 886: ben_cwb_audit_api.create_audit_entry

882: and (p_txn_old.attribute23 is not null))
883: or (p_txn_old.attribute23 <> l_txn_new.attribute23) ) then
884: --
885: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then
886: ben_cwb_audit_api.create_audit_entry
887: (p_group_per_in_ler_id => l_per_in_ler_id
888: ,p_group_pl_id => l_pl_id
889: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
890: ,p_pl_id => l_pl_id

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

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

Line 909: ben_cwb_audit_api.create_audit_entry

905: and (p_txn_old.attribute24 is not null))
906: or (p_txn_old.attribute24 <> l_txn_new.attribute24) ) then
907: --
908: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then
909: ben_cwb_audit_api.create_audit_entry
910: (p_group_per_in_ler_id => l_per_in_ler_id
911: ,p_group_pl_id => l_pl_id
912: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
913: ,p_pl_id => l_pl_id

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

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

Line 932: ben_cwb_audit_api.create_audit_entry

928: and (p_txn_old.attribute25 is not null))
929: or (p_txn_old.attribute25 <> l_txn_new.attribute25) ) then
930: --
931: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then
932: ben_cwb_audit_api.create_audit_entry
933: (p_group_per_in_ler_id => l_per_in_ler_id
934: ,p_group_pl_id => l_pl_id
935: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
936: ,p_pl_id => l_pl_id

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

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

Line 955: ben_cwb_audit_api.create_audit_entry

951: and (p_txn_old.attribute26 is not null))
952: or (p_txn_old.attribute26 <> l_txn_new.attribute26) ) then
953: --
954: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then
955: ben_cwb_audit_api.create_audit_entry
956: (p_group_per_in_ler_id => l_per_in_ler_id
957: ,p_group_pl_id => l_pl_id
958: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
959: ,p_pl_id => l_pl_id

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

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

Line 978: ben_cwb_audit_api.create_audit_entry

974: and (p_txn_old.attribute27 is not null))
975: or (p_txn_old.attribute27 <> l_txn_new.attribute27) ) then
976: --
977: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then
978: ben_cwb_audit_api.create_audit_entry
979: (p_group_per_in_ler_id => l_per_in_ler_id
980: ,p_group_pl_id => l_pl_id
981: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
982: ,p_pl_id => l_pl_id

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

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

Line 1001: ben_cwb_audit_api.create_audit_entry

997: and (p_txn_old.attribute28 is not null))
998: or (p_txn_old.attribute28 <> l_txn_new.attribute28) ) then
999: --
1000: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then
1001: ben_cwb_audit_api.create_audit_entry
1002: (p_group_per_in_ler_id => l_per_in_ler_id
1003: ,p_group_pl_id => l_pl_id
1004: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1005: ,p_pl_id => l_pl_id

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

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

Line 1024: ben_cwb_audit_api.create_audit_entry

1020: and (p_txn_old.attribute29 is not null))
1021: or (p_txn_old.attribute29 <> l_txn_new.attribute29) ) then
1022: --
1023: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then
1024: ben_cwb_audit_api.create_audit_entry
1025: (p_group_per_in_ler_id => l_per_in_ler_id
1026: ,p_group_pl_id => l_pl_id
1027: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1028: ,p_pl_id => l_pl_id

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

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

Line 1047: ben_cwb_audit_api.create_audit_entry

1043: and (p_txn_old.attribute30 is not null))
1044: or (p_txn_old.attribute30 <> l_txn_new.attribute30) ) then
1045: --
1046: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then
1047: ben_cwb_audit_api.create_audit_entry
1048: (p_group_per_in_ler_id => l_per_in_ler_id
1049: ,p_group_pl_id => l_pl_id
1050: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1051: ,p_pl_id => l_pl_id

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

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

Line 1070: ben_cwb_audit_api.create_audit_entry

1066: and (p_txn_old.attribute31 is not null))
1067: or (p_txn_old.attribute31 <> l_txn_new.attribute31) ) then
1068: --
1069: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then
1070: ben_cwb_audit_api.create_audit_entry
1071: (p_group_per_in_ler_id => l_per_in_ler_id
1072: ,p_group_pl_id => l_pl_id
1073: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1074: ,p_pl_id => l_pl_id

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

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

Line 1093: ben_cwb_audit_api.create_audit_entry

1089: and (p_txn_old.attribute32 is not null))
1090: or (p_txn_old.attribute32 <> l_txn_new.attribute32) ) then
1091: --
1092: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then
1093: ben_cwb_audit_api.create_audit_entry
1094: (p_group_per_in_ler_id => l_per_in_ler_id
1095: ,p_group_pl_id => l_pl_id
1096: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1097: ,p_pl_id => l_pl_id

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

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

Line 1116: ben_cwb_audit_api.create_audit_entry

1112: and (p_txn_old.attribute33 is not null))
1113: or (p_txn_old.attribute33 <> l_txn_new.attribute33) ) then
1114: --
1115: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then
1116: ben_cwb_audit_api.create_audit_entry
1117: (p_group_per_in_ler_id => l_per_in_ler_id
1118: ,p_group_pl_id => l_pl_id
1119: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1120: ,p_pl_id => l_pl_id

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

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

Line 1139: ben_cwb_audit_api.create_audit_entry

1135: and (p_txn_old.attribute34 is not null))
1136: or (p_txn_old.attribute34 <> l_txn_new.attribute34) ) then
1137: --
1138: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then
1139: ben_cwb_audit_api.create_audit_entry
1140: (p_group_per_in_ler_id => l_per_in_ler_id
1141: ,p_group_pl_id => l_pl_id
1142: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1143: ,p_pl_id => l_pl_id

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

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

Line 1162: ben_cwb_audit_api.create_audit_entry

1158: and (p_txn_old.attribute35 is not null))
1159: or (p_txn_old.attribute35 <> l_txn_new.attribute35) ) then
1160: --
1161: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then
1162: ben_cwb_audit_api.create_audit_entry
1163: (p_group_per_in_ler_id => l_per_in_ler_id
1164: ,p_group_pl_id => l_pl_id
1165: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1166: ,p_pl_id => l_pl_id

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

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

Line 1185: ben_cwb_audit_api.create_audit_entry

1181: and (p_txn_old.attribute36 is not null))
1182: or (p_txn_old.attribute36 <> l_txn_new.attribute36) ) then
1183: --
1184: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then
1185: ben_cwb_audit_api.create_audit_entry
1186: (p_group_per_in_ler_id => l_per_in_ler_id
1187: ,p_group_pl_id => l_pl_id
1188: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1189: ,p_pl_id => l_pl_id

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

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

Line 1208: ben_cwb_audit_api.create_audit_entry

1204: and (p_txn_old.attribute37 is not null))
1205: or (p_txn_old.attribute37 <> l_txn_new.attribute37) ) then
1206: --
1207: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then
1208: ben_cwb_audit_api.create_audit_entry
1209: (p_group_per_in_ler_id => l_per_in_ler_id
1210: ,p_group_pl_id => l_pl_id
1211: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1212: ,p_pl_id => l_pl_id

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

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

Line 1231: ben_cwb_audit_api.create_audit_entry

1227: and (p_txn_old.attribute38 is not null))
1228: or (p_txn_old.attribute38 <> l_txn_new.attribute38) ) then
1229: --
1230: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then
1231: ben_cwb_audit_api.create_audit_entry
1232: (p_group_per_in_ler_id => l_per_in_ler_id
1233: ,p_group_pl_id => l_pl_id
1234: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1235: ,p_pl_id => l_pl_id

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

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

Line 1254: ben_cwb_audit_api.create_audit_entry

1250: and (p_txn_old.attribute39 is not null))
1251: or (p_txn_old.attribute39 <> l_txn_new.attribute39) ) then
1252: --
1253: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then
1254: ben_cwb_audit_api.create_audit_entry
1255: (p_group_per_in_ler_id => l_per_in_ler_id
1256: ,p_group_pl_id => l_pl_id
1257: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1258: ,p_pl_id => l_pl_id

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

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

Line 1277: ben_cwb_audit_api.create_audit_entry

1273: and (p_txn_old.attribute40 is not null))
1274: or (p_txn_old.attribute40 <> l_txn_new.attribute40) ) then
1275: --
1276: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then
1277: ben_cwb_audit_api.create_audit_entry
1278: (p_group_per_in_ler_id => l_per_in_ler_id
1279: ,p_group_pl_id => l_pl_id
1280: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1281: ,p_pl_id => l_pl_id

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

1299: fetch c_job into l_cd_meaning_old;
1300: close c_job;
1301: --
1302: --
1303: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
1304: ben_cwb_audit_api.create_audit_entry
1305: (p_group_per_in_ler_id => l_per_in_ler_id
1306: ,p_group_pl_id => l_pl_id
1307: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1304: ben_cwb_audit_api.create_audit_entry

1300: close c_job;
1301: --
1302: --
1303: if(ben_cwb_audit_api.return_lookup_validity('JO')=true) then
1304: ben_cwb_audit_api.create_audit_entry
1305: (p_group_per_in_ler_id => l_per_in_ler_id
1306: ,p_group_pl_id => l_pl_id
1307: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1308: ,p_pl_id => l_pl_id

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

1323: fetch c_lookup into l_cd_meaning_old;
1324: close c_lookup;
1325: --
1326: --
1327: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
1328: ben_cwb_audit_api.create_audit_entry
1329: (p_group_per_in_ler_id => l_per_in_ler_id
1330: ,p_group_pl_id => l_pl_id
1331: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1328: ben_cwb_audit_api.create_audit_entry

1324: close c_lookup;
1325: --
1326: --
1327: if(ben_cwb_audit_api.return_lookup_validity('CR')=true) then
1328: ben_cwb_audit_api.create_audit_entry
1329: (p_group_per_in_ler_id => l_per_in_ler_id
1330: ,p_group_pl_id => l_pl_id
1331: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1332: ,p_pl_id => l_pl_id

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

1349: close c_grade;
1350: --
1351: --
1352: --
1353: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
1354: ben_cwb_audit_api.create_audit_entry
1355: (p_group_per_in_ler_id => l_per_in_ler_id
1356: ,p_group_pl_id => l_pl_id
1357: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1354: ben_cwb_audit_api.create_audit_entry

1350: --
1351: --
1352: --
1353: if(ben_cwb_audit_api.return_lookup_validity('GR')=true) then
1354: ben_cwb_audit_api.create_audit_entry
1355: (p_group_per_in_ler_id => l_per_in_ler_id
1356: ,p_group_pl_id => l_pl_id
1357: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1358: ,p_pl_id => l_pl_id

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

1369: end if;
1370: --
1371: if(p_txn_old.attribute8 is not null) then
1372: --
1373: if(ben_cwb_audit_api.return_lookup_validity('AF')=true) then
1374: ben_cwb_audit_api.create_audit_entry
1375: (p_group_per_in_ler_id => l_per_in_ler_id
1376: ,p_group_pl_id => l_pl_id
1377: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1374: ben_cwb_audit_api.create_audit_entry

1370: --
1371: if(p_txn_old.attribute8 is not null) then
1372: --
1373: if(ben_cwb_audit_api.return_lookup_validity('AF')=true) then
1374: ben_cwb_audit_api.create_audit_entry
1375: (p_group_per_in_ler_id => l_per_in_ler_id
1376: ,p_group_pl_id => l_pl_id
1377: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1378: ,p_pl_id => l_pl_id

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

1394: close c_position;
1395: --
1396: --
1397: --
1398: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
1399: ben_cwb_audit_api.create_audit_entry
1400: (p_group_per_in_ler_id => l_per_in_ler_id
1401: ,p_group_pl_id => l_pl_id
1402: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1399: ben_cwb_audit_api.create_audit_entry

1395: --
1396: --
1397: --
1398: if(ben_cwb_audit_api.return_lookup_validity('PO')=true) then
1399: ben_cwb_audit_api.create_audit_entry
1400: (p_group_per_in_ler_id => l_per_in_ler_id
1401: ,p_group_pl_id => l_pl_id
1402: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1403: ,p_pl_id => l_pl_id

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

1413: end if;
1414: end if;
1415: if(p_txn_old.attribute11 is not null) then
1416: --
1417: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then
1418: ben_cwb_audit_api.create_audit_entry
1419: (p_group_per_in_ler_id => l_per_in_ler_id
1420: ,p_group_pl_id => l_pl_id
1421: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1418: ben_cwb_audit_api.create_audit_entry

1414: end if;
1415: if(p_txn_old.attribute11 is not null) then
1416: --
1417: if(ben_cwb_audit_api.return_lookup_validity('AF1')=true) then
1418: ben_cwb_audit_api.create_audit_entry
1419: (p_group_per_in_ler_id => l_per_in_ler_id
1420: ,p_group_pl_id => l_pl_id
1421: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1422: ,p_pl_id => l_pl_id

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

1432: end if;
1433: end if;
1434: if(p_txn_old.attribute12 is not null) then
1435: --
1436: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then
1437: ben_cwb_audit_api.create_audit_entry
1438: (p_group_per_in_ler_id => l_per_in_ler_id
1439: ,p_group_pl_id => l_pl_id
1440: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1437: ben_cwb_audit_api.create_audit_entry

1433: end if;
1434: if(p_txn_old.attribute12 is not null) then
1435: --
1436: if(ben_cwb_audit_api.return_lookup_validity('AF2')=true) then
1437: ben_cwb_audit_api.create_audit_entry
1438: (p_group_per_in_ler_id => l_per_in_ler_id
1439: ,p_group_pl_id => l_pl_id
1440: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1441: ,p_pl_id => l_pl_id

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

1451: end if;
1452: end if;
1453: if(p_txn_old.attribute13 is not null) then
1454: --
1455: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then
1456: ben_cwb_audit_api.create_audit_entry
1457: (p_group_per_in_ler_id => l_per_in_ler_id
1458: ,p_group_pl_id => l_pl_id
1459: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1456: ben_cwb_audit_api.create_audit_entry

1452: end if;
1453: if(p_txn_old.attribute13 is not null) then
1454: --
1455: if(ben_cwb_audit_api.return_lookup_validity('AF3')=true) then
1456: ben_cwb_audit_api.create_audit_entry
1457: (p_group_per_in_ler_id => l_per_in_ler_id
1458: ,p_group_pl_id => l_pl_id
1459: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1460: ,p_pl_id => l_pl_id

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

1470: end if;
1471: end if;
1472: if(p_txn_old.attribute14 is not null) then
1473: --
1474: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then
1475: ben_cwb_audit_api.create_audit_entry
1476: (p_group_per_in_ler_id => l_per_in_ler_id
1477: ,p_group_pl_id => l_pl_id
1478: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1475: ben_cwb_audit_api.create_audit_entry

1471: end if;
1472: if(p_txn_old.attribute14 is not null) then
1473: --
1474: if(ben_cwb_audit_api.return_lookup_validity('AF4')=true) then
1475: ben_cwb_audit_api.create_audit_entry
1476: (p_group_per_in_ler_id => l_per_in_ler_id
1477: ,p_group_pl_id => l_pl_id
1478: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1479: ,p_pl_id => l_pl_id

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

1489: end if;
1490: end if;
1491: if(p_txn_old.attribute15 is not null) then
1492: --
1493: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then
1494: ben_cwb_audit_api.create_audit_entry
1495: (p_group_per_in_ler_id => l_per_in_ler_id
1496: ,p_group_pl_id => l_pl_id
1497: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1494: ben_cwb_audit_api.create_audit_entry

1490: end if;
1491: if(p_txn_old.attribute15 is not null) then
1492: --
1493: if(ben_cwb_audit_api.return_lookup_validity('AF5')=true) then
1494: ben_cwb_audit_api.create_audit_entry
1495: (p_group_per_in_ler_id => l_per_in_ler_id
1496: ,p_group_pl_id => l_pl_id
1497: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1498: ,p_pl_id => l_pl_id

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

1508: end if;
1509: end if;
1510: if(p_txn_old.attribute16 is not null) then
1511: --
1512: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then
1513: ben_cwb_audit_api.create_audit_entry
1514: (p_group_per_in_ler_id => l_per_in_ler_id
1515: ,p_group_pl_id => l_pl_id
1516: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1513: ben_cwb_audit_api.create_audit_entry

1509: end if;
1510: if(p_txn_old.attribute16 is not null) then
1511: --
1512: if(ben_cwb_audit_api.return_lookup_validity('AF6')=true) then
1513: ben_cwb_audit_api.create_audit_entry
1514: (p_group_per_in_ler_id => l_per_in_ler_id
1515: ,p_group_pl_id => l_pl_id
1516: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1517: ,p_pl_id => l_pl_id

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

1527: end if;
1528: end if;
1529: if(p_txn_old.attribute17 is not null) then
1530: --
1531: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then
1532: ben_cwb_audit_api.create_audit_entry
1533: (p_group_per_in_ler_id => l_per_in_ler_id
1534: ,p_group_pl_id => l_pl_id
1535: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1532: ben_cwb_audit_api.create_audit_entry

1528: end if;
1529: if(p_txn_old.attribute17 is not null) then
1530: --
1531: if(ben_cwb_audit_api.return_lookup_validity('AF7')=true) then
1532: ben_cwb_audit_api.create_audit_entry
1533: (p_group_per_in_ler_id => l_per_in_ler_id
1534: ,p_group_pl_id => l_pl_id
1535: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1536: ,p_pl_id => l_pl_id

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

1546: end if;
1547: end if;
1548: if(p_txn_old.attribute18 is not null) then
1549: --
1550: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then
1551: ben_cwb_audit_api.create_audit_entry
1552: (p_group_per_in_ler_id => l_per_in_ler_id
1553: ,p_group_pl_id => l_pl_id
1554: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1551: ben_cwb_audit_api.create_audit_entry

1547: end if;
1548: if(p_txn_old.attribute18 is not null) then
1549: --
1550: if(ben_cwb_audit_api.return_lookup_validity('AF8')=true) then
1551: ben_cwb_audit_api.create_audit_entry
1552: (p_group_per_in_ler_id => l_per_in_ler_id
1553: ,p_group_pl_id => l_pl_id
1554: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1555: ,p_pl_id => l_pl_id

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

1565: end if;
1566: end if;
1567: if(p_txn_old.attribute19 is not null) then
1568: --
1569: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then
1570: ben_cwb_audit_api.create_audit_entry
1571: (p_group_per_in_ler_id => l_per_in_ler_id
1572: ,p_group_pl_id => l_pl_id
1573: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1570: ben_cwb_audit_api.create_audit_entry

1566: end if;
1567: if(p_txn_old.attribute19 is not null) then
1568: --
1569: if(ben_cwb_audit_api.return_lookup_validity('AF9')=true) then
1570: ben_cwb_audit_api.create_audit_entry
1571: (p_group_per_in_ler_id => l_per_in_ler_id
1572: ,p_group_pl_id => l_pl_id
1573: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1574: ,p_pl_id => l_pl_id

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

1584: end if;
1585: end if;
1586: if(p_txn_old.attribute20 is not null) then
1587: --
1588: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then
1589: ben_cwb_audit_api.create_audit_entry
1590: (p_group_per_in_ler_id => l_per_in_ler_id
1591: ,p_group_pl_id => l_pl_id
1592: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1589: ben_cwb_audit_api.create_audit_entry

1585: end if;
1586: if(p_txn_old.attribute20 is not null) then
1587: --
1588: if(ben_cwb_audit_api.return_lookup_validity('AF10')=true) then
1589: ben_cwb_audit_api.create_audit_entry
1590: (p_group_per_in_ler_id => l_per_in_ler_id
1591: ,p_group_pl_id => l_pl_id
1592: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1593: ,p_pl_id => l_pl_id

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

1603: end if;
1604: end if;
1605: if(p_txn_old.attribute21 is not null) then
1606: --
1607: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then
1608: ben_cwb_audit_api.create_audit_entry
1609: (p_group_per_in_ler_id => l_per_in_ler_id
1610: ,p_group_pl_id => l_pl_id
1611: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1608: ben_cwb_audit_api.create_audit_entry

1604: end if;
1605: if(p_txn_old.attribute21 is not null) then
1606: --
1607: if(ben_cwb_audit_api.return_lookup_validity('AF11')=true) then
1608: ben_cwb_audit_api.create_audit_entry
1609: (p_group_per_in_ler_id => l_per_in_ler_id
1610: ,p_group_pl_id => l_pl_id
1611: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1612: ,p_pl_id => l_pl_id

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

1622: end if;
1623: end if;
1624: if(p_txn_old.attribute22 is not null) then
1625: --
1626: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then
1627: ben_cwb_audit_api.create_audit_entry
1628: (p_group_per_in_ler_id => l_per_in_ler_id
1629: ,p_group_pl_id => l_pl_id
1630: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1627: ben_cwb_audit_api.create_audit_entry

1623: end if;
1624: if(p_txn_old.attribute22 is not null) then
1625: --
1626: if(ben_cwb_audit_api.return_lookup_validity('AF12')=true) then
1627: ben_cwb_audit_api.create_audit_entry
1628: (p_group_per_in_ler_id => l_per_in_ler_id
1629: ,p_group_pl_id => l_pl_id
1630: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1631: ,p_pl_id => l_pl_id

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

1641: end if;
1642: end if;
1643: if(p_txn_old.attribute23 is not null) then
1644: --
1645: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then
1646: ben_cwb_audit_api.create_audit_entry
1647: (p_group_per_in_ler_id => l_per_in_ler_id
1648: ,p_group_pl_id => l_pl_id
1649: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1646: ben_cwb_audit_api.create_audit_entry

1642: end if;
1643: if(p_txn_old.attribute23 is not null) then
1644: --
1645: if(ben_cwb_audit_api.return_lookup_validity('AF13')=true) then
1646: ben_cwb_audit_api.create_audit_entry
1647: (p_group_per_in_ler_id => l_per_in_ler_id
1648: ,p_group_pl_id => l_pl_id
1649: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1650: ,p_pl_id => l_pl_id

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

1660: end if;
1661: end if;
1662: if(p_txn_old.attribute24 is not null) then
1663: --
1664: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then
1665: ben_cwb_audit_api.create_audit_entry
1666: (p_group_per_in_ler_id => l_per_in_ler_id
1667: ,p_group_pl_id => l_pl_id
1668: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1665: ben_cwb_audit_api.create_audit_entry

1661: end if;
1662: if(p_txn_old.attribute24 is not null) then
1663: --
1664: if(ben_cwb_audit_api.return_lookup_validity('AF14')=true) then
1665: ben_cwb_audit_api.create_audit_entry
1666: (p_group_per_in_ler_id => l_per_in_ler_id
1667: ,p_group_pl_id => l_pl_id
1668: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1669: ,p_pl_id => l_pl_id

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

1679: end if;
1680: end if;
1681: if(p_txn_old.attribute25 is not null) then
1682: --
1683: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then
1684: ben_cwb_audit_api.create_audit_entry
1685: (p_group_per_in_ler_id => l_per_in_ler_id
1686: ,p_group_pl_id => l_pl_id
1687: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1684: ben_cwb_audit_api.create_audit_entry

1680: end if;
1681: if(p_txn_old.attribute25 is not null) then
1682: --
1683: if(ben_cwb_audit_api.return_lookup_validity('AF15')=true) then
1684: ben_cwb_audit_api.create_audit_entry
1685: (p_group_per_in_ler_id => l_per_in_ler_id
1686: ,p_group_pl_id => l_pl_id
1687: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1688: ,p_pl_id => l_pl_id

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

1698: end if;
1699: end if;
1700: if(p_txn_old.attribute26 is not null) then
1701: --
1702: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then
1703: ben_cwb_audit_api.create_audit_entry
1704: (p_group_per_in_ler_id => l_per_in_ler_id
1705: ,p_group_pl_id => l_pl_id
1706: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1703: ben_cwb_audit_api.create_audit_entry

1699: end if;
1700: if(p_txn_old.attribute26 is not null) then
1701: --
1702: if(ben_cwb_audit_api.return_lookup_validity('AF16')=true) then
1703: ben_cwb_audit_api.create_audit_entry
1704: (p_group_per_in_ler_id => l_per_in_ler_id
1705: ,p_group_pl_id => l_pl_id
1706: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1707: ,p_pl_id => l_pl_id

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

1717: end if;
1718: end if;
1719: if(p_txn_old.attribute27 is not null) then
1720: --
1721: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then
1722: ben_cwb_audit_api.create_audit_entry
1723: (p_group_per_in_ler_id => l_per_in_ler_id
1724: ,p_group_pl_id => l_pl_id
1725: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1722: ben_cwb_audit_api.create_audit_entry

1718: end if;
1719: if(p_txn_old.attribute27 is not null) then
1720: --
1721: if(ben_cwb_audit_api.return_lookup_validity('AF17')=true) then
1722: ben_cwb_audit_api.create_audit_entry
1723: (p_group_per_in_ler_id => l_per_in_ler_id
1724: ,p_group_pl_id => l_pl_id
1725: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1726: ,p_pl_id => l_pl_id

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

1736: end if;
1737: end if;
1738: if(p_txn_old.attribute28 is not null) then
1739: --
1740: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then
1741: ben_cwb_audit_api.create_audit_entry
1742: (p_group_per_in_ler_id => l_per_in_ler_id
1743: ,p_group_pl_id => l_pl_id
1744: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1741: ben_cwb_audit_api.create_audit_entry

1737: end if;
1738: if(p_txn_old.attribute28 is not null) then
1739: --
1740: if(ben_cwb_audit_api.return_lookup_validity('AF18')=true) then
1741: ben_cwb_audit_api.create_audit_entry
1742: (p_group_per_in_ler_id => l_per_in_ler_id
1743: ,p_group_pl_id => l_pl_id
1744: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1745: ,p_pl_id => l_pl_id

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

1755: end if;
1756: end if;
1757: if(p_txn_old.attribute29 is not null) then
1758: --
1759: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then
1760: ben_cwb_audit_api.create_audit_entry
1761: (p_group_per_in_ler_id => l_per_in_ler_id
1762: ,p_group_pl_id => l_pl_id
1763: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1760: ben_cwb_audit_api.create_audit_entry

1756: end if;
1757: if(p_txn_old.attribute29 is not null) then
1758: --
1759: if(ben_cwb_audit_api.return_lookup_validity('AF19')=true) then
1760: ben_cwb_audit_api.create_audit_entry
1761: (p_group_per_in_ler_id => l_per_in_ler_id
1762: ,p_group_pl_id => l_pl_id
1763: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1764: ,p_pl_id => l_pl_id

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

1774: end if;
1775: end if;
1776: if(p_txn_old.attribute30 is not null) then
1777: --
1778: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then
1779: ben_cwb_audit_api.create_audit_entry
1780: (p_group_per_in_ler_id => l_per_in_ler_id
1781: ,p_group_pl_id => l_pl_id
1782: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1779: ben_cwb_audit_api.create_audit_entry

1775: end if;
1776: if(p_txn_old.attribute30 is not null) then
1777: --
1778: if(ben_cwb_audit_api.return_lookup_validity('AF20')=true) then
1779: ben_cwb_audit_api.create_audit_entry
1780: (p_group_per_in_ler_id => l_per_in_ler_id
1781: ,p_group_pl_id => l_pl_id
1782: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1783: ,p_pl_id => l_pl_id

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

1793: end if;
1794: end if;
1795: if(p_txn_old.attribute31 is not null) then
1796: --
1797: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then
1798: ben_cwb_audit_api.create_audit_entry
1799: (p_group_per_in_ler_id => l_per_in_ler_id
1800: ,p_group_pl_id => l_pl_id
1801: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1798: ben_cwb_audit_api.create_audit_entry

1794: end if;
1795: if(p_txn_old.attribute31 is not null) then
1796: --
1797: if(ben_cwb_audit_api.return_lookup_validity('AF21')=true) then
1798: ben_cwb_audit_api.create_audit_entry
1799: (p_group_per_in_ler_id => l_per_in_ler_id
1800: ,p_group_pl_id => l_pl_id
1801: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1802: ,p_pl_id => l_pl_id

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

1812: end if;
1813: end if;
1814: if(p_txn_old.attribute32 is not null) then
1815: --
1816: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then
1817: ben_cwb_audit_api.create_audit_entry
1818: (p_group_per_in_ler_id => l_per_in_ler_id
1819: ,p_group_pl_id => l_pl_id
1820: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1817: ben_cwb_audit_api.create_audit_entry

1813: end if;
1814: if(p_txn_old.attribute32 is not null) then
1815: --
1816: if(ben_cwb_audit_api.return_lookup_validity('AF22')=true) then
1817: ben_cwb_audit_api.create_audit_entry
1818: (p_group_per_in_ler_id => l_per_in_ler_id
1819: ,p_group_pl_id => l_pl_id
1820: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1821: ,p_pl_id => l_pl_id

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

1831: end if;
1832: end if;
1833: if(p_txn_old.attribute33 is not null) then
1834: --
1835: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then
1836: ben_cwb_audit_api.create_audit_entry
1837: (p_group_per_in_ler_id => l_per_in_ler_id
1838: ,p_group_pl_id => l_pl_id
1839: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1836: ben_cwb_audit_api.create_audit_entry

1832: end if;
1833: if(p_txn_old.attribute33 is not null) then
1834: --
1835: if(ben_cwb_audit_api.return_lookup_validity('AF23')=true) then
1836: ben_cwb_audit_api.create_audit_entry
1837: (p_group_per_in_ler_id => l_per_in_ler_id
1838: ,p_group_pl_id => l_pl_id
1839: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1840: ,p_pl_id => l_pl_id

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

1850: end if;
1851: end if;
1852: if(p_txn_old.attribute34 is not null) then
1853: --
1854: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then
1855: ben_cwb_audit_api.create_audit_entry
1856: (p_group_per_in_ler_id => l_per_in_ler_id
1857: ,p_group_pl_id => l_pl_id
1858: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1855: ben_cwb_audit_api.create_audit_entry

1851: end if;
1852: if(p_txn_old.attribute34 is not null) then
1853: --
1854: if(ben_cwb_audit_api.return_lookup_validity('AF24')=true) then
1855: ben_cwb_audit_api.create_audit_entry
1856: (p_group_per_in_ler_id => l_per_in_ler_id
1857: ,p_group_pl_id => l_pl_id
1858: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1859: ,p_pl_id => l_pl_id

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

1869: end if;
1870: end if;
1871: if(p_txn_old.attribute35 is not null) then
1872: --
1873: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then
1874: ben_cwb_audit_api.create_audit_entry
1875: (p_group_per_in_ler_id => l_per_in_ler_id
1876: ,p_group_pl_id => l_pl_id
1877: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1874: ben_cwb_audit_api.create_audit_entry

1870: end if;
1871: if(p_txn_old.attribute35 is not null) then
1872: --
1873: if(ben_cwb_audit_api.return_lookup_validity('AF25')=true) then
1874: ben_cwb_audit_api.create_audit_entry
1875: (p_group_per_in_ler_id => l_per_in_ler_id
1876: ,p_group_pl_id => l_pl_id
1877: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1878: ,p_pl_id => l_pl_id

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

1888: end if;
1889: end if;
1890: if(p_txn_old.attribute36 is not null) then
1891: --
1892: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then
1893: ben_cwb_audit_api.create_audit_entry
1894: (p_group_per_in_ler_id => l_per_in_ler_id
1895: ,p_group_pl_id => l_pl_id
1896: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1893: ben_cwb_audit_api.create_audit_entry

1889: end if;
1890: if(p_txn_old.attribute36 is not null) then
1891: --
1892: if(ben_cwb_audit_api.return_lookup_validity('AF26')=true) then
1893: ben_cwb_audit_api.create_audit_entry
1894: (p_group_per_in_ler_id => l_per_in_ler_id
1895: ,p_group_pl_id => l_pl_id
1896: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1897: ,p_pl_id => l_pl_id

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

1907: end if;
1908: end if;
1909: if(p_txn_old.attribute37 is not null) then
1910: --
1911: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then
1912: ben_cwb_audit_api.create_audit_entry
1913: (p_group_per_in_ler_id => l_per_in_ler_id
1914: ,p_group_pl_id => l_pl_id
1915: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1912: ben_cwb_audit_api.create_audit_entry

1908: end if;
1909: if(p_txn_old.attribute37 is not null) then
1910: --
1911: if(ben_cwb_audit_api.return_lookup_validity('AF27')=true) then
1912: ben_cwb_audit_api.create_audit_entry
1913: (p_group_per_in_ler_id => l_per_in_ler_id
1914: ,p_group_pl_id => l_pl_id
1915: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1916: ,p_pl_id => l_pl_id

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

1926: end if;
1927: end if;
1928: if(p_txn_old.attribute38 is not null) then
1929: --
1930: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then
1931: ben_cwb_audit_api.create_audit_entry
1932: (p_group_per_in_ler_id => l_per_in_ler_id
1933: ,p_group_pl_id => l_pl_id
1934: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1931: ben_cwb_audit_api.create_audit_entry

1927: end if;
1928: if(p_txn_old.attribute38 is not null) then
1929: --
1930: if(ben_cwb_audit_api.return_lookup_validity('AF28')=true) then
1931: ben_cwb_audit_api.create_audit_entry
1932: (p_group_per_in_ler_id => l_per_in_ler_id
1933: ,p_group_pl_id => l_pl_id
1934: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1935: ,p_pl_id => l_pl_id

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

1945: end if;
1946: end if;
1947: if(p_txn_old.attribute39 is not null) then
1948: --
1949: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then
1950: ben_cwb_audit_api.create_audit_entry
1951: (p_group_per_in_ler_id => l_per_in_ler_id
1952: ,p_group_pl_id => l_pl_id
1953: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1950: ben_cwb_audit_api.create_audit_entry

1946: end if;
1947: if(p_txn_old.attribute39 is not null) then
1948: --
1949: if(ben_cwb_audit_api.return_lookup_validity('AF29')=true) then
1950: ben_cwb_audit_api.create_audit_entry
1951: (p_group_per_in_ler_id => l_per_in_ler_id
1952: ,p_group_pl_id => l_pl_id
1953: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1954: ,p_pl_id => l_pl_id

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

1964: end if;
1965: end if;
1966: if(p_txn_old.attribute40 is not null) then
1967: --
1968: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then
1969: ben_cwb_audit_api.create_audit_entry
1970: (p_group_per_in_ler_id => l_per_in_ler_id
1971: ,p_group_pl_id => l_pl_id
1972: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 1969: ben_cwb_audit_api.create_audit_entry

1965: end if;
1966: if(p_txn_old.attribute40 is not null) then
1967: --
1968: if(ben_cwb_audit_api.return_lookup_validity('AF30')=true) then
1969: ben_cwb_audit_api.create_audit_entry
1970: (p_group_per_in_ler_id => l_per_in_ler_id
1971: ,p_group_pl_id => l_pl_id
1972: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1973: ,p_pl_id => l_pl_id