eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TL_COST_ALLOCATION dependencies on FTE_RTG_GLOBALS

Line 981: OR ((x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

977: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fetch_alloc_param_fail;
978: END IF;
979:
980: IF ( (x_cost_allocation_parameters.principal_alloc_basis IS NULL)
981: OR ((x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
982: AND (x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS))
983: OR (x_cost_allocation_parameters.distance_alloc_method IS NULL)
984: OR ((x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE )
985: AND (x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE ))

Line 982: AND (x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS))

978: END IF;
979:
980: IF ( (x_cost_allocation_parameters.principal_alloc_basis IS NULL)
981: OR ((x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
982: AND (x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS))
983: OR (x_cost_allocation_parameters.distance_alloc_method IS NULL)
984: OR ((x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE )
985: AND (x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE ))
986: OR (x_cost_allocation_parameters.tl_stop_alloc_method IS NULL)

Line 984: OR ((x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE )

980: IF ( (x_cost_allocation_parameters.principal_alloc_basis IS NULL)
981: OR ((x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
982: AND (x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS))
983: OR (x_cost_allocation_parameters.distance_alloc_method IS NULL)
984: OR ((x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE )
985: AND (x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE ))
986: OR (x_cost_allocation_parameters.tl_stop_alloc_method IS NULL)
987: OR ( (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_PICKUP_STOP)
988: AND (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP))

Line 985: AND (x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE ))

981: OR ((x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
982: AND (x_cost_allocation_parameters.principal_alloc_basis <> FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS))
983: OR (x_cost_allocation_parameters.distance_alloc_method IS NULL)
984: OR ((x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE )
985: AND (x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE ))
986: OR (x_cost_allocation_parameters.tl_stop_alloc_method IS NULL)
987: OR ( (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_PICKUP_STOP)
988: AND (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP))
989:

Line 987: OR ( (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_PICKUP_STOP)

983: OR (x_cost_allocation_parameters.distance_alloc_method IS NULL)
984: OR ((x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE )
985: AND (x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE ))
986: OR (x_cost_allocation_parameters.tl_stop_alloc_method IS NULL)
987: OR ( (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_PICKUP_STOP)
988: AND (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP))
989:
990: )
991: THEN

Line 988: AND (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP))

984: OR ((x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE )
985: AND (x_cost_allocation_parameters.distance_alloc_method <> FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE ))
986: OR (x_cost_allocation_parameters.tl_stop_alloc_method IS NULL)
987: OR ( (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_PICKUP_STOP)
988: AND (x_cost_allocation_parameters.tl_stop_alloc_method <> FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP))
989:
990: )
991: THEN
992:

Line 1002: --x_cost_allocation_parameters.distance_alloc_method:=FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE;

998:
999: END IF;
1000:
1001:
1002: --x_cost_allocation_parameters.distance_alloc_method:=FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE;
1003: --x_cost_allocation_parameters.tl_stop_alloc_method:=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP;
1004: --x_cost_allocation_parameters.output_type:='T';
1005: --x_cost_allocation_parameters.comparison_request_id:=102;
1006:

Line 1003: --x_cost_allocation_parameters.tl_stop_alloc_method:=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP;

999: END IF;
1000:
1001:
1002: --x_cost_allocation_parameters.distance_alloc_method:=FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE;
1003: --x_cost_allocation_parameters.tl_stop_alloc_method:=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP;
1004: --x_cost_allocation_parameters.output_type:='T';
1005: --x_cost_allocation_parameters.comparison_request_id:=102;
1006:
1007: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_cost_allocation_parameters.principal_alloc_basis='||x_cost_allocation_parameters.principal_alloc_basis);

Line 1483: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS) AND

1479:
1480: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1481: x_fraction:=0;
1482:
1483: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS) AND
1484: (p_stop_rec.pickup_weight>0))
1485: THEN
1486: x_fraction:=p_dleg_rec.weight/p_stop_rec.pickup_weight;
1487:

Line 1488: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_VOLUME_BASIS)

1484: (p_stop_rec.pickup_weight>0))
1485: THEN
1486: x_fraction:=p_dleg_rec.weight/p_stop_rec.pickup_weight;
1487:
1488: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_VOLUME_BASIS)
1489: AND(p_stop_rec.pickup_volume>0))
1490: THEN
1491: x_fraction:=p_dleg_rec.volume/p_stop_rec.pickup_volume;
1492:

Line 1493: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_CONTAINER_BASIS)AND

1489: AND(p_stop_rec.pickup_volume>0))
1490: THEN
1491: x_fraction:=p_dleg_rec.volume/p_stop_rec.pickup_volume;
1492:
1493: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_CONTAINER_BASIS)AND
1494: (p_stop_rec.pickup_containers>0))
1495: THEN
1496: x_fraction:=p_dleg_rec.containers/p_stop_rec.pickup_containers;
1497:

Line 1498: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_PALLET_BASIS)

1494: (p_stop_rec.pickup_containers>0))
1495: THEN
1496: x_fraction:=p_dleg_rec.containers/p_stop_rec.pickup_containers;
1497:
1498: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_PALLET_BASIS)
1499: AND(p_stop_rec.pickup_pallets>0))
1500: THEN
1501: x_fraction:=p_dleg_rec.pallets/p_stop_rec.pickup_pallets;
1502:

Line 1503: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =

1499: AND(p_stop_rec.pickup_pallets>0))
1500: THEN
1501: x_fraction:=p_dleg_rec.pallets/p_stop_rec.pickup_pallets;
1502:
1503: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =
1504: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1505: THEN
1506: -- if basis is not wt/vol/container/pallet then use cost allocation
1507: --basis(Step 3 of CA algorithm)

Line 1504: FTE_RTG_GLOBALS.G_FLAT_BASIS))

1500: THEN
1501: x_fraction:=p_dleg_rec.pallets/p_stop_rec.pickup_pallets;
1502:
1503: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =
1504: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1505: THEN
1506: -- if basis is not wt/vol/container/pallet then use cost allocation
1507: --basis(Step 3 of CA algorithm)
1508:

Line 1509: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

1505: THEN
1506: -- if basis is not wt/vol/container/pallet then use cost allocation
1507: --basis(Step 3 of CA algorithm)
1508:
1509: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
1510: AND(p_stop_rec.pickup_weight>0))
1511: THEN
1512: x_fraction:=p_dleg_rec.weight/p_stop_rec.pickup_weight;
1513:

Line 1514: ELSIF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

1510: AND(p_stop_rec.pickup_weight>0))
1511: THEN
1512: x_fraction:=p_dleg_rec.weight/p_stop_rec.pickup_weight;
1513:
1514: ELSIF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
1515: AND(p_stop_rec.pickup_volume>0))
1516: THEN
1517:
1518: x_fraction:=p_dleg_rec.volume/p_stop_rec.pickup_volume;

Line 1579: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS)

1575:
1576: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1577:
1578: x_fraction:=0;
1579: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS)
1580: AND(p_stop_rec.dropoff_weight>0))
1581: THEN
1582: x_fraction:=p_dleg_rec.weight/p_stop_rec.dropoff_weight;
1583:

Line 1584: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_VOLUME_BASIS)

1580: AND(p_stop_rec.dropoff_weight>0))
1581: THEN
1582: x_fraction:=p_dleg_rec.weight/p_stop_rec.dropoff_weight;
1583:
1584: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_VOLUME_BASIS)
1585: AND(p_stop_rec.dropoff_volume>0))
1586: THEN
1587: x_fraction:=p_dleg_rec.volume/p_stop_rec.dropoff_volume;
1588:

Line 1589: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_CONTAINER_BASIS)

1585: AND(p_stop_rec.dropoff_volume>0))
1586: THEN
1587: x_fraction:=p_dleg_rec.volume/p_stop_rec.dropoff_volume;
1588:
1589: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_CONTAINER_BASIS)
1590: AND(p_stop_rec.dropoff_containers>0))
1591: THEN
1592: x_fraction:=p_dleg_rec.containers/p_stop_rec.dropoff_containers;
1593:

Line 1594: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_PALLET_BASIS)

1590: AND(p_stop_rec.dropoff_containers>0))
1591: THEN
1592: x_fraction:=p_dleg_rec.containers/p_stop_rec.dropoff_containers;
1593:
1594: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_PALLET_BASIS)
1595: AND(p_stop_rec.dropoff_pallets>0))
1596: THEN
1597: x_fraction:=p_dleg_rec.pallets/p_stop_rec.dropoff_pallets;
1598:

Line 1599: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =

1595: AND(p_stop_rec.dropoff_pallets>0))
1596: THEN
1597: x_fraction:=p_dleg_rec.pallets/p_stop_rec.dropoff_pallets;
1598:
1599: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =
1600: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1601: THEN
1602: --Step 3 of the CA algorithm
1603:

Line 1600: FTE_RTG_GLOBALS.G_FLAT_BASIS))

1596: THEN
1597: x_fraction:=p_dleg_rec.pallets/p_stop_rec.dropoff_pallets;
1598:
1599: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =
1600: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1601: THEN
1602: --Step 3 of the CA algorithm
1603:
1604: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

Line 1604: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

1600: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1601: THEN
1602: --Step 3 of the CA algorithm
1603:
1604: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
1605: AND(p_stop_rec.dropoff_weight>0))
1606: THEN
1607: x_fraction:=p_dleg_rec.weight/p_stop_rec.dropoff_weight;
1608:

Line 1609: ELSIF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

1605: AND(p_stop_rec.dropoff_weight>0))
1606: THEN
1607: x_fraction:=p_dleg_rec.weight/p_stop_rec.dropoff_weight;
1608:
1609: ELSIF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
1610: AND(p_stop_rec.dropoff_volume>0))
1611: THEN
1612:
1613: x_fraction:=p_dleg_rec.volume/p_stop_rec.dropoff_volume;

Line 1678: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS)

1674:
1675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1676:
1677: x_fraction:=0;
1678: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS)
1679: AND((p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight)>0))
1680: THEN
1681: x_fraction:=p_dleg_rec.weight/(p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight);
1682:

Line 1683: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_VOLUME_BASIS)

1679: AND((p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight)>0))
1680: THEN
1681: x_fraction:=p_dleg_rec.weight/(p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight);
1682:
1683: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_VOLUME_BASIS)
1684: AND((p_stop_rec.dropoff_volume+p_stop_rec.pickup_volume)>0))
1685: THEN
1686: x_fraction:=p_dleg_rec.volume/(p_stop_rec.dropoff_volume+p_stop_rec.pickup_volume);
1687:

Line 1688: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_CONTAINER_BASIS)

1684: AND((p_stop_rec.dropoff_volume+p_stop_rec.pickup_volume)>0))
1685: THEN
1686: x_fraction:=p_dleg_rec.volume/(p_stop_rec.dropoff_volume+p_stop_rec.pickup_volume);
1687:
1688: ELSIF ((p_basis =FTE_RTG_GLOBALS.G_CONTAINER_BASIS)
1689: AND((p_stop_rec.dropoff_containers+p_stop_rec.pickup_containers)>0))
1690: THEN
1691: x_fraction:=p_dleg_rec.containers/(p_stop_rec.dropoff_containers+p_stop_rec.pickup_containers);
1692:

Line 1693: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_PALLET_BASIS)

1689: AND((p_stop_rec.dropoff_containers+p_stop_rec.pickup_containers)>0))
1690: THEN
1691: x_fraction:=p_dleg_rec.containers/(p_stop_rec.dropoff_containers+p_stop_rec.pickup_containers);
1692:
1693: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_PALLET_BASIS)
1694: AND((p_stop_rec.dropoff_pallets+p_stop_rec.pickup_pallets)>0))
1695: THEN
1696: x_fraction:=p_dleg_rec.pallets/(p_stop_rec.dropoff_pallets+p_stop_rec.pickup_pallets);
1697:

Line 1698: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =

1694: AND((p_stop_rec.dropoff_pallets+p_stop_rec.pickup_pallets)>0))
1695: THEN
1696: x_fraction:=p_dleg_rec.pallets/(p_stop_rec.dropoff_pallets+p_stop_rec.pickup_pallets);
1697:
1698: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =
1699: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1700: THEN
1701: --Step 3 of the CA algorithm
1702:

Line 1699: FTE_RTG_GLOBALS.G_FLAT_BASIS))

1695: THEN
1696: x_fraction:=p_dleg_rec.pallets/(p_stop_rec.dropoff_pallets+p_stop_rec.pickup_pallets);
1697:
1698: ELSIF ((p_basis = FTE_RTG_GLOBALS.G_TIME_BASIS) OR (p_basis =
1699: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1700: THEN
1701: --Step 3 of the CA algorithm
1702:
1703: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

Line 1703: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

1699: FTE_RTG_GLOBALS.G_FLAT_BASIS))
1700: THEN
1701: --Step 3 of the CA algorithm
1702:
1703: IF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
1704: AND((p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight)>0))
1705: THEN
1706: x_fraction:=p_dleg_rec.weight/(p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight);
1707:

Line 1708: ELSIF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

1704: AND((p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight)>0))
1705: THEN
1706: x_fraction:=p_dleg_rec.weight/(p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight);
1707:
1708: ELSIF((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
1709: AND((p_stop_rec.dropoff_volume+p_stop_rec.pickup_volume)>0))
1710: THEN
1711:
1712: x_fraction:=p_dleg_rec.volume/(p_stop_rec.dropoff_volume+p_stop_rec.pickup_volume);

Line 1855: IF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP) AND

1851:
1852: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1853: x_dleg_alloc_rec.stop_off_chrg:=0;
1854:
1855: IF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP) AND
1856: (p_pickup_stop_rec.pickup_weight>0))
1857: THEN
1858: IF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
1859: AND(p_pickup_stop_rec.pickup_weight>0))

Line 1858: IF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

1854:
1855: IF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP) AND
1856: (p_pickup_stop_rec.pickup_weight>0))
1857: THEN
1858: IF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
1859: AND(p_pickup_stop_rec.pickup_weight>0))
1860: THEN
1861: x_dleg_alloc_rec.stop_off_chrg:=
1862: p_stopoff_charge*p_dleg_rec.weight/

Line 1864: ELSIF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

1860: THEN
1861: x_dleg_alloc_rec.stop_off_chrg:=
1862: p_stopoff_charge*p_dleg_rec.weight/
1863: p_pickup_stop_rec.pickup_weight;
1864: ELSIF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
1865: AND(p_pickup_stop_rec.pickup_volume>0))
1866: THEN
1867: x_dleg_alloc_rec.stop_off_chrg:=
1868: p_stopoff_charge*p_dleg_rec.volume/

Line 1873: ELSIF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP) AND

1869: p_pickup_stop_rec.pickup_volume;
1870:
1871: END IF;
1872:
1873: ELSIF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP) AND
1874: (p_dropoff_stop_rec.dropoff_weight>0))
1875: THEN
1876: IF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
1877: AND(p_dropoff_stop_rec.dropoff_weight>0))

Line 1876: IF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

1872:
1873: ELSIF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP) AND
1874: (p_dropoff_stop_rec.dropoff_weight>0))
1875: THEN
1876: IF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
1877: AND(p_dropoff_stop_rec.dropoff_weight>0))
1878: THEN
1879: x_dleg_alloc_rec.stop_off_chrg:=
1880: p_stopoff_charge*p_dleg_rec.weight/

Line 1882: ELSIF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

1878: THEN
1879: x_dleg_alloc_rec.stop_off_chrg:=
1880: p_stopoff_charge*p_dleg_rec.weight/
1881: p_dropoff_stop_rec.dropoff_weight;
1882: ELSIF ((p_alloc_params.principal_alloc_basis=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
1883: AND(p_dropoff_stop_rec.dropoff_volume>0))
1884: THEN
1885: x_dleg_alloc_rec.stop_off_chrg:=
1886: p_stopoff_charge*p_dleg_rec.volume/

Line 1948: IF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP) AND

1944: l_cache_index:=p_stop_input_hash(p_stop_charges_tab(i).stop_id);
1945:
1946: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,' cache index'||l_cache_index);
1947:
1948: IF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP) AND
1949: (FTE_TL_CACHE.g_tl_trip_stop_rows(l_cache_index).pickup_weight>
1950: 0))
1951: THEN
1952:

Line 1956: ELSIF((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP)

1952:
1953: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,' Pickup');
1954: l_stop_count:=l_stop_count+1;
1955:
1956: ELSIF((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP)
1957: AND
1958: (FTE_TL_CACHE.g_tl_trip_stop_rows(l_cache_index).dropoff_weight>
1959: 0))
1960: THEN

Line 2019: FTE_RTG_GLOBALS.G_WEIGHT_BASIS )

2015:
2016: l_factor:=0;
2017:
2018: IF ((p_trip_rec_charges.handling_chrg_basis =
2019: FTE_RTG_GLOBALS.G_WEIGHT_BASIS )
2020: AND(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_weight>0))
2021: THEN
2022: l_factor:=p_dleg_row.weight/
2023: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_weight;

Line 2026: FTE_RTG_GLOBALS.G_VOLUME_BASIS)

2022: l_factor:=p_dleg_row.weight/
2023: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_weight;
2024:
2025: ELSIF((p_trip_rec_charges.handling_chrg_basis =
2026: FTE_RTG_GLOBALS.G_VOLUME_BASIS)
2027: AND(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_volume>0))
2028: THEN
2029: l_factor:=p_dleg_row.volume/
2030: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_volume;

Line 2034: FTE_RTG_GLOBALS.G_CONTAINER_BASIS)

2030: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_volume;
2031:
2032:
2033: ELSIF((p_trip_rec_charges.handling_chrg_basis =
2034: FTE_RTG_GLOBALS.G_CONTAINER_BASIS)
2035: AND(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).number_of_containers>0))
2036: THEN
2037: l_factor:=p_dleg_row.containers/
2038: FTE_TL_CACHE.g_tl_trip_rows(

Line 2042: FTE_RTG_GLOBALS.G_PALLET_BASIS)

2038: FTE_TL_CACHE.g_tl_trip_rows(
2039: p_trip_index).number_of_containers;
2040:
2041: ELSIF((p_trip_rec_charges.handling_chrg_basis =
2042: FTE_RTG_GLOBALS.G_PALLET_BASIS)
2043: AND(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).number_of_pallets>0))
2044: THEN
2045: l_factor:=p_dleg_row.pallets/
2046: FTE_TL_CACHE.g_tl_trip_rows(

Line 2049: ELSIF (p_trip_rec_charges.handling_chrg_basis = FTE_RTG_GLOBALS.G_FLAT_BASIS)

2045: l_factor:=p_dleg_row.pallets/
2046: FTE_TL_CACHE.g_tl_trip_rows(
2047: p_trip_index).number_of_pallets;
2048:
2049: ELSIF (p_trip_rec_charges.handling_chrg_basis = FTE_RTG_GLOBALS.G_FLAT_BASIS)
2050: THEN
2051: IF ((p_cost_allocation_parameters.principal_alloc_basis =
2052: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
2053: AND(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_weight>0))

Line 2052: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

2048:
2049: ELSIF (p_trip_rec_charges.handling_chrg_basis = FTE_RTG_GLOBALS.G_FLAT_BASIS)
2050: THEN
2051: IF ((p_cost_allocation_parameters.principal_alloc_basis =
2052: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
2053: AND(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_weight>0))
2054: THEN
2055: l_factor:=p_dleg_row.weight/
2056: FTE_TL_CACHE.g_tl_trip_rows(

Line 2060: FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

2056: FTE_TL_CACHE.g_tl_trip_rows(
2057: p_trip_index).total_weight;
2058:
2059: ELSIF((p_cost_allocation_parameters.principal_alloc_basis =
2060: FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
2061: AND(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).total_volume>0))
2062: THEN
2063: l_factor:=p_dleg_row.volume/
2064: FTE_TL_CACHE.g_tl_trip_rows(

Line 2638: p_basis=> FTE_RTG_GLOBALS.G_FLAT_BASIS,

2634:
2635: Get_Loading_Fraction(
2636: p_dleg_rec=> FTE_TL_CACHE.g_tl_delivery_leg_rows(i),
2637: p_stop_rec=> FTE_TL_CACHE.g_tl_trip_stop_rows(l_pickup_stop_ip_index),
2638: p_basis=> FTE_RTG_GLOBALS.G_FLAT_BASIS,
2639: p_alloc_params=> p_cost_allocation_parameters,
2640: x_fraction=> l_fraction,
2641: x_return_status => l_return_status);
2642:

Line 2667: p_basis=> FTE_RTG_GLOBALS.G_FLAT_BASIS,

2663:
2664: Get_Unloading_Fraction(
2665: p_dleg_rec=> FTE_TL_CACHE.g_tl_delivery_leg_rows(i),
2666: p_stop_rec=> FTE_TL_CACHE.g_tl_trip_stop_rows(l_dropoff_stop_ip_index),
2667: p_basis=> FTE_RTG_GLOBALS.G_FLAT_BASIS,
2668: p_alloc_params=> p_cost_allocation_parameters,
2669: x_fraction=> l_fraction,
2670: x_return_status => l_return_status);
2671:

Line 3160: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

3156:
3157: l_factor:=0;
3158:
3159: IF(p_cost_allocation_parameters.principal_alloc_basis=
3160: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
3161: THEN
3162: IF (FTE_TL_CACHE.g_tl_delivery_leg_rows(l_parent_dleg_index).children_weight > 0)
3163: THEN
3164: l_factor:=FTE_TL_CACHE.g_tl_chld_delivery_leg_rows(i).weight/

Line 3169: FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

3165: FTE_TL_CACHE.g_tl_delivery_leg_rows(l_parent_dleg_index).children_weight;
3166: END IF;
3167:
3168: ELSIF(p_cost_allocation_parameters.principal_alloc_basis=
3169: FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
3170: THEN
3171: IF (FTE_TL_CACHE.g_tl_delivery_leg_rows(l_parent_dleg_index).children_volume > 0)
3172: THEN
3173: l_factor:=FTE_TL_CACHE.g_tl_chld_delivery_leg_rows(i).volume/

Line 3433: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

3429: (FTE_TL_CACHE.g_tl_delivery_leg_rows(i).trip_id=
3430: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id) AND (i < l_dleg_index_last))
3431: LOOP
3432: IF(p_cost_allocation_parameters.principal_alloc_basis=
3433: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
3434: THEN
3435: l_value:=FTE_TL_CACHE.g_tl_delivery_leg_rows(i).weight;
3436:
3437: ELSIF(p_cost_allocation_parameters.principal_alloc_basis=

Line 3438: FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

3434: THEN
3435: l_value:=FTE_TL_CACHE.g_tl_delivery_leg_rows(i).weight;
3436:
3437: ELSIF(p_cost_allocation_parameters.principal_alloc_basis=
3438: FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
3439: THEN
3440: l_value:=FTE_TL_CACHE.g_tl_delivery_leg_rows(i).volume;
3441:
3442: END IF;

Line 3445: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE)

3441:
3442: END IF;
3443:
3444: IF(p_cost_allocation_parameters.distance_alloc_method=
3445: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE)
3446: THEN
3447: l_distance:=
3448: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).direct_distance;
3449:

Line 3451: FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE)

3447: l_distance:=
3448: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).direct_distance;
3449:
3450: ELSIF(p_cost_allocation_parameters.distance_alloc_method=
3451: FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE)
3452: THEN
3453: l_distance:=
3454: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).distance;
3455:

Line 3478: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

3474: (FTE_TL_CACHE.g_tl_delivery_leg_rows(i).trip_id=
3475: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id) AND i < l_dleg_index_last)
3476: LOOP
3477: IF(p_cost_allocation_parameters.principal_alloc_basis=
3478: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
3479: THEN
3480: l_value:=
3481: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).weight;
3482:

Line 3484: =FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

3480: l_value:=
3481: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).weight;
3482:
3483: ELSIF(p_cost_allocation_parameters.principal_alloc_basis
3484: =FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
3485: THEN
3486:
3487: l_value:=
3488: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).volume;

Line 3495: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE)

3491:
3492: END IF;
3493:
3494: IF(p_cost_allocation_parameters.distance_alloc_method=
3495: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE)
3496: THEN
3497: l_distance:=
3498: FTE_TL_CACHE.g_tl_delivery_leg_rows(i
3499: ).direct_distance;

Line 3502: =FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE)

3498: FTE_TL_CACHE.g_tl_delivery_leg_rows(i
3499: ).direct_distance;
3500:
3501: ELSIF(p_cost_allocation_parameters.distance_alloc_method
3502: =FTE_RTG_GLOBALS.G_CA_TOTAL_DISTANCE)
3503: THEN
3504:
3505: l_distance:=
3506: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).distance;

Line 4629: IF(FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_WEIGHT_BASIS

4625:
4626:
4627: --base_unit_chrg
4628:
4629: IF(FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_WEIGHT_BASIS
4630: )
4631: THEN
4632: l_unit_freight_code:=
4633: g_tl_freight_codes(C_UNIT_WEIGHT_RT).fte_summary_code_id;

Line 4636: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_VOLUME_BASIS)

4632: l_unit_freight_code:=
4633: g_tl_freight_codes(C_UNIT_WEIGHT_RT).fte_summary_code_id;
4634:
4635: ELSIF
4636: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_VOLUME_BASIS)
4637: THEN
4638: l_unit_freight_code:=
4639: g_tl_freight_codes(C_UNIT_VOLUME_RT).fte_summary_code_id;
4640:

Line 4642: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_CONTAINER_BASIS)

4638: l_unit_freight_code:=
4639: g_tl_freight_codes(C_UNIT_VOLUME_RT).fte_summary_code_id;
4640:
4641: ELSIF
4642: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_CONTAINER_BASIS)
4643: THEN
4644: l_unit_freight_code:=
4645: g_tl_freight_codes(C_UNIT_CONTAINER_RT).fte_summary_code_id;
4646:

Line 4648: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_PALLET_BASIS)

4644: l_unit_freight_code:=
4645: g_tl_freight_codes(C_UNIT_CONTAINER_RT).fte_summary_code_id;
4646:
4647: ELSIF
4648: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_PALLET_BASIS)
4649: THEN
4650: l_unit_freight_code:=
4651: g_tl_freight_codes(C_UNIT_PALLET_RT).fte_summary_code_id;
4652:

Line 5641: IF(FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_WEIGHT_BASIS

5637:
5638:
5639: --base_unit_chrg
5640:
5641: IF(FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_WEIGHT_BASIS
5642: )
5643: THEN
5644: l_unit_freight_code:=
5645: g_tl_freight_codes(C_UNIT_WEIGHT_RT).fte_price_code_id;

Line 5648: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_VOLUME_BASIS)

5644: l_unit_freight_code:=
5645: g_tl_freight_codes(C_UNIT_WEIGHT_RT).fte_price_code_id;
5646:
5647: ELSIF
5648: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_VOLUME_BASIS)
5649: THEN
5650: l_unit_freight_code:=
5651: g_tl_freight_codes(C_UNIT_VOLUME_RT).fte_price_code_id;
5652:

Line 5654: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_CONTAINER_BASIS)

5650: l_unit_freight_code:=
5651: g_tl_freight_codes(C_UNIT_VOLUME_RT).fte_price_code_id;
5652:
5653: ELSIF
5654: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_CONTAINER_BASIS)
5655: THEN
5656: l_unit_freight_code:=
5657: g_tl_freight_codes(C_UNIT_CONTAINER_RT).fte_price_code_id;
5658:

Line 5660: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_PALLET_BASIS)

5656: l_unit_freight_code:=
5657: g_tl_freight_codes(C_UNIT_CONTAINER_RT).fte_price_code_id;
5658:
5659: ELSIF
5660: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_PALLET_BASIS)
5661: THEN
5662: l_unit_freight_code:=
5663: g_tl_freight_codes(C_UNIT_PALLET_RT).fte_price_code_id;
5664:

Line 6444: IF(FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_WEIGHT_BASIS

6440: --base_unit_chrg
6441:
6442:
6443:
6444: IF(FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_WEIGHT_BASIS
6445: )
6446: THEN
6447: l_unit_freight_code:=
6448: g_tl_freight_codes(C_UNIT_WEIGHT_RT).fte_price_code_id;

Line 6458: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_VOLUME_BASIS)

6454: l_billable_quantity:=p_dim_weight;
6455: END IF;
6456:
6457: ELSIF
6458: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_VOLUME_BASIS)
6459: THEN
6460: l_unit_freight_code:=
6461: g_tl_freight_codes(C_UNIT_VOLUME_RT).fte_price_code_id;
6462:

Line 6469: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_CONTAINER_BASIS)

6465: --l_billable_quantity:=p_volume;
6466:
6467:
6468: ELSIF
6469: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_CONTAINER_BASIS)
6470: THEN
6471: l_unit_freight_code:=
6472: g_tl_freight_codes(C_UNIT_CONTAINER_RT).fte_price_code_id;
6473:

Line 6482: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_PALLET_BASIS)

6478:
6479:
6480:
6481: ELSIF
6482: (FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).unit_basis=FTE_RTG_GLOBALS.G_CARRIER_PALLET_BASIS)
6483: THEN
6484: l_unit_freight_code:=
6485: g_tl_freight_codes(C_UNIT_PALLET_RT).fte_price_code_id;
6486:

Line 7499: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

7495: LOOP
7496: l_dim_weight:=NULL;
7497:
7498: IF((p_cost_allocation_parameters.principal_alloc_basis=
7499: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
7500: AND(FTE_TL_CACHE.g_tl_delivery_leg_rows(i).weight>0))
7501: THEN
7502:
7503: l_quantity:=

Line 7573: =FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

7569: FTE_TL_CACHE.g_tl_delivery_leg_rows(i).weight;
7570:
7571: ELSIF((
7572: p_cost_allocation_parameters.principal_alloc_basis
7573: =FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
7574: AND(FTE_TL_CACHE.g_tl_delivery_leg_rows(i).volume>0))
7575: THEN
7576:
7577: l_quantity:=

Line 7730: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)

7726: LOOP
7727: l_dim_weight:=NULL;
7728:
7729: IF((p_cost_allocation_parameters.principal_alloc_basis=
7730: FTE_RTG_GLOBALS.G_CA_WEIGHT_BASIS)
7731: AND(FTE_TL_CACHE.g_tl_chld_delivery_leg_rows(i).weight>0))
7732: THEN
7733:
7734: l_quantity:=

Line 7804: =FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)

7800: FTE_TL_CACHE.g_tl_chld_delivery_leg_rows(i).weight;
7801:
7802: ELSIF((
7803: p_cost_allocation_parameters.principal_alloc_basis
7804: =FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS)
7805: AND(FTE_TL_CACHE.g_tl_chld_delivery_leg_rows(i).volume>0))
7806: THEN
7807:
7808: l_quantity:=

Line 8473: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8469: l_trip_charges_rec.out_of_route_chrg:=50;
8470: l_trip_charges_rec.document_chrg:=0;
8471: l_trip_charges_rec.handling_chrg:=130;
8472: l_trip_charges_rec.handling_chrg_basis:=
8473: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8474: l_trip_charges_rec.cm_discount_percent:=0;
8475: l_trip_charges_rec.cm_discount_value:=0;
8476: l_trip_charges_rec.currency:='USD';
8477: l_trip_charges_rec.total_trip_rate:=555;

Line 8485: l_stop_charges_rec.loading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8481: l_stop_charges_rec.trip_id:=1117828;
8482: l_stop_charges_rec.weekday_layover_chrg:=0;
8483: l_stop_charges_rec.weekend_layover_chrg:=0;
8484: l_stop_charges_rec.loading_chrg:=0;
8485: l_stop_charges_rec.loading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8486: l_stop_charges_rec.ast_loading_chrg:=0;
8487: l_stop_charges_rec.ast_loading_chrg_basis:=
8488: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8489: l_stop_charges_rec.unloading_chrg:=0;

Line 8488: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8484: l_stop_charges_rec.loading_chrg:=0;
8485: l_stop_charges_rec.loading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8486: l_stop_charges_rec.ast_loading_chrg:=0;
8487: l_stop_charges_rec.ast_loading_chrg_basis:=
8488: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8489: l_stop_charges_rec.unloading_chrg:=0;
8490: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8491: l_stop_charges_rec.ast_unloading_chrg:=0;
8492: l_stop_charges_rec.ast_unloading_chrg_basis:=

Line 8490: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8486: l_stop_charges_rec.ast_loading_chrg:=0;
8487: l_stop_charges_rec.ast_loading_chrg_basis:=
8488: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8489: l_stop_charges_rec.unloading_chrg:=0;
8490: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8491: l_stop_charges_rec.ast_unloading_chrg:=0;
8492: l_stop_charges_rec.ast_unloading_chrg_basis:=
8493: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8494: l_stop_charges_rec.origin_surchrg:=120;

Line 8493: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8489: l_stop_charges_rec.unloading_chrg:=0;
8490: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8491: l_stop_charges_rec.ast_unloading_chrg:=0;
8492: l_stop_charges_rec.ast_unloading_chrg_basis:=
8493: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8494: l_stop_charges_rec.origin_surchrg:=120;
8495: l_stop_charges_rec.destination_surchrg:=0;
8496: l_stop_charges_rec.fac_loading_chrg:=50;
8497: l_stop_charges_rec.fac_loading_chrg_basis:=

Line 8498: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8494: l_stop_charges_rec.origin_surchrg:=120;
8495: l_stop_charges_rec.destination_surchrg:=0;
8496: l_stop_charges_rec.fac_loading_chrg:=50;
8497: l_stop_charges_rec.fac_loading_chrg_basis:=
8498: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8499: l_stop_charges_rec.fac_ast_loading_chrg:=0;
8500: l_stop_charges_rec.fac_ast_loading_chrg_basis:=
8501: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8502: l_stop_charges_rec.fac_unloading_chrg:=0;

Line 8501: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8497: l_stop_charges_rec.fac_loading_chrg_basis:=
8498: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8499: l_stop_charges_rec.fac_ast_loading_chrg:=0;
8500: l_stop_charges_rec.fac_ast_loading_chrg_basis:=
8501: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8502: l_stop_charges_rec.fac_unloading_chrg:=0;
8503: l_stop_charges_rec.fac_unloading_chrg_basis:=
8504: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8505: l_stop_charges_rec.fac_ast_unloading_chrg:=0;

Line 8504: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8500: l_stop_charges_rec.fac_ast_loading_chrg_basis:=
8501: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8502: l_stop_charges_rec.fac_unloading_chrg:=0;
8503: l_stop_charges_rec.fac_unloading_chrg_basis:=
8504: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8505: l_stop_charges_rec.fac_ast_unloading_chrg:=0;
8506: l_stop_charges_rec.fac_ast_unloading_chrg_basis:=
8507: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8508: l_stop_charges_rec.fac_handling_chrg:=0;

Line 8507: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8503: l_stop_charges_rec.fac_unloading_chrg_basis:=
8504: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8505: l_stop_charges_rec.fac_ast_unloading_chrg:=0;
8506: l_stop_charges_rec.fac_ast_unloading_chrg_basis:=
8507: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8508: l_stop_charges_rec.fac_handling_chrg:=0;
8509: l_stop_charges_rec.fac_handling_chrg_basis:=
8510: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8511: l_stop_charges_rec.fac_currency:='USD';

Line 8510: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8506: l_stop_charges_rec.fac_ast_unloading_chrg_basis:=
8507: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8508: l_stop_charges_rec.fac_handling_chrg:=0;
8509: l_stop_charges_rec.fac_handling_chrg_basis:=
8510: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8511: l_stop_charges_rec.fac_currency:='USD';
8512:
8513: l_stop_charges_tab(1):=l_stop_charges_rec;
8514:

Line 8521: l_stop_charges_rec.loading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8517: l_stop_charges_rec.trip_id:=1117828;
8518: l_stop_charges_rec.weekday_layover_chrg:=330;
8519: l_stop_charges_rec.weekend_layover_chrg:=10;
8520: l_stop_charges_rec.loading_chrg:=0;
8521: l_stop_charges_rec.loading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8522: l_stop_charges_rec.ast_loading_chrg:=0;
8523: l_stop_charges_rec.ast_loading_chrg_basis:=
8524: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8525: l_stop_charges_rec.unloading_chrg:=0;

Line 8524: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8520: l_stop_charges_rec.loading_chrg:=0;
8521: l_stop_charges_rec.loading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8522: l_stop_charges_rec.ast_loading_chrg:=0;
8523: l_stop_charges_rec.ast_loading_chrg_basis:=
8524: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8525: l_stop_charges_rec.unloading_chrg:=0;
8526: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8527: l_stop_charges_rec.ast_unloading_chrg:=25;
8528: l_stop_charges_rec.ast_unloading_chrg_basis:=

Line 8526: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8522: l_stop_charges_rec.ast_loading_chrg:=0;
8523: l_stop_charges_rec.ast_loading_chrg_basis:=
8524: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8525: l_stop_charges_rec.unloading_chrg:=0;
8526: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8527: l_stop_charges_rec.ast_unloading_chrg:=25;
8528: l_stop_charges_rec.ast_unloading_chrg_basis:=
8529: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8530: l_stop_charges_rec.origin_surchrg:=0;

Line 8529: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8525: l_stop_charges_rec.unloading_chrg:=0;
8526: l_stop_charges_rec.unloading_chrg_basis:=FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8527: l_stop_charges_rec.ast_unloading_chrg:=25;
8528: l_stop_charges_rec.ast_unloading_chrg_basis:=
8529: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8530: l_stop_charges_rec.origin_surchrg:=0;
8531: l_stop_charges_rec.destination_surchrg:=0;
8532: l_stop_charges_rec.fac_loading_chrg:=0;
8533: l_stop_charges_rec.fac_loading_chrg_basis:=

Line 8534: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8530: l_stop_charges_rec.origin_surchrg:=0;
8531: l_stop_charges_rec.destination_surchrg:=0;
8532: l_stop_charges_rec.fac_loading_chrg:=0;
8533: l_stop_charges_rec.fac_loading_chrg_basis:=
8534: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8535: l_stop_charges_rec.fac_ast_loading_chrg:=0;
8536: l_stop_charges_rec.fac_ast_loading_chrg_basis:=
8537: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8538: l_stop_charges_rec.fac_unloading_chrg:=55;

Line 8537: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8533: l_stop_charges_rec.fac_loading_chrg_basis:=
8534: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8535: l_stop_charges_rec.fac_ast_loading_chrg:=0;
8536: l_stop_charges_rec.fac_ast_loading_chrg_basis:=
8537: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8538: l_stop_charges_rec.fac_unloading_chrg:=55;
8539: l_stop_charges_rec.fac_unloading_chrg_basis:=
8540: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8541: l_stop_charges_rec.fac_ast_unloading_chrg:=0;

Line 8540: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8536: l_stop_charges_rec.fac_ast_loading_chrg_basis:=
8537: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8538: l_stop_charges_rec.fac_unloading_chrg:=55;
8539: l_stop_charges_rec.fac_unloading_chrg_basis:=
8540: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8541: l_stop_charges_rec.fac_ast_unloading_chrg:=0;
8542: l_stop_charges_rec.fac_ast_unloading_chrg_basis:=
8543: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8544: l_stop_charges_rec.fac_handling_chrg:=75;

Line 8543: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8539: l_stop_charges_rec.fac_unloading_chrg_basis:=
8540: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8541: l_stop_charges_rec.fac_ast_unloading_chrg:=0;
8542: l_stop_charges_rec.fac_ast_unloading_chrg_basis:=
8543: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8544: l_stop_charges_rec.fac_handling_chrg:=75;
8545: l_stop_charges_rec.fac_handling_chrg_basis:=
8546: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8547: l_stop_charges_rec.fac_currency:='USD';

Line 8546: FTE_RTG_GLOBALS.G_VOLUME_BASIS;

8542: l_stop_charges_rec.fac_ast_unloading_chrg_basis:=
8543: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8544: l_stop_charges_rec.fac_handling_chrg:=75;
8545: l_stop_charges_rec.fac_handling_chrg_basis:=
8546: FTE_RTG_GLOBALS.G_VOLUME_BASIS;
8547: l_stop_charges_rec.fac_currency:='USD';
8548:
8549: l_stop_charges_tab(2):=l_stop_charges_rec;
8550:

Line 8555: l_cost_allocation_parameters.principal_alloc_basis:=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS;

8551:
8552:
8553:
8554:
8555: l_cost_allocation_parameters.principal_alloc_basis:=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS;
8556: l_cost_allocation_parameters.distance_alloc_method:=
8557: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE;
8558: l_cost_allocation_parameters.tl_stop_alloc_method:=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP;
8559: l_cost_allocation_parameters.output_type:='T';

Line 8557: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE;

8553:
8554:
8555: l_cost_allocation_parameters.principal_alloc_basis:=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS;
8556: l_cost_allocation_parameters.distance_alloc_method:=
8557: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE;
8558: l_cost_allocation_parameters.tl_stop_alloc_method:=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP;
8559: l_cost_allocation_parameters.output_type:='T';
8560: l_cost_allocation_parameters.comparison_request_id:=101101;
8561:

Line 8558: l_cost_allocation_parameters.tl_stop_alloc_method:=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP;

8554:
8555: l_cost_allocation_parameters.principal_alloc_basis:=FTE_RTG_GLOBALS.G_CA_VOLUME_BASIS;
8556: l_cost_allocation_parameters.distance_alloc_method:=
8557: FTE_RTG_GLOBALS.G_CA_DIRECT_DISTANCE;
8558: l_cost_allocation_parameters.tl_stop_alloc_method:=FTE_RTG_GLOBALS.G_CA_DELIVERY_STOP;
8559: l_cost_allocation_parameters.output_type:='T';
8560: l_cost_allocation_parameters.comparison_request_id:=101101;
8561:
8562: