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_VALIDATION_PKG dependencies on FTE_LANE_PKG

Line 875: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,

871: --
872: ------------------------------------------------------------------
873:
874: PROCEDURE VERIFY_LANE_BASIS(p_lane_id IN NUMBER,
875: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
876: p_line_number IN NUMBER,
877: x_status OUT NOCOPY NUMBER,
878: x_error_msg OUT NOCOPY VARCHAR2) IS
879: l_basis VARCHAR2(100);

Line 1359: p_lane_id := FTE_LANE_PKG.GET_LANE_ID(p_lane_number, p_carrier_id);

1355: RETURN;
1356: ELSIF (p_carrier_id <> -1) THEN
1357: -- Search for Lane Number in fte_lanes table
1358: -- Vijay: added clause to check if laneId is already populated
1359: p_lane_id := FTE_LANE_PKG.GET_LANE_ID(p_lane_number, p_carrier_id);
1360: IF (p_lane_id = -1) THEN
1361: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_LANE_NUMBER_INVALID',
1362: p_tokens => STRINGARRAY('SERVICE_NUMBER'),
1363: p_values => STRINGARRAY(p_lane_number));

Line 2233: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,

2229: ----------------------------------------------------------------------------
2230: PROCEDURE VALIDATE_LANE_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2231: p_line_number IN NUMBER,
2232: p_action IN VARCHAR2,
2233: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,
2234: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
2235: p_set_error IN BOOLEAN DEFAULT TRUE,
2236: x_status OUT NOCOPY NUMBER,
2237: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 2234: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,

2230: PROCEDURE VALIDATE_LANE_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2231: p_line_number IN NUMBER,
2232: p_action IN VARCHAR2,
2233: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,
2234: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
2235: p_set_error IN BOOLEAN DEFAULT TRUE,
2236: x_status OUT NOCOPY NUMBER,
2237: x_error_msg OUT NOCOPY VARCHAR2) IS
2238: l_rate_chart_name VARCHAR2(200);

Line 2314: IF (FTE_LANE_PKG.CHECK_EXISTING_LOAD(p_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,

2310: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', l_rate_chart_info(1));
2311: END IF;
2312:
2313: IF (p_action <> 'DELETE') THEN
2314: IF (FTE_LANE_PKG.CHECK_EXISTING_LOAD(p_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,
2315: p_table => 'FTE_LANE_RATE_CHARTS',
2316: p_code => TO_NUMBER(l_rate_chart_info(1)),
2317: p_line_number => p_line_number,
2318: x_status => x_status,

Line 2336: IF (FTE_LANE_PKG.VERIFY_OVERLAPPING_DATE(p_name => l_rate_chart_name,

2332: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
2333: RETURN;
2334: END IF;
2335:
2336: IF (FTE_LANE_PKG.VERIFY_OVERLAPPING_DATE(p_name => l_rate_chart_name,
2337: p_lane_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,
2338: x_status => x_status,
2339: x_error_msg => x_error_msg)) THEN
2340: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DATE_OVERLAP',

Line 2468: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,

2464: PROCEDURE VALIDATE_LANE_COMMODITY(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2465: p_line_number IN NUMBER,
2466: p_type IN VARCHAR2,
2467: p_action IN VARCHAR2,
2468: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,
2469: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
2470: x_status OUT NOCOPY NUMBER,
2471: x_error_msg OUT NOCOPY VARCHAR2) IS
2472: l_catg_id NUMBER := -1;

Line 2469: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,

2465: p_line_number IN NUMBER,
2466: p_type IN VARCHAR2,
2467: p_action IN VARCHAR2,
2468: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,
2469: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
2470: x_status OUT NOCOPY NUMBER,
2471: x_error_msg OUT NOCOPY VARCHAR2) IS
2472: l_catg_id NUMBER := -1;
2473: l_count NUMBER;

Line 2565: IF (FTE_LANE_PKG.CHECK_EXISTING_LOAD(p_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,

2561: x_status := 1;
2562: RETURN;
2563: ELSE
2564: IF (p_action = 'ADD') THEN
2565: IF (FTE_LANE_PKG.CHECK_EXISTING_LOAD(p_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,
2566: p_table => 'FTE_LANE_COMMODITIES',
2567: p_code => l_catg_id,
2568: p_line_number => p_line_number,
2569: x_status => x_status,

Line 2624: p_lane_commodity_tbl(l_count).lane_commodity_id := FTE_LANE_PKG.GET_NEXT_LANE_COMMODITY_ID;

2620: END IF;
2621: END IF;
2622:
2623: p_lane_commodity_tbl(l_count).lane_id := p_lane_tbl(p_lane_tbl.COUNT).lane_id;
2624: p_lane_commodity_tbl(l_count).lane_commodity_id := FTE_LANE_PKG.GET_NEXT_LANE_COMMODITY_ID;
2625:
2626: END IF;
2627: ELSE
2628: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_LANE_REF_MISSING');

Line 2673: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,

2669: PROCEDURE VALIDATE_LANE_SERVICE_LEVEL(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2670: p_line_number IN NUMBER,
2671: p_type IN VARCHAR2,
2672: p_action IN VARCHAR2,
2673: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,
2674: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
2675: x_status OUT NOCOPY NUMBER,
2676: x_error_msg OUT NOCOPY VARCHAR2) IS
2677: l_service_level VARCHAR2(100);

Line 2674: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,

2670: p_line_number IN NUMBER,
2671: p_type IN VARCHAR2,
2672: p_action IN VARCHAR2,
2673: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,
2674: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
2675: x_status OUT NOCOPY NUMBER,
2676: x_error_msg OUT NOCOPY VARCHAR2) IS
2677: l_service_level VARCHAR2(100);
2678: l_service_code VARCHAR2(100);

Line 2774: IF (FTE_LANE_PKG.CHECK_EXISTING_LOAD(p_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,

2770: END IF;
2771: END IF;
2772:
2773: IF (p_action = 'ADD') THEN
2774: IF (FTE_LANE_PKG.CHECK_EXISTING_LOAD(p_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,
2775: p_table => 'FTE_LANE_SERVICES',
2776: p_code => l_service_code,
2777: p_line_number => p_line_number,
2778: x_status => x_status,

Line 2801: p_lane_service_tbl(l_count).lane_service_id := FTE_LANE_PKG.GET_NEXT_LANE_SERVICE_ID;

2797: l_count := p_lane_service_tbl.COUNT+1;
2798:
2799: p_lane_service_tbl(l_count).service_code := l_service_code;
2800: p_lane_service_tbl(l_count).lane_id := p_lane_tbl(p_lane_tbl.COUNT).lane_id;
2801: p_lane_service_tbl(l_count).lane_service_id := FTE_LANE_PKG.GET_NEXT_LANE_SERVICE_ID;
2802:
2803: END IF;
2804: ELSE
2805: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_LANE_REF_MISSING');

Line 2853: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,

2849: PROCEDURE VALIDATE_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2850: p_line_number IN NUMBER,
2851: p_type OUT NOCOPY VARCHAR2,
2852: p_action OUT NOCOPY VARCHAR2,
2853: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
2854: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
2855: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
2856: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
2857: x_status OUT NOCOPY NUMBER,

Line 2854: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,

2850: p_line_number IN NUMBER,
2851: p_type OUT NOCOPY VARCHAR2,
2852: p_action OUT NOCOPY VARCHAR2,
2853: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
2854: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
2855: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
2856: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
2857: x_status OUT NOCOPY NUMBER,
2858: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 2855: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,

2851: p_type OUT NOCOPY VARCHAR2,
2852: p_action OUT NOCOPY VARCHAR2,
2853: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
2854: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
2855: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
2856: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
2857: x_status OUT NOCOPY NUMBER,
2858: x_error_msg OUT NOCOPY VARCHAR2) IS
2859:

Line 2856: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,

2852: p_action OUT NOCOPY VARCHAR2,
2853: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
2854: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
2855: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
2856: p_lane_commodity_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_commodity_tbl,
2857: x_status OUT NOCOPY NUMBER,
2858: x_error_msg OUT NOCOPY VARCHAR2) IS
2859:
2860: l_effect_date VARCHAR2(30);

Line 3030: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);

3026: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
3027: x_status := 1;
3028: RETURN;
3029: ELSE
3030: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);
3031:
3032: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3033: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Old Lane ID', l_old_lane_id);
3034: END IF;

Line 3056: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;

3052: ELSIF (p_action = 'SYNC') THEN
3053: -- if laneNumber is not specified, it's assumed to be ADD
3054: IF (l_lane_number IS NULL) THEN
3055: l_old_lane_id := -1;
3056: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;
3057: ELSE
3058: -- To determine if it's ADD or UPDATE
3059: -- if there's a lane with the given laneNumber and carrirName
3060: -- oldLaneId is not -1, which means UPDATE

Line 3061: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);

3057: ELSE
3058: -- To determine if it's ADD or UPDATE
3059: -- if there's a lane with the given laneNumber and carrirName
3060: -- oldLaneId is not -1, which means UPDATE
3061: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);
3062: IF (l_old_lane_id = -1) THEN
3063: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;
3064: ELSE
3065: p_lane_tbl(l_count).lane_id := l_old_lane_id;

Line 3063: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;

3059: -- if there's a lane with the given laneNumber and carrirName
3060: -- oldLaneId is not -1, which means UPDATE
3061: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);
3062: IF (l_old_lane_id = -1) THEN
3063: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;
3064: ELSE
3065: p_lane_tbl(l_count).lane_id := l_old_lane_id;
3066: p_lane_tbl(l_count).action := 'UPDATE';
3067: END IF;

Line 3071: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);

3067: END IF;
3068: p_lane_tbl(l_count).lane_number := l_lane_number;
3069: END IF;
3070: ELSIF (p_action = 'DELETE') THEN
3071: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);
3072: p_lane_tbl(l_count).lane_id := l_old_lane_id;
3073: IF (l_old_lane_id = -1) THEN
3074: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_NUMBER_INVALID',
3075: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),

Line 3089: IF (-1 <> FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id)) THEN

3085: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
3086: RETURN;
3087: ELSIF (p_action = 'ADD') THEN
3088:
3089: IF (-1 <> FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id)) THEN
3090: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_REF_EXISTS',
3091: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),
3092: P_values => STRINGARRAY(l_lane_number));
3093: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 3101: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;

3097: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
3098: x_status := 1;
3099: RETURN;
3100: ELSE
3101: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;
3102: p_lane_tbl(l_count).lane_number := l_lane_number;
3103: END IF;
3104: END IF;
3105:

Line 3572: p_prc_parameter_tbl IN OUT NOCOPY FTE_LANE_PKG.prc_parameter_tbl,

3568: ----------------------------------------------------------------------------
3569: PROCEDURE VALIDATE_SERVICE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
3570: p_line_number IN NUMBER,
3571: p_pre_lane_number IN VARCHAR2,
3572: p_prc_parameter_tbl IN OUT NOCOPY FTE_LANE_PKG.prc_parameter_tbl,
3573: p_deficit_wt IN OUT NOCOPY BOOLEAN,
3574: p_lane_function IN OUT NOCOPY VARCHAR2,
3575: p_lane_number OUT NOCOPY VARCHAR2,
3576: p_action OUT NOCOPY VARCHAR2,

Line 4045: l_prc_parameter_id := FTE_LANE_PKG.GET_NEXT_PRC_PARAMETER_ID;

4041: END IF;
4042: END IF;
4043:
4044: IF (p_action = 'ADD') THEN
4045: l_prc_parameter_id := FTE_LANE_PKG.GET_NEXT_PRC_PARAMETER_ID;
4046: p_prc_parameter_tbl(l_count).parameter_instance_id := l_prc_parameter_id;
4047: p_prc_parameter_tbl(l_count).lane_id := l_lane_id;
4048: p_prc_parameter_tbl(l_count).parameter_id := l_parameter_id;
4049: ELSIF (p_action = 'UPDATE') THEN

Line 4092: p_schedule_tbl IN OUT NOCOPY FTE_LANE_PKG.schedule_tbl,

4088: -- 4. x_error_msg: error message if any.
4089: ----------------------------------------------------------------------------
4090: PROCEDURE VALIDATE_SCHEDULE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
4091: p_line_number IN NUMBER,
4092: p_schedule_tbl IN OUT NOCOPY FTE_LANE_PKG.schedule_tbl,
4093: p_action OUT NOCOPY VARCHAR2,
4094: x_status OUT NOCOPY NUMBER,
4095: x_error_msg OUT NOCOPY VARCHAR2) IS
4096:

Line 4600: l_old_schedule_id := FTE_LANE_PKG.GET_SCHEDULE(l_lane_id, l_voyage_number);

4596: END IF;
4597: END IF;
4598: END IF;
4599:
4600: l_old_schedule_id := FTE_LANE_PKG.GET_SCHEDULE(l_lane_id, l_voyage_number);
4601:
4602: IF (l_old_schedule_id = -1 AND (p_action IN ('SYNC', 'ADD'))) THEN
4603:
4604: p_action := 'ADD';

Line 4606: l_schedule_id := FTE_LANE_PKG.GET_NEXT_SCHEDULE_ID;

4602: IF (l_old_schedule_id = -1 AND (p_action IN ('SYNC', 'ADD'))) THEN
4603:
4604: p_action := 'ADD';
4605: p_schedule_tbl(l_count).lane_id := l_lane_id;
4606: l_schedule_id := FTE_LANE_PKG.GET_NEXT_SCHEDULE_ID;
4607: IF (l_schedule_id <> -1) THEN
4608: p_schedule_tbl(l_count).schedules_id := l_schedule_id;
4609:
4610: -- FTE_CAT_VALIDATION_PKG.VALIDATE_ELEMENTS(SCHEDULETABLE, data, _encoding, errors);

Line 6902: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,

6898: PROCEDURE VALIDATE_TL_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
6899: p_line_number IN NUMBER,
6900: p_type OUT NOCOPY VARCHAR2,
6901: p_action OUT NOCOPY VARCHAR2,
6902: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
6903: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
6904: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
6905: x_status OUT NOCOPY NUMBER,
6906: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 6903: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,

6899: p_line_number IN NUMBER,
6900: p_type OUT NOCOPY VARCHAR2,
6901: p_action OUT NOCOPY VARCHAR2,
6902: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
6903: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
6904: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
6905: x_status OUT NOCOPY NUMBER,
6906: x_error_msg OUT NOCOPY VARCHAR2) IS
6907:

Line 6904: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,

6900: p_type OUT NOCOPY VARCHAR2,
6901: p_action OUT NOCOPY VARCHAR2,
6902: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,
6903: p_lane_service_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_service_tbl,
6904: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,
6905: x_status OUT NOCOPY NUMBER,
6906: x_error_msg OUT NOCOPY VARCHAR2) IS
6907:
6908: l_effect_date VARCHAR2(30);

Line 7016: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);

7012: --+
7013: -- Get the lane id.
7014: -- Lane ID is -1 if this is new service, a +ve number otherwise.
7015: --+
7016: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);
7017:
7018: IF(g_debug_on) THEN
7019: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_old_lane_id ',l_old_lane_id);
7020: END IF;

Line 7071: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;

7067: ELSE
7068: --+
7069: -- Get a new Lane Id from the suquence "fte_lanes_s" for the new lane
7070: --+
7071: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;
7072: p_lane_tbl(l_count).lane_number := l_lane_number;
7073:
7074: END IF;
7075: