APPS.WSH_FOLDER_EXTENSIONS_PVT dependencies on WSH_FOLDER_EXTENSIONS

Line 1: PACKAGE BODY WSH_FOLDER_EXTENSIONS_PVT as

1: PACKAGE BODY WSH_FOLDER_EXTENSIONS_PVT as
2: /* $Header: WSHFDEXB.pls 115.7 2004/02/17 01:11:53 ttrichy noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FOLDER_EXTENSIONS_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FOLDER_EXTENSIONS_PVT';

1: PACKAGE BODY WSH_FOLDER_EXTENSIONS_PVT as
2: /* $Header: WSHFDEXB.pls 115.7 2004/02/17 01:11:53 ttrichy noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FOLDER_EXTENSIONS_PVT';
5:
6: Procedure Insert_Update_Folder_Ext(
7: p_folder_ext_rec IN folder_ext_rec_type,
8: x_return_status OUT NOCOPY VARCHAR2)

Line 13: FROM wsh_folder_extensions

9: IS PRAGMA AUTONOMOUS_TRANSACTION;
10:
11: CURSOR c_ext_rec_cur(p_folder_id NUMBER) IS
12: SELECT folder_extension_id
13: FROM wsh_folder_extensions
14: WHERE folder_id = p_folder_id
15: FOR UPDATE NOWAIT;
16:
17: l_folder_extension_id NUMBER;

Line 55: UPDATE WSH_FOLDER_EXTENSIONS

51: FETCH c_ext_rec_cur INTO l_folder_extension_id;
52:
53: IF c_ext_rec_cur%FOUND THEN
54:
55: UPDATE WSH_FOLDER_EXTENSIONS
56: SET
57: user_id = nvl(p_folder_ext_rec.user_id, FND_GLOBAL.USER_ID),
58: application_id = nvl(p_folder_ext_rec.application_id, 665),
59: display_dlvy_main = nvl(p_folder_ext_rec.display_dlvy_main,'Y'), -- always display

Line 79: INSERT INTO WSH_FOLDER_EXTENSIONS

75: WHERE
76: folder_id = p_folder_ext_rec.folder_id;
77: ELSE
78:
79: INSERT INTO WSH_FOLDER_EXTENSIONS
80: (FOLDER_EXTENSION_ID,
81: OBJECT,
82: USER_ID,
83: FOLDER_ID,

Line 142: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_EXT',l_module_name);

138:
139: EXCEPTION
140:
141: WHEN others THEN
142: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_EXT',l_module_name);
143: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
144: --
145: IF l_debug_on THEN
146: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 201: DELETE FROM wsh_folder_extensions

197: END IF;
198:
199: IF l_flag = 'N' THEN
200:
201: DELETE FROM wsh_folder_extensions
202: WHERE folder_id = p_folder_id;
203:
204: IF l_debug_on THEN
205: WSH_DEBUG_SV.log(l_module_name,'Folders Deleted-',sql%rowcount);

Line 224: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_EXT',l_module_name);

220: --
221: EXCEPTION
222:
223: WHEN others THEN
224: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_EXT',l_module_name);
225: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
226: --
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 360: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_CUSTOM',l_module_name);

356:
357: EXCEPTION
358:
359: WHEN others THEN
360: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_CUSTOM',l_module_name);
361: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
362: --
363: IF l_debug_on THEN
364: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 425: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_CUSTOM',l_module_name);

421: --
422: EXCEPTION
423:
424: WHEN others THEN
425: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_CUSTOM',l_module_name);
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 438: END WSH_FOLDER_EXTENSIONS_PVT;

434: END Delete_Folder_Custom;
435:
436:
437:
438: END WSH_FOLDER_EXTENSIONS_PVT;