APPS.FTE_TL_LOADER dependencies on FTE_RTG_GLOBALS

Line 317: IF (p_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT, -- Container

313: FTE_UTIL_PKG.Exit_Debug(l_module_name);
314: RETURN;
315: END IF;
316:
317: IF (p_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT, -- Container
318: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET, -- Pallet
319: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT, -- Weight
320: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL)) THEN -- Volume
321:

Line 318: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET, -- Pallet

314: RETURN;
315: END IF;
316:
317: IF (p_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT, -- Container
318: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET, -- Pallet
319: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT, -- Weight
320: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL)) THEN -- Volume
321:
322: l_basis_type := 'UNIT';

Line 319: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT, -- Weight

315: END IF;
316:
317: IF (p_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT, -- Container
318: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET, -- Pallet
319: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT, -- Weight
320: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL)) THEN -- Volume
321:
322: l_basis_type := 'UNIT';
323:

Line 320: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL)) THEN -- Volume

316:
317: IF (p_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT, -- Container
318: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET, -- Pallet
319: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT, -- Weight
320: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL)) THEN -- Volume
321:
322: l_basis_type := 'UNIT';
323:
324: IF (p_rate_basis <> g_carrier_unit_basis) THEN

Line 341: ELSIF (p_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME AND

337: ELSIF (p_rate_basis_uom <> g_carrier_unit_basis_uom) THEN
338: x_status := 3;
339: END IF;
340:
341: ELSIF (p_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME AND
342: p_rate_basis_uom <> g_carrier_time_uom) THEN
343:
344: x_status := 3;
345:

Line 346: ELSIF (p_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST AND

342: p_rate_basis_uom <> g_carrier_time_uom) THEN
343:
344: x_status := 3;
345:
346: ELSIF (p_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST AND
347: p_rate_basis_uom <> g_carrier_distance_uom) THEN
348:
349: x_status := 3;
350:

Line 1449: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_DISTANCE_CH;

1445: l_uom := l_charge_info(l_count + 5);
1446: l_mincharge := Fnd_Number.Canonical_To_Number(l_charge_info(l_count+7));
1447:
1448: IF (l_basis = 'DISTANCE') THEN
1449: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_DISTANCE_CH;
1450: ELSIF (l_basis = 'TIME') THEN
1451: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_TIME_CH;
1452: ELSE
1453: -- WEIGHT/VOLUME/PALLET/CONTAINER

Line 1451: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_TIME_CH;

1447:
1448: IF (l_basis = 'DISTANCE') THEN
1449: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_DISTANCE_CH;
1450: ELSIF (l_basis = 'TIME') THEN
1451: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_TIME_CH;
1452: ELSE
1453: -- WEIGHT/VOLUME/PALLET/CONTAINER
1454: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_UNIT_CH;
1455: END IF;

Line 1454: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_UNIT_CH;

1450: ELSIF (l_basis = 'TIME') THEN
1451: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_TIME_CH;
1452: ELSE
1453: -- WEIGHT/VOLUME/PALLET/CONTAINER
1454: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_UNIT_CH;
1455: END IF;
1456:
1457: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1458: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_description);

Line 1506: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_BASIS,

1502:
1503: ADD_ATTRIBUTE(p_attribute_type => 'TL_RATE_BASIS',
1504: p_attribute_value => l_basis,
1505: p_attribute_value_to => NULL,
1506: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_BASIS,
1507: p_comp_operator => NULL,
1508: p_linenum => l_linenum,
1509: p_process_id => l_process_id,
1510: p_line_number => p_line_number,

Line 1517: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,

1513:
1514: ADD_ATTRIBUTE(p_attribute_type => 'TL_RATE_TYPE',
1515: p_attribute_value => 'BASE_RATE',
1516: p_attribute_value_to => NULL,
1517: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,
1518: p_comp_operator => NULL,
1519: p_linenum => l_linenum,
1520: p_process_id => l_process_id,
1521: p_line_number => p_line_number,

Line 1532: p_context => FTE_RTG_GLOBALS.G_AX_VEHICLE,

1528: --Vehicle type is already in ID form
1529: ADD_ATTRIBUTE (p_attribute_type => 'TL_VEHICLE_TYPE',
1530: p_attribute_value => l_vehicle_type,
1531: p_attribute_value_to => NULL,
1532: p_context => FTE_RTG_GLOBALS.G_AX_VEHICLE,
1533: p_comp_operator => NULL,
1534: p_linenum => l_linenum,
1535: p_process_id => l_process_id,
1536: p_line_number => p_line_number,

Line 1764: l_subtype := FTE_RTG_GLOBALS.G_C_WEEKEND_LAYOVER_CH;

1760: END IF;
1761:
1762: l_type := 'ACCESSORIAL_SURCHARGE';
1763: l_break_type := 'POINT';
1764: l_subtype := FTE_RTG_GLOBALS.G_C_WEEKEND_LAYOVER_CH;
1765:
1766: l_rate_line_data('ACTION') := 'ADD'; --G_ACTION;
1767: l_rate_line_data('LINE_NUMBER') := x_linenum;
1768: l_rate_line_data('DESCRIPTION') := l_description;

Line 1794: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;

1790: --+
1791: -- add Rate Type Attribute
1792: --+
1793: l_attribute_type := 'TL_RATE_TYPE';
1794: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
1795: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
1796:
1797: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
1798: p_attribute_value => l_attribute_value,

Line 1795: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

1791: -- add Rate Type Attribute
1792: --+
1793: l_attribute_type := 'TL_RATE_TYPE';
1794: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
1795: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
1796:
1797: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
1798: p_attribute_value => l_attribute_value,
1799: p_attribute_value_to => NULL,

Line 2457: l_subtype := FTE_RTG_GLOBALS.G_C_FUEL_CH;

2453: FTE_UTIL_PKG.Write_LogFile(l_module_name, l_description);
2454: END IF;
2455:
2456: l_type := 'ACCESSORIAL_SURCHARGE';
2457: l_subtype := FTE_RTG_GLOBALS.G_C_FUEL_CH;
2458:
2459: l_rate_line_data('ACTION') := G_ACTION;
2460: l_rate_line_data('LINE_NUMBER') := x_linenum;
2461: l_rate_line_data('DESCRIPTION') := l_description;

Line 2486: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;

2482: FTE_UTIL_PKG.Exit_Debug(l_module_name);
2483: RETURN;
2484: END IF;
2485:
2486: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2487: l_attribute_type := 'TL_RATE_TYPE';
2488: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
2489:
2490: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,

Line 2488: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;

2484: END IF;
2485:
2486: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2487: l_attribute_type := 'TL_RATE_TYPE';
2488: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
2489:
2490: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
2491: p_attribute_value => l_attribute_value,
2492: p_attribute_value_to => NULL,

Line 2586: l_subtype := FTE_RTG_GLOBALS.G_C_ORIGIN_SURCHRG;

2582:
2583: l_type := 'ACCESSORIAL_SURCHARGE';
2584:
2585: IF (p_region_type = 'ORIGIN') THEN
2586: l_subtype := FTE_RTG_GLOBALS.G_C_ORIGIN_SURCHRG;
2587: ELSIF (p_region_type = 'DESTINATION') THEN
2588: l_subtype := FTE_RTG_GLOBALS.G_C_DESTINATION_SURCHRG;
2589: END IF;
2590:

Line 2588: l_subtype := FTE_RTG_GLOBALS.G_C_DESTINATION_SURCHRG;

2584:
2585: IF (p_region_type = 'ORIGIN') THEN
2586: l_subtype := FTE_RTG_GLOBALS.G_C_ORIGIN_SURCHRG;
2587: ELSIF (p_region_type = 'DESTINATION') THEN
2588: l_subtype := FTE_RTG_GLOBALS.G_C_DESTINATION_SURCHRG;
2589: END IF;
2590:
2591: l_rate_line_data('ACTION') := G_ACTION;
2592: l_rate_line_data('LINE_NUMBER'):= x_linenum;

Line 2617: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;

2613: FTE_UTIL_PKG.Exit_Debug(l_module_name);
2614: RETURN;
2615: END IF;
2616:
2617: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2618: l_attribute_type := 'TL_RATE_TYPE';
2619: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
2620:
2621: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,

Line 2619: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

2615: END IF;
2616:
2617: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2618: l_attribute_type := 'TL_RATE_TYPE';
2619: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
2620:
2621: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
2622: p_attribute_value => l_attribute_value,
2623: p_attribute_value_to => NULL,

Line 2642: l_context := FTE_RTG_GLOBALS.G_AX_ORIGIN_ZONE;

2638: -- Add Region Attribute
2639: l_attribute_type := p_region_type || '_ZONE_ID';
2640:
2641: IF (p_region_type = 'ORIGIN') THEN
2642: l_context := FTE_RTG_GLOBALS.G_AX_ORIGIN_ZONE;
2643: ELSIF (p_region_type = 'DESTINATION') THEN
2644: l_context := FTE_RTG_GLOBALS.G_AX_DESTINATION_ZONE;
2645: END IF;
2646:

Line 2644: l_context := FTE_RTG_GLOBALS.G_AX_DESTINATION_ZONE;

2640:
2641: IF (p_region_type = 'ORIGIN') THEN
2642: l_context := FTE_RTG_GLOBALS.G_AX_ORIGIN_ZONE;
2643: ELSIF (p_region_type = 'DESTINATION') THEN
2644: l_context := FTE_RTG_GLOBALS.G_AX_DESTINATION_ZONE;
2645: END IF;
2646:
2647: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
2648: p_attribute_value => Fnd_Number.Number_To_Canonical(l_zone_id),

Line 2758: l_subtype := FTE_RTG_GLOBALS.G_C_STOP_OFF_CH;

2754:
2755: l_type := 'ACCESSORIAL_SURCHARGE';
2756: l_rate_type := 'LUMPSUM';
2757: l_break_type := 'RANGE';
2758: l_subtype := FTE_RTG_GLOBALS.G_C_STOP_OFF_CH;
2759:
2760: l_rate_line_data('ACTION') := G_ACTION;
2761: l_rate_line_data('LINE_NUMBER') := x_linenum;
2762: l_rate_line_data('DESCRIPTION') := l_description;

Line 2791: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;

2787: --+
2788: -- Add Rate Type Attribute
2789: --+
2790: l_attribute_type := 'TL_RATE_TYPE';
2791: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2792: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
2793:
2794: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
2795: p_attribute_value => l_attribute_value,

Line 2792: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;

2788: -- Add Rate Type Attribute
2789: --+
2790: l_attribute_type := 'TL_RATE_TYPE';
2791: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2792: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
2793:
2794: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
2795: p_attribute_value => l_attribute_value,
2796: p_attribute_value_to => NULL,

Line 2916: l_attr1_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;

2912: x_status := -1;
2913:
2914: l_type := 'ACCESSORIAL_SURCHARGE';
2915: l_attr1_type := 'TL_RATE_TYPE';
2916: l_attr1_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2917:
2918: l_attr3_type := 'LOADING_PROTOCOL';
2919: l_attr3_context := FTE_RTG_GLOBALS.G_AX_LOADING_PROTOCOL;
2920:

Line 2919: l_attr3_context := FTE_RTG_GLOBALS.G_AX_LOADING_PROTOCOL;

2915: l_attr1_type := 'TL_RATE_TYPE';
2916: l_attr1_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
2917:
2918: l_attr3_type := 'LOADING_PROTOCOL';
2919: l_attr3_context := FTE_RTG_GLOBALS.G_AX_LOADING_PROTOCOL;
2920:
2921: -- TL handling only deals with weight and volume
2922: IF (p_load_type = 'HANDLING') THEN
2923: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;

Line 2923: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;

2919: l_attr3_context := FTE_RTG_GLOBALS.G_AX_LOADING_PROTOCOL;
2920:
2921: -- TL handling only deals with weight and volume
2922: IF (p_load_type = 'HANDLING') THEN
2923: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
2924: l_attr3_value := 'CARRIER';
2925: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_HANDLING_CH;
2926:
2927: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

Line 2925: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_HANDLING_CH;

2921: -- TL handling only deals with weight and volume
2922: IF (p_load_type = 'HANDLING') THEN
2923: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
2924: l_attr3_value := 'CARRIER';
2925: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_HANDLING_CH;
2926:
2927: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2928: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_WEIGHT_CH;
2929: l_attr2_type := 'TL_HANDLING_WT';

Line 2927: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

2923: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
2924: l_attr3_value := 'CARRIER';
2925: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_HANDLING_CH;
2926:
2927: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2928: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_WEIGHT_CH;
2929: l_attr2_type := 'TL_HANDLING_WT';
2930: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_WT;
2931: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 2928: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_WEIGHT_CH;

2924: l_attr3_value := 'CARRIER';
2925: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_HANDLING_CH;
2926:
2927: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2928: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_WEIGHT_CH;
2929: l_attr2_type := 'TL_HANDLING_WT';
2930: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_WT;
2931: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2932: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_VOLUME_CH;

Line 2930: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_WT;

2926:
2927: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2928: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_WEIGHT_CH;
2929: l_attr2_type := 'TL_HANDLING_WT';
2930: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_WT;
2931: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2932: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_VOLUME_CH;
2933: l_attr2_type := 'TL_HANDLING_VOL';
2934: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_VOL;

Line 2931: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

2927: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2928: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_WEIGHT_CH;
2929: l_attr2_type := 'TL_HANDLING_WT';
2930: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_WT;
2931: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2932: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_VOLUME_CH;
2933: l_attr2_type := 'TL_HANDLING_VOL';
2934: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_VOL;
2935: ELSIF (p_basis = 'FLAT') THEN

Line 2932: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_VOLUME_CH;

2928: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_WEIGHT_CH;
2929: l_attr2_type := 'TL_HANDLING_WT';
2930: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_WT;
2931: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2932: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_VOLUME_CH;
2933: l_attr2_type := 'TL_HANDLING_VOL';
2934: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_VOL;
2935: ELSIF (p_basis = 'FLAT') THEN
2936: l_flat_rate := TRUE;

Line 2934: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_VOL;

2930: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_WT;
2931: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2932: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_VOLUME_CH;
2933: l_attr2_type := 'TL_HANDLING_VOL';
2934: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_VOL;
2935: ELSIF (p_basis = 'FLAT') THEN
2936: l_flat_rate := TRUE;
2937: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_FLAT_CH;
2938: ELSE

Line 2937: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_FLAT_CH;

2933: l_attr2_type := 'TL_HANDLING_VOL';
2934: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_HANDLING_VOL;
2935: ELSIF (p_basis = 'FLAT') THEN
2936: l_flat_rate := TRUE;
2937: l_subtype := FTE_RTG_GLOBALS.G_C_HANDLING_FLAT_CH;
2938: ELSE
2939: x_status := 3;
2940: END IF;
2941: ELSIF (p_load_type = 'FACILITY_HANDLING') THEN

Line 2944: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_HANDLING_CH;

2940: END IF;
2941: ELSIF (p_load_type = 'FACILITY_HANDLING') THEN
2942: l_attr1_value := 'FACILITY_CHARGE';
2943: l_attr3_value := 'FACILITY';
2944: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_HANDLING_CH;
2945:
2946: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2947: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_WEIGHT_CH;
2948: l_attr2_type := 'FAC_HANDLING_WT';

Line 2946: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

2942: l_attr1_value := 'FACILITY_CHARGE';
2943: l_attr3_value := 'FACILITY';
2944: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_HANDLING_CH;
2945:
2946: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2947: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_WEIGHT_CH;
2948: l_attr2_type := 'FAC_HANDLING_WT';
2949: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_WT;
2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 2947: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_WEIGHT_CH;

2943: l_attr3_value := 'FACILITY';
2944: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_HANDLING_CH;
2945:
2946: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2947: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_WEIGHT_CH;
2948: l_attr2_type := 'FAC_HANDLING_WT';
2949: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_WT;
2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;

Line 2949: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_WT;

2945:
2946: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2947: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_WEIGHT_CH;
2948: l_attr2_type := 'FAC_HANDLING_WT';
2949: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_WT;
2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;
2952: l_attr2_type := 'FAC_HANDLING_VOL';
2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;

Line 2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

2946: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2947: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_WEIGHT_CH;
2948: l_attr2_type := 'FAC_HANDLING_WT';
2949: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_WT;
2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;
2952: l_attr2_type := 'FAC_HANDLING_VOL';
2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;
2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;

2947: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_WEIGHT_CH;
2948: l_attr2_type := 'FAC_HANDLING_WT';
2949: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_WT;
2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;
2952: l_attr2_type := 'FAC_HANDLING_VOL';
2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;
2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;

Line 2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;

2949: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_WT;
2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;
2952: l_attr2_type := 'FAC_HANDLING_VOL';
2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;
2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;
2956: l_attr2_type := 'FAC_HANDLING_PALLET';
2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;

Line 2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

2950: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;
2952: l_attr2_type := 'FAC_HANDLING_VOL';
2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;
2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;
2956: l_attr2_type := 'FAC_HANDLING_PALLET';
2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;
2958: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;

2951: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_VOLUME_CH;
2952: l_attr2_type := 'FAC_HANDLING_VOL';
2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;
2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;
2956: l_attr2_type := 'FAC_HANDLING_PALLET';
2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;
2958: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2959: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_CONTAINER_CH;

Line 2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;

2953: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_VOL;
2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;
2956: l_attr2_type := 'FAC_HANDLING_PALLET';
2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;
2958: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2959: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_CONTAINER_CH;
2960: l_attr2_type := 'FAC_HANDLING_CONTAINER';
2961: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_CONTAINER;

Line 2958: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

2954: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;
2956: l_attr2_type := 'FAC_HANDLING_PALLET';
2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;
2958: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2959: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_CONTAINER_CH;
2960: l_attr2_type := 'FAC_HANDLING_CONTAINER';
2961: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_CONTAINER;
2962: ELSIF (p_basis = 'FLAT') THEN

Line 2959: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_CONTAINER_CH;

2955: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_PALLET_CH;
2956: l_attr2_type := 'FAC_HANDLING_PALLET';
2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;
2958: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2959: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_CONTAINER_CH;
2960: l_attr2_type := 'FAC_HANDLING_CONTAINER';
2961: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_CONTAINER;
2962: ELSIF (p_basis = 'FLAT') THEN
2963: l_flat_rate := TRUE;

Line 2961: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_CONTAINER;

2957: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_PALLET;
2958: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2959: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_CONTAINER_CH;
2960: l_attr2_type := 'FAC_HANDLING_CONTAINER';
2961: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_CONTAINER;
2962: ELSIF (p_basis = 'FLAT') THEN
2963: l_flat_rate := TRUE;
2964: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_FLAT_CH;
2965: ELSE

Line 2964: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_FLAT_CH;

2960: l_attr2_type := 'FAC_HANDLING_CONTAINER';
2961: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_HANDLING_CONTAINER;
2962: ELSIF (p_basis = 'FLAT') THEN
2963: l_flat_rate := TRUE;
2964: l_subtype := FTE_RTG_GLOBALS.G_F_HANDLING_FLAT_CH;
2965: ELSE
2966: x_status := 3;
2967: END IF;
2968:

Line 2970: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

2966: x_status := 3;
2967: END IF;
2968:
2969: ELSIF (p_load_type = 'UNLOADING') THEN
2970: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
2971: l_attr3_value := 'CARRIER';
2972: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_UNLOADING_CH;
2973:
2974: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

Line 2972: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_UNLOADING_CH;

2968:
2969: ELSIF (p_load_type = 'UNLOADING') THEN
2970: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
2971: l_attr3_value := 'CARRIER';
2972: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_UNLOADING_CH;
2973:
2974: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2975: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_WEIGHT_CH;
2976: l_attr2_type := 'TL_DROPOFF_WT';

Line 2974: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

2970: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
2971: l_attr3_value := 'CARRIER';
2972: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_UNLOADING_CH;
2973:
2974: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2975: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_WEIGHT_CH;
2976: l_attr2_type := 'TL_DROPOFF_WT';
2977: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 2975: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_WEIGHT_CH;

2971: l_attr3_value := 'CARRIER';
2972: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_UNLOADING_CH;
2973:
2974: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2975: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_WEIGHT_CH;
2976: l_attr2_type := 'TL_DROPOFF_WT';
2977: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;

Line 2977: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;

2973:
2974: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2975: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_WEIGHT_CH;
2976: l_attr2_type := 'TL_DROPOFF_WT';
2977: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;
2980: l_attr2_type := 'TL_DROPOFF_VOL';
2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;

Line 2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

2974: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
2975: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_WEIGHT_CH;
2976: l_attr2_type := 'TL_DROPOFF_WT';
2977: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;
2980: l_attr2_type := 'TL_DROPOFF_VOL';
2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;

2975: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_WEIGHT_CH;
2976: l_attr2_type := 'TL_DROPOFF_WT';
2977: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;
2980: l_attr2_type := 'TL_DROPOFF_VOL';
2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;

Line 2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;

2977: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;
2980: l_attr2_type := 'TL_DROPOFF_VOL';
2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;
2984: l_attr2_type := 'TL_DROPOFF_PALLET';
2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;

Line 2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

2978: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;
2980: l_attr2_type := 'TL_DROPOFF_VOL';
2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;
2984: l_attr2_type := 'TL_DROPOFF_PALLET';
2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
2986: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;

2979: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_VOLUME_CH;
2980: l_attr2_type := 'TL_DROPOFF_VOL';
2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;
2984: l_attr2_type := 'TL_DROPOFF_PALLET';
2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
2986: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2987: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_CONTAINER_CH;

Line 2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;

2981: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;
2984: l_attr2_type := 'TL_DROPOFF_PALLET';
2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
2986: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2987: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_CONTAINER_CH;
2988: l_attr2_type := 'TL_DROPOFF_CONTAINER';
2989: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;

Line 2986: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

2982: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;
2984: l_attr2_type := 'TL_DROPOFF_PALLET';
2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
2986: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2987: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_CONTAINER_CH;
2988: l_attr2_type := 'TL_DROPOFF_CONTAINER';
2989: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
2990: ELSIF(p_basis = 'FLAT') THEN

Line 2987: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_CONTAINER_CH;

2983: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_PALLET_CH;
2984: l_attr2_type := 'TL_DROPOFF_PALLET';
2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
2986: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2987: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_CONTAINER_CH;
2988: l_attr2_type := 'TL_DROPOFF_CONTAINER';
2989: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
2990: ELSIF(p_basis = 'FLAT') THEN
2991: l_flat_rate := TRUE;

Line 2989: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;

2985: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
2986: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
2987: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_CONTAINER_CH;
2988: l_attr2_type := 'TL_DROPOFF_CONTAINER';
2989: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
2990: ELSIF(p_basis = 'FLAT') THEN
2991: l_flat_rate := TRUE;
2992: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_FLAT_CH;
2993: ELSE

Line 2992: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_FLAT_CH;

2988: l_attr2_type := 'TL_DROPOFF_CONTAINER';
2989: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
2990: ELSIF(p_basis = 'FLAT') THEN
2991: l_flat_rate := TRUE;
2992: l_subtype := FTE_RTG_GLOBALS.G_C_UNLOADING_FLAT_CH;
2993: ELSE
2994: x_status := 3;
2995: END IF;
2996:

Line 3000: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_UNLOADING_CH;

2996:
2997: ELSIF (p_load_type = 'FACILITY_UNLOADING') THEN
2998: l_attr1_value := 'FACILITY_CHARGE';
2999: l_attr3_value := 'FACILITY';
3000: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_UNLOADING_CH;
3001:
3002: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3003: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_WEIGHT_CH;
3004: l_attr2_type := 'FAC_DROPOFF_WT';

Line 3002: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

2998: l_attr1_value := 'FACILITY_CHARGE';
2999: l_attr3_value := 'FACILITY';
3000: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_UNLOADING_CH;
3001:
3002: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3003: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_WEIGHT_CH;
3004: l_attr2_type := 'FAC_DROPOFF_WT';
3005: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3003: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_WEIGHT_CH;

2999: l_attr3_value := 'FACILITY';
3000: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_UNLOADING_CH;
3001:
3002: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3003: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_WEIGHT_CH;
3004: l_attr2_type := 'FAC_DROPOFF_WT';
3005: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;

Line 3005: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;

3001:
3002: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3003: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_WEIGHT_CH;
3004: l_attr2_type := 'FAC_DROPOFF_WT';
3005: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;
3008: l_attr2_type := 'FAC_DROPOFF_VOL';
3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;

Line 3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3002: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3003: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_WEIGHT_CH;
3004: l_attr2_type := 'FAC_DROPOFF_WT';
3005: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;
3008: l_attr2_type := 'FAC_DROPOFF_VOL';
3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;

3003: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_WEIGHT_CH;
3004: l_attr2_type := 'FAC_DROPOFF_WT';
3005: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;
3008: l_attr2_type := 'FAC_DROPOFF_VOL';
3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;

Line 3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;

3005: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;
3008: l_attr2_type := 'FAC_DROPOFF_VOL';
3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;
3012: l_attr2_type := 'FAC_DROPOFF_PALLET';
3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;

Line 3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3006: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;
3008: l_attr2_type := 'FAC_DROPOFF_VOL';
3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;
3012: l_attr2_type := 'FAC_DROPOFF_PALLET';
3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3014: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;

3007: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_VOLUME_CH;
3008: l_attr2_type := 'FAC_DROPOFF_VOL';
3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;
3012: l_attr2_type := 'FAC_DROPOFF_PALLET';
3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3014: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3015: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_CONTAINER_CH;

Line 3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;

3009: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;
3012: l_attr2_type := 'FAC_DROPOFF_PALLET';
3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3014: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3015: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_CONTAINER_CH;
3016: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3017: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;

Line 3014: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3010: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;
3012: l_attr2_type := 'FAC_DROPOFF_PALLET';
3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3014: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3015: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_CONTAINER_CH;
3016: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3017: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3018: ELSIF(p_basis = 'FLAT') THEN

Line 3015: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_CONTAINER_CH;

3011: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_PALLET_CH;
3012: l_attr2_type := 'FAC_DROPOFF_PALLET';
3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3014: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3015: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_CONTAINER_CH;
3016: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3017: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3018: ELSIF(p_basis = 'FLAT') THEN
3019: l_flat_rate := TRUE;

Line 3017: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;

3013: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3014: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3015: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_CONTAINER_CH;
3016: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3017: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3018: ELSIF(p_basis = 'FLAT') THEN
3019: l_flat_rate := TRUE;
3020: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_FLAT_CH;
3021: ELSE

Line 3020: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_FLAT_CH;

3016: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3017: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3018: ELSIF(p_basis = 'FLAT') THEN
3019: l_flat_rate := TRUE;
3020: l_subtype := FTE_RTG_GLOBALS.G_F_UNLOADING_FLAT_CH;
3021: ELSE
3022: x_status := 3;
3023: END IF;
3024:

Line 3026: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

3022: x_status := 3;
3023: END IF;
3024:
3025: ELSIF (p_load_type = 'ASSISTED_UNLOADING') THEN
3026: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3027: l_attr3_value := 'JOINT';
3028: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_UNLOADING_CH;
3029:
3030: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

Line 3028: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_UNLOADING_CH;

3024:
3025: ELSIF (p_load_type = 'ASSISTED_UNLOADING') THEN
3026: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3027: l_attr3_value := 'JOINT';
3028: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_UNLOADING_CH;
3029:
3030: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3031: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_WEIGHT_CH;
3032: l_attr2_type := 'TL_DROPOFF_WT';

Line 3030: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3026: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3027: l_attr3_value := 'JOINT';
3028: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_UNLOADING_CH;
3029:
3030: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3031: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_WEIGHT_CH;
3032: l_attr2_type := 'TL_DROPOFF_WT';
3033: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3031: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_WEIGHT_CH;

3027: l_attr3_value := 'JOINT';
3028: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_UNLOADING_CH;
3029:
3030: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3031: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_WEIGHT_CH;
3032: l_attr2_type := 'TL_DROPOFF_WT';
3033: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;

Line 3033: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;

3029:
3030: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3031: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_WEIGHT_CH;
3032: l_attr2_type := 'TL_DROPOFF_WT';
3033: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;
3036: l_attr2_type := 'TL_DROPOFF_VOL';
3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;

Line 3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3030: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3031: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_WEIGHT_CH;
3032: l_attr2_type := 'TL_DROPOFF_WT';
3033: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;
3036: l_attr2_type := 'TL_DROPOFF_VOL';
3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;

3031: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_WEIGHT_CH;
3032: l_attr2_type := 'TL_DROPOFF_WT';
3033: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;
3036: l_attr2_type := 'TL_DROPOFF_VOL';
3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;

Line 3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;

3033: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_WT;
3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;
3036: l_attr2_type := 'TL_DROPOFF_VOL';
3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;
3040: l_attr2_type := 'TL_DROPOFF_PALLET';
3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;

Line 3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3034: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;
3036: l_attr2_type := 'TL_DROPOFF_VOL';
3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;
3040: l_attr2_type := 'TL_DROPOFF_PALLET';
3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
3042: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;

3035: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_VOLUME_CH;
3036: l_attr2_type := 'TL_DROPOFF_VOL';
3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;
3040: l_attr2_type := 'TL_DROPOFF_PALLET';
3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
3042: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3043: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_CONTAINER_CH;

Line 3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;

3037: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_VOL;
3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;
3040: l_attr2_type := 'TL_DROPOFF_PALLET';
3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
3042: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3043: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_CONTAINER_CH;
3044: l_attr2_type := 'TL_DROPOFF_CONTAINER';
3045: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;

Line 3042: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3038: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;
3040: l_attr2_type := 'TL_DROPOFF_PALLET';
3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
3042: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3043: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_CONTAINER_CH;
3044: l_attr2_type := 'TL_DROPOFF_CONTAINER';
3045: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
3046: ELSIF(p_basis = 'FLAT') THEN

Line 3043: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_CONTAINER_CH;

3039: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_PALLET_CH;
3040: l_attr2_type := 'TL_DROPOFF_PALLET';
3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
3042: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3043: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_CONTAINER_CH;
3044: l_attr2_type := 'TL_DROPOFF_CONTAINER';
3045: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
3046: ELSIF(p_basis = 'FLAT') THEN
3047: l_flat_rate := TRUE;

Line 3045: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;

3041: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_PALLET;
3042: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3043: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_CONTAINER_CH;
3044: l_attr2_type := 'TL_DROPOFF_CONTAINER';
3045: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
3046: ELSIF(p_basis = 'FLAT') THEN
3047: l_flat_rate := TRUE;
3048: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_FLAT_CH;
3049: ELSE

Line 3048: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_FLAT_CH;

3044: l_attr2_type := 'TL_DROPOFF_CONTAINER';
3045: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_DROPOFF_CONTAINER;
3046: ELSIF(p_basis = 'FLAT') THEN
3047: l_flat_rate := TRUE;
3048: l_subtype := FTE_RTG_GLOBALS.G_C_AST_UNLOADING_FLAT_CH;
3049: ELSE
3050: x_status := 3;
3051: END IF;
3052:

Line 3056: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_UNLOADING_CH;

3052:
3053: ELSIF (p_load_type = 'FACILITY_ASSISTED_UNLOADING') THEN
3054: l_attr1_value := 'FACILITY_CHARGE';
3055: l_attr3_value := 'JOINT';
3056: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_UNLOADING_CH;
3057:
3058: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3059: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_WEIGHT_CH;
3060: l_attr2_type := 'FAC_DROPOFF_WT';

Line 3058: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3054: l_attr1_value := 'FACILITY_CHARGE';
3055: l_attr3_value := 'JOINT';
3056: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_UNLOADING_CH;
3057:
3058: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3059: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_WEIGHT_CH;
3060: l_attr2_type := 'FAC_DROPOFF_WT';
3061: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3059: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_WEIGHT_CH;

3055: l_attr3_value := 'JOINT';
3056: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_UNLOADING_CH;
3057:
3058: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3059: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_WEIGHT_CH;
3060: l_attr2_type := 'FAC_DROPOFF_WT';
3061: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;

Line 3061: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;

3057:
3058: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3059: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_WEIGHT_CH;
3060: l_attr2_type := 'FAC_DROPOFF_WT';
3061: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;
3064: l_attr2_type := 'FAC_DROPOFF_VOL';
3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;

Line 3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3058: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3059: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_WEIGHT_CH;
3060: l_attr2_type := 'FAC_DROPOFF_WT';
3061: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;
3064: l_attr2_type := 'FAC_DROPOFF_VOL';
3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;

3059: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_WEIGHT_CH;
3060: l_attr2_type := 'FAC_DROPOFF_WT';
3061: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;
3064: l_attr2_type := 'FAC_DROPOFF_VOL';
3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;

Line 3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;

3061: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_WT;
3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;
3064: l_attr2_type := 'FAC_DROPOFF_VOL';
3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;
3068: l_attr2_type := 'FAC_DROPOFF_PALLET';
3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;

Line 3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3062: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;
3064: l_attr2_type := 'FAC_DROPOFF_VOL';
3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;
3068: l_attr2_type := 'FAC_DROPOFF_PALLET';
3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3070: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;

3063: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_VOLUME_CH;
3064: l_attr2_type := 'FAC_DROPOFF_VOL';
3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;
3068: l_attr2_type := 'FAC_DROPOFF_PALLET';
3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3070: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3071: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_CONTAINER_CH;

Line 3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;

3065: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_VOL;
3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;
3068: l_attr2_type := 'FAC_DROPOFF_PALLET';
3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3070: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3071: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_CONTAINER_CH;
3072: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3073: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;

Line 3070: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3066: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;
3068: l_attr2_type := 'FAC_DROPOFF_PALLET';
3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3070: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3071: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_CONTAINER_CH;
3072: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3073: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3074: ELSIF(p_basis = 'FLAT') THEN

Line 3071: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_CONTAINER_CH;

3067: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_PALLET_CH;
3068: l_attr2_type := 'FAC_DROPOFF_PALLET';
3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3070: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3071: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_CONTAINER_CH;
3072: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3073: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3074: ELSIF(p_basis = 'FLAT') THEN
3075: l_flat_rate := TRUE;

Line 3073: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;

3069: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_PALLET;
3070: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3071: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_CONTAINER_CH;
3072: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3073: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3074: ELSIF(p_basis = 'FLAT') THEN
3075: l_flat_rate := TRUE;
3076: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_FLAT_CH;
3077: ELSE

Line 3076: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_FLAT_CH;

3072: l_attr2_type := 'FAC_DROPOFF_CONTAINER';
3073: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_DROPOFF_CONTAINER;
3074: ELSIF(p_basis = 'FLAT') THEN
3075: l_flat_rate := TRUE;
3076: l_subtype := FTE_RTG_GLOBALS.G_F_AST_UNLOADING_FLAT_CH;
3077: ELSE
3078: x_status := 3;
3079: END IF;
3080:

Line 3082: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

3078: x_status := 3;
3079: END IF;
3080:
3081: ELSIF (p_load_type = 'LOADING') THEN
3082: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3083: l_attr3_value := 'CARRIER';
3084: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_LOADING_CH;
3085:
3086: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

Line 3084: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_LOADING_CH;

3080:
3081: ELSIF (p_load_type = 'LOADING') THEN
3082: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3083: l_attr3_value := 'CARRIER';
3084: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_LOADING_CH;
3085:
3086: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3087: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_WEIGHT_CH;
3088: l_attr2_type := 'TL_PICKUP_WT';

Line 3086: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3082: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3083: l_attr3_value := 'CARRIER';
3084: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_LOADING_CH;
3085:
3086: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3087: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_WEIGHT_CH;
3088: l_attr2_type := 'TL_PICKUP_WT';
3089: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3087: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_WEIGHT_CH;

3083: l_attr3_value := 'CARRIER';
3084: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_LOADING_CH;
3085:
3086: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3087: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_WEIGHT_CH;
3088: l_attr2_type := 'TL_PICKUP_WT';
3089: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;

Line 3089: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;

3085:
3086: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3087: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_WEIGHT_CH;
3088: l_attr2_type := 'TL_PICKUP_WT';
3089: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;
3092: l_attr2_type := 'TL_PICKUP_VOL';
3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;

Line 3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3086: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3087: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_WEIGHT_CH;
3088: l_attr2_type := 'TL_PICKUP_WT';
3089: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;
3092: l_attr2_type := 'TL_PICKUP_VOL';
3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;

3087: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_WEIGHT_CH;
3088: l_attr2_type := 'TL_PICKUP_WT';
3089: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;
3092: l_attr2_type := 'TL_PICKUP_VOL';
3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;

Line 3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;

3089: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;
3092: l_attr2_type := 'TL_PICKUP_VOL';
3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;
3096: l_attr2_type := 'TL_PICKUP_PALLET';
3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;

Line 3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3090: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;
3092: l_attr2_type := 'TL_PICKUP_VOL';
3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;
3096: l_attr2_type := 'TL_PICKUP_PALLET';
3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3098: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;

3091: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_VOLUME_CH;
3092: l_attr2_type := 'TL_PICKUP_VOL';
3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;
3096: l_attr2_type := 'TL_PICKUP_PALLET';
3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3098: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3099: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_CONTAINER_CH;

Line 3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;

3093: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;
3096: l_attr2_type := 'TL_PICKUP_PALLET';
3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3098: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3099: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_CONTAINER_CH;
3100: l_attr2_type := 'TL_PICKUP_CONTAINER';
3101: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;

Line 3098: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3094: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;
3096: l_attr2_type := 'TL_PICKUP_PALLET';
3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3098: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3099: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_CONTAINER_CH;
3100: l_attr2_type := 'TL_PICKUP_CONTAINER';
3101: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3102: ELSIF(p_basis = 'FLAT') THEN

Line 3099: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_CONTAINER_CH;

3095: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_PALLET_CH;
3096: l_attr2_type := 'TL_PICKUP_PALLET';
3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3098: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3099: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_CONTAINER_CH;
3100: l_attr2_type := 'TL_PICKUP_CONTAINER';
3101: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3102: ELSIF(p_basis = 'FLAT') THEN
3103: l_flat_rate := TRUE;

Line 3101: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;

3097: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3098: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3099: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_CONTAINER_CH;
3100: l_attr2_type := 'TL_PICKUP_CONTAINER';
3101: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3102: ELSIF(p_basis = 'FLAT') THEN
3103: l_flat_rate := TRUE;
3104: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_FLAT_CH;
3105: ELSE

Line 3104: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_FLAT_CH;

3100: l_attr2_type := 'TL_PICKUP_CONTAINER';
3101: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3102: ELSIF(p_basis = 'FLAT') THEN
3103: l_flat_rate := TRUE;
3104: l_subtype := FTE_RTG_GLOBALS.G_C_LOADING_FLAT_CH;
3105: ELSE
3106: x_status := 3;
3107: END IF;
3108:

Line 3112: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_LOADING_CH;

3108:
3109: ELSIF (p_load_type = 'FACILITY_LOADING') THEN
3110: l_attr1_value := 'FACILITY_CHARGE';
3111: l_attr3_value := 'FACILITY';
3112: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_LOADING_CH;
3113:
3114: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3115: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_WEIGHT_CH;
3116: l_attr2_type := 'FAC_PICKUP_WT';

Line 3114: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3110: l_attr1_value := 'FACILITY_CHARGE';
3111: l_attr3_value := 'FACILITY';
3112: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_LOADING_CH;
3113:
3114: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3115: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_WEIGHT_CH;
3116: l_attr2_type := 'FAC_PICKUP_WT';
3117: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3115: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_WEIGHT_CH;

3111: l_attr3_value := 'FACILITY';
3112: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_LOADING_CH;
3113:
3114: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3115: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_WEIGHT_CH;
3116: l_attr2_type := 'FAC_PICKUP_WT';
3117: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;

Line 3117: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;

3113:
3114: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3115: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_WEIGHT_CH;
3116: l_attr2_type := 'FAC_PICKUP_WT';
3117: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;
3120: l_attr2_type := 'FAC_PICKUP_VOL';
3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;

Line 3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3114: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3115: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_WEIGHT_CH;
3116: l_attr2_type := 'FAC_PICKUP_WT';
3117: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;
3120: l_attr2_type := 'FAC_PICKUP_VOL';
3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;

3115: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_WEIGHT_CH;
3116: l_attr2_type := 'FAC_PICKUP_WT';
3117: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;
3120: l_attr2_type := 'FAC_PICKUP_VOL';
3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;

Line 3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;

3117: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;
3120: l_attr2_type := 'FAC_PICKUP_VOL';
3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;
3124: l_attr2_type := 'FAC_PICKUP_PALLET';
3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;

Line 3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3118: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;
3120: l_attr2_type := 'FAC_PICKUP_VOL';
3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;
3124: l_attr2_type := 'FAC_PICKUP_PALLET';
3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3126: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;

3119: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_VOLUME_CH;
3120: l_attr2_type := 'FAC_PICKUP_VOL';
3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;
3124: l_attr2_type := 'FAC_PICKUP_PALLET';
3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3126: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3127: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_CONTAINER_CH;

Line 3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;

3121: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;
3124: l_attr2_type := 'FAC_PICKUP_PALLET';
3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3126: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3127: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_CONTAINER_CH;
3128: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3129: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;

Line 3126: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3122: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;
3124: l_attr2_type := 'FAC_PICKUP_PALLET';
3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3126: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3127: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_CONTAINER_CH;
3128: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3129: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3130: ELSIF(p_basis = 'FLAT') THEN

Line 3127: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_CONTAINER_CH;

3123: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_PALLET_CH;
3124: l_attr2_type := 'FAC_PICKUP_PALLET';
3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3126: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3127: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_CONTAINER_CH;
3128: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3129: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3130: ELSIF(p_basis = 'FLAT') THEN
3131: l_flat_rate := TRUE;

Line 3129: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;

3125: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3126: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3127: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_CONTAINER_CH;
3128: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3129: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3130: ELSIF(p_basis = 'FLAT') THEN
3131: l_flat_rate := TRUE;
3132: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_FLAT_CH;
3133: ELSE

Line 3132: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_FLAT_CH;

3128: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3129: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3130: ELSIF(p_basis = 'FLAT') THEN
3131: l_flat_rate := TRUE;
3132: l_subtype := FTE_RTG_GLOBALS.G_F_LOADING_FLAT_CH;
3133: ELSE
3134: x_status := 3;
3135: END IF;
3136:

Line 3138: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

3134: x_status := 3;
3135: END IF;
3136:
3137: ELSIF (p_load_type = 'ASSISTED_LOADING') THEN
3138: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3139: l_attr3_value := 'JOINT';
3140: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3141:
3142: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

Line 3140: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;

3136:
3137: ELSIF (p_load_type = 'ASSISTED_LOADING') THEN
3138: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3139: l_attr3_value := 'JOINT';
3140: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3141:
3142: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3143: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3144: l_attr2_type := 'TL_PICKUP_WT';

Line 3142: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3138: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3139: l_attr3_value := 'JOINT';
3140: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3141:
3142: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3143: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3144: l_attr2_type := 'TL_PICKUP_WT';
3145: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3143: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;

3139: l_attr3_value := 'JOINT';
3140: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3141:
3142: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3143: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3144: l_attr2_type := 'TL_PICKUP_WT';
3145: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;

Line 3145: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;

3141:
3142: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3143: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3144: l_attr2_type := 'TL_PICKUP_WT';
3145: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3148: l_attr2_type := 'TL_PICKUP_VOL';
3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;

Line 3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3142: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3143: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3144: l_attr2_type := 'TL_PICKUP_WT';
3145: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3148: l_attr2_type := 'TL_PICKUP_VOL';
3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;

3143: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3144: l_attr2_type := 'TL_PICKUP_WT';
3145: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3148: l_attr2_type := 'TL_PICKUP_VOL';
3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;

Line 3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;

3145: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3148: l_attr2_type := 'TL_PICKUP_VOL';
3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3152: l_attr2_type := 'TL_PICKUP_PALLET';
3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;

Line 3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3146: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3148: l_attr2_type := 'TL_PICKUP_VOL';
3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3152: l_attr2_type := 'TL_PICKUP_PALLET';
3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3154: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;

3147: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3148: l_attr2_type := 'TL_PICKUP_VOL';
3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3152: l_attr2_type := 'TL_PICKUP_PALLET';
3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3154: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3155: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;

Line 3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;

3149: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3152: l_attr2_type := 'TL_PICKUP_PALLET';
3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3154: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3155: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3156: l_attr2_type := 'TL_PICKUP_CONTAINER';
3157: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;

Line 3154: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3150: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3152: l_attr2_type := 'TL_PICKUP_PALLET';
3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3154: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3155: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3156: l_attr2_type := 'TL_PICKUP_CONTAINER';
3157: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3158: ELSIF(p_basis = 'FLAT') THEN

Line 3155: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;

3151: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3152: l_attr2_type := 'TL_PICKUP_PALLET';
3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3154: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3155: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3156: l_attr2_type := 'TL_PICKUP_CONTAINER';
3157: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3158: ELSIF(p_basis = 'FLAT') THEN
3159: l_flat_rate := TRUE;

Line 3157: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;

3153: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3154: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3155: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3156: l_attr2_type := 'TL_PICKUP_CONTAINER';
3157: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3158: ELSIF(p_basis = 'FLAT') THEN
3159: l_flat_rate := TRUE;
3160: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_FLAT_CH;
3161: ELSE

Line 3160: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_FLAT_CH;

3156: l_attr2_type := 'TL_PICKUP_CONTAINER';
3157: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3158: ELSIF(p_basis = 'FLAT') THEN
3159: l_flat_rate := TRUE;
3160: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_FLAT_CH;
3161: ELSE
3162: x_status := 3;
3163: END IF;
3164:

Line 3168: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;

3164:
3165: ELSIF (p_load_type = 'FACILITY_ASSISTED_LOADING') THEN
3166: l_attr1_value := 'FACILITY_CHARGE';
3167: l_attr3_value := 'JOINT';
3168: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;
3169:
3170: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3171: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3172: l_attr2_type := 'FAC_PICKUP_WT';

Line 3170: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3166: l_attr1_value := 'FACILITY_CHARGE';
3167: l_attr3_value := 'JOINT';
3168: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;
3169:
3170: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3171: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3172: l_attr2_type := 'FAC_PICKUP_WT';
3173: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3171: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;

3167: l_attr3_value := 'JOINT';
3168: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;
3169:
3170: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3171: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3172: l_attr2_type := 'FAC_PICKUP_WT';
3173: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;

Line 3173: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;

3169:
3170: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3171: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3172: l_attr2_type := 'FAC_PICKUP_WT';
3173: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3176: l_attr2_type := 'FAC_PICKUP_VOL';
3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;

Line 3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3170: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3171: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3172: l_attr2_type := 'FAC_PICKUP_WT';
3173: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3176: l_attr2_type := 'FAC_PICKUP_VOL';
3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;

3171: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3172: l_attr2_type := 'FAC_PICKUP_WT';
3173: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3176: l_attr2_type := 'FAC_PICKUP_VOL';
3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;

Line 3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;

3173: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3176: l_attr2_type := 'FAC_PICKUP_VOL';
3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3180: l_attr2_type := 'FAC_PICKUP_PALLET';
3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;

Line 3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3174: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3176: l_attr2_type := 'FAC_PICKUP_VOL';
3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3180: l_attr2_type := 'FAC_PICKUP_PALLET';
3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3182: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;

3175: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3176: l_attr2_type := 'FAC_PICKUP_VOL';
3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3180: l_attr2_type := 'FAC_PICKUP_PALLET';
3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3182: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3183: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;

Line 3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;

3177: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3180: l_attr2_type := 'FAC_PICKUP_PALLET';
3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3182: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3183: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3184: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3185: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;

Line 3182: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3178: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3180: l_attr2_type := 'FAC_PICKUP_PALLET';
3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3182: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3183: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3184: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3185: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3186: ELSIF(p_basis = 'FLAT') THEN

Line 3183: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;

3179: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3180: l_attr2_type := 'FAC_PICKUP_PALLET';
3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3182: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3183: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3184: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3185: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3186: ELSIF(p_basis = 'FLAT') THEN
3187: l_flat_rate := TRUE;

Line 3185: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;

3181: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3182: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3183: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3184: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3185: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3186: ELSIF(p_basis = 'FLAT') THEN
3187: l_flat_rate := TRUE;
3188: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_FLAT_CH;
3189: ELSE

Line 3188: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_FLAT_CH;

3184: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3185: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3186: ELSIF(p_basis = 'FLAT') THEN
3187: l_flat_rate := TRUE;
3188: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_FLAT_CH;
3189: ELSE
3190: x_status := 3;
3191: END IF;
3192:

Line 3194: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

3190: x_status := 3;
3191: END IF;
3192:
3193: ELSIF (p_load_type = 'ASSISTED_LOADING') THEN
3194: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3195: l_attr3_value := 'JOINT';
3196: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3197:
3198: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

Line 3196: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;

3192:
3193: ELSIF (p_load_type = 'ASSISTED_LOADING') THEN
3194: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3195: l_attr3_value := 'JOINT';
3196: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3197:
3198: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3199: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3200: l_attr2_type := 'TL_PICKUP_WT';

Line 3198: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3194: l_attr1_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3195: l_attr3_value := 'JOINT';
3196: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3197:
3198: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3199: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3200: l_attr2_type := 'TL_PICKUP_WT';
3201: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3199: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;

3195: l_attr3_value := 'JOINT';
3196: l_subtype_min := FTE_RTG_GLOBALS.G_C_MIN_AST_LOADING_CH;
3197:
3198: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3199: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3200: l_attr2_type := 'TL_PICKUP_WT';
3201: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;

Line 3201: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;

3197:
3198: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3199: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3200: l_attr2_type := 'TL_PICKUP_WT';
3201: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3204: l_attr2_type := 'TL_PICKUP_VOL';
3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;

Line 3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3198: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3199: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3200: l_attr2_type := 'TL_PICKUP_WT';
3201: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3204: l_attr2_type := 'TL_PICKUP_VOL';
3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;

3199: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_WEIGHT_CH;
3200: l_attr2_type := 'TL_PICKUP_WT';
3201: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3204: l_attr2_type := 'TL_PICKUP_VOL';
3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;

Line 3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;

3201: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_WT;
3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3204: l_attr2_type := 'TL_PICKUP_VOL';
3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3208: l_attr2_type := 'TL_PICKUP_PALLET';
3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;

Line 3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3202: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3204: l_attr2_type := 'TL_PICKUP_VOL';
3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3208: l_attr2_type := 'TL_PICKUP_PALLET';
3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3210: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;

3203: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_VOLUME_CH;
3204: l_attr2_type := 'TL_PICKUP_VOL';
3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3208: l_attr2_type := 'TL_PICKUP_PALLET';
3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3210: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3211: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;

Line 3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;

3205: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_VOL;
3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3208: l_attr2_type := 'TL_PICKUP_PALLET';
3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3210: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3211: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3212: l_attr2_type := 'TL_PICKUP_CONTAINER';
3213: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;

Line 3210: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3206: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3208: l_attr2_type := 'TL_PICKUP_PALLET';
3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3210: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3211: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3212: l_attr2_type := 'TL_PICKUP_CONTAINER';
3213: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3214: ELSIF(p_basis = 'FLAT') THEN

Line 3211: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;

3207: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_PALLET_CH;
3208: l_attr2_type := 'TL_PICKUP_PALLET';
3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3210: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3211: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3212: l_attr2_type := 'TL_PICKUP_CONTAINER';
3213: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3214: ELSIF(p_basis = 'FLAT') THEN
3215: l_flat_rate := TRUE;

Line 3213: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;

3209: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_PALLET;
3210: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3211: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_CONTAINER_CH;
3212: l_attr2_type := 'TL_PICKUP_CONTAINER';
3213: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3214: ELSIF(p_basis = 'FLAT') THEN
3215: l_flat_rate := TRUE;
3216: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_FLAT_CH;
3217: ELSE

Line 3216: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_FLAT_CH;

3212: l_attr2_type := 'TL_PICKUP_CONTAINER';
3213: l_attr2_context := FTE_RTG_GLOBALS.G_AX_TL_PICKUP_CONTAINER;
3214: ELSIF(p_basis = 'FLAT') THEN
3215: l_flat_rate := TRUE;
3216: l_subtype := FTE_RTG_GLOBALS.G_C_AST_LOADING_FLAT_CH;
3217: ELSE
3218: x_status := 3;
3219: END IF;
3220:

Line 3224: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;

3220:
3221: ELSIF (p_load_type = 'FACILITY_ASSISTED_LOADING') THEN
3222: l_attr1_value := 'FACILITY_CHARGE';
3223: l_attr3_value := 'JOINT';
3224: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;
3225:
3226: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3227: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3228: l_attr2_type := 'FAC_PICKUP_WT';

Line 3226: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

3222: l_attr1_value := 'FACILITY_CHARGE';
3223: l_attr3_value := 'JOINT';
3224: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;
3225:
3226: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3227: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3228: l_attr2_type := 'FAC_PICKUP_WT';
3229: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 3227: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;

3223: l_attr3_value := 'JOINT';
3224: l_subtype_min := FTE_RTG_GLOBALS.G_F_MIN_AST_LOADING_CH;
3225:
3226: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3227: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3228: l_attr2_type := 'FAC_PICKUP_WT';
3229: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;

Line 3229: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;

3225:
3226: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3227: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3228: l_attr2_type := 'FAC_PICKUP_WT';
3229: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3232: l_attr2_type := 'FAC_PICKUP_VOL';
3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;

Line 3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

3226: IF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
3227: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3228: l_attr2_type := 'FAC_PICKUP_WT';
3229: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3232: l_attr2_type := 'FAC_PICKUP_VOL';
3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;

3227: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_WEIGHT_CH;
3228: l_attr2_type := 'FAC_PICKUP_WT';
3229: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3232: l_attr2_type := 'FAC_PICKUP_VOL';
3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;

Line 3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;

3229: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_WT;
3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3232: l_attr2_type := 'FAC_PICKUP_VOL';
3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3236: l_attr2_type := 'FAC_PICKUP_PALLET';
3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;

Line 3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

3230: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3232: l_attr2_type := 'FAC_PICKUP_VOL';
3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3236: l_attr2_type := 'FAC_PICKUP_PALLET';
3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3238: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;

3231: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_VOLUME_CH;
3232: l_attr2_type := 'FAC_PICKUP_VOL';
3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3236: l_attr2_type := 'FAC_PICKUP_PALLET';
3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3238: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3239: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;

Line 3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;

3233: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_VOL;
3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3236: l_attr2_type := 'FAC_PICKUP_PALLET';
3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3238: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3239: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3240: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3241: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;

Line 3238: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

3234: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3236: l_attr2_type := 'FAC_PICKUP_PALLET';
3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3238: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3239: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3240: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3241: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3242: ELSIF(p_basis = 'FLAT') THEN

Line 3239: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;

3235: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_PALLET_CH;
3236: l_attr2_type := 'FAC_PICKUP_PALLET';
3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3238: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3239: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3240: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3241: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3242: ELSIF(p_basis = 'FLAT') THEN
3243: l_flat_rate := TRUE;

Line 3241: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;

3237: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_PALLET;
3238: ELSIF (p_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
3239: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_CONTAINER_CH;
3240: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3241: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3242: ELSIF(p_basis = 'FLAT') THEN
3243: l_flat_rate := TRUE;
3244: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_FLAT_CH;
3245: ELSE

Line 3244: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_FLAT_CH;

3240: l_attr2_type := 'FAC_PICKUP_CONTAINER';
3241: l_attr2_context := FTE_RTG_GLOBALS.G_AX_FAC_PICKUP_CONTAINER;
3242: ELSIF(p_basis = 'FLAT') THEN
3243: l_flat_rate := TRUE;
3244: l_subtype := FTE_RTG_GLOBALS.G_F_AST_LOADING_FLAT_CH;
3245: ELSE
3246: x_status := 3;
3247: END IF;
3248: END IF;

Line 3363: p_context => FTE_RTG_GLOBALS.G_AX_TL_STOP_LOADING_ACT,

3359:
3360: ADD_ATTRIBUTE (p_attribute_type => 'TL_STOP_LOADING_ACT',
3361: p_attribute_value => 'Y',
3362: p_attribute_value_to => NULL,
3363: p_context => FTE_RTG_GLOBALS.G_AX_TL_STOP_LOADING_ACT,
3364: p_linenum => x_linenum,
3365: p_comp_operator => '=',
3366: p_process_id => p_process_id,
3367: p_line_number => p_line_number,

Line 3376: p_context => FTE_RTG_GLOBALS.G_AX_TL_STOP_UNLOADING_ACT,

3372:
3373: ADD_ATTRIBUTE ( p_attribute_type => 'TL_STOP_UNLOADING_ACT',
3374: p_attribute_value => 'Y',
3375: p_attribute_value_to => NULL,
3376: p_context => FTE_RTG_GLOBALS.G_AX_TL_STOP_UNLOADING_ACT,
3377: p_linenum => x_linenum,
3378: p_comp_operator => '=',
3379: p_process_id => p_process_id,
3380: p_line_number => p_line_number,

Line 3389: p_context => FTE_RTG_GLOBALS.G_AX_TL_HANDLING_ACT,

3385:
3386: ADD_ATTRIBUTE (p_attribute_type => 'TL_HANDLING_ACT',
3387: p_attribute_value => 'Y',
3388: p_attribute_value_to => NULL,
3389: p_context => FTE_RTG_GLOBALS.G_AX_TL_HANDLING_ACT,
3390: p_linenum => x_linenum,
3391: p_comp_operator => '=',
3392: p_process_id => p_process_id,
3393: p_line_number => p_line_number,

Line 3548: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN

3544: l_break_type := 'POINT';
3545: l_rate_type := 'FIXED';
3546: l_volume_type:= 'TOTAL_QUANTITY';
3547:
3548: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3549: l_description := 'Out Of Route Charge: Line ' || x_linenum;
3550: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3551: l_description := 'Weekday Layover Charge: Line ' || x_linenum;
3552: END IF;

Line 3550: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN

3546: l_volume_type:= 'TOTAL_QUANTITY';
3547:
3548: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3549: l_description := 'Out Of Route Charge: Line ' || x_linenum;
3550: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3551: l_description := 'Weekday Layover Charge: Line ' || x_linenum;
3552: END IF;
3553:
3554: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 3594: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;

3590: END IF;
3591:
3592: -- add Rate Type Attribute
3593: l_attribute_type := 'TL_RATE_TYPE';
3594: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
3595:
3596: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3597: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
3598: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN

Line 3596: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN

3592: -- add Rate Type Attribute
3593: l_attribute_type := 'TL_RATE_TYPE';
3594: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
3595:
3596: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3597: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
3598: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3599: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3600: END IF;

Line 3597: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;

3593: l_attribute_type := 'TL_RATE_TYPE';
3594: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
3595:
3596: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3597: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
3598: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3599: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3600: END IF;
3601:

Line 3598: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN

3594: l_context := FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE;
3595:
3596: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3597: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
3598: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3599: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3600: END IF;
3601:
3602: IF (l_attribute_type IS NOT NULL AND l_context IS NOT NULL) THEN

Line 3599: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

3595:
3596: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3597: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
3598: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3599: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
3600: END IF;
3601:
3602: IF (l_attribute_type IS NOT NULL AND l_context IS NOT NULL) THEN
3603: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,

Line 3616: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN

3612: x_status => x_status);
3613: END IF;
3614:
3615: -- Add Charge Type Attribute
3616: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3617: l_attribute_type := 'TL_CHARGED_OUT_RT_DISTANCE';
3618: l_context := FTE_RTG_GLOBALS.G_AX_TL_CHARGED_OUT_RT_DIST;
3619:
3620: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN

Line 3618: l_context := FTE_RTG_GLOBALS.G_AX_TL_CHARGED_OUT_RT_DIST;

3614:
3615: -- Add Charge Type Attribute
3616: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3617: l_attribute_type := 'TL_CHARGED_OUT_RT_DISTANCE';
3618: l_context := FTE_RTG_GLOBALS.G_AX_TL_CHARGED_OUT_RT_DIST;
3619:
3620: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3621: l_attribute_type := 'TL_NUM_WEEKDAY_LAYOVERS';
3622: l_context := FTE_RTG_GLOBALS.G_AX_TL_NUM_WEEKDAY_LAYOVERS;

Line 3620: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN

3616: IF (p_subtype = FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH) THEN
3617: l_attribute_type := 'TL_CHARGED_OUT_RT_DISTANCE';
3618: l_context := FTE_RTG_GLOBALS.G_AX_TL_CHARGED_OUT_RT_DIST;
3619:
3620: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3621: l_attribute_type := 'TL_NUM_WEEKDAY_LAYOVERS';
3622: l_context := FTE_RTG_GLOBALS.G_AX_TL_NUM_WEEKDAY_LAYOVERS;
3623: END IF;
3624:

Line 3622: l_context := FTE_RTG_GLOBALS.G_AX_TL_NUM_WEEKDAY_LAYOVERS;

3618: l_context := FTE_RTG_GLOBALS.G_AX_TL_CHARGED_OUT_RT_DIST;
3619:
3620: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3621: l_attribute_type := 'TL_NUM_WEEKDAY_LAYOVERS';
3622: l_context := FTE_RTG_GLOBALS.G_AX_TL_NUM_WEEKDAY_LAYOVERS;
3623: END IF;
3624:
3625:
3626: -- NOTE: attributes with context VOLUME should not be put on the PBH.

Line 3878: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,

3874:
3875: l_rate_basis := 'FLAT';
3876: l_rate_basis_uom := g_unit_uom;
3877:
3878: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3879: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,

Line 3879: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,

3875: l_rate_basis := 'FLAT';
3876: l_rate_basis_uom := g_unit_uom;
3877:
3878: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3879: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
3883: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,

Line 3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,

3876: l_rate_basis_uom := g_unit_uom;
3877:
3878: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3879: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
3883: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
3884: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN

Line 3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,

3877:
3878: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3879: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
3883: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
3884: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
3885:

Line 3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,

3878: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3879: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
3883: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
3884: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
3885:
3886: x_status := 2;

Line 3883: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,

3879: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
3883: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
3884: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
3885:
3886: x_status := 2;
3887: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_BASIS_INVALID');

Line 3884: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN

3880: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3881: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3882: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
3883: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
3884: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
3885:
3886: x_status := 2;
3887: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_BASIS_INVALID');
3888: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,

Line 3897: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,

3893: RETURN;
3894: --+
3895: -- UOM Required for 'DISTANCE', 'TIME', 'VOLUME', 'WEIGHT'
3896: --+
3897: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3898: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3899: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3900: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
3901: IF (l_rate_basis_uom IS NULL OR LENGTH(l_rate_basis_uom) = 0) THEN

Line 3898: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,

3894: --+
3895: -- UOM Required for 'DISTANCE', 'TIME', 'VOLUME', 'WEIGHT'
3896: --+
3897: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3898: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3899: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3900: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
3901: IF (l_rate_basis_uom IS NULL OR LENGTH(l_rate_basis_uom) = 0) THEN
3902: x_status := 2;

Line 3899: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,

3895: -- UOM Required for 'DISTANCE', 'TIME', 'VOLUME', 'WEIGHT'
3896: --+
3897: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3898: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3899: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3900: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
3901: IF (l_rate_basis_uom IS NULL OR LENGTH(l_rate_basis_uom) = 0) THEN
3902: x_status := 2;
3903: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_BASIS_UOM_MISSING');

Line 3900: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN

3896: --+
3897: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
3898: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
3899: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
3900: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
3901: IF (l_rate_basis_uom IS NULL OR LENGTH(l_rate_basis_uom) = 0) THEN
3902: x_status := 2;
3903: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_BASIS_UOM_MISSING');
3904: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,

Line 3930: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,

3926: END IF;
3927:
3928: END IF;
3929:
3930: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3931: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN
3932: l_rate_basis_uom := g_unit_uom;
3933: END IF;
3934:

Line 3931: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN

3927:
3928: END IF;
3929:
3930: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
3931: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN
3932: l_rate_basis_uom := g_unit_uom;
3933: END IF;
3934:
3935: IF (p_chart_type = 'TL_MODIFIER') THEN

Line 3982: p_subtype => FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH,

3978:
3979: END IF;
3980:
3981: PROCESS_BLOCK_UNIT_CHARGES(p_charge => l_out_rt_chg,
3982: p_subtype => FTE_RTG_GLOBALS.G_C_OUT_OF_ROUTE_CH,
3983: p_uom => g_unit_uom,
3984: p_process_id => p_process_id,
3985: x_linenum => x_linenum,
3986: p_line_number => p_line_number,

Line 4004: p_subtype => FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH,

4000:
4001: IF (l_wkday_layovr_chg IS NOT NULL) THEN
4002:
4003: PROCESS_BLOCK_UNIT_CHARGES(p_charge => l_wkday_layovr_chg,
4004: p_subtype => FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH,
4005: p_uom => g_unit_uom,
4006: p_process_id => p_process_id,
4007: x_linenum => x_linenum,
4008: p_line_number => p_line_number,

Line 4025: l_subtype := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DISCOUNT;

4021:
4022: IF (l_cont_mv_dsct_prcnt IS NOT NULL) THEN
4023:
4024: l_type := 'DISCOUNT';
4025: l_subtype := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DISCOUNT;
4026:
4027: x_linenum := x_linenum + 1;
4028: l_description := ' Continuous Move Discount Line ' || x_linenum;
4029:

Line 4059: l_context := FTE_RTG_GLOBALS.G_AX_TL_CM_DISCOUNT_FLG;

4055: END IF;
4056:
4057: -- Add CHARGE Attribute
4058: l_attribute_type := 'TL_CM_DISCOUNT_FLG';
4059: l_context := FTE_RTG_GLOBALS.G_AX_TL_CM_DISCOUNT_FLG;
4060: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
4061: p_attribute_value => 'Y',
4062: p_attribute_value_to => NULL,
4063: p_context => l_context,

Line 5510: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,

5506:
5507: IF (l_rate_basis IS NULL OR length(l_rate_basis) = 0 OR l_rate_basis = 'FLAT') THEN
5508: l_rate_basis := 'FLAT';
5509: l_rate_basis_uom := g_unit_uom;
5510: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5511: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN
5512: l_rate_basis_uom := g_unit_uom;
5513: END IF;
5514:

Line 5511: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN

5507: IF (l_rate_basis IS NULL OR length(l_rate_basis) = 0 OR l_rate_basis = 'FLAT') THEN
5508: l_rate_basis := 'FLAT';
5509: l_rate_basis_uom := g_unit_uom;
5510: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5511: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN
5512: l_rate_basis_uom := g_unit_uom;
5513: END IF;
5514:
5515: END IF;

Line 5716: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,

5712:
5713: l_rate_basis := 'FLAT';
5714: l_rate_basis_uom := g_unit_uom;
5715:
5716: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5717: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,

Line 5717: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,

5713: l_rate_basis := 'FLAT';
5714: l_rate_basis_uom := g_unit_uom;
5715:
5716: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5717: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
5721: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,

Line 5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,

5714: l_rate_basis_uom := g_unit_uom;
5715:
5716: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5717: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
5721: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
5722: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN

Line 5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,

5715:
5716: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5717: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
5721: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
5722: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
5723: x_status := 2;

Line 5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,

5716: ELSIF (l_rate_basis NOT IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5717: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
5721: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
5722: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
5723: x_status := 2;
5724: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BASIS_INVALID');

Line 5721: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,

5717: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
5721: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
5722: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
5723: x_status := 2;
5724: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BASIS_INVALID');
5725: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,

Line 5722: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN

5718: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5719: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5720: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET,
5721: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME,
5722: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT)) THEN
5723: x_status := 2;
5724: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BASIS_INVALID');
5725: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5726: p_module_name => l_module_name,

Line 5731: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,

5727: p_category => 'D',
5728: p_line_number => p_line_number + i + 1); -- add tokens
5729: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5730: RETURN;
5731: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5732: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5733: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5734: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
5735:

Line 5732: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,

5728: p_line_number => p_line_number + i + 1); -- add tokens
5729: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5730: RETURN;
5731: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5732: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5733: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5734: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
5735:
5736: --+

Line 5733: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,

5729: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5730: RETURN;
5731: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5732: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5733: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5734: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
5735:
5736: --+
5737: -- UOM is required for 'DISTANCE', 'TIME', 'VOLUME', 'WEIGHT'

Line 5734: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN

5730: RETURN;
5731: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST,
5732: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT,
5733: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL,
5734: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME)) THEN
5735:
5736: --+
5737: -- UOM is required for 'DISTANCE', 'TIME', 'VOLUME', 'WEIGHT'
5738: -- Note that when called from UI, p_doValidate will be false and we have

Line 5766: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,

5762: RETURN;
5763: END IF;
5764: END IF;
5765:
5766: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5767: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN
5768: l_rate_basis_uom := g_unit_uom;
5769: END IF;
5770:

Line 5767: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN

5763: END IF;
5764: END IF;
5765:
5766: ELSIF (l_rate_basis IN (FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT,
5767: FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET)) THEN
5768: l_rate_basis_uom := g_unit_uom;
5769: END IF;
5770:
5771: --+

Line 5774: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST) THEN

5770:
5771: --+
5772: -- Distance Type(loaded, unloaded and continuous) is required if rate_basis is DISTANCE
5773: --+
5774: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST) THEN
5775: IF (l_dist_type IS NULL OR LENGTH(l_dist_type) = 0) THEN
5776: x_status := 2;
5777: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_DISTANCE_TYPE_MISSING');
5778: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,

Line 5884: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST) THEN

5880:
5881: --+
5882: -- Set the precedence and rate type, store min charges
5883: --+
5884: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST) THEN
5885:
5886: IF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_UNLOADED) THEN
5887: l_attribute := FTE_RTG_GLOBALS.G_C_UNLOADED_DISTANCE_RT;
5888: l_precedence := G_CONST_PRECEDENCE_LOW;

Line 5886: IF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_UNLOADED) THEN

5882: -- Set the precedence and rate type, store min charges
5883: --+
5884: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST) THEN
5885:
5886: IF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_UNLOADED) THEN
5887: l_attribute := FTE_RTG_GLOBALS.G_C_UNLOADED_DISTANCE_RT;
5888: l_precedence := G_CONST_PRECEDENCE_LOW;
5889: l_deadhead := TRUE;
5890: ELSIF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM) THEN

Line 5887: l_attribute := FTE_RTG_GLOBALS.G_C_UNLOADED_DISTANCE_RT;

5883: --+
5884: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST) THEN
5885:
5886: IF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_UNLOADED) THEN
5887: l_attribute := FTE_RTG_GLOBALS.G_C_UNLOADED_DISTANCE_RT;
5888: l_precedence := G_CONST_PRECEDENCE_LOW;
5889: l_deadhead := TRUE;
5890: ELSIF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM) THEN
5891: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DIST_RT;

Line 5890: ELSIF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM) THEN

5886: IF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_UNLOADED) THEN
5887: l_attribute := FTE_RTG_GLOBALS.G_C_UNLOADED_DISTANCE_RT;
5888: l_precedence := G_CONST_PRECEDENCE_LOW;
5889: l_deadhead := TRUE;
5890: ELSIF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM) THEN
5891: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DIST_RT;
5892: l_precedence := G_CONST_PRECEDENCE_MID;
5893: ELSIF (l_dist_type = 'LOADED') THEN
5894: l_attribute := FTE_RTG_GLOBALS.G_C_LOADED_DISTANCE_RT;

Line 5891: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DIST_RT;

5887: l_attribute := FTE_RTG_GLOBALS.G_C_UNLOADED_DISTANCE_RT;
5888: l_precedence := G_CONST_PRECEDENCE_LOW;
5889: l_deadhead := TRUE;
5890: ELSIF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM) THEN
5891: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DIST_RT;
5892: l_precedence := G_CONST_PRECEDENCE_MID;
5893: ELSIF (l_dist_type = 'LOADED') THEN
5894: l_attribute := FTE_RTG_GLOBALS.G_C_LOADED_DISTANCE_RT;
5895: ELSE

Line 5894: l_attribute := FTE_RTG_GLOBALS.G_C_LOADED_DISTANCE_RT;

5890: ELSIF (l_dist_type = FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM) THEN
5891: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DIST_RT;
5892: l_precedence := G_CONST_PRECEDENCE_MID;
5893: ELSIF (l_dist_type = 'LOADED') THEN
5894: l_attribute := FTE_RTG_GLOBALS.G_C_LOADED_DISTANCE_RT;
5895: ELSE
5896: x_status := 2;
5897: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_DISTANCE_TYPE_INVALID');
5898: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,

Line 5906: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN

5902: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5903: RETURN;
5904: END IF;
5905:
5906: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN
5907: l_attribute := FTE_RTG_GLOBALS.G_C_FLAT_RT;
5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN
5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

Line 5907: l_attribute := FTE_RTG_GLOBALS.G_C_FLAT_RT;

5903: RETURN;
5904: END IF;
5905:
5906: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN
5907: l_attribute := FTE_RTG_GLOBALS.G_C_FLAT_RT;
5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN
5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;

Line 5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN

5904: END IF;
5905:
5906: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN
5907: l_attribute := FTE_RTG_GLOBALS.G_C_FLAT_RT;
5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN
5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

Line 5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;

5905:
5906: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN
5907: l_attribute := FTE_RTG_GLOBALS.G_C_FLAT_RT;
5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN
5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;

Line 5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN

5906: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN
5907: l_attribute := FTE_RTG_GLOBALS.G_C_FLAT_RT;
5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN
5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

Line 5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;

5907: l_attribute := FTE_RTG_GLOBALS.G_C_FLAT_RT;
5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN
5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;

Line 5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN

5908: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_TIME) THEN
5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;
5916: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

Line 5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;

5909: l_attribute := FTE_RTG_GLOBALS.G_C_TIME_RT;
5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;
5916: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
5917: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_PALLET_RT;

Line 5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN

5910: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_WT) THEN
5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;
5916: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
5917: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_PALLET_RT;
5918: END IF;

Line 5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;

5911: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_WT_RT;
5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;
5916: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
5917: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_PALLET_RT;
5918: END IF;
5919:

Line 5916: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN

5912: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_VOL) THEN
5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;
5916: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
5917: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_PALLET_RT;
5918: END IF;
5919:
5920: --+

Line 5917: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_PALLET_RT;

5913: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_VOL_RT;
5914: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_CONT) THEN
5915: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_CONT_RT;
5916: ELSIF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_PALLET) THEN
5917: l_attribute := FTE_RTG_GLOBALS.G_C_UNIT_PALLET_RT;
5918: END IF;
5919:
5920: --+
5921: -- For the first line of the RC, we have to create the header.

Line 5985: l_rate_line_data('ATTRIBUTE1') := FTE_RTG_GLOBALS.G_C_STOP_LEVEL_CHARGES_RT;

5981: l_rate_line_data('DESCRIPTION') := l_description;
5982: l_rate_line_data('RATE') := 0;
5983: l_rate_line_data('UOM') := g_unit_uom;
5984: l_rate_line_data('VOLUME_TYPE') := 'TOTAL_QUANTITY';
5985: l_rate_line_data('ATTRIBUTE1') := FTE_RTG_GLOBALS.G_C_STOP_LEVEL_CHARGES_RT;
5986: l_rate_line_data('PRECEDENCE') := l_precedence;
5987: l_rate_line_data('RATE_TYPE') := 'PER_UOM';
5988: l_rate_line_data('START_DATE_ACTIVE') := l_start_date;
5989: l_rate_line_data('END_DATE_ACTIVE') := l_end_date;

Line 6012: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;

6008: --+
6009: -- Add Rate Type Attribute 'STOP_CHARGE'
6010: --+
6011: l_attribute_type := 'TL_RATE_TYPE';
6012: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
6013: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6014: p_attribute_value => l_attribute_value,
6015: p_attribute_value_to => NULL,
6016: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,

Line 6016: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,

6012: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_STOP;
6013: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6014: p_attribute_value => l_attribute_value,
6015: p_attribute_value_to => NULL,
6016: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,
6017: p_linenum => l_linenum,
6018: p_comp_operator => NULL,
6019: p_process_id => l_process_id,
6020: p_line_number => p_line_number + i + 1,

Line 6045: l_rate_line_data('ATTRIBUTE1') := FTE_RTG_GLOBALS.G_C_LOAD_LEVEL_CHARGES_RT;

6041: l_rate_line_data('DESCRIPTION'):= l_description;
6042: l_rate_line_data('RATE') := 0;
6043: l_rate_line_data('UOM') := g_unit_uom;
6044: l_rate_line_data('VOLUME_TYPE'):= 'TOTAL_QUANTITY';
6045: l_rate_line_data('ATTRIBUTE1') := FTE_RTG_GLOBALS.G_C_LOAD_LEVEL_CHARGES_RT;
6046: l_rate_line_data('PRECEDENCE') := l_precedence;
6047: l_rate_line_data('RATE_TYPE') := 'PER_UOM';
6048: l_rate_line_data('START_DATE_ACTIVE') := l_start_date;
6049: l_rate_line_data('END_DATE_ACTIVE') := l_end_date;

Line 6071: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;

6067: --+
6068: -- Add Rate Type Attribute 'LOAD_CHARGE'
6069: --+
6070: l_attribute_type := 'TL_RATE_TYPE';
6071: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
6072: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
6073: p_attribute_value => l_attribute_value,
6074: p_attribute_value_to => NULL,
6075: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,

Line 6075: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,

6071: l_attribute_value := FTE_RTG_GLOBALS.G_TL_RATE_TYPE_LOAD;
6072: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
6073: p_attribute_value => l_attribute_value,
6074: p_attribute_value_to => NULL,
6075: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,
6076: p_linenum => l_linenum,
6077: p_comp_operator => NULL,
6078: p_process_id => l_process_id,
6079: p_line_number => p_line_number + i + 1,

Line 6130: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_BASIS,

6126: l_attribute_type := 'TL_RATE_BASIS';
6127: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6128: p_attribute_value => l_rate_basis,
6129: p_attribute_value_to => NULL,
6130: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_BASIS,
6131: p_linenum => l_linenum,
6132: p_comp_operator => NULL,
6133: p_process_id => l_process_id,
6134: p_line_number => p_line_number + i + 1,

Line 6147: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST AND

6143: --+
6144: -- Add DISTANCE_TYPE attribute if rate basis is DISTANCE
6145: -- and distance type IS NOT LOADED
6146: --+
6147: IF (l_rate_basis = FTE_RTG_GLOBALS.G_TL_RATE_BASIS_DIST AND
6148: l_dist_type IN ('UNLOADED', 'CONTINUOUS_MOVE')) THEN
6149:
6150: l_attribute_type := 'TL_DISTANCE_TYPE';
6151: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,

Line 6154: p_context => FTE_RTG_GLOBALS.G_AX_TL_DISTANCE_TYPE,

6150: l_attribute_type := 'TL_DISTANCE_TYPE';
6151: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
6152: p_attribute_value => l_dist_type,
6153: p_attribute_value_to => NULL,
6154: p_context => FTE_RTG_GLOBALS.G_AX_TL_DISTANCE_TYPE,
6155: p_linenum => l_linenum,
6156: p_comp_operator => NULL,
6157: p_process_id => l_process_id,
6158: p_line_number => p_line_number + i + 1,

Line 6176: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,

6172: l_attribute_value := 'BASE_RATE';
6173: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6174: p_attribute_value => l_attribute_value,
6175: p_attribute_value_to => NULL,
6176: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,
6177: p_linenum => l_linenum,
6178: p_comp_operator => NULL,
6179: p_process_id => l_process_id,
6180: p_line_number => p_line_number + i + 1,

Line 6198: p_context => FTE_RTG_GLOBALS.G_AX_VEHICLE,

6194: l_attribute_type := 'TL_VEHICLE_TYPE';
6195: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6196: p_attribute_value => l_vehicle_type,
6197: p_attribute_value_to => NULL,
6198: p_context => FTE_RTG_GLOBALS.G_AX_VEHICLE,
6199: p_linenum => l_linenum,
6200: p_process_id => l_process_id,
6201: p_comp_operator => NULL,
6202: p_line_number => p_line_number,

Line 6227: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DH_RT;

6223: --+
6224: l_linenum := l_linenum + 1;
6225: l_description := 'Line ' || l_linenum || ' Of ' || l_rate_chart_name;
6226:
6227: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DH_RT;
6228: l_precedence := G_CONST_PRECEDENCE_LOW;
6229:
6230: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
6231: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_description);

Line 6267: p_attribute_value => FTE_RTG_GLOBALS.G_TL_DEADHEAD_RT_VAR_YES,

6263: -- Attach the DEADHEAD_RATING to the line
6264: --+
6265: l_attribute_type := 'TL_DEADHEAD_RT_VAR';
6266: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6267: p_attribute_value => FTE_RTG_GLOBALS.G_TL_DEADHEAD_RT_VAR_YES,
6268: p_attribute_value_to => NULL,
6269: p_context => FTE_RTG_GLOBALS.G_AX_TL_DEADHEAD_RT_VAR,
6270: p_linenum => l_linenum,
6271: p_process_id => l_process_id,

Line 6269: p_context => FTE_RTG_GLOBALS.G_AX_TL_DEADHEAD_RT_VAR,

6265: l_attribute_type := 'TL_DEADHEAD_RT_VAR';
6266: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6267: p_attribute_value => FTE_RTG_GLOBALS.G_TL_DEADHEAD_RT_VAR_YES,
6268: p_attribute_value_to => NULL,
6269: p_context => FTE_RTG_GLOBALS.G_AX_TL_DEADHEAD_RT_VAR,
6270: p_linenum => l_linenum,
6271: p_process_id => l_process_id,
6272: p_comp_operator => NULL,
6273: p_line_number => p_line_number + i + 1,

Line 6289: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_BASIS,

6285: l_attribute_type := 'TL_RATE_BASIS';
6286: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6287: p_attribute_value => l_rate_basis,
6288: p_attribute_value_to => NULL,
6289: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_BASIS,
6290: p_linenum => l_linenum,
6291: p_process_id => l_process_id,
6292: p_comp_operator => NULL,
6293: p_line_number => p_line_number + i + 1,

Line 6307: p_attribute_value => FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM,

6303: -- Attach the Distance Type 'CONTINUOUS_MOVE' to the line.
6304: --+
6305: l_attribute_type := 'TL_DISTANCE_TYPE';
6306: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6307: p_attribute_value => FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM,
6308: p_attribute_value_to => NULL,
6309: p_context => FTE_RTG_GLOBALS.G_AX_TL_DISTANCE_TYPE,
6310: p_linenum => l_linenum,
6311: p_comp_operator => NULL,

Line 6309: p_context => FTE_RTG_GLOBALS.G_AX_TL_DISTANCE_TYPE,

6305: l_attribute_type := 'TL_DISTANCE_TYPE';
6306: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
6307: p_attribute_value => FTE_RTG_GLOBALS.G_TL_DIST_TYPE_CM,
6308: p_attribute_value_to => NULL,
6309: p_context => FTE_RTG_GLOBALS.G_AX_TL_DISTANCE_TYPE,
6310: p_linenum => l_linenum,
6311: p_comp_operator => NULL,
6312: p_process_id => l_process_id,
6313: p_line_number => p_line_number + i + 1,

Line 6331: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,

6327:
6328: ADD_ATTRIBUTE(p_attribute_type => l_attribute_type,
6329: p_attribute_value => l_attribute_value,
6330: p_attribute_value_to => NULL,
6331: p_context => FTE_RTG_GLOBALS.G_AX_TL_RATE_TYPE,
6332: p_linenum => l_linenum,
6333: p_comp_operator => NULL,
6334: p_process_id => l_process_id,
6335: p_line_number => p_line_number + i + 1,

Line 6356: p_context => FTE_RTG_GLOBALS.G_AX_VEHICLE,

6352: l_attribute_type := 'TL_VEHICLE_TYPE';
6353: ADD_ATTRIBUTE ( p_attribute_type => l_attribute_type,
6354: p_attribute_value => l_vehicle_type,
6355: p_attribute_value_to => NULL,
6356: p_context => FTE_RTG_GLOBALS.G_AX_VEHICLE,
6357: p_linenum => l_linenum,
6358: p_comp_operator => NULL,
6359: p_process_id => l_process_id,
6360: p_line_number => p_line_number + i + 1,

Line 6376: IF (l_rate_basis <> FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN

6372: --+
6373: -- Validate and store the minimum charge, if it is specified.
6374: --+
6375: IF (l_min_charge IS NOT NULL) THEN
6376: IF (l_rate_basis <> FTE_RTG_GLOBALS.G_TL_RATE_BASIS_FLAT) THEN
6377: STORE_MIN_CHARGE(p_chart_name => l_rate_chart_name,
6378: p_charge => l_min_charge,
6379: p_basis => l_rate_basis,
6380: p_uom => l_rate_basis_uom,