[Home] [Help]
17: TYPE Consolidation_Rec IS RECORD(
18: consol_index NUMBER,
19: total_weight NUMBER,
20: weight_uom VARCHAR2(3),
21: delivery_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type
22: );
23:
24:
25: --========================================================================
52: -- trip. The procedure makes sure that max weight for consolidation
53: -- is not exceeded.
54: --========================================================================
55: PROCEDURE Add_For_Consolidation(
56: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
57: p_del_weight IN NUMBER,
58: p_weight_uom IN VARCHAR2,
59: p_max_weight IN NUMBER,
60: p_ignore_weight IN BOOLEAN,
71: --
72: -- COMMENT : This function takes delivery records of types
73: -- WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type and
74: -- WSH_MDC_SRS.addnl_del_attr_rec_type and copies the information
75: -- to a record of type WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
76: -- and returns it.
77: --========================================================================
78: FUNCTION Copy_Record(
79: p_del_ccinfo_rec IN WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,
77: --========================================================================
78: FUNCTION Copy_Record(
79: p_del_ccinfo_rec IN WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,
80: p_del_addnl_rec IN addnl_del_attr_rec_type)
81: RETURN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
82: IS
83: x_delivery_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
84: BEGIN
85:
79: p_del_ccinfo_rec IN WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,
80: p_del_addnl_rec IN addnl_del_attr_rec_type)
81: RETURN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
82: IS
83: x_delivery_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
84: BEGIN
85:
86: x_delivery_rec.delivery_id := p_del_ccinfo_rec.delivery_id;
87: x_delivery_rec.name := p_del_ccinfo_rec.name;
156: l_group_tab grp_attr_tab_type;
157: l_del_index NUMBER;
158: l_cont_cnt NUMBER;
159: l_trip_id NUMBER;
160: l_unassign_trip_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
161: l_action_params WSH_DELIVERIES_GRP.action_parameters_rectype;
162: l_rating_in_param_rec WSH_FTE_INTEGRATION.rate_del_in_param_rec;
163: l_rating_out_param_rec WSH_FTE_INTEGRATION.rate_del_out_param_rec;
164: l_consol_trip_id WSH_UTIL_CORE.id_tab_type;
2240: l_del_tab_grp WSH_UTIL_CORE.id_tab_type;
2241: l_d_id NUMBER;
2242: l_del_weight NUMBER;
2243: l_failed_index NUMBER;
2244: l_del_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2245: l_action_params WSH_DELIVERIES_GRP.Action_Parameters_Rectype;
2246: l_consol_tab consolidation_tab;
2247: l_init_msg_list VARCHAR2(1000);
2248: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2591: l_unplan_rec_attr WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3116: END IF;
3117: END Create_Deconsol_Trips;
3118:
3119: PROCEDURE Add_For_Consolidation(
3120: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
3121: p_del_weight IN NUMBER,
3122: p_weight_uom IN VARCHAR2,
3123: p_max_weight IN NUMBER,
3124: p_ignore_weight IN BOOLEAN,