24:
25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;
26:
27: TYPE cs_stop_rec_type IS RECORD (
28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;
26:
27: TYPE cs_stop_rec_type IS RECORD (
28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
27: TYPE cs_stop_rec_type IS RECORD (
28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
28: STOP_ID wsh_trip_stops.stop_id%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
29: , TRIP_ID wsh_trip_stops.trip_id%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
30: --To handle dummy locations #DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
31: , STOP_LOCATION_ID wsh_trip_stops.stop_location_id%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
32: , STATUS_CODE wsh_trip_stops.STATUS_CODE%TYPE
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
33: , STOP_SEQUENCE_NUMBER wsh_trip_stops.STOP_SEQUENCE_NUMBER%TYPE
34: , PLANNED_ARRIVAL_DATE wsh_trip_stops.PLANNED_ARRIVAL_DATE%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
35: , PLANNED_DEPARTURE_DATE wsh_trip_stops.PLANNED_DEPARTURE_DATE%TYPE
36: , ACTUAL_ARRIVAL_DATE wsh_trip_stops.ACTUAL_ARRIVAL_DATE%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
37: , ACTUAL_DEPARTURE_DATE wsh_trip_stops.ACTUAL_DEPARTURE_DATE%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
38: --DUM_LOC(S)
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );
39: , PHYSICAL_LOCATION_ID wsh_trip_stops.PHYSICAL_LOCATION_ID%TYPE
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );
47:
40: --#DUM_LOC(E)
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );
47:
48: TYPE cs_stop_tab_type IS TABLE OF cs_stop_rec_type INDEX BY BINARY_INTEGER;
41: , PHYSICAL_STOP_ID wsh_trip_stops.PHYSICAL_STOP_ID%TYPE
42: , pick_up_weight wsh_trip_stops.pick_up_weight%TYPE
43: , weight_uom_code wsh_trip_stops.weight_uom_code%TYPE
44: , pick_up_volume wsh_trip_stops.pick_up_volume%TYPE
45: , volume_uom_code wsh_trip_stops.volume_uom_code%TYPE
46: );
47:
48: TYPE cs_stop_tab_type IS TABLE OF cs_stop_rec_type INDEX BY BINARY_INTEGER;
49: