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 106: update FND_CONCURRENT_REQUESTS set RUN_NUMBER = 1 where request_id = conc_req_id;

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

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

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

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

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

Line 176: fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2

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

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

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

Line 229: from fnd_concurrent_requests

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

Line 354: update fnd_concurrent_requests set RUN_NUMBER =

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

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

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

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

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

Line 502: from fnd_concurrent_requests

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

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

593:
594: /* Is this the first run? */
595: if (req_data is null) then
596: begin
597: select run_number into run_number_var from fnd_concurrent_requests where request_id = parent_id;
598: if( restart_flag = 0) then
599: open stage_requests( appl_id, set_id, stage_id, parent_id);
600: else
601: open stage_requests_restart( appl_id, set_id, stage_id, parent_id,

Line 807: UPDATE fnd_concurrent_requests

803: AND parent_request_id = parent_id
804: AND set_application_id = appl_id
805: AND request_set_id = set_id;
806:
807: UPDATE fnd_concurrent_requests
808: SET RUN_NUMBER = run_number_var
809: WHERE request_id = req_id;
810:
811: has_reqs := TRUE;