The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT source_form_template_id
FROM hr_source_form_templates hsf
,hr_template_items_b hti
WHERE hsf.form_template_id_to = hti.form_template_id
AND hti.template_item_id = p_template_item_id;
SELECT tic.template_item_context_id
FROM hr_template_item_contexts_b tic
WHERE NOT EXISTS (SELECT 0
FROM hr_template_item_context_pages tcp
WHERE tcp.template_tab_page_id = p_template_tab_page_id
AND tcp.template_item_context_id = tic.template_item_context_id)
AND tic.template_item_id = p_template_item_id;
procedure delete_template_item_tab_page
(p_validate in boolean default false
,p_template_item_tab_page_id in number
,p_object_version_number in number
,p_upd_template_item_contexts in boolean default false
) is
--
-- Declare cursors and local variables
--
l_temp number;
SELECT source_form_template_id
FROM hr_source_form_templates hsf
,hr_template_items_b hti
,hr_template_item_tab_pages htit
WHERE hsf.form_template_id_to = hti.form_template_id
AND hti.template_item_id = htit.template_item_id
AND htit.template_item_tab_page_id = p_template_item_tab_page_id;
SELECT tcp.template_item_context_page_id
,tcp.object_version_number
FROM hr_template_item_context_pages tcp
,hr_template_item_contexts_b tic
,hr_template_item_tab_pages tip
WHERE tcp.template_tab_page_id = tip.template_tab_page_id
AND tcp.template_item_context_id = tic.template_item_context_id
AND tic.template_item_id = tip.template_item_id
AND tip.template_item_tab_page_id = p_template_item_tab_page_id;
l_proc varchar2(72) := g_package||'delete_template_item_tab_page';
savepoint delete_template_item_tab_page;
hr_template_item_tab_pages_bk2.delete_tip_b
(p_template_item_tab_page_id => p_template_item_tab_page_id
,p_object_version_number => p_object_version_number
,p_upd_template_item_contexts => p_upd_template_item_contexts
);
(p_module_name => 'delete_template_item_tab_page'
,p_hook_type => 'BP'
);
hr_tcp_api.delete_tcp
(p_template_item_context_page_i => l_template_item_context_page.template_item_context_page_id
,p_object_version_number => l_template_item_context_page.object_version_number
);
hr_template_item_tab_pages_bk2.delete_tip_a
(p_template_item_tab_page_id => p_template_item_tab_page_id
,p_object_version_number => p_object_version_number
,p_upd_template_item_contexts => p_upd_template_item_contexts
);
(p_module_name => 'delete_template_item_tab_page'
,p_hook_type => 'AP'
);
rollback to delete_template_item_tab_page;
rollback to delete_template_item_tab_page;
end delete_template_item_tab_page;