APPS.WSH_PICKING_BATCHES_GRP dependencies on WSH_DELIVERY_DETAILS

Line 146: FROM wsh_delivery_details

142: AND set_type = 'SHIP_SET';
143:
144: CURSOR Check_Delivery_Detail_Id(p_delivery_detail_id IN NUMBER) IS
145: SELECT delivery_detail_id
146: FROM wsh_delivery_details
147: WHERE delivery_detail_id = p_delivery_detail_id
148: AND container_flag IN ('N','Y'); -- R12 MDC
149:
150: CURSOR Check_Item_Id( p_item_id IN NUMBER,p_organization_id IN NUMBER) IS

Line 3253: FROM wsh_delivery_details wdd,

3249: ) IS
3250:
3251: CURSOR c_get_dds_for_wave (c_pick_wave_header_id NUMBER) IS
3252: SELECT wdd.delivery_detail_id
3253: FROM wsh_delivery_details wdd,
3254: wms_wp_wave_lines wpl,
3255: wms_wp_wave_headers_vl wph
3256: WHERE wdd.delivery_detail_id = wpl.delivery_detail_id
3257: AND wpl.wave_header_id = c_pick_wave_header_id

Line 3354: WSH_DELIVERY_DETAILS_PKG.lock_detail_no_compare(p_delivery_detail_id => l_dd_tbl(i));

3350: EXIT WHEN ( l_cur_fetch <= 0);
3351: FOR i in 1..l_dd_tbl.COUNT LOOP
3352: BEGIN
3353: savepoint lock_delivery_detail_loop;
3354: WSH_DELIVERY_DETAILS_PKG.lock_detail_no_compare(p_delivery_detail_id => l_dd_tbl(i));
3355: l_dd_upd_tbl(l_dd_upd_tbl.COUNT + 1) := l_dd_tbl(i);
3356: EXCEPTION
3357: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
3358: rollback to lock_delivery_detail_loop;

Line 3376: UPDATE wsh_delivery_details

3372: --
3373: END LOOP;
3374: --Update the detail lines with batch id.
3375: FORALL i in 1..l_dd_upd_tbl.count
3376: UPDATE wsh_delivery_details
3377: SET batch_id = l_batch_id,
3378: last_updated_by = fnd_global.user_id,
3379: last_update_date = SYSDATE,
3380: last_update_login = fnd_global.login_id