[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)
1760: if not formula_changed(r_distinct.c_surrogate_key) then
1761: remove(r_distinct.c_surrogate_key);
1762: else
1763:
1764: delete from ff_fdi_usages_f
1765: where formula_id = r_distinct.c_surrogate_key;
1766:
1767: delete from ff_compiled_info_f
1768: where formula_id = r_distinct.c_surrogate_key;
2207: l_new_entity_id number(9);
2208:
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
2289: so as to avoid any constraint violations */
2290:
2291: /* bug 5501644 */
2292: for r_form3 in c_form3(l_new_surrogate_key) loop
2293: delete ff_fdi_usages_f where formula_id = r_form3.fid;
2294: delete ff_compiled_info_f where formula_id = r_form3.fid;
2295: end loop;
2296:
2297: delete ff_route_parameter_values
2738: -- If no user entities are to be installed then FALSE is returned.
2739:
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:
2757:
2758: -- delete all formula usages, compiled info that may be
2759: -- affected by this dbi
2760: for r_form in c_form(all_user_entities.user_entity_id) loop
2761: delete ff_fdi_usages_f where formula_id = r_form.fid;
2762: delete ff_compiled_info_f where formula_id = r_form.fid;
2763: end loop;
2764:
2765: update ff_user_entities
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;
3005:
3007: -- delete all formula usages, compiled info that may be
3008: -- affected by this dbi
3009: for r_form2 in c_form2(stu_rec.c_surrogate_key) loop
3010:
3011: delete ff_fdi_usages_f where formula_id = r_form2.fid;
3012: delete ff_compiled_info_f where formula_id = r_form2.fid;
3013: end loop;
3014:
3015: END delete_route_form_usage;
4368: -- When deleting these UE, the BRD UE trigger potentially deletes
4369: -- database items. This trigger invalidates all formulae that can be
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
4806:
4807:
4808: for r_global in c_global_ad(r_distinct.c_surrogate_key)
4809: loop
4810: delete ff_fdi_usages_f where formula_id = r_global.fid;
4811: delete ff_compiled_info_f where formula_id = r_global.fid;
4812: end loop;
4813:
4814: -- Delete ff_route_parameter_values