The following lines contain the word 'select', 'insert', 'update' or 'delete':
select deposit_process_id
from hxc_deposit_processes
where name = 'OTL Deposit Process';
select tbb.time_building_block_id
,tbb.object_version_number
from hxc_time_building_blocks tbb
where tbb.date_to = hr_general.end_of_time
start with (tbb.time_building_block_id = p_tc_id)
connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
and prior tbb.object_version_number = tbb.parent_building_block_ovn;
select tau.time_attribute_id
from hxc_time_attribute_usages tau
where tau.time_building_block_id = p_building_block_id
and tau.time_building_block_ovn = p_building_block_ovn;
Delete Timecard Procedure
This procedure....
***************************************************************************/
Procedure delete_timecard
(p_mode in varchar2
,p_template in varchar2
,p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
) is
cursor c_timecard_ovn
(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
select tbb.object_version_number
from hxc_time_building_blocks tbb
where tbb.time_building_block_id = p_timecard_id
and tbb.date_to = hr_general.end_of_time;
l_messages.delete;
hxc_block_attribute_update.set_process_flags
(p_blocks => l_blocks
,p_attributes => l_attributes
);
,p_resubmit => c_delete
,p_can_deposit => l_dummy
);
hxc_timecard_summary_api.delete_timecard
(p_blocks => l_blocks
,p_timecard_id => p_timecard_id
);
End delete_timecard;