[Home] [Help]
1: package body pay_jp_wic_pkg as
2: /* $Header: pyjpwic.pkb 120.30.12020000.3 2012/10/19 09:09:31 mdubasi ship $ */
3: --
4: -- Constants
5: --
2: /* $Header: pyjpwic.pkb 120.30.12020000.3 2012/10/19 09:09:31 mdubasi ship $ */
3: --
4: -- Constants
5: --
6: c_package constant varchar2(31) := 'pay_jp_wic_pkg.';
7: FIXED_RATE_TAX_REDUCTION constant varchar2(30) := 'FIXED_RATE_TAX_REDUCTION';
8: NP_PREM constant varchar2(30) := 'NP_PREM';
9: DEPENDENT constant varchar2(30) := 'DEPENDENT';
10: PREV_JOB constant varchar2(30) := 'PREV_JOB';
3267: p_housing_info out nocopy t_housing_info)
3268: is
3269: --
3270: l_housing_tbl t_housing_tbl;
3271: l_prev_jobs pay_jp_wic_pkg.t_prev_jobs;
3272: --
3273: begin
3274: --
3275: get_certificate_info(
3730: p_valid_term_taxable_amt in number)
3731: is
3732: begin
3733: --
3734: pay_jp_wic_pkg.g_valid_term_taxable_amt := p_valid_term_taxable_amt;
3735: --
3736: end set_valid_term_taxable_amt;
3737: --
3738: -- |-------------------------------------------------------------------|
3761: begin
3762: --
3763: if p_termination_date is not null then
3764: --
3765: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
3766: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');
3767: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');
3768: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');
3769: hr_utility.raise_error;
3763: if p_termination_date is not null then
3764: --
3765: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
3766: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');
3767: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');
3768: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');
3769: hr_utility.raise_error;
3770: end if;
3771: --
3764: --
3765: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
3766: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');
3767: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');
3768: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');
3769: hr_utility.raise_error;
3770: end if;
3771: --
3772: if p_certificate_info.tax_info.taxable_income is null then
3788: l_certificate_info := p_certificate_info;
3789: --
3790: end if;
3791: --
3792: if l_certificate_info.tax_info.taxable_income <= pay_jp_wic_pkg.g_valid_term_taxable_amt then
3793: --
3794: l_result := 1;
3795: --
3796: end if;
4164: g_housing_loan_info_elm.loan_type_iv := hr_jp_id_pkg.input_value_id(g_housing_loan_info_elm.element_type_id,'LOAN_TYPE');
4165: g_housing_loan_info_elm.loan_balance_iv := hr_jp_id_pkg.input_value_id(g_housing_loan_info_elm.element_type_id,'LOAN_BALANCE');
4166: --
4167: -- hr_utility.trace_on('F', 'TTAGAWA');
4168: end pay_jp_wic_pkg;
4169: