DBA Data[Home] [Help]

APPS.AHL_EAM_JOB_PVT dependencies on V$PARAMETER

Line 28: FROM v$parameter

24:
25: /* get output directory path from database */
26: SELECT value
27: INTO l_full_path
28: FROM v$parameter
29: WHERE name = 'utl_file_dir';
30:
31: l_flag := 0;
32: --l_full_path contains a list of comma-separated directories

Line 102: -- FROM V$PARAMETER

98: x_debug := 'Y';
99:
100: -- SELECT trim(substr(VALUE, 1, DECODE( instr( VALUE, ','), 0, length( VALUE), instr( VALUE, ',') -1 ) ) )
101: -- INTO x_output_dir
102: -- FROM V$PARAMETER
103: -- WHERE NAME = 'utl_file_dir';
104: --Call log path
105: log_path( x_output_dir => l_output_dir);
106: --