APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on V$PARAMETER

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

13: Created By : ayedubat
14: Date Created By : 24-Dec-02
15: Purpose: Private procedure created for finding the Directory of the filename.
16: This will check the value of profile 'UTL_FILE_OUT'
17: (output dir for export data file) matches with the value in v$parameter
18: for the name utl_file_dir.
19: Known limitations,enhancements,remarks:
20: Change History
21: Who When What

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

24: l_start_str_index NUMBER := 1;
25: l_end_comma_index NUMBER := 1;
26: l_start_comma_index NUMBER := 1;
27: l_fndvalue VARCHAR2(80);
28: l_dbvalue V$PARAMETER.VALUE%TYPE;
29: l_db_directory V$PARAMETER.VALUE%TYPE;
30:
31: CURSOR cur_parameter_value IS
32: SELECT LTRIM(RTRIM(value))

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

25: l_end_comma_index NUMBER := 1;
26: l_start_comma_index NUMBER := 1;
27: l_fndvalue VARCHAR2(80);
28: l_dbvalue V$PARAMETER.VALUE%TYPE;
29: l_db_directory V$PARAMETER.VALUE%TYPE;
30:
31: CURSOR cur_parameter_value IS
32: SELECT LTRIM(RTRIM(value))
33: FROM V$PARAMETER

Line 33: FROM V$PARAMETER

29: l_db_directory V$PARAMETER.VALUE%TYPE;
30:
31: CURSOR cur_parameter_value IS
32: SELECT LTRIM(RTRIM(value))
33: FROM V$PARAMETER
34: WHERE name ='utl_file_dir';
35:
36: CURSOR cur_db_dir IS
37: SELECT DECODE( INSTR(l_dbvalue,',',l_start_str_index),0,LENGTH(l_dbvalue)+1, INSTR(l_dbvalue,',',l_start_str_index) )