The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_security_user
(p_validate in boolean default false
,p_effective_date in date
,p_security_user_id in number
,p_user_id in number default hr_api.g_number
,p_security_profile_id in number default hr_api.g_number
,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
,p_object_version_number in out nocopy number
,p_del_static_lists_warning out nocopy boolean
) IS
l_proc varchar2(72) := g_package||'update_security_user';
SAVEPOINT update_security_user;
hr_security_user_bk2.update_security_user_b
(p_effective_date => p_effective_date
,p_security_user_id => p_security_user_id
,p_user_id => p_user_id
,p_security_profile_id => p_security_profile_id
,p_process_in_next_run_flag => p_process_in_next_run_flag
,p_object_version_number => l_object_version_number);
(p_module_name => 'update_security_user'
,p_hook_type => 'BP'
);
hr_security_user_bk2.update_security_user_a
(p_effective_date => p_effective_date
,p_security_user_id => p_security_user_id
,p_user_id => p_user_id
,p_security_profile_id => p_security_profile_id
,p_process_in_next_run_flag => p_process_in_next_run_flag
,p_object_version_number => l_object_version_number
,p_del_static_lists_warning => l_del_static_lists_warning);
(p_module_name => 'update_security_user'
,p_hook_type => 'AP'
);
ROLLBACK to update_security_user;
ROLLBACK to update_security_user;
END update_security_user;
PROCEDURE delete_security_user
(p_validate in boolean default false
,p_security_user_id in number
,p_object_version_number in number
,p_del_static_lists_warning out nocopy boolean
) IS
l_proc varchar2(72) := g_package||'delete_security_user';
SAVEPOINT delete_security_user;
hr_security_user_bk3.delete_security_user_b
(p_security_user_id => p_security_user_id
,p_object_version_number => p_object_version_number);
(p_module_name => 'delete_security_user'
,p_hook_type => 'BP'
);
hr_security_user_bk3.delete_security_user_a
(p_security_user_id => p_security_user_id
,p_object_version_number => p_object_version_number
,p_del_static_lists_warning => l_del_static_lists_warning);
(p_module_name => 'delete_security_user'
,p_hook_type => 'AP'
);
ROLLBACK to delete_security_user;
ROLLBACK to delete_security_user;
END delete_security_user;