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.PAY_PPD_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 117: When hr_api.check_integrity_violated Then

113: End If;
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 15);
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: pay_ppd_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: pay_ppd_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: pay_ppd_shd.constraint_error

Line 122: When hr_api.unique_integrity_violated Then

118: -- A check constraint has been violated
119: --
120: pay_ppd_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: pay_ppd_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: pay_ppd_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: --
129: Raise;
130: End dt_update_dml;

Line 243: If (p_datetrack_mode <> hr_api.g_correction) then

239: l_dummy_version_number number;
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: If (p_datetrack_mode <> hr_api.g_correction) then
244: --
245: -- Update the current effective end date
246: --
247: pay_ppd_shd.upd_effective_end_date

Line 256: If (p_datetrack_mode = hr_api.g_update_override) then

252: ,p_validation_end_date => p_validation_end_date
253: ,p_object_version_number => l_dummy_version_number
254: );
255: --
256: If (p_datetrack_mode = hr_api.g_update_override) then
257: --
258: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
259: -- delete any future rows
260: --

Line 462: when hr_api.cannot_find_prog_unit then

458: );
459: --
460: exception
461: --
462: when hr_api.cannot_find_prog_unit then
463: --
464: hr_api.cannot_find_prog_unit_error
465: (p_module_name => 'PAY_PL_PAYE_DETAILS_F'
466: ,p_hook_type => 'AU');

Line 464: hr_api.cannot_find_prog_unit_error

460: exception
461: --
462: when hr_api.cannot_find_prog_unit then
463: --
464: hr_api.cannot_find_prog_unit_error
465: (p_module_name => 'PAY_PL_PAYE_DETAILS_F'
466: ,p_hook_type => 'AU');
467: --
468: end;

Line 527: If (p_rec.per_or_asg_id = hr_api.g_number) then

523: -- p_rec plsql record structure
524: -- to see if a system default is being used. If a system default
525: -- is being used then we must set to the 'current' argument value.
526: --
527: If (p_rec.per_or_asg_id = hr_api.g_number) then
528: p_rec.per_or_asg_id :=
529: pay_ppd_shd.g_old_rec.per_or_asg_id;
530: End If;
531: If (p_rec.business_group_id = hr_api.g_number) then

Line 531: If (p_rec.business_group_id = hr_api.g_number) then

527: If (p_rec.per_or_asg_id = hr_api.g_number) then
528: p_rec.per_or_asg_id :=
529: pay_ppd_shd.g_old_rec.per_or_asg_id;
530: End If;
531: If (p_rec.business_group_id = hr_api.g_number) then
532: p_rec.business_group_id :=
533: pay_ppd_shd.g_old_rec.business_group_id;
534: End If;
535: If (p_rec.contract_category = hr_api.g_varchar2) then

Line 535: If (p_rec.contract_category = hr_api.g_varchar2) then

531: If (p_rec.business_group_id = hr_api.g_number) then
532: p_rec.business_group_id :=
533: pay_ppd_shd.g_old_rec.business_group_id;
534: End If;
535: If (p_rec.contract_category = hr_api.g_varchar2) then
536: p_rec.contract_category :=
537: pay_ppd_shd.g_old_rec.contract_category;
538: End If;
539: If (p_rec.tax_reduction = hr_api.g_varchar2) then

Line 539: If (p_rec.tax_reduction = hr_api.g_varchar2) then

535: If (p_rec.contract_category = hr_api.g_varchar2) then
536: p_rec.contract_category :=
537: pay_ppd_shd.g_old_rec.contract_category;
538: End If;
539: If (p_rec.tax_reduction = hr_api.g_varchar2) then
540: p_rec.tax_reduction :=
541: pay_ppd_shd.g_old_rec.tax_reduction;
542: End If;
543: If (p_rec.tax_calc_with_spouse_child = hr_api.g_varchar2) then

Line 543: If (p_rec.tax_calc_with_spouse_child = hr_api.g_varchar2) then

539: If (p_rec.tax_reduction = hr_api.g_varchar2) then
540: p_rec.tax_reduction :=
541: pay_ppd_shd.g_old_rec.tax_reduction;
542: End If;
543: If (p_rec.tax_calc_with_spouse_child = hr_api.g_varchar2) then
544: p_rec.tax_calc_with_spouse_child :=
545: pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child;
546: End If;
547: If (p_rec.income_reduction = hr_api.g_varchar2) then

Line 547: If (p_rec.income_reduction = hr_api.g_varchar2) then

543: If (p_rec.tax_calc_with_spouse_child = hr_api.g_varchar2) then
544: p_rec.tax_calc_with_spouse_child :=
545: pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child;
546: End If;
547: If (p_rec.income_reduction = hr_api.g_varchar2) then
548: p_rec.income_reduction :=
549: pay_ppd_shd.g_old_rec.income_reduction;
550: End If;
551: If (p_rec.income_reduction_amount = hr_api.g_number) then

Line 551: If (p_rec.income_reduction_amount = hr_api.g_number) then

547: If (p_rec.income_reduction = hr_api.g_varchar2) then
548: p_rec.income_reduction :=
549: pay_ppd_shd.g_old_rec.income_reduction;
550: End If;
551: If (p_rec.income_reduction_amount = hr_api.g_number) then
552: p_rec.income_reduction_amount :=
553: pay_ppd_shd.g_old_rec.income_reduction_amount;
554: End If;
555: If (p_rec.rate_of_tax = hr_api.g_varchar2) then

Line 555: If (p_rec.rate_of_tax = hr_api.g_varchar2) then

551: If (p_rec.income_reduction_amount = hr_api.g_number) then
552: p_rec.income_reduction_amount :=
553: pay_ppd_shd.g_old_rec.income_reduction_amount;
554: End If;
555: If (p_rec.rate_of_tax = hr_api.g_varchar2) then
556: p_rec.rate_of_tax :=
557: pay_ppd_shd.g_old_rec.rate_of_tax;
558: End If;
559: If (p_rec.program_id = hr_api.g_number) then

Line 559: If (p_rec.program_id = hr_api.g_number) then

555: If (p_rec.rate_of_tax = hr_api.g_varchar2) then
556: p_rec.rate_of_tax :=
557: pay_ppd_shd.g_old_rec.rate_of_tax;
558: End If;
559: If (p_rec.program_id = hr_api.g_number) then
560: p_rec.program_id :=
561: pay_ppd_shd.g_old_rec.program_id;
562: End If;
563: If (p_rec.program_login_id = hr_api.g_number) then

Line 563: If (p_rec.program_login_id = hr_api.g_number) then

559: If (p_rec.program_id = hr_api.g_number) then
560: p_rec.program_id :=
561: pay_ppd_shd.g_old_rec.program_id;
562: End If;
563: If (p_rec.program_login_id = hr_api.g_number) then
564: p_rec.program_login_id :=
565: pay_ppd_shd.g_old_rec.program_login_id;
566: End If;
567: If (p_rec.program_application_id = hr_api.g_number) then

Line 567: If (p_rec.program_application_id = hr_api.g_number) then

563: If (p_rec.program_login_id = hr_api.g_number) then
564: p_rec.program_login_id :=
565: pay_ppd_shd.g_old_rec.program_login_id;
566: End If;
567: If (p_rec.program_application_id = hr_api.g_number) then
568: p_rec.program_application_id :=
569: pay_ppd_shd.g_old_rec.program_application_id;
570: End If;
571: If (p_rec.request_id = hr_api.g_number) then

Line 571: If (p_rec.request_id = hr_api.g_number) then

567: If (p_rec.program_application_id = hr_api.g_number) then
568: p_rec.program_application_id :=
569: pay_ppd_shd.g_old_rec.program_application_id;
570: End If;
571: If (p_rec.request_id = hr_api.g_number) then
572: p_rec.request_id :=
573: pay_ppd_shd.g_old_rec.request_id;
574: End If;
575: --

Line 670: ,p_tax_reduction in varchar2 default hr_api.g_varchar2

666: (p_effective_date in date
667: ,p_datetrack_mode in varchar2
668: ,p_paye_details_id in number
669: ,p_object_version_number in out nocopy number
670: ,p_tax_reduction in varchar2 default hr_api.g_varchar2
671: ,p_tax_calc_with_spouse_child in varchar2 default hr_api.g_varchar2
672: ,p_income_reduction in varchar2 default hr_api.g_varchar2
673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2

Line 671: ,p_tax_calc_with_spouse_child in varchar2 default hr_api.g_varchar2

667: ,p_datetrack_mode in varchar2
668: ,p_paye_details_id in number
669: ,p_object_version_number in out nocopy number
670: ,p_tax_reduction in varchar2 default hr_api.g_varchar2
671: ,p_tax_calc_with_spouse_child in varchar2 default hr_api.g_varchar2
672: ,p_income_reduction in varchar2 default hr_api.g_varchar2
673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number

Line 672: ,p_income_reduction in varchar2 default hr_api.g_varchar2

668: ,p_paye_details_id in number
669: ,p_object_version_number in out nocopy number
670: ,p_tax_reduction in varchar2 default hr_api.g_varchar2
671: ,p_tax_calc_with_spouse_child in varchar2 default hr_api.g_varchar2
672: ,p_income_reduction in varchar2 default hr_api.g_varchar2
673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number
676: ,p_program_login_id in number default hr_api.g_number

Line 673: ,p_income_reduction_amount in number default hr_api.g_number

669: ,p_object_version_number in out nocopy number
670: ,p_tax_reduction in varchar2 default hr_api.g_varchar2
671: ,p_tax_calc_with_spouse_child in varchar2 default hr_api.g_varchar2
672: ,p_income_reduction in varchar2 default hr_api.g_varchar2
673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number
676: ,p_program_login_id in number default hr_api.g_number
677: ,p_program_application_id in number default hr_api.g_number

Line 674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2

670: ,p_tax_reduction in varchar2 default hr_api.g_varchar2
671: ,p_tax_calc_with_spouse_child in varchar2 default hr_api.g_varchar2
672: ,p_income_reduction in varchar2 default hr_api.g_varchar2
673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number
676: ,p_program_login_id in number default hr_api.g_number
677: ,p_program_application_id in number default hr_api.g_number
678: ,p_request_id in number default hr_api.g_number

Line 675: ,p_program_id in number default hr_api.g_number

671: ,p_tax_calc_with_spouse_child in varchar2 default hr_api.g_varchar2
672: ,p_income_reduction in varchar2 default hr_api.g_varchar2
673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number
676: ,p_program_login_id in number default hr_api.g_number
677: ,p_program_application_id in number default hr_api.g_number
678: ,p_request_id in number default hr_api.g_number
679: ,p_effective_start_date out nocopy date

Line 676: ,p_program_login_id in number default hr_api.g_number

672: ,p_income_reduction in varchar2 default hr_api.g_varchar2
673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number
676: ,p_program_login_id in number default hr_api.g_number
677: ,p_program_application_id in number default hr_api.g_number
678: ,p_request_id in number default hr_api.g_number
679: ,p_effective_start_date out nocopy date
680: ,p_effective_end_date out nocopy date

Line 677: ,p_program_application_id in number default hr_api.g_number

673: ,p_income_reduction_amount in number default hr_api.g_number
674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number
676: ,p_program_login_id in number default hr_api.g_number
677: ,p_program_application_id in number default hr_api.g_number
678: ,p_request_id in number default hr_api.g_number
679: ,p_effective_start_date out nocopy date
680: ,p_effective_end_date out nocopy date
681: ) is

Line 678: ,p_request_id in number default hr_api.g_number

674: ,p_rate_of_tax in varchar2 default hr_api.g_varchar2
675: ,p_program_id in number default hr_api.g_number
676: ,p_program_login_id in number default hr_api.g_number
677: ,p_program_application_id in number default hr_api.g_number
678: ,p_request_id in number default hr_api.g_number
679: ,p_effective_start_date out nocopy date
680: ,p_effective_end_date out nocopy date
681: ) is
682: --

Line 697: ,hr_api.g_number

693: pay_ppd_shd.convert_args
694: (p_paye_details_id
695: ,null
696: ,null
697: ,hr_api.g_number
698: ,hr_api.g_number
699: ,hr_api.g_varchar2
700: ,p_object_version_number
701: ,p_tax_reduction

Line 698: ,hr_api.g_number

694: (p_paye_details_id
695: ,null
696: ,null
697: ,hr_api.g_number
698: ,hr_api.g_number
699: ,hr_api.g_varchar2
700: ,p_object_version_number
701: ,p_tax_reduction
702: ,p_tax_calc_with_spouse_child

Line 699: ,hr_api.g_varchar2

695: ,null
696: ,null
697: ,hr_api.g_number
698: ,hr_api.g_number
699: ,hr_api.g_varchar2
700: ,p_object_version_number
701: ,p_tax_reduction
702: ,p_tax_calc_with_spouse_child
703: ,p_income_reduction