APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_WAVE_EXCEPTIONS_B

Line 16380: update wms_wp_wave_exceptions_b

16376:
16377: IF (nvl(l_previous_trip, -999) = nvl(p_current_trip, -999) AND
16378: nvl(l_previous_delivery, -999) <> nvl(p_current_delivery, -999)) THEN
16379:
16380: update wms_wp_wave_exceptions_b
16381: set delivery_id = null,
16382: last_update_login = fnd_global.conc_login_id,
16383: last_updated_by = fnd_global.user_id,
16384: last_update_date = l_date

Line 16403: update wms_wp_wave_exceptions_b

16399: ELSIF (nvl(l_previous_trip, -999) <> nvl(p_current_trip, -999) AND
16400: nvl(l_previous_delivery, -999) <>
16401: nvl(p_current_delivery, -999)) THEN
16402:
16403: update wms_wp_wave_exceptions_b
16404: set trip_id = null,
16405: delivery_id = null,
16406: last_update_login = fnd_global.conc_login_id,
16407: last_updated_by = fnd_global.user_id,

Line 16478: update wms_wp_wave_exceptions_b

16474: ELSE
16475: IF (nvl(l_previous_trip, -999) = nvl(p_current_trip, -999) AND
16476: nvl(l_previous_delivery, -999) <> nvl(p_current_delivery, -999)) THEN
16477:
16478: update wms_wp_wave_exceptions_b
16479: set delivery_id = null,
16480: last_update_login = fnd_global.conc_login_id,
16481: last_updated_by = fnd_global.user_id,
16482: last_update_date = l_date

Line 16497: update wms_wp_wave_exceptions_b

16493: ELSIF (nvl(l_previous_trip, -999) <> nvl(p_current_trip, -999) AND
16494: nvl(l_previous_delivery, -999) <>
16495: nvl(p_current_delivery, -999)) THEN
16496:
16497: update wms_wp_wave_exceptions_b
16498: set trip_id = null,
16499: delivery_id = null,
16500: last_update_login = fnd_global.conc_login_id,
16501: last_updated_by = fnd_global.user_id,

Line 16711: UPDATE wms_wp_wave_exceptions_b

16707: (p_entity = 'Order' AND order_number = p_entity_value) OR
16708: (p_entity = 'Order Line' AND
16709: source_line_id = p_entity_value));
16710:
16711: UPDATE wms_wp_wave_exceptions_b
16712: SET exception_level = l_level,
16713: exception_msg = l_msg,
16714: ready_to_release = l_readytorelease,
16715: backordered = l_backordered,

Line 16780: UPDATE wms_wp_wave_exceptions_b

16776: l_debug);
16777:
16778: ELSE
16779:
16780: UPDATE wms_wp_wave_exceptions_b
16781: SET status = 'Closed',
16782: last_update_date = sysdate,
16783: last_updated_by = fnd_global.user_id,
16784: last_update_login = fnd_global.login_id

Line 16895: UPDATE wms_wp_wave_exceptions_b

16891:
16892: SELECT wms_WP_WAVE_exceptions_s.currval INTO l_seq_val FROM dual; -- Changed
16893: l_update_exception_id := l_seq_val; -- Changed
16894:
16895: UPDATE wms_wp_wave_exceptions_b
16896: SET ready_to_release = l_readytorelease,
16897: backordered = l_backordered,
16898: crossdock_planned = l_crossdocked,
16899: replenishment_planned = l_replenishment,

Line 17556: UPDATE wms_wp_wave_exceptions_b

17552: END IF;
17553:
17554: IF (p_release_back_ordered_lines = 'Yes' OR p_action_name IS NOT NULL) THEN
17555:
17556: UPDATE wms_wp_wave_exceptions_b
17557: SET status = 'Action Taken'
17558: WHERE exception_id = p_exception_id;
17559:
17560: update WMS_WP_WAVE_EXCEPTIONS_TL