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_GRR_UPD dependencies on HR_API

Line 116: When hr_api.check_integrity_violated Then

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

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

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

Line 121: When hr_api.unique_integrity_violated Then

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

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

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

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

432: -- p_rec plsql record structure
433: -- to see if a system default is being used. If a system default
434: -- is being used then we must set to the 'current' argument value.
435: --
436: If (p_rec.business_group_id = hr_api.g_number) then
437: p_rec.business_group_id :=
438: pay_grr_shd.g_old_rec.business_group_id;
439: End If;
440: If (p_rec.rate_id = hr_api.g_number) then

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

436: If (p_rec.business_group_id = hr_api.g_number) then
437: p_rec.business_group_id :=
438: pay_grr_shd.g_old_rec.business_group_id;
439: End If;
440: If (p_rec.rate_id = hr_api.g_number) then
441: p_rec.rate_id :=
442: pay_grr_shd.g_old_rec.rate_id;
443: End If;
444: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then

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

440: If (p_rec.rate_id = hr_api.g_number) then
441: p_rec.rate_id :=
442: pay_grr_shd.g_old_rec.rate_id;
443: End If;
444: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then
445: p_rec.grade_or_spinal_point_id :=
446: pay_grr_shd.g_old_rec.grade_or_spinal_point_id;
447: End If;
448: If (p_rec.rate_type = hr_api.g_varchar2) then

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

444: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then
445: p_rec.grade_or_spinal_point_id :=
446: pay_grr_shd.g_old_rec.grade_or_spinal_point_id;
447: End If;
448: If (p_rec.rate_type = hr_api.g_varchar2) then
449: p_rec.rate_type :=
450: pay_grr_shd.g_old_rec.rate_type;
451: End If;
452: If (p_rec.maximum = hr_api.g_varchar2) then

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

448: If (p_rec.rate_type = hr_api.g_varchar2) then
449: p_rec.rate_type :=
450: pay_grr_shd.g_old_rec.rate_type;
451: End If;
452: If (p_rec.maximum = hr_api.g_varchar2) then
453: p_rec.maximum :=
454: pay_grr_shd.g_old_rec.maximum;
455: End If;
456: If (p_rec.mid_value = hr_api.g_varchar2) then

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

452: If (p_rec.maximum = hr_api.g_varchar2) then
453: p_rec.maximum :=
454: pay_grr_shd.g_old_rec.maximum;
455: End If;
456: If (p_rec.mid_value = hr_api.g_varchar2) then
457: p_rec.mid_value :=
458: pay_grr_shd.g_old_rec.mid_value;
459: End If;
460: If (p_rec.minimum = hr_api.g_varchar2) then

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

456: If (p_rec.mid_value = hr_api.g_varchar2) then
457: p_rec.mid_value :=
458: pay_grr_shd.g_old_rec.mid_value;
459: End If;
460: If (p_rec.minimum = hr_api.g_varchar2) then
461: p_rec.minimum :=
462: pay_grr_shd.g_old_rec.minimum;
463: End If;
464: If (p_rec.sequence = hr_api.g_number) then

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

460: If (p_rec.minimum = hr_api.g_varchar2) then
461: p_rec.minimum :=
462: pay_grr_shd.g_old_rec.minimum;
463: End If;
464: If (p_rec.sequence = hr_api.g_number) then
465: p_rec.sequence :=
466: pay_grr_shd.g_old_rec.sequence;
467: End If;
468: If (p_rec.value = hr_api.g_varchar2) then

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

464: If (p_rec.sequence = hr_api.g_number) then
465: p_rec.sequence :=
466: pay_grr_shd.g_old_rec.sequence;
467: End If;
468: If (p_rec.value = hr_api.g_varchar2) then
469: p_rec.value :=
470: pay_grr_shd.g_old_rec.value;
471: End If;
472: If (p_rec.request_id = hr_api.g_number) then

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

468: If (p_rec.value = hr_api.g_varchar2) then
469: p_rec.value :=
470: pay_grr_shd.g_old_rec.value;
471: End If;
472: If (p_rec.request_id = hr_api.g_number) then
473: p_rec.request_id :=
474: pay_grr_shd.g_old_rec.request_id;
475: End If;
476: If (p_rec.program_application_id = hr_api.g_number) then

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

472: If (p_rec.request_id = hr_api.g_number) then
473: p_rec.request_id :=
474: pay_grr_shd.g_old_rec.request_id;
475: End If;
476: If (p_rec.program_application_id = hr_api.g_number) then
477: p_rec.program_application_id :=
478: pay_grr_shd.g_old_rec.program_application_id;
479: End If;
480: If (p_rec.program_id = hr_api.g_number) then

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

476: If (p_rec.program_application_id = hr_api.g_number) then
477: p_rec.program_application_id :=
478: pay_grr_shd.g_old_rec.program_application_id;
479: End If;
480: If (p_rec.program_id = hr_api.g_number) then
481: p_rec.program_id :=
482: pay_grr_shd.g_old_rec.program_id;
483: End If;
484: If (p_rec.program_update_date = hr_api.g_date) then

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

480: If (p_rec.program_id = hr_api.g_number) then
481: p_rec.program_id :=
482: pay_grr_shd.g_old_rec.program_id;
483: End If;
484: If (p_rec.program_update_date = hr_api.g_date) then
485: p_rec.program_update_date :=
486: pay_grr_shd.g_old_rec.program_update_date;
487: End If;
488: If (p_rec.currency_code = hr_api.g_varchar2) then

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

484: If (p_rec.program_update_date = hr_api.g_date) then
485: p_rec.program_update_date :=
486: pay_grr_shd.g_old_rec.program_update_date;
487: End If;
488: If (p_rec.currency_code = hr_api.g_varchar2) then
489: p_rec.currency_code :=
490: pay_grr_shd.g_old_rec.currency_code;
491: End If;
492: --

Line 583: Raise HR_Api.Validate_Enabled;

579: --
580: -- If we are validating then raise the Validate_Enabled exception
581: --
582: If p_validate then
583: Raise HR_Api.Validate_Enabled;
584: End If;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 10);
587: Exception

Line 588: When HR_Api.Validate_Enabled Then

584: End If;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 10);
587: Exception
588: When HR_Api.Validate_Enabled Then
589: --
590: -- As the Validate_Enabled exception has been raised
591: -- we must rollback to the savepoint
592: --

Line 604: p_maximum in varchar2 default hr_api.g_varchar2,

600: (
601: p_grade_rule_id in number,
602: p_effective_start_date out nocopy date,
603: p_effective_end_date out nocopy date,
604: p_maximum in varchar2 default hr_api.g_varchar2,
605: p_mid_value in varchar2 default hr_api.g_varchar2,
606: p_minimum in varchar2 default hr_api.g_varchar2,
607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,

Line 605: p_mid_value in varchar2 default hr_api.g_varchar2,

601: p_grade_rule_id in number,
602: p_effective_start_date out nocopy date,
603: p_effective_end_date out nocopy date,
604: p_maximum in varchar2 default hr_api.g_varchar2,
605: p_mid_value in varchar2 default hr_api.g_varchar2,
606: p_minimum in varchar2 default hr_api.g_varchar2,
607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,
609: p_program_application_id in number default hr_api.g_number,

Line 606: p_minimum in varchar2 default hr_api.g_varchar2,

602: p_effective_start_date out nocopy date,
603: p_effective_end_date out nocopy date,
604: p_maximum in varchar2 default hr_api.g_varchar2,
605: p_mid_value in varchar2 default hr_api.g_varchar2,
606: p_minimum in varchar2 default hr_api.g_varchar2,
607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,
609: p_program_application_id in number default hr_api.g_number,
610: p_program_id in number default hr_api.g_number,

Line 607: p_value in varchar2 default hr_api.g_varchar2,

603: p_effective_end_date out nocopy date,
604: p_maximum in varchar2 default hr_api.g_varchar2,
605: p_mid_value in varchar2 default hr_api.g_varchar2,
606: p_minimum in varchar2 default hr_api.g_varchar2,
607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,
609: p_program_application_id in number default hr_api.g_number,
610: p_program_id in number default hr_api.g_number,
611: p_program_update_date in date default hr_api.g_date,

Line 608: p_request_id in number default hr_api.g_number,

604: p_maximum in varchar2 default hr_api.g_varchar2,
605: p_mid_value in varchar2 default hr_api.g_varchar2,
606: p_minimum in varchar2 default hr_api.g_varchar2,
607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,
609: p_program_application_id in number default hr_api.g_number,
610: p_program_id in number default hr_api.g_number,
611: p_program_update_date in date default hr_api.g_date,
612: p_object_version_number in out nocopy number,

Line 609: p_program_application_id in number default hr_api.g_number,

605: p_mid_value in varchar2 default hr_api.g_varchar2,
606: p_minimum in varchar2 default hr_api.g_varchar2,
607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,
609: p_program_application_id in number default hr_api.g_number,
610: p_program_id in number default hr_api.g_number,
611: p_program_update_date in date default hr_api.g_date,
612: p_object_version_number in out nocopy number,
613: p_effective_date in date,

Line 610: p_program_id in number default hr_api.g_number,

606: p_minimum in varchar2 default hr_api.g_varchar2,
607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,
609: p_program_application_id in number default hr_api.g_number,
610: p_program_id in number default hr_api.g_number,
611: p_program_update_date in date default hr_api.g_date,
612: p_object_version_number in out nocopy number,
613: p_effective_date in date,
614: p_datetrack_mode in varchar2,

Line 611: p_program_update_date in date default hr_api.g_date,

607: p_value in varchar2 default hr_api.g_varchar2,
608: p_request_id in number default hr_api.g_number,
609: p_program_application_id in number default hr_api.g_number,
610: p_program_id in number default hr_api.g_number,
611: p_program_update_date in date default hr_api.g_date,
612: p_object_version_number in out nocopy number,
613: p_effective_date in date,
614: p_datetrack_mode in varchar2,
615: p_validate in boolean default false,

Line 616: p_currency_code in varchar2 default hr_api.g_varchar2

612: p_object_version_number in out nocopy number,
613: p_effective_date in date,
614: p_datetrack_mode in varchar2,
615: p_validate in boolean default false,
616: p_currency_code in varchar2 default hr_api.g_varchar2
617: ) is
618: --
619: l_rec pay_grr_shd.g_rec_type;
620: l_proc varchar2(72) := g_package||'upd';

Line 634: hr_api.g_number,

630: (
631: p_grade_rule_id,
632: null,
633: null,
634: hr_api.g_number,
635: hr_api.g_number,
636: hr_api.g_number,
637: hr_api.g_varchar2,
638: p_maximum,

Line 635: hr_api.g_number,

631: p_grade_rule_id,
632: null,
633: null,
634: hr_api.g_number,
635: hr_api.g_number,
636: hr_api.g_number,
637: hr_api.g_varchar2,
638: p_maximum,
639: p_mid_value,

Line 636: hr_api.g_number,

632: null,
633: null,
634: hr_api.g_number,
635: hr_api.g_number,
636: hr_api.g_number,
637: hr_api.g_varchar2,
638: p_maximum,
639: p_mid_value,
640: p_minimum,

Line 637: hr_api.g_varchar2,

633: null,
634: hr_api.g_number,
635: hr_api.g_number,
636: hr_api.g_number,
637: hr_api.g_varchar2,
638: p_maximum,
639: p_mid_value,
640: p_minimum,
641: hr_api.g_number,

Line 641: hr_api.g_number,

637: hr_api.g_varchar2,
638: p_maximum,
639: p_mid_value,
640: p_minimum,
641: hr_api.g_number,
642: p_value,
643: p_request_id,
644: p_program_application_id,
645: p_program_id,