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 347: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

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

Line 1486: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(

1482: END IF;
1483:
1484:
1485: IF (p_in_rec.action_code= 'CREATE') THEN
1486: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
1487: p_freight_cost_info => l_freight_info_tab(l_index),
1488: x_rowid => x_out_tab(l_index).rowid,
1489: x_freight_cost_id => x_out_tab(l_index).freight_cost_id,
1490: x_return_status => l_return_status);

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

1489: x_freight_cost_id => x_out_tab(l_index).freight_cost_id,
1490: x_return_status => l_return_status);
1491:
1492: IF l_debug_on THEN
1493: WSH_DEBUG_SV.log(l_module_name,'WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost x_freight_cost_id,x_return_status',
1494: x_out_tab(l_index).freight_cost_id||','||l_return_status);
1495: END IF;
1496: WSH_UTIL_CORE.api_post_call(
1497: p_return_status => l_return_status,

Line 1506: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(

1502: p_token1 => 'ENTITY',
1503: p_value1 => 'Freight_Cost');
1504:
1505: ELSIF (p_in_rec.action_code= 'UPDATE') THEN
1506: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
1507: p_rowid => NULL,
1508: p_freight_cost_info => l_freight_info_tab(l_index),
1509: x_return_status => l_return_status);
1510:

Line 1709: l_pvt_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

1705: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Freight_Costs';
1706: l_debug_on BOOLEAN;
1707: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_FREIGHT_COSTS';
1708:
1709: l_pvt_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1710: l_in_rec FreightInRecType;
1711: l_freight_info_tab freight_rec_tab_type;
1712: l_out_tab freight_out_tab_type;
1713: BEGIN