[Home] [Help]
1: package body pay_jp_isdf_ss_pkg as
2: /* $Header: pyjpisfs.pkb 120.9 2007/11/29 08:41:54 keyazawa noship $ */
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');
230: --
231: begin
232: --
233: if g_debug then
234: hr_utility.set_location(l_proc,0);
235: end if;
236: --
237: open csr_pact;
238: fetch csr_pact into l_payroll_action_id, l_business_group_id, l_effective_date;
946: --
947: end if;
948: --
949: if g_debug then
950: hr_utility.trace('g_life_range1b : '||g_life_range1b);
951: hr_utility.trace('g_life_range2a : '||g_life_range2a);
952: hr_utility.trace('g_life_range2b : '||g_life_range2b);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
947: end if;
948: --
949: if g_debug then
950: hr_utility.trace('g_life_range1b : '||g_life_range1b);
951: hr_utility.trace('g_life_range2a : '||g_life_range2a);
952: hr_utility.trace('g_life_range2b : '||g_life_range2b);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
948: --
949: if g_debug then
950: hr_utility.trace('g_life_range1b : '||g_life_range1b);
951: hr_utility.trace('g_life_range2a : '||g_life_range2a);
952: hr_utility.trace('g_life_range2b : '||g_life_range2b);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
949: if g_debug then
950: hr_utility.trace('g_life_range1b : '||g_life_range1b);
951: hr_utility.trace('g_life_range2a : '||g_life_range2a);
952: hr_utility.trace('g_life_range2b : '||g_life_range2b);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
950: hr_utility.trace('g_life_range1b : '||g_life_range1b);
951: hr_utility.trace('g_life_range2a : '||g_life_range2a);
952: hr_utility.trace('g_life_range2b : '||g_life_range2b);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
951: hr_utility.trace('g_life_range2a : '||g_life_range2a);
952: hr_utility.trace('g_life_range2b : '||g_life_range2b);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
952: hr_utility.trace('g_life_range2b : '||g_life_range2b);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
953: hr_utility.trace('g_life_range3a : '||g_life_range3a);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
954: hr_utility.trace('g_life_range3b : '||g_life_range3b);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
955: hr_utility.trace('g_life_range4a : '||g_life_range4a);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
956: hr_utility.trace('g_life_calc2 : '||g_life_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
957: hr_utility.trace('g_life_calc3 : '||g_life_calc3);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
958: hr_utility.trace('g_life_calc4 : '||g_life_calc4);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
959: hr_utility.trace('g_life_gen_max : '||g_life_gen_max);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
960: hr_utility.trace('g_life_pens_max : '||g_life_pens_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
961: hr_utility.trace('g_life_ins_max : '||g_life_ins_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
962: hr_utility.trace('g_earthquake_max : '||g_earthquake_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
963: hr_utility.trace('g_lnonlife_range1b : '||g_lnonlife_range1b);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
964: hr_utility.trace('g_lnonlife_calc2 : '||g_lnonlife_calc2);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
965: hr_utility.trace('g_lnonlife_year : '||g_lnonlife_year);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
966: hr_utility.trace('g_snonlife_range1b : '||g_snonlife_range1b);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
967: hr_utility.trace('g_snonlife_calc2 : '||g_snonlife_calc2);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
968: hr_utility.trace('g_lnonlife_max : '||g_lnonlife_max);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
969: hr_utility.trace('g_snonlife_max : '||g_snonlife_max);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
970: hr_utility.trace('g_nonlife_max : '||g_nonlife_max);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
971: hr_utility.trace('g_sp_calc_unit : '||g_sp_calc_unit);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
972: hr_utility.trace('g_sp_emp_inc_max : '||g_sp_emp_inc_max);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
973: hr_utility.trace('g_sp_spdct_max : '||g_sp_spdct_max);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
974: hr_utility.trace('g_sp_spinc_max : '||g_sp_spinc_max);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
975: hr_utility.trace('g_sp_calc_exp1b : '||g_sp_calc_exp1b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
976: hr_utility.trace('g_sp_calc_exp1b_fmt : '||g_sp_calc_exp1b_fmt);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
977: hr_utility.trace('g_sp_calc_cal1 : '||g_sp_calc_cal1);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
978: hr_utility.trace('g_sp_calc_cal6 : '||g_sp_calc_cal6);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
979: hr_utility.trace('g_sp_calc_dct_range1a : '||g_sp_calc_dct_range1a);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
980: hr_utility.trace('g_sp_calc_dct_range1b : '||g_sp_calc_dct_range1b);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
981: hr_utility.trace('g_sp_calc_dct1 : '||g_sp_calc_dct1);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
982: hr_utility.trace('g_sp_calc_dct_range2a : '||g_sp_calc_dct_range2a);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
983: hr_utility.trace('g_sp_calc_dct_range2b : '||g_sp_calc_dct_range2b);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
984: hr_utility.trace('g_sp_calc_dct2 : '||g_sp_calc_dct2);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
985: hr_utility.trace('g_sp_calc_dct_range3a : '||g_sp_calc_dct_range3a);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
986: hr_utility.trace('g_sp_calc_dct_range3b : '||g_sp_calc_dct_range3b);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
987: hr_utility.trace('g_sp_calc_dct3 : '||g_sp_calc_dct3);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
988: hr_utility.trace('g_sp_calc_dct_range4a : '||g_sp_calc_dct_range4a);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
989: hr_utility.trace('g_sp_calc_dct_range4b : '||g_sp_calc_dct_range4b);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
990: hr_utility.trace('g_sp_calc_dct4 : '||g_sp_calc_dct4);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
991: hr_utility.trace('g_sp_calc_dct_range5a : '||g_sp_calc_dct_range5a);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
992: hr_utility.trace('g_sp_calc_dct_range5b : '||g_sp_calc_dct_range5b);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
993: hr_utility.trace('g_sp_calc_dct5 : '||g_sp_calc_dct5);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
994: hr_utility.trace('g_sp_calc_dct_range6a : '||g_sp_calc_dct_range6a);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
995: hr_utility.trace('g_sp_calc_dct_range6b : '||g_sp_calc_dct_range6b);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1003: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
996: hr_utility.trace('g_sp_calc_dct6 : '||g_sp_calc_dct6);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1003: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1004: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
997: hr_utility.trace('g_sp_calc_dct_range7a : '||g_sp_calc_dct_range7a);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1003: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1004: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1005: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
998: hr_utility.trace('g_sp_calc_dct_range7b : '||g_sp_calc_dct_range7b);
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1003: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1004: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1005: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1006: end if;
999: hr_utility.trace('g_sp_calc_dct7 : '||g_sp_calc_dct7);
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1003: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1004: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1005: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1006: end if;
1007: --
1000: hr_utility.trace('g_sp_calc_dct_range8a : '||g_sp_calc_dct_range8a);
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1003: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1004: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1005: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1006: end if;
1007: --
1008: if g_debug then
1001: hr_utility.trace('g_sp_calc_dct_range8b : '||g_sp_calc_dct_range8b);
1002: hr_utility.trace('g_sp_calc_dct8 : '||g_sp_calc_dct8);
1003: hr_utility.trace('g_sp_calc_dct_range9a : '||g_sp_calc_dct_range9a);
1004: hr_utility.trace('g_sp_calc_dct_range9b : '||g_sp_calc_dct_range9b);
1005: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1006: end if;
1007: --
1008: if g_debug then
1009: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1005: hr_utility.trace('g_sp_calc_dct9 : '||g_sp_calc_dct9);
1006: end if;
1007: --
1008: if g_debug then
1009: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1010: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1011: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1006: end if;
1007: --
1008: if g_debug then
1009: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1010: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1011: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1007: --
1008: if g_debug then
1009: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1010: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1011: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1008: if g_debug then
1009: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1010: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1011: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1009: hr_utility.trace('g_msg_life_range1 : '||g_msg_life_range1);
1010: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1011: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1010: hr_utility.trace('g_msg_life_range2 : '||g_msg_life_range2);
1011: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1011: hr_utility.trace('g_msg_life_range3 : '||g_msg_life_range3);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1012: hr_utility.trace('g_msg_life_range4 : '||g_msg_life_range4);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1013: hr_utility.trace('g_msg_life_calc2 : '||g_msg_life_calc2);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1014: hr_utility.trace('g_msg_life_calc3 : '||g_msg_life_calc3);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1015: hr_utility.trace('g_msg_life_calc4 : '||g_msg_life_calc4);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1016: hr_utility.trace('g_msg_life_gen_max : '||g_msg_life_gen_max);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1017: hr_utility.trace('g_msg_life_pens_max : '||g_msg_life_pens_max);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1018: hr_utility.trace('g_msg_life_ins_max : '||g_msg_life_ins_max);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1019: hr_utility.trace('g_msg_nonlife_2007 : '||g_msg_nonlife_2007);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1020: hr_utility.trace('g_msg_nonlife_ap_2007 : '||g_msg_nonlife_ap_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1021: hr_utility.trace('g_msg_eqnonlife_s_2007 : '||g_msg_eqnonlife_s_2007);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1022: hr_utility.trace('g_msg_lnonlife_s_2007 : '||g_msg_lnonlife_s_2007);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1023: hr_utility.trace('g_msg_lnonlife : '||g_msg_lnonlife);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1024: hr_utility.trace('g_msg_eqnonlife_2007 : '||g_msg_eqnonlife_2007);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1025: hr_utility.trace('g_msg_lnonlife_2007 : '||g_msg_lnonlife_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1026: hr_utility.trace('g_msg_lnonlife_dct : '||g_msg_lnonlife_dct);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1027: hr_utility.trace('g_msg_snonlife_dct : '||g_msg_snonlife_dct);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1028: hr_utility.trace('g_msg_lnonlife_dct_2007 : '||g_msg_lnonlife_dct_2007);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1029: hr_utility.trace('g_msg_earthquake_max : '||g_msg_earthquake_max);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1030: hr_utility.trace('g_msg_nonlife_long_max : '||g_msg_nonlife_long_max);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1031: hr_utility.trace('g_msg_nonlife_short_max : '||g_msg_nonlife_short_max);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1032: hr_utility.trace('g_msg_nonlife_ins_max : '||g_msg_nonlife_ins_max);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1033: hr_utility.trace('g_msg_nonlife_ins_max_2007 : '||g_msg_nonlife_ins_max_2007);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1034: hr_utility.trace('g_msg_sp_emp_inc_max : '||g_msg_sp_emp_inc_max);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1035: hr_utility.trace('g_msg_sp_sp_inc_max : '||g_msg_sp_sp_inc_max);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1036: hr_utility.trace('g_msg_sp_calc_cal1 : '||g_msg_sp_calc_cal1);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1037: hr_utility.trace('g_msg_sp_calc_cal6 : '||g_msg_sp_calc_cal6);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1038: hr_utility.trace('g_msg_sp_calc_dct_range1 : '||g_msg_sp_calc_dct_range1);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1039: hr_utility.trace('g_msg_sp_calc_dct_range2 : '||g_msg_sp_calc_dct_range2);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1040: hr_utility.trace('g_msg_sp_calc_dct_range3 : '||g_msg_sp_calc_dct_range3);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1041: hr_utility.trace('g_msg_sp_calc_dct_range4 : '||g_msg_sp_calc_dct_range4);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1042: hr_utility.trace('g_msg_sp_calc_dct_range5 : '||g_msg_sp_calc_dct_range5);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1043: hr_utility.trace('g_msg_sp_calc_dct_range6 : '||g_msg_sp_calc_dct_range6);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1044: hr_utility.trace('g_msg_sp_calc_dct_range7 : '||g_msg_sp_calc_dct_range7);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1045: hr_utility.trace('g_msg_sp_calc_dct_range8 : '||g_msg_sp_calc_dct_range8);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1053: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1046: hr_utility.trace('g_msg_sp_calc_dct_range9 : '||g_msg_sp_calc_dct_range9);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1053: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1054: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1047: hr_utility.trace('g_msg_sp_calc_dct1 : '||g_msg_sp_calc_dct1);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1053: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1054: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1055: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1048: hr_utility.trace('g_msg_sp_calc_dct2 : '||g_msg_sp_calc_dct2);
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1053: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1054: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1055: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1056: end if;
1049: hr_utility.trace('g_msg_sp_calc_dct3 : '||g_msg_sp_calc_dct3);
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1053: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1054: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1055: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1056: end if;
1057: --
1050: hr_utility.trace('g_msg_sp_calc_dct4 : '||g_msg_sp_calc_dct4);
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1053: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1054: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1055: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1056: end if;
1057: --
1058: if g_debug then
1051: hr_utility.trace('g_msg_sp_calc_dct5 : '||g_msg_sp_calc_dct5);
1052: hr_utility.trace('g_msg_sp_calc_dct6 : '||g_msg_sp_calc_dct6);
1053: hr_utility.trace('g_msg_sp_calc_dct7 : '||g_msg_sp_calc_dct7);
1054: hr_utility.trace('g_msg_sp_calc_dct8 : '||g_msg_sp_calc_dct8);
1055: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1056: end if;
1057: --
1058: if g_debug then
1059: hr_utility.set_location(l_proc,1000);
1055: hr_utility.trace('g_msg_sp_calc_dct9 : '||g_msg_sp_calc_dct9);
1056: end if;
1057: --
1058: if g_debug then
1059: hr_utility.set_location(l_proc,1000);
1060: end if;
1061: --
1062: end set_form_pg_prompt;
1063: --
1082: --
1083: begin
1084: --
1085: if g_debug then
1086: hr_utility.set_location(l_proc,0);
1087: end if;
1088: --
1089: l_submission_date := check_submission_period(p_action_information_id);
1090: --
1088: --
1089: l_submission_date := check_submission_period(p_action_information_id);
1090: --
1091: if g_debug then
1092: hr_utility.set_location(l_proc,10);
1093: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1094: end if;
1095: --
1096: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1089: l_submission_date := check_submission_period(p_action_information_id);
1090: --
1091: if g_debug then
1092: hr_utility.set_location(l_proc,10);
1093: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1094: end if;
1095: --
1096: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1097: --
1100: fnd_message.raise_error;
1101: end if;
1102: --
1103: if g_debug then
1104: hr_utility.set_location(l_proc,20);
1105: hr_utility.trace('action_information_id : '||p_action_information_id);
1106: hr_utility.trace('object_version_number : '||p_object_version_number);
1107: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1108: hr_utility.trace('start delete preset archive');
1101: end if;
1102: --
1103: if g_debug then
1104: hr_utility.set_location(l_proc,20);
1105: hr_utility.trace('action_information_id : '||p_action_information_id);
1106: hr_utility.trace('object_version_number : '||p_object_version_number);
1107: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1108: hr_utility.trace('start delete preset archive');
1109: end if;
1102: --
1103: if g_debug then
1104: hr_utility.set_location(l_proc,20);
1105: hr_utility.trace('action_information_id : '||p_action_information_id);
1106: hr_utility.trace('object_version_number : '||p_object_version_number);
1107: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1108: hr_utility.trace('start delete preset archive');
1109: end if;
1110: --
1103: if g_debug then
1104: hr_utility.set_location(l_proc,20);
1105: hr_utility.trace('action_information_id : '||p_action_information_id);
1106: hr_utility.trace('object_version_number : '||p_object_version_number);
1107: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1108: hr_utility.trace('start delete preset archive');
1109: end if;
1110: --
1111: -- recreate archive data (available for existing data of transaction_status N or U)
1104: hr_utility.set_location(l_proc,20);
1105: hr_utility.trace('action_information_id : '||p_action_information_id);
1106: hr_utility.trace('object_version_number : '||p_object_version_number);
1107: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1108: hr_utility.trace('start delete preset archive');
1109: end if;
1110: --
1111: -- recreate archive data (available for existing data of transaction_status N or U)
1112: --
1116: and action_context_type = 'AAP'
1117: and action_information_category <> 'JP_ISDF_ASSACT';
1118: --
1119: if g_debug then
1120: hr_utility.trace('end delete preset archive');
1121: hr_utility.set_location(l_proc,30);
1122: hr_utility.trace('start archive_assact');
1123: end if;
1124: --
1117: and action_information_category <> 'JP_ISDF_ASSACT';
1118: --
1119: if g_debug then
1120: hr_utility.trace('end delete preset archive');
1121: hr_utility.set_location(l_proc,30);
1122: hr_utility.trace('start archive_assact');
1123: end if;
1124: --
1125: -- set global argument of pact in pay_jp_isdf_archive_pkg
1118: --
1119: if g_debug then
1120: hr_utility.trace('end delete preset archive');
1121: hr_utility.set_location(l_proc,30);
1122: hr_utility.trace('start archive_assact');
1123: end if;
1124: --
1125: -- set global argument of pact in pay_jp_isdf_archive_pkg
1126: open csr_pact;
1127: fetch csr_pact into l_payroll_action_id;
1128: close csr_pact;
1129: --
1130: if g_debug then
1131: hr_utility.set_location(l_proc,40);
1132: end if;
1133: --
1134: pay_jp_isdf_archive_pkg.init_pact(
1135: p_payroll_action_id => l_payroll_action_id);
1137: -- reset to force archive because of concurrent parameter might be N
1138: pay_jp_isdf_archive_pkg.g_archive_default_flag := 'Y';
1139: --
1140: if g_debug then
1141: hr_utility.set_location(l_proc,50);
1142: end if;
1143: --
1144: -- set global argument of assact in pay_jp_isdf_archive_pkg
1145: pay_jp_isdf_archive_pkg.init_assact(
1146: p_assignment_action_id => l_assact_rec.assignment_action_id,
1147: p_assignment_id => l_assact_rec.assignment_id);
1148: --
1149: if g_debug then
1150: hr_utility.set_location(l_proc,60);
1151: end if;
1152: --
1153: pay_jp_isdf_archive_pkg.archive_assact(
1154: p_assignment_action_id => l_assact_rec.assignment_action_id,
1154: p_assignment_action_id => l_assact_rec.assignment_action_id,
1155: p_assignment_id => l_assact_rec.assignment_id);
1156: --
1157: if g_debug then
1158: hr_utility.trace('end archive_assact');
1159: hr_utility.set_location(l_proc,70);
1160: hr_utility.trace('start update_assact');
1161: end if;
1162: --
1155: p_assignment_id => l_assact_rec.assignment_id);
1156: --
1157: if g_debug then
1158: hr_utility.trace('end archive_assact');
1159: hr_utility.set_location(l_proc,70);
1160: hr_utility.trace('start update_assact');
1161: end if;
1162: --
1163: p_object_version_number := l_assact_rec.object_version_number + 1;
1156: --
1157: if g_debug then
1158: hr_utility.trace('end archive_assact');
1159: hr_utility.set_location(l_proc,70);
1160: hr_utility.trace('start update_assact');
1161: end if;
1162: --
1163: p_object_version_number := l_assact_rec.object_version_number + 1;
1164: --
1179: transaction_status = 'N'
1180: where row_id = l_assact_rec.row_id;
1181: --
1182: if g_debug then
1183: hr_utility.trace('end update_assact');
1184: hr_utility.set_location(l_proc,1000);
1185: end if;
1186: --
1187: end do_new;
1180: where row_id = l_assact_rec.row_id;
1181: --
1182: if g_debug then
1183: hr_utility.trace('end update_assact');
1184: hr_utility.set_location(l_proc,1000);
1185: end if;
1186: --
1187: end do_new;
1188: --
1198: l_assact_rec pay_jp_isdf_assact_v%rowtype;
1199: begin
1200: --
1201: if g_debug then
1202: hr_utility.set_location(l_proc,0);
1203: end if;
1204: --
1205: l_submission_date := check_submission_period(p_action_information_id);
1206: --
1204: --
1205: l_submission_date := check_submission_period(p_action_information_id);
1206: --
1207: if g_debug then
1208: hr_utility.set_location(l_proc,10);
1209: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1210: end if;
1211: --
1212: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1205: l_submission_date := check_submission_period(p_action_information_id);
1206: --
1207: if g_debug then
1208: hr_utility.set_location(l_proc,10);
1209: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1210: end if;
1211: --
1212: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1213: --
1216: fnd_message.raise_error;
1217: end if;
1218: --
1219: if g_debug then
1220: hr_utility.set_location(l_proc,20);
1221: hr_utility.set_location(l_proc,20);
1222: hr_utility.trace('action_information_id : '||p_action_information_id);
1223: hr_utility.trace('object_version_number : '||p_object_version_number);
1224: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1217: end if;
1218: --
1219: if g_debug then
1220: hr_utility.set_location(l_proc,20);
1221: hr_utility.set_location(l_proc,20);
1222: hr_utility.trace('action_information_id : '||p_action_information_id);
1223: hr_utility.trace('object_version_number : '||p_object_version_number);
1224: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1225: hr_utility.trace('start update_assact');
1218: --
1219: if g_debug then
1220: hr_utility.set_location(l_proc,20);
1221: hr_utility.set_location(l_proc,20);
1222: hr_utility.trace('action_information_id : '||p_action_information_id);
1223: hr_utility.trace('object_version_number : '||p_object_version_number);
1224: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1225: hr_utility.trace('start update_assact');
1226: end if;
1219: if g_debug then
1220: hr_utility.set_location(l_proc,20);
1221: hr_utility.set_location(l_proc,20);
1222: hr_utility.trace('action_information_id : '||p_action_information_id);
1223: hr_utility.trace('object_version_number : '||p_object_version_number);
1224: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1225: hr_utility.trace('start update_assact');
1226: end if;
1227: --
1220: hr_utility.set_location(l_proc,20);
1221: hr_utility.set_location(l_proc,20);
1222: hr_utility.trace('action_information_id : '||p_action_information_id);
1223: hr_utility.trace('object_version_number : '||p_object_version_number);
1224: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1225: hr_utility.trace('start update_assact');
1226: end if;
1227: --
1228: p_object_version_number := l_assact_rec.object_version_number + 1;
1221: hr_utility.set_location(l_proc,20);
1222: hr_utility.trace('action_information_id : '||p_action_information_id);
1223: hr_utility.trace('object_version_number : '||p_object_version_number);
1224: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
1225: hr_utility.trace('start update_assact');
1226: end if;
1227: --
1228: p_object_version_number := l_assact_rec.object_version_number + 1;
1229: --
1243: set object_version_number = p_object_version_number
1244: where row_id = l_assact_rec.row_id;
1245: --
1246: if g_debug then
1247: hr_utility.trace('end update_assact');
1248: hr_utility.set_location(l_proc,1000);
1249: end if;
1250: --
1251: end do_apply;
1244: where row_id = l_assact_rec.row_id;
1245: --
1246: if g_debug then
1247: hr_utility.trace('end update_assact');
1248: hr_utility.set_location(l_proc,1000);
1249: end if;
1250: --
1251: end do_apply;
1252: --
1316: --
1317: begin
1318: --
1319: if g_debug then
1320: hr_utility.set_location(l_proc,0);
1321: hr_utility.trace('csr_archive_data bulk collect start');
1322: end if;
1323: --
1324: -- #2243411 bulk collect bug fix is available from 9.2
1317: begin
1318: --
1319: if g_debug then
1320: hr_utility.set_location(l_proc,0);
1321: hr_utility.trace('csr_archive_data bulk collect start');
1322: end if;
1323: --
1324: -- #2243411 bulk collect bug fix is available from 9.2
1325: open csr_archive_data;
1334: end loop;
1335: close csr_archive_data;
1336: --
1337: if g_debug then
1338: hr_utility.set_location(l_proc,10);
1339: hr_utility.trace('csr_archive_data bulk collect end');
1340: hr_utility.trace('csr_archive_data count : '||l_action_info_tbl.count);
1341: end if;
1342: --
1335: close csr_archive_data;
1336: --
1337: if g_debug then
1338: hr_utility.set_location(l_proc,10);
1339: hr_utility.trace('csr_archive_data bulk collect end');
1340: hr_utility.trace('csr_archive_data count : '||l_action_info_tbl.count);
1341: end if;
1342: --
1343: p_calc_total_rec.life_gen := 0;
1336: --
1337: if g_debug then
1338: hr_utility.set_location(l_proc,10);
1339: hr_utility.trace('csr_archive_data bulk collect end');
1340: hr_utility.trace('csr_archive_data count : '||l_action_info_tbl.count);
1341: end if;
1342: --
1343: p_calc_total_rec.life_gen := 0;
1344: p_calc_total_rec.life_pens := 0;
1374: p_calc_total_rec.sp_other_inc_exp_tmp := 0;
1375: p_calc_total_rec.sp_other_inc_exp_tmp_exp := 0;
1376: --
1377: if g_debug then
1378: hr_utility.set_location(l_proc,20);
1379: end if;
1380: --
1381: for i in 1..l_action_info_tbl.count loop
1382: --
1450: --
1451: end loop;
1452: --
1453: if g_debug then
1454: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1455: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1456: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1451: end loop;
1452: --
1453: if g_debug then
1454: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1455: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1456: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1452: --
1453: if g_debug then
1454: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1455: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1456: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1453: if g_debug then
1454: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1455: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1456: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1454: hr_utility.trace('life_gen : '||to_char(p_calc_total_rec.life_gen));
1455: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1456: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1455: hr_utility.trace('life_pens : '||to_char(p_calc_total_rec.life_pens));
1456: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1456: hr_utility.trace('earthquake : '||to_char(p_calc_total_rec.earthquake));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1457: hr_utility.trace('nonlife_long : '||to_char(p_calc_total_rec.nonlife_long));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1458: hr_utility.trace('nonlife_short : '||to_char(p_calc_total_rec.nonlife_short));
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1459: hr_utility.trace('national_pens : '||to_char(p_calc_total_rec.national_pens));
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1460: hr_utility.trace('social : '||to_char(p_calc_total_rec.social));
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1461: hr_utility.trace('mutual_aid_ec : '||to_char(p_calc_total_rec.mutual_aid_ec));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1462: hr_utility.trace('mutual_aid_p : '||to_char(p_calc_total_rec.mutual_aid_p));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1463: hr_utility.trace('mutual_aid_dsc : '||to_char(p_calc_total_rec.mutual_aid_dsc));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1464: hr_utility.trace('sp_emp_inc : '||to_char(p_calc_total_rec.sp_emp_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1465: hr_utility.trace('sp_spouse_inc : '||to_char(p_calc_total_rec.sp_spouse_inc));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1466: hr_utility.trace('sp_type : '||p_calc_total_rec.sp_sp_type);
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1467: hr_utility.trace('sp_wid_type : '||p_calc_total_rec.sp_wid_type);
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1468: hr_utility.trace('sp_dct_exc : '||p_calc_total_rec.sp_dct_exc);
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1469: hr_utility.trace('sp_inc_cnt : '||to_char(p_calc_total_rec.sp_inc_cnt));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1470: hr_utility.trace('sp_earned_inc : '||to_char(p_calc_total_rec.sp_earned_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1471: hr_utility.trace('sp_earned_inc_exp : '||to_char(p_calc_total_rec.sp_earned_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1472: hr_utility.trace('sp_business_inc : '||to_char(p_calc_total_rec.sp_business_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1473: hr_utility.trace('sp_business_inc_exp : '||to_char(p_calc_total_rec.sp_business_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1474: hr_utility.trace('sp_miscellaneous_inc : '||to_char(p_calc_total_rec.sp_miscellaneous_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1475: hr_utility.trace('sp_miscellaneous_inc_exp : '||to_char(p_calc_total_rec.sp_miscellaneous_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1476: hr_utility.trace('sp_dividend_inc : '||to_char(p_calc_total_rec.sp_dividend_inc));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1477: hr_utility.trace('sp_dividend_inc_exp : '||to_char(p_calc_total_rec.sp_dividend_inc_exp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1485: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1478: hr_utility.trace('sp_real_estate_inc : '||to_char(p_calc_total_rec.sp_real_estate_inc));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1485: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1486: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1479: hr_utility.trace('sp_real_estate_inc_exp : '||to_char(p_calc_total_rec.sp_real_estate_inc_exp));
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1485: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1486: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1487: hr_utility.set_location(l_proc,1000);
1480: hr_utility.trace('sp_retirement_inc : '||to_char(p_calc_total_rec.sp_retirement_inc));
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1485: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1486: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1487: hr_utility.set_location(l_proc,1000);
1488: end if;
1481: hr_utility.trace('sp_retirement_inc_exp : '||to_char(p_calc_total_rec.sp_retirement_inc_exp));
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1485: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1486: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1487: hr_utility.set_location(l_proc,1000);
1488: end if;
1489: --
1482: hr_utility.trace('sp_other_inc : '||to_char(p_calc_total_rec.sp_other_inc));
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1485: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1486: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1487: hr_utility.set_location(l_proc,1000);
1488: end if;
1489: --
1490: end calc_total;
1483: hr_utility.trace('sp_other_inc_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp));
1484: hr_utility.trace('sp_other_inc_exp_dct : '||to_char(p_calc_total_rec.sp_other_inc_exp_dct));
1485: hr_utility.trace('sp_other_inc_exp_tmp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp));
1486: hr_utility.trace('sp_other_inc_exp_tmp_exp : '||to_char(p_calc_total_rec.sp_other_inc_exp_tmp_exp));
1487: hr_utility.set_location(l_proc,1000);
1488: end if;
1489: --
1490: end calc_total;
1491: --
1510: --
1511: begin
1512: --
1513: if g_debug then
1514: hr_utility.set_location(l_proc,0);
1515: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1516: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1517: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1518: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1511: begin
1512: --
1513: if g_debug then
1514: hr_utility.set_location(l_proc,0);
1515: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1516: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1517: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1518: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1519: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1512: --
1513: if g_debug then
1514: hr_utility.set_location(l_proc,0);
1515: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1516: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1517: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1518: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1519: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1520: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1513: if g_debug then
1514: hr_utility.set_location(l_proc,0);
1515: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1516: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1517: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1518: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1519: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1520: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1521: end if;
1514: hr_utility.set_location(l_proc,0);
1515: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1516: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1517: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1518: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1519: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1520: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1521: end if;
1522: --
1515: hr_utility.trace('p_life_gen_i : '||to_char(p_life_gen_i));
1516: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1517: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1518: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1519: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1520: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1521: end if;
1522: --
1523: -- formula datetrack
1516: hr_utility.trace('p_life_pens_i : '||to_char(p_life_pens_i));
1517: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1518: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1519: hr_utility.trace('i_life_gen : '||to_char(i_life_gen));
1520: hr_utility.trace('i_life_pens : '||to_char(i_life_pens));
1521: end if;
1522: --
1523: -- formula datetrack
1524: if (p_effective_date >= hr_api.g_sot
1524: if (p_effective_date >= hr_api.g_sot
1525: and p_effective_date <= hr_api.g_eot) then
1526: --
1527: if g_debug then
1528: hr_utility.set_location(l_proc,10);
1529: end if;
1530: --
1531: if i_life_gen > 0 then
1532: --
1530: --
1531: if i_life_gen > 0 then
1532: --
1533: if g_debug then
1534: hr_utility.set_location(l_proc,20);
1535: end if;
1536: --
1537: -- udt satisfy validation of max value
1538: o_life_gen := round(i_life_gen
1549: to_char(i_life_gen),
1550: p_effective_date)));
1551: --
1552: if g_debug then
1553: hr_utility.set_location(l_proc,30);
1554: end if;
1555: --
1556: end if;
1557: --
1555: --
1556: end if;
1557: --
1558: if g_debug then
1559: hr_utility.set_location(l_proc,40);
1560: end if;
1561: --
1562: if i_life_pens > 0 then
1563: --
1561: --
1562: if i_life_pens > 0 then
1563: --
1564: if g_debug then
1565: hr_utility.set_location(l_proc,50);
1566: end if;
1567: --
1568: -- udt satisfy validation of max value
1569: o_life_pens := round(i_life_pens
1580: to_char(i_life_pens),
1581: p_effective_date)));
1582: --
1583: if g_debug then
1584: hr_utility.set_location(l_proc,60);
1585: end if;
1586: --
1587: end if;
1588: --
1592: p_life_pens_o := o_life_pens;
1593: p_life_ins_dct_o := o_life_gen + o_life_pens;
1594: --
1595: if g_debug then
1596: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
1597: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
1598: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
1599: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
1600: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
1593: p_life_ins_dct_o := o_life_gen + o_life_pens;
1594: --
1595: if g_debug then
1596: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
1597: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
1598: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
1599: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
1600: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
1601: hr_utility.set_location(l_proc,1000);
1594: --
1595: if g_debug then
1596: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
1597: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
1598: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
1599: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
1600: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
1601: hr_utility.set_location(l_proc,1000);
1602: end if;
1595: if g_debug then
1596: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
1597: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
1598: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
1599: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
1600: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
1601: hr_utility.set_location(l_proc,1000);
1602: end if;
1603: --
1596: hr_utility.trace('o_life_gen : '||to_char(o_life_gen));
1597: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
1598: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
1599: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
1600: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
1601: hr_utility.set_location(l_proc,1000);
1602: end if;
1603: --
1604: end calc_life_ins_dct;
1597: hr_utility.trace('o_life_pens : '||to_char(o_life_pens));
1598: hr_utility.trace('p_life_gen_o : '||to_char(p_life_gen_o));
1599: hr_utility.trace('p_life_pens_o : '||to_char(p_life_pens_o));
1600: hr_utility.trace('p_life_ins_dct_o : '||to_char(p_life_ins_dct_o));
1601: hr_utility.set_location(l_proc,1000);
1602: end if;
1603: --
1604: end calc_life_ins_dct;
1605: --
1629: --
1630: begin
1631: --
1632: if g_debug then
1633: hr_utility.set_location(l_proc,0);
1634: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
1635: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1630: begin
1631: --
1632: if g_debug then
1633: hr_utility.set_location(l_proc,0);
1634: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
1635: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1631: --
1632: if g_debug then
1633: hr_utility.set_location(l_proc,0);
1634: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
1635: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1639: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
1632: if g_debug then
1633: hr_utility.set_location(l_proc,0);
1634: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
1635: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1639: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
1640: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
1633: hr_utility.set_location(l_proc,0);
1634: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
1635: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1639: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
1640: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
1641: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
1634: hr_utility.trace('p_earthquake_i : '||to_char(p_earthquake_i));
1635: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1639: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
1640: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
1641: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
1642: end if;
1635: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_long_i));
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1639: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
1640: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
1641: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
1642: end if;
1643: --
1636: hr_utility.trace('p_nonlife_long_i : '||to_char(p_nonlife_short_i));
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1639: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
1640: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
1641: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
1642: end if;
1643: --
1644: -- formula datetrack
1637: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1638: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1639: hr_utility.trace('i_earthquake : '||to_char(i_earthquake));
1640: hr_utility.trace('i_nonlife_long : '||to_char(i_nonlife_long));
1641: hr_utility.trace('i_nonlife_short : '||to_char(i_nonlife_short));
1642: end if;
1643: --
1644: -- formula datetrack
1645: if (p_effective_date >= hr_api.g_sot
1645: if (p_effective_date >= hr_api.g_sot
1646: and p_effective_date < c_st_upd_date_2007) then
1647: --
1648: if g_debug then
1649: hr_utility.set_location(l_proc,10);
1650: end if;
1651: --
1652: o_earthquake := null;
1653: --
1653: --
1654: if i_nonlife_long > 0 then
1655: --
1656: if g_debug then
1657: hr_utility.set_location(l_proc,20);
1658: end if;
1659: --
1660: -- udt satisfy validation of max value
1661: o_nonlife_long := round(i_nonlife_long
1672: to_char(i_nonlife_long),
1673: p_effective_date)));
1674: --
1675: if g_debug then
1676: hr_utility.set_location(l_proc,30);
1677: end if;
1678: --
1679: end if;
1680: --
1678: --
1679: end if;
1680: --
1681: if g_debug then
1682: hr_utility.set_location(l_proc,40);
1683: end if;
1684: --
1685: if i_nonlife_short > 0 then
1686: --
1684: --
1685: if i_nonlife_short > 0 then
1686: --
1687: if g_debug then
1688: hr_utility.set_location(l_proc,50);
1689: end if;
1690: --
1691: -- udt satisfy validation of max value
1692: o_nonlife_short := round(i_nonlife_short
1703: to_char(i_nonlife_short),
1704: p_effective_date)));
1705: --
1706: if g_debug then
1707: hr_utility.set_location(l_proc,60);
1708: end if;
1709: --
1710: end if;
1711: --
1725: --
1726: end if;
1727: --
1728: if g_debug then
1729: hr_utility.set_location(l_proc,70);
1730: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1731: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
1732: end if;
1733: --
1726: end if;
1727: --
1728: if g_debug then
1729: hr_utility.set_location(l_proc,70);
1730: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1731: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
1732: end if;
1733: --
1734: if o_nonlife_dct > c_nonlife_max then
1727: --
1728: if g_debug then
1729: hr_utility.set_location(l_proc,70);
1730: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1731: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
1732: end if;
1733: --
1734: if o_nonlife_dct > c_nonlife_max then
1735: o_nonlife_dct := c_nonlife_max;
1735: o_nonlife_dct := c_nonlife_max;
1736: end if;
1737: --
1738: if g_debug then
1739: hr_utility.set_location(l_proc,80);
1740: end if;
1741: --
1742: elsif (p_effective_date >= c_st_upd_date_2007
1743: and p_effective_date <= hr_api.g_eot) then
1742: elsif (p_effective_date >= c_st_upd_date_2007
1743: and p_effective_date <= hr_api.g_eot) then
1744: --
1745: if g_debug then
1746: hr_utility.set_location(l_proc,90);
1747: end if;
1748: --
1749: o_nonlife_short := null;
1750: --
1750: --
1751: if i_earthquake > 0 then
1752: --
1753: if g_debug then
1754: hr_utility.set_location(l_proc,100);
1755: end if;
1756: --
1757: o_earthquake := round(i_earthquake);
1758: if c_earthquake_max is null then
1764: p_effective_date));
1765: end if;
1766: --
1767: if g_debug then
1768: hr_utility.set_location(l_proc,110);
1769: hr_utility.trace('o_earthquake : '||to_char(o_earthquake));
1770: hr_utility.trace('c_earthquake_max : '||to_char(c_earthquake_max));
1771: end if;
1772: --
1765: end if;
1766: --
1767: if g_debug then
1768: hr_utility.set_location(l_proc,110);
1769: hr_utility.trace('o_earthquake : '||to_char(o_earthquake));
1770: hr_utility.trace('c_earthquake_max : '||to_char(c_earthquake_max));
1771: end if;
1772: --
1773: if o_earthquake > c_earthquake_max then
1766: --
1767: if g_debug then
1768: hr_utility.set_location(l_proc,110);
1769: hr_utility.trace('o_earthquake : '||to_char(o_earthquake));
1770: hr_utility.trace('c_earthquake_max : '||to_char(c_earthquake_max));
1771: end if;
1772: --
1773: if o_earthquake > c_earthquake_max then
1774: o_earthquake := c_earthquake_max;
1774: o_earthquake := c_earthquake_max;
1775: end if;
1776: --
1777: if g_debug then
1778: hr_utility.set_location(l_proc,120);
1779: end if;
1780: --
1781: end if;
1782: --
1782: --
1783: if i_nonlife_long > 0 then
1784: --
1785: if g_debug then
1786: hr_utility.set_location(l_proc,130);
1787: end if;
1788: --
1789: -- udt satisfy validation of max value
1790: o_nonlife_long := round(i_nonlife_long
1801: to_char(i_nonlife_long),
1802: p_effective_date)));
1803: --
1804: if g_debug then
1805: hr_utility.set_location(l_proc,140);
1806: end if;
1807: --
1808: end if;
1809: --
1807: --
1808: end if;
1809: --
1810: if g_debug then
1811: hr_utility.set_location(l_proc,150);
1812: end if;
1813: --
1814: o_nonlife_dct := o_earthquake + o_nonlife_long;
1815: --
1827: --
1828: end if;
1829: --
1830: if g_debug then
1831: hr_utility.set_location(l_proc,160);
1832: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1833: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
1834: end if;
1835: --
1828: end if;
1829: --
1830: if g_debug then
1831: hr_utility.set_location(l_proc,160);
1832: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1833: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
1834: end if;
1835: --
1836: if o_nonlife_dct > c_nonlife_max then
1829: --
1830: if g_debug then
1831: hr_utility.set_location(l_proc,160);
1832: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1833: hr_utility.trace('c_nonlife_max : '||to_char(c_nonlife_max));
1834: end if;
1835: --
1836: if o_nonlife_dct > c_nonlife_max then
1837: o_nonlife_dct := c_nonlife_max;
1837: o_nonlife_dct := c_nonlife_max;
1838: end if;
1839: --
1840: if g_debug then
1841: hr_utility.set_location(l_proc,170);
1842: end if;
1843: --
1844: end if;
1845: --
1848: p_nonlife_short_o := o_nonlife_short;
1849: p_nonlife_dct_o := o_nonlife_dct;
1850: --
1851: if g_debug then
1852: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
1853: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
1854: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1849: p_nonlife_dct_o := o_nonlife_dct;
1850: --
1851: if g_debug then
1852: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
1853: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
1854: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1857: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
1850: --
1851: if g_debug then
1852: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
1853: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
1854: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1857: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
1858: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1851: if g_debug then
1852: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
1853: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
1854: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1857: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
1858: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1859: hr_utility.set_location(l_proc,1000);
1852: hr_utility.trace('p_earthquake_o : '||to_char(p_earthquake_o));
1853: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
1854: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1857: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
1858: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1859: hr_utility.set_location(l_proc,1000);
1860: end if;
1853: hr_utility.trace('p_nonlife_long_o : '||to_char(p_nonlife_long_o));
1854: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1857: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
1858: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1859: hr_utility.set_location(l_proc,1000);
1860: end if;
1861: --
1854: hr_utility.trace('p_nonlife_short_o : '||to_char(p_nonlife_short_o));
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1857: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
1858: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1859: hr_utility.set_location(l_proc,1000);
1860: end if;
1861: --
1862: end calc_nonlife_dct;
1855: hr_utility.trace('p_nonlife_dct_o : '||to_char(p_nonlife_dct_o));
1856: hr_utility.trace('o_nonlife_long : '||to_char(o_nonlife_long));
1857: hr_utility.trace('o_nonlife_short : '||to_char(o_nonlife_short));
1858: hr_utility.trace('o_nonlife_dct : '||to_char(o_nonlife_dct));
1859: hr_utility.set_location(l_proc,1000);
1860: end if;
1861: --
1862: end calc_nonlife_dct;
1863: --
1883: --
1884: begin
1885: --
1886: if g_debug then
1887: hr_utility.set_location(l_proc,0);
1888: hr_utility.trace('calc_nonlife_dct wrapper');
1889: end if;
1890: --
1891: if (p_effective_date >= hr_api.g_sot
1884: begin
1885: --
1886: if g_debug then
1887: hr_utility.set_location(l_proc,0);
1888: hr_utility.trace('calc_nonlife_dct wrapper');
1889: end if;
1890: --
1891: if (p_effective_date >= hr_api.g_sot
1892: and p_effective_date < c_st_upd_date_2007) then
1891: if (p_effective_date >= hr_api.g_sot
1892: and p_effective_date < c_st_upd_date_2007) then
1893: --
1894: if g_debug then
1895: hr_utility.set_location(l_proc,10);
1896: end if;
1897: --
1898: calc_nonlife_dct(
1899: p_earthquake_i => p_earthquake_i,
1912: p_nonlife_long_o := o_nonlife_long;
1913: p_nonlife_dct_o := o_nonlife_dct;
1914: --
1915: if g_debug then
1916: hr_utility.set_location(l_proc,1000);
1917: end if;
1918: --
1919: end calc_nonlife_dct;
1920: --
1934: --
1935: begin
1936: --
1937: if g_debug then
1938: hr_utility.set_location(l_proc,0);
1939: hr_utility.trace('p_social_i : '||to_char(p_social_i));
1940: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1941: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1942: hr_utility.trace('i_social : '||to_char(i_social));
1935: begin
1936: --
1937: if g_debug then
1938: hr_utility.set_location(l_proc,0);
1939: hr_utility.trace('p_social_i : '||to_char(p_social_i));
1940: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1941: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1942: hr_utility.trace('i_social : '||to_char(i_social));
1943: end if;
1936: --
1937: if g_debug then
1938: hr_utility.set_location(l_proc,0);
1939: hr_utility.trace('p_social_i : '||to_char(p_social_i));
1940: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1941: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1942: hr_utility.trace('i_social : '||to_char(i_social));
1943: end if;
1944: --
1937: if g_debug then
1938: hr_utility.set_location(l_proc,0);
1939: hr_utility.trace('p_social_i : '||to_char(p_social_i));
1940: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1941: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1942: hr_utility.trace('i_social : '||to_char(i_social));
1943: end if;
1944: --
1945: -- formula datetrack
1938: hr_utility.set_location(l_proc,0);
1939: hr_utility.trace('p_social_i : '||to_char(p_social_i));
1940: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
1941: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
1942: hr_utility.trace('i_social : '||to_char(i_social));
1943: end if;
1944: --
1945: -- formula datetrack
1946: if (p_effective_date >= hr_api.g_sot
1946: if (p_effective_date >= hr_api.g_sot
1947: and p_effective_date <= hr_api.g_eot) then
1948: --
1949: if g_debug then
1950: hr_utility.set_location(l_proc,10);
1951: end if;
1952: --
1953: if i_social < 0 then
1954: --
1952: --
1953: if i_social < 0 then
1954: --
1955: if g_debug then
1956: hr_utility.set_location(l_proc,20);
1957: end if;
1958: --
1959: o_social_dct := 0;
1960: --
1962: --
1963: o_social_dct := round(i_social);
1964: --
1965: if g_debug then
1966: hr_utility.set_location(l_proc,30);
1967: end if;
1968: --
1969: end if;
1970: --
1972: --
1973: p_social_dct_o := o_social_dct;
1974: --
1975: if g_debug then
1976: hr_utility.trace('p_social_dct_o : '||to_char(p_social_dct_o));
1977: hr_utility.trace('o_social_dct : '||to_char(o_social_dct));
1978: hr_utility.set_location(l_proc,1000);
1979: end if;
1980: --
1973: p_social_dct_o := o_social_dct;
1974: --
1975: if g_debug then
1976: hr_utility.trace('p_social_dct_o : '||to_char(p_social_dct_o));
1977: hr_utility.trace('o_social_dct : '||to_char(o_social_dct));
1978: hr_utility.set_location(l_proc,1000);
1979: end if;
1980: --
1981: end calc_social_dct;
1974: --
1975: if g_debug then
1976: hr_utility.trace('p_social_dct_o : '||to_char(p_social_dct_o));
1977: hr_utility.trace('o_social_dct : '||to_char(o_social_dct));
1978: hr_utility.set_location(l_proc,1000);
1979: end if;
1980: --
1981: end calc_social_dct;
1982: --
2000: --
2001: begin
2002: --
2003: if g_debug then
2004: hr_utility.set_location(l_proc,0);
2005: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2006: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2001: begin
2002: --
2003: if g_debug then
2004: hr_utility.set_location(l_proc,0);
2005: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2006: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2002: --
2003: if g_debug then
2004: hr_utility.set_location(l_proc,0);
2005: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2006: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2010: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2003: if g_debug then
2004: hr_utility.set_location(l_proc,0);
2005: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2006: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2010: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2011: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2004: hr_utility.set_location(l_proc,0);
2005: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2006: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2010: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2011: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2012: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2005: hr_utility.trace('p_mutual_aid_ec_i : '||to_char(p_mutual_aid_ec_i));
2006: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2010: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2011: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2012: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2013: end if;
2006: hr_utility.trace('p_mutual_aid_p_i : '||to_char(p_mutual_aid_p_i));
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2010: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2011: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2012: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2013: end if;
2014: --
2007: hr_utility.trace('p_mutual_aid_dsc_i : '||to_char(p_mutual_aid_dsc_i));
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2010: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2011: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2012: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2013: end if;
2014: --
2015: -- formula datetrack
2008: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2009: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2010: hr_utility.trace('i_mutual_aid_ec : '||to_char(i_mutual_aid_ec));
2011: hr_utility.trace('i_mutual_aid_p : '||to_char(i_mutual_aid_p));
2012: hr_utility.trace('i_mutual_aid_dsc : '||to_char(i_mutual_aid_dsc));
2013: end if;
2014: --
2015: -- formula datetrack
2016: if (p_effective_date >= hr_api.g_sot
2016: if (p_effective_date >= hr_api.g_sot
2017: and p_effective_date <= hr_api.g_eot) then
2018: --
2019: if g_debug then
2020: hr_utility.set_location(l_proc,10);
2021: end if;
2022: --
2023: o_mutual_aid_dct := round(i_mutual_aid_ec + i_mutual_aid_p + i_mutual_aid_dsc);
2024: --
2026: --
2027: p_mutual_aid_dct_o := o_mutual_aid_dct;
2028: --
2029: if g_debug then
2030: hr_utility.trace('p_mutual_aid_dct_o : '||to_char(p_mutual_aid_dct_o));
2031: hr_utility.trace('o_mutual_aid_dct : '||to_char(o_mutual_aid_dct));
2032: hr_utility.set_location(l_proc,1000);
2033: end if;
2034: --
2027: p_mutual_aid_dct_o := o_mutual_aid_dct;
2028: --
2029: if g_debug then
2030: hr_utility.trace('p_mutual_aid_dct_o : '||to_char(p_mutual_aid_dct_o));
2031: hr_utility.trace('o_mutual_aid_dct : '||to_char(o_mutual_aid_dct));
2032: hr_utility.set_location(l_proc,1000);
2033: end if;
2034: --
2035: end calc_mutual_aid_dct;
2028: --
2029: if g_debug then
2030: hr_utility.trace('p_mutual_aid_dct_o : '||to_char(p_mutual_aid_dct_o));
2031: hr_utility.trace('o_mutual_aid_dct : '||to_char(o_mutual_aid_dct));
2032: hr_utility.set_location(l_proc,1000);
2033: end if;
2034: --
2035: end calc_mutual_aid_dct;
2036: --
2083: -- (At the calculated time, system cannot know final eev data at the yea runtime,
2084: -- so the result by this calculation might be different from final yea run result.)
2085: --
2086: if g_debug then
2087: hr_utility.set_location(l_proc,0);
2088: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2089: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2084: -- so the result by this calculation might be different from final yea run result.)
2085: --
2086: if g_debug then
2087: hr_utility.set_location(l_proc,0);
2088: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2089: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2085: --
2086: if g_debug then
2087: hr_utility.set_location(l_proc,0);
2088: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2089: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2086: if g_debug then
2087: hr_utility.set_location(l_proc,0);
2088: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2089: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2087: hr_utility.set_location(l_proc,0);
2088: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2089: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2095: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2088: hr_utility.trace('p_spouse_income_i : '||to_char(p_spouse_income_i));
2089: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2095: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2096: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2089: hr_utility.trace('p_emp_income_i : '||to_char(p_emp_income_i));
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2095: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2096: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2097: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2090: hr_utility.trace('p_business_group_id : '||to_char(p_business_group_id));
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2095: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2096: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2097: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2098: end if;
2091: hr_utility.trace('p_effective_date : '||to_char(p_effective_date,'YYYY/MM/DD'));
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2095: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2096: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2097: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2098: end if;
2099: --
2092: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2095: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2096: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2097: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2098: end if;
2099: --
2100: -- formula datetrack
2093: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2094: hr_utility.trace('following are just information');
2095: hr_utility.trace('p_sp_type_i : '||p_sp_type_i);
2096: hr_utility.trace('p_wid_type_i : '||p_wid_type_i);
2097: hr_utility.trace('p_dct_exc_i : '||p_dct_exc_i);
2098: end if;
2099: --
2100: -- formula datetrack
2101: if (p_effective_date >= hr_api.g_sot
2101: if (p_effective_date >= hr_api.g_sot
2102: and p_effective_date <= hr_api.g_eot) then
2103: --
2104: if g_debug then
2105: hr_utility.set_location(l_proc,10);
2106: end if;
2107: --
2108: if nvl(p_spouse_income_i,0) > 0
2109: and nvl(p_dct_exc_i,'N') = 'N' then
2108: if nvl(p_spouse_income_i,0) > 0
2109: and nvl(p_dct_exc_i,'N') = 'N' then
2110: --
2111: if g_debug then
2112: hr_utility.set_location(l_proc,20);
2113: end if;
2114: --
2115: if c_emp_income_max is null then
2116: --
2121: c_sp_emp_income_udtrow,
2122: p_effective_date));
2123: --
2124: if g_debug then
2125: hr_utility.set_location(l_proc,30);
2126: hr_utility.trace('c_emp_income_max : '||to_char(c_emp_income_max));
2127: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2128: end if;
2129: --
2122: p_effective_date));
2123: --
2124: if g_debug then
2125: hr_utility.set_location(l_proc,30);
2126: hr_utility.trace('c_emp_income_max : '||to_char(c_emp_income_max));
2127: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2128: end if;
2129: --
2130: end if;
2123: --
2124: if g_debug then
2125: hr_utility.set_location(l_proc,30);
2126: hr_utility.trace('c_emp_income_max : '||to_char(c_emp_income_max));
2127: hr_utility.trace('i_emp_income : '||to_char(i_emp_income));
2128: end if;
2129: --
2130: end if;
2131: --
2134: -- calculate when sp_type is null since eev might be set in future.
2135: and nvl(p_sp_type_i,'1') <> '0' then
2136: --
2137: if g_debug then
2138: hr_utility.set_location(l_proc,40);
2139: end if;
2140: --
2141: if c_inc_spouse_dct_max is null then
2142: --
2147: c_sp_dctable_sp_income_udtrow,
2148: p_effective_date));
2149: --
2150: if g_debug then
2151: hr_utility.set_location(l_proc,50);
2152: hr_utility.trace('c_inc_spouse_dct_max : '||to_char(c_inc_spouse_dct_max));
2153: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2154: end if;
2155: --
2148: p_effective_date));
2149: --
2150: if g_debug then
2151: hr_utility.set_location(l_proc,50);
2152: hr_utility.trace('c_inc_spouse_dct_max : '||to_char(c_inc_spouse_dct_max));
2153: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2154: end if;
2155: --
2156: end if;
2149: --
2150: if g_debug then
2151: hr_utility.set_location(l_proc,50);
2152: hr_utility.trace('c_inc_spouse_dct_max : '||to_char(c_inc_spouse_dct_max));
2153: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2154: end if;
2155: --
2156: end if;
2157: --
2158: -- even spouse_type is 2,3, if over inc_spouse_dct_max, they can be deductive for sp_spouse_dct.
2159: if i_spouse_income > c_inc_spouse_dct_max then
2160: --
2161: if g_debug then
2162: hr_utility.set_location(l_proc,60);
2163: end if;
2164: --
2165: if c_spouse_income_max is null then
2166: --
2173: --
2174: end if;
2175: --
2176: if g_debug then
2177: hr_utility.set_location(l_proc,70);
2178: hr_utility.trace('c_spouse_income_max : '||to_char(c_spouse_income_max));
2179: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2180: end if;
2181: --
2174: end if;
2175: --
2176: if g_debug then
2177: hr_utility.set_location(l_proc,70);
2178: hr_utility.trace('c_spouse_income_max : '||to_char(c_spouse_income_max));
2179: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2180: end if;
2181: --
2182: if i_spouse_income < c_spouse_income_max then
2175: --
2176: if g_debug then
2177: hr_utility.set_location(l_proc,70);
2178: hr_utility.trace('c_spouse_income_max : '||to_char(c_spouse_income_max));
2179: hr_utility.trace('i_spouse_income : '||to_char(i_spouse_income));
2180: end if;
2181: --
2182: if i_spouse_income < c_spouse_income_max then
2183: --
2188: to_char(i_spouse_income),
2189: p_effective_date)));
2190: --
2191: if g_debug then
2192: hr_utility.set_location(l_proc,80);
2193: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2194: end if;
2195: --
2196: end if;
2189: p_effective_date)));
2190: --
2191: if g_debug then
2192: hr_utility.set_location(l_proc,80);
2193: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2194: end if;
2195: --
2196: end if;
2197: --
2205: --
2206: p_spouse_dct_o := o_spouse_dct;
2207: --
2208: if g_debug then
2209: hr_utility.trace('p_spouse_dct_o : '||to_char(p_spouse_dct_o));
2210: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2211: hr_utility.set_location(l_proc,1000);
2212: end if;
2213: --
2206: p_spouse_dct_o := o_spouse_dct;
2207: --
2208: if g_debug then
2209: hr_utility.trace('p_spouse_dct_o : '||to_char(p_spouse_dct_o));
2210: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2211: hr_utility.set_location(l_proc,1000);
2212: end if;
2213: --
2214: end calc_spouse_dct;
2207: --
2208: if g_debug then
2209: hr_utility.trace('p_spouse_dct_o : '||to_char(p_spouse_dct_o));
2210: hr_utility.trace('o_spouse_dct : '||to_char(o_spouse_dct));
2211: hr_utility.set_location(l_proc,1000);
2212: end if;
2213: --
2214: end calc_spouse_dct;
2215: --
2247: --
2248: begin
2249: --
2250: if g_debug then
2251: hr_utility.set_location(l_proc,0);
2252: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2253: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2248: begin
2249: --
2250: if g_debug then
2251: hr_utility.set_location(l_proc,0);
2252: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2253: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2249: --
2250: if g_debug then
2251: hr_utility.set_location(l_proc,0);
2252: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2253: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2250: if g_debug then
2251: hr_utility.set_location(l_proc,0);
2252: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2253: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2251: hr_utility.set_location(l_proc,0);
2252: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2253: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2252: hr_utility.trace('p_sp_earned_inc_i : '||to_char(p_sp_earned_inc_i));
2253: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2253: hr_utility.trace('p_sp_earned_inc_exp_i : '||to_char(p_sp_earned_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2254: hr_utility.trace('p_sp_business_inc_i : '||to_char(p_sp_business_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2255: hr_utility.trace('p_sp_business_inc_exp_i : '||to_char(p_sp_business_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2256: hr_utility.trace('p_sp_miscellaneous_inc_i : '||to_char(p_sp_miscellaneous_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2257: hr_utility.trace('p_sp_miscellaneous_inc_exp_i : '||to_char(p_sp_miscellaneous_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2258: hr_utility.trace('p_sp_dividend_inc_i : '||to_char(p_sp_dividend_inc_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2259: hr_utility.trace('p_sp_dividend_inc_exp_i : '||to_char(p_sp_dividend_inc_exp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2260: hr_utility.trace('p_sp_real_estate_inc_i : '||to_char(p_sp_real_estate_inc_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2268: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2261: hr_utility.trace('p_sp_real_estate_inc_exp_i : '||to_char(p_sp_real_estate_inc_exp_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2268: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2269: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2262: hr_utility.trace('p_sp_retirement_inc_i : '||to_char(p_sp_retirement_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2268: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2269: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2270: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2263: hr_utility.trace('p_sp_retirement_inc_exp_i : '||to_char(p_sp_retirement_inc_exp_i));
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2268: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2269: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2270: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2271: end if;
2264: hr_utility.trace('p_sp_other_inc_i : '||to_char(p_sp_other_inc_i));
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2268: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2269: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2270: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2271: end if;
2272: --
2265: hr_utility.trace('p_sp_other_inc_exp_i : '||to_char(p_sp_other_inc_exp_i));
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2268: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2269: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2270: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2271: end if;
2272: --
2273: p_calc_spouse_inc_rec.sp_earned_inc_calc := 0;
2266: hr_utility.trace('p_sp_other_inc_exp_dct_i : '||to_char(p_sp_other_inc_exp_dct_i));
2267: hr_utility.trace('p_sp_other_inc_exp_tmp_i : '||to_char(p_sp_other_inc_exp_tmp_i));
2268: hr_utility.trace('p_sp_other_inc_exp_tmp_exp_i : '||to_char(p_sp_other_inc_exp_tmp_exp_i));
2269: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2270: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2271: end if;
2272: --
2273: p_calc_spouse_inc_rec.sp_earned_inc_calc := 0;
2274: p_calc_spouse_inc_rec.sp_business_inc_calc := 0;
2359: --
2360: end if;
2361: --
2362: if g_debug then
2363: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2364: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2365: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2360: end if;
2361: --
2362: if g_debug then
2363: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2364: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2365: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2361: --
2362: if g_debug then
2363: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2364: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2365: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2362: if g_debug then
2363: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2364: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2365: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2363: hr_utility.trace('p_calc_spouse_inc_rec.sp_earned_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_earned_inc_calc));
2364: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2365: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2364: hr_utility.trace('p_calc_spouse_inc_rec.sp_business_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_business_inc_calc));
2365: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2372: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2365: hr_utility.trace('p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_miscellaneous_inc_calc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2372: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2373: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2366: hr_utility.trace('p_calc_spouse_inc_rec.sp_dividend_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_dividend_inc_calc));
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2372: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2373: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2374: hr_utility.set_location(l_proc,1000);
2367: 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));
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2372: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2373: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2374: hr_utility.set_location(l_proc,1000);
2375: end if;
2368: hr_utility.trace('p_calc_spouse_inc_rec.sp_retirement_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_retirement_inc_calc));
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2372: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2373: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2374: hr_utility.set_location(l_proc,1000);
2375: end if;
2376: --
2369: hr_utility.trace('p_calc_spouse_inc_rec.sp_other_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_other_inc_calc));
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2372: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2373: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2374: hr_utility.set_location(l_proc,1000);
2375: end if;
2376: --
2377: p_spouse_inc_o := o_spouse_inc;
2370: hr_utility.trace('p_sp_inc_cnt_i : '||to_char(p_sp_inc_cnt_i));
2371: hr_utility.trace('p_calc_spouse_inc_rec.sp_inc_calc : '||to_char(p_calc_spouse_inc_rec.sp_inc_calc));
2372: hr_utility.trace('p_ent_spouse_inc_i : '||to_char(p_ent_spouse_inc_i));
2373: hr_utility.trace('o_spouse_inc : '||to_char(o_spouse_inc));
2374: hr_utility.set_location(l_proc,1000);
2375: end if;
2376: --
2377: p_spouse_inc_o := o_spouse_inc;
2378: --
2407: --
2408: begin
2409: --
2410: if g_debug then
2411: hr_utility.set_location(l_proc,0);
2412: end if;
2413: --
2414: calc_total(
2415: p_assignment_action_id => p_assignment_action_id,
2516: --
2517: end if;
2518: --
2519: if g_debug then
2520: hr_utility.trace('end update_assact');
2521: hr_utility.set_location(l_proc,1000);
2522: end if;
2523: --
2524: end calc_dct;
2517: end if;
2518: --
2519: if g_debug then
2520: hr_utility.trace('end update_assact');
2521: hr_utility.set_location(l_proc,1000);
2522: end if;
2523: --
2524: end calc_dct;
2525: --
2551: --
2552: begin
2553: --
2554: if g_debug then
2555: hr_utility.set_location(l_proc,0);
2556: end if;
2557: --
2558: l_submission_date := check_submission_period(p_action_information_id);
2559: --
2557: --
2558: l_submission_date := check_submission_period(p_action_information_id);
2559: --
2560: if g_debug then
2561: hr_utility.set_location(l_proc,10);
2562: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
2563: end if;
2564: --
2565: -- unnecessary to lock
2558: l_submission_date := check_submission_period(p_action_information_id);
2559: --
2560: if g_debug then
2561: hr_utility.set_location(l_proc,10);
2562: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
2563: end if;
2564: --
2565: -- unnecessary to lock
2566: select *
2573: fnd_message.raise_error;
2574: end if;
2575: --
2576: if g_debug then
2577: hr_utility.set_location(l_proc,20);
2578: hr_utility.trace('action_information_id : '||p_action_information_id);
2579: hr_utility.trace('object_version_number : '||p_object_version_number);
2580: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2581: hr_utility.trace('start calc_ins');
2574: end if;
2575: --
2576: if g_debug then
2577: hr_utility.set_location(l_proc,20);
2578: hr_utility.trace('action_information_id : '||p_action_information_id);
2579: hr_utility.trace('object_version_number : '||p_object_version_number);
2580: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2581: hr_utility.trace('start calc_ins');
2582: end if;
2575: --
2576: if g_debug then
2577: hr_utility.set_location(l_proc,20);
2578: hr_utility.trace('action_information_id : '||p_action_information_id);
2579: hr_utility.trace('object_version_number : '||p_object_version_number);
2580: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2581: hr_utility.trace('start calc_ins');
2582: end if;
2583: --
2576: if g_debug then
2577: hr_utility.set_location(l_proc,20);
2578: hr_utility.trace('action_information_id : '||p_action_information_id);
2579: hr_utility.trace('object_version_number : '||p_object_version_number);
2580: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2581: hr_utility.trace('start calc_ins');
2582: end if;
2583: --
2584: calc_dct(
2577: hr_utility.set_location(l_proc,20);
2578: hr_utility.trace('action_information_id : '||p_action_information_id);
2579: hr_utility.trace('object_version_number : '||p_object_version_number);
2580: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2581: hr_utility.trace('start calc_ins');
2582: end if;
2583: --
2584: calc_dct(
2585: p_assignment_action_id => l_assact_rec.assignment_action_id,
2668: --
2669: end if;
2670: --
2671: if g_debug then
2672: hr_utility.trace('end update_assact');
2673: hr_utility.set_location(l_proc,1000);
2674: end if;
2675: --
2676: end do_calculate;
2669: end if;
2670: --
2671: if g_debug then
2672: hr_utility.trace('end update_assact');
2673: hr_utility.set_location(l_proc,1000);
2674: end if;
2675: --
2676: end do_calculate;
2677: --
2715: --
2716: begin
2717: --
2718: if g_debug then
2719: hr_utility.set_location(l_proc,0);
2720: end if;
2721: --
2722: l_submission_date := check_submission_period(p_action_information_id);
2723: --
2721: --
2722: l_submission_date := check_submission_period(p_action_information_id);
2723: --
2724: if g_debug then
2725: hr_utility.set_location(l_proc,10);
2726: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
2727: end if;
2728: --
2729: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2722: l_submission_date := check_submission_period(p_action_information_id);
2723: --
2724: if g_debug then
2725: hr_utility.set_location(l_proc,10);
2726: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
2727: end if;
2728: --
2729: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2730: --
2733: fnd_message.raise_error;
2734: end if;
2735: --
2736: if g_debug then
2737: hr_utility.set_location(l_proc,20);
2738: hr_utility.trace('action_information_id : '||p_action_information_id);
2739: hr_utility.trace('object_version_number : '||p_object_version_number);
2740: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2741: hr_utility.trace('start calc_dct before finalize');
2734: end if;
2735: --
2736: if g_debug then
2737: hr_utility.set_location(l_proc,20);
2738: hr_utility.trace('action_information_id : '||p_action_information_id);
2739: hr_utility.trace('object_version_number : '||p_object_version_number);
2740: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2741: hr_utility.trace('start calc_dct before finalize');
2742: end if;
2735: --
2736: if g_debug then
2737: hr_utility.set_location(l_proc,20);
2738: hr_utility.trace('action_information_id : '||p_action_information_id);
2739: hr_utility.trace('object_version_number : '||p_object_version_number);
2740: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2741: hr_utility.trace('start calc_dct before finalize');
2742: end if;
2743: --
2736: if g_debug then
2737: hr_utility.set_location(l_proc,20);
2738: hr_utility.trace('action_information_id : '||p_action_information_id);
2739: hr_utility.trace('object_version_number : '||p_object_version_number);
2740: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2741: hr_utility.trace('start calc_dct before finalize');
2742: end if;
2743: --
2744: calc_dct(
2737: hr_utility.set_location(l_proc,20);
2738: hr_utility.trace('action_information_id : '||p_action_information_id);
2739: hr_utility.trace('object_version_number : '||p_object_version_number);
2740: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2741: hr_utility.trace('start calc_dct before finalize');
2742: end if;
2743: --
2744: calc_dct(
2745: p_assignment_action_id => l_assact_rec.assignment_action_id,
2945: --
2946: end if;
2947: --
2948: if g_debug then
2949: hr_utility.set_location(l_proc,20);
2950: hr_utility.trace('end calc_dct before finalize');
2951: end if;
2952: --
2953: if g_debug then
2946: end if;
2947: --
2948: if g_debug then
2949: hr_utility.set_location(l_proc,20);
2950: hr_utility.trace('end calc_dct before finalize');
2951: end if;
2952: --
2953: if g_debug then
2954: hr_utility.set_location(l_proc,20);
2950: hr_utility.trace('end calc_dct before finalize');
2951: end if;
2952: --
2953: if g_debug then
2954: hr_utility.set_location(l_proc,20);
2955: hr_utility.trace('action_information_id : '||p_action_information_id);
2956: hr_utility.trace('object_version_number : '||p_object_version_number);
2957: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2958: hr_utility.trace('start update_assact');
2951: end if;
2952: --
2953: if g_debug then
2954: hr_utility.set_location(l_proc,20);
2955: hr_utility.trace('action_information_id : '||p_action_information_id);
2956: hr_utility.trace('object_version_number : '||p_object_version_number);
2957: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2958: hr_utility.trace('start update_assact');
2959: end if;
2952: --
2953: if g_debug then
2954: hr_utility.set_location(l_proc,20);
2955: hr_utility.trace('action_information_id : '||p_action_information_id);
2956: hr_utility.trace('object_version_number : '||p_object_version_number);
2957: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2958: hr_utility.trace('start update_assact');
2959: end if;
2960: --
2953: if g_debug then
2954: hr_utility.set_location(l_proc,20);
2955: hr_utility.trace('action_information_id : '||p_action_information_id);
2956: hr_utility.trace('object_version_number : '||p_object_version_number);
2957: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2958: hr_utility.trace('start update_assact');
2959: end if;
2960: --
2961: p_object_version_number := l_assact_rec.object_version_number + 1;
2954: hr_utility.set_location(l_proc,20);
2955: hr_utility.trace('action_information_id : '||p_action_information_id);
2956: hr_utility.trace('object_version_number : '||p_object_version_number);
2957: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
2958: hr_utility.trace('start update_assact');
2959: end if;
2960: --
2961: p_object_version_number := l_assact_rec.object_version_number + 1;
2962: --
2980: user_comments = p_user_comments
2981: where row_id = l_assact_rec.row_id;
2982: --
2983: if g_debug then
2984: hr_utility.trace('end update_assact');
2985: hr_utility.set_location(l_proc,1000);
2986: end if;
2987: --
2988: end do_finalize;
2981: where row_id = l_assact_rec.row_id;
2982: --
2983: if g_debug then
2984: hr_utility.trace('end update_assact');
2985: hr_utility.set_location(l_proc,1000);
2986: end if;
2987: --
2988: end do_finalize;
2989: --
3002: --
3003: begin
3004: --
3005: if g_debug then
3006: hr_utility.set_location(l_proc,0);
3007: end if;
3008: --
3009: l_submission_date := check_submission_period(p_action_information_id);
3010: --
3008: --
3009: l_submission_date := check_submission_period(p_action_information_id);
3010: --
3011: if g_debug then
3012: hr_utility.set_location(l_proc,10);
3013: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3014: end if;
3015: --
3016: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3009: l_submission_date := check_submission_period(p_action_information_id);
3010: --
3011: if g_debug then
3012: hr_utility.set_location(l_proc,10);
3013: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3014: end if;
3015: --
3016: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3017: --
3023: fnd_message.raise_error;
3024: end if;
3025: --
3026: if g_debug then
3027: hr_utility.set_location(l_proc,20);
3028: hr_utility.trace('action_information_id : '||p_action_information_id);
3029: hr_utility.trace('object_version_number : '||p_object_version_number);
3030: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3031: hr_utility.trace('start calc_dct before finalize');
3024: end if;
3025: --
3026: if g_debug then
3027: hr_utility.set_location(l_proc,20);
3028: hr_utility.trace('action_information_id : '||p_action_information_id);
3029: hr_utility.trace('object_version_number : '||p_object_version_number);
3030: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3031: hr_utility.trace('start calc_dct before finalize');
3032: end if;
3025: --
3026: if g_debug then
3027: hr_utility.set_location(l_proc,20);
3028: hr_utility.trace('action_information_id : '||p_action_information_id);
3029: hr_utility.trace('object_version_number : '||p_object_version_number);
3030: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3031: hr_utility.trace('start calc_dct before finalize');
3032: end if;
3033: --
3026: if g_debug then
3027: hr_utility.set_location(l_proc,20);
3028: hr_utility.trace('action_information_id : '||p_action_information_id);
3029: hr_utility.trace('object_version_number : '||p_object_version_number);
3030: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3031: hr_utility.trace('start calc_dct before finalize');
3032: end if;
3033: --
3034: delete
3027: hr_utility.set_location(l_proc,20);
3028: hr_utility.trace('action_information_id : '||p_action_information_id);
3029: hr_utility.trace('object_version_number : '||p_object_version_number);
3030: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3031: hr_utility.trace('start calc_dct before finalize');
3032: end if;
3033: --
3034: delete
3035: from pay_action_information
3037: and action_context_type = 'AAP'
3038: and action_information_category <> 'JP_ISDF_ASSACT';
3039: --
3040: if g_debug then
3041: hr_utility.set_location(l_proc,20);
3042: hr_utility.trace('action_information_id : '||p_action_information_id);
3043: hr_utility.trace('object_version_number : '||p_object_version_number);
3044: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3045: hr_utility.trace('start update_assact');
3038: and action_information_category <> 'JP_ISDF_ASSACT';
3039: --
3040: if g_debug then
3041: hr_utility.set_location(l_proc,20);
3042: hr_utility.trace('action_information_id : '||p_action_information_id);
3043: hr_utility.trace('object_version_number : '||p_object_version_number);
3044: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3045: hr_utility.trace('start update_assact');
3046: end if;
3039: --
3040: if g_debug then
3041: hr_utility.set_location(l_proc,20);
3042: hr_utility.trace('action_information_id : '||p_action_information_id);
3043: hr_utility.trace('object_version_number : '||p_object_version_number);
3044: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3045: hr_utility.trace('start update_assact');
3046: end if;
3047: --
3040: if g_debug then
3041: hr_utility.set_location(l_proc,20);
3042: hr_utility.trace('action_information_id : '||p_action_information_id);
3043: hr_utility.trace('object_version_number : '||p_object_version_number);
3044: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3045: hr_utility.trace('start update_assact');
3046: end if;
3047: --
3048: p_object_version_number := l_assact_rec.object_version_number + 1;
3041: hr_utility.set_location(l_proc,20);
3042: hr_utility.trace('action_information_id : '||p_action_information_id);
3043: hr_utility.trace('object_version_number : '||p_object_version_number);
3044: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3045: hr_utility.trace('start update_assact');
3046: end if;
3047: --
3048: p_object_version_number := l_assact_rec.object_version_number + 1;
3049: --
3067: admin_comments = p_admin_comments
3068: where row_id = l_assact_rec.row_id;
3069: --
3070: if g_debug then
3071: hr_utility.trace('end update_assact');
3072: hr_utility.set_location(l_proc,1000);
3073: end if;
3074: --
3075: end do_reject;
3068: where row_id = l_assact_rec.row_id;
3069: --
3070: if g_debug then
3071: hr_utility.trace('end update_assact');
3072: hr_utility.set_location(l_proc,1000);
3073: end if;
3074: --
3075: end do_reject;
3076: --
3089: --
3090: begin
3091: --
3092: if g_debug then
3093: hr_utility.set_location(l_proc,0);
3094: end if;
3095: --
3096: l_submission_date := check_submission_period(p_action_information_id);
3097: --
3095: --
3096: l_submission_date := check_submission_period(p_action_information_id);
3097: --
3098: if g_debug then
3099: hr_utility.set_location(l_proc,10);
3100: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3101: end if;
3102: --
3103: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3096: l_submission_date := check_submission_period(p_action_information_id);
3097: --
3098: if g_debug then
3099: hr_utility.set_location(l_proc,10);
3100: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3101: end if;
3102: --
3103: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3104: --
3110: fnd_message.raise_error;
3111: end if;
3112: --
3113: if g_debug then
3114: hr_utility.set_location(l_proc,20);
3115: hr_utility.trace('action_information_id : '||p_action_information_id);
3116: hr_utility.trace('object_version_number : '||p_object_version_number);
3117: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3118: hr_utility.trace('start calc_dct before finalize');
3111: end if;
3112: --
3113: if g_debug then
3114: hr_utility.set_location(l_proc,20);
3115: hr_utility.trace('action_information_id : '||p_action_information_id);
3116: hr_utility.trace('object_version_number : '||p_object_version_number);
3117: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3118: hr_utility.trace('start calc_dct before finalize');
3119: end if;
3112: --
3113: if g_debug then
3114: hr_utility.set_location(l_proc,20);
3115: hr_utility.trace('action_information_id : '||p_action_information_id);
3116: hr_utility.trace('object_version_number : '||p_object_version_number);
3117: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3118: hr_utility.trace('start calc_dct before finalize');
3119: end if;
3120: --
3113: if g_debug then
3114: hr_utility.set_location(l_proc,20);
3115: hr_utility.trace('action_information_id : '||p_action_information_id);
3116: hr_utility.trace('object_version_number : '||p_object_version_number);
3117: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3118: hr_utility.trace('start calc_dct before finalize');
3119: end if;
3120: --
3121: if g_debug then
3114: hr_utility.set_location(l_proc,20);
3115: hr_utility.trace('action_information_id : '||p_action_information_id);
3116: hr_utility.trace('object_version_number : '||p_object_version_number);
3117: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3118: hr_utility.trace('start calc_dct before finalize');
3119: end if;
3120: --
3121: if g_debug then
3122: hr_utility.set_location(l_proc,20);
3118: hr_utility.trace('start calc_dct before finalize');
3119: end if;
3120: --
3121: if g_debug then
3122: hr_utility.set_location(l_proc,20);
3123: hr_utility.trace('action_information_id : '||p_action_information_id);
3124: hr_utility.trace('object_version_number : '||p_object_version_number);
3125: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3126: hr_utility.trace('start update_assact');
3119: end if;
3120: --
3121: if g_debug then
3122: hr_utility.set_location(l_proc,20);
3123: hr_utility.trace('action_information_id : '||p_action_information_id);
3124: hr_utility.trace('object_version_number : '||p_object_version_number);
3125: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3126: hr_utility.trace('start update_assact');
3127: end if;
3120: --
3121: if g_debug then
3122: hr_utility.set_location(l_proc,20);
3123: hr_utility.trace('action_information_id : '||p_action_information_id);
3124: hr_utility.trace('object_version_number : '||p_object_version_number);
3125: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3126: hr_utility.trace('start update_assact');
3127: end if;
3128: --
3121: if g_debug then
3122: hr_utility.set_location(l_proc,20);
3123: hr_utility.trace('action_information_id : '||p_action_information_id);
3124: hr_utility.trace('object_version_number : '||p_object_version_number);
3125: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3126: hr_utility.trace('start update_assact');
3127: end if;
3128: --
3129: p_object_version_number := l_assact_rec.object_version_number + 1;
3122: hr_utility.set_location(l_proc,20);
3123: hr_utility.trace('action_information_id : '||p_action_information_id);
3124: hr_utility.trace('object_version_number : '||p_object_version_number);
3125: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3126: hr_utility.trace('start update_assact');
3127: end if;
3128: --
3129: p_object_version_number := l_assact_rec.object_version_number + 1;
3130: --
3148: admin_comments = p_admin_comments
3149: where row_id = l_assact_rec.row_id;
3150: --
3151: if g_debug then
3152: hr_utility.trace('end update_assact');
3153: hr_utility.set_location(l_proc,1000);
3154: end if;
3155: --
3156: end do_return;
3149: where row_id = l_assact_rec.row_id;
3150: --
3151: if g_debug then
3152: hr_utility.trace('end update_assact');
3153: hr_utility.set_location(l_proc,1000);
3154: end if;
3155: --
3156: end do_return;
3157: --
3168: --
3169: begin
3170: --
3171: if g_debug then
3172: hr_utility.set_location(l_proc,0);
3173: end if;
3174: --
3175: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3176: --
3179: fnd_message.raise_error;
3180: end if;
3181: --
3182: if g_debug then
3183: hr_utility.set_location(l_proc,20);
3184: hr_utility.trace('action_information_id : '||p_action_information_id);
3185: hr_utility.trace('object_version_number : '||p_object_version_number);
3186: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3187: hr_utility.trace('start calc_dct before finalize');
3180: end if;
3181: --
3182: if g_debug then
3183: hr_utility.set_location(l_proc,20);
3184: hr_utility.trace('action_information_id : '||p_action_information_id);
3185: hr_utility.trace('object_version_number : '||p_object_version_number);
3186: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3187: hr_utility.trace('start calc_dct before finalize');
3188: end if;
3181: --
3182: if g_debug then
3183: hr_utility.set_location(l_proc,20);
3184: hr_utility.trace('action_information_id : '||p_action_information_id);
3185: hr_utility.trace('object_version_number : '||p_object_version_number);
3186: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3187: hr_utility.trace('start calc_dct before finalize');
3188: end if;
3189: --
3182: if g_debug then
3183: hr_utility.set_location(l_proc,20);
3184: hr_utility.trace('action_information_id : '||p_action_information_id);
3185: hr_utility.trace('object_version_number : '||p_object_version_number);
3186: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3187: hr_utility.trace('start calc_dct before finalize');
3188: end if;
3189: --
3190: if g_debug then
3183: hr_utility.set_location(l_proc,20);
3184: hr_utility.trace('action_information_id : '||p_action_information_id);
3185: hr_utility.trace('object_version_number : '||p_object_version_number);
3186: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3187: hr_utility.trace('start calc_dct before finalize');
3188: end if;
3189: --
3190: if g_debug then
3191: hr_utility.set_location(l_proc,20);
3187: hr_utility.trace('start calc_dct before finalize');
3188: end if;
3189: --
3190: if g_debug then
3191: hr_utility.set_location(l_proc,20);
3192: hr_utility.trace('action_information_id : '||p_action_information_id);
3193: hr_utility.trace('object_version_number : '||p_object_version_number);
3194: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3195: hr_utility.trace('start update_assact');
3188: end if;
3189: --
3190: if g_debug then
3191: hr_utility.set_location(l_proc,20);
3192: hr_utility.trace('action_information_id : '||p_action_information_id);
3193: hr_utility.trace('object_version_number : '||p_object_version_number);
3194: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3195: hr_utility.trace('start update_assact');
3196: end if;
3189: --
3190: if g_debug then
3191: hr_utility.set_location(l_proc,20);
3192: hr_utility.trace('action_information_id : '||p_action_information_id);
3193: hr_utility.trace('object_version_number : '||p_object_version_number);
3194: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3195: hr_utility.trace('start update_assact');
3196: end if;
3197: --
3190: if g_debug then
3191: hr_utility.set_location(l_proc,20);
3192: hr_utility.trace('action_information_id : '||p_action_information_id);
3193: hr_utility.trace('object_version_number : '||p_object_version_number);
3194: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3195: hr_utility.trace('start update_assact');
3196: end if;
3197: --
3198: p_object_version_number := l_assact_rec.object_version_number + 1;
3191: hr_utility.set_location(l_proc,20);
3192: hr_utility.trace('action_information_id : '||p_action_information_id);
3193: hr_utility.trace('object_version_number : '||p_object_version_number);
3194: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
3195: hr_utility.trace('start update_assact');
3196: end if;
3197: --
3198: p_object_version_number := l_assact_rec.object_version_number + 1;
3199: --
3214: transaction_status = 'A'
3215: where row_id = l_assact_rec.row_id;
3216: --
3217: if g_debug then
3218: hr_utility.trace('end update_assact');
3219: hr_utility.set_location(l_proc,1000);
3220: end if;
3221: --
3222: end do_approve;
3215: where row_id = l_assact_rec.row_id;
3216: --
3217: if g_debug then
3218: hr_utility.trace('end update_assact');
3219: hr_utility.set_location(l_proc,1000);
3220: end if;
3221: --
3222: end do_approve;
3223: --
3365: --
3366: begin
3367: --
3368: if g_debug then
3369: hr_utility.set_location(l_proc,0);
3370: end if;
3371: --
3372: if p_effective_date is null then
3373: l_effective_date := p_rec.effective_date;
3808: --
3809: end if;
3810: --
3811: if g_debug then
3812: hr_utility.trace('end update_assact');
3813: hr_utility.set_location(l_proc,1000);
3814: end if;
3815: --
3816: end transfer_entry;
3809: end if;
3810: --
3811: if g_debug then
3812: hr_utility.trace('end update_assact');
3813: hr_utility.set_location(l_proc,1000);
3814: end if;
3815: --
3816: end transfer_entry;
3817: --
3837: --
3838: begin
3839: --
3840: if g_debug then
3841: hr_utility.set_location(l_proc,0);
3842: end if;
3843: --
3844: if p_effective_date is null then
3845: l_effective_date := p_rec.effective_date;
3988: --
3989: end if;
3990: --
3991: if g_debug then
3992: hr_utility.trace('end update_assact');
3993: hr_utility.set_location(l_proc,1000);
3994: end if;
3995: --
3996: end transfer_life_gen;
3989: end if;
3990: --
3991: if g_debug then
3992: hr_utility.trace('end update_assact');
3993: hr_utility.set_location(l_proc,1000);
3994: end if;
3995: --
3996: end transfer_life_gen;
3997: --
4017: --
4018: begin
4019: --
4020: if g_debug then
4021: hr_utility.set_location(l_proc,0);
4022: end if;
4023: --
4024: if p_effective_date is null then
4025: l_effective_date := p_rec.effective_date;
4171: --
4172: end if;
4173: --
4174: if g_debug then
4175: hr_utility.trace('end update_assact');
4176: hr_utility.set_location(l_proc,1000);
4177: end if;
4178: --
4179: end transfer_life_pens;
4172: end if;
4173: --
4174: if g_debug then
4175: hr_utility.trace('end update_assact');
4176: hr_utility.set_location(l_proc,1000);
4177: end if;
4178: --
4179: end transfer_life_pens;
4180: --
4200: --
4201: begin
4202: --
4203: if g_debug then
4204: hr_utility.set_location(l_proc,0);
4205: end if;
4206: --
4207: if p_effective_date is null then
4208: l_effective_date := p_rec.effective_date;
4357: --
4358: end if;
4359: --
4360: if g_debug then
4361: hr_utility.trace('end update_assact');
4362: hr_utility.set_location(l_proc,1000);
4363: end if;
4364: --
4365: end transfer_nonlife;
4358: end if;
4359: --
4360: if g_debug then
4361: hr_utility.trace('end update_assact');
4362: hr_utility.set_location(l_proc,1000);
4363: end if;
4364: --
4365: end transfer_nonlife;
4366: --
4478: --
4479: begin
4480: --
4481: if g_debug then
4482: hr_utility.set_location(l_proc,0);
4483: end if;
4484: --
4485: hr_api.mandatory_arg_error(l_proc, 'transfer_date', p_transfer_date);
4486: --
4521: insert_session(l_effective_date);
4522: end if;
4523: --
4524: if g_debug then
4525: hr_utility.set_location(l_proc,20);
4526: hr_utility.trace('action_information_id : '||p_action_information_id);
4527: hr_utility.trace('object_version_number : '||p_object_version_number);
4528: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4529: hr_utility.trace('start calc_dct before finalize');
4522: end if;
4523: --
4524: if g_debug then
4525: hr_utility.set_location(l_proc,20);
4526: hr_utility.trace('action_information_id : '||p_action_information_id);
4527: hr_utility.trace('object_version_number : '||p_object_version_number);
4528: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4529: hr_utility.trace('start calc_dct before finalize');
4530: end if;
4523: --
4524: if g_debug then
4525: hr_utility.set_location(l_proc,20);
4526: hr_utility.trace('action_information_id : '||p_action_information_id);
4527: hr_utility.trace('object_version_number : '||p_object_version_number);
4528: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4529: hr_utility.trace('start calc_dct before finalize');
4530: end if;
4531: --
4524: if g_debug then
4525: hr_utility.set_location(l_proc,20);
4526: hr_utility.trace('action_information_id : '||p_action_information_id);
4527: hr_utility.trace('object_version_number : '||p_object_version_number);
4528: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4529: hr_utility.trace('start calc_dct before finalize');
4530: end if;
4531: --
4532: -- Transfer the followings.
4525: hr_utility.set_location(l_proc,20);
4526: hr_utility.trace('action_information_id : '||p_action_information_id);
4527: hr_utility.trace('object_version_number : '||p_object_version_number);
4528: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4529: hr_utility.trace('start calc_dct before finalize');
4530: end if;
4531: --
4532: -- Transfer the followings.
4533: --
4618: transfer_date = fnd_date.date_to_canonical(l_effective_date)
4619: where row_id = l_assact_rec.row_id;
4620: --
4621: if g_debug then
4622: hr_utility.trace('end update_assact');
4623: hr_utility.set_location(l_proc,1000);
4624: end if;
4625: --
4626: end do_transfer;
4619: where row_id = l_assact_rec.row_id;
4620: --
4621: if g_debug then
4622: hr_utility.trace('end update_assact');
4623: hr_utility.set_location(l_proc,1000);
4624: end if;
4625: --
4626: end do_transfer;
4627: --
4675: --
4676: begin
4677: --
4678: if g_debug then
4679: hr_utility.set_location(l_proc,0);
4680: end if;
4681: --
4682: hr_api.mandatory_arg_error(l_proc,'expiry_date',p_expiry_date);
4683: --
4691: fnd_message.raise_error;
4692: end if;
4693: --
4694: if g_debug then
4695: hr_utility.set_location(l_proc,20);
4696: hr_utility.trace('action_information_id : '||p_action_information_id);
4697: hr_utility.trace('object_version_number : '||p_object_version_number);
4698: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4699: hr_utility.trace('start calc_dct before finalize');
4692: end if;
4693: --
4694: if g_debug then
4695: hr_utility.set_location(l_proc,20);
4696: hr_utility.trace('action_information_id : '||p_action_information_id);
4697: hr_utility.trace('object_version_number : '||p_object_version_number);
4698: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4699: hr_utility.trace('start calc_dct before finalize');
4700: end if;
4693: --
4694: if g_debug then
4695: hr_utility.set_location(l_proc,20);
4696: hr_utility.trace('action_information_id : '||p_action_information_id);
4697: hr_utility.trace('object_version_number : '||p_object_version_number);
4698: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4699: hr_utility.trace('start calc_dct before finalize');
4700: end if;
4701: --
4694: if g_debug then
4695: hr_utility.set_location(l_proc,20);
4696: hr_utility.trace('action_information_id : '||p_action_information_id);
4697: hr_utility.trace('object_version_number : '||p_object_version_number);
4698: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4699: hr_utility.trace('start calc_dct before finalize');
4700: end if;
4701: --
4702: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
4695: hr_utility.set_location(l_proc,20);
4696: hr_utility.trace('action_information_id : '||p_action_information_id);
4697: hr_utility.trace('object_version_number : '||p_object_version_number);
4698: hr_utility.trace('assignment_action_id : '||l_assact_rec.assignment_action_id);
4699: hr_utility.trace('start calc_dct before finalize');
4700: end if;
4701: --
4702: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
4703: l_dec_first_date := trunc(l_year_end_date,'MM');
4822: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
4823: where row_id = l_assact_rec.row_id;
4824: --
4825: if g_debug then
4826: hr_utility.trace('end update_assact');
4827: hr_utility.set_location(l_proc,1000);
4828: end if;
4829: --
4830: end do_expire;
4823: where row_id = l_assact_rec.row_id;
4824: --
4825: if g_debug then
4826: hr_utility.trace('end update_assact');
4827: hr_utility.set_location(l_proc,1000);
4828: end if;
4829: --
4830: end do_expire;
4831: --