APPS.EAM_TEXT_INDEX_PVT dependencies on V$PARAMETER

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

61:
62: g_Msg_Text VARCHAR2(1000);
63:
64: -- Log directory
65: g_Log_Dir v$parameter.value%TYPE;
66: g_Dump_Dir v$parameter.value%TYPE;
67:
68: -- Log files for Sqlplus
69: g_Log_File VARCHAR2(30) := 'eam_text_index.log';

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

62: g_Msg_Text VARCHAR2(1000);
63:
64: -- Log directory
65: g_Log_Dir v$parameter.value%TYPE;
66: g_Dump_Dir v$parameter.value%TYPE;
67:
68: -- Log files for Sqlplus
69: g_Log_File VARCHAR2(30) := 'eam_text_index.log';
70: g_Out_File VARCHAR2(30) := 'eam_text_index.out';

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

166: -- Determine log directory
167:
168: BEGIN
169: SELECT value INTO g_Dump_Dir
170: FROM v$parameter WHERE name = 'user_dump_dest';
171:
172: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
173: FROM v$parameter
174: WHERE name = 'utl_file_dir';

Line 173: FROM v$parameter

169: SELECT value INTO g_Dump_Dir
170: FROM v$parameter WHERE name = 'user_dump_dest';
171:
172: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
173: FROM v$parameter
174: WHERE name = 'utl_file_dir';
175:
176: IF ( g_Log_Dir IS NOT NULL ) THEN
177: IF ( INSTR(g_Log_Dir, ' ') > 0 ) THEN