The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure UPDATE_CONTEXT
(p_validate in boolean default false
,p_function_id in number
,p_sequence_number in number
,p_object_version_number in out nocopy number
,p_context_id in number default hr_api.g_number
) is
--
-- Declare cursors and local variables
--
l_object_version_number ff_function_context_usages.object_version_number%type;
l_proc varchar2(72) := g_package||'UPDATE_CONTEXT';
savepoint UPDATE_CONTEXT;
FF_FUNCTION_CONTEXT_USG_BK2.UPDATE_CONTEXT_b
(p_function_id => p_function_id
,p_sequence_number => p_sequence_number
,p_object_version_number => l_object_version_number
,p_context_id => p_context_id
);
(p_module_name => 'UPDATE_CONTEXT'
,p_hook_type => 'BP'
);
FF_FUNCTION_CONTEXT_USG_BK2.UPDATE_CONTEXT_a
(p_function_id => p_function_id
,p_sequence_number => p_sequence_number
,p_object_version_number => l_object_version_number
,p_context_id => p_context_id
);
(p_module_name => 'UPDATE_CONTEXT'
,p_hook_type => 'AP'
);
rollback to UPDATE_CONTEXT;
rollback to UPDATE_CONTEXT;
end UPDATE_CONTEXT;
procedure DELETE_CONTEXT
(p_validate in boolean default false
,p_function_id in number
,p_sequence_number in number
,p_object_version_number in number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'DELETE_CONTEXT';
savepoint DELETE_CONTEXT;
FF_FUNCTION_CONTEXT_USG_BK3.DELETE_CONTEXT_b
(p_function_id => p_function_id
,p_sequence_number => p_sequence_number
,p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_CONTEXT'
,p_hook_type => 'BP'
);
FF_FUNCTION_CONTEXT_USG_BK3.DELETE_CONTEXT_a
(p_function_id => p_function_id
,p_sequence_number => p_sequence_number
,p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_CONTEXT'
,p_hook_type => 'AP'
);
rollback to DELETE_CONTEXT;
rollback to DELETE_CONTEXT;
end DELETE_CONTEXT;