DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on FTE_ID_TAB_TYPE

Line 469: p_deliveries_list IN FTE_ID_TAB_TYPE,

465: PROCEDURE rerate_shipment_online(
466: p_api_version IN NUMBER DEFAULT 1.0,
467: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
468: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
469: p_deliveries_list IN FTE_ID_TAB_TYPE,
470: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
471: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
472: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
473: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,

Line 472: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,

468: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
469: p_deliveries_list IN FTE_ID_TAB_TYPE,
470: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
471: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
472: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
473: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,
474: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,

Line 473: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,

469: p_deliveries_list IN FTE_ID_TAB_TYPE,
470: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
471: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
472: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
473: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,
474: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2 );

Line 474: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,

470: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
471: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
472: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,
473: x_warning_list OUT NOCOPY FTE_ID_TAB_TYPE,
474: x_fail_list OUT NOCOPY FTE_ID_TAB_TYPE,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2 );
478:

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

694: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
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,

Line 702: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,

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,
706: p_dropoff_location_id IN NUMBER,

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

703: p_dep_date IN DATE DEFAULT sysdate,
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,

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

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,
713: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

Line 712: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,

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 ) ;
716: