APPS.JAI_PO_TAX_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 2171: lv_conc_name fnd_concurrent_programs.concurrent_program_name%type ;

2167: v_errbuf VARCHAR2(1996);
2168: v_retcode VARCHAR2(1996);
2169:
2170: lv_app_name fnd_application.application_short_name%type ;
2171: lv_conc_name fnd_concurrent_programs.concurrent_program_name%type ;
2172:
2173: v_rowid ROWID;
2174: error_from_called_unit EXCEPTION;
2175: v_error_mesg VARCHAR2(1996);

Line 2189: FROM fnd_concurrent_programs a, fnd_application b

2185: WHERE line_location_id = p_line_location_id;
2186:
2187: CURSOR c_enable_trace IS
2188: SELECT enable_trace
2189: FROM fnd_concurrent_programs a, fnd_application b
2190: WHERE b.application_short_name = lv_app_name --'PO'
2191: AND b.application_id = a.application_id
2192: AND a.concurrent_program_name = lv_conc_name; --'JAINPOTD';/* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2193:

Line 2202: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;

2198:
2199: CURSOR get_dbname IS
2200: SELECT name FROM v$database;
2201:
2202: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;
2203: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2204: sid V$SESSION.SID%TYPE;
2205: serial V$SESSION.SERIAL#%TYPE;
2206: spid V$PROCESS.SPID%TYPE;