[Home] [Help]
2844:
2845: -- All qty should be in the detail line uom.
2846: -- all allocations excludes the invisible move orders
2847: IF p_called_by = 'S' THEN
2848: gme_reservations_pvt.get_reserved_qty
2849: (p_mtl_dtl_rec => p_mtl_dtl_rec
2850: ,x_reserved_qty => l_reserved_qty
2851: ,x_return_status => l_return_status);
2852:
2865: || ' Calculated open qty for shortages is '
2866: || x_open_qty);
2867: END IF;
2868: ELSIF p_called_by = 'P' THEN
2869: gme_reservations_pvt.get_reserved_qty
2870: (p_mtl_dtl_rec => p_mtl_dtl_rec
2871: ,p_supply_sub_only => fnd_api.g_true
2872: ,x_reserved_qty => l_reserved_qty
2873: ,x_return_status => l_return_status);
2934: || ' Calculated open qty for picking is '
2935: || x_open_qty);
2936: END IF;
2937: ELSIF p_called_by = 'R' THEN
2938: gme_reservations_pvt.get_material_reservations
2939: (p_organization_id => p_mtl_dtl_rec.organization_id
2940: ,p_batch_id => p_mtl_dtl_rec.batch_id
2941: ,p_material_detail_id => p_mtl_dtl_rec.material_detail_id
2942: ,x_return_status => l_return_status
2963:
2964: -- Assess fully detailed (1) and part detailed (2) reservations
2965: /*Bug#7346653 commenting the below if condition as the open qty
2966: should not include the the already created high level reservation as this is
2967: causing the extra HLR to be created from the gme_reservations_pvt.auto_detail_line */
2968: /* IF (gme_reservations_pvt.reservation_fully_specified
2969: (p_reservation_rec => l_resv_tbl (i)
2970: ,p_item_location_control => l_item_loc_control
2971: ,p_item_restrict_locators => l_item_restrict_locators) in (1,2)) THEN */
2964: -- Assess fully detailed (1) and part detailed (2) reservations
2965: /*Bug#7346653 commenting the below if condition as the open qty
2966: should not include the the already created high level reservation as this is
2967: causing the extra HLR to be created from the gme_reservations_pvt.auto_detail_line */
2968: /* IF (gme_reservations_pvt.reservation_fully_specified
2969: (p_reservation_rec => l_resv_tbl (i)
2970: ,p_item_location_control => l_item_loc_control
2971: ,p_item_restrict_locators => l_item_restrict_locators) in (1,2)) THEN */
2972:
2969: (p_reservation_rec => l_resv_tbl (i)
2970: ,p_item_location_control => l_item_loc_control
2971: ,p_item_restrict_locators => l_item_restrict_locators) in (1,2)) THEN */
2972:
2973: gme_reservations_pvt.get_reservation_dtl_qty
2974: (p_reservation_rec => l_resv_tbl
2975: (i)
2976: ,p_uom_code => p_mtl_dtl_rec.dtl_um
2977: ,x_qty => l_temp_qty
4263: gme_debug.put_line ('Calling Query Reservation.');
4264: END IF;
4265:
4266: /* start ,Punit Kumar */
4267: gme_reservations_pvt.get_material_reservations
4268: (p_organization_id => l_material_detail_rec.organization_id
4269: ,p_batch_id => l_material_detail_rec.batch_id
4270: ,p_material_detail_id => l_material_detail_rec.material_detail_id
4271: ,x_return_status => l_return_status
4302: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4303: gme_debug.put_line ('Calling Delete Reservation.');
4304: END IF;
4305:
4306: gme_reservations_pvt.delete_reservation
4307: (p_reservation_id => l_rsv_array (j).reservation_id
4308: ,x_return_status => l_return_status);
4309:
4310: IF (NVL (g_debug, 0) IN
4337: || ' requirement_date: '
4338: || TO_CHAR (l_material_date, 'MM/DD/YYYY HH24:MI:SS') );
4339: END IF;
4340:
4341: gme_reservations_pvt.update_reservation
4342: (p_reservation_id => l_rsv_array (j).reservation_id
4343: ,p_revision => l_rsv_array (j).revision
4344: ,p_subinventory => l_rsv_array (j).subinventory_code
4345: ,p_locator_id => l_rsv_array (j).locator_id