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

103: p_mtl_ser_txn_if_rec.attribute14(i),
104: p_mtl_ser_txn_if_rec.attribute15(i));
105:
106: IF l_debug_on THEN
107: WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_serial_numbers_interface',SQL%ROWCOUNT);
108: END IF;
109:
110:
111: IF l_debug_on THEN

Line 136: -- MTL_SERIAL_NUMBERS_INTERFACE table.

132: --
133: -- Description:
134: --
135: -- Called by the client to insert a row into the
136: -- MTL_SERIAL_NUMBERS_INTERFACE table.
137: --
138: -- ===========================================================================
139: PROCEDURE Insert_Row (
140: x_rowid IN OUT NOCOPY VARCHAR2,

Line 163: SELECT rowid FROM mtl_serial_numbers_interface

159: p_process_flag IN NUMBER DEFAULT 1)
160: IS
161:
162: CURSOR row_id IS
163: SELECT rowid FROM mtl_serial_numbers_interface
164: WHERE transaction_interface_id = x_trx_interface_id
165: AND NVL(fm_serial_number,'-1') =
166: NVL(p_fm_serial_number, NVL(fm_serial_number,'-1'))
167: AND NVL(to_serial_number,'-1') =

Line 265: INSERT INTO mtl_serial_numbers_interface (

261: FETCH get_interface_id INTO x_trx_interface_id;
262: CLOSE get_interface_id;
263: END IF;
264:
265: INSERT INTO mtl_serial_numbers_interface (
266: source_code,
267: source_line_id,
268: transaction_interface_id,
269: fm_serial_number,

Line 348: -- MTL_SERIAL_NUMBERS_INTERFACE table.

344: --
345: -- Description:
346: --
347: -- Called by the client to update a row in the
348: -- MTL_SERIAL_NUMBERS_INTERFACE table.
349: --
350: -- ===========================================================================
351:
352: PROCEDURE Update_Row (

Line 447: UPDATE mtl_serial_numbers_interface SET

443: END IF;
444:
445: fnd_profile.get('USER_ID',g_userid);
446:
447: UPDATE mtl_serial_numbers_interface SET
448: source_code = p_source_code,
449: source_line_id = p_source_line_id,
450: transaction_interface_id = p_trx_interface_id,
451: fm_serial_number = p_fm_serial_number,

Line 501: -- MTL_SERIAL_NUMBERS_INTERFACE table.

497: --
498: -- Description:
499: --
500: -- Called by the client to delete a row in the
501: -- MTL_SERIAL_NUMBERS_INTERFACE table.
502: --
503: -- ===========================================================================
504:
505: PROCEDURE Delete_Row (

Line 533: DELETE FROM mtl_serial_numbers_interface WHERE rowid = x_rowid;

529: --
530: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
531: END IF;
532: --
533: DELETE FROM mtl_serial_numbers_interface WHERE rowid = x_rowid;
534:
535: IF l_debug_on THEN
536: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
537: END IF;

Line 569: -- MTL_SERIAL_NUMBERS_INTERFACE table.

565: --
566: -- Description:
567: --
568: -- Called by the client to lock a row in the
569: -- MTL_SERIAL_NUMBERS_INTERFACE table.
570: --
571: -- ===========================================================================
572:
573: PROCEDURE Lock_Row (

Line 587: SELECT * FROM mtl_serial_numbers_interface

583: p_process_flag IN NUMBER,
584: p_parent_serial_number IN VARCHAR2 )
585: IS
586: CURSOR lock_record IS
587: SELECT * FROM mtl_serial_numbers_interface
588: WHERE rowid = x_rowid
589: FOR UPDATE NOWAIT;
590:
591: rec_info lock_record%ROWTYPE;