The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_building_blocks_int.delete;
p_building_blocks_otl.delete;
p_app_attributes_otl(l_index).updated :=
p_app_attributes_int(l_index).updated;
p_app_attributes_int.delete;
p_app_attributes_int(l_index).updated :=
p_app_attributes_otl(l_index).updated;
p_app_attributes_otl.delete;
p_messages_int.delete;
p_messages_otl.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=
HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;
HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).deleted :=
HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).deleted;
HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_bb_id.delete;
HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks.delete;
Procedure Update_Transaction_Status(
p_process hxc_retrieval_processes.name%TYPE
,p_status hxc_transactions.status%TYPE
,p_exception_description hxc_transactions.exception_description%TYPE
,p_rollback BOOLEAN DEFAULT FALSE)
IS
BEGIN
-- transfer the data from the integration pl/sql table
-- to the otl pl/sql table
int_to_otl_gb_tx_detail_status;
HXC_GENERIC_RETRIEVAL_PKG.Update_Transaction_Status(
p_process => p_process
,p_status => p_status
,p_exception_description => p_exception_description
,p_rollback => p_rollback);
END Update_Transaction_Status;
l_building_blocks_int.delete;
l_building_blocks_otl.delete;
l_app_attributes_int.delete;
l_app_attributes_otl.delete;
select *
from hxc_time_building_blocks
where time_building_block_id = p_time_building_block_id
and object_version_number = p_time_building_block_ovn;
select a.*
from hxc_time_attributes a,
hxc_time_attribute_usages b
where a.time_attribute_id = b.time_attribute_id
and b.time_building_block_id = p_time_building_block_id
and b.time_building_block_ovn = P_time_building_block_ovn
and a.attribute_category = nvl(p_attribute_category,a.attribute_category);