The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_shared_types_tl
(p_validate in boolean default false
,p_shared_type_id in number
,p_language out nocopy varchar2
,p_source_lang in varchar2 default hr_api.g_varchar2
,p_shared_type_name in varchar2 default hr_api.g_varchar2
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_shared_types_tl';
savepoint update_shared_types_tl;
per_shared_types_tl_bk2.update_shared_types_tl_b
(
p_shared_type_id => p_shared_type_id
,p_source_lang => p_source_lang
,p_shared_type_name => p_shared_type_name
);
(p_module_name => 'UPDATE_shared_types_tl'
,p_hook_type => 'BP'
);
per_shared_types_tl_bk2.update_shared_types_tl_a
(
p_shared_type_id => p_shared_type_id
,p_language => l_language
,p_source_lang => p_source_lang
,p_shared_type_name => p_shared_type_name
);
(p_module_name => 'UPDATE_shared_types_tl'
,p_hook_type => 'AP'
);
ROLLBACK TO update_shared_types_tl;
ROLLBACK TO update_shared_types_tl;
end update_shared_types_tl;
procedure delete_shared_types_tl
(p_validate in boolean default false
,p_shared_type_id in number
,p_language out nocopy varchar2
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_shared_types_tl';
savepoint delete_shared_types_tl;
per_shared_types_tl_bk3.delete_shared_types_tl_b
(
p_shared_type_id => p_shared_type_id
);
(p_module_name => 'DELETE_shared_types_tl'
,p_hook_type => 'BP'
);
per_shared_types_tl_bk3.delete_shared_types_tl_a
(
p_shared_type_id => p_shared_type_id
,p_language => l_language
);
(p_module_name => 'DELETE_shared_types_tl'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_shared_types_tl;
ROLLBACK TO delete_shared_types_tl;
end delete_shared_types_tl;