APPS.FTE_LANE_PKG dependencies on FTE_LANE_SERVICES

Line 56: TYPE LANE_SERVICE_ID_TBL IS TABLE OF FTE_LANE_SERVICES.LANE_SERVICE_ID%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;
60: TYPE VOYAGE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.VOYAGE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 291: SELECT fte_lane_services_s.nextval

287: ---------------------------------------------------------------------------
288: FUNCTION GET_NEXT_LANE_SERVICE_ID RETURN NUMBER IS
289: l_id NUMBER := -1;
290: BEGIN
291: SELECT fte_lane_services_s.nextval
292: INTO l_id
293: FROM dual;
294: RETURN l_id;
295: EXCEPTION

Line 469: FROM fte_lane_services

465: l_numfetch NUMBER;
466: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.FIND_TYPE';
467: CURSOR GET_SERVICE (p_lane_id IN NUMBER, p_value IN VARCHAR2) IS
468: SELECT 'true'
469: FROM fte_lane_services
470: WHERE service_code = p_value
471: AND lane_id = p_lane_id;
472:
473: CURSOR GET_COMMODITY (p_lane_id IN NUMBER, p_value IN VARCHAR2) IS

Line 574: ELSIF (p_table = 'FTE_LANE_SERVICES') THEN

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)
576: INTO l_result
577: FROM fte_lane_services
578: WHERE lane_id = p_id

Line 577: FROM fte_lane_services

573: AND commodity_catg_id = TO_NUMBER(p_code);
574: ELSIF (p_table = 'FTE_LANE_SERVICES') THEN
575: SELECT count(lane_id)
576: INTO l_result
577: FROM fte_lane_services
578: WHERE lane_id = p_id
579: AND service_code = p_code;
580: END IF;
581:

Line 645: ELSIF (p_table = 'FTE_LANE_SERVICES') THEN

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
647: WHERE lane_id = p_id
648: AND service_code = p_code;
649: ELSIF (p_table = 'FTE_LANES') THEN

Line 646: DELETE from fte_lane_services

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
647: WHERE lane_id = p_id
648: AND service_code = p_code;
649: ELSIF (p_table = 'FTE_LANES') THEN
650: UPDATE fte_lanes

Line 735: FROM fte_lane_services

731:
732: CURSOR Get_Service_Code (p_lane_id IN NUMBER)
733: IS
734: SELECT service_code
735: FROM fte_lane_services
736: WHERE lane_id = p_lane_id;
737:
738: BEGIN
739:

Line 1321: INSERT INTO FTE_LANE_SERVICES (LANE_ID,

1317: END LOOP;
1318:
1319: BEGIN
1320: FORALL i in p_lane_service_tbl.FIRST..p_lane_service_tbl.LAST
1321: INSERT INTO FTE_LANE_SERVICES (LANE_ID,
1322: LANE_SERVICE_ID,
1323: SERVICE_CODE,
1324: CREATED_BY,
1325: CREATION_DATE,