2: /* $Header: pyjpetr.pkb 120.1.12010000.2 2010/01/26 07:28:57 keyazawa ship $ */
3: --
4: -- Constant values used to remove Japanese characters(Temporary solution).
5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
3: --
4: -- Constant values used to remove Japanese characters(Temporary solution).
5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
4: -- Constant values used to remove Japanese characters(Temporary solution).
5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
38: --
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
38: --
39: -- Current Element Entry Row Hander "pay_ele_shd" does not comply with API
40: -- strategy. "pay_ele_shd" is like API, but not API. So this package
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
38: --
39: -- Current Element Entry Row Hander "pay_ele_shd" does not comply with API
40: -- strategy. "pay_ele_shd" is like API, but not API. So this package
41: -- used in PAYJPTAX form implement part of real API to use DTCSAPI library.
52: --
53: Function element_name(
54: p_element_code in varchar2) return varchar2
55: Is
56: l_element_name pay_element_types_f.element_name%TYPE;
57: Begin
58: --- Used by PAYJPTAX.fmx ---------------
59: if p_element_code = 'SI' then
60: l_element_name := c_si_elm_name;
145: p_elm_rec_tbl out nocopy elm_rec_tbl,
146: p_iv_rec_tbl out nocopy iv_rec_tbl)
147: Is
148: l_index number;
149: l_elm_rec pay_element_types_f%ROWTYPE;
150: l_effective_date date;
151: Cursor csr_iv(
152: p_element_type_id number,
153: p_eff_date date) is
503: decode(piv.hot_default_flag,
504: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
505: pliv.warning_or_error) WARNING_OR_ERROR,
506: pet.input_currency_code
507: from pay_element_types_f pet,
508: pay_input_values_f_tl pivtl,
509: pay_input_values_f piv,
510: pay_link_input_values_f pliv
511: where pliv.element_link_id = p_element_link_id
720: --
721: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
722: --
723: l_entry_type pay_element_entries_f.entry_type%TYPE;
724: l_processing_type pay_element_types_f.processing_type%TYPE;
725: --
726: Cursor C_Sel1 Is
727: select pee.entry_type,
728: pet.processing_type
725: --
726: Cursor C_Sel1 Is
727: select pee.entry_type,
728: pet.processing_type
729: from pay_element_types_f pet,
730: pay_element_links_f pel,
731: pay_element_entries_f pee
732: where pee.element_entry_id = p_base_key_value
733: and p_effective_date
797: --
798: l_parent_key_value1 number;
799: l_parent_key_value2 number;
800: l_entry_type pay_element_entries_f.entry_type%TYPE;
801: l_processing_type pay_element_types_f.processing_type%TYPE;
802: --
803: Cursor C_Sel1 Is
804: select pee.assignment_id,
805: pee.element_link_id,
804: select pee.assignment_id,
805: pee.element_link_id,
806: pee.entry_type,
807: pet.processing_type
808: from pay_element_types_f pet,
809: pay_element_links_f pel,
810: pay_element_entries_f pee
811: where pee.element_entry_id = p_base_key_value
812: and p_effective_date