eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FREIGHT_COSTS_GRP dependencies on WSH_FREIGHT_COSTS

Line 1: PACKAGE BODY WSH_FREIGHT_COSTS_GRP as

1: PACKAGE BODY WSH_FREIGHT_COSTS_GRP as
2: /* $Header: WSHFCGPB.pls 120.6.12010000.2 2008/08/04 12:30:52 suppal ship $ */
3: -- standard global constants
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_FREIGHT_COSTS_GRP';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_FREIGHT_COSTS_GRP';

1: PACKAGE BODY WSH_FREIGHT_COSTS_GRP as
2: /* $Header: WSHFCGPB.pls 120.6.12010000.2 2008/08/04 12:30:52 suppal ship $ */
3: -- standard global constants
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_FREIGHT_COSTS_GRP';
5:
6:
7: --===================
8: -- PROCEDURES

Line 103: , p_pub_freight_costs IN WSH_FREIGHT_COSTS_GRP.PubFreightCostRecType

99: , p_commit IN VARCHAR2
100: , x_return_status OUT NOCOPY VARCHAR2
101: , x_msg_count OUT NOCOPY NUMBER
102: , x_msg_data OUT NOCOPY VARCHAR2
103: , p_pub_freight_costs IN WSH_FREIGHT_COSTS_GRP.PubFreightCostRecType
104: )
105: IS
106: l_return_status VARCHAR2(30);
107: --

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 343: FROM wsh_freight_costs

339: , COMMODITY_CATEGORY_ID
340: , BILLABLE_QUANTITY
341: , BILLABLE_UOM
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:

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 623: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);

619: WHEN e_dp_no_entity THEN
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621:
622: WHEN OTHERS THEN
623: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
627: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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 1652: , p_pub_freight_costs IN WSH_FREIGHT_COSTS_GRP.PubFreightCostRecType

1648: , p_commit IN VARCHAR2
1649: , x_return_status OUT NOCOPY VARCHAR2
1650: , x_msg_count OUT NOCOPY NUMBER
1651: , x_msg_data OUT NOCOPY VARCHAR2
1652: , p_pub_freight_costs IN WSH_FREIGHT_COSTS_GRP.PubFreightCostRecType
1653: , p_action_code IN VARCHAR2
1654: , x_freight_cost_id OUT NOCOPY NUMBER
1655: )
1656: IS

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

Line 1739: END WSH_FREIGHT_COSTS_GRP;

1735: END IF;
1736: END Create_Update_Freight_Costs;
1737: --Harmonizing Project I :heali
1738:
1739: END WSH_FREIGHT_COSTS_GRP;