DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_NEW_DELIVERIES_PVT

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 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: -- }