DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on V$PARAMETER

Line 96: FROM v$parameter

92:
93: /* get output directory path from database */
94: SELECT value
95: INTO l_full_path
96: FROM v$parameter
97: WHERE name = 'utl_file_dir';
98:
99: l_flag := 0;
100: --l_full_path contains a list of comma-separated directories

Line 169: -- FROM V$PARAMETER

165: x_debug := 'Y';
166:
167: -- SELECT trim(substr(VALUE, 1, DECODE( instr( VALUE, ','), 0, length( VALUE), instr( VALUE, ',') -1 ) ) )
168: -- INTO x_output_dir
169: -- FROM V$PARAMETER
170: -- WHERE NAME = 'utl_file_dir';
171: --Call log path
172: log_path( x_output_dir => l_output_dir);
173: --