APPS.PQP_ATD_UPD dependencies on HR_API

Line 130: When hr_api.check_integrity_violated Then

126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128:
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
133: pqp_atd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
133: pqp_atd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
138: pqp_atd_shd.constraint_error

Line 135: When hr_api.parent_integrity_violated Then

131: -- A check constraint has been violated
132: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
133: pqp_atd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
138: pqp_atd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
138: pqp_atd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
143: pqp_atd_shd.constraint_error

Line 140: When hr_api.unique_integrity_violated Then

136: -- Parent integrity has been violated
137: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
138: pqp_atd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
143: pqp_atd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
143: pqp_atd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End update_dml;

Line 347: when hr_api.cannot_find_prog_unit then

343: );
344: --
345: exception
346: --
347: when hr_api.cannot_find_prog_unit then
348: --
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'PQP_ALIEN_TRANS_DATA'
351: ,p_hook_type => 'AU');

Line 349: hr_api.cannot_find_prog_unit_error

345: exception
346: --
347: when hr_api.cannot_find_prog_unit then
348: --
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'PQP_ALIEN_TRANS_DATA'
351: ,p_hook_type => 'AU');
352: --
353: end;

Line 417: If (p_rec.person_id = hr_api.g_number) then

413: -- p_rec plsql record structure
414: -- to see if a system default is being used. If a system default
415: -- is being used then we must set to the 'current' argument value.
416: --
417: If (p_rec.person_id = hr_api.g_number) then
418: p_rec.person_id :=
419: pqp_atd_shd.g_old_rec.person_id;
420: End If;
421: If (p_rec.data_source_type = hr_api.g_varchar2) then

Line 421: If (p_rec.data_source_type = hr_api.g_varchar2) then

417: If (p_rec.person_id = hr_api.g_number) then
418: p_rec.person_id :=
419: pqp_atd_shd.g_old_rec.person_id;
420: End If;
421: If (p_rec.data_source_type = hr_api.g_varchar2) then
422: p_rec.data_source_type :=
423: pqp_atd_shd.g_old_rec.data_source_type;
424: End If;
425: If (p_rec.tax_year = hr_api.g_number) then

Line 425: If (p_rec.tax_year = hr_api.g_number) then

421: If (p_rec.data_source_type = hr_api.g_varchar2) then
422: p_rec.data_source_type :=
423: pqp_atd_shd.g_old_rec.data_source_type;
424: End If;
425: If (p_rec.tax_year = hr_api.g_number) then
426: p_rec.tax_year :=
427: pqp_atd_shd.g_old_rec.tax_year;
428: End If;
429: If (p_rec.income_code = hr_api.g_varchar2) then

Line 429: If (p_rec.income_code = hr_api.g_varchar2) then

425: If (p_rec.tax_year = hr_api.g_number) then
426: p_rec.tax_year :=
427: pqp_atd_shd.g_old_rec.tax_year;
428: End If;
429: If (p_rec.income_code = hr_api.g_varchar2) then
430: p_rec.income_code :=
431: pqp_atd_shd.g_old_rec.income_code;
432: End If;
433: If (p_rec.withholding_rate = hr_api.g_number) then

Line 433: If (p_rec.withholding_rate = hr_api.g_number) then

429: If (p_rec.income_code = hr_api.g_varchar2) then
430: p_rec.income_code :=
431: pqp_atd_shd.g_old_rec.income_code;
432: End If;
433: If (p_rec.withholding_rate = hr_api.g_number) then
434: p_rec.withholding_rate :=
435: pqp_atd_shd.g_old_rec.withholding_rate;
436: End If;
437: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then

Line 437: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then

433: If (p_rec.withholding_rate = hr_api.g_number) then
434: p_rec.withholding_rate :=
435: pqp_atd_shd.g_old_rec.withholding_rate;
436: End If;
437: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
438: p_rec.income_code_sub_type :=
439: pqp_atd_shd.g_old_rec.income_code_sub_type;
440: End If;
441: If (p_rec.exemption_code = hr_api.g_varchar2) then

Line 441: If (p_rec.exemption_code = hr_api.g_varchar2) then

437: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
438: p_rec.income_code_sub_type :=
439: pqp_atd_shd.g_old_rec.income_code_sub_type;
440: End If;
441: If (p_rec.exemption_code = hr_api.g_varchar2) then
442: p_rec.exemption_code :=
443: pqp_atd_shd.g_old_rec.exemption_code;
444: End If;
445: If (p_rec.maximum_benefit_amount = hr_api.g_number) then

Line 445: If (p_rec.maximum_benefit_amount = hr_api.g_number) then

441: If (p_rec.exemption_code = hr_api.g_varchar2) then
442: p_rec.exemption_code :=
443: pqp_atd_shd.g_old_rec.exemption_code;
444: End If;
445: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
446: p_rec.maximum_benefit_amount :=
447: pqp_atd_shd.g_old_rec.maximum_benefit_amount;
448: End If;
449: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then

Line 449: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then

445: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
446: p_rec.maximum_benefit_amount :=
447: pqp_atd_shd.g_old_rec.maximum_benefit_amount;
448: End If;
449: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
450: p_rec.retro_lose_ben_amt_flag :=
451: pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag;
452: End If;
453: If (p_rec.date_benefit_ends = hr_api.g_date) then

Line 453: If (p_rec.date_benefit_ends = hr_api.g_date) then

449: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
450: p_rec.retro_lose_ben_amt_flag :=
451: pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag;
452: End If;
453: If (p_rec.date_benefit_ends = hr_api.g_date) then
454: p_rec.date_benefit_ends :=
455: pqp_atd_shd.g_old_rec.date_benefit_ends;
456: End If;
457: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then

Line 457: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then

453: If (p_rec.date_benefit_ends = hr_api.g_date) then
454: p_rec.date_benefit_ends :=
455: pqp_atd_shd.g_old_rec.date_benefit_ends;
456: End If;
457: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
458: p_rec.retro_lose_ben_date_flag :=
459: pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag;
460: End If;
461: If (p_rec.current_residency_status = hr_api.g_varchar2) then

Line 461: If (p_rec.current_residency_status = hr_api.g_varchar2) then

457: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
458: p_rec.retro_lose_ben_date_flag :=
459: pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag;
460: End If;
461: If (p_rec.current_residency_status = hr_api.g_varchar2) then
462: p_rec.current_residency_status :=
463: pqp_atd_shd.g_old_rec.current_residency_status;
464: End If;
465: If (p_rec.nra_to_ra_date = hr_api.g_date) then

Line 465: If (p_rec.nra_to_ra_date = hr_api.g_date) then

461: If (p_rec.current_residency_status = hr_api.g_varchar2) then
462: p_rec.current_residency_status :=
463: pqp_atd_shd.g_old_rec.current_residency_status;
464: End If;
465: If (p_rec.nra_to_ra_date = hr_api.g_date) then
466: p_rec.nra_to_ra_date :=
467: pqp_atd_shd.g_old_rec.nra_to_ra_date;
468: End If;
469: If (p_rec.target_departure_date = hr_api.g_date) then

Line 469: If (p_rec.target_departure_date = hr_api.g_date) then

465: If (p_rec.nra_to_ra_date = hr_api.g_date) then
466: p_rec.nra_to_ra_date :=
467: pqp_atd_shd.g_old_rec.nra_to_ra_date;
468: End If;
469: If (p_rec.target_departure_date = hr_api.g_date) then
470: p_rec.target_departure_date :=
471: pqp_atd_shd.g_old_rec.target_departure_date;
472: End If;
473: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then

Line 473: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then

469: If (p_rec.target_departure_date = hr_api.g_date) then
470: p_rec.target_departure_date :=
471: pqp_atd_shd.g_old_rec.target_departure_date;
472: End If;
473: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
474: p_rec.tax_residence_country_code :=
475: pqp_atd_shd.g_old_rec.tax_residence_country_code;
476: End If;
477: If (p_rec.treaty_info_update_date = hr_api.g_date) then

Line 477: If (p_rec.treaty_info_update_date = hr_api.g_date) then

473: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
474: p_rec.tax_residence_country_code :=
475: pqp_atd_shd.g_old_rec.tax_residence_country_code;
476: End If;
477: If (p_rec.treaty_info_update_date = hr_api.g_date) then
478: p_rec.treaty_info_update_date :=
479: pqp_atd_shd.g_old_rec.treaty_info_update_date;
480: End If;
481: If (p_rec.nra_exempt_from_fica = hr_api.g_varchar2) then

Line 481: If (p_rec.nra_exempt_from_fica = hr_api.g_varchar2) then

477: If (p_rec.treaty_info_update_date = hr_api.g_date) then
478: p_rec.treaty_info_update_date :=
479: pqp_atd_shd.g_old_rec.treaty_info_update_date;
480: End If;
481: If (p_rec.nra_exempt_from_fica = hr_api.g_varchar2) then
482: p_rec.nra_exempt_from_fica :=
483: pqp_atd_shd.g_old_rec.nra_exempt_from_fica;
484: End If;
485: If (p_rec.student_exempt_from_fica = hr_api.g_varchar2) then

Line 485: If (p_rec.student_exempt_from_fica = hr_api.g_varchar2) then

481: If (p_rec.nra_exempt_from_fica = hr_api.g_varchar2) then
482: p_rec.nra_exempt_from_fica :=
483: pqp_atd_shd.g_old_rec.nra_exempt_from_fica;
484: End If;
485: If (p_rec.student_exempt_from_fica = hr_api.g_varchar2) then
486: p_rec.student_exempt_from_fica :=
487: pqp_atd_shd.g_old_rec.student_exempt_from_fica;
488: End If;
489: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then

Line 489: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then

485: If (p_rec.student_exempt_from_fica = hr_api.g_varchar2) then
486: p_rec.student_exempt_from_fica :=
487: pqp_atd_shd.g_old_rec.student_exempt_from_fica;
488: End If;
489: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
490: p_rec.addl_withholding_flag :=
491: pqp_atd_shd.g_old_rec.addl_withholding_flag;
492: End If;
493: If (p_rec.addl_withholding_amt = hr_api.g_number) then

Line 493: If (p_rec.addl_withholding_amt = hr_api.g_number) then

489: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
490: p_rec.addl_withholding_flag :=
491: pqp_atd_shd.g_old_rec.addl_withholding_flag;
492: End If;
493: If (p_rec.addl_withholding_amt = hr_api.g_number) then
494: p_rec.addl_withholding_amt :=
495: pqp_atd_shd.g_old_rec.addl_withholding_amt;
496: End If;
497: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then

Line 497: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then

493: If (p_rec.addl_withholding_amt = hr_api.g_number) then
494: p_rec.addl_withholding_amt :=
495: pqp_atd_shd.g_old_rec.addl_withholding_amt;
496: End If;
497: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
498: p_rec.addl_wthldng_amt_period_type :=
499: pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type;
500: End If;
501: If (p_rec.personal_exemption = hr_api.g_number) then

Line 501: If (p_rec.personal_exemption = hr_api.g_number) then

497: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
498: p_rec.addl_wthldng_amt_period_type :=
499: pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type;
500: End If;
501: If (p_rec.personal_exemption = hr_api.g_number) then
502: p_rec.personal_exemption :=
503: pqp_atd_shd.g_old_rec.personal_exemption;
504: End If;
505: If (p_rec.addl_exemption_allowed = hr_api.g_number) then

Line 505: If (p_rec.addl_exemption_allowed = hr_api.g_number) then

501: If (p_rec.personal_exemption = hr_api.g_number) then
502: p_rec.personal_exemption :=
503: pqp_atd_shd.g_old_rec.personal_exemption;
504: End If;
505: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
506: p_rec.addl_exemption_allowed :=
507: pqp_atd_shd.g_old_rec.addl_exemption_allowed;
508: End If;
509: If (p_rec.number_of_days_in_usa = hr_api.g_number) then

Line 509: If (p_rec.number_of_days_in_usa = hr_api.g_number) then

505: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
506: p_rec.addl_exemption_allowed :=
507: pqp_atd_shd.g_old_rec.addl_exemption_allowed;
508: End If;
509: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
510: p_rec.number_of_days_in_usa :=
511: pqp_atd_shd.g_old_rec.number_of_days_in_usa;
512: End If;
513: If (p_rec.wthldg_allow_eligible_flag = hr_api.g_varchar2) then

Line 513: If (p_rec.wthldg_allow_eligible_flag = hr_api.g_varchar2) then

509: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
510: p_rec.number_of_days_in_usa :=
511: pqp_atd_shd.g_old_rec.number_of_days_in_usa;
512: End If;
513: If (p_rec.wthldg_allow_eligible_flag = hr_api.g_varchar2) then
514: p_rec.wthldg_allow_eligible_flag :=
515: pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag;
516: End If;
517: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then

Line 517: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then

513: If (p_rec.wthldg_allow_eligible_flag = hr_api.g_varchar2) then
514: p_rec.wthldg_allow_eligible_flag :=
515: pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag;
516: End If;
517: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
518: p_rec.treaty_ben_allowed_flag :=
519: pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag;
520: End If;
521: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then

Line 521: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then

517: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
518: p_rec.treaty_ben_allowed_flag :=
519: pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag;
520: End If;
521: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
522: p_rec.treaty_benefits_start_date :=
523: pqp_atd_shd.g_old_rec.treaty_benefits_start_date;
524: End If;
525: If (p_rec.ra_effective_date = hr_api.g_date) then

Line 525: If (p_rec.ra_effective_date = hr_api.g_date) then

521: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
522: p_rec.treaty_benefits_start_date :=
523: pqp_atd_shd.g_old_rec.treaty_benefits_start_date;
524: End If;
525: If (p_rec.ra_effective_date = hr_api.g_date) then
526: p_rec.ra_effective_date :=
527: pqp_atd_shd.g_old_rec.ra_effective_date;
528: End If;
529: If (p_rec.state_code = hr_api.g_varchar2) then

Line 529: If (p_rec.state_code = hr_api.g_varchar2) then

525: If (p_rec.ra_effective_date = hr_api.g_date) then
526: p_rec.ra_effective_date :=
527: pqp_atd_shd.g_old_rec.ra_effective_date;
528: End If;
529: If (p_rec.state_code = hr_api.g_varchar2) then
530: p_rec.state_code :=
531: pqp_atd_shd.g_old_rec.state_code;
532: End If;
533: If (p_rec.state_honors_treaty_flag = hr_api.g_varchar2) then

Line 533: If (p_rec.state_honors_treaty_flag = hr_api.g_varchar2) then

529: If (p_rec.state_code = hr_api.g_varchar2) then
530: p_rec.state_code :=
531: pqp_atd_shd.g_old_rec.state_code;
532: End If;
533: If (p_rec.state_honors_treaty_flag = hr_api.g_varchar2) then
534: p_rec.state_honors_treaty_flag :=
535: pqp_atd_shd.g_old_rec.state_honors_treaty_flag;
536: End If;
537: If (p_rec.ytd_payments = hr_api.g_number) then

Line 537: If (p_rec.ytd_payments = hr_api.g_number) then

533: If (p_rec.state_honors_treaty_flag = hr_api.g_varchar2) then
534: p_rec.state_honors_treaty_flag :=
535: pqp_atd_shd.g_old_rec.state_honors_treaty_flag;
536: End If;
537: If (p_rec.ytd_payments = hr_api.g_number) then
538: p_rec.ytd_payments :=
539: pqp_atd_shd.g_old_rec.ytd_payments;
540: End If;
541: If (p_rec.ytd_w2_payments = hr_api.g_number) then

Line 541: If (p_rec.ytd_w2_payments = hr_api.g_number) then

537: If (p_rec.ytd_payments = hr_api.g_number) then
538: p_rec.ytd_payments :=
539: pqp_atd_shd.g_old_rec.ytd_payments;
540: End If;
541: If (p_rec.ytd_w2_payments = hr_api.g_number) then
542: p_rec.ytd_w2_payments :=
543: pqp_atd_shd.g_old_rec.ytd_w2_payments;
544: End If;
545: If (p_rec.ytd_w2_withholding = hr_api.g_number) then

Line 545: If (p_rec.ytd_w2_withholding = hr_api.g_number) then

541: If (p_rec.ytd_w2_payments = hr_api.g_number) then
542: p_rec.ytd_w2_payments :=
543: pqp_atd_shd.g_old_rec.ytd_w2_payments;
544: End If;
545: If (p_rec.ytd_w2_withholding = hr_api.g_number) then
546: p_rec.ytd_w2_withholding :=
547: pqp_atd_shd.g_old_rec.ytd_w2_withholding;
548: End If;
549: If (p_rec.ytd_withholding_allowance = hr_api.g_number) then

Line 549: If (p_rec.ytd_withholding_allowance = hr_api.g_number) then

545: If (p_rec.ytd_w2_withholding = hr_api.g_number) then
546: p_rec.ytd_w2_withholding :=
547: pqp_atd_shd.g_old_rec.ytd_w2_withholding;
548: End If;
549: If (p_rec.ytd_withholding_allowance = hr_api.g_number) then
550: p_rec.ytd_withholding_allowance :=
551: pqp_atd_shd.g_old_rec.ytd_withholding_allowance;
552: End If;
553: If (p_rec.ytd_treaty_payments = hr_api.g_number) then

Line 553: If (p_rec.ytd_treaty_payments = hr_api.g_number) then

549: If (p_rec.ytd_withholding_allowance = hr_api.g_number) then
550: p_rec.ytd_withholding_allowance :=
551: pqp_atd_shd.g_old_rec.ytd_withholding_allowance;
552: End If;
553: If (p_rec.ytd_treaty_payments = hr_api.g_number) then
554: p_rec.ytd_treaty_payments :=
555: pqp_atd_shd.g_old_rec.ytd_treaty_payments;
556: End If;
557: If (p_rec.ytd_treaty_withheld_amt = hr_api.g_number) then

Line 557: If (p_rec.ytd_treaty_withheld_amt = hr_api.g_number) then

553: If (p_rec.ytd_treaty_payments = hr_api.g_number) then
554: p_rec.ytd_treaty_payments :=
555: pqp_atd_shd.g_old_rec.ytd_treaty_payments;
556: End If;
557: If (p_rec.ytd_treaty_withheld_amt = hr_api.g_number) then
558: p_rec.ytd_treaty_withheld_amt :=
559: pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt;
560: End If;
561: If (p_rec.record_source = hr_api.g_varchar2) then

Line 561: If (p_rec.record_source = hr_api.g_varchar2) then

557: If (p_rec.ytd_treaty_withheld_amt = hr_api.g_number) then
558: p_rec.ytd_treaty_withheld_amt :=
559: pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt;
560: End If;
561: If (p_rec.record_source = hr_api.g_varchar2) then
562: p_rec.record_source :=
563: pqp_atd_shd.g_old_rec.record_source;
564: End If;
565: If (p_rec.visa_type = hr_api.g_varchar2) then

Line 565: If (p_rec.visa_type = hr_api.g_varchar2) then

561: If (p_rec.record_source = hr_api.g_varchar2) then
562: p_rec.record_source :=
563: pqp_atd_shd.g_old_rec.record_source;
564: End If;
565: If (p_rec.visa_type = hr_api.g_varchar2) then
566: p_rec.visa_type :=
567: pqp_atd_shd.g_old_rec.visa_type;
568: End If;
569: If (p_rec.j_sub_type = hr_api.g_varchar2) then

Line 569: If (p_rec.j_sub_type = hr_api.g_varchar2) then

565: If (p_rec.visa_type = hr_api.g_varchar2) then
566: p_rec.visa_type :=
567: pqp_atd_shd.g_old_rec.visa_type;
568: End If;
569: If (p_rec.j_sub_type = hr_api.g_varchar2) then
570: p_rec.j_sub_type :=
571: pqp_atd_shd.g_old_rec.j_sub_type;
572: End If;
573: If (p_rec.primary_activity = hr_api.g_varchar2) then

Line 573: If (p_rec.primary_activity = hr_api.g_varchar2) then

569: If (p_rec.j_sub_type = hr_api.g_varchar2) then
570: p_rec.j_sub_type :=
571: pqp_atd_shd.g_old_rec.j_sub_type;
572: End If;
573: If (p_rec.primary_activity = hr_api.g_varchar2) then
574: p_rec.primary_activity :=
575: pqp_atd_shd.g_old_rec.primary_activity;
576: End If;
577: If (p_rec.non_us_country_code = hr_api.g_varchar2) then

Line 577: If (p_rec.non_us_country_code = hr_api.g_varchar2) then

573: If (p_rec.primary_activity = hr_api.g_varchar2) then
574: p_rec.primary_activity :=
575: pqp_atd_shd.g_old_rec.primary_activity;
576: End If;
577: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
578: p_rec.non_us_country_code :=
579: pqp_atd_shd.g_old_rec.non_us_country_code;
580: End If;
581: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then

Line 581: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then

577: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
578: p_rec.non_us_country_code :=
579: pqp_atd_shd.g_old_rec.non_us_country_code;
580: End If;
581: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
582: p_rec.citizenship_country_code :=
583: pqp_atd_shd.g_old_rec.citizenship_country_code;
584: End If;
585: If (p_rec.constant_addl_tax = hr_api.g_number) then

Line 585: If (p_rec.constant_addl_tax = hr_api.g_number) then

581: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
582: p_rec.citizenship_country_code :=
583: pqp_atd_shd.g_old_rec.citizenship_country_code;
584: End If;
585: If (p_rec.constant_addl_tax = hr_api.g_number) then
586: p_rec.constant_addl_tax :=
587: pqp_atd_shd.g_old_rec.constant_addl_tax;
588: End If;
589: If (p_rec.date_8233_signed = hr_api.g_date) then

Line 589: If (p_rec.date_8233_signed = hr_api.g_date) then

585: If (p_rec.constant_addl_tax = hr_api.g_number) then
586: p_rec.constant_addl_tax :=
587: pqp_atd_shd.g_old_rec.constant_addl_tax;
588: End If;
589: If (p_rec.date_8233_signed = hr_api.g_date) then
590: p_rec.date_8233_signed :=
591: pqp_atd_shd.g_old_rec.date_8233_signed;
592: End If;
593: If (p_rec.date_w4_signed = hr_api.g_date) then

Line 593: If (p_rec.date_w4_signed = hr_api.g_date) then

589: If (p_rec.date_8233_signed = hr_api.g_date) then
590: p_rec.date_8233_signed :=
591: pqp_atd_shd.g_old_rec.date_8233_signed;
592: End If;
593: If (p_rec.date_w4_signed = hr_api.g_date) then
594: p_rec.date_w4_signed :=
595: pqp_atd_shd.g_old_rec.date_w4_signed;
596: End If;
597: If (p_rec.error_indicator = hr_api.g_varchar2) then

Line 597: If (p_rec.error_indicator = hr_api.g_varchar2) then

593: If (p_rec.date_w4_signed = hr_api.g_date) then
594: p_rec.date_w4_signed :=
595: pqp_atd_shd.g_old_rec.date_w4_signed;
596: End If;
597: If (p_rec.error_indicator = hr_api.g_varchar2) then
598: p_rec.error_indicator :=
599: pqp_atd_shd.g_old_rec.error_indicator;
600: End If;
601: If (p_rec.prev_er_treaty_benefit_amt = hr_api.g_number) then

Line 601: If (p_rec.prev_er_treaty_benefit_amt = hr_api.g_number) then

597: If (p_rec.error_indicator = hr_api.g_varchar2) then
598: p_rec.error_indicator :=
599: pqp_atd_shd.g_old_rec.error_indicator;
600: End If;
601: If (p_rec.prev_er_treaty_benefit_amt = hr_api.g_number) then
602: p_rec.prev_er_treaty_benefit_amt :=
603: pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt;
604: End If;
605: If (p_rec.error_text = hr_api.g_varchar2) then

Line 605: If (p_rec.error_text = hr_api.g_varchar2) then

601: If (p_rec.prev_er_treaty_benefit_amt = hr_api.g_number) then
602: p_rec.prev_er_treaty_benefit_amt :=
603: pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt;
604: End If;
605: If (p_rec.error_text = hr_api.g_varchar2) then
606: p_rec.error_text :=
607: pqp_atd_shd.g_old_rec.error_text;
608: End If;
609: If (p_rec.current_analysis= hr_api.g_varchar2) then

Line 609: If (p_rec.current_analysis= hr_api.g_varchar2) then

605: If (p_rec.error_text = hr_api.g_varchar2) then
606: p_rec.error_text :=
607: pqp_atd_shd.g_old_rec.error_text;
608: End If;
609: If (p_rec.current_analysis= hr_api.g_varchar2) then
610: p_rec.current_analysis :=
611: pqp_atd_shd.g_old_rec.current_analysis;
612: End If;
613: If (p_rec.forecast_income_code = hr_api.g_varchar2) then

Line 613: If (p_rec.forecast_income_code = hr_api.g_varchar2) then

609: If (p_rec.current_analysis= hr_api.g_varchar2) then
610: p_rec.current_analysis :=
611: pqp_atd_shd.g_old_rec.current_analysis;
612: End If;
613: If (p_rec.forecast_income_code = hr_api.g_varchar2) then
614: p_rec.forecast_income_code :=
615: pqp_atd_shd.g_old_rec.forecast_income_code;
616: End If;
617:

Line 676: p_person_id in number default hr_api.g_number ,

672: Procedure upd
673: (
674: p_effective_date in date,
675: p_alien_transaction_id in number,
676: p_person_id in number default hr_api.g_number ,
677: p_data_source_type in varchar2 default hr_api.g_varchar2,
678: p_tax_year in number default hr_api.g_number,
679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,

Line 677: p_data_source_type in varchar2 default hr_api.g_varchar2,

673: (
674: p_effective_date in date,
675: p_alien_transaction_id in number,
676: p_person_id in number default hr_api.g_number ,
677: p_data_source_type in varchar2 default hr_api.g_varchar2,
678: p_tax_year in number default hr_api.g_number,
679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,

Line 678: p_tax_year in number default hr_api.g_number,

674: p_effective_date in date,
675: p_alien_transaction_id in number,
676: p_person_id in number default hr_api.g_number ,
677: p_data_source_type in varchar2 default hr_api.g_varchar2,
678: p_tax_year in number default hr_api.g_number,
679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,

Line 679: p_income_code in varchar2 default hr_api.g_varchar2,

675: p_alien_transaction_id in number,
676: p_person_id in number default hr_api.g_number ,
677: p_data_source_type in varchar2 default hr_api.g_varchar2,
678: p_tax_year in number default hr_api.g_number,
679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,

Line 680: p_withholding_rate in number default hr_api.g_number,

676: p_person_id in number default hr_api.g_number ,
677: p_data_source_type in varchar2 default hr_api.g_varchar2,
678: p_tax_year in number default hr_api.g_number,
679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,

Line 681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,

677: p_data_source_type in varchar2 default hr_api.g_varchar2,
678: p_tax_year in number default hr_api.g_number,
679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,

Line 682: p_exemption_code in varchar2 default hr_api.g_varchar2,

678: p_tax_year in number default hr_api.g_number,
679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,

Line 683: p_maximum_benefit_amount in number default hr_api.g_number,

679: p_income_code in varchar2 default hr_api.g_varchar2,
680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,

Line 684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,

680: p_withholding_rate in number default hr_api.g_number,
681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,

Line 685: p_date_benefit_ends in date default hr_api.g_date,

681: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,

Line 686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,

682: p_exemption_code in varchar2 default hr_api.g_varchar2,
683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,

Line 687: p_current_residency_status in varchar2 default hr_api.g_varchar2,

683: p_maximum_benefit_amount in number default hr_api.g_number,
684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,

Line 688: p_nra_to_ra_date in date default hr_api.g_date,

684: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,

Line 689: p_target_departure_date in date default hr_api.g_date,

685: p_date_benefit_ends in date default hr_api.g_date,
686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,

Line 690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,

686: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,

Line 691: p_treaty_info_update_date in date default hr_api.g_date,

687: p_current_residency_status in varchar2 default hr_api.g_varchar2,
688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,

Line 692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,

688: p_nra_to_ra_date in date default hr_api.g_date,
689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,

Line 693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,

689: p_target_departure_date in date default hr_api.g_date,
690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,

Line 694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,

690: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,

Line 695: p_addl_withholding_amt in number default hr_api.g_number,

691: p_treaty_info_update_date in date default hr_api.g_date,
692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,

Line 696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,

692: p_nra_exempt_from_fica in varchar2 default hr_api.g_varchar2,
693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,

Line 697: p_personal_exemption in number default hr_api.g_number,

693: p_student_exempt_from_fica in varchar2 default hr_api.g_varchar2,
694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,

Line 698: p_addl_exemption_allowed in number default hr_api.g_number,

694: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,

Line 699: p_number_of_days_in_usa in number default hr_api.g_number,

695: p_addl_withholding_amt in number default hr_api.g_number,
696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,

Line 700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,

696: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,

Line 701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,

697: p_personal_exemption in number default hr_api.g_number,
698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,

Line 702: p_treaty_benefits_start_date in date default hr_api.g_date,

698: p_addl_exemption_allowed in number default hr_api.g_number,
699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,

Line 703: p_ra_effective_date in date default hr_api.g_date,

699: p_number_of_days_in_usa in number default hr_api.g_number,
700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,

Line 704: p_state_code in varchar2 default hr_api.g_varchar2,

700: p_wthldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,

Line 705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,

701: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,

Line 706: p_ytd_payments in number default hr_api.g_number,

702: p_treaty_benefits_start_date in date default hr_api.g_date,
703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,

Line 707: p_ytd_w2_payments in number default hr_api.g_number,

703: p_ra_effective_date in date default hr_api.g_date,
704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,

Line 708: p_ytd_w2_withholding in number default hr_api.g_number,

704: p_state_code in varchar2 default hr_api.g_varchar2,
705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,

Line 709: p_ytd_withholding_allowance in number default hr_api.g_number,

705: p_state_honors_treaty_flag in varchar2 default hr_api.g_varchar2,
706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,

Line 710: p_ytd_treaty_payments in number default hr_api.g_number,

706: p_ytd_payments in number default hr_api.g_number,
707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,

Line 711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,

707: p_ytd_w2_payments in number default hr_api.g_number,
708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,

Line 712: p_record_source in varchar2 default hr_api.g_varchar2,

708: p_ytd_w2_withholding in number default hr_api.g_number,
709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,

Line 713: p_visa_type in varchar2 default hr_api.g_varchar2,

709: p_ytd_withholding_allowance in number default hr_api.g_number,
710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,

Line 714: p_j_sub_type in varchar2 default hr_api.g_varchar2,

710: p_ytd_treaty_payments in number default hr_api.g_number,
711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,

Line 715: p_primary_activity in varchar2 default hr_api.g_varchar2,

711: p_ytd_treaty_withheld_amt in number default hr_api.g_number,
712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,

Line 716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,

712: p_record_source in varchar2 default hr_api.g_varchar2,
713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,

Line 717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,

713: p_visa_type in varchar2 default hr_api.g_varchar2,
714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,
721: p_error_indicator in varchar2 default hr_api.g_varchar2,

Line 718: p_constant_addl_tax in number default hr_api.g_number,

714: p_j_sub_type in varchar2 default hr_api.g_varchar2,
715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,
721: p_error_indicator in varchar2 default hr_api.g_varchar2,
722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,

Line 719: p_date_8233_signed in date default hr_api.g_date,

715: p_primary_activity in varchar2 default hr_api.g_varchar2,
716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,
721: p_error_indicator in varchar2 default hr_api.g_varchar2,
722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,
723: p_error_text in varchar2 default hr_api.g_varchar2,

Line 720: p_date_w4_signed in date default hr_api.g_date,

716: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,
721: p_error_indicator in varchar2 default hr_api.g_varchar2,
722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,
723: p_error_text in varchar2 default hr_api.g_varchar2,
724: p_object_version_number in out nocopy number,

Line 721: p_error_indicator in varchar2 default hr_api.g_varchar2,

717: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,
721: p_error_indicator in varchar2 default hr_api.g_varchar2,
722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,
723: p_error_text in varchar2 default hr_api.g_varchar2,
724: p_object_version_number in out nocopy number,
725: p_current_analysis in varchar2 default hr_api.g_varchar2,

Line 722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,

718: p_constant_addl_tax in number default hr_api.g_number,
719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,
721: p_error_indicator in varchar2 default hr_api.g_varchar2,
722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,
723: p_error_text in varchar2 default hr_api.g_varchar2,
724: p_object_version_number in out nocopy number,
725: p_current_analysis in varchar2 default hr_api.g_varchar2,
726: p_forecast_income_code in varchar2 default hr_api.g_varchar2

Line 723: p_error_text in varchar2 default hr_api.g_varchar2,

719: p_date_8233_signed in date default hr_api.g_date,
720: p_date_w4_signed in date default hr_api.g_date,
721: p_error_indicator in varchar2 default hr_api.g_varchar2,
722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,
723: p_error_text in varchar2 default hr_api.g_varchar2,
724: p_object_version_number in out nocopy number,
725: p_current_analysis in varchar2 default hr_api.g_varchar2,
726: p_forecast_income_code in varchar2 default hr_api.g_varchar2
727: ) is

Line 725: p_current_analysis in varchar2 default hr_api.g_varchar2,

721: p_error_indicator in varchar2 default hr_api.g_varchar2,
722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,
723: p_error_text in varchar2 default hr_api.g_varchar2,
724: p_object_version_number in out nocopy number,
725: p_current_analysis in varchar2 default hr_api.g_varchar2,
726: p_forecast_income_code in varchar2 default hr_api.g_varchar2
727: ) is
728:
729: l_rec pqp_atd_shd.g_rec_type;

Line 726: p_forecast_income_code in varchar2 default hr_api.g_varchar2

722: p_prev_er_treaty_benefit_amt in number default hr_api.g_number,
723: p_error_text in varchar2 default hr_api.g_varchar2,
724: p_object_version_number in out nocopy number,
725: p_current_analysis in varchar2 default hr_api.g_varchar2,
726: p_forecast_income_code in varchar2 default hr_api.g_varchar2
727: ) is
728:
729: l_rec pqp_atd_shd.g_rec_type;
730: l_proc varchar2(72) := g_package||'upd';