[Home] [Help]
PACKAGE: APPS.PAY_CA_EMP_TAX_INF
Source
1 PACKAGE PAY_CA_EMP_TAX_INF AUTHID CURRENT_USER as
2 /* $Header: pycantax.pkh 120.10.12020000.2 2012/07/19 16:12:04 sbachu ship $ */
3
4 procedure get_province_code (p_assignment_id in number,
5 p_session_date in date,
6 p_res_province_code out nocopy varchar2,
7 p_res_province_name out nocopy varchar2,
8 p_work_province_code out nocopy varchar2,
9 p_work_province_name out nocopy varchar2,
10 p_res_inf_flag in varchar2,
11 p_work_inf_flag in varchar2);
12
13 procedure create_default_tax_record (p_assignment_id in number,
14 p_effective_start_date out nocopy date,
15 p_effective_end_date out nocopy date,
16 p_effective_date in date,
17 p_business_group_id in number,
18 p_legislation_code in varchar2,
19 p_work_province in varchar2,
20 p_ret_code out nocopy number,
21 p_ret_text out nocopy varchar2);
22
23 /*****************************************************************************
24 Delete_fed_tax_rule procedure calls
25 "pay_ca_emp_fedtax_inf_api.delete_ca_emp_fedtax_inf" procedure for updating
26 "Effective_End_Date" of tax records in PAY_CA_EMP_FED_TAX_INFO_F table.
27
28 "pay_ca_emp_prvtax_inf_api.delete_ca_emp_prvtax_inf" procedure for updating
29 "Effective_End_Date" of tax records in PAY_CA_EMP_PROV_TAX_INFO_F table.
30
31 *****************************************************************************/
32
33 procedure delete_fed_tax_rule (p_effective_date in date,
34 p_datetrack_delete_mode in varchar2,
35 p_assignment_id in number,
36 p_delete_routine in varchar2,
37 p_effective_start_date out nocopy date,
38 p_effective_end_date out nocopy date,
39 p_object_version_number out nocopy number);
40
41 /*****************************************************************************
42 Maintain_ca_employee_taxes procedure fetches "Assignment_id"
43 values for the given "period_of_service_id"
44 and calls Delete_fed_tax_rule procedure.
45 *****************************************************************************/
46
47 procedure maintain_ca_employee_taxes(
48 p_period_of_service_id in number,
49 p_effective_date in date,
50 p_datetrack_mode in varchar2 default null,
51 p_delete_routine in varchar2 default null);
52
53 procedure delete_tax_record(
54 p_period_of_service_id in number,
55 p_final_process_date in date);
56
57 function get_basic_exemption(p_effective_date date,
58 p_province varchar2 DEFAULT NULL) return number;
59
60 procedure get_min_asg_start_date(p_assignment_id in number,
61 p_min_start_date out nocopy date) ;
62
63 function get_tax_detail_num(p_assignment_id in Number,
64 p_effective_start_date in date,
65 p_effective_end_date in date,
66 p_effective_date in date,
67 p_info_type in VARCHAR2) return number;
68
69 PRAGMA RESTRICT_REFERENCES(get_tax_detail_num,WNDS,WNPS);
70
71 function get_tax_detail_char(p_assignment_id in Number,
72 p_effective_start_date in date,
73 p_effective_end_date in date,
74 p_effective_date in date,
75 p_info_type in VARCHAR2) return varchar2;
76
77 PRAGMA RESTRICT_REFERENCES(get_tax_detail_char,WNDS,WNPS);
78
79 function get_tax_detail_dfs(p_assignment_id in Number,
80 p_effective_start_date in date,
81 p_effective_end_date in date,
82 p_effective_date in date,
83 p_info_type in VARCHAR2) return varchar2;
84
85
86 PRAGMA RESTRICT_REFERENCES(get_tax_detail_dfs,WNDS,WNPS);
87
88 /* For Bug Number 13258136 -Start */
89 function get_tax_detail_date(p_assignment_id in Number,
90 p_effective_start_date in date,
91 p_effective_end_date in date,
92 p_effective_date in date,
93 p_info_type in VARCHAR2) return date;
94
95 PRAGMA RESTRICT_REFERENCES(get_tax_detail_date,WNDS,WNPS);
96 /* For Bug Number 13258136 -End */
97
98 function get_prov_tax_detail_num(p_assignment_id in Number,
99 p_effective_start_date in date,
100 p_effective_end_date in date,
101 p_effective_date in date,
102 p_province_abbrev in VARCHAR2,
103 p_info_type in VARCHAR2) return number;
104
105 PRAGMA RESTRICT_REFERENCES(get_prov_tax_detail_num,WNDS,WNPS);
106
107 function get_prov_tax_detail_char(p_assignment_id in Number,
108 p_effective_start_date in date,
109 p_effective_end_date in date,
110 p_effective_date in date,
111 p_province_abbrev in varchar2,
112 p_info_type in VARCHAR2) return VARCHAR2;
113
114 PRAGMA RESTRICT_REFERENCES(get_prov_tax_detail_char,WNDS,WNPS);
115
116 function get_prov_tax_detail_dfs(p_assignment_id in Number,
117 p_effective_start_date in date,
118 p_effective_end_date in date,
119 p_effective_date in date,
120 p_province_abbrev in varchar2,
121 p_info_type in VARCHAR2) return VARCHAR2;
122
123
124 PRAGMA RESTRICT_REFERENCES(get_prov_tax_detail_dfs,WNDS,WNPS);
125
126 function get_address(p_person_id in Number,
127 p_effective_date in date,
128 address_line_no in number
129 ) return VARCHAR2;
130 PRAGMA RESTRICT_REFERENCES(get_address,WNDS,WNPS);
131
132 function get_salary_basis(p_salary_basis_id in Number) return VARCHAR2;
133 PRAGMA RESTRICT_REFERENCES(get_salary_basis,WNDS,WNPS);
134
135 function get_base_salary(p_assignment_id in Number,
136 p_effective_date in date,
137 p_salary_basis_id in number) return VARCHAR2;
138 PRAGMA RESTRICT_REFERENCES(get_base_salary,WNDS,WNPS);
139
140 function get_summary_info(p_assignment_action_id in Number,
141 p_information_type in varchar2,
142 p_dimension in varchar2) return NUMBER;
143 PRAGMA RESTRICT_REFERENCES(get_summary_info,WNDS);
144
145 function check_age_under18_or_over70(p_payroll_action_id in Number,
146 p_date_of_birth in Date,
147 p_exemption_start_date Date,
148 p_exemption_end_date Date) return VARCHAR2;
149 PRAGMA RESTRICT_REFERENCES(check_age_under18_or_over70,WNDS);
150
151 function check_age_under18(p_payroll_action_id in Number,
152 p_date_of_birth in Date) return VARCHAR2;
153 PRAGMA RESTRICT_REFERENCES(check_age_under18,WNDS);
154
155 function get_loc_change_retro_exemp(p_payroll_action_id in Number,
156 p_assignment_id in Number,
157 p_exemption in VARCHAR2) return Number;
158
159 PRAGMA RESTRICT_REFERENCES(get_loc_change_retro_exemp,WNDS);
160
161 function retro_across_calendar_years(p_element_entry_id in number,
162 p_payroll_action_id in number)
163 return varchar2;
164
165 PRAGMA RESTRICT_REFERENCES(retro_across_calendar_years,WNDS);
166
167 function check_ei_exempt(p_roe_assignment_id in Number,
168 p_roe_date in Date) return VARCHAR2;
169
170 end pay_ca_emp_tax_inf;