974:
975: CURSOR get_dbname IS
976: SELECT name FROM v$database;
977:
978: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
979: v_program_id FND_CONCURRENT_PROGRAMS.concurrent_program_id%TYPE;
980: audsid NUMBER; -- := userenv('SESSIONID'); --Ramananda for File.Sql.35
981: sid NUMBER;
982: serial NUMBER;
975: CURSOR get_dbname IS
976: SELECT name FROM v$database;
977:
978: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
979: v_program_id FND_CONCURRENT_PROGRAMS.concurrent_program_id%TYPE;
980: audsid NUMBER; -- := userenv('SESSIONID'); --Ramananda for File.Sql.35
981: sid NUMBER;
982: serial NUMBER;
983: spid VARCHAR2(9);