APPS.OZF_ACTMETRICFACT_PVT dependencies on OZF_ACT_METRIC_FORMULAS

Line 2799: FROM ozf_act_metric_formulas

2795: l_formula_count number;
2796:
2797: CURSOR c_formula_type IS
2798: SELECT COUNT(*)
2799: FROM ozf_act_metric_formulas
2800: WHERE formula_type = p_formula_rec.formula_type
2801: AND activity_metric_id = p_formula_rec.activity_metric_id
2802: AND level_depth = p_formula_rec.level_depth
2803: AND formula_id <> p_formula_rec.formula_id;

Line 3101: p_table_name => 'OZF_ACT_METRIC_FORMULAS'

3097:
3098: IF (l_formula_entry_rec.formula_id <> FND_API.G_MISS_NUM) THEN
3099:
3100: IF ozf_utility_pvt.Check_FK_Exists (
3101: p_table_name => 'OZF_ACT_METRIC_FORMULAS'
3102: ,p_pk_name => 'FORMULA_ID'
3103: ,p_pk_value => l_formula_entry_rec.formula_id
3104: ,p_pk_data_type => NULL
3105: ,p_additional_where_clause => NULL

Line 3612: FROM ozf_act_metric_formulas

3608: l_formula_count NUMBER ;
3609:
3610: CURSOR c_formula_count(l_formula_id IN NUMBER) IS
3611: SELECT count(*)
3612: FROM ozf_act_metric_formulas
3613: WHERE formula_id = l_formula_id;
3614:
3615: CURSOR c_formula_id IS
3616: SELECT ozf_act_metric_formulas_s.NEXTVAL

Line 3616: SELECT ozf_act_metric_formulas_s.NEXTVAL

3612: FROM ozf_act_metric_formulas
3613: WHERE formula_id = l_formula_id;
3614:
3615: CURSOR c_formula_id IS
3616: SELECT ozf_act_metric_formulas_s.NEXTVAL
3617: FROM dual;
3618:
3619: BEGIN
3620:

Line 3731: INSERT INTO OZF_ACT_METRIC_FORMULAS

3727:
3728: --
3729: -- Insert into the base table.
3730: --
3731: INSERT INTO OZF_ACT_METRIC_FORMULAS
3732: ( formula_id
3733: ,activity_metric_id
3734: ,level_depth
3735: ,parent_formula_id

Line 4206: FROM ozf_act_metric_formulas

4202: ozf_utility_pvt.debug_message('object version number '||to_char(p_object_version_number));
4203: END IF;
4204:
4205: DELETE
4206: FROM ozf_act_metric_formulas
4207: WHERE formula_id = p_formula_id
4208: AND object_version_number = p_object_version_number;
4209:
4210: IF (SQL%NOTFOUND) THEN