APPS.JAI_RCV_RND_PKG dependencies on V$SESSION

Line 106: v_sid v$session.sid%type;

102: -- 0 => RMIN Items, 1 => CGIN Items, 2 => Both RMIN and CGIN items
103: v_rounding_type NUMBER(1);
104:
105: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
106: v_sid v$session.sid%type;
107: v_serial v$session.serial#%type;
108: v_spid v$process.spid%type;
109: v_name1 v$database.name%type;
110:

Line 107: v_serial v$session.serial#%type;

103: v_rounding_type NUMBER(1);
104:
105: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
106: v_sid v$session.sid%type;
107: v_serial v$session.serial#%type;
108: v_spid v$process.spid%type;
109: v_name1 v$database.name%type;
110:
111: CURSOR c_enable_trace(cp_conc_pname fnd_concurrent_programs.concurrent_program_name%type) IS

Line 118: FROM v$session a, v$process b

114: WHERE concurrent_program_name = cp_conc_pname ; --'JAINRGRND';
115:
116: CURSOR get_audsid IS
117: SELECT a.sid, a.serial#, b.spid
118: FROM v$session a, v$process b
119: WHERE audsid = userenv('SESSIONID')
120: AND a.paddr = b.addr;
121:
122: CURSOR get_dbname IS SELECT name FROM v$database;