APPS.FF_DATA_DICT dependencies on FF_DATABASE_ITEMS

Line 2197: from ff_database_items fdbi,

2193: cursor c_form3(p_route_id number) is
2194: select distinct ffu.formula_id fid
2195: from ff_fdi_usages_f ffu
2196: where ffu.item_name in (select fdbi.user_name
2197: from ff_database_items fdbi,
2198: ff_user_entities fue
2199: where fdbi.user_entity_id = fue.user_entity_id
2200: and fue.route_id = p_route_id);
2201:

Line 2655: from ff_database_items

2651: data_type,
2652: definition_text,
2653: null_allowed_flag,
2654: description
2655: from ff_database_items
2656: where user_entity_id = v_user_entity_id)
2657: or exists
2658: (select value
2659: from hr_s_route_parameter_values

Line 2703: from ff_database_items fdbi

2699: cursor c_form(p_ue_id number) is
2700: select distinct fue.formula_id fid
2701: from ff_fdi_usages_f fue
2702: where fue.item_name in (select fdbi.user_name
2703: from ff_database_items fdbi
2704: where fdbi.user_entity_id = p_ue_id);
2705:
2706: BEGIN
2707:

Line 2802: update ff_database_items

2798: FOR all_db_items IN
2799: db_item(all_user_entities.user_entity_id)
2800: LOOP
2801:
2802: update ff_database_items
2803: set data_type = all_db_items.data_type
2804: ,definition_text = all_db_items.definition_text
2805: ,null_allowed_flag = all_db_items.null_allowed_flag
2806: ,description = all_db_items.description

Line 2818: insert into ff_database_items

2814:
2815: IF SQL%NOTFOUND THEN
2816:
2817: BEGIN
2818: insert into ff_database_items
2819: (user_name
2820: ,user_entity_id
2821: ,data_type
2822: ,definition_text

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

2842: ,all_db_items.creation_date
2843: );
2844: EXCEPTION WHEN OTHERS THEN
2845: hr_legislation.hrrunprc_trace_on;
2846: hr_utility.trace('ins ff_database_items');
2847: hr_utility.trace('dbi user_name ' ||
2848: all_db_items.user_name);
2849: hr_utility.trace('user_entity_id ' ||
2850: to_char(all_db_items.user_entity_id));

Line 2959: from ff_database_items fdbi,

2955: select /*+ INDEX(ffu FF_FDI_USAGES_F_N50)*/
2956: distinct ffu.formula_id fid
2957: from ff_fdi_usages_f ffu
2958: where ffu.item_name in (select fdbi.user_name
2959: from ff_database_items fdbi,
2960: ff_user_entities fue,
2961: ff_routes fr
2962: where fdbi.user_entity_id = fue.user_entity_id
2963: and fue.route_id = fr.route_id

Line 4323: from ff_database_items fdbi,

4319: -- affected by these dbi removals.
4320: select distinct ffu.formula_id fid
4321: from ff_fdi_usages_f ffu
4322: where ffu.item_name in (select fdbi.user_name
4323: from ff_database_items fdbi,
4324: ff_user_entities ffue
4325: where fdbi.user_entity_id = ffue.user_entity_id
4326: and ffue.creator_id = p_global_id
4327: and ffue.creator_type = 'S');

Line 4743: ff_database_items d,

4739: where global_id = l_new_global_id
4740: ))
4741: and exists (select distinct null
4742: from ff_user_entities u,
4743: ff_database_items d,
4744: ff_route_parameters rp,
4745: ff_route_parameter_values rpv
4746: where u.user_entity_name = global_name || '_GLOBAL_UE'
4747: and u.user_entity_id = rpv.user_entity_id