APPS.WSH_DELIVERY_LEGS_PVT dependencies on WSH_FREIGHT_COSTS

Line 33: l_freight_cost_info WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

29: SELECT wsh_delivery_legs_s.nextval
30: FROM sys.dual;
31:
32: /* csun 02/25/2002 */
33: l_freight_cost_info WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
34: l_row_id VARCHAR2(30);
35: l_freight_cost_id NUMBER ;
36: l_return_status VARCHAR2(1);
37: l_fte_install_status VARCHAR2(30);

Line 231: WSH_FREIGHT_COSTS_PVT.create_freight_cost(

227: l_freight_cost_info.created_by := FND_GLOBAL.USER_ID;
228: l_freight_cost_info.last_update_date := SYSDATE;
229: l_freight_cost_info.last_updated_by := FND_GLOBAL.USER_ID;
230: --
231: WSH_FREIGHT_COSTS_PVT.create_freight_cost(
232: p_freight_cost_info => l_freight_cost_info,
233: x_rowid => l_row_id,
234: x_freight_cost_id => l_freight_cost_id,
235: x_return_status => l_return_status );

Line 756: DELETE FROM wsh_freight_costs

752: --OTM R12, allow delete when OTM is installed
753: OR l_gc3_is_installed = 'Y'
754: --
755: THEN
756: DELETE FROM wsh_freight_costs
757: WHERE delivery_leg_id = l_delivery_leg_id;
758:
759: IF l_debug_on THEN
760: WSH_DEBUG_SV.log(l_module_name,

Line 761: 'Rows deleted from wsh_freight_costs',SQL%ROWCOUNT);

757: WHERE delivery_leg_id = l_delivery_leg_id;
758:
759: IF l_debug_on THEN
760: WSH_DEBUG_SV.log(l_module_name,
761: 'Rows deleted from wsh_freight_costs',SQL%ROWCOUNT);
762: END IF;
763: END IF;
764: --
765: