DBA Data[Home] [Help]

APPS.WMS_WIP_INTEGRATION dependencies on INV_GLOBALS

Line 2776: (p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE AND

2772: );
2773: END IF;
2774:
2775: IF p_transaction_type_id IS NULL OR
2776: (p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE AND
2777: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN
2778: IF (l_debug = 1) THEN
2779: mydebug ('update_mmtt_for_wip:'||'Invalid transaction type: ' || to_char(p_transaction_type_id));
2780: END IF;

Line 2777: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN

2773: END IF;
2774:
2775: IF p_transaction_type_id IS NULL OR
2776: (p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE AND
2777: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN
2778: IF (l_debug = 1) THEN
2779: mydebug ('update_mmtt_for_wip:'||'Invalid transaction type: ' || to_char(p_transaction_type_id));
2780: END IF;
2781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2816: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

2812: END;
2813:
2814:
2815:
2816: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2817: THEN
2818:
2819: IF l_entity_type = 2 THEN
2820: IF p_repetitive_schedule_id IS NULL THEN

Line 2913: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

2909: RAISE;
2910: END;
2911: END IF; -- end if txn type is wip issue
2912:
2913: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2914: THEN
2915: UPDATE mtl_material_transactions_temp
2916: SET transaction_source_id = p_wip_entity_id
2917: , trx_source_line_id = p_operation_seq_num

Line 2920: , transaction_source_type_id = INV_Globals.G_SourceType_WIP

2916: SET transaction_source_id = p_wip_entity_id
2917: , trx_source_line_id = p_operation_seq_num
2918: , demand_source_header_id = p_wip_entity_id
2919: , demand_source_line = p_operation_seq_num
2920: , transaction_source_type_id = INV_Globals.G_SourceType_WIP
2921: , transaction_type_id = p_transaction_type_id
2922: , transaction_action_id = INV_Globals.G_Action_Issue
2923: , wip_entity_type = l_entity_type
2924: , repetitive_line_id = l_repetitive_line_id

Line 2922: , transaction_action_id = INV_Globals.G_Action_Issue

2918: , demand_source_header_id = p_wip_entity_id
2919: , demand_source_line = p_operation_seq_num
2920: , transaction_source_type_id = INV_Globals.G_SourceType_WIP
2921: , transaction_type_id = p_transaction_type_id
2922: , transaction_action_id = INV_Globals.G_Action_Issue
2923: , wip_entity_type = l_entity_type
2924: , repetitive_line_id = l_repetitive_line_id
2925: , operation_seq_num = p_operation_seq_num
2926: , department_id = l_department_id

Line 2945: ELSIF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN

2941: IF (l_debug = 1) THEN
2942: mydebug ('update_mmtt_for_wip:'||'Done updating mmtt rec ' || p_transaction_temp_id || ' for WIP Issue.');
2943: END IF;
2944:
2945: ELSIF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
2946: --
2947: -- Bug 2057540: explicitly set WIP_SUPPLY_TYPE to null
2948: --
2949: UPDATE mtl_material_transactions_temp

Line 2954: , transaction_source_type_id = INV_Globals.G_SourceType_Inventory

2950: SET transaction_source_id = p_wip_entity_id
2951: , trx_source_line_id = p_operation_seq_num
2952: , demand_source_header_id = p_wip_entity_id
2953: , demand_source_line = p_operation_seq_num
2954: , transaction_source_type_id = INV_Globals.G_SourceType_Inventory
2955: , transaction_type_id = p_transaction_type_id
2956: , transaction_action_id = INV_Globals.G_Action_Subxfr
2957: , wip_entity_type = l_entity_type
2958: , wip_supply_type = NULL

Line 2956: , transaction_action_id = INV_Globals.G_Action_Subxfr

2952: , demand_source_header_id = p_wip_entity_id
2953: , demand_source_line = p_operation_seq_num
2954: , transaction_source_type_id = INV_Globals.G_SourceType_Inventory
2955: , transaction_type_id = p_transaction_type_id
2956: , transaction_action_id = INV_Globals.G_Action_Subxfr
2957: , wip_entity_type = l_entity_type
2958: , wip_supply_type = NULL
2959: WHERE transaction_temp_id = p_transaction_temp_id;
2960: IF (l_debug = 1) THEN