4631:
4632: l_leg_id NUMBER;
4633: l_delivery_id NUMBER;
4634:
4635: l_leg_id_array dbms_utility.number_array;
4636: l_delivery_id_array dbms_utility.number_array;
4637: l_delivery_summary dbms_utility.number_array;
4638:
4639: l_freight_cost_type_id NUMBER;
4632: l_leg_id NUMBER;
4633: l_delivery_id NUMBER;
4634:
4635: l_leg_id_array dbms_utility.number_array;
4636: l_delivery_id_array dbms_utility.number_array;
4637: l_delivery_summary dbms_utility.number_array;
4638:
4639: l_freight_cost_type_id NUMBER;
4640:
4633: l_delivery_id NUMBER;
4634:
4635: l_leg_id_array dbms_utility.number_array;
4636: l_delivery_id_array dbms_utility.number_array;
4637: l_delivery_summary dbms_utility.number_array;
4638:
4639: l_freight_cost_type_id NUMBER;
4640:
4641: BEGIN
5531: l_leg_id NUMBER;
5532: l_delivery_id NUMBER;--indexed by delivery id/parent delivery id
5533: l_freight_cost_type_id NUMBER;
5534: l_tmp NUMBER;
5535: l_delivery_id_array dbms_utility.number_array;
5536: l_temp_delivery_id NUMBER;
5537: l_temp_parent_delivery_id NUMBER;
5538: l_trip_summary_amount NUMBER;
5539: l_leg_id_array dbms_utility.number_array;
5535: l_delivery_id_array dbms_utility.number_array;
5536: l_temp_delivery_id NUMBER;
5537: l_temp_parent_delivery_id NUMBER;
5538: l_trip_summary_amount NUMBER;
5539: l_leg_id_array dbms_utility.number_array;
5540:
5541:
5542:
5543: l_delivery_summary dbms_utility.number_array;
5539: l_leg_id_array dbms_utility.number_array;
5540:
5541:
5542:
5543: l_delivery_summary dbms_utility.number_array;
5544:
5545: l_main_update_count NUMBER;
5546:
5547: BEGIN