DBA Data[Home] [Help]

APPS.AMS_FORMULA_PVT dependencies on AMS_ACT_METRIC_FORMULAS_S

Line 1660: SELECT ams_act_metric_formulas_s.NEXTVAL

1656: FROM ams_act_metric_formulas
1657: WHERE formula_id = l_formula_id;
1658:
1659: CURSOR c_formula_id IS
1660: SELECT ams_act_metric_formulas_s.NEXTVAL
1661: FROM dual;
1662:
1663: BEGIN
1664:

Line 2307: UPDATE ams_act_metric_formulas SET

2303: IF G_DEBUG THEN
2304: AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formulas Table');
2305: END IF;
2306:
2307: UPDATE ams_act_metric_formulas SET
2308: activity_metric_id = l_formula_rec.activity_metric_id,
2309: level_depth = l_formula_rec.level_depth,
2310: parent_formula_id = l_formula_rec.parent_formula_id,
2311: last_update_date = SYSDATE,