[Home] [Help]
886: delete ff_compiled_info_f f
887: where f.formula_id in (
888: select distinct a.formula_id
889: from ff_formulas_f a,
890: ff_fdi_usages_f b,
891: ff_contexts c
892: where a.formula_type_id = stu_rec.c_surrogate_key
893: and a.formula_id = b.formula_id
894: and b.item_name = upper(c.context_name)
894: and b.item_name = upper(c.context_name)
895: and c.context_id = usages.context_id
896: and b.usage = 'U');
897:
898: delete ff_fdi_usages_f f
899: where f.formula_id in (
900: select distinct a.formula_id
901: from ff_formulas_f a,
902: ff_fdi_usages_f b,
898: delete ff_fdi_usages_f f
899: where f.formula_id in (
900: select distinct a.formula_id
901: from ff_formulas_f a,
902: ff_fdi_usages_f b,
903: ff_contexts c
904: where a.formula_type_id = stu_rec.c_surrogate_key
905: and a.formula_id = b.formula_id
906: and b.item_name = upper(c.context_name)
1746: if not formula_changed(r_distinct.c_surrogate_key) then
1747: remove(r_distinct.c_surrogate_key);
1748: else
1749:
1750: delete from ff_fdi_usages_f
1751: where formula_id = r_distinct.c_surrogate_key;
1752:
1753: delete from ff_compiled_info_f
1754: where formula_id = r_distinct.c_surrogate_key;
2191: l_new_entity_id number(9);
2192:
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
2273: so as to avoid any constraint violations */
2274:
2275: /* bug 5501644 */
2276: for r_form3 in c_form3(l_new_surrogate_key) loop
2277: delete ff_fdi_usages_f where formula_id = r_form3.fid;
2278: delete ff_compiled_info_f where formula_id = r_form3.fid;
2279: end loop;
2280:
2281: delete ff_route_parameter_values
2697: -- If no user entities are to be installed then FALSE is returned.
2698:
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:
2716:
2717: -- delete all formula usages, compiled info that may be
2718: -- affected by this dbi
2719: for r_form in c_form(all_user_entities.user_entity_id) loop
2720: delete ff_fdi_usages_f where formula_id = r_form.fid;
2721: delete ff_compiled_info_f where formula_id = r_form.fid;
2722: end loop;
2723:
2724: update ff_user_entities
2951: ---------------------------------
2952: IS
2953:
2954: cursor c_form2(p_route_id number) is
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,
2953:
2954: cursor c_form2(p_route_id number) is
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
2967: -- delete all formula usages, compiled info that may be
2968: -- affected by this dbi
2969: for r_form2 in c_form2(stu_rec.c_surrogate_key) loop
2970:
2971: delete ff_fdi_usages_f where formula_id = r_form2.fid;
2972: delete ff_compiled_info_f where formula_id = r_form2.fid;
2973: end loop;
2974:
2975: END delete_route_form_usage;
4317: -- When deleting these UE, the BRD UE trigger potentially deletes
4318: -- database items. This trigger invalidates all formulae that can be
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
4755:
4756:
4757: for r_global in c_global_ad(r_distinct.c_surrogate_key)
4758: loop
4759: delete ff_fdi_usages_f where formula_id = r_global.fid;
4760: delete ff_compiled_info_f where formula_id = r_global.fid;
4761: end loop;
4762:
4763: -- Delete ff_route_parameter_values