DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on HR_JP_ID_PKG

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

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');
10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');

Line 9: c_life_gen_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'GEN_LIFE_INS_PREM');

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');
10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');

Line 10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');

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');
10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: --

Line 11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');

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');
10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: --
15: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';

Line 12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');

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');
10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: --
15: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');

Line 13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');

9: c_life_gen_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'GEN_LIFE_INS_PREM');
10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: --
15: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');
17: c_social_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'DECLARE_SI_PREM');

Line 16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');

12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: --
15: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');
17: c_social_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'DECLARE_SI_PREM');
18: c_mutual_aid_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SMALL_COMPANY_MUTUAL_AID_PREM');
19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');
20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');

Line 17: c_social_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'DECLARE_SI_PREM');

13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: --
15: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');
17: c_social_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'DECLARE_SI_PREM');
18: c_mutual_aid_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SMALL_COMPANY_MUTUAL_AID_PREM');
19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');
20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
21: --

Line 18: c_mutual_aid_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SMALL_COMPANY_MUTUAL_AID_PREM');

14: --
15: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');
17: c_social_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'DECLARE_SI_PREM');
18: c_mutual_aid_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SMALL_COMPANY_MUTUAL_AID_PREM');
19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');
20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
21: --
22: c_com_calc_dpnt_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');

Line 19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');

15: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');
17: c_social_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'DECLARE_SI_PREM');
18: c_mutual_aid_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SMALL_COMPANY_MUTUAL_AID_PREM');
19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');
20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
21: --
22: c_com_calc_dpnt_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');

Line 20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');

16: c_isdf_is_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_is_elm, null, 'JP');
17: c_social_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'DECLARE_SI_PREM');
18: c_mutual_aid_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SMALL_COMPANY_MUTUAL_AID_PREM');
19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');
20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
21: --
22: c_com_calc_dpnt_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');
24: c_widow_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'WIDOW_TYPE');

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

18: c_mutual_aid_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SMALL_COMPANY_MUTUAL_AID_PREM');
19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');
20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
21: --
22: c_com_calc_dpnt_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');
24: c_widow_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'WIDOW_TYPE');
25: --
26: c_com_itax_info_elm_id constant number := hr_jp_id_pkg.element_type_id('COM_ITX_INFO', null, 'JP');

Line 23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');

19: c_spouse_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'SPOUSE_INCOME');
20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
21: --
22: c_com_calc_dpnt_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');
24: c_widow_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'WIDOW_TYPE');
25: --
26: c_com_itax_info_elm_id constant number := hr_jp_id_pkg.element_type_id('COM_ITX_INFO', null, 'JP');
27: c_tax_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itax_info_elm_id, 'ITX_TYPE');

Line 24: c_widow_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'WIDOW_TYPE');

20: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
21: --
22: c_com_calc_dpnt_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');
24: c_widow_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'WIDOW_TYPE');
25: --
26: c_com_itax_info_elm_id constant number := hr_jp_id_pkg.element_type_id('COM_ITX_INFO', null, 'JP');
27: c_tax_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itax_info_elm_id, 'ITX_TYPE');
28: --

Line 26: c_com_itax_info_elm_id constant number := hr_jp_id_pkg.element_type_id('COM_ITX_INFO', null, 'JP');

22: c_com_calc_dpnt_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');
24: c_widow_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'WIDOW_TYPE');
25: --
26: c_com_itax_info_elm_id constant number := hr_jp_id_pkg.element_type_id('COM_ITX_INFO', null, 'JP');
27: c_tax_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itax_info_elm_id, 'ITX_TYPE');
28: --
29: c_st_upd_date_2007 constant date := to_date('2007/01/01','YYYY/MM/DD');
30: --

Line 27: c_tax_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itax_info_elm_id, 'ITX_TYPE');

23: c_sp_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'SPOUSE_TYPE');
24: c_widow_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_calc_dpnt_elm_id, 'WIDOW_TYPE');
25: --
26: c_com_itax_info_elm_id constant number := hr_jp_id_pkg.element_type_id('COM_ITX_INFO', null, 'JP');
27: c_tax_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itax_info_elm_id, 'ITX_TYPE');
28: --
29: c_st_upd_date_2007 constant date := to_date('2007/01/01','YYYY/MM/DD');
30: --
31: -- -------------------------------------------------------------------------

Line 250: l_legislation_code := hr_jp_id_pkg.legislation_code(g_business_group_id);

246: g_payroll_action_id := l_payroll_action_id;
247: g_business_group_id := l_business_group_id;
248: g_effective_date := l_effective_date;
249: --
250: l_legislation_code := hr_jp_id_pkg.legislation_code(g_business_group_id);
251: --
252: --
253: -- life_ins prompt fetch
254: --