1 PACKAGE pay_get_tax_exists_pkg AS
2 /* $Header: pytaxexi.pkh 120.5.12010000.1 2008/07/27 23:44:02 appldev 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_wage_accumulation_flag
54 RETURN varchar2;
55
56 FUNCTION get_tax_exists (p_juri_code IN VARCHAR2,
57 p_date_earned IN DATE,
58 p_tax_unit_id IN NUMBER,
59 p_assign_id IN NUMBER,
60 p_type IN VARCHAR2
61 ) RETURN VARCHAR2;
62
63 FUNCTION get_tax_exists
64 (
65 p_juri_code IN varchar2,
66 p_date_earned IN date,
67 p_tax_unit_id IN number,
68 p_assign_id IN number,
69 p_pact_id IN number,
70 p_type IN varchar2
71 )
72 RETURN varchar2;
73
74 FUNCTION get_tax_exists
75 (
76 p_juri_code IN varchar2,
77 p_date_earned IN date,
78 p_tax_unit_id IN number,
79 p_assign_id IN number,
80 p_pact_id IN number,
81 p_type IN varchar2,
82 p_call IN varchar2)
83 RETURN varchar2;
84
85 FUNCTION check_tax_exists
86 (
87 p_date_earned IN date,
88 p_tax_unit_id IN number,
89 p_assign_id IN number,
90 p_pact_id IN number,
91 p_juri_code IN varchar2,
92 p_type IN varchar2
93 )
94 RETURN varchar2;
95
96 end pay_get_tax_exists_pkg;