DBA Data[Home] [Help]

APPS.FFDICT dependencies on FF_CONTEXTS

Line 1354: -- Check if there any rows in FF_CONTEXTS for this name

1350: dummy varchar2(1);
1351: begin
1352: -- set error tracking information
1353: hr_utility.set_location('ffdict.will_clash_with_context',1);
1354: -- Check if there any rows in FF_CONTEXTS for this name
1355: --
1356: select 'X' into dummy from dual where exists
1357: (select null from ff_contexts where context_name = upper(p_item_name));
1358: --

Line 1357: (select null from ff_contexts where context_name = upper(p_item_name));

1353: hr_utility.set_location('ffdict.will_clash_with_context',1);
1354: -- Check if there any rows in FF_CONTEXTS for this name
1355: --
1356: select 'X' into dummy from dual where exists
1357: (select null from ff_contexts where context_name = upper(p_item_name));
1358: --
1359: -- Exception not raised, so item is a context - return TRUE.
1360: return TRUE;
1361: exception

Line 2494: ff_contexts c

2490: where exists
2491: (
2492: select null from ff_formulas_f a,
2493: ff_fdi_usages_f b,
2494: ff_contexts c
2495: where a.formula_type_id = p_ftype_id
2496: and a.formula_id = b.formula_id
2497: and b.item_name = upper(c.context_name)
2498: and c.context_id = p_context_id