APPS.FND_DIAG_REQUEST_ANALYZER dependencies on FND_CONCURRENT_PROGRAMS_VL

Line 138: proginfo fnd_concurrent_programs_vl % rowtype;

134: str VARCHAR2(2000);
135: -- CP Request Analyser
136: p_req_id NUMBER;
137: reqinfo fnd_concurrent_requests % rowtype;
138: proginfo fnd_concurrent_programs_vl % rowtype;
139: c_status fnd_lookups.meaning%TYPE;
140: m_buf fnd_lookups.meaning%TYPE;
141: conc_prog_name fnd_concurrent_programs.concurrent_program_name%TYPE;
142: exe_method_code fnd_concurrent_programs_vl.execution_method_code%TYPE;

Line 142: exe_method_code fnd_concurrent_programs_vl.execution_method_code%TYPE;

138: proginfo fnd_concurrent_programs_vl % rowtype;
139: c_status fnd_lookups.meaning%TYPE;
140: m_buf fnd_lookups.meaning%TYPE;
141: conc_prog_name fnd_concurrent_programs.concurrent_program_name%TYPE;
142: exe_method_code fnd_concurrent_programs_vl.execution_method_code%TYPE;
143: conc_app_name fnd_application_vl.application_name%TYPE;
144: tmp_id NUMBER(15);
145: tmp_status fnd_concurrent_requests.status_code%TYPE;
146: tmp_date DATE;

Line 246: FROM fnd_concurrent_programs_vl fvl,

242: END;
243:
244: SELECT fvl.*
245: INTO proginfo
246: FROM fnd_concurrent_programs_vl fvl,
247: fnd_concurrent_requests fcr
248: WHERE fcr.request_id = p_req_id
249: AND fcr.concurrent_program_id = fvl.concurrent_program_id
250: AND fcr.program_application_id = fvl.application_id;