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_FREIGHT_PRICING dependencies on FTE_ID_TAB_TYPE

Line 10093: --PROCEDURE validate_rerate_delivery(p_delv_list IN FTE_ID_TAB_TYPE,

10089: END IF;
10090: END shipment_reprice2;
10091:
10092:
10093: --PROCEDURE validate_rerate_delivery(p_delv_list IN FTE_ID_TAB_TYPE,
10094:
10095: -- Added for R12 to get Delivery Legs for all the deliveries.
10096: -- This is added to allow multi leg rating in case of rerating.
10097: -- In addition to this , this delivery needs to find out all the

Line 10101: p_deliveries_list IN FTE_ID_TAB_TYPE,

10097: -- In addition to this , this delivery needs to find out all the
10098: -- delivery legs for it's child deliveries in case it's console delivery.
10099:
10100: PROCEDURE get_delivery_legs(
10101: p_deliveries_list IN FTE_ID_TAB_TYPE,
10102: x_delivery_legs OUT NOCOPY DELIVERY_LEG_TAB_TYPE,
10103: x_return_status OUT NOCOPY VARCHAR2)
10104: IS
10105:

Line 10158: PROCEDURE get_distinct_trip_ids( p_dleg_list IN FTE_ID_TAB_TYPE,

10154: -- Internal procedure to get distinct trip_ids for a given
10155: -- delivery legs table.
10156: -- Added for R12. Used in rerate_shipment_online.
10157:
10158: PROCEDURE get_distinct_trip_ids( p_dleg_list IN FTE_ID_TAB_TYPE,
10159: x_trip_ids OUT NOCOPY DELIVERY_TRIP_TAB_TYPE,
10160: x_all_trips OUT NOCOPY DELIVERY_TRIP_TAB_TYPE,
10161: x_return_status OUT NOCOPY VARCHAR2)
10162:

Line 10195: --x_trip_ids := FTE_ID_TAB_TYPE();

10191: BEGIN
10192:
10193: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
10194: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name);
10195: --x_trip_ids := FTE_ID_TAB_TYPE();
10196:
10197: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,p_dleg_list.COUNT);
10198:
10199: FOR i IN p_dleg_list.FIRST..p_dleg_list.COUNT LOOP

Line 10250: ( p_deliveries_list IN FTE_ID_TAB_TYPE,

10246: -- which need rerating
10247: -- For Deliveries which fail validation a new message is written in log file.
10248:
10249: PROCEDURE validate_delv_for_rerating
10250: ( p_deliveries_list IN FTE_ID_TAB_TYPE,
10251: x_deliveries_list OUT NOCOPY FTE_ID_TAB_TYPE
10252: )
10253:
10254: IS

Line 10251: x_deliveries_list OUT NOCOPY FTE_ID_TAB_TYPE

10247: -- For Deliveries which fail validation a new message is written in log file.
10248:
10249: PROCEDURE validate_delv_for_rerating
10250: ( p_deliveries_list IN FTE_ID_TAB_TYPE,
10251: x_deliveries_list OUT NOCOPY FTE_ID_TAB_TYPE
10252: )
10253:
10254: IS
10255:

Line 10256: l_new_delv_list FTE_ID_TAB_TYPE;

10252: )
10253:
10254: IS
10255:
10256: l_new_delv_list FTE_ID_TAB_TYPE;
10257: l_api_name CONSTANT VARCHAR2(30) := 'validate_delv_for_rerating';
10258: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
10259: i NUMBER := 0;
10260: l_var VARCHAR2(1);

Line 10272: l_new_delv_list := FTE_ID_TAB_TYPE();

10268:
10269: BEGIN
10270: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
10271: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name);
10272: l_new_delv_list := FTE_ID_TAB_TYPE();
10273:
10274: FOR i IN p_deliveries_list.FIRST..p_deliveries_list.LAST
10275: LOOP
10276: OPEN check_delivery_type(p_deliveries_list(i));

Line 10302: PROCEDURE validate_delivery_legs(p_dlegs_list IN FTE_ID_TAB_TYPE,

10298: -- 1) Delivery leg has a rate
10299: -- If a delivery leg doesnt have existing rates, it removes it from
10300: -- the list of dlegs which need to be rerated.
10301: -- For Dlegs which fail validation a new message is written in log file.
10302: PROCEDURE validate_delivery_legs(p_dlegs_list IN FTE_ID_TAB_TYPE,
10303: x_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,
10304: x_failed_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,
10305: x_return_status OUT NOCOPY VARCHAR2
10306: )

Line 10303: x_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,

10299: -- If a delivery leg doesnt have existing rates, it removes it from
10300: -- the list of dlegs which need to be rerated.
10301: -- For Dlegs which fail validation a new message is written in log file.
10302: PROCEDURE validate_delivery_legs(p_dlegs_list IN FTE_ID_TAB_TYPE,
10303: x_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,
10304: x_failed_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,
10305: x_return_status OUT NOCOPY VARCHAR2
10306: )
10307:

Line 10304: x_failed_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,

10300: -- the list of dlegs which need to be rerated.
10301: -- For Dlegs which fail validation a new message is written in log file.
10302: PROCEDURE validate_delivery_legs(p_dlegs_list IN FTE_ID_TAB_TYPE,
10303: x_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,
10304: x_failed_dleg_list OUT NOCOPY FTE_ID_TAB_TYPE,
10305: x_return_status OUT NOCOPY VARCHAR2
10306: )
10307:
10308: IS

Line 10309: l_new_dleg_list FTE_ID_TAB_TYPE;

10305: x_return_status OUT NOCOPY VARCHAR2
10306: )
10307:
10308: IS
10309: l_new_dleg_list FTE_ID_TAB_TYPE;
10310: l_failed_dleg_list FTE_ID_TAB_TYPE;
10311: l_api_name CONSTANT VARCHAR2(30) := 'validate_delivery_legs';
10312: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
10313: i NUMBER := 0;

Line 10310: l_failed_dleg_list FTE_ID_TAB_TYPE;

10306: )
10307:
10308: IS
10309: l_new_dleg_list FTE_ID_TAB_TYPE;
10310: l_failed_dleg_list FTE_ID_TAB_TYPE;
10311: l_api_name CONSTANT VARCHAR2(30) := 'validate_delivery_legs';
10312: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
10313: i NUMBER := 0;
10314: l_var NUMBER;--VARCHAR2(1);

Line 10329: l_new_dleg_list := FTE_ID_TAB_TYPE();

10325:
10326: BEGIN
10327: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
10328: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name);
10329: l_new_dleg_list := FTE_ID_TAB_TYPE();
10330: l_failed_dleg_list := FTE_ID_TAB_TYPE();
10331:
10332: FOR i IN p_dlegs_list.FIRST..p_dlegs_list.LAST
10333: LOOP

Line 10330: l_failed_dleg_list := FTE_ID_TAB_TYPE();

10326: BEGIN
10327: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
10328: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name);
10329: l_new_dleg_list := FTE_ID_TAB_TYPE();
10330: l_failed_dleg_list := FTE_ID_TAB_TYPE();
10331:
10332: FOR i IN p_dlegs_list.FIRST..p_dlegs_list.LAST
10333: LOOP
10334: OPEN check_freight_cost_exist(p_dlegs_list(i));

Line 10481: p_deliveries_list IN FTE_ID_TAB_TYPE,

10477: PROCEDURE rerate_shipment_online(
10478: p_api_version IN NUMBER DEFAULT 1.0,
10479: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10480: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10481: p_deliveries_list IN FTE_ID_TAB_TYPE,
10482: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
10483: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
10484: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
10485: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,

Line 10484: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,

10480: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10481: p_deliveries_list IN FTE_ID_TAB_TYPE,
10482: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
10483: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
10484: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
10485: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,
10486: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,
10487: x_return_status OUT NOCOPY VARCHAR2,
10488: x_msg_count OUT NOCOPY NUMBER,

Line 10485: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,

10481: p_deliveries_list IN FTE_ID_TAB_TYPE,
10482: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
10483: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
10484: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
10485: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,
10486: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,
10487: x_return_status OUT NOCOPY VARCHAR2,
10488: x_msg_count OUT NOCOPY NUMBER,
10489: x_msg_data OUT NOCOPY VARCHAR2)

Line 10486: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,

10482: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
10483: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
10484: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
10485: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,
10486: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,
10487: x_return_status OUT NOCOPY VARCHAR2,
10488: x_msg_count OUT NOCOPY NUMBER,
10489: x_msg_data OUT NOCOPY VARCHAR2)
10490: IS

Line 10507: l_failed_leg_list FTE_ID_TAB_TYPE;

10503: l_msg_data VARCHAR2(32767);
10504: l_fail_delivery_name_list VARCHAR2(32767);
10505: l_warn_delivery_name_list VARCHAR2(32767);
10506: i NUMBER;
10507: l_failed_leg_list FTE_ID_TAB_TYPE;
10508: l_success_leg_list FTE_ID_TAB_TYPE;
10509: l_warning_leg_list FTE_ID_TAB_TYPE;
10510: l_dleg_list FTE_ID_TAB_TYPE;
10511: --l_trip_ids FTE_ID_TAB_TYPE;

Line 10508: l_success_leg_list FTE_ID_TAB_TYPE;

10504: l_fail_delivery_name_list VARCHAR2(32767);
10505: l_warn_delivery_name_list VARCHAR2(32767);
10506: i NUMBER;
10507: l_failed_leg_list FTE_ID_TAB_TYPE;
10508: l_success_leg_list FTE_ID_TAB_TYPE;
10509: l_warning_leg_list FTE_ID_TAB_TYPE;
10510: l_dleg_list FTE_ID_TAB_TYPE;
10511: --l_trip_ids FTE_ID_TAB_TYPE;
10512: l_new_deliveries_list FTE_ID_TAB_TYPE;

Line 10509: l_warning_leg_list FTE_ID_TAB_TYPE;

10505: l_warn_delivery_name_list VARCHAR2(32767);
10506: i NUMBER;
10507: l_failed_leg_list FTE_ID_TAB_TYPE;
10508: l_success_leg_list FTE_ID_TAB_TYPE;
10509: l_warning_leg_list FTE_ID_TAB_TYPE;
10510: l_dleg_list FTE_ID_TAB_TYPE;
10511: --l_trip_ids FTE_ID_TAB_TYPE;
10512: l_new_deliveries_list FTE_ID_TAB_TYPE;
10513: l_new_dleg_list FTE_ID_TAB_TYPE;

Line 10510: l_dleg_list FTE_ID_TAB_TYPE;

10506: i NUMBER;
10507: l_failed_leg_list FTE_ID_TAB_TYPE;
10508: l_success_leg_list FTE_ID_TAB_TYPE;
10509: l_warning_leg_list FTE_ID_TAB_TYPE;
10510: l_dleg_list FTE_ID_TAB_TYPE;
10511: --l_trip_ids FTE_ID_TAB_TYPE;
10512: l_new_deliveries_list FTE_ID_TAB_TYPE;
10513: l_new_dleg_list FTE_ID_TAB_TYPE;
10514: l_delv_legs DELIVERY_LEG_TAB_TYPE;

Line 10511: --l_trip_ids FTE_ID_TAB_TYPE;

10507: l_failed_leg_list FTE_ID_TAB_TYPE;
10508: l_success_leg_list FTE_ID_TAB_TYPE;
10509: l_warning_leg_list FTE_ID_TAB_TYPE;
10510: l_dleg_list FTE_ID_TAB_TYPE;
10511: --l_trip_ids FTE_ID_TAB_TYPE;
10512: l_new_deliveries_list FTE_ID_TAB_TYPE;
10513: l_new_dleg_list FTE_ID_TAB_TYPE;
10514: l_delv_legs DELIVERY_LEG_TAB_TYPE;
10515: l_index NUMBER := 0;

Line 10512: l_new_deliveries_list FTE_ID_TAB_TYPE;

10508: l_success_leg_list FTE_ID_TAB_TYPE;
10509: l_warning_leg_list FTE_ID_TAB_TYPE;
10510: l_dleg_list FTE_ID_TAB_TYPE;
10511: --l_trip_ids FTE_ID_TAB_TYPE;
10512: l_new_deliveries_list FTE_ID_TAB_TYPE;
10513: l_new_dleg_list FTE_ID_TAB_TYPE;
10514: l_delv_legs DELIVERY_LEG_TAB_TYPE;
10515: l_index NUMBER := 0;
10516: l_trip_id NUMBER;

Line 10513: l_new_dleg_list FTE_ID_TAB_TYPE;

10509: l_warning_leg_list FTE_ID_TAB_TYPE;
10510: l_dleg_list FTE_ID_TAB_TYPE;
10511: --l_trip_ids FTE_ID_TAB_TYPE;
10512: l_new_deliveries_list FTE_ID_TAB_TYPE;
10513: l_new_dleg_list FTE_ID_TAB_TYPE;
10514: l_delv_legs DELIVERY_LEG_TAB_TYPE;
10515: l_index NUMBER := 0;
10516: l_trip_id NUMBER;
10517: l_failed_list FTE_ID_TAB_TYPE;

Line 10517: l_failed_list FTE_ID_TAB_TYPE;

10513: l_new_dleg_list FTE_ID_TAB_TYPE;
10514: l_delv_legs DELIVERY_LEG_TAB_TYPE;
10515: l_index NUMBER := 0;
10516: l_trip_id NUMBER;
10517: l_failed_list FTE_ID_TAB_TYPE;
10518: l_success_list FTE_ID_TAB_TYPE;
10519: l_warning_list FTE_ID_TAB_TYPE;
10520: l_trip_ids DELIVERY_TRIP_TAB_TYPE;
10521: j NUMBER;

Line 10518: l_success_list FTE_ID_TAB_TYPE;

10514: l_delv_legs DELIVERY_LEG_TAB_TYPE;
10515: l_index NUMBER := 0;
10516: l_trip_id NUMBER;
10517: l_failed_list FTE_ID_TAB_TYPE;
10518: l_success_list FTE_ID_TAB_TYPE;
10519: l_warning_list FTE_ID_TAB_TYPE;
10520: l_trip_ids DELIVERY_TRIP_TAB_TYPE;
10521: j NUMBER;
10522: l_all_trips DELIVERY_TRIP_TAB_TYPE;

Line 10519: l_warning_list FTE_ID_TAB_TYPE;

10515: l_index NUMBER := 0;
10516: l_trip_id NUMBER;
10517: l_failed_list FTE_ID_TAB_TYPE;
10518: l_success_list FTE_ID_TAB_TYPE;
10519: l_warning_list FTE_ID_TAB_TYPE;
10520: l_trip_ids DELIVERY_TRIP_TAB_TYPE;
10521: j NUMBER;
10522: l_all_trips DELIVERY_TRIP_TAB_TYPE;
10523: j1 NUMBER;

Line 10527: l_fail_val_dleg_list FTE_ID_TAB_TYPE;

10523: j1 NUMBER;
10524: l_service_failed VARCHAR2(1) ;
10525: l_service_failed_delv_ids VARCHAR2(32767);
10526: l_closed_trips_delv_ids VARCHAR2(32767);
10527: l_fail_val_dleg_list FTE_ID_TAB_TYPE;
10528: l_action_params FTE_TRIP_RATING_GRP.action_param_rec;
10529: l_trip_id_list WSH_UTIL_CORE.id_tab_type;
10530: l_failed_trips WSH_UTIL_CORE.id_tab_type;
10531: l_success_trips WSH_UTIL_CORE.id_tab_type;

Line 10615: l_dleg_list := FTE_ID_TAB_TYPE();

10611:
10612: -- If deliveries are passed for re-rating.
10613: -- get all the delivery legs for those deliveries. Done for R12
10614:
10615: l_dleg_list := FTE_ID_TAB_TYPE();
10616: l_failed_list := FTE_ID_TAB_TYPE();
10617: l_success_list := FTE_ID_TAB_TYPE();
10618: l_warning_list := FTE_ID_TAB_TYPE();
10619:

Line 10616: l_failed_list := FTE_ID_TAB_TYPE();

10612: -- If deliveries are passed for re-rating.
10613: -- get all the delivery legs for those deliveries. Done for R12
10614:
10615: l_dleg_list := FTE_ID_TAB_TYPE();
10616: l_failed_list := FTE_ID_TAB_TYPE();
10617: l_success_list := FTE_ID_TAB_TYPE();
10618: l_warning_list := FTE_ID_TAB_TYPE();
10619:
10620:

Line 10617: l_success_list := FTE_ID_TAB_TYPE();

10613: -- get all the delivery legs for those deliveries. Done for R12
10614:
10615: l_dleg_list := FTE_ID_TAB_TYPE();
10616: l_failed_list := FTE_ID_TAB_TYPE();
10617: l_success_list := FTE_ID_TAB_TYPE();
10618: l_warning_list := FTE_ID_TAB_TYPE();
10619:
10620:
10621: IF p_deliveries_list_type = 'DEL' THEN

Line 10618: l_warning_list := FTE_ID_TAB_TYPE();

10614:
10615: l_dleg_list := FTE_ID_TAB_TYPE();
10616: l_failed_list := FTE_ID_TAB_TYPE();
10617: l_success_list := FTE_ID_TAB_TYPE();
10618: l_warning_list := FTE_ID_TAB_TYPE();
10619:
10620:
10621: IF p_deliveries_list_type = 'DEL' THEN
10622:

Line 13069: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids

13065: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
13066: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
13067: p_delivery_id IN NUMBER,
13068: p_trip_id IN NUMBER,
13069: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
13070: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
13071: p_mode_tab IN FTE_CODE_TAB_TYPE,
13072: p_service_type_tab IN FTE_CODE_TAB_TYPE,
13073: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,

Line 13073: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,

13069: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
13070: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
13071: p_mode_tab IN FTE_CODE_TAB_TYPE,
13072: p_service_type_tab IN FTE_CODE_TAB_TYPE,
13073: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
13074: p_dep_date IN DATE DEFAULT sysdate,
13075: p_arr_date IN DATE DEFAULT sysdate,
13076: p_pickup_location_id IN NUMBER,
13077: p_dropoff_location_id IN NUMBER,

Line 13078: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids

13074: p_dep_date IN DATE DEFAULT sysdate,
13075: p_arr_date IN DATE DEFAULT sysdate,
13076: p_pickup_location_id IN NUMBER,
13077: p_dropoff_location_id IN NUMBER,
13078: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
13079: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
13080: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID
13081: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
13082: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

Line 13080: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID

13076: p_pickup_location_id IN NUMBER,
13077: p_dropoff_location_id IN NUMBER,
13078: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
13079: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
13080: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID
13081: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
13082: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
13083: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
13084: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

Line 13083: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,

13079: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
13080: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID
13081: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
13082: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
13083: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
13084: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
13085: x_request_id OUT NOCOPY NUMBER, -- One request ID per comparison request
13086: x_return_status OUT NOCOPY VARCHAR2 )
13087: IS

Line 13354: x_sum_rate_tab := FTE_ID_TAB_TYPE(0);

13350: THEN
13351:
13352: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Init op tables');
13353:
13354: x_sum_rate_tab := FTE_ID_TAB_TYPE(0);
13355: x_sum_rate_curr_tab := FTE_CODE_TAB_TYPE('NULL');
13356: -- init all elements the tables with 0 and 'NULL' resp.
13357:
13358: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);

Line 13358: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);

13354: x_sum_rate_tab := FTE_ID_TAB_TYPE(0);
13355: x_sum_rate_curr_tab := FTE_CODE_TAB_TYPE('NULL');
13356: -- init all elements the tables with 0 and 'NULL' resp.
13357:
13358: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);
13359: x_lane_sched_tab:=FTE_CODE_TAB_TYPE('NULL');
13360: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);
13361: x_mode_tab:=FTE_CODE_TAB_TYPE('NULL');
13362: x_service_type_tab:=FTE_CODE_TAB_TYPE('NULL');

Line 13360: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);

13356: -- init all elements the tables with 0 and 'NULL' resp.
13357:
13358: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);
13359: x_lane_sched_tab:=FTE_CODE_TAB_TYPE('NULL');
13360: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);
13361: x_mode_tab:=FTE_CODE_TAB_TYPE('NULL');
13362: x_service_type_tab:=FTE_CODE_TAB_TYPE('NULL');
13363:
13364: