APPS.EAM_SAFETY_ASSET_UTL_PKG SQL Statements

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

Line: 29

 ,x_create_update           OUT  NOCOPY  VARCHAR2
 ,x_return_status           OUT  NOCOPY  VARCHAR2
 ,x_msg_count		        OUT  NOCOPY  NUMBER
 ,x_msg_data	            OUT  NOCOPY  VARCHAR2
 ) IS

 l_inventory_item_id          NUMBER;

Line: 43

 l_create_update              VARCHAR2(1);

Line: 54

	        SELECT 'Y', INVENTORY_ITEM_ID, LAST_VLD_ORGANIZATION_ID, SERIAL_NUMBER, INSTANCE_NUMBER,NETWORK_ASSET_FLAG
		     INTO l_exists, l_inventory_item_id, l_organization_id,l_serial_number, l_instance_number,l_network_asset_flag
	        FROM CSI_ITEM_INSTANCES
	        WHERE INSTANCE_ID = p_instance_id;

Line: 71

	       SELECT EAM_ITEM_TYPE,SERIAL_NUMBER_CONTROL_CODE
	       INTO l_eam_item_type,l_serial_number_control_code
		   FROM MTL_SYSTEM_ITEMS_B_KFV
		   WHERE INVENTORY_ITEM_ID = l_inventory_item_id
	       AND   ORGANIZATION_ID = l_organization_id;

Line: 106

	          SELECT 'U'
			      INTO l_create_update
	          FROM EAM_ASSET_SAFETY_TYPES
	          WHERE INSTANCE_ID = p_instance_id;

Line: 112

	          l_create_update := 'C';

Line: 116

        x_create_update := l_create_update;