APPS.IGS_UC_EXT_MARVIN dependencies on V$PARAMETER

Line 157: (output dir for export data file) matches with the value in v$parameter

153: Created By : ayedubat
154: Date Created By : 24-DEC-2002
155: Purpose : Private procedure craeted for finding the Directory of the filename.
156: This will check the value of profile 'UTL_FILE_OUT'
157: (output dir for export data file) matches with the value in v$parameter
158: for the name utl_file_dir.
159: Know limitations, enhancements or remarks
160: Change History
161: Who When What

Line 169: l_dbvalue V$PARAMETER.VALUE%TYPE;

165: l_start_str_index NUMBER := 1;
166: l_end_comma_index NUMBER := 1;
167: l_start_comma_index NUMBER := 1;
168: l_fndvalue VARCHAR2(80);
169: l_dbvalue V$PARAMETER.VALUE%TYPE;
170: l_db_directory V$PARAMETER.VALUE%TYPE;
171:
172: CURSOR cur_parameter_value IS
173: SELECT LTRIM(RTRIM(value))

Line 170: l_db_directory V$PARAMETER.VALUE%TYPE;

166: l_end_comma_index NUMBER := 1;
167: l_start_comma_index NUMBER := 1;
168: l_fndvalue VARCHAR2(80);
169: l_dbvalue V$PARAMETER.VALUE%TYPE;
170: l_db_directory V$PARAMETER.VALUE%TYPE;
171:
172: CURSOR cur_parameter_value IS
173: SELECT LTRIM(RTRIM(value))
174: FROM V$PARAMETER

Line 174: FROM V$PARAMETER

170: l_db_directory V$PARAMETER.VALUE%TYPE;
171:
172: CURSOR cur_parameter_value IS
173: SELECT LTRIM(RTRIM(value))
174: FROM V$PARAMETER
175: WHERE name ='utl_file_dir';
176:
177: CURSOR cur_db_dir IS
178: SELECT DECODE( INSTR(l_dbvalue,',',l_start_str_index),0,LENGTH(l_dbvalue)+1, INSTR(l_dbvalue,',',l_start_str_index) )