The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_time_category
(p_validate in boolean default false
,p_time_category_id in number
,p_object_version_number in out nocopy number
,p_time_category_name in varchar2
,p_operator in varchar2
,p_description in varchar2
,p_display in varchar2
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) ;
l_proc := g_package||' update_time_category';
savepoint update_time_category;
hxc_time_category_BK_2.update_time_category_b
(p_time_category_id => p_time_category_id
,p_object_version_number => p_object_version_number
,p_time_category_name => p_time_category_name
,p_description => p_description
,p_display => p_display
,p_operator => p_operator
);
(p_module_name => 'update_time_category'
,p_hook_type => 'BP'
);
hxc_time_category_BK_2.update_time_category_a
(p_time_category_id => p_time_category_id
,p_object_version_number => l_object_version_number
,p_time_category_name => p_time_category_name
,p_description => p_description
,p_display => p_display
,p_operator => p_operator );
(p_module_name => 'update_time_category'
,p_hook_type => 'AP'
);
ROLLBACK TO update_time_category;
ROLLBACK TO update_time_category;
END update_time_category;
procedure delete_time_category
(p_validate in boolean default false
,p_time_category_id in number
,p_time_category_name in varchar2
,p_object_version_number in number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) ;
l_proc := g_package||'delete_time_category';
savepoint delete_time_category;
hxc_time_category_BK_3.delete_time_category_b
(p_time_category_id => p_time_category_id
,p_time_Category_name => p_time_category_name
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_time_category_b'
,p_hook_type => 'BP'
);
hxc_time_category_BK_3.delete_time_category_a
(p_time_category_id => p_time_category_id
,p_time_Category_name => p_time_category_name
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_time_category_a'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_time_category;
ROLLBACK TO delete_time_category;
end delete_time_category;
UPDATE hxc_time_categories
SET time_sql = l_time_sql
WHERE time_category_id = p_time_category_id;
PROCEDURE delete_old_comps
IS
l_cat VARCHAR2(50);
IS SELECT cat.time_category_id
FROM hxc_time_categories cat,
hxc_time_category_comps comp
WHERE cat.time_category_id = comp.time_category_id
AND cat.time_category_name IN ('Payroll Processing Fields',
'Projects Processing Fields',
'HR Processing Fields')
GROUP
BY cat.time_category_id,
component_type_id
HAVING COUNT(1) > 1;
DELETE FROM hxc_time_category_comps
WHERE time_category_id = l_tc_tab(i);
END delete_old_comps;
SELECT name
INTO l_comp_name
FROM hxc_mapping_components
WHERE mapping_component_id = p_component_type_id;