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_SCHEDULES

Line 58: TYPE VESSEL_NAME_TBL IS TABLE OF FTE_SCHEDULES.VESSEL_NAME%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;
61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;

Line 59: TYPE VESSEL_TYPE_TBL IS TABLE OF FTE_SCHEDULES.VESSEL_TYPE%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;
61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;

Line 60: TYPE VOYAGE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.VOYAGE_NUMBER%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;
61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;

Line 61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%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;
61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;

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;
61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;

Line 63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%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;
61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;

Line 64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;

60: TYPE VOYAGE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.VOYAGE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;

Line 65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;

61: TYPE ARRIVAL_DATE_INDICATOR_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;

Line 66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;

62: TYPE SCH_TRANSIT_TIME_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;

63: TYPE PORT_OF_LOADING_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_LOADING%TYPE INDEX BY BINARY_INTEGER;
64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;

64: TYPE PORT_OF_DISCHARGE_TBL IS TABLE OF FTE_SCHEDULES.PORT_OF_DISCHARGE%TYPE INDEX BY BINARY_INTEGER;
65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;

65: TYPE FREQUENCY_TYPE_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;

66: TYPE FREQUENCY_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY%TYPE INDEX BY BINARY_INTEGER;
67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;

Line 71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;

67: TYPE FREQUENCY_ARRIVAL_TBL IS TABLE OF FTE_SCHEDULES.FREQUENCY_ARRIVAL%TYPE INDEX BY BINARY_INTEGER;
68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;

68: TYPE DEPARTURE_TIME_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_TIME%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;

69: TYPE ARRIVAL_TIME_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_TIME%TYPE INDEX BY BINARY_INTEGER;
70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;
77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;

70: TYPE DEPARTURE_DATE_TBL IS TABLE OF FTE_SCHEDULES.DEPARTURE_DATE%TYPE INDEX BY BINARY_INTEGER;
71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;
77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78:

Line 75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;

71: TYPE ARRIVAL_DATE_TBL IS TABLE OF FTE_SCHEDULES.ARRIVAL_DATE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;
77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78:
79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;

72: TYPE SCH_EFFECTIVE_DATE_TBL IS TABLE OF FTE_SCHEDULES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;
77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78:
79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;

Line 77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

73: TYPE SCH_EXPIRY_DATE_TBL IS TABLE OF FTE_SCHEDULES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
74: TYPE SCH_TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_SCHEDULES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;
77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78:
79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 97: SELECT fte_schedules_s.nextval

93: --------------------------------------------------------------------------
94: FUNCTION GET_NEXT_SCHEDULE_ID RETURN NUMBER IS
95: l_id NUMBER;
96: BEGIN
97: SELECT fte_schedules_s.nextval
98: INTO l_id
99: FROM dual;
100: RETURN l_id;
101: EXCEPTION

Line 147: FROM fte_schedules

143: l_id NUMBER;
144: BEGIN
145: SELECT schedules_id
146: INTO l_id
147: FROM fte_schedules
148: WHERE lane_id = p_lane_id
149: AND voyage_number = p_voyage
150: AND nvl(editable_flag,'Y') = 'Y';
151: RETURN l_id;

Line 666: ELSIF (p_table = 'FTE_SCHEDULES') THEN

662: DELETE from fte_prc_parameters
663: WHERE lane_id = p_id
664: AND parameter_id = TO_NUMBER(p_code);
665: END IF;
666: ELSIF (p_table = 'FTE_SCHEDULES') THEN
667:
668: UPDATE FTE_SCHEDULES
669: SET EDITABLE_FLAG = 'D',
670: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 668: UPDATE FTE_SCHEDULES

664: AND parameter_id = TO_NUMBER(p_code);
665: END IF;
666: ELSIF (p_table = 'FTE_SCHEDULES') THEN
667:
668: UPDATE FTE_SCHEDULES
669: SET EDITABLE_FLAG = 'D',
670: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
671: LAST_UPDATE_DATE = sysdate,
672: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

Line 896: INSERT INTO FTE_SCHEDULES(LANE_ID,

892: END LOOP;
893:
894: BEGIN
895: FORALL i in p_schedule_tbl.FIRST..p_schedule_tbl.LAST
896: INSERT INTO FTE_SCHEDULES(LANE_ID,
897: SCHEDULES_ID,
898: VESSEL_NAME,
899: VESSEL_TYPE,
900: VOYAGE_NUMBER,