[Home] [Help]
390: -- Package global variables
391: --
392: -- holds the delivery information and is compatible with delivery action group api
393: -- is indexed by delivery_id
394: g_dlv_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
395: --
396: -- holds delivery leg information, indexed on delivery_leg_id
397: g_dlv_leg_tab dlv_leg_tab;
398: --
523: END api_post_call;
524: --
525: --
526: PROCEDURE load_dlv_rec (p_dlv_rec IN c_delivery%ROWTYPE,
527: x_dlv_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type)
528: IS
529: BEGIN
530: --
531: x_dlv_rec.DELIVERY_ID := p_dlv_rec.DELIVERY_ID;
646: PROCEDURE validate_delivery (p_delivery_id IN NUMBER,
647: x_return_code OUT NOCOPY NUMBER)
648: IS
649: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
650: l_dlv_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
651: c_dlv_rec c_delivery%ROWTYPE;
652:
653: c_carr_srv_rec c_carrier_services%ROWTYPE;
654: l_ship_method_code wsh_carrier_services.ship_method_code%type;
1724: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1725: l_return_status VARCHAR2(1);
1726: l_return_status_1 VARCHAR2(1);
1727: --
1728: l_dlv_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1729: l_leg_trip_det_rec trip_info_rec;
1730: l_del_out_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
1731: l_del_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
1732: c_dlv_rec c_delivery%ROWTYPE;
2554: l_number_of_errors NUMBER;
2555: l_number_of_warnings NUMBER;
2556: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_NONTL_TRIP';
2557:
2558: l_dlv_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2559: c_dlv_rec c_delivery%ROWTYPE;
2560: l_dleg_rec dlv_leg_info_rec;
2561: l_trip_info_rec trip_info_rec;
2562: l_trip_dleg_cnt NUMBER;
2785: l_number_of_errors NUMBER;
2786: l_number_of_warnings NUMBER;
2787: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TL_TRIP';
2788:
2789: l_dlv_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2790: c_dlv_rec c_delivery%ROWTYPE;
2791: l_dleg_rec dlv_leg_info_rec;
2792: l_trip_info_rec trip_info_rec;
2793: l_trip_dleg_cnt NUMBER;
4145: --
4146: i NUMBER;
4147: j NUMBER;
4148: k NUMBER;
4149: l_dlv_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4150: l_leg_count NUMBER := 0;
4151: l_dlv_leg_list WSH_UTIL_CORE.id_tab_type;
4152: l_lane_ids WSH_UTIL_CORE.id_tab_type;
4153: l_trip_ids WSH_UTIL_CORE.id_tab_type;
4754: --
4755: i NUMBER;
4756: j NUMBER;
4757: k NUMBER;
4758: l_dlv_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4759: l_leg_count NUMBER := 0;
4760: l_dlv_leg_list WSH_UTIL_CORE.id_tab_type;
4761: l_lane_ids WSH_UTIL_CORE.id_tab_type;
4762: l_trip_ids WSH_UTIL_CORE.id_tab_type;