APPS.WSH_TP_RELEASE_INT dependencies on WSH_DEL_LEGS_INTERFACE

Line 696: wsh_del_legs_interface wdli,

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
700: and wti.interface_action_code = G_TP_RELEASE_CODE

Line 717: wsh_del_legs_interface wdli

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
721: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id

Line 735: wsh_del_legs_interface wdli

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
739: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id

Line 744: -- Purge wsh_del_legs_interface

740: and wtsi.interface_action_code = G_TP_RELEASE_CODE
741: and wdli.interface_action_code = G_TP_RELEASE_CODE)
742: and wndi.interface_action_code = G_TP_RELEASE_CODE;
743:
744: -- Purge wsh_del_legs_interface
745:
746: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
747: delete from wsh_del_legs_interface wdli
748: where wdli.pick_up_stop_interface_id in (

Line 747: delete from wsh_del_legs_interface wdli

743:
744: -- Purge wsh_del_legs_interface
745:
746: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
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

Line 995: wsh_del_legs_interface wdli,

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
999: where wti.group_id = p_group_id

Line 1126: wsh_del_legs_interface wdli,

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
1130: where wti.group_id = p_group_id

Line 1593: wsh_del_legs_interface wdli,

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
1597: WHERE wti.group_id = p_group_id

Line 1686: wsh_del_legs_interface wdli,

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
1690: AND wti.interface_action_code = G_TP_RELEASE_CODE

Line 1885: FROM wsh_del_legs_interface wdli,

1881: wdli.delivery_leg_id,
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

Line 5906: l_interface_entity := 'WSH_DEL_LEGS_INTERFACE';

5902: x_return_status => l_return_status,
5903: x_msg_count => l_msg_count,
5904: x_msg_data => l_msg_data);
5905:
5906: l_interface_entity := 'WSH_DEL_LEGS_INTERFACE';
5907: l_interface_id := x_plan_legs(l_index).leg_interface_id;
5908: l_message_name := 'WSH_TP_F_ASSIGN_TRIP';
5909: wsh_util_core.api_post_call(
5910: p_return_status => l_return_status,