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 13731: IF (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE) THEN

13727: /* OPEN c_mo_line_info;
13728: 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;
13729: CLOSE c_mo_line_info;
13730: */
13731: IF (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE) THEN
13732: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
13733:
13734: /*bug3139307 suggest_alternate_location API in wms_txnrsn_actions_pub
13735: would call INV_Replenish_Detail_PUB.Line_Details_PUB . When there is

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

13800: END IF;
13801: RAISE fnd_api.g_exc_error;
13802: END IF;
13803: END IF; --bug3139307 bug 2924823 H to I
13804: /* IF l_mo_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK THEN */
13805: ELSIF l_mo_type IN (5,7)THEN -- wip picking bug 2924823 H to I
13806: UPDATE mtl_txn_request_lines
13807: SET quantity_detailed = quantity_delivered
13808: , line_status = 5

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

13850: SET quantity_detailed = quantity_detailed - l_txn_qty,
13851: line_status = 5
13852: WHERE line_id = l_mo_line_id;
13853: end if;
13854: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
13855: UPDATE mtl_txn_request_lines
13856: SET quantity_detailed = quantity_delivered
13857: WHERE line_id = l_mo_line_id;
13858:

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

13870: RAISE fnd_api.g_exc_error;
13871: END IF;
13872:
13873: /* 3926046 */
13874: IF (l_kill_mo_profile = 1) and (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
13875:
13876: IF (l_debug = 1) THEN
13877: mydebug('Replenishment Move Order... pending task count :'|| l_other_mmtt_count);
13878: mydebug('Replenishment Move Order... quantity delivered :'|| l_mol_qty_delivered);