DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on WSH_UTIL_CORE

Line 634: p_lane_id_tab IN WSH_UTIL_CORE.id_tab_type,

630:
631: PROCEDURE shipment_price_compare_pvt (
632: p_delivery_id IN NUMBER DEFAULT NULL,
633: p_trip_id IN NUMBER DEFAULT NULL,
634: p_lane_id_tab IN WSH_UTIL_CORE.id_tab_type,
635: p_sched_id_tab IN WSH_UTIL_CORE.id_tab_type,
636: p_service_lane_tab IN WSH_UTIL_CORE.Column_Tab_Type,
637: p_service_sched_tab IN WSH_UTIL_CORE.Column_Tab_Type,
638: p_dep_date IN DATE DEFAULT sysdate,

Line 635: p_sched_id_tab IN WSH_UTIL_CORE.id_tab_type,

631: PROCEDURE shipment_price_compare_pvt (
632: p_delivery_id IN NUMBER DEFAULT NULL,
633: p_trip_id IN NUMBER DEFAULT NULL,
634: p_lane_id_tab IN WSH_UTIL_CORE.id_tab_type,
635: p_sched_id_tab IN WSH_UTIL_CORE.id_tab_type,
636: p_service_lane_tab IN WSH_UTIL_CORE.Column_Tab_Type,
637: p_service_sched_tab IN WSH_UTIL_CORE.Column_Tab_Type,
638: p_dep_date IN DATE DEFAULT sysdate,
639: p_arr_date IN DATE DEFAULT sysdate,

Line 636: p_service_lane_tab IN WSH_UTIL_CORE.Column_Tab_Type,

632: p_delivery_id IN NUMBER DEFAULT NULL,
633: p_trip_id IN NUMBER DEFAULT NULL,
634: p_lane_id_tab IN WSH_UTIL_CORE.id_tab_type,
635: p_sched_id_tab IN WSH_UTIL_CORE.id_tab_type,
636: p_service_lane_tab IN WSH_UTIL_CORE.Column_Tab_Type,
637: p_service_sched_tab IN WSH_UTIL_CORE.Column_Tab_Type,
638: p_dep_date IN DATE DEFAULT sysdate,
639: p_arr_date IN DATE DEFAULT sysdate,
640: x_sum_lane_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

Line 637: p_service_sched_tab IN WSH_UTIL_CORE.Column_Tab_Type,

633: p_trip_id IN NUMBER DEFAULT NULL,
634: p_lane_id_tab IN WSH_UTIL_CORE.id_tab_type,
635: p_sched_id_tab IN WSH_UTIL_CORE.id_tab_type,
636: p_service_lane_tab IN WSH_UTIL_CORE.Column_Tab_Type,
637: p_service_sched_tab IN WSH_UTIL_CORE.Column_Tab_Type,
638: p_dep_date IN DATE DEFAULT sysdate,
639: p_arr_date IN DATE DEFAULT sysdate,
640: x_sum_lane_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
641: x_sum_lane_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,

Line 640: x_sum_lane_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

636: p_service_lane_tab IN WSH_UTIL_CORE.Column_Tab_Type,
637: p_service_sched_tab IN WSH_UTIL_CORE.Column_Tab_Type,
638: p_dep_date IN DATE DEFAULT sysdate,
639: p_arr_date IN DATE DEFAULT sysdate,
640: x_sum_lane_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
641: x_sum_lane_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
642: x_sum_sched_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
643: x_sum_sched_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
644: x_request_id IN OUT NOCOPY NUMBER,

Line 641: x_sum_lane_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,

637: p_service_sched_tab IN WSH_UTIL_CORE.Column_Tab_Type,
638: p_dep_date IN DATE DEFAULT sysdate,
639: p_arr_date IN DATE DEFAULT sysdate,
640: x_sum_lane_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
641: x_sum_lane_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
642: x_sum_sched_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
643: x_sum_sched_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
644: x_request_id IN OUT NOCOPY NUMBER,
645: x_return_status OUT NOCOPY VARCHAR2 );

Line 642: x_sum_sched_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

638: p_dep_date IN DATE DEFAULT sysdate,
639: p_arr_date IN DATE DEFAULT sysdate,
640: x_sum_lane_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
641: x_sum_lane_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
642: x_sum_sched_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
643: x_sum_sched_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
644: x_request_id IN OUT NOCOPY NUMBER,
645: x_return_status OUT NOCOPY VARCHAR2 );
646:

Line 643: x_sum_sched_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,

639: p_arr_date IN DATE DEFAULT sysdate,
640: x_sum_lane_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
641: x_sum_lane_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
642: x_sum_sched_price_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
643: x_sum_sched_price_curr_tab OUT NOCOPY WSH_UTIL_CORE.Column_tab_type,
644: x_request_id IN OUT NOCOPY NUMBER,
645: x_return_status OUT NOCOPY VARCHAR2 );
646:
647: -- Returns the freight_cost_id of the delivery leg summary record in WSH_FREIGHT_COSTS