2: /* $Header: pyjpetr.pkb 120.1 2005/09/12 23:49:04 keyazawa noship $ */
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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------
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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------
35: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------
35: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
36: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
29: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------
35: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
36: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
37: --
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------
35: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
36: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
37: --
38: -- Current Element Entry Row Hander "pay_ele_shd" does not comply with API
39: -- strategy. "pay_ele_shd" is like API, but not API. So this package
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------
35: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
36: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
37: --
38: -- Current Element Entry Row Hander "pay_ele_shd" does not comply with API
39: -- strategy. "pay_ele_shd" is like API, but not API. So this package
40: -- used in PAYJPTAX form implement part of real API to use DTCSAPI library.
51: --
52: Function element_name(
53: p_element_code in varchar2) return varchar2
54: Is
55: l_element_name pay_element_types_f.element_name%TYPE;
56: Begin
57: --- Used by PAYJPTAX.fmx ---------------
58: if p_element_code = 'SI' then
59: l_element_name := c_si_elm_name;
142: p_elm_rec_tbl out nocopy elm_rec_tbl,
143: p_iv_rec_tbl out nocopy iv_rec_tbl)
144: Is
145: l_index number;
146: l_elm_rec pay_element_types_f%ROWTYPE;
147: Cursor csr_iv(p_element_type_id number) is
148: select piv.input_value_id,
149: piv.display_sequence,
150: piv.uom,
487: decode(piv.hot_default_flag,
488: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
489: pliv.warning_or_error) WARNING_OR_ERROR,
490: pet.input_currency_code
491: from pay_element_types_f pet,
492: pay_input_values_f_tl pivtl,
493: pay_input_values_f piv,
494: pay_link_input_values_f pliv
495: where pliv.element_link_id = p_element_link_id
704: --
705: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
706: --
707: l_entry_type pay_element_entries_f.entry_type%TYPE;
708: l_processing_type pay_element_types_f.processing_type%TYPE;
709: --
710: Cursor C_Sel1 Is
711: select pee.entry_type,
712: pet.processing_type
709: --
710: Cursor C_Sel1 Is
711: select pee.entry_type,
712: pet.processing_type
713: from pay_element_types_f pet,
714: pay_element_links_f pel,
715: pay_element_entries_f pee
716: where pee.element_entry_id = p_base_key_value
717: and p_effective_date
781: --
782: l_parent_key_value1 number;
783: l_parent_key_value2 number;
784: l_entry_type pay_element_entries_f.entry_type%TYPE;
785: l_processing_type pay_element_types_f.processing_type%TYPE;
786: --
787: Cursor C_Sel1 Is
788: select pee.assignment_id,
789: pee.element_link_id,
788: select pee.assignment_id,
789: pee.element_link_id,
790: pee.entry_type,
791: pet.processing_type
792: from pay_element_types_f pet,
793: pay_element_links_f pel,
794: pay_element_entries_f pee
795: where pee.element_entry_id = p_base_key_value
796: and p_effective_date