APPS.ENG_CHANGE_TEXT_PVT dependencies on V$PARAMETER

Line 33: g_Log_Dir v$parameter.value%TYPE;

29:
30: g_Msg_Text VARCHAR2(1000);
31:
32: -- Log directory
33: g_Log_Dir v$parameter.value%TYPE;
34: g_Dump_Dir v$parameter.value%TYPE;
35:
36: -- Log files for Sqlplus
37: g_Log_File VARCHAR2(30) := 'eng_change_text_tl_srs.log';

Line 34: g_Dump_Dir v$parameter.value%TYPE;

30: g_Msg_Text VARCHAR2(1000);
31:
32: -- Log directory
33: g_Log_Dir v$parameter.value%TYPE;
34: g_Dump_Dir v$parameter.value%TYPE;
35:
36: -- Log files for Sqlplus
37: g_Log_File VARCHAR2(30) := 'eng_change_text_tl_srs.log';
38: g_Out_File VARCHAR2(30) := 'eng_cchange_text_tl_srs.out';

Line 123: FROM v$parameter WHERE name = 'user_dump_dest';

119: -- Determine log directory
120:
121: BEGIN
122: SELECT value INTO g_Dump_Dir
123: FROM v$parameter WHERE name = 'user_dump_dest';
124:
125: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
126: FROM v$parameter
127: WHERE name = 'utl_file_dir';

Line 126: FROM v$parameter

122: SELECT value INTO g_Dump_Dir
123: FROM v$parameter WHERE name = 'user_dump_dest';
124:
125: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
126: FROM v$parameter
127: WHERE name = 'utl_file_dir';
128:
129: IF ( g_Log_Dir IS NOT NULL ) THEN
130: IF ( INSTR(g_Log_Dir, ' ') > 0 ) THEN