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.
110: End If;
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 15);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
117: per_pgs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
117: per_pgs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
122: per_pgs_shd.constraint_error
115: -- A check constraint has been violated
116: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
117: per_pgs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
122: per_pgs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
122: per_pgs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;
127: End dt_update_dml;
236: l_dummy_version_number number;
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: If (p_datetrack_mode <> hr_api.g_correction) then
241: --
242: -- Update the current effective end date
243: --
244: per_pgs_shd.upd_effective_end_date
249: ,p_validation_end_date => p_validation_end_date
250: ,p_object_version_number => l_dummy_version_number
251: );
252: --
253: If (p_datetrack_mode = hr_api.g_update_override) then
254: --
255: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
256: -- delete any future rows
257: --
441: );
442: --
443: exception
444: --
445: when hr_api.cannot_find_prog_unit then
446: --
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'PER_GRADE_SPINES_F'
449: ,p_hook_type => 'AU');
443: exception
444: --
445: when hr_api.cannot_find_prog_unit then
446: --
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'PER_GRADE_SPINES_F'
449: ,p_hook_type => 'AU');
450: --
451: end;
506: -- p_rec plsql record structure
507: -- to see if a system default is being used. If a system default
508: -- is being used then we must set to the 'current' argument value.
509: --
510: If (p_rec.business_group_id = hr_api.g_number) then
511: p_rec.business_group_id :=
512: per_pgs_shd.g_old_rec.business_group_id;
513: End If;
514: If (p_rec.parent_spine_id = hr_api.g_number) then
510: If (p_rec.business_group_id = hr_api.g_number) then
511: p_rec.business_group_id :=
512: per_pgs_shd.g_old_rec.business_group_id;
513: End If;
514: If (p_rec.parent_spine_id = hr_api.g_number) then
515: p_rec.parent_spine_id :=
516: per_pgs_shd.g_old_rec.parent_spine_id;
517: End If;
518: If (p_rec.grade_id = hr_api.g_number) then
514: If (p_rec.parent_spine_id = hr_api.g_number) then
515: p_rec.parent_spine_id :=
516: per_pgs_shd.g_old_rec.parent_spine_id;
517: End If;
518: If (p_rec.grade_id = hr_api.g_number) then
519: p_rec.grade_id :=
520: per_pgs_shd.g_old_rec.grade_id;
521: End If;
522: If (p_rec.ceiling_step_id = hr_api.g_number) then
518: If (p_rec.grade_id = hr_api.g_number) then
519: p_rec.grade_id :=
520: per_pgs_shd.g_old_rec.grade_id;
521: End If;
522: If (p_rec.ceiling_step_id = hr_api.g_number) then
523: p_rec.ceiling_step_id :=
524: per_pgs_shd.g_old_rec.ceiling_step_id;
525: End If;
526: If (p_rec.starting_step = hr_api.g_number) then
522: If (p_rec.ceiling_step_id = hr_api.g_number) then
523: p_rec.ceiling_step_id :=
524: per_pgs_shd.g_old_rec.ceiling_step_id;
525: End If;
526: If (p_rec.starting_step = hr_api.g_number) then
527: p_rec.starting_step :=
528: per_pgs_shd.g_old_rec.starting_step;
529: End If;
530: If (p_rec.request_id = hr_api.g_number) then
526: If (p_rec.starting_step = hr_api.g_number) then
527: p_rec.starting_step :=
528: per_pgs_shd.g_old_rec.starting_step;
529: End If;
530: If (p_rec.request_id = hr_api.g_number) then
531: p_rec.request_id :=
532: per_pgs_shd.g_old_rec.request_id;
533: End If;
534: If (p_rec.program_application_id = hr_api.g_number) then
530: If (p_rec.request_id = hr_api.g_number) then
531: p_rec.request_id :=
532: per_pgs_shd.g_old_rec.request_id;
533: End If;
534: If (p_rec.program_application_id = hr_api.g_number) then
535: p_rec.program_application_id :=
536: per_pgs_shd.g_old_rec.program_application_id;
537: End If;
538: If (p_rec.program_id = hr_api.g_number) then
534: If (p_rec.program_application_id = hr_api.g_number) then
535: p_rec.program_application_id :=
536: per_pgs_shd.g_old_rec.program_application_id;
537: End If;
538: If (p_rec.program_id = hr_api.g_number) then
539: p_rec.program_id :=
540: per_pgs_shd.g_old_rec.program_id;
541: End If;
542: If (p_rec.program_update_date = hr_api.g_date) then
538: If (p_rec.program_id = hr_api.g_number) then
539: p_rec.program_id :=
540: per_pgs_shd.g_old_rec.program_id;
541: End If;
542: If (p_rec.program_update_date = hr_api.g_date) then
543: p_rec.program_update_date :=
544: per_pgs_shd.g_old_rec.program_update_date;
545: End If;
546: --
637: (p_effective_date in date
638: ,p_datetrack_mode in varchar2
639: ,p_grade_spine_id in number
640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
638: ,p_datetrack_mode in varchar2
639: ,p_grade_spine_id in number
640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
639: ,p_grade_spine_id in number
640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date
651: ,p_effective_end_date out nocopy date
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date
651: ,p_effective_end_date out nocopy date
652: ) is
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date
651: ,p_effective_end_date out nocopy date
652: ) is
653: --