The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hxc_approval_item_key_s.nextval
into l_item_key
from dual;
select 'YES'
from hxc_time_building_blocks
where time_building_block_id = p_timecard_id
and object_version_number <= p_max_ovn
and approval_status = 'SUBMITTED';
select 'YES'
from hxc_time_building_blocks
where time_building_block_id <> p_timecard_id
and approval_status = 'SUBMITTED'
and start_time <= p_stop_time
and stop_time >= p_start_time
and resource_id = p_resource_id
and scope = 'TIMECARD';
select timecard_id,
application_period_id
from hxc_tc_ap_links
where timecard_id = p_tc_bb_id;
select creation_date
from hxc_time_building_blocks
where time_building_block_id = l_app_id
and object_version_number = l_app_ovn;
select application_period_id
from hxc_app_period_summary
where resource_id = p_resource_id
and trunc(start_time) = trunc(p_start_time)
and trunc(stop_time) = trunc(p_stop_time)
and time_recipient_id = p_time_recipient_id
and recipient_sequence IS NULL
and time_category_id IS NULL
and category_sequence IS NULL
and approval_comp_id IS NULL;
select htr.time_recipient_id
from hxc_application_sets_v has,
hxc_application_set_comps_v hasc,
hxc_time_recipients htr
where has.application_set_id = p_app_set
and hasc.application_set_id = has.application_set_id
and hasc.time_recipient_id = htr.time_recipient_id;
* been deleted in the hxc_timecard package */
hxc_tc_ap_links_pkg.remove_timecard_links
(p_timecard_id => p_tc_bb_id );
hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));
hxc_app_period_summary_pkg.delete_summary_row(p_app_period_id => l_app_period_info(l_dup_index) );
hxc_app_period_summary_pkg.insert_summary_row
(p_application_period_id => l_time_building_block_id,
p_application_period_ovn=> l_object_version_number,
p_approval_status => 'APPROVED',
p_time_recipient_id => l_appl_recipients(l_index),
p_time_category_id => NULL,
p_start_time => l_timecard_start_time,
p_stop_time => l_timecard_stop_time,
p_resource_id => l_resource_id,
p_recipient_sequence => null,
p_category_sequence => null,
p_creation_date => l_creation_date,
p_notification_status => 'FINISHED',
p_approver_id => null,
p_approval_comp_id => null,
p_approval_item_type => NULL,
p_approval_process_name => NULL,
p_approval_item_key => NULL,
p_data_set_id => null ----- Passing data set id as null explicitly.,
);
hxc_tc_ap_links_pkg.insert_summary_row
(p_timecard_id => p_tc_bb_id,
p_application_period_id => l_time_building_block_id
);
/* Bulk insert the nested array into the hxc_ap_detail_links table */
--Fix the bug 4506258. Added the if condition to take care of empty PL/SQL table when empty TC is submitted
if(l_detail_array.application_period_id.count>0) then
forall l_dup_index in l_detail_array.application_period_id.first .. l_detail_array.application_period_id.last
insert into hxc_ap_detail_links
values ( l_detail_array.APPLICATION_PERIOD_ID(l_dup_index),
l_detail_array.TIME_BUILDING_BLOCK_ID(l_dup_index),
l_detail_array.TIME_BUILDING_BLOCK_OVN(l_dup_index)
);
update hxc_timecard_summary
set approval_status = hxc_timecard.c_approved_status
where timecard_id = p_tc_bb_id;
Select APPROVAL_STYLE_ID
from hxc_approval_styles
where NAME = 'Approval on Submit' ;