[Home] [Help]
155: AND SET_APPLICATION_ID = appl_id;
156: IF( tmpDate > rset_last_updated_date) THEN
157: rset_last_updated_date := tmpDate;
158: END IF;
159: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_programs
160: WHERE request_set_id = set_id AND set_application_id = appl_id;
161: IF( tmpDate > rset_last_updated_date) THEN
162: rset_last_updated_date := tmpDate;
163: END IF;
184: and error_stage_id = to_number(fcr2.argument3)
185: AND r.request_set_program_id IS NOT NULL
186: AND r.request_set_program_id NOT IN
187: (
188: SELECT REQUEST_SET_PROGRAM_ID FROM FND_REQUEST_SET_PROGRAMS WHERE SET_APPLICATION_ID = appl_id
189: AND REQUEST_SET_ID = set_id AND REQUEST_SET_STAGE_ID = error_stage_id
190: );
191: if( tmp_number <> 0)THEN
192: errbuf := gen_error('FNDRSSUB', SQLCODE, 'Request Set Definition Changed');
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
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