[Home] [Help]
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;
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;
143: conc_app_name fnd_application_vl.application_name%TYPE;
144: tmp_id NUMBER(15);
145: tmp_status fnd_concurrent_requests.status_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;
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);
154: rclass_name fnd_concurrent_request_class.request_class_name%TYPE;
171: run_alone boolean;
172: reqlimit boolean := FALSE;
173: mgrname fnd_concurrent_queues_vl.user_concurrent_queue_name%TYPE;
174: filename VARCHAR2(255);
175: qcf fnd_concurrent_programs.queue_control_flag%TYPE;
176: req_notfound
177:
178: EXCEPTION;
179:
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;
360: EXCEPTION
361: WHEN no_data_found THEN
362: SELECT queue_control_flag
363: INTO qcf
364: FROM fnd_concurrent_programs
365: WHERE concurrent_program_id = reqinfo.concurrent_program_id
366: AND application_id = reqinfo.program_application_id;
367:
368: IF qcf = 'Y' THEN
434:
435: -- Paused, check and see if it is a request set, and if its children are running
436: SELECT nvl(concurrent_program_name, 'UNKNOWN')
437: INTO conc_prog_name
438: FROM fnd_concurrent_programs
439: WHERE concurrent_program_id = reqinfo.concurrent_program_id;
440:
441: note := jtf_diag_report_factory.create_note('A Running/Paused request is waiting on one or more child requests to complete.', reportcontext);
442: inner_section.add_note(note);
486:
487: -- could be a queue control request
488: SELECT queue_control_flag
489: INTO qcf
490: FROM fnd_concurrent_programs
491: WHERE concurrent_program_id = reqinfo.concurrent_program_id
492: AND application_id = reqinfo.program_application_id;
493:
494: IF qcf = 'Y' THEN
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'
738: AND fcr.cd_id = reqinfo.cd_id;