eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_DYN_CALC_PKG dependencies on BEN_CWB_UTILS

Line 420: l_increase_amt := ben_cwb_utils.add_number_with_null_check

416: begin
417: if g_allocation_row.new_salary is null then
418: for l_local_plan_info in c_local_plan_info loop
419: if l_local_plan_info.oipl_ordr_num is null then
420: l_increase_amt := ben_cwb_utils.add_number_with_null_check
421: (g_allocation_row.ws_val,l_increase_amt);
422: elsif l_local_plan_info.oipl_ordr_num = 1 then
423: l_increase_amt := ben_cwb_utils.add_number_with_null_check
424: (g_allocation_row.ws_val_opt1,l_increase_amt);

Line 423: l_increase_amt := ben_cwb_utils.add_number_with_null_check

419: if l_local_plan_info.oipl_ordr_num is null then
420: l_increase_amt := ben_cwb_utils.add_number_with_null_check
421: (g_allocation_row.ws_val,l_increase_amt);
422: elsif l_local_plan_info.oipl_ordr_num = 1 then
423: l_increase_amt := ben_cwb_utils.add_number_with_null_check
424: (g_allocation_row.ws_val_opt1,l_increase_amt);
425: elsif l_local_plan_info.oipl_ordr_num = 2 then
426: l_increase_amt := ben_cwb_utils.add_number_with_null_check
427: (g_allocation_row.ws_val_opt2,l_increase_amt);

Line 426: l_increase_amt := ben_cwb_utils.add_number_with_null_check

422: elsif l_local_plan_info.oipl_ordr_num = 1 then
423: l_increase_amt := ben_cwb_utils.add_number_with_null_check
424: (g_allocation_row.ws_val_opt1,l_increase_amt);
425: elsif l_local_plan_info.oipl_ordr_num = 2 then
426: l_increase_amt := ben_cwb_utils.add_number_with_null_check
427: (g_allocation_row.ws_val_opt2,l_increase_amt);
428: elsif l_local_plan_info.oipl_ordr_num = 3 then
429: l_increase_amt := ben_cwb_utils.add_number_with_null_check
430: (g_allocation_row.ws_val_opt3,l_increase_amt);

Line 429: l_increase_amt := ben_cwb_utils.add_number_with_null_check

425: elsif l_local_plan_info.oipl_ordr_num = 2 then
426: l_increase_amt := ben_cwb_utils.add_number_with_null_check
427: (g_allocation_row.ws_val_opt2,l_increase_amt);
428: elsif l_local_plan_info.oipl_ordr_num = 3 then
429: l_increase_amt := ben_cwb_utils.add_number_with_null_check
430: (g_allocation_row.ws_val_opt3,l_increase_amt);
431: elsif l_local_plan_info.oipl_ordr_num = 4 then
432: l_increase_amt := ben_cwb_utils.add_number_with_null_check
433: (g_allocation_row.ws_val_opt4,l_increase_amt);

Line 432: l_increase_amt := ben_cwb_utils.add_number_with_null_check

428: elsif l_local_plan_info.oipl_ordr_num = 3 then
429: l_increase_amt := ben_cwb_utils.add_number_with_null_check
430: (g_allocation_row.ws_val_opt3,l_increase_amt);
431: elsif l_local_plan_info.oipl_ordr_num = 4 then
432: l_increase_amt := ben_cwb_utils.add_number_with_null_check
433: (g_allocation_row.ws_val_opt4,l_increase_amt);
434: end if;
435: end loop;
436: --

Line 1062: ben_cwb_utils.add_number_with_null_check(

1058: g_allocation_row.new_salary := null;
1059: if g_allocation_row.ws_abr_id is not null then
1060: g_upd_pl_rate := true;
1061: g_allocation_row.ws_val:=
1062: ben_cwb_utils.add_number_with_null_check(
1063: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1064: (to_number(p_value),-g_allocation_row.ws_val_opt1));
1065: end if;
1066: g_allocation_row.ws_val_opt1:= to_number(p_value);

Line 1063: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check

1059: if g_allocation_row.ws_abr_id is not null then
1060: g_upd_pl_rate := true;
1061: g_allocation_row.ws_val:=
1062: ben_cwb_utils.add_number_with_null_check(
1063: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1064: (to_number(p_value),-g_allocation_row.ws_val_opt1));
1065: end if;
1066: g_allocation_row.ws_val_opt1:= to_number(p_value);
1067: elsif p_attribute_name = 'StatSalValOpt1' then

Line 1089: ben_cwb_utils.add_number_with_null_check(

1085: g_allocation_row.new_salary := null;
1086: if g_allocation_row.ws_abr_id is not null then
1087: g_upd_pl_rate := true;
1088: g_allocation_row.ws_val:=
1089: ben_cwb_utils.add_number_with_null_check(
1090: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1091: (to_number(p_value),-g_allocation_row.ws_val_opt2));
1092: end if;
1093: g_allocation_row.ws_val_opt2:= to_number(p_value);

Line 1090: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check

1086: if g_allocation_row.ws_abr_id is not null then
1087: g_upd_pl_rate := true;
1088: g_allocation_row.ws_val:=
1089: ben_cwb_utils.add_number_with_null_check(
1090: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1091: (to_number(p_value),-g_allocation_row.ws_val_opt2));
1092: end if;
1093: g_allocation_row.ws_val_opt2:= to_number(p_value);
1094: elsif p_attribute_name = 'StatSalValOpt2' then

Line 1116: ben_cwb_utils.add_number_with_null_check(

1112: g_allocation_row.new_salary := null;
1113: if g_allocation_row.ws_abr_id is not null then
1114: g_upd_pl_rate := true;
1115: g_allocation_row.ws_val:=
1116: ben_cwb_utils.add_number_with_null_check(
1117: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1118: (to_number(p_value),-g_allocation_row.ws_val_opt3));
1119: end if;
1120: g_allocation_row.ws_val_opt3:= to_number(p_value);

Line 1117: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check

1113: if g_allocation_row.ws_abr_id is not null then
1114: g_upd_pl_rate := true;
1115: g_allocation_row.ws_val:=
1116: ben_cwb_utils.add_number_with_null_check(
1117: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1118: (to_number(p_value),-g_allocation_row.ws_val_opt3));
1119: end if;
1120: g_allocation_row.ws_val_opt3:= to_number(p_value);
1121: elsif p_attribute_name = 'StatSalValOpt3' then

Line 1143: ben_cwb_utils.add_number_with_null_check(

1139: g_allocation_row.new_salary := null;
1140: if g_allocation_row.ws_abr_id is not null then
1141: g_upd_pl_rate := true;
1142: g_allocation_row.ws_val:=
1143: ben_cwb_utils.add_number_with_null_check(
1144: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1145: (to_number(p_value),-g_allocation_row.ws_val_opt4));
1146: end if;
1147: g_allocation_row.ws_val_opt4:= to_number(p_value);

Line 1144: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check

1140: if g_allocation_row.ws_abr_id is not null then
1141: g_upd_pl_rate := true;
1142: g_allocation_row.ws_val:=
1143: ben_cwb_utils.add_number_with_null_check(
1144: g_allocation_row.ws_val,ben_cwb_utils.add_number_with_null_check
1145: (to_number(p_value),-g_allocation_row.ws_val_opt4));
1146: end if;
1147: g_allocation_row.ws_val_opt4:= to_number(p_value);
1148: elsif p_attribute_name = 'StatSalValOpt4' then