eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRX_HANDLER dependencies on MTL_TRANSACTIONS_INTERFACE

Line 18: -- MTL_TRANSACTIONS_INTERFACE table.

14: --
15: -- Description:
16: --
17: -- Called by the client to insert a row into the
18: -- MTL_TRANSACTIONS_INTERFACE table.
19: --
20: -- ===========================================================================
21: --
22: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRX_HANDLER';

Line 59: INSERT INTO mtl_transactions_interface (

55:
56: fnd_profile.get('USER_ID',g_userid);
57:
58: FORALL i IN p_start_index..p_end_index
59: INSERT INTO mtl_transactions_interface (
60: source_code,
61: source_header_id,
62: source_line_id,
63: inventory_item_id,

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

149: g_userid
150: );
151:
152: IF l_debug_on THEN
153: WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_transactions_interface',SQL%ROWCOUNT);
154: END IF;
155:
156: -- Delete all the record with error_flag 'Y'
157: FORALL i IN p_start_index..p_end_index

Line 158: DELETE mtl_transactions_interface

154: END IF;
155:
156: -- Delete all the record with error_flag 'Y'
157: FORALL i IN p_start_index..p_end_index
158: DELETE mtl_transactions_interface
159: WHERE picking_line_id = decode(p_mtl_txn_if_rec.error_flag(i),
160: 'Y',p_mtl_txn_if_rec.picking_line_id(i),
161: 'N',-99999);
162: IF l_debug_on THEN

Line 163: WSH_DEBUG_SV.log(l_module_name,'Rows Delete in mtl_transactions_interface',SQL%ROWCOUNT);

159: WHERE picking_line_id = decode(p_mtl_txn_if_rec.error_flag(i),
160: 'Y',p_mtl_txn_if_rec.picking_line_id(i),
161: 'N',-99999);
162: IF l_debug_on THEN
163: WSH_DEBUG_SV.log(l_module_name,'Rows Delete in mtl_transactions_interface',SQL%ROWCOUNT);
164: END IF;
165:
166: FORALL i IN p_start_index..p_end_index
167: UPDATE wsh_delivery_details

Line 468: SELECT rowid FROM mtl_transactions_interface

464: )
465: IS
466:
467: CURSOR row_id IS
468: SELECT rowid FROM mtl_transactions_interface
469: WHERE transaction_interface_id = x_trx_interface_id;
470:
471: CURSOR get_interface_id IS
472: SELECT mtl_material_transactions_s.nextval

Line 1063: INSERT INTO mtl_transactions_interface (

1059: FETCH get_interface_id INTO x_trx_interface_id;
1060: CLOSE get_interface_id;
1061: END IF;
1062:
1063: INSERT INTO mtl_transactions_interface (
1064: source_code,
1065: source_line_id,
1066: source_header_id,
1067: inventory_item_id,

Line 1640: -- MTL_TRANSACTIONS_INTERFACE table.

1636: --
1637: -- Description:
1638: --
1639: -- Called by the client to update a row in the
1640: -- MTL_TRANSACTIONS_INTERFACE table.
1641: --
1642: -- ===========================================================================
1643:
1644: PROCEDURE Update_Row (

Line 2486: UPDATE mtl_transactions_interface SET

2482: END IF;
2483: --
2484: fnd_profile.get('USER_ID',g_userid);
2485:
2486: UPDATE mtl_transactions_interface SET
2487: source_code = p_source_code,
2488: source_line_id = p_source_line_id,
2489: source_header_id = p_source_header_id,
2490: inventory_item_id = p_inventory_item_id,

Line 2785: -- MTL_TRANSACTIONS_INTERFACE table.

2781: --
2782: -- Description:
2783: --
2784: -- Called by the client to delete a row in the
2785: -- MTL_TRANSACTIONS_INTERFACE table.
2786: --
2787: -- ===========================================================================
2788:
2789: PROCEDURE Delete_Row (

Line 2809: FROM mtl_transactions_interface');

2805: -- get the column which may map to another table
2806: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2807: 'START',
2808: 'Select transaction_interface_id INTO l_trx_interface_id
2809: FROM mtl_transactions_interface');
2810: */
2811: --
2812: --
2813: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 2827: FROM mtl_transactions_interface

2823: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
2824: END IF;
2825: --
2826: SELECT transaction_interface_id INTO l_trx_interface_id
2827: FROM mtl_transactions_interface
2828: WHERE rowid = x_rowid;
2829:
2830: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2831: 'END',

Line 2897: 'Delete mtl_transactions_interface');

2893: END IF;
2894:
2895: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2896: 'START',
2897: 'Delete mtl_transactions_interface');
2898: */
2899: DELETE FROM mtl_transactions_interface WHERE rowid = x_rowid;
2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);

Line 2899: DELETE FROM mtl_transactions_interface WHERE rowid = x_rowid;

2895: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2896: 'START',
2897: 'Delete mtl_transactions_interface');
2898: */
2899: DELETE FROM mtl_transactions_interface WHERE rowid = x_rowid;
2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2902: END IF;
2903:

Line 2907: 'No rows deleted from mtl_transactions_interface.

2903:
2904: IF (SQL%NOTFOUND) THEN
2905: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2906: 'END',
2907: 'No rows deleted from mtl_transactions_interface.
2908: Raising NO_DATA_FOUND');
2909: */
2910: IF l_debug_on THEN
2911: WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');

Line 3210: SELECT * FROM mtl_transactions_interface

3206: -- p_scheduled_payback_date IN DATE
3207: )
3208: IS
3209: CURSOR lock_record IS
3210: SELECT * FROM mtl_transactions_interface
3211: WHERE rowid = x_rowid
3212: FOR UPDATE NOWAIT;
3213:
3214: rec_info lock_record%ROWTYPE;