[Home] [Help]
247: ---------------------------------------------------------------------------------------
248: l_computation_result NUMBER := 0;
249:
250: ---------------------------------------------------------------------------------------
251: --This Cursor queries the activity_metric_id field from the ams_act_metric_formulas --
252: --table, this is used to query the required value from the ams_act_metrics_all table --
253: ---------------------------------------------------------------------------------------
254: CURSOR C_Formula_Dets(p_formula_id IN NUMBER) IS
255: SELECT activity_metric_id,parent_formula_id
252: --table, this is used to query the required value from the ams_act_metrics_all table --
253: ---------------------------------------------------------------------------------------
254: CURSOR C_Formula_Dets(p_formula_id IN NUMBER) IS
255: SELECT activity_metric_id,parent_formula_id
256: FROM ams_act_metric_formulas
257: WHERE formula_id = p_formula_id;
258:
259: ---------------------------------------------------------------------------------------
260: --This variable stores the value of the cursor c_formula_dets. --
839: l_formula_count number;
840:
841: CURSOR c_formula_type IS
842: SELECT COUNT(*)
843: FROM ams_act_metric_formulas
844: WHERE formula_type = p_formula_rec.formula_type
845: AND activity_metric_id = p_formula_rec.activity_metric_id
846: AND level_depth = p_formula_rec.level_depth
847: AND formula_id <> p_formula_rec.formula_id;
1141:
1142: IF (l_formula_entry_rec.formula_id <> FND_API.G_MISS_NUM) THEN
1143:
1144: IF AMS_Utility_PVT.Check_FK_Exists (
1145: p_table_name => 'AMS_ACT_METRIC_FORMULAS'
1146: ,p_pk_name => 'FORMULA_ID'
1147: ,p_pk_value => l_formula_entry_rec.formula_id
1148: ,p_pk_data_type => NULL
1149: ,p_additional_where_clause => NULL
1652: l_formula_count NUMBER ;
1653:
1654: CURSOR c_formula_count(l_formula_id IN NUMBER) IS
1655: SELECT count(*)
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
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:
1771:
1772: --
1773: -- Insert into the base table.
1774: --
1775: INSERT INTO AMS_ACT_METRIC_FORMULAS
1776: ( formula_id
1777: ,activity_metric_id
1778: ,level_depth
1779: ,parent_formula_id
2168: -- NAME
2169: -- Update_Formula
2170: --
2171: -- PURPOSE
2172: -- Updates an entry in the AMS_ACT_METRIC_FORMULAS table
2173: --
2174: -- NOTES
2175: --
2176: -- HISTORY
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,
2694: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));
2695: END IF;
2696:
2697: DELETE
2698: FROM ams_act_metric_formulas
2699: WHERE formula_id = p_formula_id
2700: AND object_version_number = p_object_version_number;
2701:
2702: IF (SQL%NOTFOUND) THEN
2951: l_formula_id NUMBER;
2952:
2953: CURSOR c_formula_info IS
2954: SELECT formula_id
2955: FROM ams_act_metric_formulas
2956: WHERE formula_id = p_formula_id
2957: AND object_version_number = p_object_version_number
2958: FOR UPDATE OF formula_id NOWAIT;
2959:
3237: )
3238: IS
3239: CURSOR c_formula IS
3240: SELECT *
3241: FROM ams_act_metric_formulas
3242: WHERE formula_id = p_formula_rec.formula_id;
3243:
3244: l_formula_rec c_formula%ROWTYPE;
3245: