eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_ALIEN_TRANS_DATA_API dependencies on HR_API

Line 146: when hr_api.cannot_find_prog_unit then

142: ,p_current_analysis => p_current_analysis
143: ,p_forecast_income_code => p_forecast_income_code
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (
149: p_module_name => 'CREATE_ALIEN_TRANS_DATA'
150: ,p_hook_type => 'BP'

Line 147: hr_api.cannot_find_prog_unit_error

143: ,p_forecast_income_code => p_forecast_income_code
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (
149: p_module_name => 'CREATE_ALIEN_TRANS_DATA'
150: ,p_hook_type => 'BP'
151: );

Line 275: when hr_api.cannot_find_prog_unit then

271: ,p_current_analysis => p_current_analysis
272: ,p_forecast_income_code => p_forecast_income_code
273: );
274: exception
275: when hr_api.cannot_find_prog_unit then
276: hr_api.cannot_find_prog_unit_error
277: (p_module_name => 'CREATE_ALIEN_TRANS_DATA'
278: ,p_hook_type => 'AP'
279: );

Line 276: hr_api.cannot_find_prog_unit_error

272: ,p_forecast_income_code => p_forecast_income_code
273: );
274: exception
275: when hr_api.cannot_find_prog_unit then
276: hr_api.cannot_find_prog_unit_error
277: (p_module_name => 'CREATE_ALIEN_TRANS_DATA'
278: ,p_hook_type => 'AP'
279: );
280: --

Line 290: raise hr_api.validate_enabled;

286: --
287: -- When in validation only mode raise the Validate_Enabled exception
288: --
289: if p_validate then
290: raise hr_api.validate_enabled;
291: end if;
292: --
293: -- Set all output arguments
294: --

Line 302: when hr_api.validate_enabled then

298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: --
300: exception
301: --
302: when hr_api.validate_enabled then
303: --
304: -- As the Validate_Enabled exception has been raised
305: -- we must rollback to the savepoint
306: --

Line 337: ,p_person_id in number default hr_api.g_number

333: --
334: procedure update_alien_trans_data
335: (p_validate in boolean default false
336: ,p_alien_transaction_id in number
337: ,p_person_id in number default hr_api.g_number
338: ,p_data_source_type in varchar2 default hr_api.g_varchar2
339: ,p_tax_year in number default hr_api.g_number
340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number

Line 338: ,p_data_source_type in varchar2 default hr_api.g_varchar2

334: procedure update_alien_trans_data
335: (p_validate in boolean default false
336: ,p_alien_transaction_id in number
337: ,p_person_id in number default hr_api.g_number
338: ,p_data_source_type in varchar2 default hr_api.g_varchar2
339: ,p_tax_year in number default hr_api.g_number
340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2

Line 339: ,p_tax_year in number default hr_api.g_number

335: (p_validate in boolean default false
336: ,p_alien_transaction_id in number
337: ,p_person_id in number default hr_api.g_number
338: ,p_data_source_type in varchar2 default hr_api.g_varchar2
339: ,p_tax_year in number default hr_api.g_number
340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2

Line 340: ,p_income_code in varchar2 default hr_api.g_varchar2

336: ,p_alien_transaction_id in number
337: ,p_person_id in number default hr_api.g_number
338: ,p_data_source_type in varchar2 default hr_api.g_varchar2
339: ,p_tax_year in number default hr_api.g_number
340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number

Line 341: ,p_withholding_rate in number default hr_api.g_number

337: ,p_person_id in number default hr_api.g_number
338: ,p_data_source_type in varchar2 default hr_api.g_varchar2
339: ,p_tax_year in number default hr_api.g_number
340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2

Line 342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2

338: ,p_data_source_type in varchar2 default hr_api.g_varchar2
339: ,p_tax_year in number default hr_api.g_number
340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date

Line 343: ,p_exemption_code in varchar2 default hr_api.g_varchar2

339: ,p_tax_year in number default hr_api.g_number
340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2

Line 344: ,p_maximum_benefit_amount in number default hr_api.g_number

340: ,p_income_code in varchar2 default hr_api.g_varchar2
341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2

Line 345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2

341: ,p_withholding_rate in number default hr_api.g_number
342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date

Line 346: ,p_date_benefit_ends in date default hr_api.g_date

342: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date

Line 347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2

343: ,p_exemption_code in varchar2 default hr_api.g_varchar2
344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2

Line 348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2

344: ,p_maximum_benefit_amount in number default hr_api.g_number
345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date

Line 349: ,p_nra_to_ra_date in date default hr_api.g_date

345: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2

Line 350: ,p_target_departure_date in date default hr_api.g_date

346: ,p_date_benefit_ends in date default hr_api.g_date
347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2

Line 351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2

347: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2

Line 352: ,p_treaty_info_update_date in date default hr_api.g_date

348: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number

Line 353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2

349: ,p_nra_to_ra_date in date default hr_api.g_date
350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2

Line 354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2

350: ,p_target_departure_date in date default hr_api.g_date
351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number

Line 355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2

351: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number

Line 356: ,p_addl_withholding_amt in number default hr_api.g_number

352: ,p_treaty_info_update_date in date default hr_api.g_date
353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number

Line 357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2

353: ,p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2
354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2

Line 358: ,p_personal_exemption in number default hr_api.g_number

354: ,p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2
355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2

Line 359: ,p_addl_exemption_allowed in number default hr_api.g_number

355: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date

Line 360: ,p_number_of_days_in_usa in number default hr_api.g_number

356: ,p_addl_withholding_amt in number default hr_api.g_number
357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date

Line 361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2

357: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2

Line 362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2

358: ,p_personal_exemption in number default hr_api.g_number
359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2

Line 363: ,p_treaty_benefits_start_date in date default hr_api.g_date

359: ,p_addl_exemption_allowed in number default hr_api.g_number
360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number

Line 364: ,p_ra_effective_date in date default hr_api.g_date

360: ,p_number_of_days_in_usa in number default hr_api.g_number
361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number

Line 365: ,p_state_code in varchar2 default hr_api.g_varchar2

361: ,p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number

Line 366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2

362: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number

Line 367: ,p_ytd_payments in number default hr_api.g_number

363: ,p_treaty_benefits_start_date in date default hr_api.g_date
364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number

Line 368: ,p_ytd_w2_payments in number default hr_api.g_number

364: ,p_ra_effective_date in date default hr_api.g_date
365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number

Line 369: ,p_ytd_w2_withholding in number default hr_api.g_number

365: ,p_state_code in varchar2 default hr_api.g_varchar2
366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2

Line 370: ,p_ytd_withholding_allowance in number default hr_api.g_number

366: ,p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2
367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2

Line 371: ,p_ytd_treaty_payments in number default hr_api.g_number

367: ,p_ytd_payments in number default hr_api.g_number
368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2

Line 372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number

368: ,p_ytd_w2_payments in number default hr_api.g_number
369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2

Line 373: ,p_record_source in varchar2 default hr_api.g_varchar2

369: ,p_ytd_w2_withholding in number default hr_api.g_number
370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2

Line 374: ,p_visa_type in varchar2 default hr_api.g_varchar2

370: ,p_ytd_withholding_allowance in number default hr_api.g_number
371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2

Line 375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2

371: ,p_ytd_treaty_payments in number default hr_api.g_number
372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number

Line 376: ,p_primary_activity in varchar2 default hr_api.g_varchar2

372: ,p_ytd_treaty_withheld_amt in number default hr_api.g_number
373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date

Line 377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2

373: ,p_record_source in varchar2 default hr_api.g_varchar2
374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date

Line 378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2

374: ,p_visa_type in varchar2 default hr_api.g_varchar2
375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date
382: ,p_error_indicator in varchar2 default hr_api.g_varchar2

Line 379: ,p_constant_addl_tax in number default hr_api.g_number

375: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date
382: ,p_error_indicator in varchar2 default hr_api.g_varchar2
383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number

Line 380: ,p_date_8233_signed in date default hr_api.g_date

376: ,p_primary_activity in varchar2 default hr_api.g_varchar2
377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date
382: ,p_error_indicator in varchar2 default hr_api.g_varchar2
383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number
384: ,p_error_text in varchar2 default hr_api.g_varchar2

Line 381: ,p_date_w4_signed in date default hr_api.g_date

377: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date
382: ,p_error_indicator in varchar2 default hr_api.g_varchar2
383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number
384: ,p_error_text in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number

Line 382: ,p_error_indicator in varchar2 default hr_api.g_varchar2

378: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date
382: ,p_error_indicator in varchar2 default hr_api.g_varchar2
383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number
384: ,p_error_text in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_effective_date in date

Line 383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number

379: ,p_constant_addl_tax in number default hr_api.g_number
380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date
382: ,p_error_indicator in varchar2 default hr_api.g_varchar2
383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number
384: ,p_error_text in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_effective_date in date
387: ,p_current_analysis in varchar2 default hr_api.g_varchar2

Line 384: ,p_error_text in varchar2 default hr_api.g_varchar2

380: ,p_date_8233_signed in date default hr_api.g_date
381: ,p_date_w4_signed in date default hr_api.g_date
382: ,p_error_indicator in varchar2 default hr_api.g_varchar2
383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number
384: ,p_error_text in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_effective_date in date
387: ,p_current_analysis in varchar2 default hr_api.g_varchar2
388: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2

Line 387: ,p_current_analysis in varchar2 default hr_api.g_varchar2

383: ,p_prev_er_treaty_benefit_amt in number default hr_api.g_number
384: ,p_error_text in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_effective_date in date
387: ,p_current_analysis in varchar2 default hr_api.g_varchar2
388: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2
389: ) is
390: --
391: -- Declare cursors and local variables

Line 388: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2

384: ,p_error_text in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_effective_date in date
387: ,p_current_analysis in varchar2 default hr_api.g_varchar2
388: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2
389: ) is
390: --
391: -- Declare cursors and local variables
392: --

Line 471: when hr_api.cannot_find_prog_unit then

467: ,p_current_analysis => p_current_analysis
468: ,p_forecast_income_code => p_forecast_income_code
469: );
470: exception
471: when hr_api.cannot_find_prog_unit then
472: hr_api.cannot_find_prog_unit_error
473: (p_module_name => 'UPDATE_ALIEN_TRANS_DATA'
474: ,p_hook_type => 'BP'
475: );

Line 472: hr_api.cannot_find_prog_unit_error

468: ,p_forecast_income_code => p_forecast_income_code
469: );
470: exception
471: when hr_api.cannot_find_prog_unit then
472: hr_api.cannot_find_prog_unit_error
473: (p_module_name => 'UPDATE_ALIEN_TRANS_DATA'
474: ,p_hook_type => 'BP'
475: );
476: --

Line 599: when hr_api.cannot_find_prog_unit then

595: ,p_current_analysis => p_current_analysis
596: ,p_forecast_income_code => p_forecast_income_code
597: );
598: exception
599: when hr_api.cannot_find_prog_unit then
600: hr_api.cannot_find_prog_unit_error
601: (p_module_name => 'UPDATE_ALIEN_TRANS_DATA'
602: ,p_hook_type => 'AP'
603: );

Line 600: hr_api.cannot_find_prog_unit_error

596: ,p_forecast_income_code => p_forecast_income_code
597: );
598: exception
599: when hr_api.cannot_find_prog_unit then
600: hr_api.cannot_find_prog_unit_error
601: (p_module_name => 'UPDATE_ALIEN_TRANS_DATA'
602: ,p_hook_type => 'AP'
603: );
604: --

Line 614: raise hr_api.validate_enabled;

610: --
611: -- When in validation only mode raise the Validate_Enabled exception
612: --
613: if p_validate then
614: raise hr_api.validate_enabled;
615: end if;
616: --
617: -- Set all output arguments
618: --

Line 625: when hr_api.validate_enabled then

621: hr_utility.set_location(' Leaving:'||l_proc, 70);
622: --
623: exception
624: --
625: when hr_api.validate_enabled then
626: --
627: -- As the Validate_Enabled exception has been raised
628: -- we must rollback to the savepoint
629: --

Line 690: when hr_api.cannot_find_prog_unit then

686: ,p_object_version_number => p_object_version_number
687: ,p_effective_date => trunc(p_effective_date)
688: );
689: exception
690: when hr_api.cannot_find_prog_unit then
691: hr_api.cannot_find_prog_unit_error
692: (p_module_name => 'DELETE_ALIEN_TRANS_DATA'
693: ,p_hook_type => 'BP'
694: );

Line 691: hr_api.cannot_find_prog_unit_error

687: ,p_effective_date => trunc(p_effective_date)
688: );
689: exception
690: when hr_api.cannot_find_prog_unit then
691: hr_api.cannot_find_prog_unit_error
692: (p_module_name => 'DELETE_ALIEN_TRANS_DATA'
693: ,p_hook_type => 'BP'
694: );
695: --

Line 718: when hr_api.cannot_find_prog_unit then

714: ,p_object_version_number => l_object_version_number
715: ,p_effective_date => trunc(p_effective_date)
716: );
717: exception
718: when hr_api.cannot_find_prog_unit then
719: hr_api.cannot_find_prog_unit_error
720: (p_module_name => 'DELETE_ALIEN_TRANS_DATA'
721: ,p_hook_type => 'AP'
722: );

Line 719: hr_api.cannot_find_prog_unit_error

715: ,p_effective_date => trunc(p_effective_date)
716: );
717: exception
718: when hr_api.cannot_find_prog_unit then
719: hr_api.cannot_find_prog_unit_error
720: (p_module_name => 'DELETE_ALIEN_TRANS_DATA'
721: ,p_hook_type => 'AP'
722: );
723: --

Line 733: raise hr_api.validate_enabled;

729: --
730: -- When in validation only mode raise the Validate_Enabled exception
731: --
732: if p_validate then
733: raise hr_api.validate_enabled;
734: end if;
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 70);
737: --

Line 740: when hr_api.validate_enabled then

736: hr_utility.set_location(' Leaving:'||l_proc, 70);
737: --
738: exception
739: --
740: when hr_api.validate_enabled then
741: --
742: -- As the Validate_Enabled exception has been raised
743: -- we must rollback to the savepoint
744: --