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_COST_TYPES_PVT dependencies on WSH_FREIGHT_COST_TYPES

Line 1: PACKAGE BODY WSH_FREIGHT_COST_TYPES_PVT AS

1: PACKAGE BODY WSH_FREIGHT_COST_TYPES_PVT AS
2: /* $Header: WSHFCTPB.pls 115.3 2002/11/13 20:08:08 nparikh ship $ */
3: -- Package internal global variables
4: g_Return_Status VARCHAR2(1);
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FREIGHT_COST_TYPES_PVT';

3: -- Package internal global variables
4: g_Return_Status VARCHAR2(1);
5:
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FREIGHT_COST_TYPES_PVT';
8: --
9: PROCEDURE Create_Freight_Cost_Type(
10: p_freight_cost_type_info IN Freight_Cost_Type_Rec_Type
11: , x_rowid OUT NOCOPY VARCHAR2

Line 18: SELECT wsh_freight_cost_types_s.nextval

14: )
15: IS
16: CURSOR C_Next_Freight_Cost_Type_Id
17: IS
18: SELECT wsh_freight_cost_types_s.nextval
19: FROM sys.dual;
20:
21: CURSOR c_new_row_id
22: IS

Line 24: FROM wsh_freight_cost_types

20:
21: CURSOR c_new_row_id
22: IS
23: SELECT rowid
24: FROM wsh_freight_cost_types
25: WHERE freight_cost_type_id = x_freight_cost_type_id;
26:
27: create_failure EXCEPTION;
28: --

Line 79: INSERT INTO wsh_freight_cost_types(

75: END IF;
76: END LOOP;
77: END IF;
78:
79: INSERT INTO wsh_freight_cost_types(
80: freight_cost_type_id,
81: name,
82: freight_cost_type_code,
83: amount,

Line 171: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');

167: END IF;
168: --
169: EXCEPTION
170: WHEN create_failure THEN
171: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
173:
174: --
175: -- Debug Statements

Line 183: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');

179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_FAILURE');
180: END IF;
181: --
182: WHEN others THEN
183: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');
184: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
185:
186: --
187: -- Debug Statements

Line 232: UPDATE wsh_freight_cost_types

228: END IF;
229: --
230: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
231:
232: UPDATE wsh_freight_cost_types
233: SET
234: name = p_freight_cost_type_info.name,
235: freight_cost_type_code = p_freight_cost_type_info.freight_cost_type_code,
236: amount = p_freight_cost_type_info.amount,

Line 282: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.UPDATE_FREIGHT_COST_TYPE');

278: END IF;
279: --
280: EXCEPTION
281: WHEN others THEN
282: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.UPDATE_FREIGHT_COST_TYPE');
283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
284: --
285: -- Debug Statements
286: --

Line 302: FROM wsh_freight_cost_types

298: IS
299:
300: CURSOR lock_row IS
301: SELECT *
302: FROM wsh_freight_cost_types
303: WHERE rowid = p_rowid
304: FOR UPDATE OF freight_cost_type_id NOWAIT;
305:
306: Recinfo lock_row%ROWTYPE;

Line 433: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.LOCK_FREIGHT_COST_TYPE');

429: END IF;
430: --
431: EXCEPTION
432: WHEN others THEN
433: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.LOCK_FREIGHT_COST_TYPE');
434: --
435: -- Debug Statements
436: --
437: IF l_debug_on THEN

Line 462: FROM wsh_freight_cost_types

458: IS
459: CURSOR C_Get_Freight_cost_type_id
460: IS
461: SELECT freight_cost_type_id
462: FROM wsh_freight_cost_types
463: WHERE rowid = p_rowid;
464:
465: l_freight_cost_type_id NUMBER;
466: row_not_found EXCEPTION;

Line 502: DELETE FROM wsh_freight_cost_types

498: CLOSE C_Get_Freight_cost_type_id;
499: END IF;
500:
501: IF (l_freight_cost_type_id IS NOT NULL) THEN
502: DELETE FROM wsh_freight_cost_types
503: WHERE freight_cost_type_id = p_freight_cost_type_id;
504: ELSE
505: RAISE row_not_found;
506: END IF;

Line 517: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');

513: END IF;
514: --
515: EXCEPTION
516: WHEN row_not_found THEN
517: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');
518: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
519: --
520: -- Debug Statements
521: --

Line 528: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');

524: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ROW_NOT_FOUND');
525: END IF;
526: --
527: WHEN others THEN
528: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
530: --
531: -- Debug Statements
532: --

Line 540: END WSH_FREIGHT_COST_TYPES_PVT;

536: END IF;
537: --
538: END Delete_Freight_Cost_Type;
539:
540: END WSH_FREIGHT_COST_TYPES_PVT;