[Home] [Help]
477: l_cc_count_success NUMBER;
478: b_cc_linefailed BOOLEAN;
479:
480: --dummy tables for calling validate_constraint_wrapper
481: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
482: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
484: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
485: l_cc_in_ids wsh_util_core.id_tab_type;
499: IS
500: SELECT wdl.delivery_id, wt.name
501: FROM wsh_trip_stops wts,
502: wsh_Delivery_legs wdl,
503: wsh_new_deliveries wnd,
504: wsh_trips wt
505: WHERE wt.trip_id = p_trip_id
506: AND wts.trip_id = p_trip_id
507: AND wdl.pick_up_stop_id = wts.stop_id
2408: l_cc_count_success NUMBER;
2409: b_cc_linefailed BOOLEAN;
2410:
2411: --dummy tables for calling validate_constraint_wrapper
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2418:
2419: --Compatibility Changes
2420: CURSOR c_getorgcarriersmc (p_tripid NUMBER) IS
2421: SELECT wnd.organization_id, wnd.name, wt.ship_method_code, wt.carrier_id
2422: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt
2423: WHERE wnd.delivery_id=wdl.delivery_id
2424: and wdl.pick_up_stop_id=wts.stop_id
2425: and wt.trip_id = p_tripid
2426: and wt.trip_id=wts.trip_id
2427: and wt.ignore_for_planning<>'Y'
2428: and rownum=1;
2429:
2430: l_wh_type VARCHAR2(3);
2431: l_organization_id wsh_new_deliveries.organization_id%TYPE;
2432: l_smc wsh_trips.ship_method_code%TYPE;
2433: l_carrier_id wsh_trips.carrier_id%TYPE;
2434: l_param_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2435: l_autofirm_loadtender_trip Varchar2(10) := null;