DBA Data[Home] [Help]

APPS.WMS_WIP_INTEGRATION dependencies on INV_GLOBALS

Line 2746: (p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE AND

2742: );
2743: END IF;
2744:
2745: IF p_transaction_type_id IS NULL OR
2746: (p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE AND
2747: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN
2748: IF (l_debug = 1) THEN
2749: mydebug ('update_mmtt_for_wip:'||'Invalid transaction type: ' || to_char(p_transaction_type_id));
2750: END IF;

Line 2747: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN

2743: END IF;
2744:
2745: IF p_transaction_type_id IS NULL OR
2746: (p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE AND
2747: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN
2748: IF (l_debug = 1) THEN
2749: mydebug ('update_mmtt_for_wip:'||'Invalid transaction type: ' || to_char(p_transaction_type_id));
2750: END IF;
2751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2786: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

2782: END;
2783:
2784:
2785:
2786: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2787: THEN
2788:
2789: IF l_entity_type = 2 THEN
2790: IF p_repetitive_schedule_id IS NULL THEN

Line 2883: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

2879: RAISE;
2880: END;
2881: END IF; -- end if txn type is wip issue
2882:
2883: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2884: THEN
2885: UPDATE mtl_material_transactions_temp
2886: SET transaction_source_id = p_wip_entity_id
2887: , trx_source_line_id = p_operation_seq_num

Line 2890: , transaction_source_type_id = INV_Globals.G_SourceType_WIP

2886: SET transaction_source_id = p_wip_entity_id
2887: , trx_source_line_id = p_operation_seq_num
2888: , demand_source_header_id = p_wip_entity_id
2889: , demand_source_line = p_operation_seq_num
2890: , transaction_source_type_id = INV_Globals.G_SourceType_WIP
2891: , transaction_type_id = p_transaction_type_id
2892: , transaction_action_id = INV_Globals.G_Action_Issue
2893: , wip_entity_type = l_entity_type
2894: , repetitive_line_id = l_repetitive_line_id

Line 2892: , transaction_action_id = INV_Globals.G_Action_Issue

2888: , demand_source_header_id = p_wip_entity_id
2889: , demand_source_line = p_operation_seq_num
2890: , transaction_source_type_id = INV_Globals.G_SourceType_WIP
2891: , transaction_type_id = p_transaction_type_id
2892: , transaction_action_id = INV_Globals.G_Action_Issue
2893: , wip_entity_type = l_entity_type
2894: , repetitive_line_id = l_repetitive_line_id
2895: , operation_seq_num = p_operation_seq_num
2896: , department_id = l_department_id

Line 2915: ELSIF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN

2911: IF (l_debug = 1) THEN
2912: mydebug ('update_mmtt_for_wip:'||'Done updating mmtt rec ' || p_transaction_temp_id || ' for WIP Issue.');
2913: END IF;
2914:
2915: ELSIF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
2916: --
2917: -- Bug 2057540: explicitly set WIP_SUPPLY_TYPE to null
2918: --
2919: UPDATE mtl_material_transactions_temp

Line 2924: , transaction_source_type_id = INV_Globals.G_SourceType_Inventory

2920: SET transaction_source_id = p_wip_entity_id
2921: , trx_source_line_id = p_operation_seq_num
2922: , demand_source_header_id = p_wip_entity_id
2923: , demand_source_line = p_operation_seq_num
2924: , transaction_source_type_id = INV_Globals.G_SourceType_Inventory
2925: , transaction_type_id = p_transaction_type_id
2926: , transaction_action_id = INV_Globals.G_Action_Subxfr
2927: , wip_entity_type = l_entity_type
2928: , wip_supply_type = NULL

Line 2926: , transaction_action_id = INV_Globals.G_Action_Subxfr

2922: , demand_source_header_id = p_wip_entity_id
2923: , demand_source_line = p_operation_seq_num
2924: , transaction_source_type_id = INV_Globals.G_SourceType_Inventory
2925: , transaction_type_id = p_transaction_type_id
2926: , transaction_action_id = INV_Globals.G_Action_Subxfr
2927: , wip_entity_type = l_entity_type
2928: , wip_supply_type = NULL
2929: WHERE transaction_temp_id = p_transaction_temp_id;
2930: IF (l_debug = 1) THEN