APPS.FF_DATA_DICT dependencies on FF_DATABASE_ITEMS

Line 2213: from ff_database_items fdbi,

2209: cursor c_form3(p_route_id number) is
2210: select distinct ffu.formula_id fid
2211: from ff_fdi_usages_f ffu
2212: where ffu.item_name in (select fdbi.user_name
2213: from ff_database_items fdbi,
2214: ff_user_entities fue
2215: where fdbi.user_entity_id = fue.user_entity_id
2216: and fue.route_id = p_route_id);
2217:

Line 2696: from ff_database_items

2692: data_type,
2693: definition_text,
2694: null_allowed_flag,
2695: description
2696: from ff_database_items
2697: where user_entity_id = v_user_entity_id)
2698: or exists
2699: (select value
2700: from hr_s_route_parameter_values

Line 2744: from ff_database_items fdbi

2740: cursor c_form(p_ue_id number) is
2741: select distinct fue.formula_id fid
2742: from ff_fdi_usages_f fue
2743: where fue.item_name in (select fdbi.user_name
2744: from ff_database_items fdbi
2745: where fdbi.user_entity_id = p_ue_id);
2746:
2747: BEGIN
2748:

Line 2843: update ff_database_items

2839: FOR all_db_items IN
2840: db_item(all_user_entities.user_entity_id)
2841: LOOP
2842:
2843: update ff_database_items
2844: set data_type = all_db_items.data_type
2845: ,definition_text = all_db_items.definition_text
2846: ,null_allowed_flag = all_db_items.null_allowed_flag
2847: ,description = all_db_items.description

Line 2859: insert into ff_database_items

2855:
2856: IF SQL%NOTFOUND THEN
2857:
2858: BEGIN
2859: insert into ff_database_items
2860: (user_name
2861: ,user_entity_id
2862: ,data_type
2863: ,definition_text

Line 2887: hr_utility.trace('ins ff_database_items');

2883: ,all_db_items.creation_date
2884: );
2885: EXCEPTION WHEN OTHERS THEN
2886: hr_legislation.hrrunprc_trace_on;
2887: hr_utility.trace('ins ff_database_items');
2888: hr_utility.trace('dbi user_name ' ||
2889: all_db_items.user_name);
2890: hr_utility.trace('user_entity_id ' ||
2891: to_char(all_db_items.user_entity_id));

Line 3000: ff_database_items fdbi,

2996: select /*+ LEADING (FUE,FDBI) */
2997: distinct formula_id fid
2998: from
2999: ff_user_entities fue,
3000: ff_database_items fdbi,
3001: ff_fdi_usages_f fdi
3002: where fdi.item_name = fdbi.user_name
3003: and fdbi.user_entity_id = fue.user_entity_id
3004: and fue.route_id = p_route_id;

Line 4374: from ff_database_items fdbi,

4370: -- affected by these dbi removals.
4371: select distinct ffu.formula_id fid
4372: from ff_fdi_usages_f ffu
4373: where ffu.item_name in (select fdbi.user_name
4374: from ff_database_items fdbi,
4375: ff_user_entities ffue
4376: where fdbi.user_entity_id = ffue.user_entity_id
4377: and ffue.creator_id = p_global_id
4378: and ffue.creator_type = 'S');

Line 4794: ff_database_items d,

4790: where global_id = l_new_global_id
4791: ))
4792: and exists (select distinct null
4793: from ff_user_entities u,
4794: ff_database_items d,
4795: ff_route_parameters rp,
4796: ff_route_parameter_values rpv
4797: where u.user_entity_name = global_name || '_GLOBAL_UE'
4798: and u.user_entity_id = rpv.user_entity_id