DBA Data[Home] [Help]

APPS.FNDCP_CRM dependencies on FND_CONFLICTS_DOMAIN

Line 287: from fnd_conflicts_domain

283:
284: begin -- select block
285: select cd_id
286: into cdid
287: from fnd_conflicts_domain
288: where cd_name = cdname;
289:
290: exception
291: when no_data_found then

Line 293: select fnd_conflicts_domain_s.nextval

289:
290: exception
291: when no_data_found then
292: begin -- insert block
293: select fnd_conflicts_domain_s.nextval
294: into cdid
295: from sys.dual;
296:
297: insert

Line 298: into fnd_conflicts_domain (

294: into cdid
295: from sys.dual;
296:
297: insert
298: into fnd_conflicts_domain (
299: cd_id,
300: cd_name,
301: user_cd_name,
302: runalone_flag,

Line 342: from fnd_conflicts_domain

338:
339: when dup_val_on_index then
340: select cd_id
341: into cdid
342: from fnd_conflicts_domain
343: where cd_name = cdname;
344:
345:
346: when others then

Line 375: delete from fnd_conflicts_domain fcd

371: --
372: procedure purge_dynamic_domains is
373: begin
374:
375: delete from fnd_conflicts_domain fcd
376: where dynamic = 'Y'
377: and not exists (select 'X'
378: from fnd_concurrent_requests fcr
379: where fcr.cd_id = fcd.cd_id