1 package pay_kr_yea_form_pkg as
2 /* $Header: pykryeaf.pkh 120.5 2006/09/22 10:54:21 pdesu noship $ */
3 -------------------------------------------------------------------------------------------------------
4 procedure chk_detail_medical_record
5 (
6 p_effective_date in date,
7 p_assignment_id in per_assignment_extra_info.assignment_id%type,
8 p_provider_reg_no in per_assignment_extra_info.aei_information1%type,
9 p_provider_reg_name in per_assignment_extra_info.aei_information1%type,
10 p_res_reg_no in per_assignment_extra_info.aei_information1%type,
11 p_relationship in per_assignment_extra_info.aei_information1%type,
12 p_disabled_aged in per_assignment_extra_info.aei_information1%type,
13 p_total_employee in out nocopy per_assignment_extra_info.aei_information1%type,
14 p_total_dependent in out nocopy per_assignment_extra_info.aei_information1%type,
15 p_total_aged in out nocopy per_assignment_extra_info.aei_information1%type,
16 p_total_disabled in out nocopy per_assignment_extra_info.aei_information1%type,
17 p_total_card_exp in out nocopy per_assignment_extra_info.aei_information1%type,
18 p_inv_provider_name out nocopy varchar2,
19 p_inv_relationship out nocopy varchar2,
20 p_inv_aged_disabled out nocopy varchar2
21 );
22 -------------------------------------------------------------------------------------------------------
23 function chk_dup_recipient_name (
24 p_effective_date in date,
25 p_assignment_id in per_assignment_extra_info.assignment_id%type,
26 p_recipient_reg_no in per_assignment_extra_info.aei_information1%type,
27 p_recipient_name in per_assignment_extra_info.aei_information1%type,
28 p_stat_total in out nocopy per_assignment_extra_info.aei_information1%type,
29 p_pol_total in out nocopy per_assignment_extra_info.aei_information1%type,
30 p_prom_fund_total in out nocopy per_assignment_extra_info.aei_information1%type,
31 p_tax_redn_total in out nocopy per_assignment_extra_info.aei_information1%type,
32 p_specified_total in out nocopy per_assignment_extra_info.aei_information1%type,
33 p_religious_total in out nocopy per_assignment_extra_info.aei_information1%type,
34 p_esoa_total in out nocopy per_assignment_extra_info.aei_information1%type,
35 p_others_total in out nocopy per_assignment_extra_info.aei_information1%type
36 ) return varchar2 ;
37 -------------------------------------------------------------------------------------------------------
38 function get_donation_tax_break(p_effective_date IN VARCHAR2,
39 p_political_donation IN NUMBER) return number;
40 -------------------------------------------------------------------------------------------------------
41 end pay_kr_yea_form_pkg;