1114:
1115: CURSOR get_dbname IS
1116: SELECT name FROM v$database;
1117:
1118: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
1119: v_program_id FND_CONCURRENT_PROGRAMS.concurrent_program_id%TYPE;
1120: audsid NUMBER; -- := userenv('SESSIONID'); --Ramananda for File.Sql.35
1121: sid NUMBER;
1122: serial NUMBER;
1115: CURSOR get_dbname IS
1116: SELECT name FROM v$database;
1117:
1118: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
1119: v_program_id FND_CONCURRENT_PROGRAMS.concurrent_program_id%TYPE;
1120: audsid NUMBER; -- := userenv('SESSIONID'); --Ramananda for File.Sql.35
1121: sid NUMBER;
1122: serial NUMBER;
1123: spid VARCHAR2(9);