APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_NEW_DELIVERIES

Line 560: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

556: b_cc_linefailed boolean;
557: l_stop_id_tab_t wsh_util_core.id_tab_type;
558: l_cc_stop_id_tab wsh_util_core.id_tab_type;
559: l_cc_count_success NUMBER;
560: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
561: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
562: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
563: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
564: l_cc_in_ids wsh_util_core.id_tab_type;

Line 2332: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2328: l_msg_count NUMBER;
2329: l_msg_data VARCHAR2(2000);
2330:
2331: --dummy tables for calling validate_constraint_mainper
2332: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2333: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
2334: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2335: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2336: l_cc_in_ids wsh_util_core.id_tab_type;

Line 3889: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

3885: IS
3886: --
3887: CURSOR c_pickup_deliveries(p_stop_id NUMBER, p_stop_loc_id NUMBER) IS
3888: SELECT wnd.delivery_id
3889: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
3890: WHERE wnd.delivery_id = wdl.delivery_id
3891: AND wdl.pick_up_stop_id = p_stop_id
3892: AND wnd.initial_pickup_location_id = p_stop_loc_id;
3893: --

Line 3896: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

3892: AND wnd.initial_pickup_location_id = p_stop_loc_id;
3893: --
3894: CURSOR c_dropoff_deliveries(p_stop_id NUMBER, p_stop_loc_id NUMBER) IS
3895: SELECT wnd.delivery_id
3896: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
3897: WHERE wnd.delivery_id = wdl.delivery_id
3898: AND wdl.drop_off_stop_id = p_stop_id
3899: AND wnd.ultimate_dropoff_location_id = p_stop_loc_id;
3900: --

Line 3999: WSH_NEW_DELIVERIES_PVT.lock_dlvy_no_compare(

3995: FOR c_pickup_del_rec IN c_pickup_deliveries(p_stop_attr_tab(l_index).stop_id, l_stop_location_id)
3996: LOOP
3997: -- {
3998: -- lock delivery
3999: WSH_NEW_DELIVERIES_PVT.lock_dlvy_no_compare(
4000: p_delivery_id => c_pickup_del_rec.delivery_id
4001: );
4002: -- }
4003: END LOOP;

Line 4009: WSH_NEW_DELIVERIES_PVT.lock_dlvy_no_compare(

4005: FOR c_dropoff_del_rec IN c_dropoff_deliveries(p_stop_attr_tab(l_index).stop_id, l_stop_location_id)
4006: LOOP
4007: -- {
4008: -- lock delivery
4009: WSH_NEW_DELIVERIES_PVT.lock_dlvy_no_compare(
4010: p_delivery_id => c_dropoff_del_rec.delivery_id
4011: );
4012:
4013: -- }