DBA Data[Home] [Help]

APPS.AMS_METRIC_PVT dependencies on AMS_ACT_METRICS_ALL

Line 3165: SELECT 1 from AMS_ACT_METRICS_ALL

3161: l_metric_id NUMBER := p_metric_id;
3162: l_return_status VARCHAR2(1);
3163:
3164: CURSOR c_check_metric_id(p_metric_id number) IS
3165: SELECT 1 from AMS_ACT_METRICS_ALL
3166: WHERE METRIC_ID = p_metric_id ;
3167:
3168:
3169: BEGIN

Line 3183: -- AMS_ACT_METRICS_ALL

3179: CLOSE c_check_metric_id;
3180:
3181:
3182:
3183: -- AMS_ACT_METRICS_ALL
3184: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3185: p_table_name => 'AMS_ACT_METRICS_ALL',
3186: p_pk_name => 'METRIC_ID',
3187: p_pk_value => l_metric_id,

Line 3185: p_table_name => 'AMS_ACT_METRICS_ALL',

3181:
3182:
3183: -- AMS_ACT_METRICS_ALL
3184: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3185: p_table_name => 'AMS_ACT_METRICS_ALL',
3186: p_pk_name => 'METRIC_ID',
3187: p_pk_value => l_metric_id,
3188: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER
3189: ) = FND_API.G_TRUE