APPS.WSH_FREIGHT_COSTS_GRP dependencies on WSH_FREIGHT_COSTS_PVT

Line 132: WSH_FREIGHT_COSTS_PVT.Delete_freight_cost(

128: END IF;
129: --
130: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
131:
132: WSH_FREIGHT_COSTS_PVT.Delete_freight_cost(
133: p_rowid => NULL,
134: p_freight_cost_id => p_pub_freight_costs.freight_cost_id,
135: x_return_status => x_return_status);
136:

Line 169: x_pvt_freight_rec OUT NOCOPY WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type,

165:
166: --Harmonizing Project I :heali
167: PROCEDURE map_freightgrp_to_pvt(
168: p_grp_freight_rec IN PubFreightCostRecType,
169: x_pvt_freight_rec OUT NOCOPY WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type,
170: x_return_status OUT NOCOPY VARCHAR2) IS
171:
172: --
173: l_debug_on BOOLEAN;

Line 269: p_freight_rec IN WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type

265: END map_freightgrp_to_pvt;
266:
267:
268: PROCEDURE Get_Disabled_List (
269: p_freight_rec IN WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type
270: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
271: , p_caller IN VARCHAR2
272: , x_freight_rec OUT NOCOPY WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type
273: , x_return_status OUT NOCOPY VARCHAR2

Line 272: , x_freight_rec OUT NOCOPY WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type

268: PROCEDURE Get_Disabled_List (
269: p_freight_rec IN WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type
270: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
271: , p_caller IN VARCHAR2
272: , x_freight_rec OUT NOCOPY WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type
273: , x_return_status OUT NOCOPY VARCHAR2
274: ) IS
275:
276: l_debug_on BOOLEAN;

Line 346: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

342: , BILLABLE_BASIS
343: FROM wsh_freight_costs
344: WHERE FREIGHT_COST_ID= p_freight_rec.freight_cost_id;
345:
346: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
347:
348: e_dp_no_entity EXCEPTION;
349: BEGIN
350: --

Line 1440: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

1436: END IF;
1437:
1438:
1439: IF (p_in_rec.action_code= 'CREATE') THEN
1440: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
1441: p_freight_cost_info => l_freight_info_tab(l_index),
1442: x_rowid => x_out_tab(l_index).rowid,
1443: x_freight_cost_id => x_out_tab(l_index).freight_cost_id,
1444: x_return_status => l_return_status);

Line 1447: WSH_DEBUG_SV.log(l_module_name,'WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost x_freight_cost_id,x_return_status',

1443: x_freight_cost_id => x_out_tab(l_index).freight_cost_id,
1444: x_return_status => l_return_status);
1445:
1446: IF l_debug_on THEN
1447: WSH_DEBUG_SV.log(l_module_name,'WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost x_freight_cost_id,x_return_status',
1448: x_out_tab(l_index).freight_cost_id||','||l_return_status);
1449: END IF;
1450: WSH_UTIL_CORE.api_post_call(
1451: p_return_status => l_return_status,

Line 1460: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

1456: p_token1 => 'ENTITY',
1457: p_value1 => 'Freight_Cost');
1458:
1459: ELSIF (p_in_rec.action_code= 'UPDATE') THEN
1460: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
1461: p_rowid => NULL,
1462: p_freight_cost_info => l_freight_info_tab(l_index),
1463: x_return_status => l_return_status);
1464:

Line 1663: l_pvt_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

1659: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Freight_Costs';
1660: l_debug_on BOOLEAN;
1661: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_FREIGHT_COSTS';
1662:
1663: l_pvt_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1664: l_in_rec FreightInRecType;
1665: l_freight_info_tab freight_rec_tab_type;
1666: l_out_tab freight_out_tab_type;
1667: BEGIN