DBA Data[Home] [Help]

APPS.FND_REQUEST_SET dependencies on FND_RUN_REQUESTS

Line 175: from fnd_run_requests r,

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
178: and fcr1.parent_request_id = fcr2.request_id
179: and fcr1.concurrent_program_id = r.concurrent_program_id

Line 427: from fnd_request_set_programs sp, fnd_run_requests r,

423: argument81, argument82, argument83, argument84, argument85,
424: argument86, argument87, argument88, argument89, argument90,
425: argument91, argument92, argument93, argument94, argument95,
426: argument96, argument97, argument98, argument99, argument100, r.org_id
427: from fnd_request_set_programs sp, fnd_run_requests r,
428: fnd_concurrent_programs cp, fnd_application a
429: where sp.set_application_id = appl_id
430: and sp.request_set_id = set_id
431: and sp.request_set_stage_id = stage_id

Line 479: from fnd_request_set_programs sp, fnd_run_requests r,

475: r.argument81, r.argument82, r.argument83, r.argument84, r.argument85,
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

Line 795: -- set the request_id in fnd_run_requests so that

791: retcode := 2;
792: return;
793: end if;
794:
795: -- set the request_id in fnd_run_requests so that
796: -- we can identify the failed request later if we
797: -- restart this stage.
798: UPDATE fnd_run_requests
799: SET request_id = req_id

Line 798: UPDATE fnd_run_requests

794:
795: -- set the request_id in fnd_run_requests so that
796: -- we can identify the failed request later if we
797: -- restart this stage.
798: UPDATE fnd_run_requests
799: SET request_id = req_id
800: WHERE request_set_program_id = req.request_set_program_id
801: AND application_id = req.application_id
802: AND concurrent_program_id = req.concurrent_program_id