1 Package pqp_alien_trans_data_api as
2 /* $Header: pqatdapi.pkh 120.0 2005/05/29 01:42:31 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_alien_trans_data >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_person_id No number Added by Ashu Gupta
18 -- p_data_source_type Yes varchar2
19 -- p_tax_year No number
20 -- p_income_code Yes varchar2
21 -- p_withholding_rate No number
22 -- p_income_code_sub_type No varchar2
23 -- p_exemption_code No varchar2
24 -- p_maximum_benefit_amount No number
25 -- p_retro_lose_ben_amt_flag No varchar2
26 -- p_date_benefit_ends No date
27 -- p_retro_lose_ben_date_flag No varchar2
28 -- p_current_residency_status No varchar2
29 -- p_nra_to_ra_date No date
30 -- p_target_departure_date No date
31 -- p_tax_residence_country_code No varchar2
32 -- p_treaty_info_update_date No date
33 -- p_nra_exempt_from_fica No varchar2
34 -- p_student_exempt_from_fica No varchar2
35 -- p_addl_withholding_flag No varchar2
36 -- p_addl_withholding_amt No number
37 -- p_addl_wthldng_amt_period_type No varchar2
38 -- p_personal_exemption No number
39 -- p_addl_exemption_allowed No number
40 -- p_number_of_days_in_usa No number
41 -- p_wthldg_allow_eligible_flag No varchar2
42 -- p_treaty_ben_allowed_flag No varchar2
43 -- p_treaty_benefits_start_date No date
44 -- p_ra_effective_date No date
45 -- p_state_code No varchar2
46 -- p_state_honors_treaty_flag No varchar2
47 -- p_ytd_payments No number
48 -- p_ytd_w2_payments No number
49 -- p_ytd_w2_withholding No number
50 -- p_ytd_withholding_allowance No number
51 -- p_ytd_treaty_payments No number
52 -- p_ytd_treaty_withheld_amt No number
53 -- p_record_source No varchar2
54 -- p_visa_type No varchar2
55 -- p_j_sub_type No varchar2
56 -- p_primary_activity No varchar2
57 -- p_non_us_country_code No varchar2
58 -- p_citizenship_country_code No varchar2
59 -- p_constant_addl_tax No number
60 -- p_date_8233_signed No date
61 -- p_date_w4_signed No date
62 -- p_error_indicator No varchar2
63 -- p_prev_er_treaty_benefit_amt No number
64 -- p_error_text No varchar2
65 -- p_effective_date Yes date Session Date.
66 --
67 -- Post Success:
68 --
69 -- Out Parameters:
70 -- Name Type Description
71 -- p_alien_transaction_id Yes number PK of record
72 -- p_object_version_number Yes number OVN of record
73 --
74 -- Post Failure:
75 --
76 -- Access Status:
77 -- Public.
78 --
79 -- {End Of Comments}
80 --
81 procedure create_alien_trans_data
82 (
83 p_validate in boolean default false
84 ,p_alien_transaction_id out nocopy number
85 ,p_person_id in number default null -- Added by Ashu
86 ,p_data_source_type in varchar2 default null
87 ,p_tax_year in number default null
88 ,p_income_code in varchar2 default null
89 ,p_withholding_rate in number default null
90 ,p_income_code_sub_type in varchar2 default null
91 ,p_exemption_code in varchar2 default null
92 ,p_maximum_benefit_amount in number default null
93 ,p_retro_lose_ben_amt_flag in varchar2 default null
94 ,p_date_benefit_ends in date default null
95 ,p_retro_lose_ben_date_flag in varchar2 default null
96 ,p_current_residency_status in varchar2 default null
97 ,p_nra_to_ra_date in date default null
98 ,p_target_departure_date in date default null
99 ,p_tax_residence_country_code in varchar2 default null
100 ,p_treaty_info_update_date in date default null
101 ,p_nra_exempt_from_fica in varchar2 default null
102 ,p_student_exempt_from_fica in varchar2 default null
103 ,p_addl_withholding_flag in varchar2 default null
104 ,p_addl_withholding_amt in number default null
105 ,p_addl_wthldng_amt_period_type in varchar2 default null
106 ,p_personal_exemption in number default null
107 ,p_addl_exemption_allowed in number default null
108 ,p_number_of_days_in_usa in number default null
109 ,p_wthldg_allow_eligible_flag in varchar2 default null
110 ,p_treaty_ben_allowed_flag in varchar2 default null
111 ,p_treaty_benefits_start_date in date default null
112 ,p_ra_effective_date in date default null
113 ,p_state_code in varchar2 default null
114 ,p_state_honors_treaty_flag in varchar2 default null
115 ,p_ytd_payments in number default null
116 ,p_ytd_w2_payments in number default null
117 ,p_ytd_w2_withholding in number default null
118 ,p_ytd_withholding_allowance in number default null
119 ,p_ytd_treaty_payments in number default null
120 ,p_ytd_treaty_withheld_amt in number default null
121 ,p_record_source in varchar2 default null
122 ,p_visa_type in varchar2 default null
123 ,p_j_sub_type in varchar2 default null
124 ,p_primary_activity in varchar2 default null
125 ,p_non_us_country_code in varchar2 default null
126 ,p_citizenship_country_code in varchar2 default null
127 ,p_constant_addl_tax in number default null
128 ,p_date_8233_signed in date default null
129 ,p_date_w4_signed in date default null
130 ,p_error_indicator in varchar2 default null
131 ,p_prev_er_treaty_benefit_amt in number default null
132 ,p_error_text in varchar2 default null
133 ,p_object_version_number out nocopy number
134 ,p_effective_date in date
135 ,p_current_analysis in varchar2 default null
136 ,p_forecast_income_code in varchar2 default null
137 );
138 -- ----------------------------------------------------------------------------
139 -- |------------------------< update_alien_trans_data >------------------------|
140 -- ----------------------------------------------------------------------------
141 -- {Start Of Comments}
142 --
143 -- Description:
144 --
145 -- Prerequisites:
146 --
147 --
148 -- In Parameters:
149 -- Name Reqd Type Description
150 -- p_validate Yes boolean Commit or Rollback.
151 -- p_alien_transaction_id Yes number PK of record
152 -- p_person_id No number Added by Ashu Gupta
153 -- p_data_source_type Yes varchar2
154 -- p_tax_year No number
155 -- p_income_code Yes varchar2
156 -- p_withholding_rate No number
157 -- p_income_code_sub_type No varchar2
158 -- p_exemption_code No varchar2
159 -- p_maximum_benefit_amount No number
160 -- p_retro_lose_ben_amt_flag No varchar2
161 -- p_date_benefit_ends No date
162 -- p_retro_lose_ben_date_flag No varchar2
163 -- p_current_residency_status No varchar2
164 -- p_nra_to_ra_date No date
165 -- p_target_departure_date No date
166 -- p_tax_residence_country_code No varchar2
167 -- p_treaty_info_update_date No date
168 -- p_nra_exempt_from_fica No varchar2
169 -- p_student_exempt_from_fica No varchar2
170 -- p_addl_withholding_flag No varchar2
171 -- p_addl_withholding_amt No number
172 -- p_addl_wthldng_amt_period_type No varchar2
173 -- p_personal_exemption No number
174 -- p_addl_exemption_allowed No number
175 -- p_number_of_days_in_usa No number
176 -- p_wthldg_allow_eligible_flag No varchar2
177 -- p_treaty_ben_allowed_flag No varchar2
178 -- p_treaty_benefits_start_date No date
179 -- p_ra_effective_date No date
180 -- p_state_code No varchar2
181 -- p_state_honors_treaty_flag No varchar2
182 -- p_ytd_payments No number
183 -- p_ytd_w2_payments No number
184 -- p_ytd_w2_withholding No number
185 -- p_ytd_withholding_allowance No number
186 -- p_ytd_treaty_payments No number
187 -- p_ytd_treaty_withheld_amt No number
188 -- p_record_source No varchar2
189 -- p_visa_type No varchar2
190 -- p_j_sub_type No varchar2
191 -- p_primary_activity No varchar2
192 -- p_non_us_country_code No varchar2
193 -- p_citizenship_country_code No varchar2
194 -- p_constant_addl_tax No number
195 -- p_date_8233_signed No date
196 -- p_date_w4_signed No date
197 -- p_error_indicator No varchar2
198 -- p_prev_er_treaty_benefit_amt No number
199 -- p_error_text No varchar2
200 -- p_effective_date Yes date Session Date.
201 --
202 -- Post Success:
203 --
204 -- Name Type Description
205 -- p_object_version_number Yes number OVN of record
206 --
207 -- Post Failure:
208 --
209 -- Access Status:
210 -- Public.
211 --
212 -- {End Of Comments}
213 --
214 procedure update_alien_trans_data
215 (
216 p_validate in boolean default false
217 ,p_alien_transaction_id in number
218 ,p_person_id in number default hr_api.g_number
219 ,p_data_source_type in varchar2 default hr_api.g_varchar2
220 ,p_tax_year in number default hr_api.g_number
221 ,p_income_code in varchar2 default hr_api.g_varchar2
222 ,p_withholding_rate in number default hr_api.g_number
223 ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
224 ,p_exemption_code in varchar2 default hr_api.g_varchar2
225 ,p_maximum_benefit_amount in number default hr_api.g_number
226 ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
227 ,p_date_benefit_ends in date default hr_api.g_date
228 ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
229 ,p_current_residency_status in varchar2 default hr_api.g_varchar2
230 ,p_nra_to_ra_date in date default hr_api.g_date
231 ,p_target_departure_date in date default hr_api.g_date
232 ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
233 ,p_treaty_info_update_date in date default hr_api.g_date
234 ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
235 ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
236 ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
237 ,p_addl_withholding_amt in number default hr_api.g_number
238 ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
239 ,p_personal_exemption in number default hr_api.g_number
240 ,p_addl_exemption_allowed in number default hr_api.g_number
241 ,p_number_of_days_in_usa in number default hr_api.g_number
242 ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
243 ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
244 ,p_treaty_benefits_start_date in date default hr_api.g_date
245 ,p_ra_effective_date in date default hr_api.g_date
246 ,p_state_code in varchar2 default hr_api.g_varchar2
247 ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
248 ,p_ytd_payments in number default hr_api.g_number
249 ,p_ytd_w2_payments in number default hr_api.g_number
250 ,p_ytd_w2_withholding in number default hr_api.g_number
251 ,p_ytd_withholding_allowance in number default hr_api.g_number
252 ,p_ytd_treaty_payments in number default hr_api.g_number
253 ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
254 ,p_record_source in varchar2 default hr_api.g_varchar2
255 ,p_visa_type in varchar2 default hr_api.g_varchar2
256 ,p_j_sub_type in varchar2 default hr_api.g_varchar2
257 ,p_primary_activity in varchar2 default hr_api.g_varchar2
258 ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
259 ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
260 ,p_constant_addl_tax in number default hr_api.g_number
261 ,p_date_8233_signed in date default hr_api.g_date
262 ,p_date_w4_signed in date default hr_api.g_date
263 ,p_error_indicator in varchar2 default hr_api.g_varchar2
264 ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number
265 ,p_error_text in varchar2 default hr_api.g_varchar2
266 ,p_object_version_number in out nocopy number
267 ,p_effective_date in date
268 ,p_current_analysis in varchar2 default hr_api.g_varchar2
269 ,p_forecast_income_code in varchar2 default hr_api.g_varchar2
270 );
271 --
272 -- ----------------------------------------------------------------------------
273 -- |------------------------< delete_alien_trans_data >------------------------|
274 -- ----------------------------------------------------------------------------
275 -- {Start Of Comments}
276 --
277 -- Description:
278 --
279 -- Prerequisites:
280 --
281 --
282 -- In Parameters:
283 -- Name Reqd Type Description
284 -- p_validate Yes boolean Commit or Rollback.
285 -- p_alien_transaction_id Yes number PK of record
286 -- p_effective_date Yes date Session Date.
287 --
288 -- Post Success:
289 --
290 -- Name Type Description
291 -- p_object_version_number Yes number OVN of record
292 --
293 -- Post Failure:
294 --
295 -- Access Status:
296 -- Public.
297 --
298 -- {End Of Comments}
299 --
300 procedure delete_alien_trans_data
301 (
302 p_validate in boolean default false
303 ,p_alien_transaction_id in number
304 ,p_object_version_number in out nocopy number
305 ,p_effective_date in date
306 );
307 --
308 -- ----------------------------------------------------------------------------
309 -- |----------------------------------< lck >---------------------------------|
310 -- ----------------------------------------------------------------------------
311 -- {Start Of Comments}
312 --
313 -- Description:
314 --
315 -- Prerequisites:
316 --
317 --
318 -- In Parameters:
319 -- Name Reqd Type Description
320 -- p_alien_transaction_id Yes number PK of record
321 -- p_object_version_number Yes number OVN of record
322 --
323 -- Post Success:
324 --
325 -- Name Type Description
326 --
327 -- Post Failure:
328 --
329 -- Access Status:
330 -- Public.
331 --
332 -- {End Of Comments}
333 --
334 procedure lck
335 (
336 p_alien_transaction_id in number
337 ,p_object_version_number in number
338 );
339 --
340 end pqp_alien_trans_data_api;