APPS.WSH_TRXLOTS_HANDLER 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 65: INSERT INTO mtl_transaction_lots_interface (

61: END IF;
62:
63:
64: FORALL i IN l_start_index..l_end_index
65: INSERT INTO mtl_transaction_lots_interface (
66: source_code,
67: source_line_id,
68: transaction_interface_id,
69: lot_number,

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

206: p_mtl_lot_txn_if_rec.grade_code(i)
207: );
208:
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_transaction_lots_interface',SQL%ROWCOUNT);
211: END IF;
212:
213: IF l_debug_on THEN
214: WSH_DEBUG_SV.pop(l_module_name);

Line 257: SELECT rowid FROM mtl_transaction_lots_interface

253: p_grade_code IN VARCHAR2 DEFAULT NULL)
254: IS
255:
256: CURSOR row_id IS
257: SELECT rowid FROM mtl_transaction_lots_interface
258: WHERE transaction_interface_id = x_trx_interface_id
259: AND lot_number = p_lot_number;
260:
261: CURSOR get_interface_id IS

Line 344: INSERT INTO mtl_transaction_lots_interface(

340: FETCH get_interface_id INTO x_trx_interface_id;
341: CLOSE get_interface_id;
342: END IF;
343:
344: INSERT INTO mtl_transaction_lots_interface(
345: source_code,
346: source_line_id,
347: transaction_interface_id,
348: lot_number,

Line 430: -- MTL_TRANSACTION_LOTS_INTERFACE table.

426: --
427: -- Description:
428: --
429: -- Called by the client to update a row in the
430: -- MTL_TRANSACTION_LOTS_INTERFACE table.
431: --
432: -- ===========================================================================
433:
434: PROCEDURE Update_Row (

Line 527: UPDATE mtl_transaction_lots_interface SET

523: END IF;
524: --
525: fnd_profile.get('USER_ID',g_userid);
526:
527: UPDATE mtl_transaction_lots_interface SET
528: source_code = p_source_code,
529: source_line_id = p_source_line_id,
530: transaction_interface_id = p_trx_interface_id,
531: lot_number = p_lot_number,

Line 580: -- MTL_TRANSACTION_LOTS_INTERFACE table.

576: --
577: -- Description:
578: --
579: -- Called by the client to delete a row in the
580: -- MTL_TRANSACTION_LOTS_INTERFACE table.
581: --
582: -- ===========================================================================
583:
584: PROCEDURE Delete_Row (

Line 622: FROM mtl_transaction_lots_interface

618: --
619: DELETE FROM mtl_serial_numbers_interface
620: WHERE transaction_interface_id IN
621: ( SELECT serial_transaction_temp_id
622: FROM mtl_transaction_lots_interface
623: WHERE rowid = x_rowid);
624:
625: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
626: 'END',

Line 631: 'Delete from mtl_transaction_lots_interface ');

627: 'Finish with call to DELETE mtl_serial_numbers_interface');
628:
629: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
630: 'START',
631: 'Delete from mtl_transaction_lots_interface ');
632: */
633: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
634:
635: IF (SQL%NOTFOUND) THEN

Line 633: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

629: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
630: 'START',
631: 'Delete from mtl_transaction_lots_interface ');
632: */
633: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
634:
635: IF (SQL%NOTFOUND) THEN
636: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
637: 'END',

Line 665: -- MTL_TRANSACTION_LOTS_INTERFACE table.

661: --
662: -- Description:
663: --
664: -- Called by the client to lock a row in the
665: -- MTL_TRANSACTION_LOTS_INTERFACE table.
666: --
667: -- ===========================================================================
668:
669: PROCEDURE Lock_Row (

Line 687: SELECT * FROM mtl_transaction_lots_interface

683: p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
684: p_grade_code IN VARCHAR2 DEFAULT NULL )
685: IS
686: CURSOR lock_record IS
687: SELECT * FROM mtl_transaction_lots_interface
688: WHERE rowid = x_rowid
689: FOR UPDATE NOWAIT;
690:
691: rec_info lock_record%ROWTYPE;