4: -- Constants
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: c_package constant varchar2(31) := 'pay_jp_def_ss.';
8: c_def_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_TYPE');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: c_package constant varchar2(31) := 'pay_jp_def_ss.';
8: c_def_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_TYPE');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
6: g_debug boolean := hr_utility.debug_enabled;
7: c_package constant varchar2(31) := 'pay_jp_def_ss.';
8: c_def_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_TYPE');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
7: c_package constant varchar2(31) := 'pay_jp_def_ss.';
8: c_def_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_TYPE');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
8: c_def_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_TYPE');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_TYPE');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_TYPE');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');
13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');
21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');
14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_DISABLE_TYPE');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');
21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');
22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_LT');
15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_DEP');
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');
21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');
22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_LT');
23: --
16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_DEP');
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');
21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');
22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_LT');
23: --
24: c_org_iv_name constant pay_input_values_f.name%type := 'COM_ITX_INFO_WITHHOLD_AGENT_ENTRY_VALUE';
17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');
21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');
22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_LT');
23: --
24: c_org_iv_name constant pay_input_values_f.name%type := 'COM_ITX_INFO_WITHHOLD_AGENT_ENTRY_VALUE';
25: c_dep_exm_info_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_INFO',null,'JP');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');
19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');
20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');
21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');
22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_LT');
23: --
24: c_org_iv_name constant pay_input_values_f.name%type := 'COM_ITX_INFO_WITHHOLD_AGENT_ENTRY_VALUE';
25: c_dep_exm_info_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_INFO',null,'JP');
26: c_dep_sec_sal_flag_iv constant number := hr_jp_id_pkg.input_value_id(c_dep_exm_info_elm,'SECOND_SAL_SUBMIT_FLAG');
21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');
22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_LT');
23: --
24: c_org_iv_name constant pay_input_values_f.name%type := 'COM_ITX_INFO_WITHHOLD_AGENT_ENTRY_VALUE';
25: c_dep_exm_info_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_INFO',null,'JP');
26: c_dep_sec_sal_flag_iv constant number := hr_jp_id_pkg.input_value_id(c_dep_exm_info_elm,'SECOND_SAL_SUBMIT_FLAG');
27: --
28: -- |---------------------------------------------------------------------------|
29: -- |-----------------------< ee_datetrack_update_mode >------------------------|
22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_LT');
23: --
24: c_org_iv_name constant pay_input_values_f.name%type := 'COM_ITX_INFO_WITHHOLD_AGENT_ENTRY_VALUE';
25: c_dep_exm_info_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_INFO',null,'JP');
26: c_dep_sec_sal_flag_iv constant number := hr_jp_id_pkg.input_value_id(c_dep_exm_info_elm,'SECOND_SAL_SUBMIT_FLAG');
27: --
28: -- |---------------------------------------------------------------------------|
29: -- |-----------------------< ee_datetrack_update_mode >------------------------|
30: -- |---------------------------------------------------------------------------|