55: is
56: --
57: l_proc varchar2(1000) := 'adjust_validation';
58: --
59: l_adjustment_counts ben_efc_adjustments.g_adjustment_counts;
60: --
61: l_bftid_va benutils.g_number_table := benutils.g_number_table();
62: l_bftprdt_va benutils.g_date_table := benutils.g_date_table();
63: l_bftmdcd_va benutils.g_v2_30_table := benutils.g_v2_30_table();
479: if p_ent_scode is null
480: or p_ent_scode = 'PEP'
481: then
482: --
483: ben_efc_adjustments.pep_adjustments
484: (p_validate => FALSE
485: ,p_worker_id => p_worker_id
486: ,p_action_id => l_action_id
487: ,p_total_workers => p_total_workers
508: ,p_disp_private => p_disp_private
509: ,p_disp_succeeds => p_disp_succeeds
510: ,p_disp_exclusions => p_disp_exclusions
511: --
512: ,p_rcoerr_val_set => ben_efc_adjustments.g_pep_rcoerr_val_set
513: ,p_failed_adj_val_set => ben_efc_adjustments.g_pep_failed_adj_val_set
514: ,p_fatal_error_val_set => ben_efc_adjustments.g_pep_fatal_error_val_set
515: ,p_success_val_set => ben_efc_adjustments.g_pep_success_adj_val_set
516: );
509: ,p_disp_succeeds => p_disp_succeeds
510: ,p_disp_exclusions => p_disp_exclusions
511: --
512: ,p_rcoerr_val_set => ben_efc_adjustments.g_pep_rcoerr_val_set
513: ,p_failed_adj_val_set => ben_efc_adjustments.g_pep_failed_adj_val_set
514: ,p_fatal_error_val_set => ben_efc_adjustments.g_pep_fatal_error_val_set
515: ,p_success_val_set => ben_efc_adjustments.g_pep_success_adj_val_set
516: );
517: --
510: ,p_disp_exclusions => p_disp_exclusions
511: --
512: ,p_rcoerr_val_set => ben_efc_adjustments.g_pep_rcoerr_val_set
513: ,p_failed_adj_val_set => ben_efc_adjustments.g_pep_failed_adj_val_set
514: ,p_fatal_error_val_set => ben_efc_adjustments.g_pep_fatal_error_val_set
515: ,p_success_val_set => ben_efc_adjustments.g_pep_success_adj_val_set
516: );
517: --
518: end if;
511: --
512: ,p_rcoerr_val_set => ben_efc_adjustments.g_pep_rcoerr_val_set
513: ,p_failed_adj_val_set => ben_efc_adjustments.g_pep_failed_adj_val_set
514: ,p_fatal_error_val_set => ben_efc_adjustments.g_pep_fatal_error_val_set
515: ,p_success_val_set => ben_efc_adjustments.g_pep_success_adj_val_set
516: );
517: --
518: end if;
519: --
522: if p_ent_scode is null
523: or p_ent_scode = 'EPO'
524: then
525: --
526: ben_efc_adjustments.epo_adjustments
527: (p_validate => FALSE
528: ,p_worker_id => p_worker_id
529: ,p_action_id => l_action_id
530: ,p_total_workers => p_total_workers
551: ,p_disp_private => p_disp_private
552: ,p_disp_succeeds => p_disp_succeeds
553: ,p_disp_exclusions => p_disp_exclusions
554: --
555: ,p_rcoerr_val_set => ben_efc_adjustments.g_epo_rcoerr_val_set
556: ,p_failed_adj_val_set => ben_efc_adjustments.g_epo_failed_adj_val_set
557: ,p_fatal_error_val_set => ben_efc_adjustments.g_epo_fatal_error_val_set
558: ,p_success_val_set => ben_efc_adjustments.g_epo_success_adj_val_set
559: );
552: ,p_disp_succeeds => p_disp_succeeds
553: ,p_disp_exclusions => p_disp_exclusions
554: --
555: ,p_rcoerr_val_set => ben_efc_adjustments.g_epo_rcoerr_val_set
556: ,p_failed_adj_val_set => ben_efc_adjustments.g_epo_failed_adj_val_set
557: ,p_fatal_error_val_set => ben_efc_adjustments.g_epo_fatal_error_val_set
558: ,p_success_val_set => ben_efc_adjustments.g_epo_success_adj_val_set
559: );
560: --
553: ,p_disp_exclusions => p_disp_exclusions
554: --
555: ,p_rcoerr_val_set => ben_efc_adjustments.g_epo_rcoerr_val_set
556: ,p_failed_adj_val_set => ben_efc_adjustments.g_epo_failed_adj_val_set
557: ,p_fatal_error_val_set => ben_efc_adjustments.g_epo_fatal_error_val_set
558: ,p_success_val_set => ben_efc_adjustments.g_epo_success_adj_val_set
559: );
560: --
561: end if;
554: --
555: ,p_rcoerr_val_set => ben_efc_adjustments.g_epo_rcoerr_val_set
556: ,p_failed_adj_val_set => ben_efc_adjustments.g_epo_failed_adj_val_set
557: ,p_fatal_error_val_set => ben_efc_adjustments.g_epo_fatal_error_val_set
558: ,p_success_val_set => ben_efc_adjustments.g_epo_success_adj_val_set
559: );
560: --
561: end if;
562: --
565: if p_ent_scode is null
566: or p_ent_scode = 'ENB'
567: then
568: --
569: ben_efc_adjustments.enb_adjustments
570: (p_validate => FALSE
571: ,p_worker_id => p_worker_id
572: ,p_action_id => l_action_id
573: ,p_total_workers => p_total_workers
594: ,p_disp_private => p_disp_private
595: ,p_disp_succeeds => p_disp_succeeds
596: ,p_disp_exclusions => p_disp_exclusions
597: --
598: ,p_rcoerr_val_set => ben_efc_adjustments.g_enb_rcoerr_val_set
599: ,p_failed_adj_val_set => ben_efc_adjustments.g_enb_failed_adj_val_set
600: ,p_fatal_error_val_set => ben_efc_adjustments.g_enb_fatal_error_val_set
601: ,p_success_val_set => ben_efc_adjustments.g_enb_success_adj_val_set
602: );
595: ,p_disp_succeeds => p_disp_succeeds
596: ,p_disp_exclusions => p_disp_exclusions
597: --
598: ,p_rcoerr_val_set => ben_efc_adjustments.g_enb_rcoerr_val_set
599: ,p_failed_adj_val_set => ben_efc_adjustments.g_enb_failed_adj_val_set
600: ,p_fatal_error_val_set => ben_efc_adjustments.g_enb_fatal_error_val_set
601: ,p_success_val_set => ben_efc_adjustments.g_enb_success_adj_val_set
602: );
603: --
596: ,p_disp_exclusions => p_disp_exclusions
597: --
598: ,p_rcoerr_val_set => ben_efc_adjustments.g_enb_rcoerr_val_set
599: ,p_failed_adj_val_set => ben_efc_adjustments.g_enb_failed_adj_val_set
600: ,p_fatal_error_val_set => ben_efc_adjustments.g_enb_fatal_error_val_set
601: ,p_success_val_set => ben_efc_adjustments.g_enb_success_adj_val_set
602: );
603: --
604: end if;
597: --
598: ,p_rcoerr_val_set => ben_efc_adjustments.g_enb_rcoerr_val_set
599: ,p_failed_adj_val_set => ben_efc_adjustments.g_enb_failed_adj_val_set
600: ,p_fatal_error_val_set => ben_efc_adjustments.g_enb_fatal_error_val_set
601: ,p_success_val_set => ben_efc_adjustments.g_enb_success_adj_val_set
602: );
603: --
604: end if;
605: --
612: if p_ent_scode is null
613: or p_ent_scode = 'EPR'
614: then
615: --
616: ben_efc_adjustments.epr_adjustments
617: (p_validate => FALSE
618: ,p_worker_id => p_worker_id
619: ,p_action_id => l_action_id
620: ,p_total_workers => p_total_workers
641: ,p_disp_private => p_disp_private
642: ,p_disp_succeeds => p_disp_succeeds
643: ,p_disp_exclusions => p_disp_exclusions
644: --
645: ,p_rcoerr_val_set => ben_efc_adjustments.g_epr_rcoerr_val_set
646: ,p_failed_adj_val_set => ben_efc_adjustments.g_epr_failed_adj_val_set
647: ,p_fatal_error_val_set => ben_efc_adjustments.g_epr_fatal_error_val_set
648: ,p_success_val_set => ben_efc_adjustments.g_epr_success_adj_val_set
649: );
642: ,p_disp_succeeds => p_disp_succeeds
643: ,p_disp_exclusions => p_disp_exclusions
644: --
645: ,p_rcoerr_val_set => ben_efc_adjustments.g_epr_rcoerr_val_set
646: ,p_failed_adj_val_set => ben_efc_adjustments.g_epr_failed_adj_val_set
647: ,p_fatal_error_val_set => ben_efc_adjustments.g_epr_fatal_error_val_set
648: ,p_success_val_set => ben_efc_adjustments.g_epr_success_adj_val_set
649: );
650: --
643: ,p_disp_exclusions => p_disp_exclusions
644: --
645: ,p_rcoerr_val_set => ben_efc_adjustments.g_epr_rcoerr_val_set
646: ,p_failed_adj_val_set => ben_efc_adjustments.g_epr_failed_adj_val_set
647: ,p_fatal_error_val_set => ben_efc_adjustments.g_epr_fatal_error_val_set
648: ,p_success_val_set => ben_efc_adjustments.g_epr_success_adj_val_set
649: );
650: --
651: end if;
644: --
645: ,p_rcoerr_val_set => ben_efc_adjustments.g_epr_rcoerr_val_set
646: ,p_failed_adj_val_set => ben_efc_adjustments.g_epr_failed_adj_val_set
647: ,p_fatal_error_val_set => ben_efc_adjustments.g_epr_fatal_error_val_set
648: ,p_success_val_set => ben_efc_adjustments.g_epr_success_adj_val_set
649: );
650: --
651: end if;
652: --
659: if p_ent_scode is null
660: or p_ent_scode = 'ECR'
661: then
662: --
663: ben_efc_adjustments.ecr_adjustments
664: (p_validate => FALSE
665: ,p_worker_id => p_worker_id
666: ,p_action_id => l_action_id
667: ,p_total_workers => p_total_workers
688: ,p_disp_private => p_disp_private
689: ,p_disp_succeeds => p_disp_succeeds
690: ,p_disp_exclusions => p_disp_exclusions
691: --
692: ,p_rcoerr_val_set => ben_efc_adjustments.g_ecr_rcoerr_val_set
693: ,p_failed_adj_val_set => ben_efc_adjustments.g_ecr_failed_adj_val_set
694: ,p_fatal_error_val_set => ben_efc_adjustments.g_ecr_fatal_error_val_set
695: ,p_success_val_set => ben_efc_adjustments.g_ecr_success_adj_val_set
696: );
689: ,p_disp_succeeds => p_disp_succeeds
690: ,p_disp_exclusions => p_disp_exclusions
691: --
692: ,p_rcoerr_val_set => ben_efc_adjustments.g_ecr_rcoerr_val_set
693: ,p_failed_adj_val_set => ben_efc_adjustments.g_ecr_failed_adj_val_set
694: ,p_fatal_error_val_set => ben_efc_adjustments.g_ecr_fatal_error_val_set
695: ,p_success_val_set => ben_efc_adjustments.g_ecr_success_adj_val_set
696: );
697: --
690: ,p_disp_exclusions => p_disp_exclusions
691: --
692: ,p_rcoerr_val_set => ben_efc_adjustments.g_ecr_rcoerr_val_set
693: ,p_failed_adj_val_set => ben_efc_adjustments.g_ecr_failed_adj_val_set
694: ,p_fatal_error_val_set => ben_efc_adjustments.g_ecr_fatal_error_val_set
695: ,p_success_val_set => ben_efc_adjustments.g_ecr_success_adj_val_set
696: );
697: --
698: end if;
691: --
692: ,p_rcoerr_val_set => ben_efc_adjustments.g_ecr_rcoerr_val_set
693: ,p_failed_adj_val_set => ben_efc_adjustments.g_ecr_failed_adj_val_set
694: ,p_fatal_error_val_set => ben_efc_adjustments.g_ecr_fatal_error_val_set
695: ,p_success_val_set => ben_efc_adjustments.g_ecr_success_adj_val_set
696: );
697: --
698: end if;
699: --
706: if p_ent_scode is null
707: or p_ent_scode = 'PRV'
708: then
709: --
710: ben_efc_adjustments1.prv_adjustments
711: (p_validate => FALSE
712: ,p_worker_id => p_worker_id
713: ,p_action_id => l_action_id
714: ,p_total_workers => p_total_workers
735: ,p_disp_private => p_disp_private
736: ,p_disp_succeeds => p_disp_succeeds
737: ,p_disp_exclusions => p_disp_exclusions
738: --
739: ,p_rcoerr_val_set => ben_efc_adjustments.g_prv_rcoerr_val_set
740: ,p_failed_adj_val_set => ben_efc_adjustments.g_prv_failed_adj_val_set
741: ,p_fatal_error_val_set => ben_efc_adjustments.g_prv_fatal_error_val_set
742: ,p_success_val_set => ben_efc_adjustments.g_prv_success_adj_val_set
743: );
736: ,p_disp_succeeds => p_disp_succeeds
737: ,p_disp_exclusions => p_disp_exclusions
738: --
739: ,p_rcoerr_val_set => ben_efc_adjustments.g_prv_rcoerr_val_set
740: ,p_failed_adj_val_set => ben_efc_adjustments.g_prv_failed_adj_val_set
741: ,p_fatal_error_val_set => ben_efc_adjustments.g_prv_fatal_error_val_set
742: ,p_success_val_set => ben_efc_adjustments.g_prv_success_adj_val_set
743: );
744: --
737: ,p_disp_exclusions => p_disp_exclusions
738: --
739: ,p_rcoerr_val_set => ben_efc_adjustments.g_prv_rcoerr_val_set
740: ,p_failed_adj_val_set => ben_efc_adjustments.g_prv_failed_adj_val_set
741: ,p_fatal_error_val_set => ben_efc_adjustments.g_prv_fatal_error_val_set
742: ,p_success_val_set => ben_efc_adjustments.g_prv_success_adj_val_set
743: );
744: --
745: end if;
738: --
739: ,p_rcoerr_val_set => ben_efc_adjustments.g_prv_rcoerr_val_set
740: ,p_failed_adj_val_set => ben_efc_adjustments.g_prv_failed_adj_val_set
741: ,p_fatal_error_val_set => ben_efc_adjustments.g_prv_fatal_error_val_set
742: ,p_success_val_set => ben_efc_adjustments.g_prv_success_adj_val_set
743: );
744: --
745: end if;
746: --
753: if p_ent_scode is null
754: or p_ent_scode = 'EEV'
755: then
756: --
757: ben_efc_adjustments1.eev_adjustments
758: (p_validate => FALSE
759: ,p_worker_id => p_worker_id
760: ,p_action_id => l_action_id
761: ,p_total_workers => p_total_workers
782: ,p_disp_private => p_disp_private
783: ,p_disp_succeeds => p_disp_succeeds
784: ,p_disp_exclusions => p_disp_exclusions
785: --
786: ,p_rcoerr_val_set => ben_efc_adjustments.g_eev_rcoerr_val_set
787: ,p_failed_adj_val_set => ben_efc_adjustments.g_eev_failed_adj_val_set
788: ,p_fatal_error_val_set => ben_efc_adjustments.g_eev_fatal_error_val_set
789: ,p_success_val_set => ben_efc_adjustments.g_eev_success_adj_val_set
790: );
783: ,p_disp_succeeds => p_disp_succeeds
784: ,p_disp_exclusions => p_disp_exclusions
785: --
786: ,p_rcoerr_val_set => ben_efc_adjustments.g_eev_rcoerr_val_set
787: ,p_failed_adj_val_set => ben_efc_adjustments.g_eev_failed_adj_val_set
788: ,p_fatal_error_val_set => ben_efc_adjustments.g_eev_fatal_error_val_set
789: ,p_success_val_set => ben_efc_adjustments.g_eev_success_adj_val_set
790: );
791: --
784: ,p_disp_exclusions => p_disp_exclusions
785: --
786: ,p_rcoerr_val_set => ben_efc_adjustments.g_eev_rcoerr_val_set
787: ,p_failed_adj_val_set => ben_efc_adjustments.g_eev_failed_adj_val_set
788: ,p_fatal_error_val_set => ben_efc_adjustments.g_eev_fatal_error_val_set
789: ,p_success_val_set => ben_efc_adjustments.g_eev_success_adj_val_set
790: );
791: --
792: end if;
785: --
786: ,p_rcoerr_val_set => ben_efc_adjustments.g_eev_rcoerr_val_set
787: ,p_failed_adj_val_set => ben_efc_adjustments.g_eev_failed_adj_val_set
788: ,p_fatal_error_val_set => ben_efc_adjustments.g_eev_fatal_error_val_set
789: ,p_success_val_set => ben_efc_adjustments.g_eev_success_adj_val_set
790: );
791: --
792: end if;
793: --
796: if p_ent_scode is null
797: or p_ent_scode = 'BPL'
798: then
799: --
800: ben_efc_adjustments1.bpl_adjustments
801: (p_validate => FALSE
802: ,p_worker_id => p_worker_id
803: ,p_action_id => l_action_id
804: ,p_total_workers => p_total_workers
825: ,p_disp_private => p_disp_private
826: ,p_disp_succeeds => p_disp_succeeds
827: ,p_disp_exclusions => p_disp_exclusions
828: --
829: ,p_rcoerr_val_set => ben_efc_adjustments.g_bpl_rcoerr_val_set
830: ,p_failed_adj_val_set => ben_efc_adjustments.g_bpl_failed_adj_val_set
831: ,p_fatal_error_val_set => ben_efc_adjustments.g_bpl_fatal_error_val_set
832: ,p_success_val_set => ben_efc_adjustments.g_bpl_success_adj_val_set
833: );
826: ,p_disp_succeeds => p_disp_succeeds
827: ,p_disp_exclusions => p_disp_exclusions
828: --
829: ,p_rcoerr_val_set => ben_efc_adjustments.g_bpl_rcoerr_val_set
830: ,p_failed_adj_val_set => ben_efc_adjustments.g_bpl_failed_adj_val_set
831: ,p_fatal_error_val_set => ben_efc_adjustments.g_bpl_fatal_error_val_set
832: ,p_success_val_set => ben_efc_adjustments.g_bpl_success_adj_val_set
833: );
834: --
827: ,p_disp_exclusions => p_disp_exclusions
828: --
829: ,p_rcoerr_val_set => ben_efc_adjustments.g_bpl_rcoerr_val_set
830: ,p_failed_adj_val_set => ben_efc_adjustments.g_bpl_failed_adj_val_set
831: ,p_fatal_error_val_set => ben_efc_adjustments.g_bpl_fatal_error_val_set
832: ,p_success_val_set => ben_efc_adjustments.g_bpl_success_adj_val_set
833: );
834: --
835: end if;
828: --
829: ,p_rcoerr_val_set => ben_efc_adjustments.g_bpl_rcoerr_val_set
830: ,p_failed_adj_val_set => ben_efc_adjustments.g_bpl_failed_adj_val_set
831: ,p_fatal_error_val_set => ben_efc_adjustments.g_bpl_fatal_error_val_set
832: ,p_success_val_set => ben_efc_adjustments.g_bpl_success_adj_val_set
833: );
834: --
835: end if;
836: --