1 package pay_kr_yea_form_pkg AUTHID CURRENT_USER as
2 /* $Header: pykryeaf.pkh 120.9 2012/01/19 10:17:24 rpahune ship $ */
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 p_public_legal_total in out nocopy per_assignment_extra_info.aei_information1%type
37 ) return varchar2 ; -- Bug 7142612
38 -------------------------------------------------------------------------------------------------------
39 function get_donation_tax_break(p_effective_date IN VARCHAR2,
40 p_political_donation IN NUMBER) return number;
41 -------------------------------------------------------------------------------------------------------
42 end pay_kr_yea_form_pkg;
[Home] [Help]