DBA Data[Home] [Help]

APPS.AMS_METRIC_PVT dependencies on AMS_ACT_METRICS_ALL

Line 3158: SELECT 1 from AMS_ACT_METRICS_ALL

3154: l_metric_id NUMBER := p_metric_id;
3155: l_return_status VARCHAR2(1);
3156:
3157: CURSOR c_check_metric_id(p_metric_id number) IS
3158: SELECT 1 from AMS_ACT_METRICS_ALL
3159: WHERE METRIC_ID = p_metric_id ;
3160:
3161:
3162: BEGIN

Line 3176: -- AMS_ACT_METRICS_ALL

3172: CLOSE c_check_metric_id;
3173:
3174:
3175:
3176: -- AMS_ACT_METRICS_ALL
3177: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3178: p_table_name => 'AMS_ACT_METRICS_ALL',
3179: p_pk_name => 'METRIC_ID',
3180: p_pk_value => l_metric_id,

Line 3178: p_table_name => 'AMS_ACT_METRICS_ALL',

3174:
3175:
3176: -- AMS_ACT_METRICS_ALL
3177: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3178: p_table_name => 'AMS_ACT_METRICS_ALL',
3179: p_pk_name => 'METRIC_ID',
3180: p_pk_value => l_metric_id,
3181: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER
3182: ) = FND_API.G_TRUE