DBA Data[Home] [Help]

APPS.FTE_LANE_PKG dependencies on FTE_SCHEDULES_S

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 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