[Home] [Help]
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
179: and fcr1.parent_request_id = fcr2.request_id
180: and fcr1.concurrent_program_id = r.concurrent_program_id
421: argument81, argument82, argument83, argument84, argument85,
422: argument86, argument87, argument88, argument89, argument90,
423: argument91, argument92, argument93, argument94, argument95,
424: argument96, argument97, argument98, argument99, argument100, r.org_id
425: from fnd_request_set_programs sp, fnd_run_requests r,
426: fnd_concurrent_programs cp, fnd_application a
427: where sp.set_application_id = appl_id
428: and sp.request_set_id = set_id
429: and sp.request_set_stage_id = stage_id
473: r.argument81, r.argument82, r.argument83, r.argument84, r.argument85,
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
755: retcode := 2;
756: return;
757: end if;
758:
759: -- set the request_id in fnd_run_requests so that
760: -- we can identify the failed request later if we
761: -- restart this stage.
762: UPDATE fnd_run_requests
763: SET request_id = req_id
758:
759: -- set the request_id in fnd_run_requests so that
760: -- we can identify the failed request later if we
761: -- restart this stage.
762: UPDATE fnd_run_requests
763: SET request_id = req_id
764: WHERE request_set_program_id = req.request_set_program_id
765: AND application_id = req.application_id
766: AND concurrent_program_id = req.concurrent_program_id