APPS.WSH_PICK_LIST dependencies on WSH_DELIVERY_DETAILS_PKG

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

1134: l_rel_delivery_detail_id(l_count_x_relstatus_details):= WSH_PR_CRITERIA.release_table(i).delivery_detail_id;
1135: --}
1136: -- X-dock, X-dock lines which have been processed above
1137: -- will have released status of S
1138: ELSIF (WSH_PR_CRITERIA.release_table(i).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN --{
1139: IF l_debug_on THEN
1140: WSH_DEBUG_SV.logmsg(l_module_name,'IGNORING PLANNED X-DOCK LINE FOR MOVE ORDER LINE CREATION');
1141: END IF;
1142: --}

Line 1603: released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE,

1599: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE WITH TROLIN.LINE_ID ' || G_TROLIN_TBL(I).LINE_ID );
1600: END IF;
1601: UPDATE wsh_delivery_details
1602: SET move_order_line_id = g_trolin_tbl(i).line_id,
1603: released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE,
1604: batch_id = p_batch_id,
1605: last_updated_by = l_user_id,
1606: last_update_date = l_date,
1607: last_update_login = l_login_id,

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

3829: AND wdd.move_order_line_id = mtrl.line_id
3830: AND mtrl.header_id = mtrh.header_id
3831: AND mtrh.header_id = l_mo_header_id
3832: AND mtrh.move_order_type <> 6
3833: AND wdd.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE; -- auto pick confirm = 'N' for these lines
3834:
3835:
3836: CURSOR c_dels_in_batch(l_batch_id NUMBER, p_organization_id NUMBER) IS
3837: SELECT delivery_id