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.

[Home] [Help]

APPS.WSH_FC_INTERFACE_PKG dependencies on WSH_FREIGHT_COSTS

Line 1309: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE

1305: , p_Freight_Cost_Type_Code IN VARCHAR2
1306: , p_Freight_Cost_Id IN NUMBER
1307: , p_Freight_Cost_Amount IN NUMBER
1308: , p_From_Currency_code IN VARCHAR2
1309: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1310: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1311: , p_Relevant_Info_Tab IN RelavantInfoTabType
1312: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1313: , x_return_status OUT NOCOPY VARCHAR2

Line 1310: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE

1306: , p_Freight_Cost_Id IN NUMBER
1307: , p_Freight_Cost_Amount IN NUMBER
1308: , p_From_Currency_code IN VARCHAR2
1309: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1310: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1311: , p_Relevant_Info_Tab IN RelavantInfoTabType
1312: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1313: , x_return_status OUT NOCOPY VARCHAR2
1314: )

Line 1522: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE

1518: , p_Freight_Cost_Type_Code IN VARCHAR2
1519: , p_Freight_cost_id IN NUMBER
1520: , p_Freight_Cost_Amount IN NUMBER
1521: , p_From_Currency_code IN VARCHAR2
1522: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1523: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1524: , p_Relevant_Info_Tab IN RelavantInfoTabType
1525: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1526: , x_return_status OUT NOCOPY VARCHAR2

Line 1523: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE

1519: , p_Freight_cost_id IN NUMBER
1520: , p_Freight_Cost_Amount IN NUMBER
1521: , p_From_Currency_code IN VARCHAR2
1522: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1523: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1524: , p_Relevant_Info_Tab IN RelavantInfoTabType
1525: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1526: , x_return_status OUT NOCOPY VARCHAR2
1527: )

Line 1626: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE

1622: , p_Freight_Cost_Type_Code IN VARCHAR2
1623: , p_Freight_Cost_Id IN NUMBER
1624: , p_Freight_Cost_Amount IN NUMBER
1625: , p_From_Currency_Code IN VARCHAR2
1626: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1627: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1628: , p_Relevant_Info_Tab IN RelavantInfoTabType
1629: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1630: , x_return_status OUT NOCOPY VARCHAR2

Line 1627: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE

1623: , p_Freight_Cost_Id IN NUMBER
1624: , p_Freight_Cost_Amount IN NUMBER
1625: , p_From_Currency_Code IN VARCHAR2
1626: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1627: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1628: , p_Relevant_Info_Tab IN RelavantInfoTabType
1629: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1630: , x_return_status OUT NOCOPY VARCHAR2
1631: )

Line 1840: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE

1836: , p_Freight_Cost_Type_Code IN VARCHAR2
1837: , p_Freight_Cost_Id IN NUMBER
1838: , p_Freight_Cost_Amount IN NUMBER
1839: , p_From_Currency_Code IN VARCHAR2
1840: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1841: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1842: , p_Relevant_Info_Tab IN RelavantInfoTabType
1843: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1844: , x_return_status OUT NOCOPY VARCHAR2

Line 1841: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE

1837: , p_Freight_Cost_Id IN NUMBER
1838: , p_Freight_Cost_Amount IN NUMBER
1839: , p_From_Currency_Code IN VARCHAR2
1840: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
1841: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
1842: , p_Relevant_Info_Tab IN RelavantInfoTabType
1843: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
1844: , x_return_status OUT NOCOPY VARCHAR2
1845: )

Line 2070: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE

2066: , p_Freight_Cost_Type_Code IN VARCHAR2
2067: , p_Freight_Cost_Id IN NUMBER
2068: , p_Freight_Cost_Amount IN NUMBER
2069: , p_From_Currency_Code IN VARCHAR2
2070: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
2071: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
2072: , p_Relevant_Info_Tab IN RelavantInfoTabType
2073: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
2074: , x_return_status OUT NOCOPY VARCHAR2

Line 2071: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE

2067: , p_Freight_Cost_Id IN NUMBER
2068: , p_Freight_Cost_Amount IN NUMBER
2069: , p_From_Currency_Code IN VARCHAR2
2070: , p_Conversion_Type_Code IN WSH_FREIGHT_COSTS.CONVERSION_TYPE_CODE%TYPE
2071: , p_Conversion_Rate IN WSH_FREIGHT_COSTS.CONVERSION_RATE%TYPE
2072: , p_Relevant_Info_Tab IN RelavantInfoTabType
2073: , x_Prorated_Freight_Cost IN OUT NOCOPY ProratedCostTabType
2074: , x_return_status OUT NOCOPY VARCHAR2
2075: )

Line 2562: -- bug 3455978 use the conversion_type_code from wsh_freight_costs

2558: END IF;
2559: --
2560: x_Final_Cost(j).amount := x_Final_Cost(j).amount + GL_CURRENCY_API.convert_amount(
2561: p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date, NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type), p_prorated_freight_cost(i).amount);
2562: -- bug 3455978 use the conversion_type_code from wsh_freight_costs
2563: ELSIF (p_prorated_freight_cost(i).conversion_type_code = 'User') THEN
2564: IF (p_prorated_freight_cost(i).conversion_rate IS NOT NULL) THEN
2565: --
2566: -- Debug Statements

Line 2707: -- bug 3455978 use the conversion_type_code from wsh_freight_costs

2703: l_line_currency_code,
2704: l_conversion_date,
2705: NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),
2706: p_prorated_freight_cost(i).amount);
2707: -- bug 3455978 use the conversion_type_code from wsh_freight_costs
2708: ELSIF (p_prorated_freight_cost(i).conversion_type_code = 'User') THEN
2709: IF (p_prorated_freight_cost(i).conversion_rate IS NOT NULL) THEN
2710: --
2711: -- Debug Statements

Line 2963: FROM wsh_freight_costs a,

2959: IS
2960: SELECT a.trip_id, a.freight_cost_id, a.unit_amount, a.currency_code,
2961: c.freight_cost_type_code
2962: , a.conversion_type_code, a.conversion_rate
2963: FROM wsh_freight_costs a,
2964: wsh_trip_stops b,
2965: wsh_freight_cost_types c
2966: WHERE a.trip_id = b.trip_id and
2967: b.stop_id = p_stop_id and

Line 2986: FROM wsh_freight_costs a,

2982: IS
2983: SELECT a.stop_id, a.freight_cost_id, a.unit_amount, a.currency_code,
2984: b.freight_cost_type_code
2985: , a.conversion_type_code, a.conversion_rate
2986: FROM wsh_freight_costs a,
2987: wsh_freight_cost_types b
2988: WHERE a.stop_id = p_stop_id and
2989: a.freight_cost_type_id = b.freight_cost_type_id and
2990: /* H projects: pricing integration csun

Line 3007: FROM wsh_freight_costs wfc,

3003: SELECT wnd.delivery_id, wfc.freight_cost_id,
3004: wfc.unit_amount, wfc.currency_code,
3005: wft.freight_cost_type_code
3006: , wfc.conversion_type_code, wfc.conversion_rate
3007: FROM wsh_freight_costs wfc,
3008: wsh_freight_cost_types wft,
3009: wsh_delivery_legs wdl,
3010: wsh_new_deliveries wnd,
3011: wsh_trip_stops wts

Line 3044: wsh_freight_costs wfc,

3040: wfc.conversion_type_code,
3041: wfc.conversion_rate
3042: FROM wsh_delivery_assignments_v wda,
3043: wsh_delivery_details wdd,
3044: wsh_freight_costs wfc,
3045: wsh_freight_cost_types wft,
3046: wsh_delivery_legs wdl,
3047: wsh_new_deliveries wnd,
3048: wsh_trip_stops wts

Line 3080: wsh_freight_costs wfc,

3076: , wfc.conversion_type_code, wfc.conversion_rate
3077: FROM wsh_delivery_assignments_v wda,
3078: wsh_delivery_details wdd,
3079: oe_order_lines_all ol,
3080: wsh_freight_costs wfc,
3081: wsh_freight_cost_types wft,
3082: wsh_delivery_legs wdl,
3083: wsh_new_deliveries wnd,
3084: wsh_trip_stops wts