APPS.GMI_RESERVATION_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 3023: From wsh_delivery_details

3019: and lot_id <> 0
3020: and doc_type = 'OMSO'
3021: and line_detail_id in
3022: (Select delivery_detail_id
3023: From wsh_delivery_details
3024: Where move_order_line_id = p_mo_line_id);
3025: ELSIF ((l_ic_item_mst_rec.loct_ctl * l_whse_ctl) <> 0 )
3026: THEN
3027: SELECT SUM(ABS(TRANS_QTY)), SUM(ABS(TRANS_QTY2))

Line 3038: From wsh_delivery_details

3034: and location <> GMI_Reservation_Util.G_DEFAULT_LOCT
3035: and doc_type = 'OMSO'
3036: and line_detail_id in
3037: (Select delivery_detail_id
3038: From wsh_delivery_details
3039: Where move_order_line_id = p_mo_line_id);
3040: ELSE
3041: SELECT SUM(ABS(TRANS_QTY)), SUM(ABS(TRANS_QTY2))
3042: INTO l_NEW_ALLOCATED_QTY, l_NEW_ALLOCATED_QTY2

Line 4632: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;

4628: l_new_trans_id ic_tran_pnd.trans_id%TYPE;
4629: l_item_id ic_tran_pnd.item_id%TYPE;
4630: l_location ic_tran_pnd.location%TYPE;
4631: l_lot_id ic_tran_pnd.lot_id%TYPE;
4632: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
4633: l_new_delivery_detail_id NUMBER;
4634: l_source_line_id NUMBER;
4635: l_fulfilled_qty NUMBER;
4636: l_qty_to_fulfil NUMBER;

Line 5027: -- there are no records in wsh_delivery_details

5023:
5024: -- Update staged_ind
5025: l_old_transaction_rec.staged_ind :=1;
5026: -- Make the Bill-To transactions unique so subledger can identify them since
5027: -- there are no records in wsh_delivery_details
5028: l_old_transaction_rec.line_detail_id := -999;
5029: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
5030: (
5031: p_api_version => 1

Line 5334: -- WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action

5330:
5331:
5332: -- HW Added for bug#2677054 - WSH.I project
5333: -- This rotine will be called from WSH Group API
5334: -- WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action
5335: -- to check if line is allocated to lot_indivisble or not
5336:
5337:
5338: PROCEDURE is_line_allocated (

Line 5489: -- WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail

5485: END is_line_allocated;
5486:
5487: -- PK Added for bug#3055126 - WSH.J
5488: -- This rotine will be called from WSH Group API
5489: -- WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail
5490: -- If this group layer API is called from public API
5491: -- WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
5492: -- Actual call is from WSHDDGPB.pls PROCEDURE Validate_Delivery_Detail
5493: -- This procedure checks if quantity1 and quantity2 ( Shipped or Cycle Count0

Line 5491: -- WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes

5487: -- PK Added for bug#3055126 - WSH.J
5488: -- This rotine will be called from WSH Group API
5489: -- WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail
5490: -- If this group layer API is called from public API
5491: -- WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
5492: -- Actual call is from WSHDDGPB.pls PROCEDURE Validate_Delivery_Detail
5493: -- This procedure checks if quantity1 and quantity2 ( Shipped or Cycle Count0
5494: -- are within tolerance and can raise these exceptions.
5495: -- 1) Required quantity not populated