[Home] [Help]
1: package body ben_efc_adjustments1 as
2: /* $Header: beefcaj1.pkb 120.1 2006/11/15 15:19:48 rtagarra noship $ */
3: --
4: /*
5: +==============================================================================+
26: */
27: --
28: -- Globals.
29: --
30: g_package varchar2(50) := 'ben_efc_adjustments1.';
31: --
32: procedure prv_adjustments
33: (p_validate in boolean default false
34: ,p_worker_id in number default null
42: ,p_valtotal_workers in number default null
43: --
44: ,p_business_group_id in number default null
45: --
46: ,p_adjustment_counts out nocopy ben_efc_adjustments.g_adjustment_counts
47: )
48: is
49: --
50: TYPE cur_type IS REF CURSOR;
69: l_efc_row g_efc_row;
70: --
71: l_global_asg_rec ben_global_enrt.g_global_asg_rec_type;
72: --
73: l_who_counts ben_efc_adjustments.g_who_counts;
74: l_olddata boolean;
75: --
76: l_row_count pls_integer;
77: l_calfail_count pls_integer;
401: )
402: is
403: --
404: l_currepe_row ben_determine_rates.g_curr_epe_rec;
405: l_currpil_row ben_efc_adjustments.g_pil_rowtype;
406: --
407: l_vpfdets ben_efc_adjustments.gc_vpfdets%rowtype;
408: --
409: l_adjfailed boolean;
403: --
404: l_currepe_row ben_determine_rates.g_curr_epe_rec;
405: l_currpil_row ben_efc_adjustments.g_pil_rowtype;
406: --
407: l_vpfdets ben_efc_adjustments.gc_vpfdets%rowtype;
408: --
409: l_adjfailed boolean;
410: l_old_val1 number;
411: l_new_val1 number;
655: then
656: --
657: -- Detect EPE or ENB Info
658: --
659: ben_efc_adjustments.DetectEPEENBInfo
660: (p_elig_per_elctbl_chc_id => p_ecrepe_id
661: ,p_enrt_bnft_id => p_ecrenb_id
662: --
663: ,p_detect_mode => 'EPEINFO'
671: -- Validate vapro
672: --
673: if l_faterr_code is null then
674: --
675: ben_efc_adjustments.DetectVAPROInfo
676: (p_currepe_row => l_currepe_row
677: --
678: ,p_lf_evt_ocrd_dt => l_currepe_row.lf_evt_ocrd_dt
679: ,p_last_update_date => null
803: l_preconv_val := l_preconvdets.ann_rt_val;
804: --
805: end if;
806: --
807: ben_efc_adjustments.DetectConvInfo
808: (p_ncucurr_code => l_uom
809: ,p_new_val => l_new_val1
810: ,p_preconv_val => l_preconv_val
811: --
899: --
900: l_chunkrow_count := 0;
901: l_allpilprv_count := 0;
902: --
903: ben_efc_adjustments.g_prv_success_adj_val_set.delete;
904: ben_efc_adjustments.g_prv_failed_adj_val_set.delete;
905: ben_efc_adjustments.g_prv_rcoerr_val_set.delete;
906: ben_efc_adjustments.g_prv_fatal_error_val_set.delete;
907: --
900: l_chunkrow_count := 0;
901: l_allpilprv_count := 0;
902: --
903: ben_efc_adjustments.g_prv_success_adj_val_set.delete;
904: ben_efc_adjustments.g_prv_failed_adj_val_set.delete;
905: ben_efc_adjustments.g_prv_rcoerr_val_set.delete;
906: ben_efc_adjustments.g_prv_fatal_error_val_set.delete;
907: --
908: -- Check if EFC process parameters are set
901: l_allpilprv_count := 0;
902: --
903: ben_efc_adjustments.g_prv_success_adj_val_set.delete;
904: ben_efc_adjustments.g_prv_failed_adj_val_set.delete;
905: ben_efc_adjustments.g_prv_rcoerr_val_set.delete;
906: ben_efc_adjustments.g_prv_fatal_error_val_set.delete;
907: --
908: -- Check if EFC process parameters are set
909: --
902: --
903: ben_efc_adjustments.g_prv_success_adj_val_set.delete;
904: ben_efc_adjustments.g_prv_failed_adj_val_set.delete;
905: ben_efc_adjustments.g_prv_rcoerr_val_set.delete;
906: ben_efc_adjustments.g_prv_fatal_error_val_set.delete;
907: --
908: -- Check if EFC process parameters are set
909: --
910: if p_action_id is not null
1122: then
1123: --
1124: -- Check rounding
1125: --
1126: ben_efc_adjustments.DetectRoundInfo
1127: (p_rndg_cd => null
1128: ,p_rndg_rl => null
1129: ,p_old_val => l_old_val1
1130: ,p_new_val => l_new_val1
1140: then
1141: --
1142: -- Check if the coverage has been modified
1143: --
1144: ben_efc_adjustments.DetectWhoInfo
1145: (p_creation_date => l_prvdets.creation_date
1146: ,p_last_update_date => l_prvdets.last_update_date
1147: ,p_object_version_number => l_prvdets.object_version_number
1148: --
1154: end if;
1155: --
1156: if l_faterr_code is null then
1157: --
1158: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1159: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1160: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id2 := l_efc_row.per_in_ler_id;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1155: --
1156: if l_faterr_code is null then
1157: --
1158: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1159: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1160: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id2 := l_efc_row.per_in_ler_id;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1156: if l_faterr_code is null then
1157: --
1158: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1159: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1160: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id2 := l_efc_row.per_in_ler_id;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1157: --
1158: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1159: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1160: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id2 := l_efc_row.per_in_ler_id;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1158: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1159: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1160: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id2 := l_efc_row.per_in_ler_id;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1166: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code1 := l_prvdets.mlt_cd;
1159: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1160: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id2 := l_efc_row.per_in_ler_id;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1166: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code1 := l_prvdets.mlt_cd;
1167: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1160: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id2 := l_efc_row.per_in_ler_id;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1166: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code1 := l_prvdets.mlt_cd;
1167: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1168: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code3 := l_prv_uom;
1161: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1166: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code1 := l_prvdets.mlt_cd;
1167: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1168: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code3 := l_prv_uom;
1169: --
1162: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1166: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code1 := l_prvdets.mlt_cd;
1167: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1168: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code3 := l_prv_uom;
1169: --
1170: l_calfail_count := l_calfail_count+1;
1163: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1166: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code1 := l_prvdets.mlt_cd;
1167: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1168: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code3 := l_prv_uom;
1169: --
1170: l_calfail_count := l_calfail_count+1;
1171: --
1164: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_prvdets.creation_date;
1165: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_prvdets.last_update_date;
1166: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code1 := l_prvdets.mlt_cd;
1167: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1168: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).code3 := l_prv_uom;
1169: --
1170: l_calfail_count := l_calfail_count+1;
1171: --
1172: end if;
1177: --
1178: if l_faterr_code is not null
1179: then
1180: --
1181: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1182: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1183: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1178: if l_faterr_code is not null
1179: then
1180: --
1181: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1182: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1183: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1179: then
1180: --
1181: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1182: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1183: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1180: --
1181: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1182: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1183: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1181: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1182: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1183: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1182: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1183: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1190: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := l_prvdets.mlt_cd;
1183: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1190: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := l_prvdets.mlt_cd;
1191: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1184: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1190: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := l_prvdets.mlt_cd;
1191: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1192: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1185: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1190: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := l_prvdets.mlt_cd;
1191: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1192: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1193: --
1186: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := l_prvdets.last_update_date;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1190: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := l_prvdets.mlt_cd;
1191: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1192: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1193: --
1194: l_faterrs_count := l_faterrs_count+1;
1187: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := l_prvdets.creation_date;
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1190: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := l_prvdets.mlt_cd;
1191: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1192: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1193: --
1194: l_faterrs_count := l_faterrs_count+1;
1195: --
1188: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1189: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1190: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := l_prvdets.mlt_cd;
1191: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1192: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1193: --
1194: l_faterrs_count := l_faterrs_count+1;
1195: --
1196: elsif l_faterr_code is null
1196: elsif l_faterr_code is null
1197: and not l_adjfailed
1198: then
1199: --
1200: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1201: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1202: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1197: and not l_adjfailed
1198: then
1199: --
1200: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1201: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1202: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1198: then
1199: --
1200: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1201: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1202: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1199: --
1200: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1201: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1202: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1200: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := l_prv_rtval_set(prvele_num).prtt_rt_val_id;
1201: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1202: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1208: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := l_prvdets.mlt_cd;
1201: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id1 := l_prvdets.prtt_enrt_rslt_id;
1202: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1208: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := l_prvdets.mlt_cd;
1209: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1202: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1208: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := l_prvdets.mlt_cd;
1209: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1210: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1203: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1208: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := l_prvdets.mlt_cd;
1209: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1210: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1211: --
1204: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1208: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := l_prvdets.mlt_cd;
1209: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1210: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1211: --
1212: l_calsucc_count := l_calsucc_count+1;
1205: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1208: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := l_prvdets.mlt_cd;
1209: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1210: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1211: --
1212: l_calsucc_count := l_calsucc_count+1;
1213: --
1206: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := l_prvdets.creation_date;
1207: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := l_prvdets.last_update_date;
1208: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := l_prvdets.mlt_cd;
1209: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_prv_rtval_set(prvele_num).ecr_rt_mlt_cd;
1210: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1211: --
1212: l_calsucc_count := l_calsucc_count+1;
1213: --
1214: end if;
1444: --
1445: exception
1446: when others then
1447: --
1448: ben_efc_adjustments.DetectAppError
1449: (p_sqlerrm => SQLERRM
1450: ,p_abr_rt_mlt_cd => l_abrdets.rt_mlt_cd
1451: ,p_abr_val => l_abrdets.val
1452: ,p_abr_entr_val_at_enrt_flag => l_abrdets.entr_val_at_enrt_flag
1459: );
1460: --
1461: if l_faterr_code is null then
1462: --
1463: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1464: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1465: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1466: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1467: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1460: --
1461: if l_faterr_code is null then
1462: --
1463: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1464: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1465: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1466: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1467: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1468: --
1461: if l_faterr_code is null then
1462: --
1463: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1464: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1465: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1466: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1467: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1468: --
1469: l_rcoerr_count := l_rcoerr_count+1;
1462: --
1463: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1464: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1465: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1466: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1467: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1468: --
1469: l_rcoerr_count := l_rcoerr_count+1;
1470: --
1463: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1464: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1465: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1466: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1467: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1468: --
1469: l_rcoerr_count := l_rcoerr_count+1;
1470: --
1471: end if;
1500: then
1501: --
1502: -- Check rounding
1503: --
1504: ben_efc_adjustments.DetectRoundInfo
1505: (p_rndg_cd => null
1506: ,p_rndg_rl => null
1507: ,p_old_val => l_old_val1
1508: ,p_new_val => l_new_val1
1657: if l_faterr_code is null
1658: and l_adjfailed
1659: then
1660: --
1661: ben_efc_adjustments.DetectWhoInfo
1662: (p_creation_date => pilprv_row.creation_date
1663: ,p_last_update_date => pilprv_row.last_update_date
1664: ,p_object_version_number => pilprv_row.object_version_number
1665: --
1674: --
1675: if l_faterr_code is not null
1676: then
1677: --
1678: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := pilprv_row.prtt_rt_val_id;
1679: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1680: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1675: if l_faterr_code is not null
1676: then
1677: --
1678: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := pilprv_row.prtt_rt_val_id;
1679: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1680: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1676: then
1677: --
1678: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := pilprv_row.prtt_rt_val_id;
1679: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1680: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1677: --
1678: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := pilprv_row.prtt_rt_val_id;
1679: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1680: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1678: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id := pilprv_row.prtt_rt_val_id;
1679: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1680: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1679: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
1680: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1680: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1688: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := pilprv_row.mlt_cd;
1681: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1688: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := pilprv_row.mlt_cd;
1689: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_enrt_rt.rt_mlt_cd;
1682: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1688: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := pilprv_row.mlt_cd;
1689: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_enrt_rt.rt_mlt_cd;
1690: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1683: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).ovn := pilprv_row.object_version_number;
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1688: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := pilprv_row.mlt_cd;
1689: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_enrt_rt.rt_mlt_cd;
1690: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1691: --
1684: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).lud := pilprv_row.last_update_date;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1688: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := pilprv_row.mlt_cd;
1689: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_enrt_rt.rt_mlt_cd;
1690: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1691: --
1692: l_faterrs_count := l_faterrs_count+1;
1685: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).credt := pilprv_row.creation_date;
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1688: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := pilprv_row.mlt_cd;
1689: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_enrt_rt.rt_mlt_cd;
1690: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1691: --
1692: l_faterrs_count := l_faterrs_count+1;
1693: --
1686: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id1 := pilprv_row.prtt_enrt_rslt_id;
1687: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).id2 := l_efc_row.per_in_ler_id;
1688: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code1 := pilprv_row.mlt_cd;
1689: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code2 := l_enrt_rt.rt_mlt_cd;
1690: ben_efc_adjustments.g_prv_fatal_error_val_set(l_faterrs_count).code3 := l_prv_uom;
1691: --
1692: l_faterrs_count := l_faterrs_count+1;
1693: --
1694: elsif not l_adjfailed
1694: elsif not l_adjfailed
1695: and l_faterr_code is null
1696: then
1697: --
1698: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := pilprv_row.prtt_rt_val_id;
1699: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1700: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1695: and l_faterr_code is null
1696: then
1697: --
1698: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := pilprv_row.prtt_rt_val_id;
1699: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1700: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1696: then
1697: --
1698: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := pilprv_row.prtt_rt_val_id;
1699: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1700: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1704: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := pilprv_row.mlt_cd;
1697: --
1698: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := pilprv_row.prtt_rt_val_id;
1699: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1700: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1704: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := pilprv_row.mlt_cd;
1705: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_enrt_rt.rt_mlt_cd;
1698: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id := pilprv_row.prtt_rt_val_id;
1699: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1700: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1704: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := pilprv_row.mlt_cd;
1705: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_enrt_rt.rt_mlt_cd;
1706: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1699: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).id2 := l_efc_row.per_in_ler_id;
1700: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1704: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := pilprv_row.mlt_cd;
1705: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_enrt_rt.rt_mlt_cd;
1706: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1707: --
1700: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1704: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := pilprv_row.mlt_cd;
1705: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_enrt_rt.rt_mlt_cd;
1706: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1707: --
1708: l_calsucc_count := l_calsucc_count+1;
1701: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1704: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := pilprv_row.mlt_cd;
1705: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_enrt_rt.rt_mlt_cd;
1706: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1707: --
1708: l_calsucc_count := l_calsucc_count+1;
1709: --
1702: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).credt := pilprv_row.creation_date;
1703: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).lud := pilprv_row.last_update_date;
1704: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code1 := pilprv_row.mlt_cd;
1705: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code2 := l_enrt_rt.rt_mlt_cd;
1706: ben_efc_adjustments.g_prv_success_adj_val_set(l_calsucc_count).code3 := l_prv_uom;
1707: --
1708: l_calsucc_count := l_calsucc_count+1;
1709: --
1710: end if;
1743: if l_pilprv_count = 0
1744: and l_faterr_code is null
1745: then
1746: --
1747: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_efc_row.per_in_ler_id;
1748: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := null;
1749: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := null;
1750: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := null;
1751: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := 'NORECALPRV';
1744: and l_faterr_code is null
1745: then
1746: --
1747: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_efc_row.per_in_ler_id;
1748: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := null;
1749: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := null;
1750: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := null;
1751: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := 'NORECALPRV';
1752: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
1745: then
1746: --
1747: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_efc_row.per_in_ler_id;
1748: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := null;
1749: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := null;
1750: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := null;
1751: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := 'NORECALPRV';
1752: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
1753: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
1746: --
1747: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_efc_row.per_in_ler_id;
1748: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := null;
1749: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := null;
1750: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := null;
1751: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := 'NORECALPRV';
1752: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
1753: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
1754: --
1747: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id := l_efc_row.per_in_ler_id;
1748: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := null;
1749: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := null;
1750: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := null;
1751: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := 'NORECALPRV';
1752: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
1753: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
1754: --
1755: l_calfail_count := l_calfail_count+1;
1748: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).id1 := null;
1749: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := null;
1750: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := null;
1751: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := 'NORECALPRV';
1752: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
1753: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
1754: --
1755: l_calfail_count := l_calfail_count+1;
1756: --
1749: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).old_val1 := null;
1750: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).new_val1 := null;
1751: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).val_type := 'NORECALPRV';
1752: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
1753: ben_efc_adjustments.g_prv_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
1754: --
1755: l_calfail_count := l_calfail_count+1;
1756: --
1757: end if;
1760: --
1761: exception
1762: when others then
1763: --
1764: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1765: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1766: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1767: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1768: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1761: exception
1762: when others then
1763: --
1764: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1765: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1766: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1767: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1768: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1769: --
1762: when others then
1763: --
1764: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1765: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1766: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1767: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1768: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1769: --
1770: l_rcoerr_count := l_rcoerr_count+1;
1763: --
1764: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1765: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1766: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1767: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1768: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1769: --
1770: l_rcoerr_count := l_rcoerr_count+1;
1771: --
1764: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.per_in_ler_id;
1765: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).rco_name := l_rco_name;
1766: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
1767: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
1768: ben_efc_adjustments.g_prv_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
1769: --
1770: l_rcoerr_count := l_rcoerr_count+1;
1771: --
1772: end;
1800: and p_valworker_id is null
1801: and p_valtotal_workers is null
1802: then
1803: --
1804: ben_efc_adjustments.insert_validation_exceptions
1805: (p_val_set => ben_efc_adjustments.g_prv_failed_adj_val_set
1806: ,p_efc_action_id => p_action_id
1807: ,p_ent_scode => 'PRV'
1808: ,p_exception_type => 'AF'
1801: and p_valtotal_workers is null
1802: then
1803: --
1804: ben_efc_adjustments.insert_validation_exceptions
1805: (p_val_set => ben_efc_adjustments.g_prv_failed_adj_val_set
1806: ,p_efc_action_id => p_action_id
1807: ,p_ent_scode => 'PRV'
1808: ,p_exception_type => 'AF'
1809: );
1807: ,p_ent_scode => 'PRV'
1808: ,p_exception_type => 'AF'
1809: );
1810: --
1811: ben_efc_adjustments.insert_validation_exceptions
1812: (p_val_set => ben_efc_adjustments.g_prv_fatal_error_val_set
1813: ,p_efc_action_id => p_action_id
1814: ,p_ent_scode => 'PRV'
1815: ,p_exception_type => null
1808: ,p_exception_type => 'AF'
1809: );
1810: --
1811: ben_efc_adjustments.insert_validation_exceptions
1812: (p_val_set => ben_efc_adjustments.g_prv_fatal_error_val_set
1813: ,p_efc_action_id => p_action_id
1814: ,p_ent_scode => 'PRV'
1815: ,p_exception_type => null
1816: );
1871: ,p_valtotal_workers in number default null
1872: --
1873: ,p_business_group_id in number default null
1874: --
1875: ,p_adjustment_counts out nocopy ben_efc_adjustments.g_adjustment_counts
1876: )
1877: is
1878: --
1879: TYPE cur_type IS REF CURSOR;
1909: l_proc varchar2(1000) := 'eev_adjustments';
1910: --
1911: l_efc_row g_efc_row;
1912: --
1913: l_who_counts ben_efc_adjustments.g_who_counts;
1914: l_prvwho_counts ben_efc_adjustments.g_who_counts;
1915: l_olddata boolean;
1916: --
1917: l_row_count pls_integer;
1910: --
1911: l_efc_row g_efc_row;
1912: --
1913: l_who_counts ben_efc_adjustments.g_who_counts;
1914: l_prvwho_counts ben_efc_adjustments.g_who_counts;
1915: l_olddata boolean;
1916: --
1917: l_row_count pls_integer;
1918: l_calfail_count pls_integer;
2064: l_faterrs_count := 0;
2065: l_preadjexc_count := 0;
2066: l_chunkrow_count := 0;
2067: --
2068: ben_efc_adjustments.g_eev_failed_adj_val_set.delete;
2069: ben_efc_adjustments.g_eev_rcoerr_val_set.delete;
2070: ben_efc_adjustments.g_eev_fatal_error_val_set.delete;
2071: ben_efc_adjustments.g_eev_success_adj_val_set.delete;
2072: --
2065: l_preadjexc_count := 0;
2066: l_chunkrow_count := 0;
2067: --
2068: ben_efc_adjustments.g_eev_failed_adj_val_set.delete;
2069: ben_efc_adjustments.g_eev_rcoerr_val_set.delete;
2070: ben_efc_adjustments.g_eev_fatal_error_val_set.delete;
2071: ben_efc_adjustments.g_eev_success_adj_val_set.delete;
2072: --
2073: -- Check if EFC process parameters are set
2066: l_chunkrow_count := 0;
2067: --
2068: ben_efc_adjustments.g_eev_failed_adj_val_set.delete;
2069: ben_efc_adjustments.g_eev_rcoerr_val_set.delete;
2070: ben_efc_adjustments.g_eev_fatal_error_val_set.delete;
2071: ben_efc_adjustments.g_eev_success_adj_val_set.delete;
2072: --
2073: -- Check if EFC process parameters are set
2074: --
2067: --
2068: ben_efc_adjustments.g_eev_failed_adj_val_set.delete;
2069: ben_efc_adjustments.g_eev_rcoerr_val_set.delete;
2070: ben_efc_adjustments.g_eev_fatal_error_val_set.delete;
2071: ben_efc_adjustments.g_eev_success_adj_val_set.delete;
2072: --
2073: -- Check if EFC process parameters are set
2074: --
2075: if p_action_id is not null
2259: l_faterr_type := 'MISSINGSETUP';
2260: --
2261: else
2262: --
2263: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2264: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2265: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2266: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2267: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN_CHKASG';
2260: --
2261: else
2262: --
2263: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2264: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2265: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2266: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2267: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN_CHKASG';
2268: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2261: else
2262: --
2263: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2264: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2265: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2266: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2267: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN_CHKASG';
2268: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2269: --
2262: --
2263: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2264: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2265: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2266: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2267: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN_CHKASG';
2268: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2269: --
2270: l_rcoerr_count := l_rcoerr_count+1;
2263: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2264: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2265: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2266: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2267: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN_CHKASG';
2268: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2269: --
2270: l_rcoerr_count := l_rcoerr_count+1;
2271: --
2264: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2265: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2266: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2267: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN_CHKASG';
2268: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2269: --
2270: l_rcoerr_count := l_rcoerr_count+1;
2271: --
2272: end if;
2484: -- Get the currency conversion factor details
2485: --
2486: if l_faterr_code is null then
2487: --
2488: ben_efc_adjustments.DetectConvInfo
2489: (p_ncucurr_code => l_preconvdets.input_currency_code
2490: ,p_new_val => l_eev_screen_entry_value
2491: ,p_preconv_val => l_preconvdets.SCREEN_ENTRY_VALUE
2492: --
2510: -- Check rounding
2511: --
2512: if l_faterr_code is null then
2513: --
2514: ben_efc_adjustments.DetectRoundInfo
2515: (p_rndg_cd => null
2516: ,p_rndg_rl => null
2517: ,p_old_val => l_efc_row.screen_entry_value
2518: ,p_new_val => l_eev_screen_entry_value
2585: if l_faterr_code is null then
2586: --
2587: -- Check if the ELE has been modified
2588: --
2589: ben_efc_adjustments.DetectWhoInfo
2590: (p_creation_date => l_eledets.creation_date
2591: ,p_last_update_date => l_eledets.last_update_date
2592: ,p_object_version_number => l_eledets.object_version_number
2593: --
2606: l_faterr_type := 'CORRECTEDINFO';
2607: --
2608: elsif l_faterr_code is null then
2609: --
2610: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2611: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
2612: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2607: --
2608: elsif l_faterr_code is null then
2609: --
2610: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2611: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
2612: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2608: elsif l_faterr_code is null then
2609: --
2610: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2611: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
2612: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2616: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
2609: --
2610: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2611: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
2612: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2616: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
2617: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
2610: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2611: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
2612: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2616: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
2617: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
2618: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).val_type := 'EEV_SCRENTVAL';
2611: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
2612: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2616: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
2617: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
2618: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).val_type := 'EEV_SCRENTVAL';
2619: --
2612: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2616: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
2617: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
2618: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).val_type := 'EEV_SCRENTVAL';
2619: --
2620: l_adjfailed := TRUE;
2613: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).bgp_id := l_efc_row.business_group_id;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2616: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
2617: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
2618: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).val_type := 'EEV_SCRENTVAL';
2619: --
2620: l_adjfailed := TRUE;
2621: l_calfail_count := l_calfail_count+1;
2614: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).credt := l_eledets.creation_date;
2615: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).lud := l_eledets.last_update_date;
2616: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
2617: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
2618: ben_efc_adjustments.g_eev_failed_adj_val_set(l_calfail_count).val_type := 'EEV_SCRENTVAL';
2619: --
2620: l_adjfailed := TRUE;
2621: l_calfail_count := l_calfail_count+1;
2622: --
2724: l_faterr_type := 'MISSINGSETUP';
2725: --
2726: else
2727: --
2728: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2729: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2730: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2731: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2732: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).lud := l_eledets.last_update_date;
2725: --
2726: else
2727: --
2728: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2729: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2730: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2731: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2732: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).lud := l_eledets.last_update_date;
2733: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN';
2726: else
2727: --
2728: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2729: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2730: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2731: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2732: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).lud := l_eledets.last_update_date;
2733: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN';
2734: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2727: --
2728: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2729: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2730: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2731: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2732: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).lud := l_eledets.last_update_date;
2733: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN';
2734: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2735: --
2728: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2729: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2730: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2731: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2732: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).lud := l_eledets.last_update_date;
2733: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN';
2734: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2735: --
2736: l_rcoerr_count := l_rcoerr_count+1;
2729: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
2730: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2731: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2732: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).lud := l_eledets.last_update_date;
2733: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN';
2734: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2735: --
2736: l_rcoerr_count := l_rcoerr_count+1;
2737: --
2730: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
2731: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).bgp_id := l_efc_row.business_group_id;
2732: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).lud := l_eledets.last_update_date;
2733: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENELMEN';
2734: ben_efc_adjustments.g_eev_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
2735: --
2736: l_rcoerr_count := l_rcoerr_count+1;
2737: --
2738: end if;
2749: --
2750: if l_faterr_code is not null
2751: then
2752: --
2753: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2754: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
2755: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2750: if l_faterr_code is not null
2751: then
2752: --
2753: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2754: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
2755: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2751: then
2752: --
2753: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2754: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
2755: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2752: --
2753: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2754: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
2755: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2753: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2754: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
2755: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2754: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
2755: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2755: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2756: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2764: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).cre_by := l_eledets.created_by;
2757: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2764: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).cre_by := l_eledets.created_by;
2765: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lu_by := l_eledets.last_updated_by;
2758: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2764: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).cre_by := l_eledets.created_by;
2765: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lu_by := l_eledets.last_updated_by;
2766: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id1 := l_efc_row.prtt_rt_val_id;
2759: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2764: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).cre_by := l_eledets.created_by;
2765: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lu_by := l_eledets.last_updated_by;
2766: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id1 := l_efc_row.prtt_rt_val_id;
2767: --
2760: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).bgp_id := l_efc_row.business_group_id;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2764: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).cre_by := l_eledets.created_by;
2765: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lu_by := l_eledets.last_updated_by;
2766: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id1 := l_efc_row.prtt_rt_val_id;
2767: --
2768: l_faterrs_count := l_faterrs_count+1;
2761: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lud := l_eledets.last_update_date;
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2764: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).cre_by := l_eledets.created_by;
2765: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lu_by := l_eledets.last_updated_by;
2766: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id1 := l_efc_row.prtt_rt_val_id;
2767: --
2768: l_faterrs_count := l_faterrs_count+1;
2769: --
2762: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).credt := l_eledets.creation_date;
2763: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).ovn := l_eledets.object_version_number;
2764: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).cre_by := l_eledets.created_by;
2765: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).lu_by := l_eledets.last_updated_by;
2766: ben_efc_adjustments.g_eev_fatal_error_val_set(l_faterrs_count).id1 := l_efc_row.prtt_rt_val_id;
2767: --
2768: l_faterrs_count := l_faterrs_count+1;
2769: --
2770: elsif l_faterr_code is null
2770: elsif l_faterr_code is null
2771: and not l_adjfailed
2772: then
2773: --
2774: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2775: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
2776: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2771: and not l_adjfailed
2772: then
2773: --
2774: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2775: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
2776: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2772: then
2773: --
2774: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2775: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
2776: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2780: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).credt := l_eledets.creation_date;
2773: --
2774: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2775: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
2776: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2780: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).credt := l_eledets.creation_date;
2781: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).lud := l_eledets.last_update_date;
2774: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id := l_efc_row.ELEMENT_ENTRY_VALUE_id;
2775: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
2776: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2780: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).credt := l_eledets.creation_date;
2781: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).lud := l_eledets.last_update_date;
2782: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id1 := l_efc_row.prtt_rt_val_id;
2775: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
2776: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2780: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).credt := l_eledets.creation_date;
2781: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).lud := l_eledets.last_update_date;
2782: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id1 := l_efc_row.prtt_rt_val_id;
2783: --
2776: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2780: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).credt := l_eledets.creation_date;
2781: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).lud := l_eledets.last_update_date;
2782: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id1 := l_efc_row.prtt_rt_val_id;
2783: --
2784: l_calsucc_count := l_calsucc_count+1;
2777: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2780: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).credt := l_eledets.creation_date;
2781: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).lud := l_eledets.last_update_date;
2782: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id1 := l_efc_row.prtt_rt_val_id;
2783: --
2784: l_calsucc_count := l_calsucc_count+1;
2785: -- --
2778: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
2779: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).val_type := 'EEV_SCRENTVAL';
2780: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).credt := l_eledets.creation_date;
2781: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).lud := l_eledets.last_update_date;
2782: ben_efc_adjustments.g_eev_success_adj_val_set(l_calsucc_count).id1 := l_efc_row.prtt_rt_val_id;
2783: --
2784: l_calsucc_count := l_calsucc_count+1;
2785: -- --
2786: end if;
2799: and p_valworker_id is null
2800: and p_valtotal_workers is null
2801: then
2802: --
2803: ben_efc_adjustments.insert_validation_exceptions
2804: (p_val_set => ben_efc_adjustments.g_eev_failed_adj_val_set
2805: ,p_efc_action_id => p_action_id
2806: ,p_ent_scode => 'EEV'
2807: ,p_exception_type => 'AF'
2800: and p_valtotal_workers is null
2801: then
2802: --
2803: ben_efc_adjustments.insert_validation_exceptions
2804: (p_val_set => ben_efc_adjustments.g_eev_failed_adj_val_set
2805: ,p_efc_action_id => p_action_id
2806: ,p_ent_scode => 'EEV'
2807: ,p_exception_type => 'AF'
2808: );
2806: ,p_ent_scode => 'EEV'
2807: ,p_exception_type => 'AF'
2808: );
2809: --
2810: ben_efc_adjustments.insert_validation_exceptions
2811: (p_val_set => ben_efc_adjustments.g_eev_fatal_error_val_set
2812: ,p_efc_action_id => p_action_id
2813: ,p_ent_scode => 'EEV'
2814: ,p_exception_type => null
2807: ,p_exception_type => 'AF'
2808: );
2809: --
2810: ben_efc_adjustments.insert_validation_exceptions
2811: (p_val_set => ben_efc_adjustments.g_eev_fatal_error_val_set
2812: ,p_efc_action_id => p_action_id
2813: ,p_ent_scode => 'EEV'
2814: ,p_exception_type => null
2815: );
2883: ,p_valtotal_workers in number default null
2884: --
2885: ,p_business_group_id in number default null
2886: --
2887: ,p_adjustment_counts out nocopy ben_efc_adjustments.g_adjustment_counts
2888: )
2889: is
2890: --
2891: TYPE cur_type IS REF CURSOR;
2927: l_groupby_str long;
2928: --
2929: l_efc_row g_efc_row;
2930: --
2931: l_who_counts ben_efc_adjustments.g_who_counts;
2932: l_olddata boolean;
2933: --
2934: l_faterr_code varchar2(100);
2935: l_faterr_type varchar2(100);
3110: l_faterrs_count := 0;
3111: --
3112: l_chunkrow_count := 0;
3113: --
3114: ben_efc_adjustments.g_bpl_success_adj_val_set.delete;
3115: ben_efc_adjustments.g_bpl_failed_adj_val_set.delete;
3116: ben_efc_adjustments.g_bpl_rcoerr_val_set.delete;
3117: ben_efc_adjustments.g_bpl_fatal_error_val_set.delete;
3118: --
3111: --
3112: l_chunkrow_count := 0;
3113: --
3114: ben_efc_adjustments.g_bpl_success_adj_val_set.delete;
3115: ben_efc_adjustments.g_bpl_failed_adj_val_set.delete;
3116: ben_efc_adjustments.g_bpl_rcoerr_val_set.delete;
3117: ben_efc_adjustments.g_bpl_fatal_error_val_set.delete;
3118: --
3119: -- Check if EFC process parameters are set
3112: l_chunkrow_count := 0;
3113: --
3114: ben_efc_adjustments.g_bpl_success_adj_val_set.delete;
3115: ben_efc_adjustments.g_bpl_failed_adj_val_set.delete;
3116: ben_efc_adjustments.g_bpl_rcoerr_val_set.delete;
3117: ben_efc_adjustments.g_bpl_fatal_error_val_set.delete;
3118: --
3119: -- Check if EFC process parameters are set
3120: --
3113: --
3114: ben_efc_adjustments.g_bpl_success_adj_val_set.delete;
3115: ben_efc_adjustments.g_bpl_failed_adj_val_set.delete;
3116: ben_efc_adjustments.g_bpl_rcoerr_val_set.delete;
3117: ben_efc_adjustments.g_bpl_fatal_error_val_set.delete;
3118: --
3119: -- Check if EFC process parameters are set
3120: --
3121: if p_action_id is not null
3518: -- Check rounding
3519: --
3520: if l_faterr_code is null then
3521: --
3522: ben_efc_adjustments.DetectRoundInfo
3523: (p_rndg_cd => null
3524: ,p_rndg_rl => null
3525: ,p_old_val => l_old_val1
3526: ,p_new_val => l_new_val1
3533: end if;
3534: --
3535: if l_faterr_code is null then
3536: --
3537: ben_efc_adjustments.DetectWhoInfo
3538: (p_creation_date => l_efc_row.creation_date
3539: ,p_last_update_date => l_efc_row.last_update_date
3540: ,p_object_version_number => l_efc_row.object_version_number
3541: --
3547: end if;
3548: --
3549: if l_faterr_code is null then
3550: --
3551: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3552: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
3553: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3548: --
3549: if l_faterr_code is null then
3550: --
3551: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3552: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
3553: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3549: if l_faterr_code is null then
3550: --
3551: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3552: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
3553: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3557: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
3550: --
3551: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3552: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
3553: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3557: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
3558: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
3551: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3552: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
3553: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3557: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
3558: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
3559: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
3552: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).esd := l_efc_row.effective_start_date;
3553: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3557: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
3558: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
3559: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
3560: --
3553: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).eed := l_efc_row.effective_end_date;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3557: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
3558: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
3559: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
3560: --
3561: l_calfail_count := l_calfail_count+1;
3554: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).ovn := l_efc_row.object_version_number;
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3557: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
3558: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
3559: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
3560: --
3561: l_calfail_count := l_calfail_count+1;
3562: --
3555: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).credt := l_efc_row.creation_date;
3556: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).lud := l_efc_row.last_update_date;
3557: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).old_val1 := l_old_val1;
3558: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).new_val1 := l_new_val1;
3559: ben_efc_adjustments.g_bpl_failed_adj_val_set(l_calfail_count).val_type := l_val_type;
3560: --
3561: l_calfail_count := l_calfail_count+1;
3562: --
3563: end if;
3598: --
3599: exception
3600: when others then
3601: --
3602: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3603: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
3604: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
3605: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
3606: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
3599: exception
3600: when others then
3601: --
3602: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3603: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
3604: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
3605: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
3606: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
3607: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENPSTCR';
3600: when others then
3601: --
3602: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3603: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
3604: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
3605: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
3606: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
3607: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENPSTCR';
3608: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
3601: --
3602: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3603: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
3604: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
3605: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
3606: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
3607: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENPSTCR';
3608: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
3609: --
3602: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3603: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
3604: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
3605: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
3606: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
3607: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENPSTCR';
3608: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
3609: --
3610: l_rcoerr_count := l_rcoerr_count+1;
3603: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).esd := l_efc_row.effective_start_date;
3604: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
3605: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
3606: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
3607: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENPSTCR';
3608: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
3609: --
3610: l_rcoerr_count := l_rcoerr_count+1;
3611: --
3604: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).eed := l_efc_row.effective_end_date;
3605: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).credt := l_efc_row.creation_date;
3606: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).lud := l_efc_row.last_update_date;
3607: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).rco_name := 'BENPSTCR';
3608: ben_efc_adjustments.g_bpl_rcoerr_val_set(l_rcoerr_count).sql_error := SQLERRM;
3609: --
3610: l_rcoerr_count := l_rcoerr_count+1;
3611: --
3612: end;
3617: --
3618: if l_faterr_code is not null
3619: then
3620: --
3621: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3622: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
3623: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3618: if l_faterr_code is not null
3619: then
3620: --
3621: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3622: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
3623: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3619: then
3620: --
3621: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3622: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
3623: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3620: --
3621: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3622: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
3623: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3621: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3622: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
3623: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3622: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).esd := l_efc_row.effective_start_date;
3623: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3623: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).eed := l_efc_row.effective_end_date;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3631: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).ovn := l_efc_row.object_version_number;
3624: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).val_type := l_val_type;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3631: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).ovn := l_efc_row.object_version_number;
3632: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).cre_by := l_efc_row.created_by;
3625: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).old_val1 := l_old_val1;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3631: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).ovn := l_efc_row.object_version_number;
3632: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).cre_by := l_efc_row.created_by;
3633: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lu_by := l_efc_row.last_updated_by;
3626: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).new_val1 := l_new_val1;
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3631: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).ovn := l_efc_row.object_version_number;
3632: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).cre_by := l_efc_row.created_by;
3633: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lu_by := l_efc_row.last_updated_by;
3634: --
3627: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_code := l_faterr_code;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3631: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).ovn := l_efc_row.object_version_number;
3632: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).cre_by := l_efc_row.created_by;
3633: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lu_by := l_efc_row.last_updated_by;
3634: --
3635: l_faterrs_count := l_faterrs_count+1;
3628: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).faterr_type := l_faterr_type;
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3631: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).ovn := l_efc_row.object_version_number;
3632: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).cre_by := l_efc_row.created_by;
3633: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lu_by := l_efc_row.last_updated_by;
3634: --
3635: l_faterrs_count := l_faterrs_count+1;
3636: --
3629: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lud := l_efc_row.last_update_date;
3630: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).credt := l_efc_row.creation_date;
3631: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).ovn := l_efc_row.object_version_number;
3632: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).cre_by := l_efc_row.created_by;
3633: ben_efc_adjustments.g_bpl_fatal_error_val_set(l_faterrs_count).lu_by := l_efc_row.last_updated_by;
3634: --
3635: l_faterrs_count := l_faterrs_count+1;
3636: --
3637: elsif l_faterr_code is null
3637: elsif l_faterr_code is null
3638: and not l_adjfailed
3639: then
3640: --
3641: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3642: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
3643: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3638: and not l_adjfailed
3639: then
3640: --
3641: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3642: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
3643: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3646: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
3639: then
3640: --
3641: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3642: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
3643: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3646: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
3647: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).credt := l_efc_row.creation_date;
3640: --
3641: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3642: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
3643: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3646: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
3647: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).credt := l_efc_row.creation_date;
3648: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).lud := l_efc_row.last_update_date;
3641: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).id := l_efc_row.bnft_prvdd_ldgr_id;
3642: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
3643: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3646: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
3647: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).credt := l_efc_row.creation_date;
3648: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).lud := l_efc_row.last_update_date;
3649: --
3642: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).esd := l_efc_row.effective_start_date;
3643: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3646: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
3647: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).credt := l_efc_row.creation_date;
3648: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).lud := l_efc_row.last_update_date;
3649: --
3650: l_calsucc_count := l_calsucc_count+1;
3643: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).eed := l_efc_row.effective_end_date;
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3646: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
3647: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).credt := l_efc_row.creation_date;
3648: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).lud := l_efc_row.last_update_date;
3649: --
3650: l_calsucc_count := l_calsucc_count+1;
3651: --
3644: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).old_val1 := l_old_val1;
3645: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).new_val1 := l_new_val1;
3646: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).val_type := l_val_type;
3647: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).credt := l_efc_row.creation_date;
3648: ben_efc_adjustments.g_bpl_success_adj_val_set(l_calsucc_count).lud := l_efc_row.last_update_date;
3649: --
3650: l_calsucc_count := l_calsucc_count+1;
3651: --
3652: end if;
3697: p_adjustment_counts.actconv_count := l_actconv_count;
3698: --
3699: end bpl_adjustments;
3700: --
3701: end ben_efc_adjustments1;