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_FREIGHT_RATING_PUB dependencies on FTE_PROCESS_REQUESTS

Line 103: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

99:
100: END convert_amount;
101:
102: PROCEDURE print_rates_tab (
103: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
104: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
105: x_return_status OUT NOCOPY VARCHAR2)
106: IS
107: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;

Line 104: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

100: END convert_amount;
101:
102: PROCEDURE print_rates_tab (
103: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
104: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
105: x_return_status OUT NOCOPY VARCHAR2)
106: IS
107: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
108: l_api_name VARCHAR2(50) := 'print_rates_tab';

Line 239: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

235: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
236: END print_matched_services;
237:
238: PROCEDURE print_source_line_tab (
239: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
240: x_return_status OUT NOCOPY VARCHAR2)
241: IS
242: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
243: l_api_name VARCHAR2(50) := 'print_source_line_tab';

Line 334: p_source_header_tab IN FTE_PROCESS_REQUESTS.fte_source_header_tab,

330: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
331: END print_source_line_tab;
332:
333: PROCEDURE print_source_header_tab (
334: p_source_header_tab IN FTE_PROCESS_REQUESTS.fte_source_header_tab,
335: x_return_status OUT NOCOPY VARCHAR2)
336: IS
337: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
338: l_api_name VARCHAR2(50) := 'print_source_header_tab';

Line 416: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,

412:
413: END print_source_header_tab;
414:
415: PROCEDURE populate_rate (
416: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
417: p_service_rec IN lane_info_rec_type,
418: p_lane_rate IN NUMBER,
419: p_lane_rate_uom IN VARCHAR2,
420: p_fc_temp_price IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,

Line 422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

418: p_lane_rate IN NUMBER,
419: p_lane_rate_uom IN VARCHAR2,
420: p_fc_temp_price IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
421: p_fc_temp_charge IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
423: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
424: x_return_status OUT NOCOPY VARCHAR2)
425: IS
426: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;

Line 423: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

419: p_lane_rate_uom IN VARCHAR2,
420: p_fc_temp_price IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
421: p_fc_temp_charge IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
423: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
424: x_return_status OUT NOCOPY VARCHAR2)
425: IS
426: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
427: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_RATE';

Line 737: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,

733: -- No currency conversions
734: -- No sorting of rates
735:
736: PROCEDURE populate_rate_2 (
737: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
738: p_service_rec IN lane_info_rec_type,
739: p_lane_rate IN NUMBER,
740: p_lane_rate_uom IN VARCHAR2,
741: p_fc_temp_price IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,

Line 743: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

739: p_lane_rate IN NUMBER,
740: p_lane_rate_uom IN VARCHAR2,
741: p_fc_temp_price IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
742: p_fc_temp_charge IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
743: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
744: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
745: x_return_status OUT NOCOPY VARCHAR2)
746: IS
747: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;

Line 744: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

740: p_lane_rate_uom IN VARCHAR2,
741: p_fc_temp_price IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
742: p_fc_temp_charge IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
743: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
744: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
745: x_return_status OUT NOCOPY VARCHAR2)
746: IS
747: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
748: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_RATE_2';

Line 912: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,

908: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
909: END populate_rate_2;
910:
911: PROCEDURE populate_shipment(
912: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
913: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
914: x_return_status OUT NOCOPY VARCHAR2)
915: IS
916: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;

Line 913: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

909: END populate_rate_2;
910:
911: PROCEDURE populate_shipment(
912: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
913: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
914: x_return_status OUT NOCOPY VARCHAR2)
915: IS
916: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
917: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SHIPMENT';

Line 1019: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,

1015: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1016: END populate_shipment;
1017:
1018: PROCEDURE Search_Services(
1019: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
1020: p_ignore_TL IN VARCHAR2 DEFAULT 'Y', -- FTE J estimate rate
1021: p_filter_shipmethod IN VARCHAR2 DEFAULT 'Y', -- FTE J estimate rate
1022: x_matched_services OUT NOCOPY lane_info_tab_type,
1023: x_return_status OUT NOCOPY VARCHAR2)

Line 1419: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

1415: END Search_Services;
1416:
1417:
1418: PROCEDURE Append_Rates(
1419: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1420: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1421: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1423: x_return_status OUT NOCOPY Varchar2)

Line 1420: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

1416:
1417:
1418: PROCEDURE Append_Rates(
1419: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1420: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1421: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1423: x_return_status OUT NOCOPY Varchar2)
1424:

Line 1421: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

1417:
1418: PROCEDURE Append_Rates(
1419: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1420: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1421: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1423: x_return_status OUT NOCOPY Varchar2)
1424:
1425: IS

Line 1422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

1418: PROCEDURE Append_Rates(
1419: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1420: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1421: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1422: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1423: x_return_status OUT NOCOPY Varchar2)
1424:
1425: IS
1426:

Line 1517: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

1513:
1514:
1515: PROCEDURE Sort_Source_Rates(
1516: P_LCSS_flag IN VARCHAR2,
1517: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1518: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1519: x_return_status OUT NOCOPY Varchar2)
1520: IS
1521:

Line 1518: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

1514:
1515: PROCEDURE Sort_Source_Rates(
1516: P_LCSS_flag IN VARCHAR2,
1517: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1518: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1519: x_return_status OUT NOCOPY Varchar2)
1520: IS
1521:
1522: l_values_tab FTE_TRIP_RATING_GRP.Sort_Value_Tab_Type;

Line 1528: l_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;

1524: j NUMBER;
1525: l_value_rec FTE_TRIP_RATING_GRP.Sort_Value_Rec_Type;
1526: l_value dbms_utility.number_array;
1527: l_sorted_index dbms_utility.number_array;
1528: l_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
1529:
1530: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1531: l_api_name CONSTANT VARCHAR2(30) := 'Sort_Source_Rates';
1532: l_return_status VARCHAR2(1);

Line 1605: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,

1601:
1602:
1603: PROCEDURE OM_TL_Rate(
1604: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
1605: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
1606: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
1607: p_LCSS_flag IN VARCHAR2,
1608: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1609: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

Line 1606: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

1602:
1603: PROCEDURE OM_TL_Rate(
1604: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
1605: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
1606: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
1607: p_LCSS_flag IN VARCHAR2,
1608: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1609: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1610: x_return_status OUT NOCOPY Varchar2)

Line 1608: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

1604: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
1605: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
1606: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
1607: p_LCSS_flag IN VARCHAR2,
1608: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1609: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1610: x_return_status OUT NOCOPY Varchar2)
1611: IS
1612:

Line 1609: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

1605: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
1606: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
1607: p_LCSS_flag IN VARCHAR2,
1608: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1609: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1610: x_return_status OUT NOCOPY Varchar2)
1611: IS
1612:
1613: i NUMBER;

Line 1675: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

1671:
1672: END OM_TL_Rate;
1673:
1674: PROCEDURE Get_Services(
1675: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1676: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1677: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1678: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1679: x_return_status OUT NOCOPY VARCHAR2)

Line 1676: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

1672: END OM_TL_Rate;
1673:
1674: PROCEDURE Get_Services(
1675: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1676: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1677: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1678: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1679: x_return_status OUT NOCOPY VARCHAR2)
1680: IS

Line 1677: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

1673:
1674: PROCEDURE Get_Services(
1675: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1676: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1677: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1678: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1679: x_return_status OUT NOCOPY VARCHAR2)
1680: IS
1681: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;

Line 1678: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

1674: PROCEDURE Get_Services(
1675: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1676: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1677: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1678: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1679: x_return_status OUT NOCOPY VARCHAR2)
1680: IS
1681: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1682: l_api_name CONSTANT VARCHAR2(30) := 'GET_SERVICES';

Line 1971: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

1967:
1968: -- FTE J rate estimate -- internal API
1969:
1970: PROCEDURE Get_FTE_Estimate_Rates(
1971: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1972: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1973: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1974: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1975: x_return_status OUT NOCOPY VARCHAR2)

Line 1972: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

1968: -- FTE J rate estimate -- internal API
1969:
1970: PROCEDURE Get_FTE_Estimate_Rates(
1971: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1972: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1973: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1974: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1975: x_return_status OUT NOCOPY VARCHAR2)
1976: IS

Line 1973: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

1969:
1970: PROCEDURE Get_FTE_Estimate_Rates(
1971: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1972: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1973: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1974: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1975: x_return_status OUT NOCOPY VARCHAR2)
1976: IS
1977: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;

Line 1974: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

1970: PROCEDURE Get_FTE_Estimate_Rates(
1971: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
1972: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
1973: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
1974: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
1975: x_return_status OUT NOCOPY VARCHAR2)
1976: IS
1977: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1978: l_api_name CONSTANT VARCHAR2(30) := 'GET_FTE_ESTIMATE_RATES';

Line 2411: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

2407: PROCEDURE Get_Freight_Costs(
2408: p_api_version IN NUMBER DEFAULT 1.0,
2409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2411: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
2412: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
2413: p_source_type IN VARCHAR2,
2414: p_action IN VARCHAR2,
2415: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

Line 2412: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

2408: p_api_version IN NUMBER DEFAULT 1.0,
2409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2411: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
2412: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
2413: p_source_type IN VARCHAR2,
2414: p_action IN VARCHAR2,
2415: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
2416: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

Line 2415: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

2411: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
2412: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
2413: p_source_type IN VARCHAR2,
2414: p_action IN VARCHAR2,
2415: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
2416: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
2417: x_request_id OUT NOCOPY NUMBER,
2418: x_return_status OUT NOCOPY VARCHAR2,
2419: x_msg_count OUT NOCOPY NUMBER,

Line 2416: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

2412: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
2413: p_source_type IN VARCHAR2,
2414: p_action IN VARCHAR2,
2415: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
2416: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
2417: x_request_id OUT NOCOPY NUMBER,
2418: x_return_status OUT NOCOPY VARCHAR2,
2419: x_msg_count OUT NOCOPY NUMBER,
2420: x_msg_data OUT NOCOPY VARCHAR2)

Line 2456: l_tl_source_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;

2452: l_all_lane_failed BOOLEAN;
2453: l_converted_amount NUMBER;
2454: k NUMBER;
2455: l_lane_info_tab lane_info_tab_type;
2456: l_tl_source_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
2457: l_tl_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
2458:
2459:
2460:

Line 2457: l_tl_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;

2453: l_converted_amount NUMBER;
2454: k NUMBER;
2455: l_lane_info_tab lane_info_tab_type;
2456: l_tl_source_line_rates_tab FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
2457: l_tl_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
2458:
2459:
2460:
2461: BEGIN