APPS.GMI_RESERVATION_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 3011: From wsh_delivery_details

3007: and lot_id <> 0
3008: and doc_type = 'OMSO'
3009: and line_detail_id in
3010: (Select delivery_detail_id
3011: From wsh_delivery_details
3012: Where move_order_line_id = p_mo_line_id);
3013: ELSIF ((l_ic_item_mst_rec.loct_ctl * l_whse_ctl) <> 0 )
3014: THEN
3015: SELECT SUM(ABS(TRANS_QTY)), SUM(ABS(TRANS_QTY2))

Line 3026: From wsh_delivery_details

3022: and location <> GMI_Reservation_Util.G_DEFAULT_LOCT
3023: and doc_type = 'OMSO'
3024: and line_detail_id in
3025: (Select delivery_detail_id
3026: From wsh_delivery_details
3027: Where move_order_line_id = p_mo_line_id);
3028: ELSE
3029: SELECT SUM(ABS(TRANS_QTY)), SUM(ABS(TRANS_QTY2))
3030: INTO l_NEW_ALLOCATED_QTY, l_NEW_ALLOCATED_QTY2

Line 4620: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;

4616: l_new_trans_id ic_tran_pnd.trans_id%TYPE;
4617: l_item_id ic_tran_pnd.item_id%TYPE;
4618: l_location ic_tran_pnd.location%TYPE;
4619: l_lot_id ic_tran_pnd.lot_id%TYPE;
4620: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
4621: l_new_delivery_detail_id NUMBER;
4622: l_source_line_id NUMBER;
4623: l_fulfilled_qty NUMBER;
4624: l_qty_to_fulfil NUMBER;

Line 5015: -- there are no records in wsh_delivery_details

5011:
5012: -- Update staged_ind
5013: l_old_transaction_rec.staged_ind :=1;
5014: -- Make the Bill-To transactions unique so subledger can identify them since
5015: -- there are no records in wsh_delivery_details
5016: l_old_transaction_rec.line_detail_id := -999;
5017: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
5018: (
5019: p_api_version => 1

Line 5322: -- WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action

5318:
5319:
5320: -- HW Added for bug#2677054 - WSH.I project
5321: -- This rotine will be called from WSH Group API
5322: -- WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action
5323: -- to check if line is allocated to lot_indivisble or not
5324:
5325:
5326: PROCEDURE is_line_allocated (

Line 5477: -- WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail

5473: END is_line_allocated;
5474:
5475: -- PK Added for bug#3055126 - WSH.J
5476: -- This rotine will be called from WSH Group API
5477: -- WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail
5478: -- If this group layer API is called from public API
5479: -- WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
5480: -- Actual call is from WSHDDGPB.pls PROCEDURE Validate_Delivery_Detail
5481: -- This procedure checks if quantity1 and quantity2 ( Shipped or Cycle Count0

Line 5479: -- WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes

5475: -- PK Added for bug#3055126 - WSH.J
5476: -- This rotine will be called from WSH Group API
5477: -- WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail
5478: -- If this group layer API is called from public API
5479: -- WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
5480: -- Actual call is from WSHDDGPB.pls PROCEDURE Validate_Delivery_Detail
5481: -- This procedure checks if quantity1 and quantity2 ( Shipped or Cycle Count0
5482: -- are within tolerance and can raise these exceptions.
5483: -- 1) Required quantity not populated