APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_FREIGHT_COSTS_PUB

Line 858: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;

854: l_fob_location_id NUMBER := P_fob_location_id;
855: l_intmed_shipto_loc_id NUMBER :=p_intmed_shipto_loc_id;
856:
857:
858: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
859: l_delivery_info WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type;
860: l_row_id ROWID;
861: l_delivery_id NUMBER;
862: l_freight_cost_id NUMBER;

Line 934: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs (

930: l_freight_cost_rec.delivery_ID :=p_delivery_id;
931: l_freight_cost_rec.action_code := 'CREATE';
932: EXIT WHEN delivery_freight%NOTFOUND;
933:
934: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs (
935: p_api_version_number =>1.0
936: , p_init_msg_list =>l_init_msg_list
937: , p_commit => FND_API.G_FALSE
938: , x_return_status => l_return_status

Line 2094: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;

2090: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
2091: l_msg_count NUMBER;
2092: l_msg_data VARCHAR2(20000);
2093:
2094: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
2095: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;
2096: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2097: l_freight_cost_id NUMBER;
2098: l_stop_id NUMBER;

Line 2205: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs

2201: l_freight_cost_rec.action_code := 'CREATE';
2202: EXIT WHEN trip_freight%NOTFOUND;
2203:
2204: --patchst J. Shipping API cleanup
2205: WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs
2206: (p_api_version_number =>1.0
2207: , p_init_msg_list =>l_init_msg_list
2208: , p_commit => FND_API.G_FALSE
2209: , x_return_status => l_return_status

Line 3124: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;

3120: l_delivery_detail_tab delivery_detail_t;
3121:
3122: l_lpn_del_det_tab wsh_util_core.id_tab_type;
3123:
3124: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
3125:
3126: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3127: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
3128: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

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

3155: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
3156: AND wdd.delivery_detail_id = wfc.delivery_detail_id;
3157:
3158: IF l_debug = 1 THEN
3159: debug('About to call wsh_freight_costs_pub.delete_freight_costs','UNLOAD_TRUCK');
3160: debug('delivery_detail_id : '|| l_freight_costs.delivery_detail_id,'UNLOAD_TRUCK');
3161: debug('freight_cost_id : '|| l_freight_costs.freight_cost_id, 'UNLOAD_TRUCK');
3162: END IF;
3163: wsh_freight_costs_pub.delete_freight_costs

Line 3163: wsh_freight_costs_pub.delete_freight_costs

3159: debug('About to call wsh_freight_costs_pub.delete_freight_costs','UNLOAD_TRUCK');
3160: debug('delivery_detail_id : '|| l_freight_costs.delivery_detail_id,'UNLOAD_TRUCK');
3161: debug('freight_cost_id : '|| l_freight_costs.freight_cost_id, 'UNLOAD_TRUCK');
3162: END IF;
3163: wsh_freight_costs_pub.delete_freight_costs
3164: (p_api_version_number => 1.0,
3165: p_init_msg_list => l_init_msg_list,
3166: p_commit => fnd_api.g_false,
3167: x_return_status => l_return_status,

Line 3819: l_freight_cost_rec wsh_freight_costs_pub.pubfreightcostrectype;

3815: FROM wsh_delivery_details_ob_grp_v wdd
3816: WHERE lpn_id = p_lpn_id
3817: AND released_status = 'X'; -- For LPN reuse ER : 6845650
3818:
3819: l_freight_cost_rec wsh_freight_costs_pub.pubfreightcostrectype;
3820: l_delivery_detail delivery_detail%ROWTYPE;
3821: l_lpn_freight lpn_freight%ROWTYPE;
3822: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
3823: l_return_status VARCHAR2(1);

Line 3850: wsh_freight_costs_pub.create_update_freight_costs(

3846: l_freight_cost_rec.unit_amount := l_lpn_freight.freight_amount;
3847: l_freight_cost_rec.conversion_type_code := l_lpn_freight.conversion_type;
3848: l_freight_cost_rec.delivery_detail_id := l_delivery_detail.delivery_detail_id;
3849: l_freight_cost_rec.action_code := 'CREATE';
3850: wsh_freight_costs_pub.create_update_freight_costs(
3851: p_api_version_number => 1.0
3852: , p_init_msg_list => l_init_msg_list
3853: , p_commit => fnd_api.g_false
3854: , x_return_status => l_return_status