APPS.FTE_RATE_CHART_PKG dependencies on FTE_LANE_RATE_CHARTS

Line 594: -- Also, it creates a new entry into FTE_LANE_RATE_CHARTS with the info

590: -- PROCEDURE Replace_Rate_Chart
591: --
592: -- Purpose: This procedure osolete the old rate chart setting the expiry_date
593: -- of the Old Rate Chart as the (effective_date -1) of the new Rate Chart.
594: -- Also, it creates a new entry into FTE_LANE_RATE_CHARTS with the info
595: -- related to the new Rate Chart
596: --
597: --
598: -- IN Parameters

Line 622: from fte_lane_rate_charts

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
623: where list_header_id = p_old_id;
624:
625: l_lane_id NUMBER;
626: l_debug_count number;

Line 671: -- Update FTE_LANE_RATE_CHARTS

667: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
668: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update Lane ' || l_lane_id || ' with new rate chart id ' || l_new_id);
669: END IF;
670:
671: -- Update FTE_LANE_RATE_CHARTS
672: UPDATE fte_lane_rate_charts
673: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),
674: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
675: LAST_UPDATE_DATE = sysdate,

Line 672: UPDATE fte_lane_rate_charts

668: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update Lane ' || l_lane_id || ' with new rate chart id ' || l_new_id);
669: END IF;
670:
671: -- Update FTE_LANE_RATE_CHARTS
672: UPDATE fte_lane_rate_charts
673: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),
674: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
675: LAST_UPDATE_DATE = sysdate,
676: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID