DBA Data[Home] [Help]

APPS.PQP_ALIEN_TRANS_DATA_API dependencies on HR_API

Line 218: ,p_person_id in number default hr_api.g_number

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

Line 219: ,p_data_source_type in varchar2 default hr_api.g_varchar2

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

Line 220: ,p_tax_year in number default hr_api.g_number

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

Line 221: ,p_income_code in varchar2 default hr_api.g_varchar2

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

Line 222: ,p_withholding_rate in number default hr_api.g_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

Line 223: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2

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

Line 224: ,p_exemption_code 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

Line 225: ,p_maximum_benefit_amount 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

Line 226: ,p_retro_lose_ben_amt_flag 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

Line 227: ,p_date_benefit_ends in date default hr_api.g_date

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

Line 228: ,p_retro_lose_ben_date_flag 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

Line 229: ,p_current_residency_status 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

Line 230: ,p_nra_to_ra_date in date default hr_api.g_date

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

Line 231: ,p_target_departure_date in date default hr_api.g_date

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

Line 232: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2

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

Line 233: ,p_treaty_info_update_date in date default hr_api.g_date

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

Line 234: ,p_nra_exempt_from_fica 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

Line 235: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2

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

Line 236: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2

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

Line 237: ,p_addl_withholding_amt in number default hr_api.g_number

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

Line 238: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2

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

Line 239: ,p_personal_exemption in number default hr_api.g_number

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

Line 240: ,p_addl_exemption_allowed in number default hr_api.g_number

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

Line 241: ,p_number_of_days_in_usa in number default hr_api.g_number

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

Line 242: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2

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

Line 243: ,p_treaty_ben_allowed_flag 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

Line 244: ,p_treaty_benefits_start_date in date default hr_api.g_date

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

Line 245: ,p_ra_effective_date in date default hr_api.g_date

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

Line 246: ,p_state_code in varchar2 default hr_api.g_varchar2

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

Line 247: ,p_state_honors_treaty_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

Line 248: ,p_ytd_payments in number default hr_api.g_number

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

Line 249: ,p_ytd_w2_payments in number default hr_api.g_number

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

Line 250: ,p_ytd_w2_withholding in number default hr_api.g_number

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

Line 251: ,p_ytd_withholding_allowance in number default hr_api.g_number

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

Line 252: ,p_ytd_treaty_payments in number default hr_api.g_number

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

Line 253: ,p_ytd_treaty_withheld_amt 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

Line 254: ,p_record_source in varchar2 default hr_api.g_varchar2

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

Line 255: ,p_visa_type in varchar2 default hr_api.g_varchar2

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

Line 256: ,p_j_sub_type in varchar2 default hr_api.g_varchar2

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

Line 257: ,p_primary_activity in varchar2 default hr_api.g_varchar2

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

Line 258: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2

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

Line 259: ,p_citizenship_country_code 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

Line 260: ,p_constant_addl_tax in number default hr_api.g_number

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

Line 261: ,p_date_8233_signed in date default hr_api.g_date

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

Line 262: ,p_date_w4_signed in date default hr_api.g_date

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

Line 263: ,p_error_indicator 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

Line 264: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number

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

Line 265: ,p_error_text in varchar2 default hr_api.g_varchar2

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

Line 268: ,p_current_analysis 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: -- ----------------------------------------------------------------------------

Line 269: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2

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 >------------------------|