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.
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));
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
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));
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;
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
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: --
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');
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;
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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
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: --