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_REQUEST_SET dependencies on FND_CONCURRENT_REQUESTS

Line 107: update FND_CONCURRENT_REQUESTS set RUN_NUMBER = 1 where request_id = conc_req_id;

103: /*Bug 5680669 -END-*/
104:
105: /* Is this the first run? */
106: if (req_data is null) then
107: update FND_CONCURRENT_REQUESTS set RUN_NUMBER = 1 where request_id = conc_req_id;
108: /* Get info for first stage. */
109: begin
110: select request_set_stage_id, request_set_stage_id, user_stage_name
111: into stage_id, next_stage, request_desc

Line 151: select REQUEST_DATE into req_request_date from FND_CONCURRENT_REQUESTS where REQUEST_ID = conc_req_id;

147: /* bug 1961715 Removed null as the 3rd parameter */
148: critical_outcome := substr(req_data, pos2 + 1);
149: if (runinfo_id = 'C') then
150: begin
151: select REQUEST_DATE into req_request_date from FND_CONCURRENT_REQUESTS where REQUEST_ID = conc_req_id;
152: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS sets
153: where REQUEST_SET_ID = set_id AND application_id = appl_id;
154: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages
155: WHERE request_set_id = set_id

Line 174: SELECT run_number INTO current_run_number FROM fnd_concurrent_requests WHERE request_id = conc_req_id;

170: exception
171: when no_data_found then
172: NULL;
173: end;
174: SELECT run_number INTO current_run_number FROM fnd_concurrent_requests WHERE request_id = conc_req_id;
175: select count(r.request_set_program_id) INTO tmp_number
176: from fnd_run_requests r,
177: fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2
178: where r.parent_request_id = conc_req_id

Line 177: fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2

173: end;
174: SELECT run_number INTO current_run_number FROM fnd_concurrent_requests WHERE request_id = conc_req_id;
175: select count(r.request_set_program_id) INTO tmp_number
176: from fnd_run_requests r,
177: fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2
178: where r.parent_request_id = conc_req_id
179: and fcr1.parent_request_id = fcr2.request_id
180: and fcr1.concurrent_program_id = r.concurrent_program_id
181: and r.request_id = fcr1.request_id

Line 205: update FND_CONCURRENT_REQUESTS set RUN_NUMBER = RUN_NUMBER + 1, COMPLETION_TEXT = null where request_id = conc_req_id;

201: retcode := 2;
202: return;
203: else
204: begin
205: update FND_CONCURRENT_REQUESTS set RUN_NUMBER = RUN_NUMBER + 1, COMPLETION_TEXT = null where request_id = conc_req_id;
206: critical_outcome := 'NONE';
207: restart_flag := 1;
208: runinfo_id := 'R';
209: stage_id := error_stage_id;

Line 230: from fnd_concurrent_requests

226: /* Get status for current stage */
227: begin
228: select decode(status_code, 'C', 'S', 'G', 'W', 'E')
229: into current_outcome
230: from fnd_concurrent_requests
231: where request_id = req_id;
232: exception
233: when NO_DATA_FOUND then
234: fnd_message.set_name('FND','CONC-Missing Request');

Line 352: update fnd_concurrent_requests set RUN_NUMBER =

348: errbuf := substr(fnd_message.get,1, 240);
349: retcode := 2;
350: return;
351: else
352: update fnd_concurrent_requests set RUN_NUMBER =
353: (select RUN_NUMBER from fnd_concurrent_requests where request_id = conc_req_id)
354: where request_id = req_id;
355: fnd_conc_global.set_req_globals(
356: conc_status => 'PAUSED',

Line 353: (select RUN_NUMBER from fnd_concurrent_requests where request_id = conc_req_id)

349: retcode := 2;
350: return;
351: else
352: update fnd_concurrent_requests set RUN_NUMBER =
353: (select RUN_NUMBER from fnd_concurrent_requests where request_id = conc_req_id)
354: where request_id = req_id;
355: fnd_conc_global.set_req_globals(
356: conc_status => 'PAUSED',
357: request_data => runinfo_id||','||to_char(error_stage_id)||','||substrb( to_char(next_stage) || ',' ||

Line 478: fnd_concurrent_programs cp, fnd_application a, fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2

474: r.argument86, r.argument87, r.argument88, r.argument89, r.argument90,
475: r.argument91, r.argument92, r.argument93, r.argument94, r.argument95,
476: r.argument96, r.argument97, r.argument98, r.argument99, r.argument100, r.org_id
477: from fnd_request_set_programs sp, fnd_run_requests r,
478: fnd_concurrent_programs cp, fnd_application a, fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2
479: where sp.set_application_id = appl_id
480: and sp.request_set_id = set_id
481: and sp.request_set_stage_id = stage_id
482: and sp.request_set_program_id = r.request_set_program_id

Line 500: from fnd_concurrent_requests

496: order by sp.sequence;
497:
498: cursor critical_outcomes (req_id number) is
499: select decode(status_code, 'C', 'S', 'G', 'W', 'E') outcome
500: from fnd_concurrent_requests
501: where parent_request_id = req_id
502: and critical = 'Y';
503:
504: cursor stage_req_printers(parent_req_id number, set_program_id number) is

Line 586: select run_number into run_number_var from fnd_concurrent_requests where request_id = parent_id;

582:
583: /* Is this the first run? */
584: if (req_data is null) then
585: begin
586: select run_number into run_number_var from fnd_concurrent_requests where request_id = parent_id;
587: if( restart_flag = 0) then
588: open stage_requests( appl_id, set_id, stage_id, parent_id);
589: else
590: open stage_requests_restart( appl_id, set_id, stage_id, parent_id,

Line 771: UPDATE fnd_concurrent_requests

767: AND parent_request_id = parent_id
768: AND set_application_id = appl_id
769: AND request_set_id = set_id;
770:
771: UPDATE fnd_concurrent_requests
772: SET RUN_NUMBER = run_number_var
773: WHERE request_id = req_id;
774:
775: has_reqs := TRUE;