eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_DIAG_REQUEST_ANALYZER dependencies on FND_CONCURRENT_REQUESTS

Line 137: reqinfo fnd_concurrent_requests % rowtype;

133: str_query VARCHAR2(2000);
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;

Line 145: tmp_status fnd_concurrent_requests.status_code%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;
147: conc_app_id fnd_concurrent_requests.program_application_id%TYPE;
148: conc_id fnd_concurrent_requests.concurrent_program_id%TYPE;
149: conc_cd_id fnd_concurrent_requests.cd_id%TYPE;

Line 147: conc_app_id fnd_concurrent_requests.program_application_id%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;
147: conc_app_id fnd_concurrent_requests.program_application_id%TYPE;
148: conc_id fnd_concurrent_requests.concurrent_program_id%TYPE;
149: conc_cd_id fnd_concurrent_requests.cd_id%TYPE;
150: v_enabled_flag fnd_concurrent_programs.enabled_flag%TYPE;
151: conflict_domain fnd_conflicts_domain.user_cd_name%TYPE;

Line 148: conc_id fnd_concurrent_requests.concurrent_program_id%TYPE;

144: tmp_id NUMBER(15);
145: tmp_status fnd_concurrent_requests.status_code%TYPE;
146: tmp_date DATE;
147: conc_app_id fnd_concurrent_requests.program_application_id%TYPE;
148: conc_id fnd_concurrent_requests.concurrent_program_id%TYPE;
149: conc_cd_id fnd_concurrent_requests.cd_id%TYPE;
150: v_enabled_flag fnd_concurrent_programs.enabled_flag%TYPE;
151: conflict_domain fnd_conflicts_domain.user_cd_name%TYPE;
152: parent_id NUMBER(15);

Line 149: conc_cd_id fnd_concurrent_requests.cd_id%TYPE;

145: tmp_status fnd_concurrent_requests.status_code%TYPE;
146: tmp_date DATE;
147: conc_app_id fnd_concurrent_requests.program_application_id%TYPE;
148: conc_id fnd_concurrent_requests.concurrent_program_id%TYPE;
149: conc_cd_id fnd_concurrent_requests.cd_id%TYPE;
150: v_enabled_flag fnd_concurrent_programs.enabled_flag%TYPE;
151: conflict_domain fnd_conflicts_domain.user_cd_name%TYPE;
152: parent_id NUMBER(15);
153: resp_name VARCHAR2(100);

Line 160: traid fnd_concurrent_requests.program_application_id%TYPE;

156: c_user fnd_user.user_name%TYPE;
157: last_user fnd_user.user_name%TYPE;
158: fcd_phase VARCHAR2(48);
159: fcd_status VARCHAR2(48);
160: traid fnd_concurrent_requests.program_application_id%TYPE;
161: trcpid fnd_concurrent_requests.concurrent_program_id%TYPE;
162: icount NUMBER;
163: ireqid fnd_concurrent_requests.request_id%TYPE;
164: pcode fnd_concurrent_requests.phase_code%TYPE;

Line 161: trcpid fnd_concurrent_requests.concurrent_program_id%TYPE;

157: last_user fnd_user.user_name%TYPE;
158: fcd_phase VARCHAR2(48);
159: fcd_status VARCHAR2(48);
160: traid fnd_concurrent_requests.program_application_id%TYPE;
161: trcpid fnd_concurrent_requests.concurrent_program_id%TYPE;
162: icount NUMBER;
163: ireqid fnd_concurrent_requests.request_id%TYPE;
164: pcode fnd_concurrent_requests.phase_code%TYPE;
165: scode fnd_concurrent_requests.status_code%TYPE;

Line 163: ireqid fnd_concurrent_requests.request_id%TYPE;

159: fcd_status VARCHAR2(48);
160: traid fnd_concurrent_requests.program_application_id%TYPE;
161: trcpid fnd_concurrent_requests.concurrent_program_id%TYPE;
162: icount NUMBER;
163: ireqid fnd_concurrent_requests.request_id%TYPE;
164: pcode fnd_concurrent_requests.phase_code%TYPE;
165: scode fnd_concurrent_requests.status_code%TYPE;
166: live_child boolean;
167: mgr_defined boolean;

Line 164: pcode fnd_concurrent_requests.phase_code%TYPE;

160: traid fnd_concurrent_requests.program_application_id%TYPE;
161: trcpid fnd_concurrent_requests.concurrent_program_id%TYPE;
162: icount NUMBER;
163: ireqid fnd_concurrent_requests.request_id%TYPE;
164: pcode fnd_concurrent_requests.phase_code%TYPE;
165: scode fnd_concurrent_requests.status_code%TYPE;
166: live_child boolean;
167: mgr_defined boolean;
168: mgr_active boolean;

Line 165: scode fnd_concurrent_requests.status_code%TYPE;

161: trcpid fnd_concurrent_requests.concurrent_program_id%TYPE;
162: icount NUMBER;
163: ireqid fnd_concurrent_requests.request_id%TYPE;
164: pcode fnd_concurrent_requests.phase_code%TYPE;
165: scode fnd_concurrent_requests.status_code%TYPE;
166: live_child boolean;
167: mgr_defined boolean;
168: mgr_active boolean;
169: mgr_workshift boolean;

Line 184: FROM fnd_concurrent_requests

180: CURSOR c_wait IS
181: SELECT request_id,
182: phase_code,
183: status_code
184: FROM fnd_concurrent_requests
185: WHERE parent_request_id = p_req_id;
186: CURSOR c_inc IS
187: SELECT to_run_application_id,
188: to_run_concurrent_program_id

Line 196: FROM fnd_concurrent_requests

192: CURSOR c_ireqs IS
193: SELECT request_id,
194: phase_code,
195: status_code
196: FROM fnd_concurrent_requests
197: WHERE phase_code = 'R'
198: AND program_application_id = traid
199: AND concurrent_program_id = trcpid
200: AND cd_id = conc_cd_id;

Line 206: FROM fnd_concurrent_requests

202: SELECT request_id,
203: to_char(requested_start_date, 'DD-MON-RR HH24:MI:SS') start_date,
204: phase_code,
205: status_code
206: FROM fnd_concurrent_requests
207: WHERE phase_code IN('R', 'P')
208: AND requested_by = uid
209: AND requested_start_date < s
210: AND hold_flag = 'N';

Line 230: FROM fnd_concurrent_requests

226:
227: BEGIN
228: SELECT *
229: INTO reqinfo
230: FROM fnd_concurrent_requests
231: WHERE request_id = p_req_id;
232:
233: EXCEPTION
234: WHEN no_data_found THEN

Line 247: fnd_concurrent_requests fcr

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;
251:

Line 255: fnd_concurrent_requests fcr

251:
252: SELECT nvl(application_name, '-- UNKNOWN APPLICATION --')
253: INTO conc_app_name
254: FROM fnd_application_vl fvl,
255: fnd_concurrent_requests fcr
256: WHERE fcr.request_id = p_req_id
257: AND fcr.program_application_id = fvl.application_id;
258:
259: SELECT nvl(meaning, 'UNKNOWN')

Line 619: FROM fnd_concurrent_requests

615: cd_id
616: INTO conc_app_id,
617: conc_id,
618: conc_cd_id
619: FROM fnd_concurrent_requests
620: WHERE request_id = p_req_id;
621:
622: icount := 0;
623: FOR progs IN c_inc

Line 733: FROM fnd_concurrent_requests fcr,

729: actual_start_date
730: INTO tmp_id,
731: tmp_status,
732: tmp_date
733: FROM fnd_concurrent_requests fcr,
734: fnd_concurrent_programs fcp
735: WHERE fcp.run_alone_flag = 'Y'
736: AND fcp.concurrent_program_id = fcr.concurrent_program_id
737: AND fcr.phase_code = 'R'