DBA Data[Home] [Help]

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 212: Delete from fnd_concurrent_requests

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

Line 216: Delete from fnd_concurrent_requests

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