1 package pay_us_emp_dt_tax_val AUTHID CURRENT_USER AS
2 /* $Header: pyusdtvl.pkh 120.0.12000000.1 2007/01/18 02:19:46 appldev noship $ */
3
4 function check_work_override ( p_assignment_id in number,
5 p_session_date date,
6 p_state_code in varchar2,
7 p_county_code in varchar2,
8 p_city_code in varchar2
9 )return varchar2;
10
11
12 function check_resi_override ( p_assignment_id in number,
13 p_session_date date,
14 p_state_code in varchar2,
15 p_county_code in varchar2,
16 p_city_code in varchar2
17 )return varchar2;
18
19
20
21 function check_payroll_run ( p_assignment_id in number,
22 p_new_location_code in varchar2,
23 p_new_location_id in number,
24 p_session_date in date,
25 p_effective_start_date in date,
26 p_effective_end_date in date,
27 p_mode in varchar2) return varchar2;
28
29
30 procedure check_in_work_location ( p_assignment_id in number,
31 p_state_code in varchar2,
32 p_county_code in varchar2,
33 p_city_code in varchar2,
34 p_ret_code in out NOCOPY number,
35 p_ret_text in out NOCOPY varchar2);
36
37 procedure check_in_res_addr ( p_assignment_id in number,
38 p_state_code in varchar2,
39 p_county_code in varchar2,
40 p_city_code in varchar2,
41 p_ret_code in out NOCOPY number,
42 p_ret_text in out NOCOPY varchar2);
43
44 procedure payroll_check_for_purge ( p_assignment_id in number,
45 p_state_code in varchar2,
46 p_county_code in varchar2,
47 p_city_code in varchar2,
48 p_ret_code in out NOCOPY number,
49 p_ret_text in out NOCOPY varchar2);
50
51 procedure check_school_district ( p_assignment in number,
52 p_start_date in date,
53 p_end_date in date,
54 p_mode in varchar2,
55 p_rowid in varchar2);
56
57
58 function check_locations (p_assignment_id in number,
59 p_effective_start_date in date,
60 p_business_group_id in number) return boolean;
61
62
63 procedure get_res_codes (p_assignment_id in number,
64 p_session_date in date,
65 p_res_state_code out NOCOPY varchar2,
66 p_res_county_code out NOCOPY varchar2,
67 p_res_city_code out NOCOPY varchar2,
68 p_res_state_name out NOCOPY varchar2,
69 p_res_county_name out NOCOPY varchar2,
70 p_res_city_name out NOCOPY varchar2);
71
72 procedure get_work_codes (p_assignment_id in number,
73 p_session_date in date,
74 p_work_state_code out NOCOPY varchar2,
75 p_work_county_code out NOCOPY varchar2,
76 p_work_city_code out NOCOPY varchar2,
77 p_work_state_name out NOCOPY varchar2,
78 p_work_county_name out NOCOPY varchar2,
79 p_work_city_name out NOCOPY varchar2);
80
81 procedure check_jurisdiction_exists (p_assignment_id in number,
82 p_jurisdiction_code in varchar2,
83 p_ret_code in out NOCOPY number,
84 p_ret_text in out NOCOPY varchar2);
85
86
87 procedure check_delete_tax_row ( p_assignment_id in number,
88 p_state_code in varchar2,
89 p_county_code in varchar2,
90 p_city_code in varchar2);
91
92
93 procedure get_all_work_codes (p_assignment_id in number,
94 p_session_date in date,
95 p_work_state_code in out NOCOPY varchar2,
96 p_work_county_code in out NOCOPY varchar2,
97 p_work_city_code in out NOCOPY varchar2,
98 p_work_state_name in out NOCOPY varchar2,
99 p_work_county_name in out NOCOPY varchar2,
100 p_work_city_name in out NOCOPY varchar2,
101 p_work1_state_code in out NOCOPY varchar2,
102 p_work1_county_code in out NOCOPY varchar2,
103 p_work1_city_code in out NOCOPY varchar2,
104 p_work1_state_name in out NOCOPY varchar2,
105 p_work1_county_name in out NOCOPY varchar2,
106 p_work1_city_name in out NOCOPY varchar2,
107 p_work2_state_code in out NOCOPY varchar2,
108 p_work2_county_code in out NOCOPY varchar2,
109 p_work2_city_code in out NOCOPY varchar2,
110 p_work2_state_name in out NOCOPY varchar2,
111 p_work2_county_name in out NOCOPY varchar2,
112 p_work2_city_name in out NOCOPY varchar2,
113 p_work3_state_code in out NOCOPY varchar2,
114 p_work3_county_code in out NOCOPY varchar2,
115 p_work3_city_code in out NOCOPY varchar2,
116 p_work3_state_name in out NOCOPY varchar2,
117 p_work3_county_name in out NOCOPY varchar2,
118 p_work3_city_name in out NOCOPY varchar2,
119 p_sui_state_code in out NOCOPY varchar2,
120 p_loc_city in out NOCOPY varchar2);
121
122 procedure get_orig_res_codes (p_assignment_id in number,
123 p_session_date in date,
124 p_res_state_code out NOCOPY varchar2,
125 p_res_county_code out NOCOPY varchar2,
126 p_res_city_code out NOCOPY varchar2,
127 p_res_state_name out NOCOPY varchar2,
128 p_res_county_name out NOCOPY varchar2,
129 p_res_city_name out NOCOPY varchar2);
130
131 end pay_us_emp_dt_tax_val;