285:
286: begin -- select block
287: select cd_id
288: into cdid
289: from fnd_conflicts_domain
290: where cd_name = cdname;
291:
292: exception
293: when no_data_found then
291:
292: exception
293: when no_data_found then
294: begin -- insert block
295: select fnd_conflicts_domain_s.nextval
296: into cdid
297: from sys.dual;
298:
299: insert
296: into cdid
297: from sys.dual;
298:
299: insert
300: into fnd_conflicts_domain (
301: cd_id,
302: cd_name,
303: user_cd_name,
304: runalone_flag,
340:
341: when dup_val_on_index then
342: select cd_id
343: into cdid
344: from fnd_conflicts_domain
345: where cd_name = cdname;
346:
347:
348: when others then
373: --
374: procedure purge_dynamic_domains is
375: begin
376:
377: delete from fnd_conflicts_domain fcd
378: where dynamic = 'Y'
379: and not exists (select 'X'
380: from fnd_concurrent_requests fcr
381: where fcr.cd_id = fcd.cd_id