APPS.WSH_TRXLOTS_HANDLER_TEST dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 19: -- MTL_TRANSACTION_LOTS_INTERFACE table.

15: --
16: -- Description:
17: --
18: -- Called by the client to insert a row into the
19: -- MTL_TRANSACTION_LOTS_INTERFACE table.
20: --
21: -- ===========================================================================
22:
23: --

Line 50: SELECT rowid FROM mtl_transaction_lots_interface

46: p_process_flag IN VARCHAR2 DEFAULT 'Y')
47: IS
48:
49: CURSOR row_id IS
50: SELECT rowid FROM mtl_transaction_lots_interface
51: WHERE transaction_interface_id = x_trx_interface_id
52: AND lot_number = p_lot_number;
53:
54: CURSOR get_interface_id IS

Line 134: INSERT INTO mtl_transaction_lots_interface(

130: FETCH get_interface_id INTO x_trx_interface_id;
131: CLOSE get_interface_id;
132: END IF;
133:
134: INSERT INTO mtl_transaction_lots_interface(
135: source_code,
136: source_line_id,
137: transaction_interface_id,
138: lot_number,

Line 213: -- MTL_TRANSACTION_LOTS_INTERFACE table.

209: --
210: -- Description:
211: --
212: -- Called by the client to update a row in the
213: -- MTL_TRANSACTION_LOTS_INTERFACE table.
214: --
215: -- ===========================================================================
216:
217: PROCEDURE Update_Row (

Line 302: UPDATE mtl_transaction_lots_interface SET

298: END IF;
299: --
300: fnd_profile.get('USER_ID',g_userid);
301:
302: UPDATE mtl_transaction_lots_interface SET
303: source_code = p_source_code,
304: source_line_id = p_source_line_id,
305: transaction_interface_id = p_trx_interface_id,
306: lot_number = p_lot_number,

Line 352: -- MTL_TRANSACTION_LOTS_INTERFACE table.

348: --
349: -- Description:
350: --
351: -- Called by the client to delete a row in the
352: -- MTL_TRANSACTION_LOTS_INTERFACE table.
353: --
354: -- ===========================================================================
355:
356: PROCEDURE Delete_Row (

Line 394: FROM mtl_transaction_lots_interface

390: --
391: DELETE FROM mtl_serial_numbers_interface
392: WHERE transaction_interface_id IN
393: ( SELECT serial_transaction_temp_id
394: FROM mtl_transaction_lots_interface
395: WHERE rowid = x_rowid);
396:
397: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
398: 'END',

Line 403: 'Delete from mtl_transaction_lots_interface ');

399: 'Finish with call to DELETE mtl_serial_numbers_interface');
400:
401: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
402: 'START',
403: 'Delete from mtl_transaction_lots_interface ');
404: */
405: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
406:
407: IF (SQL%NOTFOUND) THEN

Line 405: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

401: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
402: 'START',
403: 'Delete from mtl_transaction_lots_interface ');
404: */
405: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
406:
407: IF (SQL%NOTFOUND) THEN
408: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
409: 'END',

Line 437: -- MTL_TRANSACTION_LOTS_INTERFACE table.

433: --
434: -- Description:
435: --
436: -- Called by the client to lock a row in the
437: -- MTL_TRANSACTION_LOTS_INTERFACE table.
438: --
439: -- ===========================================================================
440:
441: PROCEDURE Lock_Row (

Line 455: SELECT * FROM mtl_transaction_lots_interface

451: p_error_code IN VARCHAR2,
452: p_process_flag IN VARCHAR2 )
453: IS
454: CURSOR lock_record IS
455: SELECT * FROM mtl_transaction_lots_interface
456: WHERE rowid = x_rowid
457: FOR UPDATE NOWAIT;
458:
459: rec_info lock_record%ROWTYPE;