APPS.AMS_FORMULA_PVT dependencies on AMS_ACT_METRIC_FORM_ENT

Line 275: FROM ams_act_metric_form_ent

271: --The Entries are processed in Ascending ORDER_NUMBER and FORMULA_ENTRY_ID. --
272: ---------------------------------------------------------------------------------------
273: CURSOR C_Formula_Entry_Dets IS
274: SELECT *
275: FROM ams_act_metric_form_ent
276: WHERE formula_id = p_formula_id
277: ORDER BY formula_entry_id,order_number;
278:
279:

Line 896: FROM ams_act_metric_form_ent

892: l_formula_entry_count number;
893:
894: CURSOR c_formula_entry_type IS
895: SELECT COUNT(*)
896: FROM ams_act_metric_form_ent
897: WHERE formula_id = p_formula_entry_rec.formula_id
898: AND order_number = p_formula_entry_rec.order_number
899: AND formula_entry_id <> p_formula_entry_rec.formula_entry_id;
900:

Line 1932: FROM ams_act_metric_form_ent

1928: l_formula_entry_count NUMBER ;
1929:
1930: CURSOR c_formula_entry_count(l_formula_entry_id IN NUMBER) IS
1931: SELECT count(*)
1932: FROM ams_act_metric_form_ent
1933: WHERE formula_entry_id = l_formula_entry_id;
1934:
1935: CURSOR c_formula_entry_id IS
1936: SELECT ams_act_metric_formula_ent_s.NEXTVAL

Line 2051: INSERT INTO AMS_ACT_METRIC_FORM_ENT

2047:
2048: --
2049: -- Insert into the base table.
2050: --
2051: INSERT INTO AMS_ACT_METRIC_FORM_ENT
2052: ( formula_entry_id
2053: ,formula_id
2054: ,order_number
2055: ,formula_entry_type

Line 2397: -- Updates an entry in the AMS_ACT_METRIC_FORM_ENT table

2393: -- NAME
2394: -- Update_Formula_Entry
2395: --
2396: -- PURPOSE
2397: -- Updates an entry in the AMS_ACT_METRIC_FORM_ENT table
2398: --
2399: -- NOTES
2400: --
2401: -- HISTORY

Line 2531: UPDATE ams_act_metric_form_ent SET

2527: IF G_DEBUG THEN
2528: AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formula Entry Table');
2529: END IF;
2530:
2531: UPDATE ams_act_metric_form_ent SET
2532: formula_id = l_formula_entry_rec.formula_id
2533: ,order_number = l_formula_entry_rec.order_number
2534: ,formula_entry_type = l_formula_entry_rec.formula_entry_type
2535: ,formula_entry_value = l_formula_entry_rec.formula_entry_value

Line 2713: FROM ams_act_metric_form_ent

2709: END IF;
2710: END IF;
2711:
2712: DELETE
2713: FROM ams_act_metric_form_ent
2714: WHERE formula_id = p_formula_id;
2715:
2716: --
2717: -- End API Body.

Line 2853: FROM ams_act_metric_form_ent

2849: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));
2850: END IF;
2851:
2852: DELETE
2853: FROM ams_act_metric_form_ent
2854: WHERE formula_entry_id = p_formula_entry_id
2855: AND object_version_number = p_object_version_number;
2856:
2857: IF (SQL%NOTFOUND) THEN

Line 3076: -- Lock the given row in AMS_ACT_METRIC_FORM_ENT table.

3072: -- NAME
3073: -- Lock_Formula_Entry
3074: --
3075: -- PURPOSE
3076: -- Lock the given row in AMS_ACT_METRIC_FORM_ENT table.
3077: --
3078: -- NOTES
3079: --
3080: -- HISTORY

Line 3105: FROM ams_act_metric_form_ent

3101: l_formula_entry_id NUMBER;
3102:
3103: CURSOR c_formula_entry_info IS
3104: SELECT formula_entry_id
3105: FROM ams_act_metric_form_ent
3106: WHERE formula_entry_id = p_formula_entry_id
3107: AND object_version_number = p_object_version_number
3108: FOR UPDATE OF formula_entry_id NOWAIT;
3109:

Line 3329: FROM ams_act_metric_form_ent

3325: )
3326: IS
3327: CURSOR c_formula_entry IS
3328: SELECT *
3329: FROM ams_act_metric_form_ent
3330: WHERE formula_entry_id = p_formula_entry_rec.formula_entry_id;
3331:
3332: l_formula_entry_rec c_formula_entry%ROWTYPE;
3333: