APPS.BEN_DETERMINE_RATES dependencies on BEN_MANAGE_CWB_LIFE_EVENTS

Line 564: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;

560: l_nsuv_num := 1 ;
561: --
562: if nvl(p_mode, 'X') = 'W' then
563: --
564: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
565: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
566: --
567: end if;
568: --

Line 565: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;

561: --
562: if nvl(p_mode, 'X') = 'W' then
563: --
564: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
565: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
566: --
567: end if;
568: --
569: FOR i IN p_acty_base_rt_id_table.FIRST .. p_acty_base_rt_id_table.LAST LOOP

Line 824: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then

820: if nvl(p_mode, 'X') = 'W' then
821: --
822: if l_acty_typ_cd(i) = 'CWBDB' then -- Distribution Budget values.
823: --
824: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
825: --
826: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
827: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
828: --

Line 829: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=

825: --
826: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
827: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
828: --
829: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
830: nvl(l_val(i), l_dflt_val(i));
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
832: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);

Line 831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);

827: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
828: --
829: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
830: nvl(l_val(i), l_dflt_val(i));
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
832: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val

Line 832: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);

828: --
829: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
830: nvl(l_val(i), l_dflt_val(i));
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
832: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
836: else

Line 833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);

829: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
830: nvl(l_val(i), l_dflt_val(i));
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
832: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
836: else
837: --

Line 834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);

830: nvl(l_val(i), l_dflt_val(i));
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
832: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
836: else
837: --
838: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,

Line 835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val

831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
832: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
836: else
837: --
838: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
839: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,

Line 841: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));

837: --
838: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
839: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
840: --
841: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
842: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);

Line 842: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);

838: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
839: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
840: --
841: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
842: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val

Line 843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);

839: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
840: --
841: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
842: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
847: end if;

Line 844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);

840: --
841: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
842: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
847: end if;
848: --

Line 845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);

841: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
842: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
847: end if;
848: --
849: elsif l_acty_typ_cd(i) = 'CWBWB' then -- Worksheet Budget values.

Line 846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val

842: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
847: end if;
848: --
849: elsif l_acty_typ_cd(i) = 'CWBWB' then -- Worksheet Budget values.
850: --

Line 851: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then

847: end if;
848: --
849: elsif l_acty_typ_cd(i) = 'CWBWB' then -- Worksheet Budget values.
850: --
851: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
852: --
853: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,
854: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
855: --

Line 856: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=

852: --
853: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,
854: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
855: --
856: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
857: nvl(l_val(i), l_dflt_val(i));
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
859: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);

Line 858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);

854: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
855: --
856: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
857: nvl(l_val(i), l_dflt_val(i));
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
859: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val

Line 859: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);

855: --
856: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
857: nvl(l_val(i), l_dflt_val(i));
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
859: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
863: --

Line 860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);

856: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
857: nvl(l_val(i), l_dflt_val(i));
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
859: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
863: --
864: else

Line 861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);

857: nvl(l_val(i), l_dflt_val(i));
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
859: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
863: --
864: else
865: --

Line 862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val

858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
859: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
863: --
864: else
865: --
866: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,

Line 869: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=

865: --
866: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,
867: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
868: --
869: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
870: nvl(l_val(i), l_dflt_val(i));
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
872: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);

Line 871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);

867: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
868: --
869: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
870: nvl(l_val(i), l_dflt_val(i));
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
872: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val

Line 872: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);

868: --
869: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
870: nvl(l_val(i), l_dflt_val(i));
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
872: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
876: --

Line 873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);

869: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
870: nvl(l_val(i), l_dflt_val(i));
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
872: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
876: --
877: end if;

Line 874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);

870: nvl(l_val(i), l_dflt_val(i));
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
872: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
876: --
877: end if;
878: --

Line 875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val

871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
872: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
876: --
877: end if;
878: --
879: elsif l_acty_typ_cd(i) = 'CWBR' then -- Reserve Budget values.

Line 881: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then

877: end if;
878: --
879: elsif l_acty_typ_cd(i) = 'CWBR' then -- Reserve Budget values.
880: --
881: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
882: --
883: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
884: --
885: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=

Line 885: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=

881: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
882: --
883: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
884: --
885: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
886: nvl(l_val(i), l_dflt_val(i));
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
888: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);

Line 887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);

883: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
884: --
885: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
886: nvl(l_val(i), l_dflt_val(i));
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
888: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);
890: --
891: else

Line 888: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);

884: --
885: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
886: nvl(l_val(i), l_dflt_val(i));
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
888: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);
890: --
891: else
892: --

Line 889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);

885: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
886: nvl(l_val(i), l_dflt_val(i));
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
888: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);
890: --
891: else
892: --
893: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val

Line 895: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=

891: else
892: --
893: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
894: --
895: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
896: nvl(l_val(i), l_dflt_val(i));
897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
898: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);

Line 897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);

893: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
894: --
895: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
896: nvl(l_val(i), l_dflt_val(i));
897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
898: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);
900: --
901: end if;

Line 898: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);

894: --
895: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
896: nvl(l_val(i), l_dflt_val(i));
897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
898: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);
900: --
901: end if;
902: --

Line 899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);

895: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
896: nvl(l_val(i), l_dflt_val(i));
897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
898: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);
900: --
901: end if;
902: --
903: elsif l_acty_typ_cd(i) = 'CWBWS' then -- Worksheet values.

Line 911: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);

907: -- ws_mn_val
908: -- ws_mx_val
909: -- ws_incr_val
910: --
911: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
912: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
913: nvl(l_val(i), l_dflt_val(i));
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
915: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);

Line 912: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=

908: -- ws_mx_val
909: -- ws_incr_val
910: --
911: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
912: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
913: nvl(l_val(i), l_dflt_val(i));
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
915: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);

Line 914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);

910: --
911: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
912: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
913: nvl(l_val(i), l_dflt_val(i));
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
915: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);
917: --
918: -- Multi currency support. Add caching mechanism

Line 915: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);

911: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
912: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
913: nvl(l_val(i), l_dflt_val(i));
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
915: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);
917: --
918: -- Multi currency support. Add caching mechanism
919: --

Line 916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);

912: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
913: nvl(l_val(i), l_dflt_val(i));
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
915: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);
917: --
918: -- Multi currency support. Add caching mechanism
919: --
920: open c_abr(p_acty_base_rt_id_table(i));

Line 932: ben_manage_cwb_life_events.g_cwb_person_rates_rec.elig_sal_val := l_val(i);

928: elsif l_acty_typ_cd(i) = 'CWBES' then -- Worksheet values.
929: --
930: -- elig_sal_val
931: --
932: ben_manage_cwb_life_events.g_cwb_person_rates_rec.elig_sal_val := l_val(i);
933: --
934: elsif l_acty_typ_cd(i) = 'CWBSS' then -- Worksheet values.
935: -- stat_sal_val
936: --

Line 937: ben_manage_cwb_life_events.g_cwb_person_rates_rec.stat_sal_val := l_val(i);

933: --
934: elsif l_acty_typ_cd(i) = 'CWBSS' then -- Worksheet values.
935: -- stat_sal_val
936: --
937: ben_manage_cwb_life_events.g_cwb_person_rates_rec.stat_sal_val := l_val(i);
938: --
939: elsif l_acty_typ_cd(i) = 'CWBOS' then -- Worksheet values.
940: --
941: -- oth_comp_val

Line 943: ben_manage_cwb_life_events.g_cwb_person_rates_rec.oth_comp_val := l_val(i);

939: elsif l_acty_typ_cd(i) = 'CWBOS' then -- Worksheet values.
940: --
941: -- oth_comp_val
942: --
943: ben_manage_cwb_life_events.g_cwb_person_rates_rec.oth_comp_val := l_val(i);
944: --
945: elsif l_acty_typ_cd(i) = 'CWBTC' then -- Worksheet values.
946: --
947: -- tot_comp_val

Line 949: ben_manage_cwb_life_events.g_cwb_person_rates_rec.tot_comp_val := l_val(i);

945: elsif l_acty_typ_cd(i) = 'CWBTC' then -- Worksheet values.
946: --
947: -- tot_comp_val
948: --
949: ben_manage_cwb_life_events.g_cwb_person_rates_rec.tot_comp_val := l_val(i);
950: --
951: elsif l_acty_typ_cd(i) = 'CWBMR1' then -- Worksheet values.
952: --
953: -- misc1_val

Line 955: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc1_val := l_val(i);

951: elsif l_acty_typ_cd(i) = 'CWBMR1' then -- Worksheet values.
952: --
953: -- misc1_val
954: --
955: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc1_val := l_val(i);
956: --
957: elsif l_acty_typ_cd(i) = 'CWBMR2' then -- Worksheet values.
958: --
959: -- misc2_val

Line 961: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc2_val := l_val(i);

957: elsif l_acty_typ_cd(i) = 'CWBMR2' then -- Worksheet values.
958: --
959: -- misc2_val
960: --
961: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc2_val := l_val(i);
962: --
963: elsif l_acty_typ_cd(i) = 'CWBMR3' then -- Worksheet values.
964: --
965: -- misc3_val

Line 967: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc3_val := l_val(i);

963: elsif l_acty_typ_cd(i) = 'CWBMR3' then -- Worksheet values.
964: --
965: -- misc3_val
966: --
967: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc3_val := l_val(i);
968: --
969: elsif l_acty_typ_cd(i) = 'CWBRA' then -- Worksheet values.
970: --
971: -- rec_val number,

Line 976: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=

972: -- rec_mn_val number,
973: -- rec_mx_val number,
974: -- rec_incr_val
975: --
976: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
977: nvl(l_val(i), l_dflt_val(i)) ;
978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
979: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);

Line 978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);

974: -- rec_incr_val
975: --
976: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
977: nvl(l_val(i), l_dflt_val(i)) ;
978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
979: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);
981: --
982: end if;

Line 979: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);

975: --
976: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
977: nvl(l_val(i), l_dflt_val(i)) ;
978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
979: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);
981: --
982: end if;
983: --

Line 980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);

976: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
977: nvl(l_val(i), l_dflt_val(i)) ;
978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
979: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);
981: --
982: end if;
983: --
984: end if;

Line 1072: ben_manage_cwb_life_events.populate_cwb_rates(

1068: END IF;
1069: -- Handle auto issue of budgets.
1070: -- For multi currency support added new paramaters.
1071: --
1072: ben_manage_cwb_life_events.populate_cwb_rates(
1073: --
1074: -- Columns needed for ben_cwb_person_rates
1075: --
1076: p_person_id => p_person_id

Line 2516: ben_manage_cwb_life_events.g_cwb_person_groups_rec

2512: p_rec => l_asg_benass_row
2513: );
2514: END IF;
2515: --
2516: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2517: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2518: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2519: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2520: ben_manage_cwb_life_events.populate_cwb_rates(

Line 2517: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;

2513: );
2514: END IF;
2515: --
2516: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2517: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2518: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2519: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2520: ben_manage_cwb_life_events.populate_cwb_rates(
2521: --

Line 2518: ben_manage_cwb_life_events.g_cwb_person_rates_rec

2514: END IF;
2515: --
2516: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2517: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2518: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2519: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2520: ben_manage_cwb_life_events.populate_cwb_rates(
2521: --
2522: -- Columns needed for ben_cwb_person_rates

Line 2519: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;

2515: --
2516: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2517: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2518: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2519: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2520: ben_manage_cwb_life_events.populate_cwb_rates(
2521: --
2522: -- Columns needed for ben_cwb_person_rates
2523: --

Line 2520: ben_manage_cwb_life_events.populate_cwb_rates(

2516: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2517: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2518: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2519: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2520: ben_manage_cwb_life_events.populate_cwb_rates(
2521: --
2522: -- Columns needed for ben_cwb_person_rates
2523: --
2524: p_person_id => p_person_id