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.12 2012/01/24 12:54:40 shtadepa noship $ */
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.12 2012/01/24 12:54:40 shtadepa noship $ */
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 344: FROM wsh_freight_costs

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

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

663: END IF;
664: --
665:
666: WHEN OTHERS THEN
667: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);
668: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
671: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1694: , p_commit IN VARCHAR2
1695: , x_return_status OUT NOCOPY VARCHAR2
1696: , x_msg_count OUT NOCOPY NUMBER
1697: , x_msg_data OUT NOCOPY VARCHAR2
1698: , p_pub_freight_costs IN WSH_FREIGHT_COSTS_GRP.PubFreightCostRecType
1699: , p_action_code IN VARCHAR2
1700: , x_freight_cost_id OUT NOCOPY NUMBER
1701: )
1702: IS

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

Line 1785: END WSH_FREIGHT_COSTS_GRP;

1781: END IF;
1782: END Create_Update_Freight_Costs;
1783: --Harmonizing Project I :heali
1784:
1785: END WSH_FREIGHT_COSTS_GRP;