APPS.HXC_INTEGRATION_LAYER_V1_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 75

p_building_blocks_int.delete;

Line: 144

p_building_blocks_otl.delete;

Line: 183

      p_app_attributes_otl(l_index).updated :=
      		p_app_attributes_int(l_index).updated;

Line: 194

p_app_attributes_int.delete;

Line: 232

      p_app_attributes_int(l_index).updated :=
      		p_app_attributes_otl(l_index).updated;

Line: 244

p_app_attributes_otl.delete;

Line: 294

p_messages_int.delete;

Line: 343

p_messages_otl.delete;

Line: 466

HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.delete;

Line: 492

HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.delete;

Line: 519

HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.delete;

Line: 552

	HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=
	    HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;

Line: 576

HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.delete;

Line: 609

	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;

Line: 633

HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes.delete;

Line: 667

HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes.delete;

Line: 701

HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_bb_id.delete;

Line: 775

HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks.delete;

Line: 858

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;

Line: 875

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);

Line: 882

END Update_Transaction_Status;

Line: 1217

l_building_blocks_int.delete;

Line: 1218

l_building_blocks_otl.delete;

Line: 1247

l_app_attributes_int.delete;

Line: 1248

l_app_attributes_otl.delete;

Line: 1419

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;

Line: 1484

  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);