APPS.JAI_RCV_RND_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 105: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;

101: -- Following values are used for the below variable
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;

Line 111: CURSOR c_enable_trace(cp_conc_pname fnd_concurrent_programs.concurrent_program_name%type) IS

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
112: SELECT enable_trace
113: FROM fnd_concurrent_programs
114: WHERE concurrent_program_name = cp_conc_pname ; --'JAINRGRND';
115:

Line 113: FROM fnd_concurrent_programs

109: v_name1 v$database.name%type;
110:
111: CURSOR c_enable_trace(cp_conc_pname fnd_concurrent_programs.concurrent_program_name%type) IS
112: SELECT enable_trace
113: FROM fnd_concurrent_programs
114: WHERE concurrent_program_name = cp_conc_pname ; --'JAINRGRND';
115:
116: CURSOR get_audsid IS
117: SELECT a.sid, a.serial#, b.spid