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

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

Line 8597: FROM wsh_freight_costs wfc,

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

Line 8609: FROM wsh_freight_costs wfc

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

Line 8644: FROM wsh_freight_costs wfc

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

Line 8651: UPDATE wsh_freight_costs wfc

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

Line 8672: FROM wsh_freight_costs wfc

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

Line 8679: UPDATE wsh_freight_costs wfc

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

Line 10320: SELECT total_amount FROM wsh_freight_costs

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

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

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

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 11361: -- To move freight costs from pl/sql table to wsh_freight_costs

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

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);

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

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