APPS.AMS_ACTMETRICFACT_PVT dependencies on AMS_ACT_METRICS_ALL

Line 275: FROM ams_act_metrics_all

271:
272: -- get the fund's allocation amount
273: CURSOR c_fundfact_getfundamt IS
274: SELECT func_actual_value
275: FROM ams_act_metrics_all
276: WHERE activity_metric_id = p_act_metric_id;
277:
278: -- get a node's node_value, parent node id
279: CURSOR c_fundfact_getnodeinfo(p_hierarchy_id NUMBER, p_node_id NUMBER) IS

Line 2500: l_table_name := 'AMS_ACT_METRICS_ALL';

2496: -- ACTIVITY_METRIC_ID
2497: -- Do not validate FK if NULL
2498:
2499: IF l_act_metric_fact_rec.activity_metric_id <> FND_API.G_MISS_NUM THEN
2500: l_table_name := 'AMS_ACT_METRICS_ALL';
2501: l_pk_name := 'ACTIVITY_METRIC_ID';
2502: l_pk_value := l_act_metric_fact_rec.activity_metric_id;
2503: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
2504: l_additional_where_clause := NULL ;

Line 2664: l_table_name := 'AMS_ACT_METRICS_ALL';

2660: l_act_metric_fact_rec.activity_metric_id := p_complete_fact_rec.activity_metric_id ;
2661: END IF;
2662:
2663: -- first Check whether the Metric is attached to same usage or not
2664: l_table_name := 'AMS_ACT_METRICS_ALL';
2665: l_pk_name := 'ACTIVITY_METRIC_ID';
2666: l_pk_value := l_act_metric_fact_rec.activity_metric_id;
2667: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
2668: l_additional_where_clause := ' arc_act_metric_used_by = '||''''||