DBA Data[Home] [Help]

APPS.WSH_UTILITIES dependencies on V$PARAMETER

Line 40: into v_st_position,v_end_position from v$parameter

36: WSH_DEBUG_SV.push(l_module_name);
37: END IF;
38: --
39: select INSTR(value,',',1,2),INSTR(value,',',1,3)
40: into v_st_position,v_end_position from v$parameter
41: where upper(name) = 'UTL_FILE_DIR';
42: v_w_position := v_end_position - v_st_position - 1;
43: select substr(value,v_st_position+1,v_w_position)
44: into v_log_name from v$parameter

Line 44: into v_log_name from v$parameter

40: into v_st_position,v_end_position from v$parameter
41: where upper(name) = 'UTL_FILE_DIR';
42: v_w_position := v_end_position - v_st_position - 1;
43: select substr(value,v_st_position+1,v_w_position)
44: into v_log_name from v$parameter
45: where upper(name) = 'UTL_FILE_DIR';
46: v_log_name := ltrim(v_log_name);
47: FND_FILE.PUT_NAMES(v_log_name,v_log_name,v_log_name);
48: --