13: --
14: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'FIND_INDEX';
15: BEGIN
16: --
17: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
18: --
19: IF l_debug_on IS NULL
20: THEN
21: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
58: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'SET_DATA_INDEX';
59: --
60: BEGIN
61: --
62: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
63: --
64: IF l_debug_on IS NULL
65: THEN
66: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
120: --
121: BEGIN
122: --Get length of the table and add in the end.
123: --
124: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
125: --
126: IF l_debug_on IS NULL
127: THEN
128: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
175: --
176: BEGIN
177: --Get length of the table and add in the end.
178: --
179: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
180: --
181: IF l_debug_on IS NULL
182: THEN
183: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
219: --
220: BEGIN
221: --Looping thru the Table to get the index of search result
222: --
223: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
224: --
225: IF l_debug_on IS NULL
226: THEN
227: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
273: --
274: BEGIN
275: --Looping thru the Table to get the index of search result
276: --
277: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
278: --
279: IF l_debug_on IS NULL
280: THEN
281: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
327: --
328: BEGIN
329: --Looping thru the Table to get the index of search result
330: --
331: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
332: --
333: IF l_debug_on IS NULL
334: THEN
335: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;