eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TL_RATING dependencies on DBMS_UTILITY

Line 19: l_distances dbms_utility.number_array;

15: WHERE s.trip_id=c_trip_id
16: ORDER BY s.stop_sequence_number;
17:
18:
19: l_distances dbms_utility.number_array;
20: l_stop_ids dbms_utility.number_array;
21: l_distance_uom VARCHAR2(30);
22: l_weight NUMBER;
23: l_weight_uom VARCHAR2(30);

Line 20: l_stop_ids dbms_utility.number_array;

16: ORDER BY s.stop_sequence_number;
17:
18:
19: l_distances dbms_utility.number_array;
20: l_stop_ids dbms_utility.number_array;
21: l_distance_uom VARCHAR2(30);
22: l_weight NUMBER;
23: l_weight_uom VARCHAR2(30);
24:

Line 121: p_lane_rows IN dbms_utility.number_array,

117:
118:
119: PROCEDURE Get_Vehicles_For_LaneSchedules(
120: p_trip_id IN NUMBER DEFAULT NULL,
121: p_lane_rows IN dbms_utility.number_array,
122: p_schedule_rows IN dbms_utility.number_array,
123: p_vehicle_rows IN dbms_utility.number_array,
124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
125: x_lane_rows OUT NOCOPY dbms_utility.number_array,

Line 122: p_schedule_rows IN dbms_utility.number_array,

118:
119: PROCEDURE Get_Vehicles_For_LaneSchedules(
120: p_trip_id IN NUMBER DEFAULT NULL,
121: p_lane_rows IN dbms_utility.number_array,
122: p_schedule_rows IN dbms_utility.number_array,
123: p_vehicle_rows IN dbms_utility.number_array,
124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
125: x_lane_rows OUT NOCOPY dbms_utility.number_array,
126: x_schedule_rows OUT NOCOPY dbms_utility.number_array,

Line 123: p_vehicle_rows IN dbms_utility.number_array,

119: PROCEDURE Get_Vehicles_For_LaneSchedules(
120: p_trip_id IN NUMBER DEFAULT NULL,
121: p_lane_rows IN dbms_utility.number_array,
122: p_schedule_rows IN dbms_utility.number_array,
123: p_vehicle_rows IN dbms_utility.number_array,
124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
125: x_lane_rows OUT NOCOPY dbms_utility.number_array,
126: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
127: x_ref_rows OUT NOCOPY dbms_utility.number_array,

Line 124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,

120: p_trip_id IN NUMBER DEFAULT NULL,
121: p_lane_rows IN dbms_utility.number_array,
122: p_schedule_rows IN dbms_utility.number_array,
123: p_vehicle_rows IN dbms_utility.number_array,
124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
125: x_lane_rows OUT NOCOPY dbms_utility.number_array,
126: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
127: x_ref_rows OUT NOCOPY dbms_utility.number_array,
128: x_return_status OUT NOCOPY Varchar2) IS

Line 125: x_lane_rows OUT NOCOPY dbms_utility.number_array,

121: p_lane_rows IN dbms_utility.number_array,
122: p_schedule_rows IN dbms_utility.number_array,
123: p_vehicle_rows IN dbms_utility.number_array,
124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
125: x_lane_rows OUT NOCOPY dbms_utility.number_array,
126: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
127: x_ref_rows OUT NOCOPY dbms_utility.number_array,
128: x_return_status OUT NOCOPY Varchar2) IS
129:

Line 126: x_schedule_rows OUT NOCOPY dbms_utility.number_array,

122: p_schedule_rows IN dbms_utility.number_array,
123: p_vehicle_rows IN dbms_utility.number_array,
124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
125: x_lane_rows OUT NOCOPY dbms_utility.number_array,
126: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
127: x_ref_rows OUT NOCOPY dbms_utility.number_array,
128: x_return_status OUT NOCOPY Varchar2) IS
129:
130:

Line 127: x_ref_rows OUT NOCOPY dbms_utility.number_array,

123: p_vehicle_rows IN dbms_utility.number_array,
124: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
125: x_lane_rows OUT NOCOPY dbms_utility.number_array,
126: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
127: x_ref_rows OUT NOCOPY dbms_utility.number_array,
128: x_return_status OUT NOCOPY Varchar2) IS
129:
130:
131:

Line 183: l_carrier_hash dbms_utility.number_array;--indexed by carrier id has a pointer to l_vehicle_list

179: l_vehicle_type NUMBER;
180: l_vehicle_index NUMBER;
181: l_default_vehicle NUMBER;
182: l_index NUMBER;
183: l_carrier_hash dbms_utility.number_array;--indexed by carrier id has a pointer to l_vehicle_list
184: l_vehicle_list dbms_utility.number_array;
185:
186: l_invalid_trip_vehicle dbms_utility.number_array;
187:

Line 184: l_vehicle_list dbms_utility.number_array;

180: l_vehicle_index NUMBER;
181: l_default_vehicle NUMBER;
182: l_index NUMBER;
183: l_carrier_hash dbms_utility.number_array;--indexed by carrier id has a pointer to l_vehicle_list
184: l_vehicle_list dbms_utility.number_array;
185:
186: l_invalid_trip_vehicle dbms_utility.number_array;
187:
188: i NUMBER;

Line 186: l_invalid_trip_vehicle dbms_utility.number_array;

182: l_index NUMBER;
183: l_carrier_hash dbms_utility.number_array;--indexed by carrier id has a pointer to l_vehicle_list
184: l_vehicle_list dbms_utility.number_array;
185:
186: l_invalid_trip_vehicle dbms_utility.number_array;
187:
188: i NUMBER;
189: j NUMBER;
190: l_return_status VARCHAR2(1);

Line 1507: l_lock_ids DBMS_UTILITY.NUMBER_ARRAY;

1503: -- and wfc.delivery_detail_id is not null
1504: FOR UPDATE OF wfc.freight_cost_id NOWAIT;
1505:
1506:
1507: l_lock_ids DBMS_UTILITY.NUMBER_ARRAY;
1508: l_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1509: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
1510:
1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;

Line 1508: l_stop_ids DBMS_UTILITY.NUMBER_ARRAY;

1504: FOR UPDATE OF wfc.freight_cost_id NOWAIT;
1505:
1506:
1507: l_lock_ids DBMS_UTILITY.NUMBER_ARRAY;
1508: l_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1509: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
1510:
1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;

Line 1509: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;

1505:
1506:
1507: l_lock_ids DBMS_UTILITY.NUMBER_ARRAY;
1508: l_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1509: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
1510:
1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1513: l_wfc_trip_ids DBMS_UTILITY.NUMBER_ARRAY;

Line 1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;

1507: l_lock_ids DBMS_UTILITY.NUMBER_ARRAY;
1508: l_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1509: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
1510:
1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1513: l_wfc_trip_ids DBMS_UTILITY.NUMBER_ARRAY;
1514: l_wfc_one_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1515: l_wfc_temp_stop_ids DBMS_UTILITY.NUMBER_ARRAY;

Line 1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;

1508: l_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1509: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
1510:
1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1513: l_wfc_trip_ids DBMS_UTILITY.NUMBER_ARRAY;
1514: l_wfc_one_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1515: l_wfc_temp_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1516:

Line 1513: l_wfc_trip_ids DBMS_UTILITY.NUMBER_ARRAY;

1509: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
1510:
1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1513: l_wfc_trip_ids DBMS_UTILITY.NUMBER_ARRAY;
1514: l_wfc_one_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1515: l_wfc_temp_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1516:
1517: l_lock_id NUMBER;

Line 1514: l_wfc_one_stop_ids DBMS_UTILITY.NUMBER_ARRAY;

1510:
1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1513: l_wfc_trip_ids DBMS_UTILITY.NUMBER_ARRAY;
1514: l_wfc_one_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1515: l_wfc_temp_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1516:
1517: l_lock_id NUMBER;
1518: j NUMBER;

Line 1515: l_wfc_temp_stop_ids DBMS_UTILITY.NUMBER_ARRAY;

1511: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
1512: l_wfc_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1513: l_wfc_trip_ids DBMS_UTILITY.NUMBER_ARRAY;
1514: l_wfc_one_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1515: l_wfc_temp_stop_ids DBMS_UTILITY.NUMBER_ARRAY;
1516:
1517: l_lock_id NUMBER;
1518: j NUMBER;
1519: i NUMBER;

Line 1790: l_trip_charges_tab dbms_utility.number_array;

1786: --All the stops of the diff trips in the move will be stored here
1787: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;
1788:
1789: --All the total charges for the trips are stored in this table, indexed by trip id
1790: l_trip_charges_tab dbms_utility.number_array;
1791:
1792: --This table indexed by the trip_id has a reference to the stops for that trip in l_store_trip_stop_rows
1793: l_stop_references dbms_utility.number_array;
1794: l_total_trip_charge NUMBER;

Line 1793: l_stop_references dbms_utility.number_array;

1789: --All the total charges for the trips are stored in this table, indexed by trip id
1790: l_trip_charges_tab dbms_utility.number_array;
1791:
1792: --This table indexed by the trip_id has a reference to the stops for that trip in l_store_trip_stop_rows
1793: l_stop_references dbms_utility.number_array;
1794: l_total_trip_charge NUMBER;
1795: l_non_cm_charge NUMBER;
1796: l_cm_charge NUMBER;
1797: i NUMBER;

Line 2152: l_trip_charges_tab dbms_utility.number_array;

2148: --All the stops of the diff trips in the move will be stored here
2149: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2150:
2151: --All the total charges for the trips are stored in this table, indexed by trip id
2152: l_trip_charges_tab dbms_utility.number_array;
2153:
2154: --This table indexed by the trip_id has a reference to the stops for that trip in l_store_trip_stop_rows
2155: l_stop_references dbms_utility.number_array;
2156:

Line 2155: l_stop_references dbms_utility.number_array;

2151: --All the total charges for the trips are stored in this table, indexed by trip id
2152: l_trip_charges_tab dbms_utility.number_array;
2153:
2154: --This table indexed by the trip_id has a reference to the stops for that trip in l_store_trip_stop_rows
2155: l_stop_references dbms_utility.number_array;
2156:
2157: l_dead_head_charge NUMBER;
2158: l_load_charge NUMBER;
2159:

Line 2736: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,

2732: p_end_trip_index IN NUMBER ,
2733: p_output_type IN VARCHAR2,
2734: p_request_id IN NUMBER DEFAULT NULL,
2735: p_allocate_flag IN VARCHAR2,
2736: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
2737: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
2738: x_output_cost_tab OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
2739: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
2740: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_output_tab_type ,

Line 2737: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

2733: p_output_type IN VARCHAR2,
2734: p_request_id IN NUMBER DEFAULT NULL,
2735: p_allocate_flag IN VARCHAR2,
2736: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
2737: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
2738: x_output_cost_tab OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
2739: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
2740: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_output_tab_type ,
2741: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

Line 3287: p_lane_rows IN dbms_utility.number_array ,

3283: END TL_Rate_Trip;
3284:
3285:
3286: PROCEDURE Populate_Summary_Rates(
3287: p_lane_rows IN dbms_utility.number_array ,
3288: p_schedule_rows IN dbms_utility.number_array,
3289: p_vehicle_rows IN dbms_utility.number_array,
3290: p_start_trip_index IN NUMBER,
3291: p_end_trip_index IN NUMBER,

Line 3288: p_schedule_rows IN dbms_utility.number_array,

3284:
3285:
3286: PROCEDURE Populate_Summary_Rates(
3287: p_lane_rows IN dbms_utility.number_array ,
3288: p_schedule_rows IN dbms_utility.number_array,
3289: p_vehicle_rows IN dbms_utility.number_array,
3290: p_start_trip_index IN NUMBER,
3291: p_end_trip_index IN NUMBER,
3292: p_exceptions_tab IN FTE_TL_CORE.tl_exceptions_tab_type,

Line 3289: p_vehicle_rows IN dbms_utility.number_array,

3285:
3286: PROCEDURE Populate_Summary_Rates(
3287: p_lane_rows IN dbms_utility.number_array ,
3288: p_schedule_rows IN dbms_utility.number_array,
3289: p_vehicle_rows IN dbms_utility.number_array,
3290: p_start_trip_index IN NUMBER,
3291: p_end_trip_index IN NUMBER,
3292: p_exceptions_tab IN FTE_TL_CORE.tl_exceptions_tab_type,
3293: x_lane_sched_sum_rows IN OUT NOCOPY dbms_utility.number_array,

Line 3293: x_lane_sched_sum_rows IN OUT NOCOPY dbms_utility.number_array,

3289: p_vehicle_rows IN dbms_utility.number_array,
3290: p_start_trip_index IN NUMBER,
3291: p_end_trip_index IN NUMBER,
3292: p_exceptions_tab IN FTE_TL_CORE.tl_exceptions_tab_type,
3293: x_lane_sched_sum_rows IN OUT NOCOPY dbms_utility.number_array,
3294: x_lane_sched_curr_rows IN OUT NOCOPY dbms_utility.name_array,
3295: x_summary_cache_ref OUT NOCOPY dbms_utility.number_array,
3296: x_return_status OUT NOCOPY Varchar2) IS
3297:

Line 3294: x_lane_sched_curr_rows IN OUT NOCOPY dbms_utility.name_array,

3290: p_start_trip_index IN NUMBER,
3291: p_end_trip_index IN NUMBER,
3292: p_exceptions_tab IN FTE_TL_CORE.tl_exceptions_tab_type,
3293: x_lane_sched_sum_rows IN OUT NOCOPY dbms_utility.number_array,
3294: x_lane_sched_curr_rows IN OUT NOCOPY dbms_utility.name_array,
3295: x_summary_cache_ref OUT NOCOPY dbms_utility.number_array,
3296: x_return_status OUT NOCOPY Varchar2) IS
3297:
3298: l_lane_sched_sum_rows dbms_utility.number_array;

Line 3295: x_summary_cache_ref OUT NOCOPY dbms_utility.number_array,

3291: p_end_trip_index IN NUMBER,
3292: p_exceptions_tab IN FTE_TL_CORE.tl_exceptions_tab_type,
3293: x_lane_sched_sum_rows IN OUT NOCOPY dbms_utility.number_array,
3294: x_lane_sched_curr_rows IN OUT NOCOPY dbms_utility.name_array,
3295: x_summary_cache_ref OUT NOCOPY dbms_utility.number_array,
3296: x_return_status OUT NOCOPY Varchar2) IS
3297:
3298: l_lane_sched_sum_rows dbms_utility.number_array;
3299: l_lane_sched_curr_rows dbms_utility.name_array;

Line 3298: l_lane_sched_sum_rows dbms_utility.number_array;

3294: x_lane_sched_curr_rows IN OUT NOCOPY dbms_utility.name_array,
3295: x_summary_cache_ref OUT NOCOPY dbms_utility.number_array,
3296: x_return_status OUT NOCOPY Varchar2) IS
3297:
3298: l_lane_sched_sum_rows dbms_utility.number_array;
3299: l_lane_sched_curr_rows dbms_utility.name_array;
3300: i NUMBER;
3301: j NUMBER;
3302: l_lane_cached VARCHAR2(1);

Line 3299: l_lane_sched_curr_rows dbms_utility.name_array;

3295: x_summary_cache_ref OUT NOCOPY dbms_utility.number_array,
3296: x_return_status OUT NOCOPY Varchar2) IS
3297:
3298: l_lane_sched_sum_rows dbms_utility.number_array;
3299: l_lane_sched_curr_rows dbms_utility.name_array;
3300: i NUMBER;
3301: j NUMBER;
3302: l_lane_cached VARCHAR2(1);
3303:

Line 3409: p_lane_rows IN dbms_utility.number_array ,

3405:
3406:
3407: PROCEDURE TL_TRIP_PRICE_COMPARE(
3408: p_wsh_trip_id IN Number ,
3409: p_lane_rows IN dbms_utility.number_array ,
3410: p_schedule_rows IN dbms_utility.number_array,
3411: p_vehicle_rows IN dbms_utility.number_array,
3412: x_request_id IN OUT NOCOPY NUMBER,
3413: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,

Line 3410: p_schedule_rows IN dbms_utility.number_array,

3406:
3407: PROCEDURE TL_TRIP_PRICE_COMPARE(
3408: p_wsh_trip_id IN Number ,
3409: p_lane_rows IN dbms_utility.number_array ,
3410: p_schedule_rows IN dbms_utility.number_array,
3411: p_vehicle_rows IN dbms_utility.number_array,
3412: x_request_id IN OUT NOCOPY NUMBER,
3413: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
3414: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

Line 3411: p_vehicle_rows IN dbms_utility.number_array,

3407: PROCEDURE TL_TRIP_PRICE_COMPARE(
3408: p_wsh_trip_id IN Number ,
3409: p_lane_rows IN dbms_utility.number_array ,
3410: p_schedule_rows IN dbms_utility.number_array,
3411: p_vehicle_rows IN dbms_utility.number_array,
3412: x_request_id IN OUT NOCOPY NUMBER,
3413: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
3414: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
3415: x_return_status OUT NOCOPY Varchar2) IS

Line 3413: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,

3409: p_lane_rows IN dbms_utility.number_array ,
3410: p_schedule_rows IN dbms_utility.number_array,
3411: p_vehicle_rows IN dbms_utility.number_array,
3412: x_request_id IN OUT NOCOPY NUMBER,
3413: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
3414: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
3415: x_return_status OUT NOCOPY Varchar2) IS
3416:
3417: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;

Line 3414: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

3410: p_schedule_rows IN dbms_utility.number_array,
3411: p_vehicle_rows IN dbms_utility.number_array,
3412: x_request_id IN OUT NOCOPY NUMBER,
3413: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
3414: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
3415: x_return_status OUT NOCOPY Varchar2) IS
3416:
3417: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
3418: i NUMBER;

Line 3423: l_summary_cache_ref dbms_utility.number_array;

3419: l_request_id NUMBER;
3420: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3421: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3422: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3423: l_summary_cache_ref dbms_utility.number_array;
3424:
3425: CURSOR c_get_req_id IS
3426: SELECT fte_pricing_comp_request_s.nextval
3427: FROM sys.dual;

Line 3739: p_lane_rows IN dbms_utility.number_array ,

3735:
3736:
3737: PROCEDURE TL_DELIVERY_PRICE_COMPARE(
3738: p_wsh_delivery_id IN Number ,
3739: p_lane_rows IN dbms_utility.number_array ,
3740: p_schedule_rows IN dbms_utility.number_array,
3741: p_vehicle_rows IN dbms_utility.number_array,
3742: p_dep_date IN DATE DEFAULT sysdate,
3743: p_arr_date IN DATE DEFAULT sysdate,

Line 3740: p_schedule_rows IN dbms_utility.number_array,

3736:
3737: PROCEDURE TL_DELIVERY_PRICE_COMPARE(
3738: p_wsh_delivery_id IN Number ,
3739: p_lane_rows IN dbms_utility.number_array ,
3740: p_schedule_rows IN dbms_utility.number_array,
3741: p_vehicle_rows IN dbms_utility.number_array,
3742: p_dep_date IN DATE DEFAULT sysdate,
3743: p_arr_date IN DATE DEFAULT sysdate,
3744: p_pickup_location_id IN NUMBER,

Line 3741: p_vehicle_rows IN dbms_utility.number_array,

3737: PROCEDURE TL_DELIVERY_PRICE_COMPARE(
3738: p_wsh_delivery_id IN Number ,
3739: p_lane_rows IN dbms_utility.number_array ,
3740: p_schedule_rows IN dbms_utility.number_array,
3741: p_vehicle_rows IN dbms_utility.number_array,
3742: p_dep_date IN DATE DEFAULT sysdate,
3743: p_arr_date IN DATE DEFAULT sysdate,
3744: p_pickup_location_id IN NUMBER,
3745: p_dropoff_location_id IN NUMBER,

Line 3747: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,

3743: p_arr_date IN DATE DEFAULT sysdate,
3744: p_pickup_location_id IN NUMBER,
3745: p_dropoff_location_id IN NUMBER,
3746: x_request_id IN OUT NOCOPY NUMBER,
3747: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
3748: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
3749: x_return_status OUT NOCOPY Varchar2)
3750: IS
3751:

Line 3748: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

3744: p_pickup_location_id IN NUMBER,
3745: p_dropoff_location_id IN NUMBER,
3746: x_request_id IN OUT NOCOPY NUMBER,
3747: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
3748: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
3749: x_return_status OUT NOCOPY Varchar2)
3750: IS
3751:
3752:

Line 3777: l_summary_cache_ref dbms_utility.number_array;

3773: l_request_id NUMBER;
3774: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3775: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3776: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3777: l_summary_cache_ref dbms_utility.number_array;
3778:
3779:
3780: l_term_manifest_flag VARCHAR2(1);
3781: l_return_status VARCHAR2(1);

Line 4117: p_lane_rows IN dbms_utility.number_array ,

4113: END Get_Base_Accessory_Charges;
4114:
4115:
4116: PROCEDURE TL_FREIGHT_ESTIMATE(
4117: p_lane_rows IN dbms_utility.number_array ,
4118: p_schedule_rows IN dbms_utility.number_array,
4119: p_vehicle_rows IN dbms_utility.number_array,
4120: p_pickup_location_id IN NUMBER,
4121: p_dropoff_location_id IN NUMBER,

Line 4118: p_schedule_rows IN dbms_utility.number_array,

4114:
4115:
4116: PROCEDURE TL_FREIGHT_ESTIMATE(
4117: p_lane_rows IN dbms_utility.number_array ,
4118: p_schedule_rows IN dbms_utility.number_array,
4119: p_vehicle_rows IN dbms_utility.number_array,
4120: p_pickup_location_id IN NUMBER,
4121: p_dropoff_location_id IN NUMBER,
4122: p_ship_date IN DATE,

Line 4119: p_vehicle_rows IN dbms_utility.number_array,

4115:
4116: PROCEDURE TL_FREIGHT_ESTIMATE(
4117: p_lane_rows IN dbms_utility.number_array ,
4118: p_schedule_rows IN dbms_utility.number_array,
4119: p_vehicle_rows IN dbms_utility.number_array,
4120: p_pickup_location_id IN NUMBER,
4121: p_dropoff_location_id IN NUMBER,
4122: p_ship_date IN DATE,
4123: p_delivery_date IN DATE,

Line 4130: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,

4126: p_volume IN NUMBER,
4127: p_volume_uom IN VARCHAR2,
4128: p_distance IN NUMBER,
4129: p_distance_uom in VARCHAR2,
4130: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,
4131: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,
4132: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
4133: x_return_status OUT NOCOPY Varchar2,
4134: --Bug 6625274

Line 4131: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,

4127: p_volume_uom IN VARCHAR2,
4128: p_distance IN NUMBER,
4129: p_distance_uom in VARCHAR2,
4130: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,
4131: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,
4132: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
4133: x_return_status OUT NOCOPY Varchar2,
4134: --Bug 6625274
4135: p_origin_id IN NUMBER DEFAULT NULL,

Line 4132: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

4128: p_distance IN NUMBER,
4129: p_distance_uom in VARCHAR2,
4130: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,
4131: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,
4132: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
4133: x_return_status OUT NOCOPY Varchar2,
4134: --Bug 6625274
4135: p_origin_id IN NUMBER DEFAULT NULL,
4136: p_destination_id IN NUMBER DEFAULT NULL) IS

Line 4340: p_lane_sched_sum_rows IN dbms_utility.number_array,

4336: p_output_cost_tab IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
4337: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
4338: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
4339: p_LCSS_flag IN VARCHAR2,
4340: p_lane_sched_sum_rows IN dbms_utility.number_array,
4341: p_lane_sched_curr_rows IN dbms_utility.name_array,
4342: p_filtered_rows IN dbms_utility.number_array,
4343: p_ref_rows IN dbms_utility.number_array,
4344: p_summary_cache_ref IN dbms_utility.number_array,

Line 4341: p_lane_sched_curr_rows IN dbms_utility.name_array,

4337: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
4338: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
4339: p_LCSS_flag IN VARCHAR2,
4340: p_lane_sched_sum_rows IN dbms_utility.number_array,
4341: p_lane_sched_curr_rows IN dbms_utility.name_array,
4342: p_filtered_rows IN dbms_utility.number_array,
4343: p_ref_rows IN dbms_utility.number_array,
4344: p_summary_cache_ref IN dbms_utility.number_array,
4345: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

Line 4342: p_filtered_rows IN dbms_utility.number_array,

4338: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
4339: p_LCSS_flag IN VARCHAR2,
4340: p_lane_sched_sum_rows IN dbms_utility.number_array,
4341: p_lane_sched_curr_rows IN dbms_utility.name_array,
4342: p_filtered_rows IN dbms_utility.number_array,
4343: p_ref_rows IN dbms_utility.number_array,
4344: p_summary_cache_ref IN dbms_utility.number_array,
4345: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
4346: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

Line 4343: p_ref_rows IN dbms_utility.number_array,

4339: p_LCSS_flag IN VARCHAR2,
4340: p_lane_sched_sum_rows IN dbms_utility.number_array,
4341: p_lane_sched_curr_rows IN dbms_utility.name_array,
4342: p_filtered_rows IN dbms_utility.number_array,
4343: p_ref_rows IN dbms_utility.number_array,
4344: p_summary_cache_ref IN dbms_utility.number_array,
4345: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
4346: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
4347: x_return_status OUT NOCOPY VARCHAR2)

Line 4344: p_summary_cache_ref IN dbms_utility.number_array,

4340: p_lane_sched_sum_rows IN dbms_utility.number_array,
4341: p_lane_sched_curr_rows IN dbms_utility.name_array,
4342: p_filtered_rows IN dbms_utility.number_array,
4343: p_ref_rows IN dbms_utility.number_array,
4344: p_summary_cache_ref IN dbms_utility.number_array,
4345: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
4346: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
4347: x_return_status OUT NOCOPY VARCHAR2)
4348: IS

Line 4353: l_detail_price dbms_utility.number_array;

4349:
4350: l_source_header_rate_rec FTE_PROCESS_REQUESTS.fte_source_header_rates_rec;
4351: l_source_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;
4352: l_detail_records FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
4353: l_detail_price dbms_utility.number_array;
4354: l_detail_charge dbms_utility.number_array;
4355: l_price NUMBER;
4356: l_charge NUMBER;
4357:

Line 4354: l_detail_charge dbms_utility.number_array;

4350: l_source_header_rate_rec FTE_PROCESS_REQUESTS.fte_source_header_rates_rec;
4351: l_source_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;
4352: l_detail_records FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
4353: l_detail_price dbms_utility.number_array;
4354: l_detail_charge dbms_utility.number_array;
4355: l_price NUMBER;
4356: l_charge NUMBER;
4357:
4358:

Line 4783: p_lane_sched_sum_rows IN dbms_utility.number_array,

4779: -- If p_LCSS_flag ='Y' the least cost is identified
4780:
4781:
4782: PROCEDURE TL_Filter_For_Vehicle_Cost(
4783: p_lane_sched_sum_rows IN dbms_utility.number_array,
4784: p_lane_sched_curr_rows IN dbms_utility.name_array,
4785: p_ref_rows IN dbms_utility.number_array,
4786: p_LCSS_flag IN VARCHAR2,
4787: x_filtered_list_flag OUT NOCOPY dbms_utility.number_array,

Line 4784: p_lane_sched_curr_rows IN dbms_utility.name_array,

4780:
4781:
4782: PROCEDURE TL_Filter_For_Vehicle_Cost(
4783: p_lane_sched_sum_rows IN dbms_utility.number_array,
4784: p_lane_sched_curr_rows IN dbms_utility.name_array,
4785: p_ref_rows IN dbms_utility.number_array,
4786: p_LCSS_flag IN VARCHAR2,
4787: x_filtered_list_flag OUT NOCOPY dbms_utility.number_array,
4788: x_least_index OUT NOCOPY NUMBER,

Line 4785: p_ref_rows IN dbms_utility.number_array,

4781:
4782: PROCEDURE TL_Filter_For_Vehicle_Cost(
4783: p_lane_sched_sum_rows IN dbms_utility.number_array,
4784: p_lane_sched_curr_rows IN dbms_utility.name_array,
4785: p_ref_rows IN dbms_utility.number_array,
4786: p_LCSS_flag IN VARCHAR2,
4787: x_filtered_list_flag OUT NOCOPY dbms_utility.number_array,
4788: x_least_index OUT NOCOPY NUMBER,
4789: x_return_status OUT NOCOPY Varchar2)

Line 4787: x_filtered_list_flag OUT NOCOPY dbms_utility.number_array,

4783: p_lane_sched_sum_rows IN dbms_utility.number_array,
4784: p_lane_sched_curr_rows IN dbms_utility.name_array,
4785: p_ref_rows IN dbms_utility.number_array,
4786: p_LCSS_flag IN VARCHAR2,
4787: x_filtered_list_flag OUT NOCOPY dbms_utility.number_array,
4788: x_least_index OUT NOCOPY NUMBER,
4789: x_return_status OUT NOCOPY Varchar2)
4790: IS
4791:

Line 5001: p_lane_rows IN dbms_utility.number_array ,

4997: END TL_Filter_For_Vehicle_Cost;
4998:
4999:
5000: PROCEDURE TL_OM_RATING(
5001: p_lane_rows IN dbms_utility.number_array ,
5002: p_schedule_rows IN dbms_utility.number_array,
5003: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
5004: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
5005: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

Line 5002: p_schedule_rows IN dbms_utility.number_array,

4998:
4999:
5000: PROCEDURE TL_OM_RATING(
5001: p_lane_rows IN dbms_utility.number_array ,
5002: p_schedule_rows IN dbms_utility.number_array,
5003: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
5004: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
5005: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
5006: p_LCSS_flag IN VARCHAR2,

Line 5012: l_exploded_lane_rows dbms_utility.number_array;

5008: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
5009: x_return_status OUT NOCOPY Varchar2)
5010: IS
5011:
5012: l_exploded_lane_rows dbms_utility.number_array;
5013: l_exploded_schedule_rows dbms_utility.number_array;
5014: l_exploded_vehicle_rows dbms_utility.number_array;
5015: l_exploded_ref_rows dbms_utility.number_array;
5016: l_vehicle_rows dbms_utility.number_array;

Line 5013: l_exploded_schedule_rows dbms_utility.number_array;

5009: x_return_status OUT NOCOPY Varchar2)
5010: IS
5011:
5012: l_exploded_lane_rows dbms_utility.number_array;
5013: l_exploded_schedule_rows dbms_utility.number_array;
5014: l_exploded_vehicle_rows dbms_utility.number_array;
5015: l_exploded_ref_rows dbms_utility.number_array;
5016: l_vehicle_rows dbms_utility.number_array;
5017:

Line 5014: l_exploded_vehicle_rows dbms_utility.number_array;

5010: IS
5011:
5012: l_exploded_lane_rows dbms_utility.number_array;
5013: l_exploded_schedule_rows dbms_utility.number_array;
5014: l_exploded_vehicle_rows dbms_utility.number_array;
5015: l_exploded_ref_rows dbms_utility.number_array;
5016: l_vehicle_rows dbms_utility.number_array;
5017:
5018: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;

Line 5015: l_exploded_ref_rows dbms_utility.number_array;

5011:
5012: l_exploded_lane_rows dbms_utility.number_array;
5013: l_exploded_schedule_rows dbms_utility.number_array;
5014: l_exploded_vehicle_rows dbms_utility.number_array;
5015: l_exploded_ref_rows dbms_utility.number_array;
5016: l_vehicle_rows dbms_utility.number_array;
5017:
5018: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5019: i NUMBER;

Line 5016: l_vehicle_rows dbms_utility.number_array;

5012: l_exploded_lane_rows dbms_utility.number_array;
5013: l_exploded_schedule_rows dbms_utility.number_array;
5014: l_exploded_vehicle_rows dbms_utility.number_array;
5015: l_exploded_ref_rows dbms_utility.number_array;
5016: l_vehicle_rows dbms_utility.number_array;
5017:
5018: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5019: i NUMBER;
5020: l_request_id NUMBER;

Line 5025: l_lane_sched_sum_rows dbms_utility.number_array;

5021: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5022: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5023: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5024:
5025: l_lane_sched_sum_rows dbms_utility.number_array;
5026: l_lane_sched_curr_rows dbms_utility.name_array;
5027: l_filtered_rows dbms_utility.number_array;
5028: l_summary_cache_ref dbms_utility.number_array;
5029:

Line 5026: l_lane_sched_curr_rows dbms_utility.name_array;

5022: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5023: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5024:
5025: l_lane_sched_sum_rows dbms_utility.number_array;
5026: l_lane_sched_curr_rows dbms_utility.name_array;
5027: l_filtered_rows dbms_utility.number_array;
5028: l_summary_cache_ref dbms_utility.number_array;
5029:
5030: l_least_index NUMBER;

Line 5027: l_filtered_rows dbms_utility.number_array;

5023: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5024:
5025: l_lane_sched_sum_rows dbms_utility.number_array;
5026: l_lane_sched_curr_rows dbms_utility.name_array;
5027: l_filtered_rows dbms_utility.number_array;
5028: l_summary_cache_ref dbms_utility.number_array;
5029:
5030: l_least_index NUMBER;
5031: l_return_status VARCHAR2(1);

Line 5028: l_summary_cache_ref dbms_utility.number_array;

5024:
5025: l_lane_sched_sum_rows dbms_utility.number_array;
5026: l_lane_sched_curr_rows dbms_utility.name_array;
5027: l_filtered_rows dbms_utility.number_array;
5028: l_summary_cache_ref dbms_utility.number_array;
5029:
5030: l_least_index NUMBER;
5031: l_return_status VARCHAR2(1);
5032: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 5338: p_lane_rows IN dbms_utility.number_array ,

5334:
5335:
5336: PROCEDURE BEGIN_LCSS (
5337: p_trip_id IN NUMBER,
5338: p_lane_rows IN dbms_utility.number_array ,
5339: x_trip_index OUT NOCOPY NUMBER,
5340: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type ,
5341: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
5342: x_total_cost OUT NOCOPY NUMBER,

Line 5350: l_schedule_rows dbms_utility.number_array;

5346: x_return_status OUT NOCOPY VARCHAR2)
5347: IS
5348:
5349: i NUMBER;
5350: l_schedule_rows dbms_utility.number_array;
5351: l_exploded_lane_rows dbms_utility.number_array;
5352: l_exploded_schedule_rows dbms_utility.number_array;
5353: l_exploded_vehicle_rows dbms_utility.number_array;
5354: l_exploded_ref_rows dbms_utility.number_array;

Line 5351: l_exploded_lane_rows dbms_utility.number_array;

5347: IS
5348:
5349: i NUMBER;
5350: l_schedule_rows dbms_utility.number_array;
5351: l_exploded_lane_rows dbms_utility.number_array;
5352: l_exploded_schedule_rows dbms_utility.number_array;
5353: l_exploded_vehicle_rows dbms_utility.number_array;
5354: l_exploded_ref_rows dbms_utility.number_array;
5355: l_vehicle_rows dbms_utility.number_array;

Line 5352: l_exploded_schedule_rows dbms_utility.number_array;

5348:
5349: i NUMBER;
5350: l_schedule_rows dbms_utility.number_array;
5351: l_exploded_lane_rows dbms_utility.number_array;
5352: l_exploded_schedule_rows dbms_utility.number_array;
5353: l_exploded_vehicle_rows dbms_utility.number_array;
5354: l_exploded_ref_rows dbms_utility.number_array;
5355: l_vehicle_rows dbms_utility.number_array;
5356:

Line 5353: l_exploded_vehicle_rows dbms_utility.number_array;

5349: i NUMBER;
5350: l_schedule_rows dbms_utility.number_array;
5351: l_exploded_lane_rows dbms_utility.number_array;
5352: l_exploded_schedule_rows dbms_utility.number_array;
5353: l_exploded_vehicle_rows dbms_utility.number_array;
5354: l_exploded_ref_rows dbms_utility.number_array;
5355: l_vehicle_rows dbms_utility.number_array;
5356:
5357: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;

Line 5354: l_exploded_ref_rows dbms_utility.number_array;

5350: l_schedule_rows dbms_utility.number_array;
5351: l_exploded_lane_rows dbms_utility.number_array;
5352: l_exploded_schedule_rows dbms_utility.number_array;
5353: l_exploded_vehicle_rows dbms_utility.number_array;
5354: l_exploded_ref_rows dbms_utility.number_array;
5355: l_vehicle_rows dbms_utility.number_array;
5356:
5357: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5358: l_request_id NUMBER;

Line 5355: l_vehicle_rows dbms_utility.number_array;

5351: l_exploded_lane_rows dbms_utility.number_array;
5352: l_exploded_schedule_rows dbms_utility.number_array;
5353: l_exploded_vehicle_rows dbms_utility.number_array;
5354: l_exploded_ref_rows dbms_utility.number_array;
5355: l_vehicle_rows dbms_utility.number_array;
5356:
5357: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5358: l_request_id NUMBER;
5359: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;

Line 5360: l_lane_sched_sum_rows dbms_utility.number_array;

5356:
5357: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5358: l_request_id NUMBER;
5359: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5360: l_lane_sched_sum_rows dbms_utility.number_array;
5361: l_lane_sched_curr_rows dbms_utility.name_array;
5362: l_filtered_rows dbms_utility.number_array;
5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5364: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

Line 5361: l_lane_sched_curr_rows dbms_utility.name_array;

5357: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5358: l_request_id NUMBER;
5359: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5360: l_lane_sched_sum_rows dbms_utility.number_array;
5361: l_lane_sched_curr_rows dbms_utility.name_array;
5362: l_filtered_rows dbms_utility.number_array;
5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5364: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5365: l_least_index NUMBER;

Line 5362: l_filtered_rows dbms_utility.number_array;

5358: l_request_id NUMBER;
5359: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5360: l_lane_sched_sum_rows dbms_utility.number_array;
5361: l_lane_sched_curr_rows dbms_utility.name_array;
5362: l_filtered_rows dbms_utility.number_array;
5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5364: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5365: l_least_index NUMBER;
5366: l_summary_cache_ref dbms_utility.number_array;

Line 5366: l_summary_cache_ref dbms_utility.number_array;

5362: l_filtered_rows dbms_utility.number_array;
5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5364: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5365: l_least_index NUMBER;
5366: l_summary_cache_ref dbms_utility.number_array;
5367: l_least_cache_index NUMBER;
5368:
5369: l_return_status VARCHAR2(1);
5370: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 5769: p_lane_rows IN dbms_utility.number_array ,

5765: END ABORT_LCSS;
5766:
5767: PROCEDURE LCSS (
5768: p_trip_id IN NUMBER,
5769: p_lane_rows IN dbms_utility.number_array ,
5770: x_return_status OUT NOCOPY VARCHAR2)
5771: IS
5772: BEGIN
5773: