APPS.GMD_COA_DATA_OM_NEW dependencies on V$PARAMETER

Line 2312: FROM v$parameter

2308: l_file_name VARCHAR2(10) := 'GMDLOG.txt';
2309:
2310: CURSOR c_get_1st_location IS
2311: SELECT NVL( SUBSTR( value, 1, INSTR( value, ',')-1), value)
2312: FROM v$parameter
2313: WHERE name = 'utl_file_dir';
2314:
2315: BEGIN
2316:

Line 2348: FROM v$parameter

2344: PROCEDURE PrintLn( p_msg IN VARCHAR2 ) IS
2345:
2346: CURSOR get_log_file_location IS
2347: SELECT NVL( SUBSTR( value, 1, instr( value, ',')-1), value)
2348: FROM v$parameter
2349: WHERE name = 'utl_file_dir';
2350:
2351:
2352: l_log UTL_FILE.file_type;