[Home] [Help]
962:
963: IF p_serial_allocated_flag = 'Y' THEN
964: SELECT mtl_material_transactions_s.NEXTVAL
965: INTO l_serial_transaction_temp_id
966: FROM dual;
967: END IF;
968: END;
969:
970: IF (l_debug = 1) THEN
2033: , p_inventory_item_id => p_inventory_item_id
2034: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
2035: , p_is_revision_control => b_is_revision_control
2036: , p_is_lot_control => TRUE
2037: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2038: , p_demand_source_type_id => -9999
2039: , p_revision => NVL(p_revision, NULL)
2040: , p_lot_number => l_lot_number
2041: , p_subinventory_code => p_confirmed_sub
2066: , p_inventory_item_id => p_inventory_item_id
2067: , p_tree_mode => inv_quantity_tree_pub.g_loose_only_mode
2068: , p_is_revision_control => b_is_revision_control
2069: , p_is_lot_control => TRUE
2070: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2071: , p_demand_source_type_id => -9999
2072: , p_revision => NVL(p_revision, NULL)
2073: , p_lot_number => l_lot_number
2074: , p_subinventory_code => p_confirmed_sub
2244: , p_inventory_item_id => p_inventory_item_id
2245: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
2246: , p_is_revision_control => b_is_revision_control
2247: , p_is_lot_control => FALSE
2248: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2249: , p_demand_source_type_id => -9999
2250: , p_revision => NVL(p_revision, NULL)
2251: , p_lot_number => NULL
2252: , p_subinventory_code => p_confirmed_sub
2277: , p_inventory_item_id => p_inventory_item_id
2278: , p_tree_mode => inv_quantity_tree_pub.g_loose_only_mode
2279: , p_is_revision_control => b_is_revision_control
2280: , p_is_lot_control => FALSE
2281: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2282: , p_demand_source_type_id => -9999
2283: , p_revision => NVL(p_revision, NULL)
2284: , p_lot_number => NULL
2285: , p_subinventory_code => p_confirmed_sub
2607: IF p_insert = 'Y' THEN
2608: l_progress := '110';
2609: SELECT mtl_material_transactions_s.NEXTVAL
2610: INTO l_new_transaction_temp_id
2611: FROM DUAL;
2612: x_new_transaction_temp_id := l_new_transaction_temp_id;
2613:
2614: mydebug(l_proc_name || ': l_new_transaction_temp_id = ' || l_new_transaction_temp_id);
2615:
3724: END IF; --BUG12670785
3725:
3726: SELECT mtl_material_transactions_s.NEXTVAL
3727: INTO l_serial_transaction_temp_id
3728: FROM DUAL;
3729:
3730: ELSE
3731: l_serial_transaction_temp_id := NULL;
3732: l_mtlt_serial_temp_id := NULL;
4793:
4794: -- Start of code fix for Bug 14089430
4795: IF p_serial_number IS NULL AND p_lpn_id IS NOT NULL THEN
4796: BEGIN
4797: SELECT '1' INTO l_check FROM DUAL WHERE (SELECT Count(1) FROM mtl_serial_numbers
4798: WHERE inventory_item_id = p_inventory_item_id
4799: AND current_organization_id = p_organization_id
4800: AND NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@')
4801: AND lpn_id = p_lpn_id AND current_status = 3) = (SELECT Sum(primary_transaction_quantity) FROM mtl_onhand_quantities_detail
5794:
5795: l_serial_transaction_temp_id := NULL;
5796: SELECT mtl_material_transactions_s.NEXTVAL
5797: INTO l_serial_transaction_temp_id
5798: FROM DUAL;
5799: mydebug('l_serial_transaction_temp_id .. ' || l_serial_transaction_temp_id);
5800: IF p_suggested_uom <> rec_mmtt1.item_primary_uom_code
5801: THEN
5802: IF(p_suggested_uom = rec_mmtt1.SECONDARY_UOM_CODE) THEN
6750: mydebug('l_progress = ' || l_progress);
6751: BEGIN
6752: SELECT 1
6753: INTO l_other_tasks
6754: FROM DUAL
6755: WHERE EXISTS(SELECT 1
6756: FROM mtl_material_transactions_temp
6757: WHERE transaction_header_id <> p_transaction_header_id
6758: AND transfer_lpn_id = rec_transfer_lpns.transfer_lpn_id);
6808: mydebug('l_progress = ' || l_progress);
6809: BEGIN
6810: SELECT 1
6811: INTO l_other_tasks
6812: FROM DUAL
6813: WHERE EXISTS(SELECT 1
6814: FROM mtl_material_transactions_temp
6815: WHERE transaction_header_id <> p_transaction_header_id
6816: AND content_lpn_id = rec_content_lpns.content_lpn_id);
8687: -- this check should not be restricted to that particular transaction header id
8688:
8689: SELECT 1
8690: INTO l_loaded
8691: FROM DUAL
8692: WHERE EXISTS(SELECT 1
8693: FROM mtl_material_transactions_temp
8694: WHERE (transfer_lpn_id = p_fromlpn_id
8695: OR content_lpn_id = p_fromlpn_id)
8884:
8885: BEGIN
8886: SELECT 1
8887: INTO l_item_cnt
8888: FROM DUAL
8889: WHERE EXISTS(
8890: SELECT 1
8891: FROM wms_lpn_contents wlc
8892: WHERE wlc.parent_lpn_id = p_fromlpn_id
8914:
8915: BEGIN
8916: SELECT 1
8917: INTO l_item_cnt
8918: FROM DUAL
8919: WHERE EXISTS( SELECT 1
8920: FROM wms_lpn_contents wlc
8921: WHERE wlc.parent_lpn_id = p_fromlpn_id
8922: AND wlc.organization_id = p_org_id
12052: l_is_revision_control VARCHAR2(1);
12053: l_is_serial_control VARCHAR2(1);
12054:
12055: l_transfer_subinventory VARCHAR2(10) := NULL; -- Bug #7257709
12056: l_dual_uom_item BOOLEAN := FALSE; --MUOM
12057: l_fulfillment_base VARCHAR2(1) := p_fulfillment_base; --MUOM
12058:
12059: CURSOR lot_csr IS
12060: SELECT mtlt.primary_quantity
12221: --/* Bug 9448490 Lot Substitution Project */ end
12222:
12223: IF inv_cache.set_item_rec(p_org_id,p_item_id) THEN
12224: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
12225: l_dual_uom_item := TRUE;
12226: IF (l_debug = 1) THEN
12227: mydebug('Item is dual UOM');
12228: END IF;
12229: ELSE
12223: IF inv_cache.set_item_rec(p_org_id,p_item_id) THEN
12224: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
12225: l_dual_uom_item := TRUE;
12226: IF (l_debug = 1) THEN
12227: mydebug('Item is dual UOM');
12228: END IF;
12229: ELSE
12230: l_dual_uom_item := FALSE;
12231: IF (l_debug = 1) THEN
12226: IF (l_debug = 1) THEN
12227: mydebug('Item is dual UOM');
12228: END IF;
12229: ELSE
12230: l_dual_uom_item := FALSE;
12231: IF (l_debug = 1) THEN
12232: mydebug('Item is NOT dual UOM');
12233: END IF;
12234: END IF;
12228: END IF;
12229: ELSE
12230: l_dual_uom_item := FALSE;
12231: IF (l_debug = 1) THEN
12232: mydebug('Item is NOT dual UOM');
12233: END IF;
12234: END IF;
12235: ELSE
12236: IF (l_debug = 1) THEN
12367: END IF;
12368: END IF;--}
12369:
12370:
12371: IF l_dual_uom_item THEN
12372: l_att_trx_sec_qty := l_satt; -- Bug #4141928
12373: l_trx_sec_qoh := l_sqoh; -- Bug #4141928
12374: END IF;
12375:
13386: -- program can come to here which means the LPN is not pregenerated LPN
13387: BEGIN
13388: select 'N'
13389: into l_multiple_pick
13390: from dual
13391: where exists (select 1
13392: from mtl_material_transactions_temp
13393: where transfer_lpn_id = pick_to_lpn_rec.lpn_id
13394: and transaction_header_id <>l_transaction_header_id);
13403: ELSE -- regular task but maybe the lpn has contains bulk tasks
13404: BEGIN
13405: select 'Y'
13406: into l_bulk_task_exist
13407: from dual
13408: where exists (select 1
13409: from mtl_material_transactions_temp
13410: where transfer_lpn_id = pick_to_lpn_rec.lpn_id
13411: and transaction_temp_id = parent_line_id -- bulk task
13570: l_count := 0;
13571: BEGIN
13572: SELECT 1
13573: INTO l_count
13574: FROM DUAL
13575: WHERE EXISTS
13576: ( SELECT 'x'
13577: FROM mtl_material_transactions_temp mmtt
13578: , mtl_secondary_inventories msi
14306: IF p_serial_transaction_temp_id IS NULL THEN
14307:
14308: SELECT mtl_material_transactions_s.NEXTVAL
14309: INTO p_serial_transaction_temp_id
14310: FROM DUAL;
14311:
14312: l_progress := '50';
14313:
14314: UPDATE mtl_transaction_lots_temp