APPS.JAI_PO_TAX_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 2892: lv_conc_name fnd_concurrent_programs.concurrent_program_name%type ;

2888: v_errbuf VARCHAR2(1996);
2889: v_retcode VARCHAR2(1996);
2890:
2891: lv_app_name fnd_application.application_short_name%type ;
2892: lv_conc_name fnd_concurrent_programs.concurrent_program_name%type ;
2893:
2894: v_rowid ROWID;
2895: error_from_called_unit EXCEPTION;
2896: v_error_mesg VARCHAR2(1996);

Line 2910: FROM fnd_concurrent_programs a, fnd_application b

2906: WHERE line_location_id = p_line_location_id;
2907:
2908: CURSOR c_enable_trace IS
2909: SELECT enable_trace
2910: FROM fnd_concurrent_programs a, fnd_application b
2911: WHERE b.application_short_name = lv_app_name --'PO'
2912: AND b.application_id = a.application_id
2913: AND a.concurrent_program_name = lv_conc_name; --'JAINPOTD';/* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2914:

Line 2923: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;

2919:
2920: CURSOR get_dbname IS
2921: SELECT name FROM v$database;
2922:
2923: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;
2924: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2925: sid V$SESSION.SID%TYPE;
2926: serial V$SESSION.SERIAL#%TYPE;
2927: spid V$PROCESS.SPID%TYPE;