APPS.WSH_TRXSN_HANDLER dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 51: INSERT INTO mtl_serial_numbers_interface (

47: END IF;
48:
49:
50: FORALL i IN l_start_index..l_end_index
51: INSERT INTO mtl_serial_numbers_interface (
52: source_code,
53: source_line_id,
54: transaction_interface_id,
55: fm_serial_number,

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

214: --Bugfix 8467875 End
215: );
216:
217: IF l_debug_on THEN
218: WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_serial_numbers_interface',SQL%ROWCOUNT);
219: END IF;
220:
221:
222: IF l_debug_on THEN

Line 247: -- MTL_SERIAL_NUMBERS_INTERFACE table.

243: --
244: -- Description:
245: --
246: -- Called by the client to insert a row into the
247: -- MTL_SERIAL_NUMBERS_INTERFACE table.
248: --
249: -- ===========================================================================
250: PROCEDURE Insert_Row (
251: x_rowid IN OUT NOCOPY VARCHAR2,

Line 274: SELECT rowid FROM mtl_serial_numbers_interface

270: p_process_flag IN NUMBER DEFAULT 1)
271: IS
272:
273: CURSOR row_id IS
274: SELECT rowid FROM mtl_serial_numbers_interface
275: WHERE transaction_interface_id = x_trx_interface_id
276: AND NVL(fm_serial_number,'-1') =
277: NVL(p_fm_serial_number, NVL(fm_serial_number,'-1'))
278: AND NVL(to_serial_number,'-1') =

Line 376: INSERT INTO mtl_serial_numbers_interface (

372: FETCH get_interface_id INTO x_trx_interface_id;
373: CLOSE get_interface_id;
374: END IF;
375:
376: INSERT INTO mtl_serial_numbers_interface (
377: source_code,
378: source_line_id,
379: transaction_interface_id,
380: fm_serial_number,

Line 459: -- MTL_SERIAL_NUMBERS_INTERFACE table.

455: --
456: -- Description:
457: --
458: -- Called by the client to update a row in the
459: -- MTL_SERIAL_NUMBERS_INTERFACE table.
460: --
461: -- ===========================================================================
462:
463: PROCEDURE Update_Row (

Line 558: UPDATE mtl_serial_numbers_interface SET

554: END IF;
555:
556: fnd_profile.get('USER_ID',g_userid);
557:
558: UPDATE mtl_serial_numbers_interface SET
559: source_code = p_source_code,
560: source_line_id = p_source_line_id,
561: transaction_interface_id = p_trx_interface_id,
562: fm_serial_number = p_fm_serial_number,

Line 612: -- MTL_SERIAL_NUMBERS_INTERFACE table.

608: --
609: -- Description:
610: --
611: -- Called by the client to delete a row in the
612: -- MTL_SERIAL_NUMBERS_INTERFACE table.
613: --
614: -- ===========================================================================
615:
616: PROCEDURE Delete_Row (

Line 644: DELETE FROM mtl_serial_numbers_interface WHERE rowid = x_rowid;

640: --
641: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
642: END IF;
643: --
644: DELETE FROM mtl_serial_numbers_interface WHERE rowid = x_rowid;
645:
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
648: END IF;

Line 680: -- MTL_SERIAL_NUMBERS_INTERFACE table.

676: --
677: -- Description:
678: --
679: -- Called by the client to lock a row in the
680: -- MTL_SERIAL_NUMBERS_INTERFACE table.
681: --
682: -- ===========================================================================
683:
684: PROCEDURE Lock_Row (

Line 698: SELECT * FROM mtl_serial_numbers_interface

694: p_process_flag IN NUMBER,
695: p_parent_serial_number IN VARCHAR2 )
696: IS
697: CURSOR lock_record IS
698: SELECT * FROM mtl_serial_numbers_interface
699: WHERE rowid = x_rowid
700: FOR UPDATE NOWAIT;
701:
702: rec_info lock_record%ROWTYPE;