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_RATING dependencies on WSH_FREIGHT_COSTS

Line 782: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

778: FOR UPDATE NOWAIT;
779:
780:
781: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
782: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
783: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
784: l_freight_cost_id NUMBER;
785: l_return_status VARCHAR2(1);
786: l_rowid VARCHAR2(30);

Line 783: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

779:
780:
781: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
782: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
783: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
784: l_freight_cost_id NUMBER;
785: l_return_status VARCHAR2(1);
786: l_rowid VARCHAR2(30);
787: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;

Line 913: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

909: END IF;
910:
911: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>5');
912:
913: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
914: p_rowid => l_rowid,
915: p_freight_cost_info => l_freight_rec,
916: x_return_status => l_return_status);
917:

Line 930: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

926:
927: ELSE
928: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>6');
929:
930: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
931: p_freight_cost_info => l_freight_rec,
932: x_rowid => l_rowid,
933: x_freight_cost_id => l_freight_cost_id,
934: x_return_status => l_return_status);

Line 1084: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

1080: FOR UPDATE NOWAIT;
1081:
1082:
1083: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
1084: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1085: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1086: l_freight_cost_id NUMBER;
1087: l_return_status VARCHAR2(1);
1088: l_rowid VARCHAR2(30);

Line 1085: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

1081:
1082:
1083: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
1084: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1085: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1086: l_freight_cost_id NUMBER;
1087: l_return_status VARCHAR2(1);
1088: l_rowid VARCHAR2(30);
1089: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;

Line 1281: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

1277: END IF;
1278:
1279: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>5');
1280:
1281: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
1282: p_rowid => l_rowid,
1283: p_freight_cost_info => l_freight_rec,
1284: x_return_status => l_return_status);
1285:

Line 1298: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

1294:
1295: ELSE
1296: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>6');
1297:
1298: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
1299: p_freight_cost_info => l_freight_rec,
1300: x_rowid => l_rowid,
1301: x_freight_cost_id => l_freight_cost_id,
1302: x_return_status => l_return_status);

Line 1469: FROM wsh_freight_costs wfc

1465:
1466: CURSOR lock_trip_recs(c_trip_id IN NUMBER ) IS
1467:
1468: SELECT wfc.freight_cost_id
1469: FROM wsh_freight_costs wfc
1470: WHERE wfc.trip_id = c_trip_id
1471: and wfc.charge_source_code='PRICING_ENGINE'
1472: FOR UPDATE NOWAIT;
1473:

Line 1483: FROM wsh_freight_costs wfc

1479:
1480: CURSOR lock_stop_rec(c_stop_id IN NUMBER ) IS
1481:
1482: SELECT wfc.freight_cost_id
1483: FROM wsh_freight_costs wfc
1484: WHERE wfc.stop_id =c_stop_id
1485: and wfc.charge_source_code='PRICING_ENGINE'
1486: FOR UPDATE OF wfc.freight_cost_id NOWAIT;
1487:

Line 1496: FROM wsh_freight_costs wfc,

1492: WHERE dl.pick_up_stop_id=s.stop_id and s.trip_id=p_trip_id;
1493:
1494: CURSOR lock_detail_recs(c_trip_id IN NUMBER) IS
1495: SELECT wfc.freight_cost_id
1496: FROM wsh_freight_costs wfc,
1497: wsh_delivery_legs dl ,
1498: wsh_trip_stops s
1499: WHERE wfc.delivery_leg_id = dl.delivery_leg_id
1500: and dl.pick_up_stop_id=s.stop_id

Line 1550: FROM wsh_freight_costs wfc

1546: THEN
1547:
1548: FORALL i IN l_wfc_trip_ids.FIRST..l_wfc_trip_ids.LAST
1549: DELETE
1550: FROM wsh_freight_costs wfc
1551: WHERE wfc.freight_cost_id = l_wfc_trip_ids(i);
1552: END IF;
1553:
1554:

Line 1615: FROM wsh_freight_costs wfc

1611: END LOOP;
1612:
1613: FORALL i IN l_wfc_stop_ids.FIRST..l_wfc_stop_ids.LAST
1614: DELETE
1615: FROM wsh_freight_costs wfc
1616: WHERE wfc.freight_cost_id = l_wfc_stop_ids(i) ;
1617: END IF;
1618:
1619:

Line 1647: FROM wsh_freight_costs wfc

1643:
1644:
1645: FORALL i IN l_wfc_detail_ids.FIRST..l_wfc_detail_ids.LAST
1646: DELETE
1647: FROM wsh_freight_costs wfc
1648: WHERE wfc.freight_cost_id = l_wfc_detail_ids(i)
1649: and wfc.delivery_detail_id is not null;
1650:
1651:

Line 1655: UPDATE wsh_freight_costs wfc

1651:
1652: --Clear rates for dleg recs
1653:
1654: FORALL i IN l_wfc_detail_ids.FIRST..l_wfc_detail_ids.LAST
1655: UPDATE wsh_freight_costs wfc
1656: set wfc.unit_amount=null,
1657: wfc.total_amount=null,
1658: wfc.currency_code=null
1659: WHERE wfc.freight_cost_id = l_wfc_detail_ids(i)