DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 259: CURSOR c_enable_trace(cp_conc_name fnd_concurrent_programs.concurrent_program_name%type) IS

255:
256: --//~~~~~~~~ Declaration Section for Trace and Log files ~~~~~~~~~~//
257: -- used for trace
258:
259: CURSOR c_enable_trace(cp_conc_name fnd_concurrent_programs.concurrent_program_name%type) IS
260: SELECT enable_trace
261: FROM fnd_concurrent_programs a, fnd_application b
262: WHERE b.application_short_name = 'PO'
263: AND b.application_id = a.application_id

Line 261: FROM fnd_concurrent_programs a, fnd_application b

257: -- used for trace
258:
259: CURSOR c_enable_trace(cp_conc_name fnd_concurrent_programs.concurrent_program_name%type) IS
260: SELECT enable_trace
261: FROM fnd_concurrent_programs a, fnd_application b
262: WHERE b.application_short_name = 'PO'
263: AND b.application_id = a.application_id
264: AND a.concurrent_program_name = cp_conc_name; --'JAINMTCH';
265:

Line 288: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;

284: */
285:
286: -- v_debug CHAR(1) := p_debug; -- 'Y';
287: v_debug BOOLEAN; -- := FALSE; --Ramananda for File.Sql.35
288: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
289:
290:
291: -- used for log file Generation
292: v_log_file_name VARCHAR2(50); -- := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log'; --Ramananda for File.Sql.35