APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_FREIGHT_COSTS_PUB

Line 775: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;

771: l_fob_location_id NUMBER := P_fob_location_id;
772: l_intmed_shipto_loc_id NUMBER :=p_intmed_shipto_loc_id;
773:
774:
775: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
776: l_delivery_info WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type;
777: l_row_id ROWID;
778: l_delivery_id NUMBER;
779: l_freight_cost_id NUMBER;

Line 851: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs (

847: l_freight_cost_rec.delivery_ID :=p_delivery_id;
848: l_freight_cost_rec.action_code := 'CREATE';
849: EXIT WHEN delivery_freight%NOTFOUND;
850:
851: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs (
852: p_api_version_number =>1.0
853: , p_init_msg_list =>l_init_msg_list
854: , p_commit => FND_API.G_FALSE
855: , x_return_status => l_return_status

Line 1998: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;

1994: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
1995: l_msg_count NUMBER;
1996: l_msg_data VARCHAR2(20000);
1997:
1998: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
1999: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;
2000: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2001: l_freight_cost_id NUMBER;
2002: l_stop_id NUMBER;

Line 2109: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs

2105: l_freight_cost_rec.action_code := 'CREATE';
2106: EXIT WHEN trip_freight%NOTFOUND;
2107:
2108: --patchst J. Shipping API cleanup
2109: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs
2110: (p_api_version_number =>1.0
2111: , p_init_msg_list =>l_init_msg_list
2112: , p_commit => FND_API.G_FALSE
2113: , x_return_status => l_return_status

Line 2967: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;

2963: l_delivery_detail_tab delivery_detail_t;
2964:
2965: l_lpn_del_det_tab wsh_util_core.id_tab_type;
2966:
2967: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
2968:
2969: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2970: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
2971: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

Line 3002: debug('About to call wsh_freight_costs_pub.delete_freight_costs','UNLOAD_TRUCK');

2998: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
2999: AND wdd.delivery_detail_id = wfc.delivery_detail_id;
3000:
3001: IF l_debug = 1 THEN
3002: debug('About to call wsh_freight_costs_pub.delete_freight_costs','UNLOAD_TRUCK');
3003: debug('delivery_detail_id : '|| l_freight_costs.delivery_detail_id,'UNLOAD_TRUCK');
3004: debug('freight_cost_id : '|| l_freight_costs.freight_cost_id, 'UNLOAD_TRUCK');
3005: END IF;
3006: wsh_freight_costs_pub.delete_freight_costs

Line 3006: wsh_freight_costs_pub.delete_freight_costs

3002: debug('About to call wsh_freight_costs_pub.delete_freight_costs','UNLOAD_TRUCK');
3003: debug('delivery_detail_id : '|| l_freight_costs.delivery_detail_id,'UNLOAD_TRUCK');
3004: debug('freight_cost_id : '|| l_freight_costs.freight_cost_id, 'UNLOAD_TRUCK');
3005: END IF;
3006: wsh_freight_costs_pub.delete_freight_costs
3007: (p_api_version_number => 1.0,
3008: p_init_msg_list => l_init_msg_list,
3009: p_commit => fnd_api.g_false,
3010: x_return_status => l_return_status,

Line 3617: l_freight_cost_rec wsh_freight_costs_pub.pubfreightcostrectype;

3613: FROM wsh_delivery_details_ob_grp_v wdd
3614: WHERE lpn_id = p_lpn_id
3615: AND released_status = 'X'; -- For LPN reuse ER : 6845650
3616:
3617: l_freight_cost_rec wsh_freight_costs_pub.pubfreightcostrectype;
3618: l_delivery_detail delivery_detail%ROWTYPE;
3619: l_lpn_freight lpn_freight%ROWTYPE;
3620: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
3621: l_return_status VARCHAR2(1);

Line 3648: wsh_freight_costs_pub.create_update_freight_costs(

3644: l_freight_cost_rec.unit_amount := l_lpn_freight.freight_amount;
3645: l_freight_cost_rec.conversion_type_code := l_lpn_freight.conversion_type;
3646: l_freight_cost_rec.delivery_detail_id := l_delivery_detail.delivery_detail_id;
3647: l_freight_cost_rec.action_code := 'CREATE';
3648: wsh_freight_costs_pub.create_update_freight_costs(
3649: p_api_version_number => 1.0
3650: , p_init_msg_list => l_init_msg_list
3651: , p_commit => fnd_api.g_false
3652: , x_return_status => l_return_status