DBA Data[Home] [Help]

APPS.FNDCP_CRM dependencies on FND_CONFLICTS_DOMAIN

Line 289: from fnd_conflicts_domain

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

Line 295: select fnd_conflicts_domain_s.nextval

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

Line 300: into fnd_conflicts_domain (

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,

Line 344: from fnd_conflicts_domain

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

Line 377: delete from fnd_conflicts_domain fcd

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