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 96: WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_transaction_lots_interface',SQL%ROWCOUNT);

92: p_mtl_lot_txn_if_rec.grade_code(i)
93: );
94:
95: IF l_debug_on THEN
96: WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_transaction_lots_interface',SQL%ROWCOUNT);
97: END IF;
98:
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.pop(l_module_name);

Line 143: SELECT rowid FROM mtl_transaction_lots_interface

139: p_grade_code IN VARCHAR2 DEFAULT NULL)
140: IS
141:
142: CURSOR row_id IS
143: SELECT rowid FROM mtl_transaction_lots_interface
144: WHERE transaction_interface_id = x_trx_interface_id
145: AND lot_number = p_lot_number;
146:
147: CURSOR get_interface_id IS

Line 230: INSERT INTO mtl_transaction_lots_interface(

226: FETCH get_interface_id INTO x_trx_interface_id;
227: CLOSE get_interface_id;
228: END IF;
229:
230: INSERT INTO mtl_transaction_lots_interface(
231: source_code,
232: source_line_id,
233: transaction_interface_id,
234: lot_number,

Line 316: -- MTL_TRANSACTION_LOTS_INTERFACE table.

312: --
313: -- Description:
314: --
315: -- Called by the client to update a row in the
316: -- MTL_TRANSACTION_LOTS_INTERFACE table.
317: --
318: -- ===========================================================================
319:
320: PROCEDURE Update_Row (

Line 413: UPDATE mtl_transaction_lots_interface SET

409: END IF;
410: --
411: fnd_profile.get('USER_ID',g_userid);
412:
413: UPDATE mtl_transaction_lots_interface SET
414: source_code = p_source_code,
415: source_line_id = p_source_line_id,
416: transaction_interface_id = p_trx_interface_id,
417: lot_number = p_lot_number,

Line 466: -- MTL_TRANSACTION_LOTS_INTERFACE table.

462: --
463: -- Description:
464: --
465: -- Called by the client to delete a row in the
466: -- MTL_TRANSACTION_LOTS_INTERFACE table.
467: --
468: -- ===========================================================================
469:
470: PROCEDURE Delete_Row (

Line 508: FROM mtl_transaction_lots_interface

504: --
505: DELETE FROM mtl_serial_numbers_interface
506: WHERE transaction_interface_id IN
507: ( SELECT serial_transaction_temp_id
508: FROM mtl_transaction_lots_interface
509: WHERE rowid = x_rowid);
510:
511: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
512: 'END',

Line 517: 'Delete from mtl_transaction_lots_interface ');

513: 'Finish with call to DELETE mtl_serial_numbers_interface');
514:
515: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
516: 'START',
517: 'Delete from mtl_transaction_lots_interface ');
518: */
519: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
520:
521: IF (SQL%NOTFOUND) THEN

Line 519: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

515: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
516: 'START',
517: 'Delete from mtl_transaction_lots_interface ');
518: */
519: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
520:
521: IF (SQL%NOTFOUND) THEN
522: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
523: 'END',

Line 551: -- MTL_TRANSACTION_LOTS_INTERFACE table.

547: --
548: -- Description:
549: --
550: -- Called by the client to lock a row in the
551: -- MTL_TRANSACTION_LOTS_INTERFACE table.
552: --
553: -- ===========================================================================
554:
555: PROCEDURE Lock_Row (

Line 573: SELECT * FROM mtl_transaction_lots_interface

569: p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
570: p_grade_code IN VARCHAR2 DEFAULT NULL )
571: IS
572: CURSOR lock_record IS
573: SELECT * FROM mtl_transaction_lots_interface
574: WHERE rowid = x_rowid
575: FOR UPDATE NOWAIT;
576:
577: rec_info lock_record%ROWTYPE;