DBA Data[Home] [Help]

APPS.EDW_GEN_VIEW dependencies on V$PARAMETER

Line 35: ---| Changed API getUtlFileDir to use alias for view v$parameter |

31: ---| directive. Removed restriction to 11i version to allow |
32: ---| back-porting. |
33: ---| |
34: ---| 16-sep-03 smulye |
35: ---| Changed API getUtlFileDir to use alias for view v$parameter |
36: ---| Bug 2860354 |
37: ---| 06-Nov-03 smulye |
38: ---| Changed API checkWhereClause to handle the situation when where |
39: ---| cluase is null. |

Line 140: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';

136: l_dummy NUMBER;
137:
138: BEGIN
139: SELECT param.value into l_dir
140: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';
141:
142: l_log_begin := INSTR(l_dir, '/log');
143:
144: IF (l_log_begin = 0) THEN /* then get the first string */