eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ACTMETRIC_PVT dependencies on AMS_ACT_METRICS_ALL

Line 208: --LOCK TABLE AMS_ACT_METRICS_ALL IN EXCLUSIVE MODE;

204:
205: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
206: x_activity_metric_id := NULL;
207:
208: --LOCK TABLE AMS_ACT_METRICS_ALL IN EXCLUSIVE MODE;
209:
210: l_is_locked := Lock_Object(
211: p_api_version => p_api_version,
212: p_init_msg_list => p_init_msg_list,

Line 659: UPDATE ams_act_metrics_all

655: )
656: IS
657: BEGIN
658: -- update for summarize_to_metric
659: UPDATE ams_act_metrics_all
660: SET dirty_flag = G_IS_DIRTY
661: WHERE activity_metric_id IN (
662: SELECT activity_metric_id
663: FROM ams_act_metrics_all

Line 663: FROM ams_act_metrics_all

659: UPDATE ams_act_metrics_all
660: SET dirty_flag = G_IS_DIRTY
661: WHERE activity_metric_id IN (
662: SELECT activity_metric_id
663: FROM ams_act_metrics_all
664: START WITH activity_metric_id = p_activity_metric_id
665: CONNECT BY activity_metric_id = PRIOR summarize_to_metric)
666: AND dirty_flag <> G_IS_DIRTY
667: ;

Line 670: UPDATE ams_act_metrics_all

666: AND dirty_flag <> G_IS_DIRTY
667: ;
668:
669: -- update for rollup_to_metric
670: UPDATE ams_act_metrics_all
671: SET dirty_flag = G_IS_DIRTY
672: WHERE activity_metric_id IN (
673: SELECT activity_metric_id
674: FROM ams_act_metrics_all

Line 674: FROM ams_act_metrics_all

670: UPDATE ams_act_metrics_all
671: SET dirty_flag = G_IS_DIRTY
672: WHERE activity_metric_id IN (
673: SELECT activity_metric_id
674: FROM ams_act_metrics_all
675: START WITH activity_metric_id = p_activity_metric_id
676: CONNECT BY activity_metric_id = PRIOR rollup_to_metric)
677: AND dirty_flag <> G_IS_DIRTY
678: ;

Line 681: update ams_act_metrics_all

677: AND dirty_flag <> G_IS_DIRTY
678: ;
679:
680: -- update effected formulas
681: update ams_act_metrics_all
682: set dirty_flag = G_IS_DIRTY
683: where activity_metric_id in
684: (select a.activity_metric_id
685: from ams_act_metrics_all a, ams_metrics_all_b m, ams_metric_formulas f,

Line 685: from ams_act_metrics_all a, ams_metrics_all_b m, ams_metric_formulas f,

681: update ams_act_metrics_all
682: set dirty_flag = G_IS_DIRTY
683: where activity_metric_id in
684: (select a.activity_metric_id
685: from ams_act_metrics_all a, ams_metrics_all_b m, ams_metric_formulas f,
686: ams_act_metrics_all b, ams_metrics_all_b c
687: where a.metric_id = m.metric_id
688: and m.metric_id = f.metric_id
689: and b.metric_id = c.metric_id

Line 686: ams_act_metrics_all b, ams_metrics_all_b c

682: set dirty_flag = G_IS_DIRTY
683: where activity_metric_id in
684: (select a.activity_metric_id
685: from ams_act_metrics_all a, ams_metrics_all_b m, ams_metric_formulas f,
686: ams_act_metrics_all b, ams_metrics_all_b c
687: where a.metric_id = m.metric_id
688: and m.metric_id = f.metric_id
689: and b.metric_id = c.metric_id
690: and a.arc_act_metric_used_by = b.arc_act_metric_used_by

Line 700: UPDATE ams_act_metrics_all

696: and b.activity_metric_id = p_activity_metric_id)
697: and dirty_flag <> G_IS_DIRTY;
698:
699: -- Update for effected variable metrics.
700: UPDATE ams_act_metrics_all
701: SET dirty_flag = G_IS_DIRTY
702: WHERE activity_metric_id IN
703: (SELECT a.activity_metric_id
704: FROM ams_act_metrics_all a, ams_metrics_all_b b,

Line 704: FROM ams_act_metrics_all a, ams_metrics_all_b b,

700: UPDATE ams_act_metrics_all
701: SET dirty_flag = G_IS_DIRTY
702: WHERE activity_metric_id IN
703: (SELECT a.activity_metric_id
704: FROM ams_act_metrics_all a, ams_metrics_all_b b,
705: ams_act_metrics_all c
706: WHERE a.metric_id = b.metric_id
707: AND b.accrual_type = G_VARIABLE
708: AND a.arc_act_metric_used_by = c.arc_act_metric_used_by

Line 705: ams_act_metrics_all c

701: SET dirty_flag = G_IS_DIRTY
702: WHERE activity_metric_id IN
703: (SELECT a.activity_metric_id
704: FROM ams_act_metrics_all a, ams_metrics_all_b b,
705: ams_act_metrics_all c
706: WHERE a.metric_id = b.metric_id
707: AND b.accrual_type = G_VARIABLE
708: AND a.arc_act_metric_used_by = c.arc_act_metric_used_by
709: AND a.act_metric_used_by_id = c.act_metric_used_by_id

Line 725: -- by creating a record in AMS_ACT_METRICS_ALL by calling Create_ActMetric2.

721: --
722: --
723: -- PURPOSE
724: -- Creates an association of a metric to a business object
725: -- by creating a record in AMS_ACT_METRICS_ALL by calling Create_ActMetric2.
726: --
727: -- NOTES
728: --
729: -- HISTORY

Line 755: FROM ams_act_metrics_all

751: CURSOR c_exist_parent_entry (cv_metric_id NUMBER
752: ,cv_act_metric_used_by_id NUMBER
753: ,cv_arc_act_metric_used_by VARCHAR2) IS
754: SELECT activity_metric_id
755: FROM ams_act_metrics_all
756: WHERE metric_id = cv_metric_id
757: AND act_metric_used_by_id = cv_act_metric_used_by_id
758: AND arc_act_metric_used_by = cv_arc_act_metric_used_by;
759:

Line 913: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

909: -- select rollup metrics of currency category
910: CURSOR c_get_rollup_metrics(l_obj_id NUMBER, l_obj_type VARCHAR2) IS
911: SELECT activity_metric_id, transaction_currency_code,
912: trans_actual_value, trans_forecasted_value
913: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
914: WHERE actmet.metric_id = met.metric_id
915: AND metric_calculation_type IN ('ROLLUP', 'SUMMARY')
916: AND arc_act_metric_used_by = l_obj_type
917: AND act_metric_used_by_id = l_obj_id

Line 1544: -- object by creating a record in AMS_ACT_METRICS_ALL.

1540: --
1541: --
1542: -- PURPOSE
1543: -- Creates an association of a metric to a business
1544: -- object by creating a record in AMS_ACT_METRICS_ALL.
1545: --
1546: -- NOTES
1547: --
1548: -- HISTORY

Line 1594: FROM ams_act_metrics_all

1590:
1591:
1592: CURSOR c_act_metr_count(l_act_metric_id IN NUMBER) IS
1593: SELECT COUNT(1)
1594: FROM ams_act_metrics_all
1595: WHERE activity_metric_id = l_act_metric_id;
1596:
1597: CURSOR c_act_met_id IS
1598: SELECT ams_act_metrics_all_s.NEXTVAL

Line 1598: SELECT ams_act_metrics_all_s.NEXTVAL

1594: FROM ams_act_metrics_all
1595: WHERE activity_metric_id = l_act_metric_id;
1596:
1597: CURSOR c_act_met_id IS
1598: SELECT ams_act_metrics_all_s.NEXTVAL
1599: FROM dual;
1600:
1601: -- 05/07/2001 huili for checking the "VARIABLE"
1602: --CURSOR c_dep_info (l_metric_id NUMBER) IS

Line 1625: FROM ams_act_metrics_all

1621: CURSOR c_get_multiplier_metric(l_metric_id INTEGER,
1622: l_object_type VARCHAR2, l_object_id INTEGER)
1623: IS
1624: SELECT activity_metric_id
1625: FROM ams_act_metrics_all
1626: WHERE arc_act_metric_used_by = l_object_type
1627: AND act_metric_used_by_id = l_object_id
1628: AND metric_id = l_metric_id;
1629:

Line 1852: INSERT INTO ams_act_metrics_all (

1848: END IF;
1849: --
1850: -- Insert into the base table.
1851: --
1852: INSERT INTO ams_act_metrics_all (
1853: activity_metric_id,
1854: creation_date,
1855: created_by,
1856: last_update_date,

Line 2077: -- UPDATE ams_act_metrics_all

2073: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2074: END IF;
2075:
2076: -- dmvincen 02/10/2004: no longer useful.
2077: -- UPDATE ams_act_metrics_all
2078: -- SET depend_act_metric = l_dep_act_met_id
2079: -- WHERE activity_metric_id = l_act_metrics_rec.activity_metric_id;
2080: END IF;
2081: END IF;

Line 2169: -- Updates a metric in AMS_ACT_METRICS_ALL given the

2165: -- NAME
2166: -- Update_ActMetric
2167: --
2168: -- PURPOSE
2169: -- Updates a metric in AMS_ACT_METRICS_ALL given the
2170: -- record for the metrics.
2171: --
2172: -- NOTES
2173: --

Line 2212: FROM ams_act_metrics_all a, ams_metrics_all_b b

2208: -- huili@ added to invalidate corresponding activity variable metrics
2209: l_depend_act_metric NUMBER;
2210: CURSOR c_check_var_met (l_activity_metric_id NUMBER) IS
2211: SELECT depend_act_metric
2212: FROM ams_act_metrics_all a, ams_metrics_all_b b
2213: WHERE activity_metric_id = l_activity_metric_id
2214: AND a.metric_id = b.metric_id
2215: AND b.accrual_type <> G_VARIABLE;
2216: -- end

Line 2409: -- Update AMS_ACT_METRICS_ALL

2405: IF (AMS_DEBUG_HIGH_ON) THEN
2406: Ams_Utility_Pvt.debug_message(l_full_name ||': update Activity Metrics Table');
2407: END IF;
2408:
2409: -- Update AMS_ACT_METRICS_ALL
2410: UPDATE ams_act_metrics_all
2411: SET object_version_number= object_version_number + 1,
2412: act_metric_used_by_id = l_actmet_rec.act_metric_used_by_id,
2413: arc_act_metric_used_by = l_actmet_rec.arc_act_metric_used_by,

Line 2410: UPDATE ams_act_metrics_all

2406: Ams_Utility_Pvt.debug_message(l_full_name ||': update Activity Metrics Table');
2407: END IF;
2408:
2409: -- Update AMS_ACT_METRICS_ALL
2410: UPDATE ams_act_metrics_all
2411: SET object_version_number= object_version_number + 1,
2412: act_metric_used_by_id = l_actmet_rec.act_metric_used_by_id,
2413: arc_act_metric_used_by = l_actmet_rec.arc_act_metric_used_by,
2414: purchase_req_raised_flag = l_actmet_rec.purchase_req_raised_flag,

Line 2502: UPDATE ams_act_metrics_all

2498: -- huili@ added to invalidate the corresponding variable activity metrics
2499: OPEN c_check_var_met (l_actmet_rec.activity_metric_id);
2500: FETCH c_check_var_met INTO l_depend_act_metric;
2501: IF c_check_var_met%FOUND AND l_depend_act_metric IS NOT NULL THEN
2502: UPDATE ams_act_metrics_all
2503: SET dirty_flag = G_IS_DIRTY
2504: WHERE activity_metric_id = l_depend_act_metric;
2505:
2506: IF (SQL%NOTFOUND) THEN

Line 2591: -- object by creating a record in AMS_ACT_METRICS_ALL.

2587: -- Delete_ActMetric
2588: --
2589: -- PURPOSE
2590: -- Deletes the association of a metric to a business
2591: -- object by creating a record in AMS_ACT_METRICS_ALL.
2592: --
2593: -- NOTES
2594: --
2595: -- HISTORY

Line 2634: FROM ams_act_metrics_all

2630: -- DMVINCEN Added check for rollup children.
2631: -- DMVINCEN 04/04/2002: Retrieve the child ids and relation ships.
2632: CURSOR c_check_child_exists(l_act_metric_id NUMBER) IS
2633: SELECT activity_metric_id, 'SUMMARY'
2634: FROM ams_act_metrics_all
2635: WHERE summarize_to_metric = l_act_metric_id
2636: UNION ALL
2637: SELECT activity_metric_id, 'ROLLUP'
2638: FROM ams_act_metrics_all

Line 2638: FROM ams_act_metrics_all

2634: FROM ams_act_metrics_all
2635: WHERE summarize_to_metric = l_act_metric_id
2636: UNION ALL
2637: SELECT activity_metric_id, 'ROLLUP'
2638: FROM ams_act_metrics_all
2639: WHERE rollup_to_metric = l_act_metric_id;
2640:
2641: CURSOR c_actmet_details(l_act_metric_id NUMBER) IS
2642: SELECT activity_metric_id,

Line 2722: FROM ams_act_metrics_all

2718: action_code,
2719: basis_year,
2720: ex_start_node
2721: /* 05/15/2002 yzhao: add ends */
2722: FROM ams_act_metrics_all
2723: WHERE activity_metric_id = l_act_metric_id;
2724:
2725: -- huili@ added on 05/07/2001
2726: CURSOR c_depend_met_id (l_act_met_id NUMBER) IS

Line 2728: FROM ams_act_metrics_all

2724:
2725: -- huili@ added on 05/07/2001
2726: CURSOR c_depend_met_id (l_act_met_id NUMBER) IS
2727: SELECT depend_act_metric, object_version_number
2728: FROM ams_act_metrics_all
2729: WHERE activity_metric_id = l_act_met_id;
2730:
2731: l_depend_act_met_id NUMBER;
2732: l_depend_version_num NUMBER;

Line 2803: UPDATE ams_act_metrics_all

2799: FETCH c_check_child_exists
2800: INTO l_child_activity_metric_id, l_child_type;
2801: EXIT WHEN c_check_child_exists%NOTFOUND;
2802: EXIT WHEN l_child_type = 'SUMMARY';
2803: UPDATE ams_act_metrics_all
2804: SET rollup_to_metric = NULL
2805: WHERE activity_metric_id = l_child_activity_metric_id;
2806: END LOOP;
2807: CLOSE c_check_child_exists;

Line 2902: DELETE FROM ams_act_metrics_all

2898: -- Record any change in the history table.
2899: Record_History(p_activity_metric_id, G_DELETE,
2900: x_return_status, x_msg_count, x_msg_data);
2901:
2902: DELETE FROM ams_act_metrics_all
2903: WHERE activity_metric_id = p_activity_metric_id
2904: AND object_version_number = p_object_version_number;
2905:
2906: IF SQL%NOTFOUND THEN

Line 2920: UPDATE ams_act_metrics_all

2916: Make_ActMetric_Dirty(l_act_metric_rec.summarize_to_metric);
2917:
2918: IF l_depend_act_met_id IS NOT NULL THEN
2919:
2920: UPDATE ams_act_metrics_all
2921: SET depend_act_metric = NULL
2922: WHERE activity_metric_id = l_depend_act_met_id;
2923:
2924: Delete_ActMetric (

Line 3047: FROM ams_act_metrics_all

3043: CURSOR c_get_top_level_act_metrics(l_arc_act_metric_used_by VARCHAR2,
3044: l_act_metric_used_by_id NUMBER)
3045: IS
3046: SELECT activity_metric_id, object_version_number
3047: FROM ams_act_metrics_all
3048: WHERE summarize_to_metric is NULL
3049: AND arc_act_metric_used_by = l_arc_act_metric_used_by
3050: AND act_metric_used_by_id = l_act_metric_used_by_id;
3051:

Line 3057: FROM ams_act_metrics_all

3053: l_act_metric_used_by_id NUMBER,
3054: l_activity_metric_id NUMBER)
3055: IS
3056: SELECT activity_metric_id, object_version_number
3057: FROM ams_act_metrics_all
3058: WHERE summarize_to_metric = l_activity_metric_id
3059: AND arc_act_metric_used_by = l_arc_act_metric_used_by
3060: AND act_metric_used_by_id = l_act_metric_used_by_id;
3061:

Line 3254: -- Lock the given row in AMS_ACT_METRICS_ALL.

3250: -- NAME
3251: -- Lock_ActMetric
3252: --
3253: -- PURPOSE
3254: -- Lock the given row in AMS_ACT_METRICS_ALL.
3255: --
3256: -- NOTES
3257: --
3258: -- HISTORY

Line 3285: FROM ams_act_metrics_all

3281: l_metrics_name VARCHAR2(240);
3282:
3283: CURSOR c_act_metrics_info IS
3284: SELECT activity_metric_id
3285: FROM ams_act_metrics_all
3286: WHERE activity_metric_id = p_activity_metric_id
3287: AND object_version_number = p_object_version_number
3288: FOR UPDATE OF activity_metric_id NOWAIT;
3289:

Line 3292: FROM ams_metrics_vl m, ams_act_metrics_all a

3288: FOR UPDATE OF activity_metric_id NOWAIT;
3289:
3290: CURSOR c_metric_info(p_act_metric_id NUMBER) IS
3291: SELECT metrics_name
3292: FROM ams_metrics_vl m, ams_act_metrics_all a
3293: WHERE m.metric_id = a.metric_id
3294: AND activity_metric_id = p_act_metric_id;
3295: BEGIN
3296: --

Line 3748: AND NOT EXISTS (SELECT 'x' FROM ams_act_metrics_all a

3744: SELECT 'x'
3745: FROM ams_metrics_all_b b
3746: WHERE metric_id = l_metric_id
3747: AND ((metric_calculation_type = 'FUNCTION'
3748: AND NOT EXISTS (SELECT 'x' FROM ams_act_metrics_all a
3749: WHERE a.metric_id = b.metric_id
3750: AND a.arc_act_metric_used_by = l_arc_act_metric_used_by
3751: AND a.act_metric_used_by_id = l_act_metric_used_by_id
3752: AND NVL(a.arc_function_used_by,'IS NULL') =

Line 3770: p_table_name => 'ams_act_metrics_all',

3766: THEN
3767: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
3768:
3769: IF Ams_Utility_Pvt.Check_Uniqueness(
3770: p_table_name => 'ams_act_metrics_all',
3771: p_where_clause => l_where_clause
3772: ) = Fnd_Api.g_false
3773: THEN
3774: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

Line 4158: FROM ams_act_metrics_all

4154: CURSOR c_ref_metric (p_act_metric_id NUMBER) IS
4155: SELECT func_actual_value,
4156: trans_forecasted_value,
4157: forecasted_variable_value
4158: FROM ams_act_metrics_all
4159: WHERE activity_metric_id = p_act_metric_id;
4160:
4161:
4162:

Line 4494: FROM ams_act_metrics_all

4490: )
4491: IS
4492: CURSOR c_act_metric IS
4493: SELECT *
4494: FROM ams_act_metrics_all
4495: WHERE activity_metric_id = p_act_metric_rec.activity_metric_id;
4496:
4497: l_act_metric_rec c_act_metric%ROWTYPE;
4498: BEGIN

Line 4903: UPDATE ams_act_metrics_all

4899: IF (AMS_DEBUG_HIGH_ON) THEN
4900: Ams_Utility_Pvt.debug_message(l_full_name||': Update');
4901: END IF;
4902:
4903: UPDATE ams_act_metrics_all
4904: SET func_committed_value = p_func_committed_value
4905: WHERE arc_act_metric_used_by = p_arc_act_metric_used_by
4906: AND act_metric_used_by_id = p_act_metric_used_by_id
4907: AND metric_id = p_metric_id ;

Line 5000: FROM ams_act_metrics_all

4996: RETURN BOOLEAN
4997: IS
4998: CURSOR c_met_id(l_act_met_id NUMBER) IS
4999: SELECT metric_id
5000: FROM ams_act_metrics_all
5001: WHERE activity_metric_id =l_act_met_id;
5002: l_met_rec NUMBER;
5003: BEGIN
5004:

Line 5106: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

5102: SELECT trans_forecasted_value,
5103: transaction_currency_code,
5104: func_forecasted_value,
5105: functional_currency_code
5106: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
5107: WHERE actmet.metric_id = met.metric_id
5108: AND arc_act_metric_used_by = l_obj_type
5109: AND act_metric_used_by_id = l_obj_id
5110: AND metric_category = l_category_id

Line 5322: FROM ams_act_metrics_all

5318: l_return_status VARCHAR2(1);
5319:
5320: CURSOR c_find_rollups(l_used_by_type VARCHAR2, l_used_by_id NUMBER) IS
5321: SELECT activity_metric_id
5322: FROM ams_act_metrics_all
5323: WHERE arc_act_metric_used_by = l_used_by_type
5324: AND act_metric_used_by_id = l_used_by_id
5325: AND rollup_to_metric IS NOT NULL;
5326: l_act_metrics_rec c_find_rollups%ROWTYPE;

Line 5380: UPDATE ams_act_metrics_all

5376: LOOP
5377: Make_Actmetric_Dirty(l_act_metrics_rec.activity_metric_id);
5378: END LOOP;
5379:
5380: UPDATE ams_act_metrics_all
5381: SET rollup_to_metric = NULL
5382: WHERE arc_act_metric_used_by = l_used_by_type
5383: AND act_metric_used_by_id = p_used_by_id
5384: AND rollup_to_metric IS NOT NULL;

Line 5475: FROM ams_act_metrics_all amet

5471: SELECT activity_metric_id,
5472: func_actual_value,
5473: '' description,
5474: functional_currency_code
5475: FROM ams_act_metrics_all amet
5476: WHERE arc_act_metric_used_by = l_obj_type
5477: AND act_metric_used_by_id = l_obj_id
5478: AND (published_flag IS NULL OR published_flag = 'N')
5479: AND EXISTS

Line 5542: UPDATE ams_act_metrics_all

5538:
5539: l_func_currency := l_cost_rec.cost_curr;
5540: l_cost_table(c_get_post_metrics%ROWCOUNT) := l_cost_rec;
5541:
5542: UPDATE ams_act_metrics_all
5543: SET published_flag = 'Y'
5544: WHERE CURRENT OF c_get_post_metrics;
5545:
5546: END LOOP;

Line 6098: FROM ams_act_metrics_all

6094: action_code,
6095: basis_year,
6096: ex_start_node
6097: /* 05/15/2002 yzhao: add ends */
6098: FROM ams_act_metrics_all
6099: WHERE activity_metric_id = l_act_metric_id;
6100:
6101: CURSOR c_get_new_history_id IS
6102: SELECT ams_act_metric_hst_s.NEXTVAL

Line 7059: FROM ams_act_metrics_all

7055: method_code,
7056: action_code,
7057: basis_year,
7058: ex_start_node
7059: FROM ams_act_metrics_all
7060: WHERE arc_act_metric_used_by = c_source_object_type
7061: and act_metric_used_by_id = c_source_object_id;
7062:
7063: -- metrics_rec c_act_met_details%ROWTYPE;

Line 7070: FROM ams_act_metrics_all

7066: ,cv_act_metric_used_by_id NUMBER
7067: ,cv_arc_act_metric_used_by VARCHAR2) IS
7068:
7069: SELECT activity_metric_id
7070: FROM ams_act_metrics_all
7071: WHERE metric_id = cv_metric_id
7072: AND act_metric_used_by_id = cv_act_metric_used_by_id
7073: AND arc_act_metric_used_by = cv_arc_act_metric_used_by;
7074:

Line 7149: UPDATE ams_act_metrics_all

7145:
7146: --if accrual type is variable update the variable value.
7147: IF l_accrual_type=G_VARIABLE
7148: THEN
7149: UPDATE ams_act_metrics_all
7150: SET
7151: object_version_number = object_version_number + 1,
7152: last_update_date = SYSDATE,
7153: last_updated_by = Fnd_Global.User_ID,

Line 7630: DELETE FROM ams_act_metrics_all

7626: -- Initialize API return status to success.
7627: --
7628: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7629:
7630: DELETE FROM ams_act_metrics_all
7631: WHERE arc_act_metric_used_by = p_object_type
7632: AND act_metric_used_by_id = p_object_id;
7633:
7634: IF p_commit = FND_API.G_TRUE THEN