[Home] [Help]
PACKAGE: APPS.PAY_CA_EMP_TAX_INF
Source
1 PACKAGE PAY_CA_EMP_TAX_INF as
2 /* $Header: pycantax.pkh 120.2.12010000.4 2008/08/06 06:58:12 ubhat 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 function get_prov_tax_detail_num(p_assignment_id in Number,
89 p_effective_start_date in date,
90 p_effective_end_date in date,
91 p_effective_date in date,
92 p_province_abbrev in VARCHAR2,
93 p_info_type in VARCHAR2) return number;
94
95 PRAGMA RESTRICT_REFERENCES(get_prov_tax_detail_num,WNDS,WNPS);
96
97 function get_prov_tax_detail_char(p_assignment_id in Number,
98 p_effective_start_date in date,
99 p_effective_end_date in date,
100 p_effective_date in date,
101 p_province_abbrev in varchar2,
102 p_info_type in VARCHAR2) return VARCHAR2;
103
104 PRAGMA RESTRICT_REFERENCES(get_prov_tax_detail_char,WNDS,WNPS);
105
106 function get_prov_tax_detail_dfs(p_assignment_id in Number,
107 p_effective_start_date in date,
108 p_effective_end_date in date,
109 p_effective_date in date,
110 p_province_abbrev in varchar2,
111 p_info_type in VARCHAR2) return VARCHAR2;
112
113
114 PRAGMA RESTRICT_REFERENCES(get_prov_tax_detail_dfs,WNDS,WNPS);
115
116 function get_address(p_person_id in Number,
117 p_effective_date in date,
118 address_line_no in number
119 ) return VARCHAR2;
120 PRAGMA RESTRICT_REFERENCES(get_address,WNDS,WNPS);
121
122 function get_salary_basis(p_salary_basis_id in Number) return VARCHAR2;
123 PRAGMA RESTRICT_REFERENCES(get_salary_basis,WNDS,WNPS);
124
125 function get_base_salary(p_assignment_id in Number,
126 p_effective_date in date,
127 p_salary_basis_id in number) return VARCHAR2;
128 PRAGMA RESTRICT_REFERENCES(get_base_salary,WNDS,WNPS);
129
130 function get_summary_info(p_assignment_action_id in Number,
131 p_information_type in varchar2,
132 p_dimension in varchar2) return NUMBER;
133 PRAGMA RESTRICT_REFERENCES(get_summary_info,WNDS);
134
135 function check_age_under18_or_over70(p_payroll_action_id in Number,
136 p_date_of_birth in Date) return VARCHAR2;
137 PRAGMA RESTRICT_REFERENCES(check_age_under18_or_over70,WNDS);
138
139 function check_age_under18(p_payroll_action_id in Number,
140 p_date_of_birth in Date) return VARCHAR2;
141 PRAGMA RESTRICT_REFERENCES(check_age_under18,WNDS);
142
143 function retro_across_calendar_years(p_element_entry_id in number,
144 p_payroll_action_id in number)
145 return varchar2;
146 PRAGMA RESTRICT_REFERENCES(retro_across_calendar_years,WNDS);
147
148 end pay_ca_emp_tax_inf;