The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_concat_segs
(p_cagr_grade_def_id IN per_cagr_grades_def.cagr_grade_def_id%TYPE
,p_concatenated_segments IN per_cagr_grades_def.concatenated_segments%TYPE) is
--
l_proc VARCHAR2(72) := g_package||'update_concat_segs';
SELECT concatenated_segments
FROM per_cagr_grades_def
WHERE cagr_grade_def_id = p_cagr_grade_def_id;
procedure update_concat_segs_auto
(p_cagr_grade_def_id in number) is
PRAGMA AUTONOMOUS_TRANSACTION;
SELECT null
FROM per_cagr_grades_def
where cagr_grade_def_id = p_cagr_grade_def_id
for update nowait;
l_proc varchar2(72) := g_package||'update_concat_segs_auto';
UPDATE per_cagr_grades_def
SET concatenated_segments = p_concatenated_segments
WHERE cagr_grade_def_id = p_cagr_grade_def_id;
end update_concat_segs_auto;
update_concat_segs_auto(p_cagr_grade_def_id);
end update_concat_segs;
select pcg.id_flex_num
from per_cagr_grade_structures pcg
where pcg.cagr_grade_structure_id = p_cagr_grade_structure_id;
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20
from per_cagr_grades_def
where cagr_grade_def_id = l_cagr_grade_def_id;
update_concat_segs
(p_cagr_grade_def_id => l_cagr_grade_def_id
,p_concatenated_segments => l_name);
procedure update_cagr_grades
(p_validate in boolean default false
,p_cagr_grade_id in number
,p_sequence in number default hr_api.g_number
,p_segment1 in varchar2 default hr_api.g_varchar2
,p_segment2 in varchar2 default hr_api.g_varchar2
,p_segment3 in varchar2 default hr_api.g_varchar2
,p_segment4 in varchar2 default hr_api.g_varchar2
,p_segment5 in varchar2 default hr_api.g_varchar2
,p_segment6 in varchar2 default hr_api.g_varchar2
,p_segment7 in varchar2 default hr_api.g_varchar2
,p_segment8 in varchar2 default hr_api.g_varchar2
,p_segment9 in varchar2 default hr_api.g_varchar2
,p_segment10 in varchar2 default hr_api.g_varchar2
,p_segment11 in varchar2 default hr_api.g_varchar2
,p_segment12 in varchar2 default hr_api.g_varchar2
,p_segment13 in varchar2 default hr_api.g_varchar2
,p_segment14 in varchar2 default hr_api.g_varchar2
,p_segment15 in varchar2 default hr_api.g_varchar2
,p_segment16 in varchar2 default hr_api.g_varchar2
,p_segment17 in varchar2 default hr_api.g_varchar2
,p_segment18 in varchar2 default hr_api.g_varchar2
,p_segment19 in varchar2 default hr_api.g_varchar2
,p_segment20 in varchar2 default hr_api.g_varchar2
,p_concat_segments in varchar2 default hr_api.g_varchar2
,p_object_version_number in out nocopy number
,p_effective_date in date
,p_name out nocopy varchar2
,p_cagr_grade_def_id in out nocopy number) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_cagr_grades';
select pcs.id_flex_num
from per_cagr_grade_structures pcs
where pcs.cagr_grade_structure_id in
(select pcg.cagr_grade_structure_id
from per_cagr_grades pcg
where pcg.cagr_grade_id = p_cagr_grade_id);
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20
from per_cagr_grades_def
where cagr_grade_def_id = l_cagr_grade_def_id;
savepoint update_cagr_grades;
hr_cagr_grades_bk2.update_cagr_grades_b
(p_cagr_grade_id => p_cagr_grade_id
,p_sequence => p_sequence
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_concat_segments => p_concat_segments
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date));
(p_module_name => 'UPDATE_CAGR_GRADES'
,p_hook_type => 'BP'
);
update_concat_segs
(p_cagr_grade_def_id => l_cagr_grade_def_id
,p_concatenated_segments => l_name);
hr_cagr_grades_bk2.update_cagr_grades_a
(p_cagr_grade_id => p_cagr_grade_id
,p_sequence => p_sequence
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_concat_segments => p_concat_segments
,p_effective_date => trunc(p_effective_date)
,p_name => l_name
,p_cagr_grade_def_id => l_cagr_grade_def_id
,p_object_version_number => l_object_version_number);
(p_module_name => 'UPDATE_CAGR_GRADES'
,p_hook_type => 'AP');
ROLLBACK TO update_cagr_grades;
ROLLBACK TO update_cagr_grades;
end update_cagr_grades;
procedure delete_cagr_grades
(p_validate in boolean default false
,p_cagr_grade_id in number
,p_object_version_number in out nocopy number
,p_effective_date in date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_cagr_grades';
savepoint delete_cagr_grades;
hr_cagr_grades_bk3.delete_cagr_grades_b
(
p_cagr_grade_id => p_cagr_grade_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_CAGR_GRADES'
,p_hook_type => 'BP'
);
hr_cagr_grades_bk3.delete_cagr_grades_a
(
p_cagr_grade_id => p_cagr_grade_id
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_CAGR_GRADES'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_cagr_grades;
ROLLBACK TO delete_cagr_grades;
end delete_cagr_grades;