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_PGR_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 118: When hr_api.check_integrity_violated Then

114: End If;
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 15);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_pgr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_pgr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
126: pay_pgr_shd.constraint_error

Line 123: When hr_api.unique_integrity_violated Then

119: -- A check constraint has been violated
120: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_pgr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
126: pay_pgr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
126: pay_pgr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
130: Raise;
131: End dt_update_dml;

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

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

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

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

Line 471: when hr_api.cannot_find_prog_unit then

467: );
468: --
469: exception
470: --
471: when hr_api.cannot_find_prog_unit then
472: --
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'PAY_GRADE_RULES_F'
475: ,p_hook_type => 'AU');

Line 473: hr_api.cannot_find_prog_unit_error

469: exception
470: --
471: when hr_api.cannot_find_prog_unit then
472: --
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'PAY_GRADE_RULES_F'
475: ,p_hook_type => 'AU');
476: --
477: end;

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

532: -- p_rec plsql record structure
533: -- to see if a system default is being used. If a system default
534: -- is being used then we must set to the 'current' argument value.
535: --
536: If (p_rec.business_group_id = hr_api.g_number) then
537: p_rec.business_group_id :=
538: pay_pgr_shd.g_old_rec.business_group_id;
539: End If;
540: If (p_rec.rate_id = hr_api.g_number) then

Line 540: If (p_rec.rate_id = hr_api.g_number) then

536: If (p_rec.business_group_id = hr_api.g_number) then
537: p_rec.business_group_id :=
538: pay_pgr_shd.g_old_rec.business_group_id;
539: End If;
540: If (p_rec.rate_id = hr_api.g_number) then
541: p_rec.rate_id :=
542: pay_pgr_shd.g_old_rec.rate_id;
543: End If;
544: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then

Line 544: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then

540: If (p_rec.rate_id = hr_api.g_number) then
541: p_rec.rate_id :=
542: pay_pgr_shd.g_old_rec.rate_id;
543: End If;
544: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then
545: p_rec.grade_or_spinal_point_id :=
546: pay_pgr_shd.g_old_rec.grade_or_spinal_point_id;
547: End If;
548: If (p_rec.rate_type = hr_api.g_varchar2) then

Line 548: If (p_rec.rate_type = hr_api.g_varchar2) then

544: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then
545: p_rec.grade_or_spinal_point_id :=
546: pay_pgr_shd.g_old_rec.grade_or_spinal_point_id;
547: End If;
548: If (p_rec.rate_type = hr_api.g_varchar2) then
549: p_rec.rate_type :=
550: pay_pgr_shd.g_old_rec.rate_type;
551: End If;
552: If (p_rec.maximum = hr_api.g_varchar2) then

Line 552: If (p_rec.maximum = hr_api.g_varchar2) then

548: If (p_rec.rate_type = hr_api.g_varchar2) then
549: p_rec.rate_type :=
550: pay_pgr_shd.g_old_rec.rate_type;
551: End If;
552: If (p_rec.maximum = hr_api.g_varchar2) then
553: p_rec.maximum :=
554: pay_pgr_shd.g_old_rec.maximum;
555: End If;
556: If (p_rec.mid_value = hr_api.g_varchar2) then

Line 556: If (p_rec.mid_value = hr_api.g_varchar2) then

552: If (p_rec.maximum = hr_api.g_varchar2) then
553: p_rec.maximum :=
554: pay_pgr_shd.g_old_rec.maximum;
555: End If;
556: If (p_rec.mid_value = hr_api.g_varchar2) then
557: p_rec.mid_value :=
558: pay_pgr_shd.g_old_rec.mid_value;
559: End If;
560: If (p_rec.minimum = hr_api.g_varchar2) then

Line 560: If (p_rec.minimum = hr_api.g_varchar2) then

556: If (p_rec.mid_value = hr_api.g_varchar2) then
557: p_rec.mid_value :=
558: pay_pgr_shd.g_old_rec.mid_value;
559: End If;
560: If (p_rec.minimum = hr_api.g_varchar2) then
561: p_rec.minimum :=
562: pay_pgr_shd.g_old_rec.minimum;
563: End If;
564: If (p_rec.value = hr_api.g_varchar2) then

Line 564: If (p_rec.value = hr_api.g_varchar2) then

560: If (p_rec.minimum = hr_api.g_varchar2) then
561: p_rec.minimum :=
562: pay_pgr_shd.g_old_rec.minimum;
563: End If;
564: If (p_rec.value = hr_api.g_varchar2) then
565: p_rec.value :=
566: pay_pgr_shd.g_old_rec.value;
567: End If;
568: If (p_rec.sequence = hr_api.g_number) then

Line 568: If (p_rec.sequence = hr_api.g_number) then

564: If (p_rec.value = hr_api.g_varchar2) then
565: p_rec.value :=
566: pay_pgr_shd.g_old_rec.value;
567: End If;
568: If (p_rec.sequence = hr_api.g_number) then
569: p_rec.sequence :=
570: pay_pgr_shd.g_old_rec.sequence;
571: End If;
572: If (p_rec.request_id = hr_api.g_number) then

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

568: If (p_rec.sequence = hr_api.g_number) then
569: p_rec.sequence :=
570: pay_pgr_shd.g_old_rec.sequence;
571: End If;
572: If (p_rec.request_id = hr_api.g_number) then
573: p_rec.request_id :=
574: pay_pgr_shd.g_old_rec.request_id;
575: End If;
576: If (p_rec.program_application_id = hr_api.g_number) then

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

572: If (p_rec.request_id = hr_api.g_number) then
573: p_rec.request_id :=
574: pay_pgr_shd.g_old_rec.request_id;
575: End If;
576: If (p_rec.program_application_id = hr_api.g_number) then
577: p_rec.program_application_id :=
578: pay_pgr_shd.g_old_rec.program_application_id;
579: End If;
580: If (p_rec.program_id = hr_api.g_number) then

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

576: If (p_rec.program_application_id = hr_api.g_number) then
577: p_rec.program_application_id :=
578: pay_pgr_shd.g_old_rec.program_application_id;
579: End If;
580: If (p_rec.program_id = hr_api.g_number) then
581: p_rec.program_id :=
582: pay_pgr_shd.g_old_rec.program_id;
583: End If;
584: If (p_rec.program_update_date = hr_api.g_date) then

Line 584: If (p_rec.program_update_date = hr_api.g_date) then

580: If (p_rec.program_id = hr_api.g_number) then
581: p_rec.program_id :=
582: pay_pgr_shd.g_old_rec.program_id;
583: End If;
584: If (p_rec.program_update_date = hr_api.g_date) then
585: p_rec.program_update_date :=
586: pay_pgr_shd.g_old_rec.program_update_date;
587: End If;
588: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 588: If (p_rec.currency_code = hr_api.g_varchar2) then

584: If (p_rec.program_update_date = hr_api.g_date) then
585: p_rec.program_update_date :=
586: pay_pgr_shd.g_old_rec.program_update_date;
587: End If;
588: If (p_rec.currency_code = hr_api.g_varchar2) then
589: p_rec.currency_code :=
590: pay_pgr_shd.g_old_rec.currency_code;
591: End If;
592: --

Line 687: ,p_maximum in varchar2 default hr_api.g_varchar2

683: (p_effective_date in date
684: ,p_datetrack_mode in varchar2
685: ,p_grade_rule_id in number
686: ,p_object_version_number in out nocopy number
687: ,p_maximum in varchar2 default hr_api.g_varchar2
688: ,p_mid_value in varchar2 default hr_api.g_varchar2
689: ,p_minimum in varchar2 default hr_api.g_varchar2
690: ,p_sequence in number default hr_api.g_number
691: ,p_value in varchar2 default hr_api.g_varchar2

Line 688: ,p_mid_value in varchar2 default hr_api.g_varchar2

684: ,p_datetrack_mode in varchar2
685: ,p_grade_rule_id in number
686: ,p_object_version_number in out nocopy number
687: ,p_maximum in varchar2 default hr_api.g_varchar2
688: ,p_mid_value in varchar2 default hr_api.g_varchar2
689: ,p_minimum in varchar2 default hr_api.g_varchar2
690: ,p_sequence in number default hr_api.g_number
691: ,p_value in varchar2 default hr_api.g_varchar2
692: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 689: ,p_minimum in varchar2 default hr_api.g_varchar2

685: ,p_grade_rule_id in number
686: ,p_object_version_number in out nocopy number
687: ,p_maximum in varchar2 default hr_api.g_varchar2
688: ,p_mid_value in varchar2 default hr_api.g_varchar2
689: ,p_minimum in varchar2 default hr_api.g_varchar2
690: ,p_sequence in number default hr_api.g_number
691: ,p_value in varchar2 default hr_api.g_varchar2
692: ,p_currency_code in varchar2 default hr_api.g_varchar2
693: ,p_effective_start_date out nocopy date

Line 690: ,p_sequence in number default hr_api.g_number

686: ,p_object_version_number in out nocopy number
687: ,p_maximum in varchar2 default hr_api.g_varchar2
688: ,p_mid_value in varchar2 default hr_api.g_varchar2
689: ,p_minimum in varchar2 default hr_api.g_varchar2
690: ,p_sequence in number default hr_api.g_number
691: ,p_value in varchar2 default hr_api.g_varchar2
692: ,p_currency_code in varchar2 default hr_api.g_varchar2
693: ,p_effective_start_date out nocopy date
694: ,p_effective_end_date out nocopy date

Line 691: ,p_value in varchar2 default hr_api.g_varchar2

687: ,p_maximum in varchar2 default hr_api.g_varchar2
688: ,p_mid_value in varchar2 default hr_api.g_varchar2
689: ,p_minimum in varchar2 default hr_api.g_varchar2
690: ,p_sequence in number default hr_api.g_number
691: ,p_value in varchar2 default hr_api.g_varchar2
692: ,p_currency_code in varchar2 default hr_api.g_varchar2
693: ,p_effective_start_date out nocopy date
694: ,p_effective_end_date out nocopy date
695: ) is

Line 692: ,p_currency_code in varchar2 default hr_api.g_varchar2

688: ,p_mid_value in varchar2 default hr_api.g_varchar2
689: ,p_minimum in varchar2 default hr_api.g_varchar2
690: ,p_sequence in number default hr_api.g_number
691: ,p_value in varchar2 default hr_api.g_varchar2
692: ,p_currency_code in varchar2 default hr_api.g_varchar2
693: ,p_effective_start_date out nocopy date
694: ,p_effective_end_date out nocopy date
695: ) is
696: --

Line 711: ,hr_api.g_number --p_business_group_id

707: pay_pgr_shd.convert_args
708: (p_grade_rule_id
709: ,NULL
710: ,NULL
711: ,hr_api.g_number --p_business_group_id
712: ,hr_api.g_number --p_rate_id
713: ,hr_api.g_number --p_grade_or_spinal_point_id
714: ,hr_api.g_varchar2 --p_rate_type
715: ,p_maximum

Line 712: ,hr_api.g_number --p_rate_id

708: (p_grade_rule_id
709: ,NULL
710: ,NULL
711: ,hr_api.g_number --p_business_group_id
712: ,hr_api.g_number --p_rate_id
713: ,hr_api.g_number --p_grade_or_spinal_point_id
714: ,hr_api.g_varchar2 --p_rate_type
715: ,p_maximum
716: ,p_mid_value

Line 713: ,hr_api.g_number --p_grade_or_spinal_point_id

709: ,NULL
710: ,NULL
711: ,hr_api.g_number --p_business_group_id
712: ,hr_api.g_number --p_rate_id
713: ,hr_api.g_number --p_grade_or_spinal_point_id
714: ,hr_api.g_varchar2 --p_rate_type
715: ,p_maximum
716: ,p_mid_value
717: ,p_minimum

Line 714: ,hr_api.g_varchar2 --p_rate_type

710: ,NULL
711: ,hr_api.g_number --p_business_group_id
712: ,hr_api.g_number --p_rate_id
713: ,hr_api.g_number --p_grade_or_spinal_point_id
714: ,hr_api.g_varchar2 --p_rate_type
715: ,p_maximum
716: ,p_mid_value
717: ,p_minimum
718: ,p_sequence