APPS.FND_CONC_CLONE dependencies on FND_CONCURRENT_REQUESTS

Line 169: ' from fnd_concurrent_requests fcr ' ||

165: -- This column exists from 11.5.9 onwards.
166: execute immediate 'delete from fnd_conflicts_domain fcd ' ||
167: ' where dynamic = ''Y''' ||
168: ' and not exists (select ''X''' ||
169: ' from fnd_concurrent_requests fcr ' ||
170: ' where fcr.cd_id = fcd.cd_id ' ||
171: ' and phase_code in (''P'', ''R''))';
172:
173:

Line 213: Delete from fnd_concurrent_requests

209: enable_trace = 'N'
210: where printer_name is not null or enable_trace = 'Y';
211:
212: -- Delete All completed/running Concurrent Requests
213: Delete from fnd_concurrent_requests
214: where phase_code in ('C', 'R');
215:
216: -- Delete all pending Oracle Report requests
217: Delete from fnd_concurrent_requests

Line 217: Delete from fnd_concurrent_requests

213: Delete from fnd_concurrent_requests
214: where phase_code in ('C', 'R');
215:
216: -- Delete all pending Oracle Report requests
217: Delete from fnd_concurrent_requests
218: where phase_code = 'P'
219: and (PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID) in
220: (select application_id, concurrent_program_id
221: from fnd_concurrent_programs

Line 414: from fnd_concurrent_requests fcr

410: -- Delete from FND_CONFLICTS_DOMAIN table
411: Delete from fnd_conflicts_domain fcd
412: where dynamic = 'Y'
413: and not exists (select 'X'
414: from fnd_concurrent_requests fcr
415: where fcr.cd_id = fcd.cd_id
416: and phase_code in ('P', 'R'));
417:
418: -- Reset FND_CONCURRENT_QUEUES table