[Home] [Help]
882: FOR usages IN ftcu(l_new_surrogate_key) LOOP
883:
884: BEGIN
885:
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,
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;
1755:
1756: delete from ff_formulas_f
1757: where formula_id = r_distinct.c_surrogate_key;
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
2282: where route_parameter_id in (
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
2725: set business_group_id = all_user_entities.business_group_id
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;
2976:
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
4764: -- associated with this global bug 3744555