The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_skill_provision
(
p_skill_provision_id in number,
p_activity_version_id in number default hr_api.g_number,
p_object_version_number in out nocopy number,
p_type in varchar2 default hr_api.g_varchar2,
p_comments in varchar2 default hr_api.g_varchar2,
p_tsp_information_category in varchar2 default hr_api.g_varchar2,
p_tsp_information1 in varchar2 default hr_api.g_varchar2,
p_tsp_information2 in varchar2 default hr_api.g_varchar2,
p_tsp_information3 in varchar2 default hr_api.g_varchar2,
p_tsp_information4 in varchar2 default hr_api.g_varchar2,
p_tsp_information5 in varchar2 default hr_api.g_varchar2,
p_tsp_information6 in varchar2 default hr_api.g_varchar2,
p_tsp_information7 in varchar2 default hr_api.g_varchar2,
p_tsp_information8 in varchar2 default hr_api.g_varchar2,
p_tsp_information9 in varchar2 default hr_api.g_varchar2,
p_tsp_information10 in varchar2 default hr_api.g_varchar2,
p_tsp_information11 in varchar2 default hr_api.g_varchar2,
p_tsp_information12 in varchar2 default hr_api.g_varchar2,
p_tsp_information13 in varchar2 default hr_api.g_varchar2,
p_tsp_information14 in varchar2 default hr_api.g_varchar2,
p_tsp_information15 in varchar2 default hr_api.g_varchar2,
p_tsp_information16 in varchar2 default hr_api.g_varchar2,
p_tsp_information17 in varchar2 default hr_api.g_varchar2,
p_tsp_information18 in varchar2 default hr_api.g_varchar2,
p_tsp_information19 in varchar2 default hr_api.g_varchar2,
p_tsp_information20 in varchar2 default hr_api.g_varchar2,
p_analysis_criteria_id in number default hr_api.g_number,
p_validate in boolean default false
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||' Update Skill Provision';
savepoint UPDATE_SKILL_PROVISION;
ota_skill_provision_bk2.update_skill_provision_a
(p_skill_provision_id => p_skill_provision_id ,
p_activity_version_id => p_activity_version_id ,
p_object_version_number => p_object_version_number ,
p_type => p_type ,
p_comments => p_comments ,
p_tsp_information_category => p_tsp_information_category ,
p_tsp_information1 => p_tsp_information1 ,
p_tsp_information2 => p_tsp_information2 ,
p_tsp_information3 => p_tsp_information3 ,
p_tsp_information4 => p_tsp_information4 ,
p_tsp_information5 => p_tsp_information5 ,
p_tsp_information6 => p_tsp_information6 ,
p_tsp_information7 => p_tsp_information7 ,
p_tsp_information8 => p_tsp_information8 ,
p_tsp_information9 => p_tsp_information9 ,
p_tsp_information10 => p_tsp_information10 ,
p_tsp_information11 => p_tsp_information11 ,
p_tsp_information12 => p_tsp_information12 ,
p_tsp_information13 => p_tsp_information13 ,
p_tsp_information14 => p_tsp_information14 ,
p_tsp_information15 => p_tsp_information15 ,
p_tsp_information16 => p_tsp_information16 ,
p_tsp_information17 => p_tsp_information17 ,
p_tsp_information18 => p_tsp_information18 ,
p_tsp_information19 => p_tsp_information19 ,
p_tsp_information20 => p_tsp_information20 ,
p_analysis_criteria_id => p_analysis_criteria_id );
(p_module_name => 'UPDATE_SKILL_PROVISION'
,p_hook_type => 'BP'
);
ota_skill_provision_bk2.update_skill_provision_a
(p_skill_provision_id => p_skill_provision_id ,
p_activity_version_id => p_activity_version_id ,
p_object_version_number => l_object_version_number ,
p_type => p_type ,
p_comments => p_comments ,
p_tsp_information_category => p_tsp_information_category ,
p_tsp_information1 => p_tsp_information1 ,
p_tsp_information2 => p_tsp_information2 ,
p_tsp_information3 => p_tsp_information3 ,
p_tsp_information4 => p_tsp_information4 ,
p_tsp_information5 => p_tsp_information5 ,
p_tsp_information6 => p_tsp_information6 ,
p_tsp_information7 => p_tsp_information7 ,
p_tsp_information8 => p_tsp_information8 ,
p_tsp_information9 => p_tsp_information9 ,
p_tsp_information10 => p_tsp_information10 ,
p_tsp_information11 => p_tsp_information11 ,
p_tsp_information12 => p_tsp_information12 ,
p_tsp_information13 => p_tsp_information13 ,
p_tsp_information14 => p_tsp_information14 ,
p_tsp_information15 => p_tsp_information15 ,
p_tsp_information16 => p_tsp_information16 ,
p_tsp_information17 => p_tsp_information17 ,
p_tsp_information18 => p_tsp_information18 ,
p_tsp_information19 => p_tsp_information19 ,
p_tsp_information20 => p_tsp_information20 ,
p_analysis_criteria_id => p_analysis_criteria_id );
(p_module_name => 'UPDATE_SKILL_PROVISION'
,p_hook_type => 'AP'
);
rollback to UPDATE_SKILL_PROVISION;
rollback to UPDATE_SKILL_PROVISION;
end update_skill_provision;
procedure delete_skill_provision
(
p_skill_provision_id in number,
p_object_version_number in number,
p_validate in boolean
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||' Delete Skill Provision';
savepoint DELETE_SKILL_PROVISION;
ota_skill_provision_bk3.delete_skill_provision_b
(p_skill_provision_id => p_skill_provision_id ,
p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_SKILL_PROVISION'
,p_hook_type => 'BP'
);
ota_skill_provision_bk3.delete_skill_provision_b
(p_skill_provision_id => p_skill_provision_id ,
p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_SKILL_PROVISION'
,p_hook_type => 'AP'
);
rollback to DELETE_SKILL_PROVISION;
rollback to DELETE_SKILL_PROVISION;
end delete_skill_provision;