DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on HR_JP_ID_PKG

Line 8: c_def_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');

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');

Line 9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_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');

Line 10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_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');

Line 11: c_widow_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WIDOW_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');

Line 12: c_working_student_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'WORKING_STUDENT_TYPE');

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');

Line 13: c_spouse_dep_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_TYPE');

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');

Line 14: c_spouse_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'SPOUSE_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');
18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');

Line 15: c_num_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_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');

Line 16: c_num_ageds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_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');

Line 17: c_num_aged_parents_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_ELDER_PARENT_LT');

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');

Line 18: c_num_specifieds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SPECIFIC_DEP');

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');

Line 19: c_num_junior_deps_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm,'NUM_OF_JUNIOR_DEP');

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: --

Line 20: c_num_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_GEN_DISABLED');

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';

Line 21: c_num_svr_disableds_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED');

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');

Line 22: c_num_svr_disableds_lt_iv constant number := hr_jp_id_pkg.input_value_id(c_def_elm, 'NUM_OF_SEV_DISABLED_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');
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');

Line 25: c_dep_exm_info_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_INFO',null,'JP');

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 >------------------------|

Line 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');

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: -- |---------------------------------------------------------------------------|