1 PACKAGE PER_DE_ELE_API AS
2 /*$Header: perdeele.pkh 120.1 2006/10/11 14:44:06 spendhar noship $*/
3
4
5 PROCEDURE delete_tax_information
6 (p_validate in boolean default false
7 ,p_datetrack_delete_mode in varchar2
8 ,p_effective_date in date
9 ,p_element_entry_id in number
10 ,p_object_version_number in out nocopy number
11 ,p_effective_start_date out nocopy date
12 ,p_effective_end_date out nocopy date
13 ,p_delete_warning out nocopy boolean
14 );
15
16 PROCEDURE Update_tax_information
17 (
18 p_validate in boolean default false,
19 p_datetrack_update_mode in varchar2,
20 p_effective_date in date,
21 p_business_group_id in number,
22 p_element_entry_id in number,
23 p_object_version_number in out nocopy number,
24 p_entry_information_category varchar2 default 'DE_TAX INFORMATION',
25 p_tax_year varchar2 default hr_api.g_varchar2,
26 p_tax_card_number varchar2 default hr_api.g_varchar2,
27 p_issue_date varchar2 default hr_api.g_varchar2,
28 p_card_issuer varchar2 default hr_api.g_varchar2,
29 p_tax_status varchar2 default hr_api.g_varchar2,
30 p_tax_table varchar2 default hr_api.g_varchar2,
31 p_tax_class varchar2 default hr_api.g_varchar2,
32 --p_tax_office varchar2 default hr_api.g_varchar2,
33 --p_tax_office_name varchar2 default hr_api.g_varchar2,
34 p_tax_organization_id varchar2 default hr_api.g_varchar2,
35 p_tax_card_location varchar2 default hr_api.g_varchar2,
36 p_no_of_children varchar2 default hr_api.g_varchar2,
37 p_yearly_tax_free_income varchar2 default hr_api.g_varchar2,
38 p_monthly_tax_free_income varchar2 default hr_api.g_varchar2,
39 p_additional_year_tax_income varchar2 default hr_api.g_varchar2,
40 p_yearly_Income_Tax_Calc_Flag varchar2 default hr_api.g_varchar2,
41 p_chamber_contribution varchar2 default hr_api.g_varchar2,
42 p_pensioners_tax_flag varchar2 default hr_api.g_varchar2,
43 p_additional_mth_tax_income varchar2 default hr_api.g_varchar2,
44 p_employee_church_code varchar2 default hr_api.g_varchar2,
45 p_spouse_church_code varchar2 default hr_api.g_varchar2,
46 p_bundesland_church varchar2 default hr_api.g_varchar2,
47 p_yearly_church_tax_flag varchar2 default hr_api.g_varchar2,
48 p_max_church_tax_flag varchar2 default hr_api.g_varchar2,
49 -- p_assignment_id varchar2 default hr_api.g_varchar2,
50 p_updated varchar2 default hr_api.g_varchar2,
51 p_effective_start_date out nocopy date,
52 p_effective_end_date out nocopy date,
53 p_update_warning out nocopy boolean
54 );
55
56 PROCEDURE Insert_tax_information
57 (
58 p_validate in boolean default false
59 ,p_effective_date in date
60 ,p_business_group_id in number
61 ,p_assignment_id in number
62 ,p_element_link_id in number
63 ,p_entry_type in varchar2
64 ,p_entry_information_category in varchar2 default 'DE_TAX INFORMATION'
65 ,p_tax_year in varchar2 default hr_api.g_varchar2
66 ,p_tax_card_number in varchar2 default hr_api.g_varchar2
67 ,p_issue_date in varchar2 default hr_api.g_varchar2
68 ,p_card_issuer in varchar2 default hr_api.g_varchar2
69 ,p_tax_status varchar2 default hr_api.g_varchar2
70 ,p_tax_table varchar2 default hr_api.g_varchar2
71 ,p_tax_class varchar2 default hr_api.g_varchar2
72 --,p_tax_office varchar2 default hr_api.g_varchar2
73 --,p_tax_office_name varchar2 default hr_api.g_varchar2
74 ,p_tax_organization_id varchar2 default hr_api.g_varchar2
75 ,p_tax_card_location varchar2 default hr_api.g_varchar2
76 ,p_no_of_children varchar2 default hr_api.g_varchar2
77 ,p_yearly_tax_free_income varchar2 default hr_api.g_varchar2
78 ,p_monthly_tax_free_income varchar2 default hr_api.g_varchar2
79 ,p_additional_year_tax_income varchar2 default hr_api.g_varchar2
80 ,p_yearly_Income_Tax_Calc_Flag varchar2 default hr_api.g_varchar2
81 ,p_chamber_contribution varchar2 default hr_api.g_varchar2
82 ,p_pensioners_tax_flag varchar2 default hr_api.g_varchar2
83 ,p_additional_mth_tax_income varchar2 default hr_api.g_varchar2
84 --,p_effective_date_from varchar2 default hr_api.g_varchar2
85 --,p_effective_date_to varchar2 default hr_api.g_varchar2
86 ,p_employee_church_code varchar2 default hr_api.g_varchar2
87 ,p_spouse_church_code varchar2 default hr_api.g_varchar2
88 ,p_bundesland_church varchar2 default hr_api.g_varchar2
89 ,p_yearly_church_tax_flag varchar2 default hr_api.g_varchar2
90 ,p_max_church_tax_flag varchar2 default hr_api.g_varchar2
91 ,p_updated varchar2 default hr_api.g_varchar2
92 ,p_effective_start_date out nocopy date
93 ,p_effective_end_date out nocopy date
94 ,p_element_entry_id out nocopy number
95 ,p_object_version_number out nocopy number
96 ,p_create_warning out nocopy boolean );
97
98 PROCEDURE delete_tax_exemptions
99 (p_validate in boolean default false
100 ,p_datetrack_delete_mode in varchar2
101 ,p_effective_date in date
102 ,p_element_entry_id in number
103 ,p_object_version_number in out nocopy number
104 ,p_effective_start_date out nocopy date
105 ,p_effective_end_date out nocopy date
106 ,p_delete_warning out nocopy boolean
107 );
108
109 PROCEDURE Update_tax_exemptions
110 (
111 p_validate in boolean default false,
112 p_datetrack_update_mode in varchar2,
113 p_effective_date in date,
114 p_business_group_id in number,
115 p_element_entry_id in number,
116 p_object_version_number in out nocopy number,
117 p_entry_information_category varchar2 default 'DE_TAX EXEMPTIONS',
118 p_form_number varchar2 default hr_api.g_varchar2,
119 p_issue_date varchar2 default hr_api.g_varchar2,
120 p_valid_from varchar2 default hr_api.g_varchar2,
121 p_valid_to varchar2 default hr_api.g_varchar2,
122 p_tax_free_remuneration varchar2 default hr_api.g_varchar2,
123 --p_assignment_id varchar2 default hr_api.g_varchar2,
124 p_effective_start_date out nocopy date,
125 P_effective_end_date out nocopy date,
126 p_update_warning out nocopy boolean
127 );
128
129 PROCEDURE Insert_tax_exemptions
130 (
131 p_validate in boolean default false
132 ,p_effective_date in date
133 ,p_business_group_id in number
134 ,p_assignment_id in number
135 ,p_element_link_id in number
136 ,p_entry_type in varchar2
137 ,p_entry_information_category in varchar2 default 'DE_TAX EXEMPTIONS'
138 ,p_form_number varchar2 default hr_api.g_varchar2
139 ,p_issue_date varchar2 default hr_api.g_varchar2
140 ,p_valid_from varchar2 default hr_api.g_varchar2
141 ,p_valid_to varchar2 default hr_api.g_varchar2
142 ,p_tax_free_remuneration varchar2 default hr_api.g_varchar2
143 ,p_effective_start_date out nocopy date
144 ,p_effective_end_date out nocopy date
145 ,p_element_entry_id out nocopy number
146 ,p_object_version_number out nocopy number
147 ,p_create_warning out nocopy boolean );
148
149 /*------------------------------------------------------------------------
150 Social Insurance
151
152 -------------------------------------------------------------------------*/
153
154 PROCEDURE delete_social_insurance_info
155 (p_validate in boolean default false
156 ,p_datetrack_delete_mode in varchar2
157 ,p_effective_date in date
158 ,p_element_entry_id in number
159 ,p_object_version_number in out nocopy number
160 ,p_effective_start_date out nocopy date
161 ,p_effective_end_date out nocopy date
162 ,p_delete_warning out nocopy boolean
163 );
164
165 PROCEDURE update_social_insurance_info
166 ( p_validate in boolean default false
167 ,p_datetrack_update_mode in varchar2
168 ,p_effective_date in date
169 ,p_business_group_id in number
170 ,p_element_entry_id in number
171 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
172 ,p_contribution_key in varchar2
173 ,p_health_org_id in number
174 ,p_pension_org_id in number
175 ,p_unemployment_org_id in number
176 ,p_special_care_org_id in number
177 ,p_occupation_key in varchar2
178 ,p_people_class_key in varchar2
179 ,p_legal_area_code in varchar2
180 ,p_health_insurance_number in number
181 ,p_private_health_prov_id in number
182 ,p_private_health_contribution in number
183 ,p_voluntary_pension_prov_id in number
184 ,p_voluntary_pension_contr in number
185 ,p_voluntary_pension_number in varchar2
186 ,p_contribution_transfer_code in varchar2
187 ,p_special_care_contribution in number
188 ,p_privately_insured_flag in varchar2
189 ,p_add_insurance_provider in number default hr_api.g_number
190 ,p_add_ins_memship_number in varchar2 default hr_api.g_varchar2
191 ,p_add_ins_status in varchar2 default hr_api.g_varchar2
192 ,p_add_ins_start_date in date default hr_api.g_date
193 ,p_add_ins_end_date in date default hr_api.g_date
194 ,p_add_ins_end_reason in number default hr_api.g_number
195 ,p_effective_start_date out nocopy date
196 ,p_effective_end_date out nocopy date
197 ,p_object_version_number in out nocopy number
198 ,p_update_warning out nocopy boolean );
199
200
201 PROCEDURE insert_social_insurance_info
202 ( p_validate in boolean default false
203 ,p_effective_date in date
204 ,p_business_group_id in number
205 ,p_assignment_id in number
206 ,p_element_link_id in number
207 ,p_entry_type in varchar2
208 ,p_entry_information_category in varchar2 default 'DE_SOCIAL INSURANCE'
209 ,p_contribution_key in varchar2
210 ,p_health_org_id in number
211 ,p_pension_org_id in number
212 ,p_unemployment_org_id in number
213 ,p_special_care_org_id in number
214 ,p_occupation_key in varchar2
215 ,p_people_class_key in varchar2
216 ,p_legal_area_code in varchar2
217 ,p_health_insurance_number in number
218 ,p_private_health_prov_id in number
219 ,p_private_health_contribution in number
220 ,p_voluntary_pension_prov_id in number
221 ,p_voluntary_pension_contr in number
222 ,p_voluntary_pension_number in varchar2
223 ,p_contribution_transfer_code in varchar2
224 ,p_special_care_contribution in number
225 ,p_privately_insured_flag in varchar2
226 ,p_add_insurance_provider in number default null
227 ,p_add_ins_memship_number in varchar2 default null
228 ,p_add_ins_status in varchar2 default null
229 ,p_add_ins_start_date in date default null
230 ,p_add_ins_end_date in date default null
231 ,p_add_ins_end_reason in number default null
232 ,p_effective_start_date out nocopy date
233 ,p_effective_end_date out nocopy date
234 ,p_element_entry_id out nocopy number
235 ,p_object_version_number out nocopy number
236 ,p_create_warning out nocopy boolean );
237
238 END PER_DE_ELE_API;