APPS.FTE_RATE_CHART_PKG dependencies on FTE_LANE_PKG

Line 501: FTE_LANE_PKG.Check_Lanes(p_pricelist_id => l_list_header_id,

497: x_status := Check_Facilities(l_list_header_id, x_status, x_error_msg);
498: ELSIF (NOT g_is_ltl) THEN
499: --For LTL Lanes, we want to delete the rate chart even if it is assigned
500: --to Lanes. We later obsolete these lanes.
501: FTE_LANE_PKG.Check_Lanes(p_pricelist_id => l_list_header_id,
502: x_status => x_status,
503: x_error_msg => x_error_msg);
504:
505: IF (x_status <> -1) THEN

Line 615: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;

611: l_new_end_date DATE;
612: l_new_id NUMBER;
613: l_old_start_date DATE;
614: l_old_end_date DATE;
615: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
616: l_lane_tbl FTE_LANE_PKG.lane_tbl;
617: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
618: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
619:

Line 616: l_lane_tbl FTE_LANE_PKG.lane_tbl;

612: l_new_id NUMBER;
613: l_old_start_date DATE;
614: l_old_end_date DATE;
615: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
616: l_lane_tbl FTE_LANE_PKG.lane_tbl;
617: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
618: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
619:
620: CURSOR updated_lanes IS

Line 617: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;

613: l_old_start_date DATE;
614: l_old_end_date DATE;
615: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
616: l_lane_tbl FTE_LANE_PKG.lane_tbl;
617: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
618: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
619:
620: CURSOR updated_lanes IS
621: select lane_id

Line 618: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;

614: l_old_end_date DATE;
615: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
616: l_lane_tbl FTE_LANE_PKG.lane_tbl;
617: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
618: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
619:
620: CURSOR updated_lanes IS
621: select lane_id
622: from fte_lane_rate_charts

Line 695: l_overlap := FTE_LANE_PKG.VERIFY_OVERLAPPING_DATE(p_name => p_new_name,

691:
692:
693: -- I have to check if the new Rate Chart has date overlapping
694: -- with the existing rate charts attached to the same lane.
695: l_overlap := FTE_LANE_PKG.VERIFY_OVERLAPPING_DATE(p_name => p_new_name,
696: p_lane_id => l_lane_id,
697: x_status => x_status,
698: x_error_msg => x_error_msg);
699: IF (l_overlap) THEN

Line 716: FTE_LANE_PKG.INSERT_LANE_TABLES(p_lane_tbl => l_lane_tbl,

712: l_lane_rate_chart_tbl(1).list_header_id := l_new_id;
713: l_lane_rate_chart_tbl(1).start_date_active := l_new_start_date;
714: l_lane_rate_chart_tbl(1).end_date_active := l_new_end_date;
715:
716: FTE_LANE_PKG.INSERT_LANE_TABLES(p_lane_tbl => l_lane_tbl,
717: p_lane_rate_chart_tbl => l_lane_rate_chart_tbl,
718: p_lane_commodity_tbl => l_lane_commodity_tbl,
719: p_lane_service_tbl => l_lane_service_tbl,
720: x_status => x_status,