DBA Data[Home] [Help]

APPS.WMS_UNLOAD_UTILS_PVT dependencies on INV_GLOBALS

Line 177: IF (line_status = inv_globals.g_to_status_cancel_by_source) THEN

173: IF (l_debug = 1) THEN
174: mydebug(' move order line status ' || line_status);
175: END IF;
176:
177: IF (line_status = inv_globals.g_to_status_cancel_by_source) THEN
178: IF (l_debug = 1) THEN
179: mydebug(' move order line cancelled ');
180: END IF;
181:

Line 251: SET line_status = inv_globals.g_to_status_closed

247: mydebug(' so closing the mo line ' || mol_id);
248: END IF;
249:
250: UPDATE mtl_txn_request_lines
251: SET line_status = inv_globals.g_to_status_closed
252: WHERE line_id = mol_id;
253:
254: IF (l_debug = 1) THEN
255: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);

Line 255: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);

251: SET line_status = inv_globals.g_to_status_closed
252: WHERE line_id = mol_id;
253:
254: IF (l_debug = 1) THEN
255: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);
256: END IF;
257: ELSE
258: IF (l_debug = 1) THEN
259: mydebug(' allocations in mmtt left for this mo line - count ' || mol_id || ' - ' || cnt);

Line 902: SET line_status = inv_globals.g_to_status_closed

898: mydebug('No more allocations for mo line ' || to_char(l_mo_line_id));
899: END IF;
900:
901: UPDATE mtl_txn_request_lines
902: SET line_status = inv_globals.g_to_status_closed
903: WHERE line_id = l_mo_line_id;
904: ELSE
905: IF (l_debug = 1) THEN
906: mydebug('Allocations left: ' || to_char(l_count));