30: c_asg_run_dim constant varchar2(80) := '_ASG_RUN';
31: --
32: c_fuzzy_ele_class_trm constant varchar2(80) := 'TRM';
33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
31: --
32: c_fuzzy_ele_class_trm constant varchar2(80) := 'TRM';
33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
32: c_fuzzy_ele_class_trm constant varchar2(80) := 'TRM';
33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --
56: c_trm_ele_set_id constant number := hr_jp_id_pkg.element_set_id(c_trm_ele_set,null,'JP');
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --
56: c_trm_ele_set_id constant number := hr_jp_id_pkg.element_set_id(c_trm_ele_set,null,'JP');
57: --
58: c_jp_pea_flex_num number;
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --
56: c_trm_ele_set_id constant number := hr_jp_id_pkg.element_set_id(c_trm_ele_set,null,'JP');
57: --
58: c_jp_pea_flex_num number;
59: c_pai_max constant number := trunc(240/lengthb(to_multi_byte(' ')));
60: c_ext_proc_body varchar2(2000);