APPS.WSH_PICK_LIST dependencies on WSH_DELIVERY_DETAILS_PKG

Line 1164: ELSIF (WSH_PR_CRITERIA.release_table(i).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN --{

1160: l_rel_delivery_detail_id(l_count_x_relstatus_details):= WSH_PR_CRITERIA.release_table(i).delivery_detail_id;
1161: --}
1162: -- X-dock, X-dock lines which have been processed above
1163: -- will have released status of S
1164: ELSIF (WSH_PR_CRITERIA.release_table(i).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN --{
1165: IF l_debug_on THEN
1166: WSH_DEBUG_SV.logmsg(l_module_name,'IGNORING PLANNED X-DOCK LINE FOR MOVE ORDER LINE CREATION');
1167: END IF;
1168: --}

Line 1664: released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE,

1660: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE WITH TROLIN.LINE_ID ' || G_TROLIN_TBL(I).LINE_ID );
1661: END IF;
1662: UPDATE wsh_delivery_details
1663: SET move_order_line_id = g_trolin_tbl(i).line_id,
1664: released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE,
1665: batch_id = p_batch_id,
1666: last_updated_by = l_user_id,
1667: last_update_date = l_date,
1668: last_update_login = l_login_id,

Line 3923: AND wdd.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE; -- auto pick confirm = 'N' for these lines

3919: AND wdd.move_order_line_id = mtrl.line_id
3920: AND mtrl.header_id = mtrh.header_id
3921: AND mtrh.header_id = l_mo_header_id
3922: AND mtrh.move_order_type <> 6
3923: AND wdd.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE; -- auto pick confirm = 'N' for these lines
3924:
3925:
3926: CURSOR c_dels_in_batch(l_batch_id NUMBER, p_organization_id NUMBER) IS
3927: SELECT delivery_id