APPS.FTE_LANE_PKG dependencies on FTE_LANE_COMMODITIES

Line 55: TYPE LANE_COMMODITY_ID_TBL IS TABLE OF FTE_LANE_COMMODITIES.LANE_COMMODITY_ID%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;
59: TYPE VESSEL_TYPE_TBL IS TABLE OF FTE_SCHEDULES.VESSEL_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 270: SELECT fte_lane_commodities_s.nextval

266: ---------------------------------------------------------------------------
267: FUNCTION GET_NEXT_LANE_COMMODITY_ID RETURN NUMBER IS
268: l_id NUMBER := -1;
269: BEGIN
270: SELECT fte_lane_commodities_s.nextval
271: INTO l_id
272: FROM dual;
273: RETURN l_id;
274: EXCEPTION

Line 475: FROM fte_lane_commodities

471: AND lane_id = p_lane_id;
472:
473: CURSOR GET_COMMODITY (p_lane_id IN NUMBER, p_value IN VARCHAR2) IS
474: SELECT 'true'
475: FROM fte_lane_commodities
476: WHERE commodity_catg_id = TO_NUMBER(p_value)
477: AND lane_id = p_lane_id;
478:
479: BEGIN

Line 568: ELSIF (p_table = 'FTE_LANE_COMMODITIES') THEN

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)
570: INTO l_result
571: FROM fte_lane_commodities
572: WHERE lane_id = p_id

Line 571: FROM fte_lane_commodities

567: AND list_header_id = TO_NUMBER(p_code);
568: ELSIF (p_table = 'FTE_LANE_COMMODITIES') THEN
569: SELECT count(lane_id)
570: INTO l_result
571: FROM fte_lane_commodities
572: WHERE lane_id = p_id
573: AND commodity_catg_id = TO_NUMBER(p_code);
574: ELSIF (p_table = 'FTE_LANE_SERVICES') THEN
575: SELECT count(lane_id)

Line 641: ELSIF (p_table = 'FTE_LANE_COMMODITIES') THEN

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
643: WHERE lane_id = p_id
644: AND commodity_catg_id = TO_NUMBER(p_code);
645: ELSIF (p_table = 'FTE_LANE_SERVICES') THEN

Line 642: DELETE from fte_lane_commodities

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
643: WHERE lane_id = p_id
644: AND commodity_catg_id = TO_NUMBER(p_code);
645: ELSIF (p_table = 'FTE_LANE_SERVICES') THEN
646: DELETE from fte_lane_services

Line 729: FROM fte_lane_commodities

725: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_LANE_FLAGS';
726: CURSOR Get_Commodity_Type (p_lane_id IN NUMBER)
727: IS
728: SELECT TO_CHAR(commodity_catg_id)
729: FROM fte_lane_commodities
730: WHERE lane_id = p_lane_id;
731:
732: CURSOR Get_Service_Code (p_lane_id IN NUMBER)
733: IS

Line 1275: INSERT INTO FTE_LANE_COMMODITIES (LANE_ID,

1271: END LOOP;
1272:
1273: BEGIN
1274: FORALL i in p_lane_commodity_tbl.FIRST..p_lane_commodity_tbl.LAST
1275: INSERT INTO FTE_LANE_COMMODITIES (LANE_ID,
1276: LANE_COMMODITY_ID,
1277: BASIS,
1278: COMMODITY_CATG_ID,
1279: CREATED_BY,