APPS.GMD_COA_DATA_OM_NEW dependencies on V$PARAMETER

Line 1957: FROM v$parameter

1953: l_file_name VARCHAR2(10) := 'GMDLOG.txt';
1954:
1955: CURSOR c_get_1st_location IS
1956: SELECT NVL( SUBSTR( value, 1, INSTR( value, ',')-1), value)
1957: FROM v$parameter
1958: WHERE name = 'utl_file_dir';
1959:
1960: BEGIN
1961:

Line 1993: FROM v$parameter

1989: PROCEDURE PrintLn( p_msg IN VARCHAR2 ) IS
1990:
1991: CURSOR get_log_file_location IS
1992: SELECT NVL( SUBSTR( value, 1, instr( value, ',')-1), value)
1993: FROM v$parameter
1994: WHERE name = 'utl_file_dir';
1995:
1996:
1997: l_log UTL_FILE.file_type;