APPS.WSH_TP_RELEASE_INT dependencies on WSH_DEL_ASSGN_INTERFACE

Line 697: wsh_del_assgn_interface wdai

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

Line 709: -- Purge wsh_del_assgn_interface

705: and wdai.delivery_interface_id is not null
706: and wdai.interface_action_code = G_TP_RELEASE_CODE)
707: and wddi.interface_action_code = G_TP_RELEASE_CODE;
708:
709: -- Purge wsh_del_assgn_interface
710:
711: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
712: delete from wsh_del_assgn_interface wdai
713: where wdai.delivery_interface_id in (

Line 712: delete from wsh_del_assgn_interface wdai

708:
709: -- Purge wsh_del_assgn_interface
710:
711: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
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,

Line 996: wsh_del_assgn_interface wdai,

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
1000: and wti.trip_interface_id = wtsi.trip_interface_id

Line 1127: wsh_del_assgn_interface wdai,

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
1131: and wti.trip_interface_id = wtsi.trip_interface_id

Line 1595: wsh_del_assgn_interface wdai,

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
1598: AND wti.interface_action_code = G_TP_RELEASE_CODE
1599: AND wti.trip_interface_id = wtsi.trip_interface_id

Line 7883: FROM wsh_del_assgn_interface wdai,

7879: -- count containers in plan
7880: -- currently, TP captures all LPNs within the delivery.
7881: CURSOR c_plan_lpn_count(x_delivery_interface_id IN NUMBER) IS
7882: SELECT count(wddi.delivery_detail_id)
7883: FROM wsh_del_assgn_interface wdai,
7884: wsh_del_details_interface wddi
7885: WHERE wdai.delivery_interface_id = x_delivery_interface_id
7886: AND wdai.delivery_interface_id IS NOT NULL
7887: AND wdai.interface_action_code = G_TP_RELEASE_CODE

Line 7896: FROM wsh_del_assgn_interface wdai,

7892: -- verify that this TE container is mentioned in plan
7893: CURSOR c_plan_lpn(x_delivery_interface_id IN NUMBER,
7894: x_delivery_detail_id IN NUMBER) IS
7895: SELECT wddi.delivery_detail_interface_id
7896: FROM wsh_del_assgn_interface wdai,
7897: wsh_del_details_interface wddi
7898: WHERE wdai.delivery_interface_id = x_delivery_interface_id
7899: AND wdai.delivery_interface_id IS NOT NULL
7900: AND wdai.interface_action_code = G_TP_RELEASE_CODE