DBA Data[Home] [Help]

APPS.WMS_UNLOAD_UTILS_PVT dependencies on INV_GLOBALS

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

215: IF (l_debug = 1) THEN
216: mydebug(' move order line status ' || line_status);
217: END IF;
218:
219: IF (line_status = inv_globals.g_to_status_cancel_by_source) THEN
220: IF (l_debug = 1) THEN
221: mydebug(' move order line cancelled ');
222: END IF;
223:

Line 296: SET line_status = inv_globals.g_to_status_closed

292: mydebug(' so closing the mo line ' || mol_id);
293: END IF;
294:
295: UPDATE mtl_txn_request_lines
296: SET line_status = inv_globals.g_to_status_closed
297: WHERE line_id = mol_id;
298:
299: IF (l_debug = 1) THEN
300: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);

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

296: SET line_status = inv_globals.g_to_status_closed
297: WHERE line_id = mol_id;
298:
299: IF (l_debug = 1) THEN
300: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);
301: END IF;
302: ELSE
303: IF (l_debug = 1) THEN
304: mydebug(' allocations in mmtt left for this mo line - count ' || mol_id || ' - ' || cnt);

Line 1114: SET line_status = inv_globals.g_to_status_closed

1110: mydebug('No more allocations for mo line ' || to_char(l_mo_line_id));
1111: END IF;
1112:
1113: UPDATE mtl_txn_request_lines
1114: SET line_status = inv_globals.g_to_status_closed
1115: WHERE line_id = l_mo_line_id;
1116: ELSE
1117: IF (l_debug = 1) THEN
1118: mydebug('Allocations left: ' || to_char(l_count));