APPS.EGO_ITEM_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) := 'ego_item_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) := 'ego_item_text_tl_srs.log';
38: g_Out_File VARCHAR2(30) := 'ego_item_text_tl_srs.out';

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

113: -- Determine log directory
114:
115: BEGIN
116: SELECT value INTO g_Dump_Dir
117: FROM v$parameter WHERE name = 'user_dump_dest';
118:
119: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
120: FROM v$parameter
121: WHERE name = 'utl_file_dir';

Line 120: FROM v$parameter

116: SELECT value INTO g_Dump_Dir
117: FROM v$parameter WHERE name = 'user_dump_dest';
118:
119: SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
120: FROM v$parameter
121: WHERE name = 'utl_file_dir';
122:
123: IF ( g_Log_Dir IS NOT NULL ) THEN
124: IF ( INSTR(g_Log_Dir, ' ') > 0 ) THEN