DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on FTE_CODE_TAB_TYPE

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

695: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
696: p_delivery_id IN NUMBER,
697: p_trip_id IN NUMBER,
698: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
699: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
700: p_mode_tab IN FTE_CODE_TAB_TYPE,
701: p_service_type_tab IN FTE_CODE_TAB_TYPE,
702: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
703: p_dep_date IN DATE DEFAULT sysdate,

Line 700: p_mode_tab IN FTE_CODE_TAB_TYPE,

696: p_delivery_id IN NUMBER,
697: p_trip_id IN NUMBER,
698: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
699: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
700: p_mode_tab IN FTE_CODE_TAB_TYPE,
701: p_service_type_tab IN FTE_CODE_TAB_TYPE,
702: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
703: p_dep_date IN DATE DEFAULT sysdate,
704: p_arr_date IN DATE DEFAULT sysdate,

Line 701: p_service_type_tab IN FTE_CODE_TAB_TYPE,

697: p_trip_id IN NUMBER,
698: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
699: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
700: p_mode_tab IN FTE_CODE_TAB_TYPE,
701: p_service_type_tab IN FTE_CODE_TAB_TYPE,
702: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
703: p_dep_date IN DATE DEFAULT sysdate,
704: p_arr_date IN DATE DEFAULT sysdate,
705: p_pickup_location_id IN NUMBER,

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

704: p_arr_date IN DATE DEFAULT sysdate,
705: p_pickup_location_id IN NUMBER,
706: p_dropoff_location_id IN NUMBER,
707: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
708: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
709: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID
710: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
711: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
712: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,

Line 710: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

706: p_dropoff_location_id IN NUMBER,
707: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
708: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
709: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID
710: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
711: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
712: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
713: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
714: x_request_id OUT NOCOPY NUMBER, -- One request ID per comparison request

Line 711: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

707: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
708: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
709: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID
710: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
711: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
712: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
713: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
714: x_request_id OUT NOCOPY NUMBER, -- One request ID per comparison request
715: x_return_status OUT NOCOPY VARCHAR2 ) ;

Line 713: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

709: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type ID
710: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
711: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
712: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
713: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
714: x_request_id OUT NOCOPY NUMBER, -- One request ID per comparison request
715: x_return_status OUT NOCOPY VARCHAR2 ) ;
716:
717: