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: --
117: ame_apt_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: --
117: ame_apt_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: --
122: ame_apt_shd.constraint_error
115: -- A check constraint has been violated
116: --
117: ame_apt_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: --
122: ame_apt_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: --
122: ame_apt_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
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: ame_apt_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: --
420: );
421: --
422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'ame_approver_types'
428: ,p_hook_type => 'AU');
422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'ame_approver_types'
428: ,p_hook_type => 'AU');
429: --
430: end;
485: -- p_rec plsql record structure
486: -- to see if a system default is being used. If a system default
487: -- is being used then we must set to the 'current' argument value.
488: --
489: If (p_rec.orig_system = hr_api.g_varchar2) then
490: p_rec.orig_system :=
491: ame_apt_shd.g_old_rec.orig_system;
492: End If;
493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then
489: If (p_rec.orig_system = hr_api.g_varchar2) then
490: p_rec.orig_system :=
491: ame_apt_shd.g_old_rec.orig_system;
492: End If;
493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then
494: p_rec.query_variable_1_label :=
495: ame_apt_shd.g_old_rec.query_variable_1_label;
496: End If;
497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then
493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then
494: p_rec.query_variable_1_label :=
495: ame_apt_shd.g_old_rec.query_variable_1_label;
496: End If;
497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then
498: p_rec.query_variable_2_label :=
499: ame_apt_shd.g_old_rec.query_variable_2_label;
500: End If;
501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then
497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then
498: p_rec.query_variable_2_label :=
499: ame_apt_shd.g_old_rec.query_variable_2_label;
500: End If;
501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then
502: p_rec.query_variable_3_label :=
503: ame_apt_shd.g_old_rec.query_variable_3_label;
504: End If;
505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then
501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then
502: p_rec.query_variable_3_label :=
503: ame_apt_shd.g_old_rec.query_variable_3_label;
504: End If;
505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then
506: p_rec.query_variable_4_label :=
507: ame_apt_shd.g_old_rec.query_variable_4_label;
508: End If;
509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then
505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then
506: p_rec.query_variable_4_label :=
507: ame_apt_shd.g_old_rec.query_variable_4_label;
508: End If;
509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then
510: p_rec.query_variable_5_label :=
511: ame_apt_shd.g_old_rec.query_variable_5_label;
512: End If;
513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then
509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then
510: p_rec.query_variable_5_label :=
511: ame_apt_shd.g_old_rec.query_variable_5_label;
512: End If;
513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then
514: p_rec.variable_1_lov_query :=
515: ame_apt_shd.g_old_rec.variable_1_lov_query;
516: End If;
517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then
513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then
514: p_rec.variable_1_lov_query :=
515: ame_apt_shd.g_old_rec.variable_1_lov_query;
516: End If;
517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then
518: p_rec.variable_2_lov_query :=
519: ame_apt_shd.g_old_rec.variable_2_lov_query;
520: End If;
521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then
517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then
518: p_rec.variable_2_lov_query :=
519: ame_apt_shd.g_old_rec.variable_2_lov_query;
520: End If;
521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then
522: p_rec.variable_3_lov_query :=
523: ame_apt_shd.g_old_rec.variable_3_lov_query;
524: End If;
525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then
521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then
522: p_rec.variable_3_lov_query :=
523: ame_apt_shd.g_old_rec.variable_3_lov_query;
524: End If;
525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then
526: p_rec.variable_4_lov_query :=
527: ame_apt_shd.g_old_rec.variable_4_lov_query;
528: End If;
529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then
525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then
526: p_rec.variable_4_lov_query :=
527: ame_apt_shd.g_old_rec.variable_4_lov_query;
528: End If;
529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then
530: p_rec.variable_5_lov_query :=
531: ame_apt_shd.g_old_rec.variable_5_lov_query;
532: End If;
533: If (p_rec.query_procedure = hr_api.g_varchar2) then
529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then
530: p_rec.variable_5_lov_query :=
531: ame_apt_shd.g_old_rec.variable_5_lov_query;
532: End If;
533: If (p_rec.query_procedure = hr_api.g_varchar2) then
534: p_rec.query_procedure :=
535: ame_apt_shd.g_old_rec.query_procedure;
536: End If;
537: --
631: ,p_approver_type_id in number
632: ,p_start_date in date
633: ,p_end_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
632: ,p_start_date in date
633: ,p_end_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
633: ,p_end_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
648: --
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
648: --
649: l_rec ame_apt_shd.g_rec_type;
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
648: --
649: l_rec ame_apt_shd.g_rec_type;
650: l_proc varchar2(72) := g_package||'upd';