eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_LANE_PKG dependencies on FTE_LANE_RATE_CHARTS

Line 52: TYPE LIST_HEADER_ID_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%TYPE INDEX BY BINARY_INTEGER;
51: TYPE TARIFF_NAME_TBL IS TABLE OF FTE_LANES.TARIFF_NAME%TYPE INDEX BY BINARY_INTEGER;
52: TYPE LIST_HEADER_ID_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
53: TYPE START_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
54: TYPE END_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
55: TYPE LANE_COMMODITY_ID_TBL IS TABLE OF FTE_LANE_COMMODITIES.LANE_COMMODITY_ID%TYPE INDEX BY BINARY_INTEGER;
56: TYPE LANE_SERVICE_ID_TBL IS TABLE OF FTE_LANE_SERVICES.LANE_SERVICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 53: TYPE START_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%TYPE INDEX BY BINARY_INTEGER;
51: TYPE TARIFF_NAME_TBL IS TABLE OF FTE_LANES.TARIFF_NAME%TYPE INDEX BY BINARY_INTEGER;
52: TYPE LIST_HEADER_ID_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
53: TYPE START_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
54: TYPE END_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
55: TYPE LANE_COMMODITY_ID_TBL IS TABLE OF FTE_LANE_COMMODITIES.LANE_COMMODITY_ID%TYPE INDEX BY BINARY_INTEGER;
56: TYPE LANE_SERVICE_ID_TBL IS TABLE OF FTE_LANE_SERVICES.LANE_SERVICE_ID%TYPE INDEX BY BINARY_INTEGER;
57:

Line 54: TYPE END_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%TYPE INDEX BY BINARY_INTEGER;
51: TYPE TARIFF_NAME_TBL IS TABLE OF FTE_LANES.TARIFF_NAME%TYPE INDEX BY BINARY_INTEGER;
52: TYPE LIST_HEADER_ID_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
53: TYPE START_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
54: TYPE END_DATE_ACTIVE_TBL IS TABLE OF FTE_LANE_RATE_CHARTS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
55: TYPE LANE_COMMODITY_ID_TBL IS TABLE OF FTE_LANE_COMMODITIES.LANE_COMMODITY_ID%TYPE INDEX BY BINARY_INTEGER;
56: TYPE LANE_SERVICE_ID_TBL IS TABLE OF FTE_LANE_SERVICES.LANE_SERVICE_ID%TYPE INDEX BY BINARY_INTEGER;
57:
58: TYPE VESSEL_NAME_TBL IS TABLE OF FTE_SCHEDULES.VESSEL_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 210: FROM fte_lanes l, fte_lane_rate_charts c

206: x_error_msg OUT NOCOPY VARCHAR2) IS
207:
208: CURSOR lane_number IS
209: SELECT l.lane_number
210: FROM fte_lanes l, fte_lane_rate_charts c
211: WHERE c.lane_id = l.lane_id
212: AND c.list_header_id = p_pricelist_id
213: AND l.editable_flag <> 'D';
214:

Line 369: FROM fte_lane_rate_charts

365:
366: IF (l_start_date_active IS NULL AND l_end_date_active IS NULL) THEN
367: SELECT count(list_header_id)
368: INTO l_number_of_chart
369: FROM fte_lane_rate_charts
370: WHERE lane_id = p_lane_id;
371:
372: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
373:

Line 384: FROM fte_lane_rate_charts

380:
381: IF (l_start_date_active IS NULL) THEN
382: SELECT count(list_header_id)
383: INTO l_number_of_chart
384: FROM fte_lane_rate_charts
385: WHERE lane_id = p_lane_id
386: AND ((nvl(start_date_active, l_end_date_active) <= l_end_date_active));
387: ELSIF (l_end_date_active IS NULL) THEN
388: SELECT count(list_header_id)

Line 390: FROM fte_lane_rate_charts

386: AND ((nvl(start_date_active, l_end_date_active) <= l_end_date_active));
387: ELSIF (l_end_date_active IS NULL) THEN
388: SELECT count(list_header_id)
389: INTO l_number_of_chart
390: FROM fte_lane_rate_charts
391: WHERE lane_id = p_lane_id
392: AND ((nvl(end_date_active, l_start_date_active) >= l_start_date_active));
393: ELSE
394: SELECT count(list_header_id)

Line 396: FROM fte_lane_rate_charts

392: AND ((nvl(end_date_active, l_start_date_active) >= l_start_date_active));
393: ELSE
394: SELECT count(list_header_id)
395: INTO l_number_of_chart
396: FROM fte_lane_rate_charts
397: WHERE lane_id = p_lane_id
398: AND ((nvl(start_date_active, l_start_date_active) <= l_start_date_active AND nvl(end_date_active, l_end_date_active) >= l_start_date_active)
399: OR (nvl(start_date_active, l_start_date_active) <= l_end_date_active AND nvl(end_date_active, l_end_date_active) >= l_end_date_active)
400: OR (nvl(end_date_active, l_start_date_active) >= l_start_date_active AND nvl(start_date_active, l_end_date_active) <= l_end_date_active));

Line 562: IF (p_table = 'FTE_LANE_RATE_CHARTS') THEN

558: END IF;
559:
560: x_status := -1;
561:
562: IF (p_table = 'FTE_LANE_RATE_CHARTS') THEN
563: SELECT count(lane_id)
564: INTO l_result
565: FROM fte_lane_rate_charts
566: WHERE lane_id = p_id

Line 565: FROM fte_lane_rate_charts

561:
562: IF (p_table = 'FTE_LANE_RATE_CHARTS') THEN
563: SELECT count(lane_id)
564: INTO l_result
565: FROM fte_lane_rate_charts
566: WHERE lane_id = p_id
567: AND list_header_id = TO_NUMBER(p_code);
568: ELSIF (p_table = 'FTE_LANE_COMMODITIES') THEN
569: SELECT count(lane_id)

Line 637: IF (p_table = 'FTE_LANE_RATE_CHARTS') THEN

633: END IF;
634:
635: x_status := -1;
636:
637: IF (p_table = 'FTE_LANE_RATE_CHARTS') THEN
638: DELETE from fte_lane_rate_charts
639: WHERE lane_id = p_id
640: AND list_header_id = TO_NUMBER(p_code);
641: ELSIF (p_table = 'FTE_LANE_COMMODITIES') THEN

Line 638: DELETE from fte_lane_rate_charts

634:
635: x_status := -1;
636:
637: IF (p_table = 'FTE_LANE_RATE_CHARTS') THEN
638: DELETE from fte_lane_rate_charts
639: WHERE lane_id = p_id
640: AND list_header_id = TO_NUMBER(p_code);
641: ELSIF (p_table = 'FTE_LANE_COMMODITIES') THEN
642: DELETE from fte_lane_commodities

Line 1213: INSERT INTO FTE_LANE_RATE_CHARTS (LANE_ID,

1209: END LOOP;
1210:
1211: BEGIN
1212: FORALL i in p_lane_rate_chart_tbl.FIRST..p_lane_rate_chart_tbl.LAST
1213: INSERT INTO FTE_LANE_RATE_CHARTS (LANE_ID,
1214: LIST_HEADER_ID,
1215: END_DATE_ACTIVE,
1216: START_DATE_ACTIVE,
1217: CREATED_BY,

Line 1488: -- 1. p_list_header_id: the rate chart to update in fte_lane_rate_charts

1484: --
1485: -- Purpose: update lane rate chart's dates
1486: --
1487: -- IN parameters:
1488: -- 1. p_list_header_id: the rate chart to update in fte_lane_rate_charts
1489: -- 2. p_start_date: start date
1490: -- 3. p_end_date: end date
1491: --
1492: -- OUT parameters:

Line 1514: UPDATE fte_lane_rate_charts

1510: END IF;
1511:
1512: x_status := -1;
1513:
1514: UPDATE fte_lane_rate_charts
1515: SET START_DATE_ACTIVE = p_start_date,
1516: END_DATE_ACTIVE = p_end_date,
1517: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1518: LAST_UPDATE_DATE = sysdate,