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

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 4119: FROM wsh_freight_costs

4115: IS
4116:
4117: CURSOR c_get_fc_id(p_dleg_id IN NUMBER) IS
4118: SELECT freight_cost_id,created_by,creation_date
4119: FROM wsh_freight_costs
4120: WHERE delivery_leg_id = p_dleg_id
4121: AND delivery_detail_id IS NULL
4122: AND line_type_code = 'SUMMARY';
4123:

Line 7334: -- WSH_FREIGHT_COSTS or FTE_FREIGHT_COSTS_TEMP depending on p_save_flag values ('T' or 'M')

7330: -- It processes each input shipment content line to identify their patterns
7331: -- and to construct input lines to send to the QP engine using the Pricing preferences
7332: -- Uses process_shipment_pattern to construct inputs to QP engine line and attribute line
7333: -- This API also calls out post-processing APIs and saves to
7334: -- WSH_FREIGHT_COSTS or FTE_FREIGHT_COSTS_TEMP depending on p_save_flag values ('T' or 'M')
7335: -- Looks up delivery detail info from g_shipment_line_rows
7336:
7337: PROCEDURE shipment_pricing (
7338: p_lane_id IN NUMBER DEFAULT NULL,

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 8357: wsh_freight_costs wfc

8353: IS
8354: CURSOR c_get_services(c_delivery_detail_id IN NUMBER) IS
8355: SELECT DISTINCT wfct.freight_cost_type_code,wfct.freight_cost_type_id
8356: FROM wsh_freight_cost_types wfct,
8357: wsh_freight_costs wfc
8358: WHERE wfc.delivery_detail_id = c_delivery_detail_id
8359: AND wfc.charge_source_code = 'REQUESTED'
8360: AND wfc.freight_cost_type_id = wfct.freight_cost_type_id;
8361:

Line 8548: FROM wsh_freight_costs

8544: IS
8545:
8546: CURSOR c_get_freight_cost_id IS
8547: SELECT freight_cost_id
8548: FROM wsh_freight_costs
8549: WHERE delivery_leg_id = p_delivery_leg_id
8550: AND delivery_detail_id IS NULL
8551: AND line_type_code = 'SUMMARY';
8552:

Line 8596: FROM wsh_freight_costs wfc,

8592: CURSOR c_lock_wfc_1(c_segment_id NUMBER)
8593: IS
8594:
8595: SELECT wfc.freight_cost_id
8596: FROM wsh_freight_costs wfc,
8597: wsh_delivery_legs dl ,
8598: wsh_trip_stops s
8599: WHERE wfc.delivery_leg_id = dl.delivery_leg_id
8600: and dl.pick_up_stop_id=s.stop_id

Line 8608: FROM wsh_freight_costs wfc

8604:
8605: CURSOR c_lock_wfc_2(c_delivery_leg_id NUMBER)
8606: IS
8607: SELECT wfc.freight_cost_id
8608: FROM wsh_freight_costs wfc
8609: WHERE wfc.delivery_leg_id = c_delivery_leg_id
8610: AND charge_source_code = 'PRICING_ENGINE'
8611: FOR UPDATE NOWAIT;
8612:

Line 8643: FROM wsh_freight_costs wfc

8639: THEN
8640:
8641: FORALL i IN l_wfc_detail_ids.FIRST..l_wfc_detail_ids.LAST
8642: DELETE
8643: FROM wsh_freight_costs wfc
8644: WHERE wfc.freight_cost_id = l_wfc_detail_ids(i)
8645: AND (line_type_code <> 'SUMMARY'
8646: OR (line_type_code = 'SUMMARY' AND delivery_detail_id IS NOT NULL));
8647:

Line 8650: UPDATE wsh_freight_costs wfc

8646: OR (line_type_code = 'SUMMARY' AND delivery_detail_id IS NOT NULL));
8647:
8648: FORALL i IN l_wfc_detail_ids.FIRST..l_wfc_detail_ids.LAST
8649:
8650: UPDATE wsh_freight_costs wfc
8651: SET unit_amount=NULL,
8652: total_amount=NULL,
8653: currency_code=NULL
8654: WHERE wfc.freight_cost_id=l_wfc_detail_ids(i)

Line 8671: FROM wsh_freight_costs wfc

8667: THEN
8668:
8669: FORALL i IN l_wfc_dleg_ids.FIRST..l_wfc_dleg_ids.LAST
8670: DELETE
8671: FROM wsh_freight_costs wfc
8672: WHERE wfc.freight_cost_id=l_wfc_dleg_ids(i)
8673: AND (line_type_code <> 'SUMMARY'
8674: OR (line_type_code = 'SUMMARY' AND delivery_detail_id IS NOT NULL));
8675:

Line 8678: UPDATE wsh_freight_costs wfc

8674: OR (line_type_code = 'SUMMARY' AND delivery_detail_id IS NOT NULL));
8675:
8676:
8677: FORALL i IN l_wfc_dleg_ids.FIRST..l_wfc_dleg_ids.LAST
8678: UPDATE wsh_freight_costs wfc
8679: SET unit_amount=NULL,
8680: total_amount=NULL,
8681: currency_code=NULL
8682: WHERE wfc.freight_cost_id=l_wfc_dleg_ids(i)

Line 10319: SELECT total_amount FROM wsh_freight_costs

10315:
10316:
10317: CURSOR check_freight_cost_exist (c_delivery_leg_id IN NUMBER)
10318: IS
10319: SELECT total_amount FROM wsh_freight_costs
10320: WHERE line_type_code='SUMMARY'
10321: AND delivery_detail_id is null
10322: AND freight_cost_type_id is not null
10323: AND delivery_leg_id= c_delivery_leg_id;

Line 11115: -- To move freight costs from pl/sql table to wsh_freight_costs

11111: END IF;
11112: END delete_fc_temp_pvt;
11113:
11114: -- This API is called by Rate_Delivery of LCSS project
11115: -- To move freight costs from pl/sql table to wsh_freight_costs
11116: -- for non-TL rates, dleg_id is not populated in freight_cost_temp
11117:
11118: PROCEDURE Move_fc_temp_to_main (
11119: p_delivery_leg_id IN NUMBER,

Line 11130: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11131: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11132: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

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

11225: l_freight_cost_main_row.DELIVERY_LEG_ID := l_freight_cost_main_row.delivery_leg_id;
11226:
11227: 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);
11228:
11229: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');
11230: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11231: p_rowid => l_update_rowid,
11232: p_freight_cost_info => l_freight_cost_main_row,
11233: x_return_status => l_return_status);

Line 11230: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

11226:
11227: 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);
11228:
11229: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');
11230: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11231: p_rowid => l_update_rowid,
11232: p_freight_cost_info => l_freight_cost_main_row,
11233: x_return_status => l_return_status);
11234:

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

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

Line 11249: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

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

Line 11318: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

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

Line 11360: -- To move freight costs from pl/sql table to wsh_freight_costs

11356: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
11357: END;
11358:
11359: -- This API is called by Rate_Delivery of LCSS project
11360: -- To move freight costs from pl/sql table to wsh_freight_costs
11361: -- for TL rates, tl cost allocation will populate dleg_id in freight_cost_temp
11362:
11363: PROCEDURE Move_fc_temp_to_main (
11364: p_freight_cost_temp IN Freight_Cost_Temp_Tab_Type,

Line 11372: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11373: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

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

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

Line 11446: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

11442:
11443: 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);
11444:
11445: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost...');
11446: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
11447: p_rowid => l_update_rowid,
11448: p_freight_cost_info => l_freight_cost_main_row,
11449: x_return_status => l_return_status);
11450:

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

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

Line 11465: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

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

Line 11561: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11562: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11564: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11695: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

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

Line 11723: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

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

Line 11794: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

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

Line 11954: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11956: l_freight_cost_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 11958: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 12098: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

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

Line 12126: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

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

Line 12212: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

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

Line 13058: -- It stores frieght cost details in WSH_FREIGHT_COSTS_TEMP table for all the lanes

13054:
13055:
13056:
13057: -- This API is called from the Multi-leg UI for price comparison across lanes/schedules
13058: -- It stores frieght cost details in WSH_FREIGHT_COSTS_TEMP table for all the lanes
13059: -- for display purpose.
13060: -- It returns PL/SQL tables (dense) of summary price in the same sequence as the input
13061: -- Calls shipment hierarchy flattening API
13062: