1 package PAY_NO_HIGH_RATE_TAX as
2 /* $Header: pynohtax.pkh 120.1.12000000.2 2007/03/09 13:22:33 sugarg noship $ */
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) return varchar2;
28 FUNCTION get_reduced_rule (
29 p_payroll_action_id IN number
30 ,p_payroll_id IN VARCHAR2
31 ,p_reduced_rule OUT NOCOPY VARCHAR2) return varchar2;
32 function get_message
33 (p_product in varchar2
34 ,p_message_name in varchar2
35 ,p_token1 in varchar2 default null
36 ,p_token2 in varchar2 default null
37 ,p_token3 in varchar2 default null) return varchar2;
38
39
40 -- Modified function get_prim_tax_card for Legislative changes 2007.
41
42 /*
43 function get_prim_tax_card (
44 p_assignment_id IN NUMBER
45 ,p_date_earned IN DATE
46 ,p_tax_card_type OUT NOCOPY VARCHAR2
47 ,p_tax_municipality OUT NOCOPY VARCHAR2
48 ,p_tax_percentage OUT NOCOPY VARCHAR2
49 ,p_tax_table_number OUT NOCOPY VARCHAR2
50 ,p_tax_table_type OUT NOCOPY VARCHAR2
51 ,p_tft_value OUT NOCOPY VARCHAR2
52 ,p_tax_card_msg OUT NOCOPY VARCHAR2 ) return varchar2;
53 */
54
55 function get_prim_tax_card (
56 p_assignment_id IN NUMBER
57 ,p_date_earned IN DATE
58 ,p_assignment_action_id IN NUMBER
59 ,p_payroll_action_id IN NUMBER
60 ,p_tax_card_type OUT NOCOPY VARCHAR2
61 ,p_tax_municipality OUT NOCOPY VARCHAR2
62 ,p_tax_percentage OUT NOCOPY VARCHAR2
63 ,p_tax_table_number OUT NOCOPY VARCHAR2
64 ,p_tax_table_type OUT NOCOPY VARCHAR2
65 ,p_tft_value OUT NOCOPY VARCHAR2
66 ,p_tax_card_msg OUT NOCOPY VARCHAR2 ) return varchar2;
67
68
69 FUNCTION get_pay_holiday_rule ( p_payroll_action_id IN NUMBER
70 ,p_payroll_id IN VARCHAR2
71 ,p_pay_holiday_rule OUT nocopy VARCHAR2) RETURN VARCHAR2 ;
72
73
74 END PAY_NO_HIGH_RATE_TAX;