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.PQH_RMR_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 113: When hr_api.check_integrity_violated Then

109: End If;
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 15);
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: pqh_rmr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: pqh_rmr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: pqh_rmr_shd.constraint_error

Line 118: When hr_api.unique_integrity_violated Then

114: -- A check constraint has been violated
115: --
116: pqh_rmr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: pqh_rmr_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.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: pqh_rmr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: --
125: Raise;
126: End dt_update_dml;

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

235: l_dummy_version_number number;
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: If (p_datetrack_mode <> hr_api.g_correction) then
240: --
241: -- Update the current effective end date
242: --
243: pqh_rmr_shd.upd_effective_end_date

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

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

Line 442: when hr_api.cannot_find_prog_unit then

438: );
439: --
440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'PQH_RATE_MATRIX_RATES_F'
446: ,p_hook_type => 'AU');

Line 444: hr_api.cannot_find_prog_unit_error

440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'PQH_RATE_MATRIX_RATES_F'
446: ,p_hook_type => 'AU');
447: --
448: end;

Line 507: If (p_rec.rate_matrix_node_id = hr_api.g_number) then

503: -- p_rec plsql record structure
504: -- to see if a system default is being used. If a system default
505: -- is being used then we must set to the 'current' argument value.
506: --
507: If (p_rec.rate_matrix_node_id = hr_api.g_number) then
508: p_rec.rate_matrix_node_id :=
509: pqh_rmr_shd.g_old_rec.rate_matrix_node_id;
510: End If;
511: If (p_rec.criteria_rate_defn_id = hr_api.g_number) then

Line 511: If (p_rec.criteria_rate_defn_id = hr_api.g_number) then

507: If (p_rec.rate_matrix_node_id = hr_api.g_number) then
508: p_rec.rate_matrix_node_id :=
509: pqh_rmr_shd.g_old_rec.rate_matrix_node_id;
510: End If;
511: If (p_rec.criteria_rate_defn_id = hr_api.g_number) then
512: p_rec.criteria_rate_defn_id :=
513: pqh_rmr_shd.g_old_rec.criteria_rate_defn_id;
514: End If;
515: If (p_rec.min_rate_value = hr_api.g_number) then

Line 515: If (p_rec.min_rate_value = hr_api.g_number) then

511: If (p_rec.criteria_rate_defn_id = hr_api.g_number) then
512: p_rec.criteria_rate_defn_id :=
513: pqh_rmr_shd.g_old_rec.criteria_rate_defn_id;
514: End If;
515: If (p_rec.min_rate_value = hr_api.g_number) then
516: p_rec.min_rate_value :=
517: pqh_rmr_shd.g_old_rec.min_rate_value;
518: End If;
519: If (p_rec.max_rate_value = hr_api.g_number) then

Line 519: If (p_rec.max_rate_value = hr_api.g_number) then

515: If (p_rec.min_rate_value = hr_api.g_number) then
516: p_rec.min_rate_value :=
517: pqh_rmr_shd.g_old_rec.min_rate_value;
518: End If;
519: If (p_rec.max_rate_value = hr_api.g_number) then
520: p_rec.max_rate_value :=
521: pqh_rmr_shd.g_old_rec.max_rate_value;
522: End If;
523: If (p_rec.mid_rate_value = hr_api.g_number) then

Line 523: If (p_rec.mid_rate_value = hr_api.g_number) then

519: If (p_rec.max_rate_value = hr_api.g_number) then
520: p_rec.max_rate_value :=
521: pqh_rmr_shd.g_old_rec.max_rate_value;
522: End If;
523: If (p_rec.mid_rate_value = hr_api.g_number) then
524: p_rec.mid_rate_value :=
525: pqh_rmr_shd.g_old_rec.mid_rate_value;
526: End If;
527: If (p_rec.rate_value = hr_api.g_number) then

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

523: If (p_rec.mid_rate_value = hr_api.g_number) then
524: p_rec.mid_rate_value :=
525: pqh_rmr_shd.g_old_rec.mid_rate_value;
526: End If;
527: If (p_rec.rate_value = hr_api.g_number) then
528: p_rec.rate_value :=
529: pqh_rmr_shd.g_old_rec.rate_value;
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.rate_value = hr_api.g_number) then
528: p_rec.rate_value :=
529: pqh_rmr_shd.g_old_rec.rate_value;
530: End If;
531: If (p_rec.business_group_id = hr_api.g_number) then
532: p_rec.business_group_id :=
533: pqh_rmr_shd.g_old_rec.business_group_id;
534: End If;
535: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

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

Line 634: ,p_rate_matrix_node_id in number default hr_api.g_number

630: (p_effective_date in date
631: ,p_datetrack_mode in varchar2
632: ,p_rate_matrix_rate_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_rate_matrix_node_id in number default hr_api.g_number
635: ,p_criteria_rate_defn_id in number default hr_api.g_number
636: ,p_rate_value in number default hr_api.g_number
637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number

Line 635: ,p_criteria_rate_defn_id in number default hr_api.g_number

631: ,p_datetrack_mode in varchar2
632: ,p_rate_matrix_rate_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_rate_matrix_node_id in number default hr_api.g_number
635: ,p_criteria_rate_defn_id in number default hr_api.g_number
636: ,p_rate_value in number default hr_api.g_number
637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number
639: ,p_mid_rate_value in number default hr_api.g_number

Line 636: ,p_rate_value in number default hr_api.g_number

632: ,p_rate_matrix_rate_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_rate_matrix_node_id in number default hr_api.g_number
635: ,p_criteria_rate_defn_id in number default hr_api.g_number
636: ,p_rate_value in number default hr_api.g_number
637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number
639: ,p_mid_rate_value in number default hr_api.g_number
640: ,p_business_group_id in number default hr_api.g_number

Line 637: ,p_min_rate_value in number default hr_api.g_number

633: ,p_object_version_number in out nocopy number
634: ,p_rate_matrix_node_id in number default hr_api.g_number
635: ,p_criteria_rate_defn_id in number default hr_api.g_number
636: ,p_rate_value in number default hr_api.g_number
637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number
639: ,p_mid_rate_value in number default hr_api.g_number
640: ,p_business_group_id in number default hr_api.g_number
641: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 638: ,p_max_rate_value in number default hr_api.g_number

634: ,p_rate_matrix_node_id in number default hr_api.g_number
635: ,p_criteria_rate_defn_id in number default hr_api.g_number
636: ,p_rate_value in number default hr_api.g_number
637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number
639: ,p_mid_rate_value in number default hr_api.g_number
640: ,p_business_group_id in number default hr_api.g_number
641: ,p_legislation_code in varchar2 default hr_api.g_varchar2
642: ,p_effective_start_date out nocopy date

Line 639: ,p_mid_rate_value in number default hr_api.g_number

635: ,p_criteria_rate_defn_id in number default hr_api.g_number
636: ,p_rate_value in number default hr_api.g_number
637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number
639: ,p_mid_rate_value in number default hr_api.g_number
640: ,p_business_group_id in number default hr_api.g_number
641: ,p_legislation_code in varchar2 default hr_api.g_varchar2
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date

Line 640: ,p_business_group_id in number default hr_api.g_number

636: ,p_rate_value in number default hr_api.g_number
637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number
639: ,p_mid_rate_value in number default hr_api.g_number
640: ,p_business_group_id in number default hr_api.g_number
641: ,p_legislation_code in varchar2 default hr_api.g_varchar2
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is

Line 641: ,p_legislation_code in varchar2 default hr_api.g_varchar2

637: ,p_min_rate_value in number default hr_api.g_number
638: ,p_max_rate_value in number default hr_api.g_number
639: ,p_mid_rate_value in number default hr_api.g_number
640: ,p_business_group_id in number default hr_api.g_number
641: ,p_legislation_code in varchar2 default hr_api.g_varchar2
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is
645: --