1: package body pay_jp_isdf_ss_pkg as
2: /* $Header: pyjpisfs.pkb 120.12.12020000.4 2012/09/20 19:01:41 dduvvuri ship $ */
3: --
4: c_package constant varchar2(30) := 'pay_jp_isdf_ss_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6: --
7: c_isdf_ins_elm constant varchar2(80) := 'YEA_INS_PREM_EXM_DECLARE_INFO';
8: c_isdf_ins_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_ins_elm, null, 'JP');
9: c_life_gen_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'GEN_LIFE_INS_PREM');
235: --
236: begin
237: --
238: if g_debug then
239: hr_utility.set_location(l_proc,0);
240: end if;
241: --
242: open csr_pact;
243: fetch csr_pact into l_payroll_action_id, l_business_group_id, l_effective_date;
951: --
952: end if;
953: --
954: if g_debug then
955: hr_utility.trace('g_life_range1b : '||g_life_range1b);
956: hr_utility.trace('g_life_range2a : '||g_life_range2a);
957: hr_utility.trace('g_life_range2b : '||g_life_range2b);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
952: end if;
953: --
954: if g_debug then
955: hr_utility.trace('g_life_range1b : '||g_life_range1b);
956: hr_utility.trace('g_life_range2a : '||g_life_range2a);
957: hr_utility.trace('g_life_range2b : '||g_life_range2b);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
953: --
954: if g_debug then
955: hr_utility.trace('g_life_range1b : '||g_life_range1b);
956: hr_utility.trace('g_life_range2a : '||g_life_range2a);
957: hr_utility.trace('g_life_range2b : '||g_life_range2b);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
954: if g_debug then
955: hr_utility.trace('g_life_range1b : '||g_life_range1b);
956: hr_utility.trace('g_life_range2a : '||g_life_range2a);
957: hr_utility.trace('g_life_range2b : '||g_life_range2b);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
955: hr_utility.trace('g_life_range1b : '||g_life_range1b);
956: hr_utility.trace('g_life_range2a : '||g_life_range2a);
957: hr_utility.trace('g_life_range2b : '||g_life_range2b);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
956: hr_utility.trace('g_life_range2a : '||g_life_range2a);
957: hr_utility.trace('g_life_range2b : '||g_life_range2b);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
957: hr_utility.trace('g_life_range2b : '||g_life_range2b);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
958: hr_utility.trace('g_life_range3a : '||g_life_range3a);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
959: hr_utility.trace('g_life_range3b : '||g_life_range3b);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
960: hr_utility.trace('g_life_range4a : '||g_life_range4a);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
961: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
962: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
963: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
964: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
965: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
966: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
967: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
968: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
969: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
970: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
971: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
972: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
973: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
974: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
975: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
976: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
977: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
978: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
979: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
980: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
981: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
982: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
983: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
984: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
985: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
986: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
987: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
988: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
989: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
990: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
991: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
992: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
993: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
994: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
995: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
996: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
997: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
998: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
999: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1000: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1008: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1001: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1008: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1009: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1002: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1008: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1009: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1010: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1003: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1008: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1009: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1010: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1011: end if;
1004: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1008: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1009: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1010: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1011: end if;
1012: --
1005: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1008: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1009: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1010: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1011: end if;
1012: --
1013: if g_debug then
1006: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1007: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1008: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1009: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1010: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1011: end if;
1012: --
1013: if g_debug then
1014: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1010: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1011: end if;
1012: --
1013: if g_debug then
1014: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1015: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1016: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1011: end if;
1012: --
1013: if g_debug then
1014: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1015: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1016: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1012: --
1013: if g_debug then
1014: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1015: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1016: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1013: if g_debug then
1014: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1015: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1016: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1014: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1015: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1016: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1015: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1016: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1016: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1017: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1018: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1019: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1020: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1021: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1022: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1023: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1024: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1025: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1026: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1027: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1028: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1029: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1030: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1031: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1032: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1033: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1034: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1035: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1036: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1037: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1038: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1039: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1040: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1041: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1042: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1043: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1044: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1045: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1046: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1047: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1048: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1049: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1050: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1058: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1051: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1058: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1059: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1052: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1058: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1059: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1060: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1053: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1058: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1059: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1060: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1061: end if;
1054: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1058: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1059: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1060: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1061: end if;
1062: --
1055: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1058: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1059: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1060: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1061: end if;
1062: --
1063: if g_debug then
1056: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1057: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1058: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1059: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1060: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1061: end if;
1062: --
1063: if g_debug then
1064: hr_utility.set_location(l_proc,1000);
1060: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1061: end if;
1062: --
1063: if g_debug then
1064: hr_utility.set_location(l_proc,1000);
1065: end if;
1066: --
1067: end set_form_pg_prompt;
1068: --
1119: --
1120: begin
1121: --
1122: if g_debug then
1123: hr_utility.set_location(l_proc,0);
1124: end if;
1125: --
1126: l_legislation_code := 'JP';
1127:
1483: --
1484: begin
1485: --
1486: if g_debug then
1487: hr_utility.set_location(l_proc,0);
1488: end if;
1489: --
1490: l_submission_date := check_submission_period(p_action_information_id);
1491: --
1489: --
1490: l_submission_date := check_submission_period(p_action_information_id);
1491: --
1492: if g_debug then
1493: hr_utility.set_location(l_proc,10);
1494: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1495: end if;
1496: --
1497: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1490: l_submission_date := check_submission_period(p_action_information_id);
1491: --
1492: if g_debug then
1493: hr_utility.set_location(l_proc,10);
1494: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1495: end if;
1496: --
1497: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1498: --
1501: fnd_message.raise_error;
1502: end if;
1503: --
1504: if g_debug then
1505: hr_utility.set_location(l_proc,20);
1506: hr_utility.trace('action_information_id : '||p_action_information_id);
1507: hr_utility.trace('object_version_number : '||p_object_version_number);
1508: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1509: hr_utility.trace('start delete preset archive');
1502: end if;
1503: --
1504: if g_debug then
1505: hr_utility.set_location(l_proc,20);
1506: hr_utility.trace('action_information_id : '||p_action_information_id);
1507: hr_utility.trace('object_version_number : '||p_object_version_number);
1508: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1509: hr_utility.trace('start delete preset archive');
1510: end if;
1503: --
1504: if g_debug then
1505: hr_utility.set_location(l_proc,20);
1506: hr_utility.trace('action_information_id : '||p_action_information_id);
1507: hr_utility.trace('object_version_number : '||p_object_version_number);
1508: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1509: hr_utility.trace('start delete preset archive');
1510: end if;
1511: --
1504: if g_debug then
1505: hr_utility.set_location(l_proc,20);
1506: hr_utility.trace('action_information_id : '||p_action_information_id);
1507: hr_utility.trace('object_version_number : '||p_object_version_number);
1508: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1509: hr_utility.trace('start delete preset archive');
1510: end if;
1511: --
1512: -- recreate archive data (available for existing data of transaction_status N or U)
1505: hr_utility.set_location(l_proc,20);
1506: hr_utility.trace('action_information_id : '||p_action_information_id);
1507: hr_utility.trace('object_version_number : '||p_object_version_number);
1508: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1509: hr_utility.trace('start delete preset archive');
1510: end if;
1511: --
1512: -- recreate archive data (available for existing data of transaction_status N or U)
1513: --
1517: and action_context_type = 'AAP'
1518: and action_information_category <> 'JP_ISDF_ASSACT';
1519: --
1520: if g_debug then
1521: hr_utility.trace('end delete preset archive');
1522: hr_utility.set_location(l_proc,30);
1523: hr_utility.trace('start archive_assact');
1524: end if;
1525: --
1518: and action_information_category <> 'JP_ISDF_ASSACT';
1519: --
1520: if g_debug then
1521: hr_utility.trace('end delete preset archive');
1522: hr_utility.set_location(l_proc,30);
1523: hr_utility.trace('start archive_assact');
1524: end if;
1525: --
1526: -- set global argument of pact in pay_jp_isdf_archive_pkg
1519: --
1520: if g_debug then
1521: hr_utility.trace('end delete preset archive');
1522: hr_utility.set_location(l_proc,30);
1523: hr_utility.trace('start archive_assact');
1524: end if;
1525: --
1526: -- set global argument of pact in pay_jp_isdf_archive_pkg
1527: open csr_pact;
1528: fetch csr_pact into l_payroll_action_id;
1529: close csr_pact;
1530: --
1531: if g_debug then
1532: hr_utility.set_location(l_proc,40);
1533: end if;
1534: --
1535: pay_jp_isdf_archive_pkg.init_pact(
1536: p_payroll_action_id => l_payroll_action_id);
1538: -- reset to force archive because of concurrent parameter might be N
1539: pay_jp_isdf_archive_pkg.g_archive_default_flag := 'Y';
1540: --
1541: if g_debug then
1542: hr_utility.set_location(l_proc,50);
1543: end if;
1544: --
1545: -- set global argument of assact in pay_jp_isdf_archive_pkg
1546: pay_jp_isdf_archive_pkg.init_assact(
1547: p_assignment_action_id => l_assact_rec.assignment_action_id,
1548: p_assignment_id => l_assact_rec.assignment_id);
1549: --
1550: if g_debug then
1551: hr_utility.set_location(l_proc,60);
1552: end if;
1553: --
1554: pay_jp_isdf_archive_pkg.archive_assact(
1555: p_assignment_action_id => l_assact_rec.assignment_action_id,
1555: p_assignment_action_id => l_assact_rec.assignment_action_id,
1556: p_assignment_id => l_assact_rec.assignment_id);
1557: --
1558: if g_debug then
1559: hr_utility.trace('end archive_assact');
1560: hr_utility.set_location(l_proc,70);
1561: hr_utility.trace('start update_assact');
1562: end if;
1563: --
1556: p_assignment_id => l_assact_rec.assignment_id);
1557: --
1558: if g_debug then
1559: hr_utility.trace('end archive_assact');
1560: hr_utility.set_location(l_proc,70);
1561: hr_utility.trace('start update_assact');
1562: end if;
1563: --
1564: p_object_version_number := l_assact_rec.object_version_number + 1;
1557: --
1558: if g_debug then
1559: hr_utility.trace('end archive_assact');
1560: hr_utility.set_location(l_proc,70);
1561: hr_utility.trace('start update_assact');
1562: end if;
1563: --
1564: p_object_version_number := l_assact_rec.object_version_number + 1;
1565: --
1580: transaction_status = 'N'
1581: where row_id = l_assact_rec.row_id;
1582: --
1583: if g_debug then
1584: hr_utility.trace('end update_assact');
1585: hr_utility.set_location(l_proc,1000);
1586: end if;
1587: --
1588: end do_new;
1581: where row_id = l_assact_rec.row_id;
1582: --
1583: if g_debug then
1584: hr_utility.trace('end update_assact');
1585: hr_utility.set_location(l_proc,1000);
1586: end if;
1587: --
1588: end do_new;
1589: --
1599: l_assact_rec pay_jp_isdf_assact_v%rowtype;
1600: begin
1601: --
1602: if g_debug then
1603: hr_utility.set_location(l_proc,0);
1604: end if;
1605: --
1606: l_submission_date := check_submission_period(p_action_information_id);
1607: --
1605: --
1606: l_submission_date := check_submission_period(p_action_information_id);
1607: --
1608: if g_debug then
1609: hr_utility.set_location(l_proc,10);
1610: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1611: end if;
1612: --
1613: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1606: l_submission_date := check_submission_period(p_action_information_id);
1607: --
1608: if g_debug then
1609: hr_utility.set_location(l_proc,10);
1610: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1611: end if;
1612: --
1613: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1614: --
1617: fnd_message.raise_error;
1618: end if;
1619: --
1620: if g_debug then
1621: hr_utility.set_location(l_proc,20);
1622: hr_utility.set_location(l_proc,20);
1623: hr_utility.trace('action_information_id : '||p_action_information_id);
1624: hr_utility.trace('object_version_number : '||p_object_version_number);
1625: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1618: end if;
1619: --
1620: if g_debug then
1621: hr_utility.set_location(l_proc,20);
1622: hr_utility.set_location(l_proc,20);
1623: hr_utility.trace('action_information_id : '||p_action_information_id);
1624: hr_utility.trace('object_version_number : '||p_object_version_number);
1625: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1626: hr_utility.trace('start update_assact');
1619: --
1620: if g_debug then
1621: hr_utility.set_location(l_proc,20);
1622: hr_utility.set_location(l_proc,20);
1623: hr_utility.trace('action_information_id : '||p_action_information_id);
1624: hr_utility.trace('object_version_number : '||p_object_version_number);
1625: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1626: hr_utility.trace('start update_assact');
1627: end if;
1620: if g_debug then
1621: hr_utility.set_location(l_proc,20);
1622: hr_utility.set_location(l_proc,20);
1623: hr_utility.trace('action_information_id : '||p_action_information_id);
1624: hr_utility.trace('object_version_number : '||p_object_version_number);
1625: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1626: hr_utility.trace('start update_assact');
1627: end if;
1628: --
1621: hr_utility.set_location(l_proc,20);
1622: hr_utility.set_location(l_proc,20);
1623: hr_utility.trace('action_information_id : '||p_action_information_id);
1624: hr_utility.trace('object_version_number : '||p_object_version_number);
1625: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1626: hr_utility.trace('start update_assact');
1627: end if;
1628: --
1629: p_object_version_number := l_assact_rec.object_version_number + 1;
1622: hr_utility.set_location(l_proc,20);
1623: hr_utility.trace('action_information_id : '||p_action_information_id);
1624: hr_utility.trace('object_version_number : '||p_object_version_number);
1625: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1626: hr_utility.trace('start update_assact');
1627: end if;
1628: --
1629: p_object_version_number := l_assact_rec.object_version_number + 1;
1630: --
1644: set object_version_number = p_object_version_number
1645: where row_id = l_assact_rec.row_id;
1646: --
1647: if g_debug then
1648: hr_utility.trace('end update_assact');
1649: hr_utility.set_location(l_proc,1000);
1650: end if;
1651: --
1652: end do_apply;
1645: where row_id = l_assact_rec.row_id;
1646: --
1647: if g_debug then
1648: hr_utility.trace('end update_assact');
1649: hr_utility.set_location(l_proc,1000);
1650: end if;
1651: --
1652: end do_apply;
1653: --
1718: --
1719: begin
1720: --
1721: if g_debug then
1722: hr_utility.set_location(l_proc,0);
1723: hr_utility.trace('csr_archive_data bulk collect start');
1724: end if;
1725: --
1726: -- #2243411 bulk collect bug fix is available from 9.2
1719: begin
1720: --
1721: if g_debug then
1722: hr_utility.set_location(l_proc,0);
1723: hr_utility.trace('csr_archive_data bulk collect start');
1724: end if;
1725: --
1726: -- #2243411 bulk collect bug fix is available from 9.2
1727: open csr_archive_data;
1736: end loop;
1737: close csr_archive_data;
1738: --
1739: if g_debug then
1740: hr_utility.set_location(l_proc,10);
1741: hr_utility.trace('csr_archive_data bulk collect end');
1742: hr_utility.trace('csr_archive_data count : '||l_action_info_tbl.count);
1743: end if;
1744: --
1737: close csr_archive_data;
1738: --
1739: if g_debug then
1740: hr_utility.set_location(l_proc,10);
1741: hr_utility.trace('csr_archive_data bulk collect end');
1742: hr_utility.trace('csr_archive_data count : '||l_action_info_tbl.count);
1743: end if;
1744: --
1745: p_calc_total_rec.life_gen := 0;
1738: --
1739: if g_debug then
1740: hr_utility.set_location(l_proc,10);
1741: hr_utility.trace('csr_archive_data bulk collect end');
1742: hr_utility.trace('csr_archive_data count : '||l_action_info_tbl.count);
1743: end if;
1744: --
1745: p_calc_total_rec.life_gen := 0;
1746: p_calc_total_rec.life_pens := 0;
1779: p_calc_total_rec.sp_other_inc_exp_tmp := 0;
1780: p_calc_total_rec.sp_other_inc_exp_tmp_exp := 0;
1781: --
1782: if g_debug then
1783: hr_utility.set_location(l_proc,20);
1784: end if;
1785: --
1786: for i in 1..l_action_info_tbl.count loop
1787: --
1869: --
1870: end loop;
1871: --
1872: if g_debug then
1873: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1874: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1875: hr_utility.trace('life_gen_new : '||to_char(p_calc_total_rec.life_gen_new));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1870: end loop;
1871: --
1872: if g_debug then
1873: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1874: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1875: hr_utility.trace('life_gen_new : '||to_char(p_calc_total_rec.life_gen_new));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1871: --
1872: if g_debug then
1873: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1874: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1875: hr_utility.trace('life_gen_new : '||to_char(p_calc_total_rec.life_gen_new));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1872: if g_debug then
1873: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1874: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1875: hr_utility.trace('life_gen_new : '||to_char(p_calc_total_rec.life_gen_new));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1873: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1874: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1875: hr_utility.trace('life_gen_new : '||to_char(p_calc_total_rec.life_gen_new));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1874: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1875: hr_utility.trace('life_gen_new : '||to_char(p_calc_total_rec.life_gen_new));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1875: hr_utility.trace('life_gen_new : '||to_char(p_calc_total_rec.life_gen_new));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1876: hr_utility.trace('life_pens_new : '||to_char(p_calc_total_rec.life_pens_new));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1877: hr_utility.trace('care_med_new : '||to_char(p_calc_total_rec.care_med_new));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1878: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1879: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1880: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1881: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1882: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1883: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1884: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1885: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1886: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1887: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1888: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1889: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1890: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1891: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1892: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1893: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1894: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1895: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1896: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1897: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1898: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1899: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1907: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1900: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1907: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1908: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1901: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1907: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1908: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1909: hr_utility.set_location(l_proc,1000);
1902: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1907: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1908: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1909: hr_utility.set_location(l_proc,1000);
1910: end if;
1903: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1907: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1908: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1909: hr_utility.set_location(l_proc,1000);
1910: end if;
1911: --
1904: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1907: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1908: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1909: hr_utility.set_location(l_proc,1000);
1910: end if;
1911: --
1912: end calc_total;
1905: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1906: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1907: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1908: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1909: hr_utility.set_location(l_proc,1000);
1910: end if;
1911: --
1912: end calc_total;
1913: --
1944: --
1945: begin
1946: --
1947: if g_debug then
1948: hr_utility.set_location(l_proc,0);
1949: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1950: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1945: begin
1946: --
1947: if g_debug then
1948: hr_utility.set_location(l_proc,0);
1949: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1950: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1946: --
1947: if g_debug then
1948: hr_utility.set_location(l_proc,0);
1949: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1950: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1947: if g_debug then
1948: hr_utility.set_location(l_proc,0);
1949: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1950: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1948: hr_utility.set_location(l_proc,0);
1949: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1950: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1949: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1950: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1950: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1958: hr_utility.trace('i_life_gen_new : '||to_char(i_life_gen_new));
1951: hr_utility.trace('p_life_gen_new_i : '||to_char(p_life_gen_new_i));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1958: hr_utility.trace('i_life_gen_new : '||to_char(i_life_gen_new));
1959: hr_utility.trace('i_life_pens_new : '||to_char(i_life_pens_new));
1952: hr_utility.trace('p_life_pens_new_i : '||to_char(p_life_pens_new_i));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1958: hr_utility.trace('i_life_gen_new : '||to_char(i_life_gen_new));
1959: hr_utility.trace('i_life_pens_new : '||to_char(i_life_pens_new));
1960: hr_utility.trace('i_care_med_new : '||to_char(i_care_med_new));
1953: hr_utility.trace('p_care_med_new_i : '||to_char(p_care_med_new_i));
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1958: hr_utility.trace('i_life_gen_new : '||to_char(i_life_gen_new));
1959: hr_utility.trace('i_life_pens_new : '||to_char(i_life_pens_new));
1960: hr_utility.trace('i_care_med_new : '||to_char(i_care_med_new));
1961: end if;
1954: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1958: hr_utility.trace('i_life_gen_new : '||to_char(i_life_gen_new));
1959: hr_utility.trace('i_life_pens_new : '||to_char(i_life_pens_new));
1960: hr_utility.trace('i_care_med_new : '||to_char(i_care_med_new));
1961: end if;
1962: --
1955: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1958: hr_utility.trace('i_life_gen_new : '||to_char(i_life_gen_new));
1959: hr_utility.trace('i_life_pens_new : '||to_char(i_life_pens_new));
1960: hr_utility.trace('i_care_med_new : '||to_char(i_care_med_new));
1961: end if;
1962: --
1963: -- formula datetrack
1956: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1957: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1958: hr_utility.trace('i_life_gen_new : '||to_char(i_life_gen_new));
1959: hr_utility.trace('i_life_pens_new : '||to_char(i_life_pens_new));
1960: hr_utility.trace('i_care_med_new : '||to_char(i_care_med_new));
1961: end if;
1962: --
1963: -- formula datetrack
1964: if (p_effective_date >= hr_api.g_sot
1964: if (p_effective_date >= hr_api.g_sot
1965: and p_effective_date <= hr_api.g_eot) then
1966: --
1967: if g_debug then
1968: hr_utility.set_location(l_proc,10);
1969: end if;
1970: --
1971: if i_life_gen > 0 then
1972: --
1970: --
1971: if i_life_gen > 0 then
1972: --
1973: if g_debug then
1974: hr_utility.set_location(l_proc,20);
1975: end if;
1976: --
1977: -- udt satisfy validation of max value
1978: o_life_gen := round(i_life_gen
1989: to_char(i_life_gen),
1990: p_effective_date)));
1991: --
1992: if g_debug then
1993: hr_utility.set_location(l_proc,30);
1994: end if;
1995: --
1996: end if;
1997: --
1997: --
1998: if i_life_gen_new > 0 then
1999: --
2000: if g_debug then
2001: hr_utility.set_location(l_proc,40);
2002: end if;
2003: --
2004: -- udt satisfy validation of max value
2005: o_life_gen_new := round(i_life_gen_new
2016: to_char(i_life_gen_new),
2017: p_effective_date)));
2018: --
2019: if g_debug then
2020: hr_utility.set_location(l_proc,45);
2021: end if;
2022: --
2023: end if;
2024:
2025:
2026: if i_care_med_new > 0 then
2027: --
2028: if g_debug then
2029: hr_utility.set_location(l_proc,40);
2030: end if;
2031: --
2032: -- udt satisfy validation of max value
2033: o_care_med_new := round(i_care_med_new
2044: to_char(i_care_med_new),
2045: p_effective_date)));
2046: --
2047: if g_debug then
2048: hr_utility.set_location(l_proc,45);
2049: end if;
2050: --
2051: end if;
2052:
2051: end if;
2052:
2053:
2054: if g_debug then
2055: hr_utility.set_location(l_proc,49);
2056: end if;
2057: --
2058: if i_life_pens > 0 then
2059: --
2057: --
2058: if i_life_pens > 0 then
2059: --
2060: if g_debug then
2061: hr_utility.set_location(l_proc,50);
2062: end if;
2063: --
2064: -- udt satisfy validation of max value
2065: o_life_pens := round(i_life_pens
2076: to_char(i_life_pens),
2077: p_effective_date)));
2078: --
2079: if g_debug then
2080: hr_utility.set_location(l_proc,60);
2081: end if;
2082: --
2083: end if;
2084: --
2084: --
2085: if i_life_pens_new > 0 then
2086: --
2087: if g_debug then
2088: hr_utility.set_location(l_proc,65);
2089: end if;
2090: --
2091: -- udt satisfy validation of max value
2092: o_life_pens_new := round(i_life_pens_new
2103: to_char(i_life_pens_new),
2104: p_effective_date)));
2105: --
2106: if g_debug then
2107: hr_utility.set_location(l_proc,70);
2108: end if;
2109: --
2110: end if;
2111:
2124: p_life_ins_dct_o := o_life_gen + o_life_pens;
2125: end if;
2126: --
2127: if g_debug then
2128: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
2129: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
2130: hr_utility.trace('o_life_gen_new : '||to_char(o_life_gen_new));
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2125: end if;
2126: --
2127: if g_debug then
2128: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
2129: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
2130: hr_utility.trace('o_life_gen_new : '||to_char(o_life_gen_new));
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2126: --
2127: if g_debug then
2128: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
2129: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
2130: hr_utility.trace('o_life_gen_new : '||to_char(o_life_gen_new));
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2127: if g_debug then
2128: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
2129: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
2130: hr_utility.trace('o_life_gen_new : '||to_char(o_life_gen_new));
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2135: hr_utility.trace('p_life_pens_new_o : '||to_char(p_life_pens_new_o));
2128: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
2129: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
2130: hr_utility.trace('o_life_gen_new : '||to_char(o_life_gen_new));
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2135: hr_utility.trace('p_life_pens_new_o : '||to_char(p_life_pens_new_o));
2136: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
2129: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
2130: hr_utility.trace('o_life_gen_new : '||to_char(o_life_gen_new));
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2135: hr_utility.trace('p_life_pens_new_o : '||to_char(p_life_pens_new_o));
2136: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
2137: hr_utility.set_location(l_proc,1000);
2130: hr_utility.trace('o_life_gen_new : '||to_char(o_life_gen_new));
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2135: hr_utility.trace('p_life_pens_new_o : '||to_char(p_life_pens_new_o));
2136: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
2137: hr_utility.set_location(l_proc,1000);
2138: end if;
2131: hr_utility.trace('o_life_pens_new : '||to_char(o_life_pens_new));
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2135: hr_utility.trace('p_life_pens_new_o : '||to_char(p_life_pens_new_o));
2136: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
2137: hr_utility.set_location(l_proc,1000);
2138: end if;
2139: --
2132: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2135: hr_utility.trace('p_life_pens_new_o : '||to_char(p_life_pens_new_o));
2136: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
2137: hr_utility.set_location(l_proc,1000);
2138: end if;
2139: --
2140: end calc_life_ins_dct;
2133: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
2134: hr_utility.trace('p_life_gen_new_o : '||to_char(p_life_gen_new_o));
2135: hr_utility.trace('p_life_pens_new_o : '||to_char(p_life_pens_new_o));
2136: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
2137: hr_utility.set_location(l_proc,1000);
2138: end if;
2139: --
2140: end calc_life_ins_dct;
2141: --
2165: --
2166: begin
2167: --
2168: if g_debug then
2169: hr_utility.set_location(l_proc,0);
2170: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
2171: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2166: begin
2167: --
2168: if g_debug then
2169: hr_utility.set_location(l_proc,0);
2170: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
2171: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2167: --
2168: if g_debug then
2169: hr_utility.set_location(l_proc,0);
2170: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
2171: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2175: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
2168: if g_debug then
2169: hr_utility.set_location(l_proc,0);
2170: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
2171: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2175: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
2176: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
2169: hr_utility.set_location(l_proc,0);
2170: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
2171: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2175: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
2176: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
2177: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
2170: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
2171: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2175: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
2176: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
2177: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
2178: end if;
2171: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2175: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
2176: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
2177: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
2178: end if;
2179: --
2172: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2175: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
2176: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
2177: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
2178: end if;
2179: --
2180: -- formula datetrack
2173: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2174: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2175: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
2176: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
2177: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
2178: end if;
2179: --
2180: -- formula datetrack
2181: if (p_effective_date >= hr_api.g_sot
2181: if (p_effective_date >= hr_api.g_sot
2182: and p_effective_date < c_st_upd_date_2007) then
2183: --
2184: if g_debug then
2185: hr_utility.set_location(l_proc,10);
2186: end if;
2187: --
2188: o_earthquake := null;
2189: --
2189: --
2190: if i_nonlife_long > 0 then
2191: --
2192: if g_debug then
2193: hr_utility.set_location(l_proc,20);
2194: end if;
2195: --
2196: -- udt satisfy validation of max value
2197: o_nonlife_long := round(i_nonlife_long
2208: to_char(i_nonlife_long),
2209: p_effective_date)));
2210: --
2211: if g_debug then
2212: hr_utility.set_location(l_proc,30);
2213: end if;
2214: --
2215: end if;
2216: --
2214: --
2215: end if;
2216: --
2217: if g_debug then
2218: hr_utility.set_location(l_proc,40);
2219: end if;
2220: --
2221: if i_nonlife_short > 0 then
2222: --
2220: --
2221: if i_nonlife_short > 0 then
2222: --
2223: if g_debug then
2224: hr_utility.set_location(l_proc,50);
2225: end if;
2226: --
2227: -- udt satisfy validation of max value
2228: o_nonlife_short := round(i_nonlife_short
2239: to_char(i_nonlife_short),
2240: p_effective_date)));
2241: --
2242: if g_debug then
2243: hr_utility.set_location(l_proc,60);
2244: end if;
2245: --
2246: end if;
2247: --
2261: --
2262: end if;
2263: --
2264: if g_debug then
2265: hr_utility.set_location(l_proc,70);
2266: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2267: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
2268: end if;
2269: --
2262: end if;
2263: --
2264: if g_debug then
2265: hr_utility.set_location(l_proc,70);
2266: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2267: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
2268: end if;
2269: --
2270: if o_nonlife_dct > c_nonlife_max then
2263: --
2264: if g_debug then
2265: hr_utility.set_location(l_proc,70);
2266: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2267: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
2268: end if;
2269: --
2270: if o_nonlife_dct > c_nonlife_max then
2271: o_nonlife_dct := c_nonlife_max;
2271: o_nonlife_dct := c_nonlife_max;
2272: end if;
2273: --
2274: if g_debug then
2275: hr_utility.set_location(l_proc,80);
2276: end if;
2277: --
2278: elsif (p_effective_date >= c_st_upd_date_2007
2279: and p_effective_date <= hr_api.g_eot) then
2278: elsif (p_effective_date >= c_st_upd_date_2007
2279: and p_effective_date <= hr_api.g_eot) then
2280: --
2281: if g_debug then
2282: hr_utility.set_location(l_proc,90);
2283: end if;
2284: --
2285: o_nonlife_short := null;
2286: --
2286: --
2287: if i_earthquake > 0 then
2288: --
2289: if g_debug then
2290: hr_utility.set_location(l_proc,100);
2291: end if;
2292: --
2293: o_earthquake := round(i_earthquake);
2294: if c_earthquake_max is null then
2300: p_effective_date));
2301: end if;
2302: --
2303: if g_debug then
2304: hr_utility.set_location(l_proc,110);
2305: hr_utility.trace('o_earthquake : '||to_char(o_earthquake));
2306: hr_utility.trace('c_earthquake_max : '||to_char(c_earthquake_max));
2307: end if;
2308: --
2301: end if;
2302: --
2303: if g_debug then
2304: hr_utility.set_location(l_proc,110);
2305: hr_utility.trace('o_earthquake : '||to_char(o_earthquake));
2306: hr_utility.trace('c_earthquake_max : '||to_char(c_earthquake_max));
2307: end if;
2308: --
2309: if o_earthquake > c_earthquake_max then
2302: --
2303: if g_debug then
2304: hr_utility.set_location(l_proc,110);
2305: hr_utility.trace('o_earthquake : '||to_char(o_earthquake));
2306: hr_utility.trace('c_earthquake_max : '||to_char(c_earthquake_max));
2307: end if;
2308: --
2309: if o_earthquake > c_earthquake_max then
2310: o_earthquake := c_earthquake_max;
2310: o_earthquake := c_earthquake_max;
2311: end if;
2312: --
2313: if g_debug then
2314: hr_utility.set_location(l_proc,120);
2315: end if;
2316: --
2317: end if;
2318: --
2318: --
2319: if i_nonlife_long > 0 then
2320: --
2321: if g_debug then
2322: hr_utility.set_location(l_proc,130);
2323: end if;
2324: --
2325: -- udt satisfy validation of max value
2326: o_nonlife_long := round(i_nonlife_long
2337: to_char(i_nonlife_long),
2338: p_effective_date)));
2339: --
2340: if g_debug then
2341: hr_utility.set_location(l_proc,140);
2342: end if;
2343: --
2344: end if;
2345: --
2343: --
2344: end if;
2345: --
2346: if g_debug then
2347: hr_utility.set_location(l_proc,150);
2348: end if;
2349: --
2350: o_nonlife_dct := o_earthquake + o_nonlife_long;
2351: --
2363: --
2364: end if;
2365: --
2366: if g_debug then
2367: hr_utility.set_location(l_proc,160);
2368: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2369: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
2370: end if;
2371: --
2364: end if;
2365: --
2366: if g_debug then
2367: hr_utility.set_location(l_proc,160);
2368: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2369: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
2370: end if;
2371: --
2372: if o_nonlife_dct > c_nonlife_max then
2365: --
2366: if g_debug then
2367: hr_utility.set_location(l_proc,160);
2368: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2369: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
2370: end if;
2371: --
2372: if o_nonlife_dct > c_nonlife_max then
2373: o_nonlife_dct := c_nonlife_max;
2373: o_nonlife_dct := c_nonlife_max;
2374: end if;
2375: --
2376: if g_debug then
2377: hr_utility.set_location(l_proc,170);
2378: end if;
2379: --
2380: end if;
2381: --
2384: p_nonlife_short_o := o_nonlife_short;
2385: p_nonlife_dct_o := o_nonlife_dct;
2386: --
2387: if g_debug then
2388: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
2389: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
2390: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2385: p_nonlife_dct_o := o_nonlife_dct;
2386: --
2387: if g_debug then
2388: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
2389: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
2390: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2393: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
2386: --
2387: if g_debug then
2388: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
2389: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
2390: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2393: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
2394: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2387: if g_debug then
2388: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
2389: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
2390: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2393: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
2394: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2395: hr_utility.set_location(l_proc,1000);
2388: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
2389: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
2390: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2393: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
2394: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2395: hr_utility.set_location(l_proc,1000);
2396: end if;
2389: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
2390: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2393: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
2394: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2395: hr_utility.set_location(l_proc,1000);
2396: end if;
2397: --
2390: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2393: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
2394: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2395: hr_utility.set_location(l_proc,1000);
2396: end if;
2397: --
2398: end calc_nonlife_dct;
2391: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
2392: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
2393: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
2394: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
2395: hr_utility.set_location(l_proc,1000);
2396: end if;
2397: --
2398: end calc_nonlife_dct;
2399: --
2419: --
2420: begin
2421: --
2422: if g_debug then
2423: hr_utility.set_location(l_proc,0);
2424: hr_utility.trace('calc_nonlife_dct wrapper');
2425: end if;
2426: --
2427: if (p_effective_date >= hr_api.g_sot
2420: begin
2421: --
2422: if g_debug then
2423: hr_utility.set_location(l_proc,0);
2424: hr_utility.trace('calc_nonlife_dct wrapper');
2425: end if;
2426: --
2427: if (p_effective_date >= hr_api.g_sot
2428: and p_effective_date < c_st_upd_date_2007) then
2427: if (p_effective_date >= hr_api.g_sot
2428: and p_effective_date < c_st_upd_date_2007) then
2429: --
2430: if g_debug then
2431: hr_utility.set_location(l_proc,10);
2432: end if;
2433: --
2434: calc_nonlife_dct(
2435: p_earthquake_i => p_earthquake_i,
2448: p_nonlife_long_o := o_nonlife_long;
2449: p_nonlife_dct_o := o_nonlife_dct;
2450: --
2451: if g_debug then
2452: hr_utility.set_location(l_proc,1000);
2453: end if;
2454: --
2455: end calc_nonlife_dct;
2456: --
2470: --
2471: begin
2472: --
2473: if g_debug then
2474: hr_utility.set_location(l_proc,0);
2475: hr_utility.trace('p_social_i : '||to_char(p_social_i));
2476: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2477: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2478: hr_utility.trace('i_social : '||to_char(i_social));
2471: begin
2472: --
2473: if g_debug then
2474: hr_utility.set_location(l_proc,0);
2475: hr_utility.trace('p_social_i : '||to_char(p_social_i));
2476: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2477: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2478: hr_utility.trace('i_social : '||to_char(i_social));
2479: end if;
2472: --
2473: if g_debug then
2474: hr_utility.set_location(l_proc,0);
2475: hr_utility.trace('p_social_i : '||to_char(p_social_i));
2476: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2477: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2478: hr_utility.trace('i_social : '||to_char(i_social));
2479: end if;
2480: --
2473: if g_debug then
2474: hr_utility.set_location(l_proc,0);
2475: hr_utility.trace('p_social_i : '||to_char(p_social_i));
2476: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2477: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2478: hr_utility.trace('i_social : '||to_char(i_social));
2479: end if;
2480: --
2481: -- formula datetrack
2474: hr_utility.set_location(l_proc,0);
2475: hr_utility.trace('p_social_i : '||to_char(p_social_i));
2476: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2477: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2478: hr_utility.trace('i_social : '||to_char(i_social));
2479: end if;
2480: --
2481: -- formula datetrack
2482: if (p_effective_date >= hr_api.g_sot
2482: if (p_effective_date >= hr_api.g_sot
2483: and p_effective_date <= hr_api.g_eot) then
2484: --
2485: if g_debug then
2486: hr_utility.set_location(l_proc,10);
2487: end if;
2488: --
2489: if i_social < 0 then
2490: --
2488: --
2489: if i_social < 0 then
2490: --
2491: if g_debug then
2492: hr_utility.set_location(l_proc,20);
2493: end if;
2494: --
2495: o_social_dct := 0;
2496: --
2498: --
2499: o_social_dct := round(i_social);
2500: --
2501: if g_debug then
2502: hr_utility.set_location(l_proc,30);
2503: end if;
2504: --
2505: end if;
2506: --
2508: --
2509: p_social_dct_o := o_social_dct;
2510: --
2511: if g_debug then
2512: hr_utility.trace('p_social_dct_o : '||to_char(p_social_dct_o));
2513: hr_utility.trace('o_social_dct : '||to_char(o_social_dct));
2514: hr_utility.set_location(l_proc,1000);
2515: end if;
2516: --
2509: p_social_dct_o := o_social_dct;
2510: --
2511: if g_debug then
2512: hr_utility.trace('p_social_dct_o : '||to_char(p_social_dct_o));
2513: hr_utility.trace('o_social_dct : '||to_char(o_social_dct));
2514: hr_utility.set_location(l_proc,1000);
2515: end if;
2516: --
2517: end calc_social_dct;
2510: --
2511: if g_debug then
2512: hr_utility.trace('p_social_dct_o : '||to_char(p_social_dct_o));
2513: hr_utility.trace('o_social_dct : '||to_char(o_social_dct));
2514: hr_utility.set_location(l_proc,1000);
2515: end if;
2516: --
2517: end calc_social_dct;
2518: --
2536: --
2537: begin
2538: --
2539: if g_debug then
2540: hr_utility.set_location(l_proc,0);
2541: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2542: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2537: begin
2538: --
2539: if g_debug then
2540: hr_utility.set_location(l_proc,0);
2541: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2542: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2538: --
2539: if g_debug then
2540: hr_utility.set_location(l_proc,0);
2541: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2542: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2546: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2539: if g_debug then
2540: hr_utility.set_location(l_proc,0);
2541: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2542: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2546: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2547: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2540: hr_utility.set_location(l_proc,0);
2541: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2542: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2546: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2547: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2548: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2541: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2542: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2546: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2547: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2548: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2549: end if;
2542: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2546: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2547: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2548: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2549: end if;
2550: --
2543: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2546: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2547: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2548: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2549: end if;
2550: --
2551: -- formula datetrack
2544: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2545: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2546: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2547: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2548: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2549: end if;
2550: --
2551: -- formula datetrack
2552: if (p_effective_date >= hr_api.g_sot
2552: if (p_effective_date >= hr_api.g_sot
2553: and p_effective_date <= hr_api.g_eot) then
2554: --
2555: if g_debug then
2556: hr_utility.set_location(l_proc,10);
2557: end if;
2558: --
2559: o_mutual_aid_dct := round(i_mutual_aid_ec + i_mutual_aid_p + i_mutual_aid_dsc);
2560: --
2562: --
2563: p_mutual_aid_dct_o := o_mutual_aid_dct;
2564: --
2565: if g_debug then
2566: hr_utility.trace('p_mutual_aid_dct_o : '||to_char(p_mutual_aid_dct_o));
2567: hr_utility.trace('o_mutual_aid_dct : '||to_char(o_mutual_aid_dct));
2568: hr_utility.set_location(l_proc,1000);
2569: end if;
2570: --
2563: p_mutual_aid_dct_o := o_mutual_aid_dct;
2564: --
2565: if g_debug then
2566: hr_utility.trace('p_mutual_aid_dct_o : '||to_char(p_mutual_aid_dct_o));
2567: hr_utility.trace('o_mutual_aid_dct : '||to_char(o_mutual_aid_dct));
2568: hr_utility.set_location(l_proc,1000);
2569: end if;
2570: --
2571: end calc_mutual_aid_dct;
2564: --
2565: if g_debug then
2566: hr_utility.trace('p_mutual_aid_dct_o : '||to_char(p_mutual_aid_dct_o));
2567: hr_utility.trace('o_mutual_aid_dct : '||to_char(o_mutual_aid_dct));
2568: hr_utility.set_location(l_proc,1000);
2569: end if;
2570: --
2571: end calc_mutual_aid_dct;
2572: --
2619: -- (At the calculated time, system cannot know final eev data at the yea runtime,
2620: -- so the result by this calculation might be different from final yea run result.)
2621: --
2622: if g_debug then
2623: hr_utility.set_location(l_proc,0);
2624: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2625: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2620: -- so the result by this calculation might be different from final yea run result.)
2621: --
2622: if g_debug then
2623: hr_utility.set_location(l_proc,0);
2624: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2625: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2621: --
2622: if g_debug then
2623: hr_utility.set_location(l_proc,0);
2624: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2625: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2622: if g_debug then
2623: hr_utility.set_location(l_proc,0);
2624: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2625: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2623: hr_utility.set_location(l_proc,0);
2624: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2625: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2631: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2624: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2625: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2631: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2632: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2625: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2631: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2632: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2633: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2626: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2631: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2632: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2633: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2634: end if;
2627: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2631: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2632: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2633: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2634: end if;
2635: --
2628: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2631: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2632: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2633: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2634: end if;
2635: --
2636: -- formula datetrack
2629: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2630: hr_utility.trace('following are just information');
2631: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2632: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2633: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2634: end if;
2635: --
2636: -- formula datetrack
2637: if (p_effective_date >= hr_api.g_sot
2637: if (p_effective_date >= hr_api.g_sot
2638: and p_effective_date <= hr_api.g_eot) then
2639: --
2640: if g_debug then
2641: hr_utility.set_location(l_proc,10);
2642: end if;
2643: --
2644: if nvl(p_spouse_income_i,0) > 0
2645: and nvl(p_dct_exc_i,'N') = 'N' then
2644: if nvl(p_spouse_income_i,0) > 0
2645: and nvl(p_dct_exc_i,'N') = 'N' then
2646: --
2647: if g_debug then
2648: hr_utility.set_location(l_proc,20);
2649: end if;
2650: --
2651: if c_emp_income_max is null then
2652: --
2657: c_sp_emp_income_udtrow,
2658: p_effective_date));
2659: --
2660: if g_debug then
2661: hr_utility.set_location(l_proc,30);
2662: hr_utility.trace('c_emp_income_max : '||to_char(c_emp_income_max));
2663: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2664: end if;
2665: --
2658: p_effective_date));
2659: --
2660: if g_debug then
2661: hr_utility.set_location(l_proc,30);
2662: hr_utility.trace('c_emp_income_max : '||to_char(c_emp_income_max));
2663: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2664: end if;
2665: --
2666: end if;
2659: --
2660: if g_debug then
2661: hr_utility.set_location(l_proc,30);
2662: hr_utility.trace('c_emp_income_max : '||to_char(c_emp_income_max));
2663: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2664: end if;
2665: --
2666: end if;
2667: --
2670: -- calculate when sp_type is null since eev might be set in future.
2671: and nvl(p_sp_type_i,'1') <> '0' then
2672: --
2673: if g_debug then
2674: hr_utility.set_location(l_proc,40);
2675: end if;
2676: --
2677: if c_inc_spouse_dct_max is null then
2678: --
2683: c_sp_dctable_sp_income_udtrow,
2684: p_effective_date));
2685: --
2686: if g_debug then
2687: hr_utility.set_location(l_proc,50);
2688: hr_utility.trace('c_inc_spouse_dct_max : '||to_char(c_inc_spouse_dct_max));
2689: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2690: end if;
2691: --
2684: p_effective_date));
2685: --
2686: if g_debug then
2687: hr_utility.set_location(l_proc,50);
2688: hr_utility.trace('c_inc_spouse_dct_max : '||to_char(c_inc_spouse_dct_max));
2689: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2690: end if;
2691: --
2692: end if;
2685: --
2686: if g_debug then
2687: hr_utility.set_location(l_proc,50);
2688: hr_utility.trace('c_inc_spouse_dct_max : '||to_char(c_inc_spouse_dct_max));
2689: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2690: end if;
2691: --
2692: end if;
2693: --
2694: -- even spouse_type is 2,3, if over inc_spouse_dct_max, they can be deductive for sp_spouse_dct.
2695: if i_spouse_income > c_inc_spouse_dct_max then
2696: --
2697: if g_debug then
2698: hr_utility.set_location(l_proc,60);
2699: end if;
2700: --
2701: if c_spouse_income_max is null then
2702: --
2709: --
2710: end if;
2711: --
2712: if g_debug then
2713: hr_utility.set_location(l_proc,70);
2714: hr_utility.trace('c_spouse_income_max : '||to_char(c_spouse_income_max));
2715: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2716: end if;
2717: --
2710: end if;
2711: --
2712: if g_debug then
2713: hr_utility.set_location(l_proc,70);
2714: hr_utility.trace('c_spouse_income_max : '||to_char(c_spouse_income_max));
2715: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2716: end if;
2717: --
2718: if i_spouse_income < c_spouse_income_max then
2711: --
2712: if g_debug then
2713: hr_utility.set_location(l_proc,70);
2714: hr_utility.trace('c_spouse_income_max : '||to_char(c_spouse_income_max));
2715: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2716: end if;
2717: --
2718: if i_spouse_income < c_spouse_income_max then
2719: --
2724: to_char(i_spouse_income),
2725: p_effective_date)));
2726: --
2727: if g_debug then
2728: hr_utility.set_location(l_proc,80);
2729: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2730: end if;
2731: --
2732: end if;
2725: p_effective_date)));
2726: --
2727: if g_debug then
2728: hr_utility.set_location(l_proc,80);
2729: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2730: end if;
2731: --
2732: end if;
2733: --
2741: --
2742: p_spouse_dct_o := o_spouse_dct;
2743: --
2744: if g_debug then
2745: hr_utility.trace('p_spouse_dct_o : '||to_char(p_spouse_dct_o));
2746: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2747: hr_utility.set_location(l_proc,1000);
2748: end if;
2749: --
2742: p_spouse_dct_o := o_spouse_dct;
2743: --
2744: if g_debug then
2745: hr_utility.trace('p_spouse_dct_o : '||to_char(p_spouse_dct_o));
2746: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2747: hr_utility.set_location(l_proc,1000);
2748: end if;
2749: --
2750: end calc_spouse_dct;
2743: --
2744: if g_debug then
2745: hr_utility.trace('p_spouse_dct_o : '||to_char(p_spouse_dct_o));
2746: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2747: hr_utility.set_location(l_proc,1000);
2748: end if;
2749: --
2750: end calc_spouse_dct;
2751: --
2783: --
2784: begin
2785: --
2786: if g_debug then
2787: hr_utility.set_location(l_proc,0);
2788: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2789: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2784: begin
2785: --
2786: if g_debug then
2787: hr_utility.set_location(l_proc,0);
2788: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2789: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2785: --
2786: if g_debug then
2787: hr_utility.set_location(l_proc,0);
2788: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2789: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2786: if g_debug then
2787: hr_utility.set_location(l_proc,0);
2788: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2789: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2787: hr_utility.set_location(l_proc,0);
2788: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2789: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2788: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2789: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2789: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2790: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2791: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2792: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2793: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2794: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2795: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2796: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2804: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2797: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2804: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2805: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2798: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2804: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2805: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2806: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2799: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2804: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2805: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2806: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2807: end if;
2800: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2804: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2805: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2806: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2807: end if;
2808: --
2801: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2804: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2805: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2806: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2807: end if;
2808: --
2809: p_calc_spouse_inc_rec.sp_earned_inc_calc := 0;
2802: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2803: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2804: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2805: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2806: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2807: end if;
2808: --
2809: p_calc_spouse_inc_rec.sp_earned_inc_calc := 0;
2810: p_calc_spouse_inc_rec.sp_business_inc_calc := 0;
2895: --
2896: end if;
2897: --
2898: if g_debug then
2899: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2900: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2901: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2896: end if;
2897: --
2898: if g_debug then
2899: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2900: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2901: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2897: --
2898: if g_debug then
2899: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2900: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2901: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2898: if g_debug then
2899: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2900: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2901: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2899: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2900: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2901: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2900: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2901: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2908: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2901: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2908: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2909: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2902: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2908: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2909: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2910: hr_utility.set_location(l_proc,1000);
2903: hr_utility.trace('p_calc_spouse_inc_rec.sp_real_estate_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_real_estate_inc_calc));
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2908: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2909: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2910: hr_utility.set_location(l_proc,1000);
2911: end if;
2904: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2908: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2909: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2910: hr_utility.set_location(l_proc,1000);
2911: end if;
2912: --
2905: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2908: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2909: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2910: hr_utility.set_location(l_proc,1000);
2911: end if;
2912: --
2913: p_spouse_inc_o := o_spouse_inc;
2906: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2907: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2908: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2909: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2910: hr_utility.set_location(l_proc,1000);
2911: end if;
2912: --
2913: p_spouse_inc_o := o_spouse_inc;
2914: --
2943: --
2944: begin
2945: --
2946: if g_debug then
2947: hr_utility.set_location(l_proc,0);
2948: end if;
2949: --
2950: calc_total(
2951: p_assignment_action_id => p_assignment_action_id,
3062: --
3063: end if;
3064: --
3065: if g_debug then
3066: hr_utility.trace('end update_assact');
3067: hr_utility.set_location(l_proc,1000);
3068: end if;
3069: --
3070: end calc_dct;
3063: end if;
3064: --
3065: if g_debug then
3066: hr_utility.trace('end update_assact');
3067: hr_utility.set_location(l_proc,1000);
3068: end if;
3069: --
3070: end calc_dct;
3071: --
3107: --
3108: begin
3109: --
3110: if g_debug then
3111: hr_utility.set_location(l_proc,0);
3112: end if;
3113: --
3114: l_submission_date := check_submission_period(p_action_information_id);
3115: --
3113: --
3114: l_submission_date := check_submission_period(p_action_information_id);
3115: --
3116: if g_debug then
3117: hr_utility.set_location(l_proc,10);
3118: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3119: end if;
3120: --
3121: -- unnecessary to lock
3114: l_submission_date := check_submission_period(p_action_information_id);
3115: --
3116: if g_debug then
3117: hr_utility.set_location(l_proc,10);
3118: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3119: end if;
3120: --
3121: -- unnecessary to lock
3122: select *
3129: fnd_message.raise_error;
3130: end if;
3131: --
3132: if g_debug then
3133: hr_utility.set_location(l_proc,20);
3134: hr_utility.trace('action_information_id : '||p_action_information_id);
3135: hr_utility.trace('object_version_number : '||p_object_version_number);
3136: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3137: hr_utility.trace('start calc_ins');
3130: end if;
3131: --
3132: if g_debug then
3133: hr_utility.set_location(l_proc,20);
3134: hr_utility.trace('action_information_id : '||p_action_information_id);
3135: hr_utility.trace('object_version_number : '||p_object_version_number);
3136: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3137: hr_utility.trace('start calc_ins');
3138: end if;
3131: --
3132: if g_debug then
3133: hr_utility.set_location(l_proc,20);
3134: hr_utility.trace('action_information_id : '||p_action_information_id);
3135: hr_utility.trace('object_version_number : '||p_object_version_number);
3136: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3137: hr_utility.trace('start calc_ins');
3138: end if;
3139: --
3132: if g_debug then
3133: hr_utility.set_location(l_proc,20);
3134: hr_utility.trace('action_information_id : '||p_action_information_id);
3135: hr_utility.trace('object_version_number : '||p_object_version_number);
3136: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3137: hr_utility.trace('start calc_ins');
3138: end if;
3139: --
3140: calc_dct(
3133: hr_utility.set_location(l_proc,20);
3134: hr_utility.trace('action_information_id : '||p_action_information_id);
3135: hr_utility.trace('object_version_number : '||p_object_version_number);
3136: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3137: hr_utility.trace('start calc_ins');
3138: end if;
3139: --
3140: calc_dct(
3141: p_assignment_action_id => l_assact_rec.assignment_action_id,
3270: --
3271: end if;
3272: --
3273: if g_debug then
3274: hr_utility.trace('end update_assact');
3275: hr_utility.set_location(l_proc,1000);
3276: end if;
3277: --
3278: end do_calculate;
3271: end if;
3272: --
3273: if g_debug then
3274: hr_utility.trace('end update_assact');
3275: hr_utility.set_location(l_proc,1000);
3276: end if;
3277: --
3278: end do_calculate;
3279: --
3327: --
3328: begin
3329: --
3330: if g_debug then
3331: hr_utility.set_location(l_proc,0);
3332: end if;
3333: --
3334: l_submission_date := check_submission_period(p_action_information_id);
3335: --
3333: --
3334: l_submission_date := check_submission_period(p_action_information_id);
3335: --
3336: if g_debug then
3337: hr_utility.set_location(l_proc,10);
3338: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3339: end if;
3340: --
3341: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3334: l_submission_date := check_submission_period(p_action_information_id);
3335: --
3336: if g_debug then
3337: hr_utility.set_location(l_proc,10);
3338: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3339: end if;
3340: --
3341: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3342: --
3345: fnd_message.raise_error;
3346: end if;
3347: --
3348: if g_debug then
3349: hr_utility.set_location(l_proc,20);
3350: hr_utility.trace('action_information_id : '||p_action_information_id);
3351: hr_utility.trace('object_version_number : '||p_object_version_number);
3352: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3353: hr_utility.trace('start calc_dct before finalize');
3346: end if;
3347: --
3348: if g_debug then
3349: hr_utility.set_location(l_proc,20);
3350: hr_utility.trace('action_information_id : '||p_action_information_id);
3351: hr_utility.trace('object_version_number : '||p_object_version_number);
3352: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3353: hr_utility.trace('start calc_dct before finalize');
3354: end if;
3347: --
3348: if g_debug then
3349: hr_utility.set_location(l_proc,20);
3350: hr_utility.trace('action_information_id : '||p_action_information_id);
3351: hr_utility.trace('object_version_number : '||p_object_version_number);
3352: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3353: hr_utility.trace('start calc_dct before finalize');
3354: end if;
3355: --
3348: if g_debug then
3349: hr_utility.set_location(l_proc,20);
3350: hr_utility.trace('action_information_id : '||p_action_information_id);
3351: hr_utility.trace('object_version_number : '||p_object_version_number);
3352: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3353: hr_utility.trace('start calc_dct before finalize');
3354: end if;
3355: --
3356: calc_dct(
3349: hr_utility.set_location(l_proc,20);
3350: hr_utility.trace('action_information_id : '||p_action_information_id);
3351: hr_utility.trace('object_version_number : '||p_object_version_number);
3352: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3353: hr_utility.trace('start calc_dct before finalize');
3354: end if;
3355: --
3356: calc_dct(
3357: p_assignment_action_id => l_assact_rec.assignment_action_id,
3612: --
3613: end if;
3614: --
3615: if g_debug then
3616: hr_utility.set_location(l_proc,20);
3617: hr_utility.trace('end calc_dct before finalize');
3618: end if;
3619: --
3620: if g_debug then
3613: end if;
3614: --
3615: if g_debug then
3616: hr_utility.set_location(l_proc,20);
3617: hr_utility.trace('end calc_dct before finalize');
3618: end if;
3619: --
3620: if g_debug then
3621: hr_utility.set_location(l_proc,20);
3617: hr_utility.trace('end calc_dct before finalize');
3618: end if;
3619: --
3620: if g_debug then
3621: hr_utility.set_location(l_proc,20);
3622: hr_utility.trace('action_information_id : '||p_action_information_id);
3623: hr_utility.trace('object_version_number : '||p_object_version_number);
3624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3625: hr_utility.trace('start update_assact');
3618: end if;
3619: --
3620: if g_debug then
3621: hr_utility.set_location(l_proc,20);
3622: hr_utility.trace('action_information_id : '||p_action_information_id);
3623: hr_utility.trace('object_version_number : '||p_object_version_number);
3624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3625: hr_utility.trace('start update_assact');
3626: end if;
3619: --
3620: if g_debug then
3621: hr_utility.set_location(l_proc,20);
3622: hr_utility.trace('action_information_id : '||p_action_information_id);
3623: hr_utility.trace('object_version_number : '||p_object_version_number);
3624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3625: hr_utility.trace('start update_assact');
3626: end if;
3627: --
3620: if g_debug then
3621: hr_utility.set_location(l_proc,20);
3622: hr_utility.trace('action_information_id : '||p_action_information_id);
3623: hr_utility.trace('object_version_number : '||p_object_version_number);
3624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3625: hr_utility.trace('start update_assact');
3626: end if;
3627: --
3628: p_object_version_number := l_assact_rec.object_version_number + 1;
3621: hr_utility.set_location(l_proc,20);
3622: hr_utility.trace('action_information_id : '||p_action_information_id);
3623: hr_utility.trace('object_version_number : '||p_object_version_number);
3624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3625: hr_utility.trace('start update_assact');
3626: end if;
3627: --
3628: p_object_version_number := l_assact_rec.object_version_number + 1;
3629: --
3647: user_comments = p_user_comments
3648: where row_id = l_assact_rec.row_id;
3649: --
3650: if g_debug then
3651: hr_utility.trace('end update_assact');
3652: hr_utility.set_location(l_proc,1000);
3653: end if;
3654: --
3655: end do_finalize;
3648: where row_id = l_assact_rec.row_id;
3649: --
3650: if g_debug then
3651: hr_utility.trace('end update_assact');
3652: hr_utility.set_location(l_proc,1000);
3653: end if;
3654: --
3655: end do_finalize;
3656: --
3669: --
3670: begin
3671: --
3672: if g_debug then
3673: hr_utility.set_location(l_proc,0);
3674: end if;
3675: --
3676: l_submission_date := check_submission_period(p_action_information_id);
3677: --
3675: --
3676: l_submission_date := check_submission_period(p_action_information_id);
3677: --
3678: if g_debug then
3679: hr_utility.set_location(l_proc,10);
3680: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3681: end if;
3682: --
3683: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3676: l_submission_date := check_submission_period(p_action_information_id);
3677: --
3678: if g_debug then
3679: hr_utility.set_location(l_proc,10);
3680: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3681: end if;
3682: --
3683: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3684: --
3690: fnd_message.raise_error;
3691: end if;
3692: --
3693: if g_debug then
3694: hr_utility.set_location(l_proc,20);
3695: hr_utility.trace('action_information_id : '||p_action_information_id);
3696: hr_utility.trace('object_version_number : '||p_object_version_number);
3697: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3698: hr_utility.trace('start calc_dct before finalize');
3691: end if;
3692: --
3693: if g_debug then
3694: hr_utility.set_location(l_proc,20);
3695: hr_utility.trace('action_information_id : '||p_action_information_id);
3696: hr_utility.trace('object_version_number : '||p_object_version_number);
3697: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3698: hr_utility.trace('start calc_dct before finalize');
3699: end if;
3692: --
3693: if g_debug then
3694: hr_utility.set_location(l_proc,20);
3695: hr_utility.trace('action_information_id : '||p_action_information_id);
3696: hr_utility.trace('object_version_number : '||p_object_version_number);
3697: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3698: hr_utility.trace('start calc_dct before finalize');
3699: end if;
3700: --
3693: if g_debug then
3694: hr_utility.set_location(l_proc,20);
3695: hr_utility.trace('action_information_id : '||p_action_information_id);
3696: hr_utility.trace('object_version_number : '||p_object_version_number);
3697: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3698: hr_utility.trace('start calc_dct before finalize');
3699: end if;
3700: --
3701: delete
3694: hr_utility.set_location(l_proc,20);
3695: hr_utility.trace('action_information_id : '||p_action_information_id);
3696: hr_utility.trace('object_version_number : '||p_object_version_number);
3697: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3698: hr_utility.trace('start calc_dct before finalize');
3699: end if;
3700: --
3701: delete
3702: from pay_action_information
3704: and action_context_type = 'AAP'
3705: and action_information_category <> 'JP_ISDF_ASSACT';
3706: --
3707: if g_debug then
3708: hr_utility.set_location(l_proc,20);
3709: hr_utility.trace('action_information_id : '||p_action_information_id);
3710: hr_utility.trace('object_version_number : '||p_object_version_number);
3711: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3712: hr_utility.trace('start update_assact');
3705: and action_information_category <> 'JP_ISDF_ASSACT';
3706: --
3707: if g_debug then
3708: hr_utility.set_location(l_proc,20);
3709: hr_utility.trace('action_information_id : '||p_action_information_id);
3710: hr_utility.trace('object_version_number : '||p_object_version_number);
3711: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3712: hr_utility.trace('start update_assact');
3713: end if;
3706: --
3707: if g_debug then
3708: hr_utility.set_location(l_proc,20);
3709: hr_utility.trace('action_information_id : '||p_action_information_id);
3710: hr_utility.trace('object_version_number : '||p_object_version_number);
3711: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3712: hr_utility.trace('start update_assact');
3713: end if;
3714: --
3707: if g_debug then
3708: hr_utility.set_location(l_proc,20);
3709: hr_utility.trace('action_information_id : '||p_action_information_id);
3710: hr_utility.trace('object_version_number : '||p_object_version_number);
3711: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3712: hr_utility.trace('start update_assact');
3713: end if;
3714: --
3715: p_object_version_number := l_assact_rec.object_version_number + 1;
3708: hr_utility.set_location(l_proc,20);
3709: hr_utility.trace('action_information_id : '||p_action_information_id);
3710: hr_utility.trace('object_version_number : '||p_object_version_number);
3711: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3712: hr_utility.trace('start update_assact');
3713: end if;
3714: --
3715: p_object_version_number := l_assact_rec.object_version_number + 1;
3716: --
3734: admin_comments = p_admin_comments
3735: where row_id = l_assact_rec.row_id;
3736: --
3737: if g_debug then
3738: hr_utility.trace('end update_assact');
3739: hr_utility.set_location(l_proc,1000);
3740: end if;
3741: --
3742: end do_reject;
3735: where row_id = l_assact_rec.row_id;
3736: --
3737: if g_debug then
3738: hr_utility.trace('end update_assact');
3739: hr_utility.set_location(l_proc,1000);
3740: end if;
3741: --
3742: end do_reject;
3743: --
3756: --
3757: begin
3758: --
3759: if g_debug then
3760: hr_utility.set_location(l_proc,0);
3761: end if;
3762: --
3763: l_submission_date := check_submission_period(p_action_information_id);
3764: --
3762: --
3763: l_submission_date := check_submission_period(p_action_information_id);
3764: --
3765: if g_debug then
3766: hr_utility.set_location(l_proc,10);
3767: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3768: end if;
3769: --
3770: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3763: l_submission_date := check_submission_period(p_action_information_id);
3764: --
3765: if g_debug then
3766: hr_utility.set_location(l_proc,10);
3767: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3768: end if;
3769: --
3770: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3771: --
3777: fnd_message.raise_error;
3778: end if;
3779: --
3780: if g_debug then
3781: hr_utility.set_location(l_proc,20);
3782: hr_utility.trace('action_information_id : '||p_action_information_id);
3783: hr_utility.trace('object_version_number : '||p_object_version_number);
3784: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3785: hr_utility.trace('start calc_dct before finalize');
3778: end if;
3779: --
3780: if g_debug then
3781: hr_utility.set_location(l_proc,20);
3782: hr_utility.trace('action_information_id : '||p_action_information_id);
3783: hr_utility.trace('object_version_number : '||p_object_version_number);
3784: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3785: hr_utility.trace('start calc_dct before finalize');
3786: end if;
3779: --
3780: if g_debug then
3781: hr_utility.set_location(l_proc,20);
3782: hr_utility.trace('action_information_id : '||p_action_information_id);
3783: hr_utility.trace('object_version_number : '||p_object_version_number);
3784: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3785: hr_utility.trace('start calc_dct before finalize');
3786: end if;
3787: --
3780: if g_debug then
3781: hr_utility.set_location(l_proc,20);
3782: hr_utility.trace('action_information_id : '||p_action_information_id);
3783: hr_utility.trace('object_version_number : '||p_object_version_number);
3784: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3785: hr_utility.trace('start calc_dct before finalize');
3786: end if;
3787: --
3788: if g_debug then
3781: hr_utility.set_location(l_proc,20);
3782: hr_utility.trace('action_information_id : '||p_action_information_id);
3783: hr_utility.trace('object_version_number : '||p_object_version_number);
3784: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3785: hr_utility.trace('start calc_dct before finalize');
3786: end if;
3787: --
3788: if g_debug then
3789: hr_utility.set_location(l_proc,20);
3785: hr_utility.trace('start calc_dct before finalize');
3786: end if;
3787: --
3788: if g_debug then
3789: hr_utility.set_location(l_proc,20);
3790: hr_utility.trace('action_information_id : '||p_action_information_id);
3791: hr_utility.trace('object_version_number : '||p_object_version_number);
3792: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3793: hr_utility.trace('start update_assact');
3786: end if;
3787: --
3788: if g_debug then
3789: hr_utility.set_location(l_proc,20);
3790: hr_utility.trace('action_information_id : '||p_action_information_id);
3791: hr_utility.trace('object_version_number : '||p_object_version_number);
3792: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3793: hr_utility.trace('start update_assact');
3794: end if;
3787: --
3788: if g_debug then
3789: hr_utility.set_location(l_proc,20);
3790: hr_utility.trace('action_information_id : '||p_action_information_id);
3791: hr_utility.trace('object_version_number : '||p_object_version_number);
3792: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3793: hr_utility.trace('start update_assact');
3794: end if;
3795: --
3788: if g_debug then
3789: hr_utility.set_location(l_proc,20);
3790: hr_utility.trace('action_information_id : '||p_action_information_id);
3791: hr_utility.trace('object_version_number : '||p_object_version_number);
3792: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3793: hr_utility.trace('start update_assact');
3794: end if;
3795: --
3796: p_object_version_number := l_assact_rec.object_version_number + 1;
3789: hr_utility.set_location(l_proc,20);
3790: hr_utility.trace('action_information_id : '||p_action_information_id);
3791: hr_utility.trace('object_version_number : '||p_object_version_number);
3792: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3793: hr_utility.trace('start update_assact');
3794: end if;
3795: --
3796: p_object_version_number := l_assact_rec.object_version_number + 1;
3797: --
3815: admin_comments = p_admin_comments
3816: where row_id = l_assact_rec.row_id;
3817: --
3818: if g_debug then
3819: hr_utility.trace('end update_assact');
3820: hr_utility.set_location(l_proc,1000);
3821: end if;
3822: --
3823: end do_return;
3816: where row_id = l_assact_rec.row_id;
3817: --
3818: if g_debug then
3819: hr_utility.trace('end update_assact');
3820: hr_utility.set_location(l_proc,1000);
3821: end if;
3822: --
3823: end do_return;
3824: --
3835: --
3836: begin
3837: --
3838: if g_debug then
3839: hr_utility.set_location(l_proc,0);
3840: end if;
3841: --
3842: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3843: --
3846: fnd_message.raise_error;
3847: end if;
3848: --
3849: if g_debug then
3850: hr_utility.set_location(l_proc,20);
3851: hr_utility.trace('action_information_id : '||p_action_information_id);
3852: hr_utility.trace('object_version_number : '||p_object_version_number);
3853: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3854: hr_utility.trace('start calc_dct before finalize');
3847: end if;
3848: --
3849: if g_debug then
3850: hr_utility.set_location(l_proc,20);
3851: hr_utility.trace('action_information_id : '||p_action_information_id);
3852: hr_utility.trace('object_version_number : '||p_object_version_number);
3853: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3854: hr_utility.trace('start calc_dct before finalize');
3855: end if;
3848: --
3849: if g_debug then
3850: hr_utility.set_location(l_proc,20);
3851: hr_utility.trace('action_information_id : '||p_action_information_id);
3852: hr_utility.trace('object_version_number : '||p_object_version_number);
3853: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3854: hr_utility.trace('start calc_dct before finalize');
3855: end if;
3856: --
3849: if g_debug then
3850: hr_utility.set_location(l_proc,20);
3851: hr_utility.trace('action_information_id : '||p_action_information_id);
3852: hr_utility.trace('object_version_number : '||p_object_version_number);
3853: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3854: hr_utility.trace('start calc_dct before finalize');
3855: end if;
3856: --
3857: if g_debug then
3850: hr_utility.set_location(l_proc,20);
3851: hr_utility.trace('action_information_id : '||p_action_information_id);
3852: hr_utility.trace('object_version_number : '||p_object_version_number);
3853: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3854: hr_utility.trace('start calc_dct before finalize');
3855: end if;
3856: --
3857: if g_debug then
3858: hr_utility.set_location(l_proc,20);
3854: hr_utility.trace('start calc_dct before finalize');
3855: end if;
3856: --
3857: if g_debug then
3858: hr_utility.set_location(l_proc,20);
3859: hr_utility.trace('action_information_id : '||p_action_information_id);
3860: hr_utility.trace('object_version_number : '||p_object_version_number);
3861: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3862: hr_utility.trace('start update_assact');
3855: end if;
3856: --
3857: if g_debug then
3858: hr_utility.set_location(l_proc,20);
3859: hr_utility.trace('action_information_id : '||p_action_information_id);
3860: hr_utility.trace('object_version_number : '||p_object_version_number);
3861: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3862: hr_utility.trace('start update_assact');
3863: end if;
3856: --
3857: if g_debug then
3858: hr_utility.set_location(l_proc,20);
3859: hr_utility.trace('action_information_id : '||p_action_information_id);
3860: hr_utility.trace('object_version_number : '||p_object_version_number);
3861: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3862: hr_utility.trace('start update_assact');
3863: end if;
3864: --
3857: if g_debug then
3858: hr_utility.set_location(l_proc,20);
3859: hr_utility.trace('action_information_id : '||p_action_information_id);
3860: hr_utility.trace('object_version_number : '||p_object_version_number);
3861: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3862: hr_utility.trace('start update_assact');
3863: end if;
3864: --
3865: p_object_version_number := l_assact_rec.object_version_number + 1;
3858: hr_utility.set_location(l_proc,20);
3859: hr_utility.trace('action_information_id : '||p_action_information_id);
3860: hr_utility.trace('object_version_number : '||p_object_version_number);
3861: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3862: hr_utility.trace('start update_assact');
3863: end if;
3864: --
3865: p_object_version_number := l_assact_rec.object_version_number + 1;
3866: --
3881: transaction_status = 'A'
3882: where row_id = l_assact_rec.row_id;
3883: --
3884: if g_debug then
3885: hr_utility.trace('end update_assact');
3886: hr_utility.set_location(l_proc,1000);
3887: end if;
3888: --
3889: end do_approve;
3882: where row_id = l_assact_rec.row_id;
3883: --
3884: if g_debug then
3885: hr_utility.trace('end update_assact');
3886: hr_utility.set_location(l_proc,1000);
3887: end if;
3888: --
3889: end do_approve;
3890: --
4032: --
4033: begin
4034: --
4035: if g_debug then
4036: hr_utility.set_location(l_proc,0);
4037: end if;
4038: --
4039: if p_effective_date is null then
4040: l_effective_date := p_rec.effective_date;
4508: --
4509: end if;
4510: --
4511: if g_debug then
4512: hr_utility.trace('end update_assact');
4513: hr_utility.set_location(l_proc,1000);
4514: end if;
4515: --
4516: end transfer_entry;
4509: end if;
4510: --
4511: if g_debug then
4512: hr_utility.trace('end update_assact');
4513: hr_utility.set_location(l_proc,1000);
4514: end if;
4515: --
4516: end transfer_entry;
4517: --
4537: --
4538: begin
4539: --
4540: if g_debug then
4541: hr_utility.set_location(l_proc,0);
4542: end if;
4543: --
4544: if p_effective_date is null then
4545: l_effective_date := p_rec.effective_date;
4692: --
4693: end if;
4694: --
4695: if g_debug then
4696: hr_utility.trace('end update_assact');
4697: hr_utility.set_location(l_proc,1000);
4698: end if;
4699: --
4700: end transfer_life_gen;
4693: end if;
4694: --
4695: if g_debug then
4696: hr_utility.trace('end update_assact');
4697: hr_utility.set_location(l_proc,1000);
4698: end if;
4699: --
4700: end transfer_life_gen;
4701: --
4722: --
4723: begin
4724: --
4725: if g_debug then
4726: hr_utility.set_location(l_proc,0);
4727: end if;
4728: --
4729: if p_effective_date is null then
4730: l_effective_date := p_rec.effective_date;
4873: --
4874: end if;
4875: --
4876: if g_debug then
4877: hr_utility.trace('end update_assact');
4878: hr_utility.set_location(l_proc,1000);
4879: end if;
4880: --
4881: end transfer_care_med;
4874: end if;
4875: --
4876: if g_debug then
4877: hr_utility.trace('end update_assact');
4878: hr_utility.set_location(l_proc,1000);
4879: end if;
4880: --
4881: end transfer_care_med;
4882: --
4903: --
4904: begin
4905: --
4906: if g_debug then
4907: hr_utility.set_location(l_proc,0);
4908: end if;
4909: --
4910: if p_effective_date is null then
4911: l_effective_date := p_rec.effective_date;
5061: --
5062: end if;
5063: --
5064: if g_debug then
5065: hr_utility.trace('end update_assact');
5066: hr_utility.set_location(l_proc,1000);
5067: end if;
5068: --
5069: end transfer_life_pens;
5062: end if;
5063: --
5064: if g_debug then
5065: hr_utility.trace('end update_assact');
5066: hr_utility.set_location(l_proc,1000);
5067: end if;
5068: --
5069: end transfer_life_pens;
5070: --
5090: --
5091: begin
5092: --
5093: if g_debug then
5094: hr_utility.set_location(l_proc,0);
5095: end if;
5096: --
5097: if p_effective_date is null then
5098: l_effective_date := p_rec.effective_date;
5247: --
5248: end if;
5249: --
5250: if g_debug then
5251: hr_utility.trace('end update_assact');
5252: hr_utility.set_location(l_proc,1000);
5253: end if;
5254: --
5255: end transfer_nonlife;
5248: end if;
5249: --
5250: if g_debug then
5251: hr_utility.trace('end update_assact');
5252: hr_utility.set_location(l_proc,1000);
5253: end if;
5254: --
5255: end transfer_nonlife;
5256: --
5398: --
5399: begin
5400: --
5401: if g_debug then
5402: hr_utility.set_location(l_proc,0);
5403: end if;
5404: --
5405: hr_api.mandatory_arg_error(l_proc, 'transfer_date', p_transfer_date);
5406: --
5442: commit;
5443: end if;
5444: --
5445: if g_debug then
5446: hr_utility.set_location(l_proc,20);
5447: hr_utility.trace('action_information_id : '||p_action_information_id);
5448: hr_utility.trace('object_version_number : '||p_object_version_number);
5449: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5450: hr_utility.trace('start calc_dct before finalize');
5443: end if;
5444: --
5445: if g_debug then
5446: hr_utility.set_location(l_proc,20);
5447: hr_utility.trace('action_information_id : '||p_action_information_id);
5448: hr_utility.trace('object_version_number : '||p_object_version_number);
5449: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5450: hr_utility.trace('start calc_dct before finalize');
5451: end if;
5444: --
5445: if g_debug then
5446: hr_utility.set_location(l_proc,20);
5447: hr_utility.trace('action_information_id : '||p_action_information_id);
5448: hr_utility.trace('object_version_number : '||p_object_version_number);
5449: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5450: hr_utility.trace('start calc_dct before finalize');
5451: end if;
5452: --
5445: if g_debug then
5446: hr_utility.set_location(l_proc,20);
5447: hr_utility.trace('action_information_id : '||p_action_information_id);
5448: hr_utility.trace('object_version_number : '||p_object_version_number);
5449: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5450: hr_utility.trace('start calc_dct before finalize');
5451: end if;
5452: --
5453: -- Transfer the followings.
5446: hr_utility.set_location(l_proc,20);
5447: hr_utility.trace('action_information_id : '||p_action_information_id);
5448: hr_utility.trace('object_version_number : '||p_object_version_number);
5449: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5450: hr_utility.trace('start calc_dct before finalize');
5451: end if;
5452: --
5453: -- Transfer the followings.
5454: --
5544: transfer_date = fnd_date.date_to_canonical(l_effective_date)
5545: where row_id = l_assact_rec.row_id;
5546: --
5547: if g_debug then
5548: hr_utility.trace('end update_assact');
5549: hr_utility.set_location(l_proc,1000);
5550: end if;
5551: --
5552: end do_transfer;
5545: where row_id = l_assact_rec.row_id;
5546: --
5547: if g_debug then
5548: hr_utility.trace('end update_assact');
5549: hr_utility.set_location(l_proc,1000);
5550: end if;
5551: --
5552: end do_transfer;
5553: --
5601: --
5602: begin
5603: --
5604: if g_debug then
5605: hr_utility.set_location(l_proc,0);
5606: end if;
5607: --
5608: hr_api.mandatory_arg_error(l_proc,'expiry_date',p_expiry_date);
5609: --
5617: fnd_message.raise_error;
5618: end if;
5619: --
5620: if g_debug then
5621: hr_utility.set_location(l_proc,20);
5622: hr_utility.trace('action_information_id : '||p_action_information_id);
5623: hr_utility.trace('object_version_number : '||p_object_version_number);
5624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5625: hr_utility.trace('start calc_dct before finalize');
5618: end if;
5619: --
5620: if g_debug then
5621: hr_utility.set_location(l_proc,20);
5622: hr_utility.trace('action_information_id : '||p_action_information_id);
5623: hr_utility.trace('object_version_number : '||p_object_version_number);
5624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5625: hr_utility.trace('start calc_dct before finalize');
5626: end if;
5619: --
5620: if g_debug then
5621: hr_utility.set_location(l_proc,20);
5622: hr_utility.trace('action_information_id : '||p_action_information_id);
5623: hr_utility.trace('object_version_number : '||p_object_version_number);
5624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5625: hr_utility.trace('start calc_dct before finalize');
5626: end if;
5627: --
5620: if g_debug then
5621: hr_utility.set_location(l_proc,20);
5622: hr_utility.trace('action_information_id : '||p_action_information_id);
5623: hr_utility.trace('object_version_number : '||p_object_version_number);
5624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5625: hr_utility.trace('start calc_dct before finalize');
5626: end if;
5627: --
5628: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
5621: hr_utility.set_location(l_proc,20);
5622: hr_utility.trace('action_information_id : '||p_action_information_id);
5623: hr_utility.trace('object_version_number : '||p_object_version_number);
5624: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
5625: hr_utility.trace('start calc_dct before finalize');
5626: end if;
5627: --
5628: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
5629: l_dec_first_date := trunc(l_year_end_date,'MM');
5748: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
5749: where row_id = l_assact_rec.row_id;
5750: --
5751: if g_debug then
5752: hr_utility.trace('end update_assact');
5753: hr_utility.set_location(l_proc,1000);
5754: end if;
5755: --
5756: end do_expire;
5749: where row_id = l_assact_rec.row_id;
5750: --
5751: if g_debug then
5752: hr_utility.trace('end update_assact');
5753: hr_utility.set_location(l_proc,1000);
5754: end if;
5755: --
5756: end do_expire;
5757: --