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 1843: INSERT INTO ams_act_metrics_all (

1839:
1840: --
1841: -- Insert into the base table.
1842: --
1843: INSERT INTO ams_act_metrics_all (
1844: activity_metric_id,
1845:
1846: creation_date,
1847: created_by,

Line 2069: -- UPDATE ams_act_metrics_all

2065: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2066: END IF;
2067:
2068: -- dmvincen 02/10/2004: no longer useful.
2069: -- UPDATE ams_act_metrics_all
2070: -- SET depend_act_metric = l_dep_act_met_id
2071: -- WHERE activity_metric_id = l_act_metrics_rec.activity_metric_id;
2072: END IF;
2073: END IF;

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

2157: -- NAME
2158: -- Update_ActMetric
2159: --
2160: -- PURPOSE
2161: -- Updates a metric in AMS_ACT_METRICS_ALL given the
2162: -- record for the metrics.
2163: --
2164: -- NOTES
2165: --

Line 2204: FROM ams_act_metrics_all a, ams_metrics_all_b b

2200: -- huili@ added to invalidate corresponding activity variable metrics
2201: l_depend_act_metric NUMBER;
2202: CURSOR c_check_var_met (l_activity_metric_id NUMBER) IS
2203: SELECT depend_act_metric
2204: FROM ams_act_metrics_all a, ams_metrics_all_b b
2205: WHERE activity_metric_id = l_activity_metric_id
2206: AND a.metric_id = b.metric_id
2207: AND b.accrual_type <> G_VARIABLE;
2208: -- end

Line 2401: -- Update AMS_ACT_METRICS_ALL

2397: IF (AMS_DEBUG_HIGH_ON) THEN
2398: Ams_Utility_Pvt.debug_message(l_full_name ||': update Activity Metrics Table');
2399: END IF;
2400:
2401: -- Update AMS_ACT_METRICS_ALL
2402: UPDATE ams_act_metrics_all
2403: SET object_version_number= object_version_number + 1,
2404: act_metric_used_by_id = l_actmet_rec.act_metric_used_by_id,
2405: arc_act_metric_used_by = l_actmet_rec.arc_act_metric_used_by,

Line 2402: UPDATE ams_act_metrics_all

2398: Ams_Utility_Pvt.debug_message(l_full_name ||': update Activity Metrics Table');
2399: END IF;
2400:
2401: -- Update AMS_ACT_METRICS_ALL
2402: UPDATE ams_act_metrics_all
2403: SET object_version_number= object_version_number + 1,
2404: act_metric_used_by_id = l_actmet_rec.act_metric_used_by_id,
2405: arc_act_metric_used_by = l_actmet_rec.arc_act_metric_used_by,
2406: purchase_req_raised_flag = l_actmet_rec.purchase_req_raised_flag,

Line 2494: UPDATE ams_act_metrics_all

2490: -- huili@ added to invalidate the corresponding variable activity metrics
2491: OPEN c_check_var_met (l_actmet_rec.activity_metric_id);
2492: FETCH c_check_var_met INTO l_depend_act_metric;
2493: IF c_check_var_met%FOUND AND l_depend_act_metric IS NOT NULL THEN
2494: UPDATE ams_act_metrics_all
2495: SET dirty_flag = G_IS_DIRTY
2496: WHERE activity_metric_id = l_depend_act_metric;
2497:
2498: IF (SQL%NOTFOUND) THEN

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

2579: -- Delete_ActMetric
2580: --
2581: -- PURPOSE
2582: -- Deletes the association of a metric to a business
2583: -- object by creating a record in AMS_ACT_METRICS_ALL.
2584: --
2585: -- NOTES
2586: --
2587: -- HISTORY

Line 2626: FROM ams_act_metrics_all

2622: -- DMVINCEN Added check for rollup children.
2623: -- DMVINCEN 04/04/2002: Retrieve the child ids and relation ships.
2624: CURSOR c_check_child_exists(l_act_metric_id NUMBER) IS
2625: SELECT activity_metric_id, 'SUMMARY'
2626: FROM ams_act_metrics_all
2627: WHERE summarize_to_metric = l_act_metric_id
2628: UNION ALL
2629: SELECT activity_metric_id, 'ROLLUP'
2630: FROM ams_act_metrics_all

Line 2630: FROM ams_act_metrics_all

2626: FROM ams_act_metrics_all
2627: WHERE summarize_to_metric = l_act_metric_id
2628: UNION ALL
2629: SELECT activity_metric_id, 'ROLLUP'
2630: FROM ams_act_metrics_all
2631: WHERE rollup_to_metric = l_act_metric_id;
2632:
2633: CURSOR c_actmet_details(l_act_metric_id NUMBER) IS
2634: SELECT activity_metric_id,

Line 2714: FROM ams_act_metrics_all

2710: action_code,
2711: basis_year,
2712: ex_start_node
2713: /* 05/15/2002 yzhao: add ends */
2714: FROM ams_act_metrics_all
2715: WHERE activity_metric_id = l_act_metric_id;
2716:
2717: -- huili@ added on 05/07/2001
2718: CURSOR c_depend_met_id (l_act_met_id NUMBER) IS

Line 2720: FROM ams_act_metrics_all

2716:
2717: -- huili@ added on 05/07/2001
2718: CURSOR c_depend_met_id (l_act_met_id NUMBER) IS
2719: SELECT depend_act_metric, object_version_number
2720: FROM ams_act_metrics_all
2721: WHERE activity_metric_id = l_act_met_id;
2722:
2723: l_depend_act_met_id NUMBER;
2724: l_depend_version_num NUMBER;

Line 2795: UPDATE ams_act_metrics_all

2791: FETCH c_check_child_exists
2792: INTO l_child_activity_metric_id, l_child_type;
2793: EXIT WHEN c_check_child_exists%NOTFOUND;
2794: EXIT WHEN l_child_type = 'SUMMARY';
2795: UPDATE ams_act_metrics_all
2796: SET rollup_to_metric = NULL
2797: WHERE activity_metric_id = l_child_activity_metric_id;
2798: END LOOP;
2799: CLOSE c_check_child_exists;

Line 2894: DELETE FROM ams_act_metrics_all

2890: -- Record any change in the history table.
2891: Record_History(p_activity_metric_id, G_DELETE,
2892: x_return_status, x_msg_count, x_msg_data);
2893:
2894: DELETE FROM ams_act_metrics_all
2895: WHERE activity_metric_id = p_activity_metric_id
2896: AND object_version_number = p_object_version_number;
2897:
2898: IF SQL%NOTFOUND THEN

Line 2912: UPDATE ams_act_metrics_all

2908: Make_ActMetric_Dirty(l_act_metric_rec.summarize_to_metric);
2909:
2910: IF l_depend_act_met_id IS NOT NULL THEN
2911:
2912: UPDATE ams_act_metrics_all
2913: SET depend_act_metric = NULL
2914: WHERE activity_metric_id = l_depend_act_met_id;
2915:
2916: Delete_ActMetric (

Line 3039: FROM ams_act_metrics_all

3035: CURSOR c_get_top_level_act_metrics(l_arc_act_metric_used_by VARCHAR2,
3036: l_act_metric_used_by_id NUMBER)
3037: IS
3038: SELECT activity_metric_id, object_version_number
3039: FROM ams_act_metrics_all
3040: WHERE summarize_to_metric is NULL
3041: AND arc_act_metric_used_by = l_arc_act_metric_used_by
3042: AND act_metric_used_by_id = l_act_metric_used_by_id;
3043:

Line 3049: FROM ams_act_metrics_all

3045: l_act_metric_used_by_id NUMBER,
3046: l_activity_metric_id NUMBER)
3047: IS
3048: SELECT activity_metric_id, object_version_number
3049: FROM ams_act_metrics_all
3050: WHERE summarize_to_metric = l_activity_metric_id
3051: AND arc_act_metric_used_by = l_arc_act_metric_used_by
3052: AND act_metric_used_by_id = l_act_metric_used_by_id;
3053:

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

3242: -- NAME
3243: -- Lock_ActMetric
3244: --
3245: -- PURPOSE
3246: -- Lock the given row in AMS_ACT_METRICS_ALL.
3247: --
3248: -- NOTES
3249: --
3250: -- HISTORY

Line 3277: FROM ams_act_metrics_all

3273: l_metrics_name VARCHAR2(240);
3274:
3275: CURSOR c_act_metrics_info IS
3276: SELECT activity_metric_id
3277: FROM ams_act_metrics_all
3278: WHERE activity_metric_id = p_activity_metric_id
3279: AND object_version_number = p_object_version_number
3280: FOR UPDATE OF activity_metric_id NOWAIT;
3281:

Line 3284: FROM ams_metrics_vl m, ams_act_metrics_all a

3280: FOR UPDATE OF activity_metric_id NOWAIT;
3281:
3282: CURSOR c_metric_info(p_act_metric_id NUMBER) IS
3283: SELECT metrics_name
3284: FROM ams_metrics_vl m, ams_act_metrics_all a
3285: WHERE m.metric_id = a.metric_id
3286: AND activity_metric_id = p_act_metric_id;
3287: BEGIN
3288: --

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

3736: SELECT 'x'
3737: FROM ams_metrics_all_b b
3738: WHERE metric_id = l_metric_id
3739: AND ((metric_calculation_type = 'FUNCTION'
3740: AND NOT EXISTS (SELECT 'x' FROM ams_act_metrics_all a
3741: WHERE a.metric_id = b.metric_id
3742: AND a.arc_act_metric_used_by = l_arc_act_metric_used_by
3743: AND a.act_metric_used_by_id = l_act_metric_used_by_id
3744: AND NVL(a.arc_function_used_by,'IS NULL') =

Line 3762: p_table_name => 'ams_act_metrics_all',

3758: THEN
3759: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
3760:
3761: IF Ams_Utility_Pvt.Check_Uniqueness(
3762: p_table_name => 'ams_act_metrics_all',
3763: p_where_clause => l_where_clause
3764: ) = Fnd_Api.g_false
3765: THEN
3766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

Line 4150: FROM ams_act_metrics_all

4146: CURSOR c_ref_metric (p_act_metric_id NUMBER) IS
4147: SELECT func_actual_value,
4148: trans_forecasted_value,
4149: forecasted_variable_value
4150: FROM ams_act_metrics_all
4151: WHERE activity_metric_id = p_act_metric_id;
4152:
4153:
4154:

Line 4486: FROM ams_act_metrics_all

4482: )
4483: IS
4484: CURSOR c_act_metric IS
4485: SELECT *
4486: FROM ams_act_metrics_all
4487: WHERE activity_metric_id = p_act_metric_rec.activity_metric_id;
4488:
4489: l_act_metric_rec c_act_metric%ROWTYPE;
4490: BEGIN

Line 4895: UPDATE ams_act_metrics_all

4891: IF (AMS_DEBUG_HIGH_ON) THEN
4892: Ams_Utility_Pvt.debug_message(l_full_name||': Update');
4893: END IF;
4894:
4895: UPDATE ams_act_metrics_all
4896: SET func_committed_value = p_func_committed_value
4897: WHERE arc_act_metric_used_by = p_arc_act_metric_used_by
4898: AND act_metric_used_by_id = p_act_metric_used_by_id
4899: AND metric_id = p_metric_id ;

Line 4992: FROM ams_act_metrics_all

4988: RETURN BOOLEAN
4989: IS
4990: CURSOR c_met_id(l_act_met_id NUMBER) IS
4991: SELECT metric_id
4992: FROM ams_act_metrics_all
4993: WHERE activity_metric_id =l_act_met_id;
4994: l_met_rec NUMBER;
4995: BEGIN
4996:

Line 5098: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

5094: SELECT trans_forecasted_value,
5095: transaction_currency_code,
5096: func_forecasted_value,
5097: functional_currency_code
5098: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
5099: WHERE actmet.metric_id = met.metric_id
5100: AND arc_act_metric_used_by = l_obj_type
5101: AND act_metric_used_by_id = l_obj_id
5102: AND metric_category = l_category_id

Line 5314: FROM ams_act_metrics_all

5310: l_return_status VARCHAR2(1);
5311:
5312: CURSOR c_find_rollups(l_used_by_type VARCHAR2, l_used_by_id NUMBER) IS
5313: SELECT activity_metric_id
5314: FROM ams_act_metrics_all
5315: WHERE arc_act_metric_used_by = l_used_by_type
5316: AND act_metric_used_by_id = l_used_by_id
5317: AND rollup_to_metric IS NOT NULL;
5318: l_act_metrics_rec c_find_rollups%ROWTYPE;

Line 5372: UPDATE ams_act_metrics_all

5368: LOOP
5369: Make_Actmetric_Dirty(l_act_metrics_rec.activity_metric_id);
5370: END LOOP;
5371:
5372: UPDATE ams_act_metrics_all
5373: SET rollup_to_metric = NULL
5374: WHERE arc_act_metric_used_by = l_used_by_type
5375: AND act_metric_used_by_id = p_used_by_id
5376: AND rollup_to_metric IS NOT NULL;

Line 5467: FROM ams_act_metrics_all amet

5463: SELECT activity_metric_id,
5464: func_actual_value,
5465: '' description,
5466: functional_currency_code
5467: FROM ams_act_metrics_all amet
5468: WHERE arc_act_metric_used_by = l_obj_type
5469: AND act_metric_used_by_id = l_obj_id
5470: AND (published_flag IS NULL OR published_flag = 'N')
5471: AND EXISTS

Line 5534: UPDATE ams_act_metrics_all

5530:
5531: l_func_currency := l_cost_rec.cost_curr;
5532: l_cost_table(c_get_post_metrics%ROWCOUNT) := l_cost_rec;
5533:
5534: UPDATE ams_act_metrics_all
5535: SET published_flag = 'Y'
5536: WHERE CURRENT OF c_get_post_metrics;
5537:
5538: END LOOP;

Line 6090: FROM ams_act_metrics_all

6086: action_code,
6087: basis_year,
6088: ex_start_node
6089: /* 05/15/2002 yzhao: add ends */
6090: FROM ams_act_metrics_all
6091: WHERE activity_metric_id = l_act_metric_id;
6092:
6093: CURSOR c_get_new_history_id IS
6094: SELECT ams_act_metric_hst_s.NEXTVAL

Line 7051: FROM ams_act_metrics_all

7047: method_code,
7048: action_code,
7049: basis_year,
7050: ex_start_node
7051: FROM ams_act_metrics_all
7052: WHERE arc_act_metric_used_by = c_source_object_type
7053: and act_metric_used_by_id = c_source_object_id;
7054:
7055: -- metrics_rec c_act_met_details%ROWTYPE;

Line 7062: FROM ams_act_metrics_all

7058: ,cv_act_metric_used_by_id NUMBER
7059: ,cv_arc_act_metric_used_by VARCHAR2) IS
7060:
7061: SELECT activity_metric_id
7062: FROM ams_act_metrics_all
7063: WHERE metric_id = cv_metric_id
7064: AND act_metric_used_by_id = cv_act_metric_used_by_id
7065: AND arc_act_metric_used_by = cv_arc_act_metric_used_by;
7066:

Line 7141: UPDATE ams_act_metrics_all

7137:
7138: --if accrual type is variable update the variable value.
7139: IF l_accrual_type=G_VARIABLE
7140: THEN
7141: UPDATE ams_act_metrics_all
7142: SET
7143: object_version_number = object_version_number + 1,
7144: last_update_date = SYSDATE,
7145: last_updated_by = Fnd_Global.User_ID,

Line 7622: DELETE FROM ams_act_metrics_all

7618: -- Initialize API return status to success.
7619: --
7620: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7621:
7622: DELETE FROM ams_act_metrics_all
7623: WHERE arc_act_metric_used_by = p_object_type
7624: AND act_metric_used_by_id = p_object_id;
7625:
7626: IF p_commit = FND_API.G_TRUE THEN