The following lines contain the word 'select', 'insert', 'update' or 'delete':
delete_locations(p_batch_name);
delete_space_allocations(p_batch_name);
delete_locations(p_batch_name);
delete_space_allocations(p_batch_name);
PROCEDURE Delete_Locations ( p_Batch_Name VARCHAR2) IS
l_Count Number;
Select Count(*)
Into l_Count
From PN_LOCATIONS_ITF
Where Batch_Name = p_Batch_Name ;
Select Count(*)
Into l_Count
From PN_LOCATIONS_ITF;
pnp_debug_pkg.log('About to Delete from PN_LOCATIONS_ITF ...');
Delete From PN_LOCATIONS_ITF
Where Batch_Name = p_Batch_Name ;
Delete From PN_LOCATIONS_ITF;
END delete_locations;
PROCEDURE Delete_Space_Allocations ( p_Batch_Name VARCHAR2) IS
l_Count Number;
Select Count(*)
Into l_Count
From PN_EMP_SPACE_ASSIGN_ITF
Where Batch_Name = p_Batch_Name ;
Select Count(*)
Into l_Count
From PN_EMP_SPACE_ASSIGN_ITF;
pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');
Delete From PN_EMP_SPACE_ASSIGN_ITF
Where Batch_Name = p_Batch_Name ;
Delete From PN_EMP_SPACE_ASSIGN_ITF;
END Delete_Space_Allocations ;