DBA Data[Home] [Help]

APPS.FTE_LANE_PKG dependencies on FTE_LANES_S

Line 37: TYPE SPECIAL_HANDLING_TBL IS TABLE OF FTE_LANES.SPECIAL_HANDLING%TYPE INDEX BY BINARY_INTEGER;

33: TYPE DESTINATION_ID_TBL IS TABLE OF FTE_LANES.DESTINATION_ID%TYPE INDEX BY BINARY_INTEGER;
34: TYPE MODE_OF_TRANS_TBL IS TABLE OF FTE_LANES.MODE_OF_TRANSPORTATION_CODE%TYPE INDEX BY BINARY_INTEGER;
35: TYPE TRANSIT_TIME_TBL IS TABLE OF FTE_LANES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;
36: TYPE TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_LANES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;
37: TYPE SPECIAL_HANDLING_TBL IS TABLE OF FTE_LANES.SPECIAL_HANDLING%TYPE INDEX BY BINARY_INTEGER;
38: TYPE ADDITIONAL_INSTRUCTIONS_TBL IS TABLE OF FTE_LANES.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER;
39: TYPE COMM_FC_CLASS_TBL IS TABLE OF FTE_LANES.COMM_FC_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
40: TYPE COMM_CATG_ID_TBL IS TABLE OF FTE_LANES.COMMODITY_CATG_ID%TYPE INDEX BY BINARY_INTEGER;
41: TYPE EQUIP_TYPE_CODE_TBL IS TABLE OF FTE_LANES.EQUIPMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 42: TYPE SERVICE_TYPE_CODE_TBL IS TABLE OF FTE_LANES.SERVICE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

38: TYPE ADDITIONAL_INSTRUCTIONS_TBL IS TABLE OF FTE_LANES.ADDITIONAL_INSTRUCTIONS%TYPE INDEX BY BINARY_INTEGER;
39: TYPE COMM_FC_CLASS_TBL IS TABLE OF FTE_LANES.COMM_FC_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
40: TYPE COMM_CATG_ID_TBL IS TABLE OF FTE_LANES.COMMODITY_CATG_ID%TYPE INDEX BY BINARY_INTEGER;
41: TYPE EQUIP_TYPE_CODE_TBL IS TABLE OF FTE_LANES.EQUIPMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
42: TYPE SERVICE_TYPE_CODE_TBL IS TABLE OF FTE_LANES.SERVICE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
43: TYPE DISTANCE_TBL IS TABLE OF FTE_LANES.DISTANCE%TYPE INDEX BY BINARY_INTEGER;
44: TYPE DISTANCE_UOM_TBL IS TABLE OF FTE_LANES.DISTANCE_UOM%TYPE INDEX BY BINARY_INTEGER;
45: TYPE PRICELIST_VIEW_FLAG_TBL IS TABLE OF FTE_LANES.PRICELIST_VIEW_FLAG%TYPE INDEX BY BINARY_INTEGER;
46: TYPE BASIS_TBL IS TABLE OF FTE_LANES.BASIS%TYPE INDEX BY BINARY_INTEGER;

Line 312: SELECT fte_lanes_s.nextval

308: ---------------------------------------------------------------------------
309: FUNCTION GET_NEXT_LANE_ID RETURN NUMBER IS
310: l_id NUMBER := -1;
311: BEGIN
312: SELECT fte_lanes_s.nextval
313: INTO l_id
314: FROM dual;
315: RETURN l_id;
316: EXCEPTION