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