APPS.WMS_TASK_DISPATCH_GEN dependencies on INV_GLOBALS

Line 5064: AND mol.line_status = inv_globals.g_to_status_cancel_by_source

5060: SELECT decode(mmtt.transaction_type_id, 35,'N',51,'N','Y')
5061: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
5062: WHERE (mmtt.transaction_temp_id = txn_temp_id OR mmtt.parent_line_id = txn_temp_id)
5063: AND mmtt.move_order_line_id = mol.line_id
5064: AND mol.line_status = inv_globals.g_to_status_cancel_by_source
5065: AND ROWNUM = 1;
5066: BEGIN
5067: IF (l_debug = 1) THEN
5068: mydebug('In CAN_PICKDROP for Transaction Temp ID = ' || txn_temp_id);

Line 6451: , inv_globals.g_type_container_pack

6447: , 1
6448: , 1
6449: , transaction_uom
6450: , transaction_cost
6451: , inv_globals.g_type_container_pack
6452: , 50
6453: , 13
6454: , NULL
6455: , NULL

Line 13984: IF (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE) THEN

13980: /* OPEN c_mo_line_info;
13981: FETCH c_mo_line_info INTO l_mo_type, l_mol_src_id, l_mol_src_line_id, l_mol_reference_id, l_mol_qty, l_mol_qty_delivered;
13982: CLOSE c_mo_line_info;
13983: */
13984: IF (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE) THEN
13985: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
13986:
13987: /*bug3139307 suggest_alternate_location API in wms_txnrsn_actions_pub
13988: would call INV_Replenish_Detail_PUB.Line_Details_PUB . When there is

Line 14057: /* IF l_mo_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK THEN */

14053: END IF;
14054: RAISE fnd_api.g_exc_error;
14055: END IF;
14056: END IF; --bug3139307 bug 2924823 H to I
14057: /* IF l_mo_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK THEN */
14058: ELSIF l_mo_type IN (5,7)THEN -- wip picking bug 2924823 H to I
14059: UPDATE mtl_txn_request_lines
14060: SET quantity_detailed = quantity_delivered
14061: , line_status = 5

Line 14107: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN

14103: SET quantity_detailed = quantity_detailed - l_txn_qty,
14104: line_status = 5
14105: WHERE line_id = l_mo_line_id;
14106: end if;
14107: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
14108: UPDATE mtl_txn_request_lines
14109: SET quantity_detailed = quantity_delivered
14110: WHERE line_id = l_mo_line_id;
14111:

Line 14127: IF (l_kill_mo_profile = 1) and (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN

14123: RAISE fnd_api.g_exc_error;
14124: END IF;
14125:
14126: /* 3926046 */
14127: IF (l_kill_mo_profile = 1) and (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
14128:
14129: IF (l_debug = 1) THEN
14130: mydebug('Replenishment Move Order... pending task count :'|| l_other_mmtt_count);
14131: mydebug('Replenishment Move Order... quantity delivered :'|| l_mol_qty_delivered);