APPS.GMI_PICK_RELEASE_UTIL dependencies on WSH_INV_DELIVERY_DETAILS_V

Line 43: , x_inv_delivery_details OUT NOCOPY WSH_INV_DELIVERY_DETAILS_V%ROWTYPE

39: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_Pick_Release_Util';
40:
41: PROCEDURE Get_Delivery_Details
42: ( p_mo_line_id IN NUMBER
43: , x_inv_delivery_details OUT NOCOPY WSH_INV_DELIVERY_DETAILS_V%ROWTYPE
44: , x_return_status OUT NOCOPY VARCHAR2
45: , x_msg_count OUT NOCOPY NUMBER
46: , x_msg_data OUT NOCOPY VARCHAR2
47: ) IS

Line 57: FROM wsh_inv_delivery_details_v

53:
54: -- Bug 1805216, added NOT NULL in the cursor.
55: CURSOR c_delivery( mo_line_id IN NUMBER) IS
56: SELECT *
57: FROM wsh_inv_delivery_details_v
58: WHERE move_order_line_id = mo_line_id
59: AND move_order_line_id IS NOT NULL
60: AND released_status = 'S';
61:

Line 113: , p_inv_delivery_details IN WSH_INV_DELIVERY_DETAILS_V%ROWTYPE

109: END Get_Delivery_Details;
110:
111: PROCEDURE Create_Pick_Slip_and_Print
112: ( p_mo_line_rec IN GMI_Move_Order_Global.mo_line_rec
113: , p_inv_delivery_details IN WSH_INV_DELIVERY_DETAILS_V%ROWTYPE
114: , p_pick_slip_mode IN VARCHAR2
115: , p_grouping_rule_id IN NUMBER
116: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
117: , x_return_status OUT NOCOPY VARCHAR2

Line 421: l_demand_info WSH_INV_DELIVERY_DETAILS_V%ROWTYPE;

417: FROM ic_txn_request_headers
418: WHERE HEADER_ID = p_header_id;
419:
420: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
421: l_demand_info WSH_INV_DELIVERY_DETAILS_V%ROWTYPE;
422: l_print_mode VARCHAR2(1);
423: l_grouping_rule_id NUMBER;
424: l_dummy VARCHAR2(30);
425: l_trans_id NUMBER;