[Home] [Help]
691: delete from wsh_del_details_interface wddi
692: where wddi.delivery_detail_interface_id in (
693: select wdai.delivery_detail_interface_id
694: from wsh_trips_interface wti,
695: wsh_trip_stops_interface wtsi,
696: wsh_del_legs_interface wdli,
697: wsh_del_assgn_interface wdai
698: where wti.group_id = p_group_ids(i)
699: and wti.trip_interface_id = wtsi.trip_interface_id
712: delete from wsh_del_assgn_interface wdai
713: where wdai.delivery_interface_id in (
714: select wdli.delivery_interface_id
715: from wsh_trips_interface wti,
716: wsh_trip_stops_interface wtsi,
717: wsh_del_legs_interface wdli
718: where wti.group_id = p_group_ids(i)
719: and wti.trip_interface_id = wtsi.trip_interface_id
720: and wti.interface_action_code = G_TP_RELEASE_CODE
730: delete from wsh_new_del_interface wndi
731: where wndi.delivery_interface_id in (
732: select wdli.delivery_interface_id
733: from wsh_trips_interface wti,
734: wsh_trip_stops_interface wtsi,
735: wsh_del_legs_interface wdli
736: where wti.group_id = p_group_ids(i)
737: and wti.trip_interface_id = wtsi.trip_interface_id
738: and wti.interface_action_code = G_TP_RELEASE_CODE
747: delete from wsh_del_legs_interface wdli
748: where wdli.pick_up_stop_interface_id in (
749: select wtsi.stop_interface_id
750: from wsh_trips_interface wti,
751: wsh_trip_stops_interface wtsi
752: where wti.group_id = p_group_ids(i)
753: and wti.trip_interface_id = wtsi.trip_interface_id
754: and wti.interface_action_code = G_TP_RELEASE_CODE
755: and wtsi.interface_action_code = G_TP_RELEASE_CODE)
754: and wti.interface_action_code = G_TP_RELEASE_CODE
755: and wtsi.interface_action_code = G_TP_RELEASE_CODE)
756: and wdli.interface_action_code = G_TP_RELEASE_CODE;
757:
758: -- Purge wsh_trip_stops_interface
759:
760: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
761: delete from wsh_trip_stops_interface wtsi
762: where wtsi.trip_interface_id in (
757:
758: -- Purge wsh_trip_stops_interface
759:
760: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
761: delete from wsh_trip_stops_interface wtsi
762: where wtsi.trip_interface_id in (
763: select wtsi.stop_interface_id
764: from wsh_trips_interface wti
765: where wti.group_id = p_group_ids(i)
990: wddi.source_line_id,
991: wddi.source_line_set_id,
992: wndi.tp_delivery_number
993: from wsh_trips_interface wti,
994: wsh_trip_stops_interface wtsi,
995: wsh_del_legs_interface wdli,
996: wsh_del_assgn_interface wdai,
997: wsh_del_details_interface wddi,
998: wsh_new_del_interface wndi
1121: -- Bug 4274651: It also checks for existence of cancelled lines.
1122: cursor c_tp_dangling_conts (p_group_id in number) is
1123: select wddi.delivery_detail_id
1124: from wsh_trips_interface wti,
1125: wsh_trip_stops_interface wtsi,
1126: wsh_del_legs_interface wdli,
1127: wsh_del_assgn_interface wdai,
1128: wsh_del_details_interface wddi,
1129: wsh_new_del_interface wndi
1588: wddi.src_requested_quantity_uom,
1589: wndi.delivery_id,
1590: wndi.delivery_interface_id
1591: FROM wsh_trips_interface wti,
1592: wsh_trip_stops_interface wtsi,
1593: wsh_del_legs_interface wdli,
1594: wsh_new_del_interface wndi,
1595: wsh_del_assgn_interface wdai,
1596: wsh_del_details_interface wddi
1681: wndi.pooled_ship_to_location_id,
1682: wndi.dock_code,
1683: wnd.wv_frozen_flag -- WV changes
1684: FROM wsh_trips_interface wti,
1685: wsh_trip_stops_interface wtsi,
1686: wsh_del_legs_interface wdli,
1687: wsh_new_del_interface wndi,
1688: wsh_new_deliveries wnd
1689: WHERE wti.group_id = p_group_id
1773: wtsi.departure_fill_percent,
1774: wtsi.wkend_layover_stops,
1775: wtsi.wkday_layover_stops,
1776: wtsi.shipments_type_flag
1777: FROM wsh_trip_stops_interface wtsi
1778: WHERE wtsi.trip_interface_id = p_trip_interface_id
1779: AND wtsi.interface_action_code = G_TP_RELEASE_CODE
1780: ORDER BY wtsi.stop_sequence_number
1781: ;
1882: wdli.pick_up_stop_interface_id,
1883: wdli.drop_off_stop_interface_id,
1884: wtsi_pu.trip_interface_id
1885: FROM wsh_del_legs_interface wdli,
1886: wsh_trip_stops_interface wtsi_pu
1887: WHERE wdli.delivery_interface_id = p_delivery_interface_id
1888: AND wdli.interface_action_code = G_TP_RELEASE_CODE
1889: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id
1890: AND wtsi_pu.interface_action_code = G_TP_RELEASE_CODE
3676: EXCEPTION
3677: WHEN OTHERS THEN
3678: stamp_interface_error(
3679: p_group_id => x_context.group_id,
3680: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',
3681: p_entity_interface_id => istop.stop_interface_id,
3682: p_message_name => 'WSH_TP_F_NO_LOCK_STOP',
3683: p_token_1_name => 'TRIP_NAME',
3684: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),
4126: EXCEPTION
4127: WHEN OTHERS THEN
4128: stamp_interface_error(
4129: p_group_id => x_context.group_id,
4130: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',
4131: p_entity_interface_id => x_plan_stops(l_stop_index).stop_interface_id,
4132: p_message_name => 'WSH_TP_F_NO_LOCK_STOP',
4133: p_token_1_name => 'TRIP_NAME',
4134: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),
5184: x_msg_data => l_msg_data,
5185: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab
5186: );
5187:
5188: l_interface_entity := 'WSH_TRIP_STOPS_INTERFACE';
5189: l_interface_id := x_plan_stops(l_index).stop_interface_id;
5190:
5191: wsh_util_core.api_post_call(
5192: p_return_status => l_return_status,
7436: WSH_DEBUG_SV.log(l_module_name, 'Bulk update stops: count', l_interface_ids.COUNT);
7437: END IF;
7438:
7439: FORALL i in 1..l_interface_ids.count
7440: UPDATE wsh_trip_stops_interface
7441: SET stop_id = l_ids(i)
7442: WHERE stop_interface_id = l_interface_ids(i);
7443:
7444: