1 package PAY_NO_HIGH_RATE_TAX AUTHID CURRENT_USER as
2 /* $Header: pynohtax.pkh 120.3.12020000.3 2013/01/30 11:06:12 dakhuran ship $ */
3 --
4 FUNCTION get_tax_values_high_rate (
5 p_business_group_id IN number
6 ,p_Date_Earned IN DATE
7 ,p_table_name IN VARCHAR2
8 ,p_freq IN VARCHAR2
9 ,p_ptd_amount IN VARCHAR2
10 ,p_high_tax OUT NOCOPY VARCHAR2
11 ,p_high_tax_base OUT NOCOPY VARCHAR2
12 ,p_high_rate_tax OUT NOCOPY VARCHAR2) return varchar2;
13 FUNCTION get_start_range (
14 p_Date_Earned IN DATE
15 ,p_business_group_id IN number
16 ,p_table_name IN VARCHAR2
17 ,p_freq IN VARCHAR2
18 ,p_ptd_amount IN VARCHAR2
19 ,p_start_range OUT NOCOPY VARCHAR2) return varchar2;
20 FUNCTION get_normal_tax (
21 p_Date_Earned IN DATE
22 ,p_business_group_id IN number
23 ,p_table_name IN VARCHAR2
24 ,p_freq IN VARCHAR2
25 ,p_type IN VARCHAR2
26 ,p_ptd_amount IN VARCHAR2
27 ,p_normal_tax OUT NOCOPY VARCHAR2
28 ,p_tax_card_msg OUT NOCOPY VARCHAR2) return varchar2;
29 FUNCTION get_reduced_rule (
30 p_payroll_action_id IN number
31 ,p_payroll_id IN VARCHAR2
32 ,p_reduced_rule OUT NOCOPY VARCHAR2) return varchar2;
33 function get_message
34 (p_product in varchar2
35 ,p_message_name in varchar2
36 ,p_token1 in varchar2 default null
37 ,p_token2 in varchar2 default null
38 ,p_token3 in varchar2 default null) return varchar2;
39
40
41 -- Modified function get_prim_tax_card for Legislative changes 2007.
42
43 /*
44 function get_prim_tax_card (
45 p_assignment_id IN NUMBER
46 ,p_date_earned IN DATE
47 ,p_tax_card_type OUT NOCOPY VARCHAR2
48 ,p_tax_municipality OUT NOCOPY VARCHAR2
49 ,p_tax_percentage OUT NOCOPY VARCHAR2
50 ,p_tax_table_number OUT NOCOPY VARCHAR2
51 ,p_tax_table_type OUT NOCOPY VARCHAR2
52 ,p_tft_value OUT NOCOPY VARCHAR2
53 ,p_tax_card_msg OUT NOCOPY VARCHAR2 ) return varchar2;
54 */
55
56 function get_prim_tax_card (
57 p_assignment_id IN NUMBER
58 ,p_date_earned IN DATE
59 ,p_assignment_action_id IN NUMBER
60 ,p_payroll_action_id IN NUMBER
61 ,p_tax_card_type OUT NOCOPY VARCHAR2
62 ,p_tax_municipality OUT NOCOPY VARCHAR2
63 ,p_tax_percentage OUT NOCOPY VARCHAR2
64 ,p_tax_table_number OUT NOCOPY VARCHAR2
65 ,p_tax_table_type OUT NOCOPY VARCHAR2
66 ,p_tft_value OUT NOCOPY VARCHAR2
67 ,p_tax_card_msg OUT NOCOPY VARCHAR2 ) return varchar2;
68
69
70 FUNCTION get_pay_holiday_rule ( p_payroll_action_id IN NUMBER
71 ,p_payroll_id IN VARCHAR2
72 ,p_pay_holiday_rule OUT nocopy VARCHAR2) RETURN VARCHAR2 ;
73
74 FUNCTION get_tax_period_rule ( p_assignment_id IN NUMBER
75 ,p_effective_date IN DATE
76 ,p_per_reduced_rule OUT NOCOPY VARCHAR2) RETURN VARCHAR2 ;
77
78
79 END PAY_NO_HIGH_RATE_TAX;