The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
begin
--
-- 1. Remove any previous links between an earlier version
-- of the detail
--
delete from hxc_ap_detail_links
where time_building_block_id = p_time_building_block_id
and application_period_id = p_application_period_id;
insert into hxc_ap_detail_links
(application_period_id
,time_building_block_id
,time_building_block_ovn
)
values
(p_application_period_id
,p_time_building_block_id
,p_time_building_block_ovn
);
end insert_summary_row;
procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
begin
delete from hxc_ap_detail_links
where application_period_id = p_application_period_id
and time_building_block_id = p_time_building_block_id
and time_building_block_ovn = p_time_building_block_ovn;
end delete_summary_row;
procedure delete_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
begin
delete from hxc_ap_detail_links where application_period_id = p_application_period_id;
end delete_ap_detail_links;
PROCEDURE bulk_delete ( p_application_period NUMBER
, p_tbb_id_tab tbb_id_tab
, p_app_period_tab app_period_tab) IS
l_proc varchar2(72);
l_proc := g_package||'bulk_delete';
DELETE FROM hxc_ap_detail_links adl
WHERE adl.application_period_id = l_app_period_tab(i)
AND adl.time_building_block_id = p_tbb_id_tab(i);
END bulk_delete;
procedure delete_ap_detail_links(p_timecard_id in number
,p_blocks in hxc_block_table_type) IS
CURSOR csr_get_appl_period_id ( p_tbb_id NUMBER ) IS
SELECT tal.application_period_id
FROM hxc_tc_ap_links tal
WHERE tal.timecard_id = p_tbb_id;
l_proc := g_package||'delete_ap_detail_links';
bulk_delete ( l_application_period_id, t_tbb_id, t_app_period );
t_app_period.DELETE;
t_tbb_id.DELETE;
END delete_ap_detail_links;
select resource_id
,start_time
,stop_time
from hxc_app_period_summary
where application_period_id = p_application_period_id;
select details.time_building_block_id
,details.object_version_number
from hxc_time_building_blocks details, hxc_time_building_blocks days
where days.resource_id = p_rid
and trunc(days.stop_time) >= trunc(p_start_time)
and trunc(days.start_time) <= trunc(p_stop_time)
and days.scope = 'DAY'
and days.date_to = hr_general.end_of_time
and details.parent_building_block_id = days.time_building_block_id
and details.parent_building_block_ovn = days.object_version_number
and details.date_to = hr_general.end_of_time
and details.scope = 'DETAIL';
delete_ap_detail_links(p_application_period_id);
insert_summary_row(p_application_period_id,det_rec.time_building_block_id,det_rec.object_version_number);