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_CODE_TAB_TYPE

Line 13069: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)

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

Line 13070: p_mode_tab IN FTE_CODE_TAB_TYPE,

13066: p_delivery_id IN NUMBER,
13067: p_trip_id IN NUMBER,
13068: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
13069: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
13070: p_mode_tab IN FTE_CODE_TAB_TYPE,
13071: p_service_type_tab IN FTE_CODE_TAB_TYPE,
13072: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
13073: p_dep_date IN DATE DEFAULT sysdate,
13074: p_arr_date IN DATE DEFAULT sysdate,

Line 13071: p_service_type_tab IN FTE_CODE_TAB_TYPE,

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

Line 13078: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)

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

Line 13080: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

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

Line 13081: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

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

Line 13083: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

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

Line 13354: x_sum_rate_curr_tab := FTE_CODE_TAB_TYPE('NULL');

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

Line 13358: x_lane_sched_tab:=FTE_CODE_TAB_TYPE('NULL');

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

Line 13360: x_mode_tab:=FTE_CODE_TAB_TYPE('NULL');

13356:
13357: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);
13358: x_lane_sched_tab:=FTE_CODE_TAB_TYPE('NULL');
13359: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);
13360: x_mode_tab:=FTE_CODE_TAB_TYPE('NULL');
13361: x_service_type_tab:=FTE_CODE_TAB_TYPE('NULL');
13362:
13363:
13364: x_sum_rate_tab.EXTEND(l_output_count-1,1);

Line 13361: x_service_type_tab:=FTE_CODE_TAB_TYPE('NULL');

13357: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);
13358: x_lane_sched_tab:=FTE_CODE_TAB_TYPE('NULL');
13359: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);
13360: x_mode_tab:=FTE_CODE_TAB_TYPE('NULL');
13361: x_service_type_tab:=FTE_CODE_TAB_TYPE('NULL');
13362:
13363:
13364: x_sum_rate_tab.EXTEND(l_output_count-1,1);
13365: x_sum_rate_curr_tab.EXTEND(l_output_count-1,1);