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_PRICING dependencies on WSH_FREIGHT_COSTS_PVT

Line 496: l_child_dtl_main_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

492: l_dtl_fraction NUMBER;
493: l_LPN_rec_index NUMBER;
494:
495: l_child_dtl_temp_rec Freight_Cost_temp_Rec_Type;
496: l_child_dtl_main_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
497: l_LPN_main_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
498: l_LPN_temp_rec Freight_Cost_Temp_Rec_Type;
499:
500: l_freight_cost_type_id NUMBER;

Line 497: l_LPN_main_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

493: l_LPN_rec_index NUMBER;
494:
495: l_child_dtl_temp_rec Freight_Cost_temp_Rec_Type;
496: l_child_dtl_main_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
497: l_LPN_main_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
498: l_LPN_temp_rec Freight_Cost_Temp_Rec_Type;
499:
500: l_freight_cost_type_id NUMBER;
501:

Line 819: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

815: i NUMBER;
816: l_parent_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;
817: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;
818: l_freight_cost_temp_price Freight_Cost_temp_Rec_Type;
819: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
820: l_return_status VARCHAR2(1);
821: l_index NUMBER;
822: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
823:

Line 991: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

987:
988: l_child_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;
989: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;
990: i NUMBER;
991: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
992: l_freight_cost_temp_price Freight_Cost_Temp_Rec_Type;
993: l_freight_cost_type_id NUMBER;
994: l_return_status VARCHAR2(1);
995: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 1237: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

1233:
1234: i NUMBER;
1235: l_LPN_summaries DBMS_UTILITY.NUMBER_ARRAY;
1236: l_existing_LPN DBMS_UTILITY.NUMBER_ARRAY;--If it is required to update existing LPN summaries
1237: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1238: l_freight_cost_temp_price Freight_Cost_temp_Rec_Type;
1239: l_freight_cost_type_id NUMBER;
1240: l_return_status VARCHAR2(1);
1241:

Line 7956: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

7952:
7953: l_fc_main_update_rows(l).last_update_date := sysdate;
7954: l_fc_main_update_rows(l).last_updated_by := FND_GLOBAL.USER_ID;
7955: l_fc_main_update_rows(l).last_update_login := FND_GLOBAL.LOGIN_ID;
7956: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
7957: p_rowid => l_rowid,
7958: p_freight_cost_info => l_fc_main_update_rows(l),
7959: x_return_status => l_return_status);
7960:

Line 8001: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

7997: 'delivery_detail_id='||l_freight_cost_main_price(m).delivery_detail_id
7998: ||' commodity_category_id ='||l_freight_cost_main_price(m).commodity_category_id);
7999: END IF;
8000:
8001: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
8002: p_freight_cost_info => l_freight_cost_main_price(m),
8003: x_rowid => l_rowid,
8004: x_freight_cost_id => l_freight_cost_id,
8005: x_return_status => l_return_status);

Line 8049: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

8045: 'delivery_detail_id='||l_freight_cost_main_charge(o).delivery_detail_id
8046: ||' commodity_category_id ='||l_freight_cost_main_charge(o).commodity_category_id);
8047: END IF;
8048:
8049: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
8050: p_freight_cost_info => l_freight_cost_main_charge(o),
8051: x_rowid => l_rowid,
8052: x_freight_cost_id => l_freight_cost_id,
8053: x_return_status => l_return_status);

Line 11131: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11127: l_return_status VARCHAR2(1);
11128: l_msg_count NUMBER := 0;
11129: l_msg_data VARCHAR2(240);
11130:
11131: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11132: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11133: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11134: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11135: l_rowid VARCHAR2(30);

Line 11132: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11128: l_msg_count NUMBER := 0;
11129: l_msg_data VARCHAR2(240);
11130:
11131: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11132: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11133: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11134: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11135: l_rowid VARCHAR2(30);
11136: l_update_rowid VARCHAR2(30);

Line 11133: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11129: l_msg_data VARCHAR2(240);
11130:
11131: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11132: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11133: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11134: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11135: l_rowid VARCHAR2(30);
11136: l_update_rowid VARCHAR2(30);
11137: l_freight_cost_id NUMBER;

Line 11230: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');

11226: l_freight_cost_main_row.DELIVERY_LEG_ID := l_freight_cost_main_row.delivery_leg_id;
11227:
11228: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_freight_cost_main_row.FREIGHT_COST_ID='||l_freight_cost_main_row.FREIGHT_COST_ID);
11229:
11230: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');
11231: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11232: p_rowid => l_update_rowid,
11233: p_freight_cost_info => l_freight_cost_main_row,
11234: x_return_status => l_return_status);

Line 11231: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

11227:
11228: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_freight_cost_main_row.FREIGHT_COST_ID='||l_freight_cost_main_row.FREIGHT_COST_ID);
11229:
11230: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');
11231: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11232: p_rowid => l_update_rowid,
11233: p_freight_cost_info => l_freight_cost_main_row,
11234: x_return_status => l_return_status);
11235:

Line 11249: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');

11245:
11246: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11247: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11248:
11249: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');
11250: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11251: p_freight_cost_info => l_freight_cost_main_row,
11252: x_rowid => l_rowid,
11253: x_freight_cost_id => l_freight_cost_id,

Line 11250: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

11246: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11247: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11248:
11249: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');
11250: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11251: p_freight_cost_info => l_freight_cost_main_row,
11252: x_rowid => l_rowid,
11253: x_freight_cost_id => l_freight_cost_id,
11254: x_return_status => l_return_status);

Line 11319: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

11315: := p_freight_cost_temp_charge(i).COMMODITY_CATEGORY_ID;
11316: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,
11317: '(FPA)l_freight_cost_main_charge.COMMODITY_CATEGORY_ID='||l_freight_cost_main_charge.COMMODITY_CATEGORY_ID);
11318:
11319: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11320: p_freight_cost_info => l_freight_cost_main_charge,
11321: x_rowid => l_rowid,
11322: x_freight_cost_id => l_freight_cost_id,
11323: x_return_status => l_return_status);

Line 11373: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11369: l_api_name CONSTANT VARCHAR2(30) := 'MOVE_FC_TEMP_TO_MAIN';
11370: l_return_status VARCHAR2(1);
11371: l_msg_count NUMBER := 0;
11372: l_msg_data VARCHAR2(240);
11373: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11374: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11375: l_rowid VARCHAR2(30);
11376: l_update_rowid VARCHAR2(30);
11377: l_freight_cost_id NUMBER;

Line 11374: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11370: l_return_status VARCHAR2(1);
11371: l_msg_count NUMBER := 0;
11372: l_msg_data VARCHAR2(240);
11373: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11374: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11375: l_rowid VARCHAR2(30);
11376: l_update_rowid VARCHAR2(30);
11377: l_freight_cost_id NUMBER;
11378:

Line 11446: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');

11442: l_freight_cost_main_row.FREIGHT_COST_ID := get_fc_id_from_dleg(l_freight_cost_main_row.delivery_leg_id);
11443:
11444: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_freight_cost_main_row.FREIGHT_COST_ID='||l_freight_cost_main_row.FREIGHT_COST_ID);
11445:
11446: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');
11447: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11448: p_rowid => l_update_rowid,
11449: p_freight_cost_info => l_freight_cost_main_row,
11450: x_return_status => l_return_status);

Line 11447: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

11443:
11444: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_freight_cost_main_row.FREIGHT_COST_ID='||l_freight_cost_main_row.FREIGHT_COST_ID);
11445:
11446: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');
11447: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11448: p_rowid => l_update_rowid,
11449: p_freight_cost_info => l_freight_cost_main_row,
11450: x_return_status => l_return_status);
11451:

Line 11465: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');

11461:
11462: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11463: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11464:
11465: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');
11466: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11467: p_freight_cost_info => l_freight_cost_main_row,
11468: x_rowid => l_rowid,
11469: x_freight_cost_id => l_freight_cost_id,

Line 11466: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

11462: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11463: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11464:
11465: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');
11466: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11467: p_freight_cost_info => l_freight_cost_main_row,
11468: x_rowid => l_rowid,
11469: x_freight_cost_id => l_freight_cost_id,
11470: x_return_status => l_return_status);

Line 11562: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11558: AND s.schedules_id = c_schedule_id;
11559:
11560: l_mode VARCHAR2(30);
11561: l_freight_cost_temp_row c_move_fc_temp%ROWTYPE;
11562: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11563: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11564: l_freight_cost_temp_charge c_move_fc_temp_charge%ROWTYPE;
11565: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11566: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;

Line 11563: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11559:
11560: l_mode VARCHAR2(30);
11561: l_freight_cost_temp_row c_move_fc_temp%ROWTYPE;
11562: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11563: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11564: l_freight_cost_temp_charge c_move_fc_temp_charge%ROWTYPE;
11565: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11566: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11567: l_rowid VARCHAR2(30);

Line 11565: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11561: l_freight_cost_temp_row c_move_fc_temp%ROWTYPE;
11562: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11563: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11564: l_freight_cost_temp_charge c_move_fc_temp_charge%ROWTYPE;
11565: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11566: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11567: l_rowid VARCHAR2(30);
11568: l_update_rowid VARCHAR2(30);
11569: l_freight_cost_id NUMBER;

Line 11696: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

11692:
11693: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11694: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11695:
11696: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11697: p_freight_cost_info => l_freight_cost_main_row,
11698: x_rowid => l_rowid,
11699: x_freight_cost_id => l_freight_cost_id,
11700: x_return_status => l_return_status);

Line 11724: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

11720:
11721: l_freight_cost_main_row.FREIGHT_COST_ID := get_fc_id_from_dleg(l_freight_cost_main_row.DELIVERY_LEG_ID);
11722: --l_freight_cost_main_row.DELIVERY_LEG_ID := p_delivery_leg_id;
11723:
11724: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11725: p_rowid => l_update_rowid,
11726: p_freight_cost_info => l_freight_cost_main_row,
11727: x_return_status => l_return_status);
11728:

Line 11795: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

11791: '(FPA)l_freight_cost_main_charge.COMMODITY_CATEGORY_ID='||l_freight_cost_main_charge.COMMODITY_CATEGORY_ID);
11792:
11793: l_freight_cost_main_charge.applied_to_charge_id := l_price_fc_ids(l_freight_cost_main_charge.delivery_detail_id);
11794:
11795: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11796: p_freight_cost_info => l_freight_cost_main_charge,
11797: x_rowid => l_rowid,
11798: x_freight_cost_id => l_freight_cost_id,
11799: x_return_status => l_return_status);

Line 11955: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11951: wsh_trip_stops s
11952: WHERE dl.pick_up_stop_id = s.stop_id
11953: and s.trip_id=c_trip_id;
11954:
11955: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11956: l_freight_cost_temp_row c_move_fc_temp%ROWTYPE;
11957: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11958: l_freight_cost_temp_charge c_move_fc_temp_charge%ROWTYPE;
11959: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

Line 11957: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11953: and s.trip_id=c_trip_id;
11954:
11955: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11956: l_freight_cost_temp_row c_move_fc_temp%ROWTYPE;
11957: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11958: l_freight_cost_temp_charge c_move_fc_temp_charge%ROWTYPE;
11959: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11960: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11961: l_rowid VARCHAR2(30);

Line 11959: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

11955: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11956: l_freight_cost_temp_row c_move_fc_temp%ROWTYPE;
11957: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11958: l_freight_cost_temp_charge c_move_fc_temp_charge%ROWTYPE;
11959: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11960: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11961: l_rowid VARCHAR2(30);
11962: l_update_rowid VARCHAR2(30);
11963: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;

Line 12099: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

12095:
12096: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
12097: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
12098:
12099: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
12100: p_freight_cost_info => l_freight_cost_main_row,
12101: x_rowid => l_rowid,
12102: x_freight_cost_id => l_freight_cost_id,
12103: x_return_status => l_return_status);

Line 12127: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

12123:
12124: l_freight_cost_main_row.FREIGHT_COST_ID := get_fc_id_from_dleg(l_freight_cost_main_row.DELIVERY_LEG_ID);
12125:
12126:
12127: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
12128: p_rowid => l_update_rowid,
12129: p_freight_cost_info => l_freight_cost_main_row,
12130: x_return_status => l_return_status);
12131:

Line 12213: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

12209: '(FPA)l_freight_cost_main_charge.COMMODITY_CATEGORY_ID='||l_freight_cost_main_charge.COMMODITY_CATEGORY_ID);
12210:
12211: l_freight_cost_main_charge.applied_to_charge_id := l_price_fc_ids(l_freight_cost_main_charge.delivery_detail_id);
12212:
12213: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
12214: p_freight_cost_info => l_freight_cost_main_charge,
12215: x_rowid => l_rowid,
12216: x_freight_cost_id => l_freight_cost_id,
12217: x_return_status => l_return_status);