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_LANES

Line 29: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;

25: ------------------------------------------------------------------------- --
26:
27: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_PKG';
28:
29: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE LANE_NUMBER_TBL IS TABLE OF FTE_LANES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%TYPE INDEX BY BINARY_INTEGER;
33: TYPE DESTINATION_ID_TBL IS TABLE OF FTE_LANES.DESTINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 30: TYPE LANE_NUMBER_TBL IS TABLE OF FTE_LANES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

26:
27: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_PKG';
28:
29: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE LANE_NUMBER_TBL IS TABLE OF FTE_LANES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%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;

Line 31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;

27: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_PKG';
28:
29: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE LANE_NUMBER_TBL IS TABLE OF FTE_LANES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%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;

Line 32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%TYPE INDEX BY BINARY_INTEGER;

28:
29: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE LANE_NUMBER_TBL IS TABLE OF FTE_LANES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%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;

Line 33: TYPE DESTINATION_ID_TBL IS TABLE OF FTE_LANES.DESTINATION_ID%TYPE INDEX BY BINARY_INTEGER;

29: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE LANE_NUMBER_TBL IS TABLE OF FTE_LANES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%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;

Line 34: TYPE MODE_OF_TRANS_TBL IS TABLE OF FTE_LANES.MODE_OF_TRANSPORTATION_CODE%TYPE INDEX BY BINARY_INTEGER;

30: TYPE LANE_NUMBER_TBL IS TABLE OF FTE_LANES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%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;

Line 35: TYPE TRANSIT_TIME_TBL IS TABLE OF FTE_LANES.TRANSIT_TIME%TYPE INDEX BY BINARY_INTEGER;

31: TYPE CARRIER_ID_TBL IS TABLE OF FTE_LANES.CARRIER_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%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;

Line 36: TYPE TRANSIT_TIME_UOM_TBL IS TABLE OF FTE_LANES.TRANSIT_TIME_UOM%TYPE INDEX BY BINARY_INTEGER;

32: TYPE ORIGIN_ID_TBL IS TABLE OF FTE_LANES.ORIGIN_ID%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;

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 38: TYPE ADDITIONAL_INSTRUCTIONS_TBL IS TABLE OF FTE_LANES.ADDITIONAL_INSTRUCTIONS%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;
42: TYPE SERVICE_TYPE_CODE_TBL IS TABLE OF FTE_LANES.SERVICE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 39: TYPE COMM_FC_CLASS_TBL IS TABLE OF FTE_LANES.COMM_FC_CLASS_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;
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;

Line 40: TYPE COMM_CATG_ID_TBL IS TABLE OF FTE_LANES.COMMODITY_CATG_ID%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;
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;

Line 41: TYPE EQUIP_TYPE_CODE_TBL IS TABLE OF FTE_LANES.EQUIPMENT_TYPE_CODE%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;
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;

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 43: TYPE DISTANCE_TBL IS TABLE OF FTE_LANES.DISTANCE%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;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 44: TYPE DISTANCE_UOM_TBL IS TABLE OF FTE_LANES.DISTANCE_UOM%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;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 45: TYPE PRICELIST_VIEW_FLAG_TBL IS TABLE OF FTE_LANES.PRICELIST_VIEW_FLAG%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;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 46: TYPE BASIS_TBL IS TABLE OF FTE_LANES.BASIS%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;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%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;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%TYPE INDEX BY BINARY_INTEGER;
51: TYPE TARIFF_NAME_TBL IS TABLE OF FTE_LANES.TARIFF_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%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;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%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;

Line 49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%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;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%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;

Line 50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%TYPE INDEX BY BINARY_INTEGER;

46: TYPE BASIS_TBL IS TABLE OF FTE_LANES.BASIS%TYPE INDEX BY BINARY_INTEGER;
47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%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;

Line 51: TYPE TARIFF_NAME_TBL IS TABLE OF FTE_LANES.TARIFF_NAME%TYPE INDEX BY BINARY_INTEGER;

47: TYPE EFFECTIVE_DATE_TBL IS TABLE OF FTE_LANES.EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
48: TYPE EXPIRY_DATE_TBL IS TABLE OF FTE_LANES.EXPIRY_DATE%TYPE INDEX BY BINARY_INTEGER;
49: TYPE EDITABLE_FLAG_TBL IS TABLE OF FTE_LANES.EDITABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
50: TYPE LANE_TYPE_TBL IS TABLE OF FTE_LANES.LANE_TYPE%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;

Line 177: FROM fte_lanes

173: l_lane_id NUMBER := -1;
174: BEGIN
175: SELECT lane_id
176: INTO l_lane_id
177: FROM fte_lanes
178: WHERE lane_number = p_lane_number
179: AND carrier_id = p_carrier_id
180: AND editable_flag <> 'D';
181: RETURN l_lane_id;

Line 210: FROM fte_lanes l, fte_lane_rate_charts c

206: x_error_msg OUT NOCOPY VARCHAR2) IS
207:
208: CURSOR lane_number IS
209: SELECT l.lane_number
210: FROM fte_lanes l, fte_lane_rate_charts c
211: WHERE c.lane_id = l.lane_id
212: AND c.list_header_id = p_pricelist_id
213: AND l.editable_flag <> 'D';
214:

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

Line 649: ELSIF (p_table = 'FTE_LANES') THEN

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
651: SET editable_flag = 'D',
652: lane_number = p_id || '-DELETED by USER', -- might just leave the lane number as it
653: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 650: UPDATE fte_lanes

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
651: SET editable_flag = 'D',
652: lane_number = p_id || '-DELETED by USER', -- might just leave the lane number as it
653: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
654: LAST_UPDATE_DATE = sysdate,

Line 779: UPDATE fte_lanes

775: l_flag := 'Y';
776: END IF;
777:
778: IF (p_type = 'SERVICE_LEVEL') THEN
779: UPDATE fte_lanes
780: SET service_type_code = l_code,
781: service_detail_flag = l_flag,
782: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
783: LAST_UPDATE_DATE = sysdate,

Line 787: UPDATE fte_lanes

783: LAST_UPDATE_DATE = sysdate,
784: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
785: WHERE lane_id = p_lane_id;
786: ELSIF (p_type = 'COMMODITY_TYPE') THEN
787: UPDATE fte_lanes
788: SET commodity_catg_id = TO_NUMBER(l_code),
789: commodity_detail_flag = l_flag,
790: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
791: LAST_UPDATE_DATE = sysdate,

Line 795: UPDATE fte_lanes

791: LAST_UPDATE_DATE = sysdate,
792: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
793: WHERE lane_id = p_lane_id;
794: ELSE -- schedule
795: UPDATE fte_lanes
796: SET schedules_flag = p_value,
797: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
798: LAST_UPDATE_DATE = sysdate,
799: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

Line 1056: UPDATE FTE_LANES

1052: IF (p_lane_tbl.COUNT > 0) THEN
1053: FOR i in p_lane_tbl.FIRST..p_lane_tbl.LAST LOOP
1054: IF (p_lane_tbl(i).action = 'UPDATE') THEN
1055: l_update := TRUE;
1056: UPDATE FTE_LANES
1057: SET COMM_FC_CLASS_CODE = p_lane_tbl(i).comm_fc_class_code,
1058: ORIGIN_ID = nvl(p_lane_tbl(i).origin_id, ORIGIN_ID),
1059: DESTINATION_ID = nvl(p_lane_tbl(i).destination_id, DESTINATION_ID),
1060: LANE_TYPE = nvl(p_lane_tbl(i).lane_type, lane_type),

Line 1103: INSERT INTO FTE_LANES (LANE_ID,

1099:
1100: IF (NOT l_update) THEN
1101: BEGIN
1102: FORALL i in l_lane_id.FIRST..l_lane_id.LAST
1103: INSERT INTO FTE_LANES (LANE_ID,
1104: LANE_NUMBER,
1105: OWNER_ID,
1106: CARRIER_ID,
1107: ORIGIN_ID,

Line 1189: p_msg_name => 'FTE_LANES_LOADED',

1185: --+
1186: -- For Generating Output file
1187: --+
1188: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1189: p_msg_name => 'FTE_LANES_LOADED',
1190: p_category => NULL);
1191:
1192: FOR i in l_lane_number.FIRST..l_lane_number.LAST LOOP
1193:

Line 1232: -- Remove the hold from fte_lanes

1228: FND_GLOBAL.USER_ID,
1229: SYSDATE,
1230: FND_GLOBAL.USER_ID);
1231: --+
1232: -- Remove the hold from fte_lanes
1233: -- for these rate charts.
1234: --+
1235: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Updating lane_type of fte_lanes... ');

Line 1236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Updating lane_type of fte_lanes... ');

1232: -- Remove the hold from fte_lanes
1233: -- for these rate charts.
1234: --+
1235: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Updating lane_type of fte_lanes... ');
1237: END IF;
1238: FORALL i in l_lrc_lane_id.FIRST..l_lrc_lane_id.LAST
1239: UPDATE fte_lanes
1240: SET lane_type = NULL,

Line 1239: UPDATE fte_lanes

1235: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Updating lane_type of fte_lanes... ');
1237: END IF;
1238: FORALL i in l_lrc_lane_id.FIRST..l_lrc_lane_id.LAST
1239: UPDATE fte_lanes
1240: SET lane_type = NULL,
1241: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1242: LAST_UPDATE_DATE = SYSDATE,
1243: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID