1 PACKAGE pay_get_tax_exists_pkg AUTHID CURRENT_USER AS
2 /* $Header: pytaxexi.pkh 120.8 2011/11/22 21:43:14 tclewis ship $ */
3
4
5 TYPE balance_record IS RECORD
6 (jurisdiction_code varchar2(11),
7 location varchar2(12),
8 balance_name varchar2(30),
9 amount number);
10
11 TYPE balance_table IS TABLE OF balance_record INDEX BY BINARY_INTEGER;
12
13 tax_balances balance_table;
14
15 FUNCTION store_pretax_redns
16 (p_juri_code IN varchar2,
17 p_tax_type IN varchar2,
18 p_mode IN varchar2,
19 p_125_redns IN OUT NOCOPY number,
20 p_401_redns IN OUT NOCOPY number,
21 p_403_redns IN OUT NOCOPY number,
22 p_457_redns IN OUT NOCOPY number,
23 p_dep_care_redns IN OUT NOCOPY number,
24 p_other_pretax_redns IN OUT NOCOPY number,
25 p_gross IN OUT NOCOPY number,
26 p_subj_nwhable IN OUT NOCOPY number,
27 p_location IN varchar2,
28 p_reduced_subj IN number,
29 p_subj IN number)
30 RETURN number;
31
32 FUNCTION get_stored_balance
33 (p_juri_code IN varchar2,
34 p_balance_name IN varchar2,
35 p_location IN varchar2)
36 RETURN number;
37
38 PROCEDURE reset_stored_balance
39 (p_juri_code IN varchar2,
40 p_balance_name IN varchar2,
41 p_location IN varchar2);
42
43 FUNCTION get_wage_accum_rule
44 (p_juri_code IN varchar2,
45 p_date_earned IN date,
46 p_tax_unit_id IN number,
47 p_assign_id IN number,
48 p_pact_id IN number,
49 p_type IN varchar2,
50 p_wage_accum IN varchar2)
51 RETURN varchar2;
52
53 FUNCTION get_res_wage_accum_rule
54 (p_date_earned IN date,
55 p_tax_unit_id IN number,
56 p_assign_id IN number,
57 p_pact_id IN number,
58 p_juri_code IN varchar2,
59 p_type IN varchar2,
60 p_wage_accum IN varchar2)
61 RETURN varchar2;
62
63
64 FUNCTION get_wage_accumulation_flag
65 (p_pact_id IN number)
66 RETURN varchar2;
67
68 FUNCTION get_tax_exists (p_juri_code IN VARCHAR2,
69 p_date_earned IN DATE,
70 p_tax_unit_id IN NUMBER,
71 p_assign_id IN NUMBER,
72 p_type IN VARCHAR2
73 ) RETURN VARCHAR2;
74
75 FUNCTION get_tax_exists
76 (
77 p_juri_code IN varchar2,
78 p_date_earned IN date,
79 p_tax_unit_id IN number,
80 p_assign_id IN number,
81 p_pact_id IN number,
82 p_type IN varchar2
83 )
84 RETURN varchar2;
85
86 FUNCTION get_tax_exists
87 (
88 p_juri_code IN varchar2,
89 p_date_earned IN date,
90 p_tax_unit_id IN number,
91 p_assign_id IN number,
92 p_pact_id IN number,
93 p_type IN varchar2,
94 p_call IN varchar2)
95 RETURN varchar2;
96
97 FUNCTION check_tax_exists
98 (
99 p_date_earned IN date,
100 p_tax_unit_id IN number,
101 p_assign_id IN number,
102 p_pact_id IN number,
103 p_juri_code IN varchar2,
104 p_type IN varchar2
105 )
106 RETURN varchar2;
107
108 /*Added for Bug#6696348*/
109 FUNCTION get_profile_value
110 (p_profile_name IN varchar2) return varchar2;
111
112 end pay_get_tax_exists_pkg;