DBA Data[Home] [Help]

APPS.OZF_ACTMETRICFACT_PVT dependencies on OZF_ACT_METRIC_FORM_ENT

Line 2852: FROM ozf_act_metric_form_ent

2848: l_formula_entry_count number;
2849:
2850: CURSOR c_formula_entry_type IS
2851: SELECT COUNT(*)
2852: FROM ozf_act_metric_form_ent
2853: WHERE formula_id = p_formula_entry_rec.formula_id
2854: AND order_number = p_formula_entry_rec.order_number
2855: AND formula_entry_id <> p_formula_entry_rec.formula_entry_id;
2856:

Line 3888: FROM ozf_act_metric_form_ent

3884: l_formula_entry_count NUMBER ;
3885:
3886: CURSOR c_formula_entry_count(l_formula_entry_id IN NUMBER) IS
3887: SELECT count(*)
3888: FROM ozf_act_metric_form_ent
3889: WHERE formula_entry_id = l_formula_entry_id;
3890:
3891: CURSOR c_formula_entry_id IS
3892: SELECT ozf_act_metric_formula_ent_s.NEXTVAL

Line 4007: INSERT INTO OZF_ACT_METRIC_FORM_ENT

4003:
4004: --
4005: -- Insert into the base table.
4006: --
4007: INSERT INTO OZF_ACT_METRIC_FORM_ENT
4008: ( formula_entry_id
4009: ,formula_id
4010: ,order_number
4011: ,formula_entry_type

Line 4221: FROM ozf_act_metric_form_ent

4217: END IF;
4218: END IF;
4219:
4220: DELETE
4221: FROM ozf_act_metric_form_ent
4222: WHERE formula_id = p_formula_id;
4223:
4224: --
4225: -- End API Body.