[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,
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;
1769:
1770: delete from ff_formulas_f
1771: where formula_id = r_distinct.c_surrogate_key;
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
2298: where route_parameter_id in (
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
2766: set business_group_id = all_user_entities.business_group_id
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;
3016:
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
4815: -- associated with this global bug 3744555