APPS.PN_PURGE_INTERFACE_PKG SQL Statements

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

Line: 32

      delete_locations(p_batch_name);

Line: 40

      delete_space_allocations(p_batch_name);

Line: 48

      delete_locations(p_batch_name);

Line: 50

      delete_space_allocations(p_batch_name);

Line: 64

PROCEDURE  Delete_Locations ( p_Batch_Name  VARCHAR2)  IS

  l_Count  Number;

Line: 70

  Select Count(*)
  Into   l_Count
  From   PN_LOCATIONS_ITF
  Where  Batch_Name  =  p_Batch_Name ;

Line: 75

  Select Count(*)
  Into   l_Count
  From   PN_LOCATIONS_ITF;

Line: 82

    pnp_debug_pkg.log('About to Delete from PN_LOCATIONS_ITF ...');

Line: 85

  Delete From PN_LOCATIONS_ITF
  Where  Batch_Name  =  p_Batch_Name ;

Line: 88

  Delete From PN_LOCATIONS_ITF;

Line: 105

END delete_locations;

Line: 111

PROCEDURE  Delete_Space_Allocations ( p_Batch_Name  VARCHAR2)  IS

  l_Count  Number;

Line: 117

  Select Count(*)
  Into   l_Count
  From   PN_EMP_SPACE_ASSIGN_ITF
  Where  Batch_Name  =  p_Batch_Name ;

Line: 122

  Select Count(*)
  Into   l_Count
  From   PN_EMP_SPACE_ASSIGN_ITF;

Line: 127

    pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');

Line: 131

  Delete From PN_EMP_SPACE_ASSIGN_ITF
  Where  Batch_Name  =  p_Batch_Name ;

Line: 134

   Delete From PN_EMP_SPACE_ASSIGN_ITF;

Line: 150

END  Delete_Space_Allocations ;