APPS.WMS_PURGE_PVT dependencies on WMS_TXN_CONTEXT_TEMP

Line 59: INSERT INTO WMS_TXN_CONTEXT_TEMP ( line_id, txn_source_name )

55: x_return_status := fnd_api.g_ret_sts_success;
56:
57: l_progress := 'Bulk insert LPNs into temp table for validation';
58: FORALL i IN p_lpn_id_table.first .. p_lpn_id_table.last
59: INSERT INTO WMS_TXN_CONTEXT_TEMP ( line_id, txn_source_name )
60: VALUES ( p_lpn_id_table(i), 'WMS_LPN_PURGE' );
61:
62: l_progress := 'Filter out LPNs not valid for purge';
63: SELECT lpn_id BULK COLLECT

Line 65: FROM WMS_LICENSE_PLATE_NUMBERS wlpn, WMS_TXN_CONTEXT_TEMP wtct

61:
62: l_progress := 'Filter out LPNs not valid for purge';
63: SELECT lpn_id BULK COLLECT
64: INTO l_valid_lpns
65: FROM WMS_LICENSE_PLATE_NUMBERS wlpn, WMS_TXN_CONTEXT_TEMP wtct
66: WHERE wtct.txn_source_name = 'WMS_LPN_PURGE'
67: AND wlpn.lpn_id = wtct.line_id
68: AND wlpn.lpn_context IN (4, 5)
69: AND NOT EXISTS ( SELECT 1 FROM MTL_TRANSACTIONS_INTERFACE

Line 88: l_progress := 'Remove records from wms_txn_context_temp';

84: WHERE outermost_lpn_id = wlpn.outermost_lpn_id
85: AND lpn_context <> wlpn.lpn_context)
86: FOR UPDATE;
87:
88: l_progress := 'Remove records from wms_txn_context_temp';
89: DELETE FROM WMS_TXN_CONTEXT_TEMP
90: WHERE txn_source_name = 'WMS_LPN_PURGE';
91:
92: --bug 5150284 if any LPNs did not pass validation, add message to stack

Line 89: DELETE FROM WMS_TXN_CONTEXT_TEMP

85: AND lpn_context <> wlpn.lpn_context)
86: FOR UPDATE;
87:
88: l_progress := 'Remove records from wms_txn_context_temp';
89: DELETE FROM WMS_TXN_CONTEXT_TEMP
90: WHERE txn_source_name = 'WMS_LPN_PURGE';
91:
92: --bug 5150284 if any LPNs did not pass validation, add message to stack
93: IF ( p_lpn_id_table.count > l_valid_lpns.count ) THEN