eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRXLOTS_HANDLER_TEST SQL Statements

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

Line: 26


   PROCEDURE Insert_Row(
      x_rowid				IN OUT NOCOPY  VARCHAR2,
      x_trx_interface_id		IN OUT NOCOPY  NUMBER,
      p_source_code        		IN VARCHAR2,
      p_source_line_id                 	IN NUMBER,
      p_lot_number			IN VARCHAR2,
      p_trx_quantity			IN NUMBER,
      p_last_update_date		IN DATE,
      p_last_updated_by			IN NUMBER,
      p_creation_date			IN DATE,
      p_created_by			IN NUMBER,
      p_serial_trx_id			IN NUMBER,
      p_error_code			IN VARCHAR2,
      p_last_update_login               IN NUMBER DEFAULT NULL,
      p_request_id                      IN NUMBER DEFAULT NULL,
      p_program_application_id          IN NUMBER DEFAULT NULL,
      p_program_id                      IN NUMBER DEFAULT NULL,
      p_program_update_date             IN DATE DEFAULT NULL,
      p_lot_expiration_date             IN DATE DEFAULT NULL,
      p_primary_quantity                IN NUMBER DEFAULT NULL,
      p_process_flag			IN VARCHAR2 DEFAULT 'Y')
   IS

      CURSOR row_id IS
         SELECT rowid FROM mtl_transaction_lots_interface
         WHERE transaction_interface_id = x_trx_interface_id
         AND lot_number = p_lot_number;

Line: 55


         SELECT mtl_material_transactions_s.nextval
         FROM sys.dual;

Line: 61


l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';

Line: 65


/*      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',
         'START',
         'Start of procedure INSERT_ROW, input parameters:
            source_code='||p_source_code||
            ', source_line_id='||p_source_line_id||
            ', transaction_interface_id='||x_trx_interface_id||
            ', lot_number='||p_lot_number||
            ', transaction_quantity='||p_trx_quantity||
            ', last_update_date='||p_last_update_date||
            ', last_updated_by='||p_last_updated_by);

Line: 80


            ', last_update_login='||p_last_update_login||
            ', request_id='||p_request_id||
            ', program_application_id='||p_program_application_id||
            ', program_id='||p_program_id||
            ', program_update_date='||p_program_update_date||
            ', lot_expiration_date='||p_lot_expiration_date||
            ', primary_quantity='||p_primary_quantity||
            ', process_flag='||p_process_flag );

Line: 109


          WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);

Line: 110


          WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);

Line: 115


          WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);

Line: 119


          WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);

Line: 134


      INSERT INTO mtl_transaction_lots_interface(
         source_code,
         source_line_id,
         transaction_interface_id,
         lot_number,
         transaction_quantity,
         last_update_date,
         last_updated_by,
         creation_date,
         created_by,
         serial_transaction_temp_id,
         error_code,
         last_update_login,
         request_id,
         program_application_id,
         program_id,
         program_update_date,
         lot_expiration_date,
         primary_quantity,
         process_flag
      ) VALUES (
         p_source_code,
         p_source_line_id,
         x_trx_interface_id,
         p_lot_number,
         p_trx_quantity,
         NVL(p_last_update_date,SYSDATE),
         NVL(p_last_updated_by,g_userid),
         NVL(p_creation_date,SYSDATE),
         NVL(p_created_by,g_userid),
         p_serial_trx_id,
         p_error_code,
         p_last_update_login,
         p_request_id,
         p_program_application_id,
         p_program_id,
         p_program_update_date,
         p_lot_expiration_date,
         p_primary_quantity,
         p_process_flag
      );

Line: 181


/*         wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',
            'END',
            'No rowid found. Raising NO_DATA_FOUND.');

Line: 191


/*      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',
         'END',
         'End of procedure INSERT_ROW');

Line: 202


   END Insert_Row;

Line: 217


   PROCEDURE Update_Row (
      x_rowid				IN OUT NOCOPY  VARCHAR2,
      p_trx_interface_id		IN NUMBER,
      p_source_code                    	IN VARCHAR2,
      p_source_line_id 			IN NUMBER,
      p_lot_number			IN VARCHAR2,
      p_trx_quantity			IN NUMBER,
      p_last_update_date		IN DATE,
      p_last_updated_by			IN NUMBER,
      p_serial_trx_id			IN NUMBER,
      p_error_code			IN VARCHAR2,
      p_last_update_login               IN NUMBER DEFAULT NULL,
      p_request_id                      IN NUMBER DEFAULT NULL,
      p_program_application_id          IN NUMBER DEFAULT NULL,
      p_program_id                      IN NUMBER DEFAULT NULL,
      p_program_update_date             IN DATE DEFAULT NULL,
      p_lot_expiration_date             IN DATE DEFAULT NULL,
      p_primary_quantity                IN NUMBER DEFAULT NULL,
      p_process_flag			IN VARCHAR2 DEFAULT 'Y')
   IS
   --
l_debug_on BOOLEAN;

Line: 240


   l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';

Line: 243


/*   wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',
      'START',
      'Start of procedure UPDATE_ROW, input parameters:
            source_code='||p_source_code||
            ', source_line_id='||p_source_line_id||
            ', transaction_interface_id='||p_trx_interface_id||
            ', lot_number='||p_lot_number||
            ', transaction_quantity='||p_trx_quantity||
            ', last_update_date='||p_last_update_date||
            ', last_updated_by='||p_last_updated_by);

Line: 256


            ', last_update_login='||p_last_update_login||
            ', request_id='||p_request_id||
            ', program_application_id='||p_program_application_id||
            ', program_id='||p_program_id||
            ', program_update_date='||p_program_update_date||
            ', lot_expiration_date='||p_lot_expiration_date||
            ', primary_quantity='||p_primary_quantity||
            ',  process_flag='||p_process_flag );

Line: 286


       WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);

Line: 287


       WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);

Line: 290


       WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);

Line: 294


       WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);

Line: 302


   UPDATE mtl_transaction_lots_interface SET
      source_code 			= p_source_code,
      source_line_id 			= p_source_line_id,
      transaction_interface_id		= p_trx_interface_id,
      lot_number			= p_lot_number,
      transaction_quantity		= p_trx_quantity,
      last_updated_by 			= NVL(p_last_updated_by,g_userid),
      last_update_date 			= NVL(p_last_update_date,SYSDATE),
      serial_transaction_temp_id	= p_serial_trx_id,
      error_code			= p_error_code,
      last_update_login                 = p_last_update_login,
      request_id                        = p_request_id,
      program_application_id            = p_program_application_id,
      program_id                        = p_program_id,
      program_update_date               = p_program_update_date,
      lot_expiration_date               = p_lot_expiration_date,
      primary_quantity                  = p_primary_quantity,
      process_flag			= p_process_flag
   WHERE rowid = x_rowid;

Line: 323


/*      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',
         'END',
         'No rows updated. Raising NO_DATA_FOUND.');

Line: 330


/*   wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',
      'END',
      'End of procedure UPDATE_ROW');

Line: 341


  END Update_Row;

Line: 356


   PROCEDURE Delete_Row (
        x_rowid				IN OUT NOCOPY  VARCHAR2 )
   IS
   --
l_debug_on BOOLEAN;

Line: 362


   l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';

Line: 365


/*      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
         'START',
         'Start of procedure DELETE_ROW');

Line: 369


      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
         'START',
         'Deleting from mtl_serial_numbers_interface, if any');

Line: 391


      DELETE FROM mtl_serial_numbers_interface
      WHERE transaction_interface_id IN
        ( SELECT serial_transaction_temp_id
          FROM mtl_transaction_lots_interface
          WHERE rowid = x_rowid);

Line: 397


/*      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
         'END',
         'Finish with call to DELETE mtl_serial_numbers_interface');

Line: 401


      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
         'START',
         'Delete from mtl_transaction_lots_interface ');

Line: 405


      DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

Line: 408


/*         wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
            'END',
            'No rows deleted.  Raising NO_DATA_FOUND');

Line: 415


/*      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
         'END',
         'End of procedure DELETE_ROW');

Line: 426


   END Delete_Row;

Line: 455


         SELECT * FROM mtl_transaction_lots_interface
         WHERE rowid = x_rowid
         FOR UPDATE NOWAIT;

Line: 514


             'Lock record failed.  Raising exception FORM_RECORD_DELETED');

Line: 518


         fnd_message.set_name('FND', 'FORM_RECORD_DELETED');