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 SQL Statements

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

Line: 28


PROCEDURE INSERT_ROW_BULK (
     p_mtl_lot_txn_if_rec    IN              WSH_SHIP_CONFIRM_ACTIONS.mtl_lot_txn_if_rec_type,
     x_return_status         OUT NOCOPY      VARCHAR2) IS

l_debug_on BOOLEAN;

Line: 33


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

Line: 65


       INSERT INTO mtl_transaction_lots_interface (
         source_code,
         source_line_id,
         transaction_interface_id,
         lot_number,
         transaction_quantity,
         serial_transaction_temp_id,
         attribute_category, -- Bug 13529169
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15,
         c_attribute1,
         c_attribute10,
         c_attribute11,
         c_attribute12,
         c_attribute13,
         c_attribute14,
         c_attribute15,
         c_attribute16,
         c_attribute17,
         c_attribute18,
         c_attribute19,
         c_attribute2,
         c_attribute20,
         c_attribute3,
         c_attribute4,
         c_attribute5,
         c_attribute6,
         c_attribute7,
         c_attribute8,
         c_attribute9,
         d_attribute1,
         d_attribute10,
         d_attribute2,
         d_attribute3,
         d_attribute4,
         d_attribute5,
         d_attribute6,
         d_attribute7,
         d_attribute8,
         d_attribute9,
         n_attribute1,
         n_attribute10,
         n_attribute2,
         n_attribute3,
         n_attribute4,
         n_attribute5,
         n_attribute6,
         n_attribute7,
         n_attribute8,
         n_attribute9,
         lot_attribute_category,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
-- HW OPMCONV. Added secondary_qty and grade
         SECONDARY_TRANSACTION_QUANTITY,
         GRADE_CODE
      ) VALUES (
         p_mtl_lot_txn_if_rec.source_code(i),
         p_mtl_lot_txn_if_rec.source_line_id(i),
         p_mtl_lot_txn_if_rec.transaction_interface_id(i),
         p_mtl_lot_txn_if_rec.lot_number(i),
         p_mtl_lot_txn_if_rec.trx_quantity(i),
         p_mtl_lot_txn_if_rec.serial_transaction_temp_id(i),
         p_mtl_lot_txn_if_rec.attribute_category(i), -- Bug 13529169
         p_mtl_lot_txn_if_rec.attribute1(i),
         p_mtl_lot_txn_if_rec.attribute2(i),
         p_mtl_lot_txn_if_rec.attribute3(i),
         p_mtl_lot_txn_if_rec.attribute4(i),
         p_mtl_lot_txn_if_rec.attribute5(i),
         p_mtl_lot_txn_if_rec.attribute6(i),
         p_mtl_lot_txn_if_rec.attribute7(i),
         p_mtl_lot_txn_if_rec.attribute8(i),
         p_mtl_lot_txn_if_rec.attribute9(i),
         p_mtl_lot_txn_if_rec.attribute10(i),
         p_mtl_lot_txn_if_rec.attribute11(i),
         p_mtl_lot_txn_if_rec.attribute12(i),
         p_mtl_lot_txn_if_rec.attribute13(i),
         p_mtl_lot_txn_if_rec.attribute14(i),
         p_mtl_lot_txn_if_rec.attribute15(i),
         p_mtl_lot_txn_if_rec.c_attribute1(i),
         p_mtl_lot_txn_if_rec.c_attribute10(i),
         p_mtl_lot_txn_if_rec.c_attribute11(i),
         p_mtl_lot_txn_if_rec.c_attribute12(i),
         p_mtl_lot_txn_if_rec.c_attribute13(i),
         p_mtl_lot_txn_if_rec.c_attribute14(i),
         p_mtl_lot_txn_if_rec.c_attribute15(i),
         p_mtl_lot_txn_if_rec.c_attribute16(i),
         p_mtl_lot_txn_if_rec.c_attribute17(i),
         p_mtl_lot_txn_if_rec.c_attribute18(i),
         p_mtl_lot_txn_if_rec.c_attribute19(i),
         p_mtl_lot_txn_if_rec.c_attribute2(i),
         p_mtl_lot_txn_if_rec.c_attribute20(i),
         p_mtl_lot_txn_if_rec.c_attribute3(i),
         p_mtl_lot_txn_if_rec.c_attribute4(i),
         p_mtl_lot_txn_if_rec.c_attribute5(i),
         p_mtl_lot_txn_if_rec.c_attribute6(i),
         p_mtl_lot_txn_if_rec.c_attribute7(i),
         p_mtl_lot_txn_if_rec.c_attribute8(i),
         p_mtl_lot_txn_if_rec.c_attribute9(i),
         p_mtl_lot_txn_if_rec.d_attribute1(i),
         p_mtl_lot_txn_if_rec.d_attribute10(i),
         p_mtl_lot_txn_if_rec.d_attribute2(i),
         p_mtl_lot_txn_if_rec.d_attribute3(i),
         p_mtl_lot_txn_if_rec.d_attribute4(i),
         p_mtl_lot_txn_if_rec.d_attribute5(i),
         p_mtl_lot_txn_if_rec.d_attribute6(i),
         p_mtl_lot_txn_if_rec.d_attribute7(i),
         p_mtl_lot_txn_if_rec.d_attribute8(i),
         p_mtl_lot_txn_if_rec.d_attribute9(i),
         p_mtl_lot_txn_if_rec.n_attribute1(i),
         p_mtl_lot_txn_if_rec.n_attribute10(i),
         p_mtl_lot_txn_if_rec.n_attribute2(i),
         p_mtl_lot_txn_if_rec.n_attribute3(i),
         p_mtl_lot_txn_if_rec.n_attribute4(i),
         p_mtl_lot_txn_if_rec.n_attribute5(i),
         p_mtl_lot_txn_if_rec.n_attribute6(i),
         p_mtl_lot_txn_if_rec.n_attribute7(i),
         p_mtl_lot_txn_if_rec.n_attribute8(i),
         p_mtl_lot_txn_if_rec.n_attribute9(i),
         p_mtl_lot_txn_if_rec.lot_attribute_category(i),
         SYSDATE,
         g_userid,
         SYSDATE,
         g_userid,
-- HW OPMCONV. Added secondary_qty and grade
         p_mtl_lot_txn_if_rec.secondary_trx_quantity(i),
         p_mtl_lot_txn_if_rec.grade_code(i)
         );

Line: 210


       WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_transaction_lots_interface',SQL%ROWCOUNT);

Line: 226


END insert_row_bulk;

Line: 229


   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',
-- HW OPMCONV. Added p_secondary_trx_quantity
-- and p_grade_code
      p_secondary_trx_quantity          IN NUMBER DEFAULT NULL,
      p_grade_code                      IN VARCHAR2 DEFAULT NULL)
   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: 262


         SELECT mtl_material_transactions_s.nextval
         FROM sys.dual;

Line: 268


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

Line: 272


/*      wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.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: 287


            ', 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: 316


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

Line: 317


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

Line: 322


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

Line: 326


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

Line: 344


      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,
-- HW OPMCONV. Added secondary_qty and grade
         SECONDARY_TRANSACTION_QUANTITY,
         GRADE_CODE

      ) 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,
-- HW OPMCONV. Added secondary_qty and grade
         p_secondary_trx_quantity,
         p_grade_code
      );

Line: 398


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

Line: 408


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

Line: 419


   END Insert_Row;

Line: 434


   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',
-- HW OPMCONV. Added p_secondary_trx_quantity
-- and p_grade_code
      p_secondary_trx_quantity          IN NUMBER DEFAULT NULL,
      p_grade_code                      IN VARCHAR2 DEFAULT NULL
      )
   IS
   --
l_debug_on BOOLEAN;

Line: 462


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

Line: 465


/*   wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.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: 478


            ', 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: 508


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

Line: 509


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

Line: 512


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

Line: 516


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

Line: 527


   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,
-- HW OPMCONV. Added secondary_qty and grade
      SECONDARY_TRANSACTION_QUANTITY    = p_secondary_trx_quantity,
      GRADE_CODE                        = p_grade_code
   WHERE rowid = x_rowid;

Line: 551


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

Line: 558


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

Line: 569


  END Update_Row;

Line: 584


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

Line: 590


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

Line: 593


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

Line: 597


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

Line: 619


      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: 625


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

Line: 629


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

Line: 633


      DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

Line: 636


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

Line: 643


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

Line: 654


   END Delete_Row;

Line: 687


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

Line: 749


             'Lock record failed.  Raising exception FORM_RECORD_DELETED');

Line: 753


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