58: --
59: hr_utility.set_location('Leaving:'|| l_proc, 30);
60: --
61: Exception
62: When HR_Api.Object_Locked then
63: rollback; -- Added for bug 3578845.
64: hr_utility.set_location('Leaving:'|| l_proc, 40);
65: end update_concat_segs_auto;
66: --
282: ,p_concat_segments => p_concat_segments
283: ,p_effective_date => trunc(p_effective_date)
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (
289: p_module_name => 'CREATE_CAGR_GRADES'
290: ,p_hook_type => 'BP'
283: ,p_effective_date => trunc(p_effective_date)
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (
289: p_module_name => 'CREATE_CAGR_GRADES'
290: ,p_hook_type => 'BP'
291: );
404: ,p_object_version_number => l_object_version_number
405: ,p_effective_date => trunc(p_effective_date));
406: --
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'CREATE_CAGR_GRADES'
411: ,p_hook_type => 'AP'
412: );
405: ,p_effective_date => trunc(p_effective_date));
406: --
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'CREATE_CAGR_GRADES'
411: ,p_hook_type => 'AP'
412: );
413: end;
418: --
419: -- When in validation only mode raise the Validate_Enabled exception
420: --
421: if p_validate then
422: raise hr_api.validate_enabled;
423: end if;
424: --
425: -- Set all output arguments
426: --
432: hr_utility.set_location(' Leaving:'||l_proc, 70);
433: --
434: exception
435: --
436: when hr_api.validate_enabled then
437: --
438: -- As the Validate_Enabled exception has been raised
439: -- we must rollback to the savepoint
440: --
475: --
476: procedure update_cagr_grades
477: (p_validate in boolean default false
478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
476: procedure update_cagr_grades
477: (p_validate in boolean default false
478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
477: (p_validate in boolean default false
478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number
502: ,p_effective_date in date
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number
502: ,p_effective_date in date
503: ,p_name out nocopy varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number
502: ,p_effective_date in date
503: ,p_name out nocopy varchar2
504: ,p_cagr_grade_def_id in out nocopy number) is
670: ,p_effective_date => trunc(p_effective_date));
671: --
672: exception
673: --
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'UPDATE_CAGR_GRADES'
677: ,p_hook_type => 'BP'
678: );
671: --
672: exception
673: --
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'UPDATE_CAGR_GRADES'
677: ,p_hook_type => 'BP'
678: );
679: --
795: ,p_object_version_number => l_object_version_number);
796: --
797: exception
798: --
799: when hr_api.cannot_find_prog_unit then
800: --
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'UPDATE_CAGR_GRADES'
803: ,p_hook_type => 'AP');
797: exception
798: --
799: when hr_api.cannot_find_prog_unit then
800: --
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'UPDATE_CAGR_GRADES'
803: ,p_hook_type => 'AP');
804: --
805: -- End of API User Hook for the after hook of update_cagr_grades
810: --
811: -- When in validation only mode raise the Validate_Enabled exception
812: --
813: if p_validate then
814: raise hr_api.validate_enabled;
815: end if;
816: --
817: -- Set all output arguments
818: --
823: hr_utility.set_location(' Leaving:'||l_proc, 997);
824: --
825: exception
826: --
827: when hr_api.validate_enabled then
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 998);
830: --
831: -- As the Validate_Enabled exception has been raised
902: ,p_object_version_number => p_object_version_number
903: ,p_effective_date => trunc(p_effective_date)
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'DELETE_CAGR_GRADES'
909: ,p_hook_type => 'BP'
910: );
903: ,p_effective_date => trunc(p_effective_date)
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'DELETE_CAGR_GRADES'
909: ,p_hook_type => 'BP'
910: );
911: --
929: ,p_object_version_number => l_object_version_number
930: ,p_effective_date => trunc(p_effective_date)
931: );
932: exception
933: when hr_api.cannot_find_prog_unit then
934: hr_api.cannot_find_prog_unit_error
935: (p_module_name => 'DELETE_CAGR_GRADES'
936: ,p_hook_type => 'AP'
937: );
930: ,p_effective_date => trunc(p_effective_date)
931: );
932: exception
933: when hr_api.cannot_find_prog_unit then
934: hr_api.cannot_find_prog_unit_error
935: (p_module_name => 'DELETE_CAGR_GRADES'
936: ,p_hook_type => 'AP'
937: );
938: --
944: --
945: -- When in validation only mode raise the Validate_Enabled exception
946: --
947: if p_validate then
948: raise hr_api.validate_enabled;
949: end if;
950: --
951: -- Set all output arguments
952: --
955: hr_utility.set_location(' Leaving:'||l_proc, 70);
956: --
957: exception
958: --
959: when hr_api.validate_enabled then
960: --
961: -- As the Validate_Enabled exception has been raised
962: -- we must rollback to the savepoint
963: --