APPS.AMS_METRIC_TEMPLATE_PVT dependencies on AMS_LOOKUPS

Line 1020: SELECT count(1) FROM ams_lookups

1016: x_return_status OUT NOCOPY VARCHAR2
1017: )
1018: IS
1019: CURSOR c_checkObjectType(p_objectType VARCHAR2) IS
1020: SELECT count(1) FROM ams_lookups
1021: WHERE lookup_type = 'AMS_METRIC_OBJECT_TYPE'
1022: AND lookup_code = p_objectType;
1023:
1024: CURSOR c_checkCustomSetup(p_setupId NUMBER) IS

Line 1026: FROM ams_custom_setups_B a, ams_lookups b

1022: AND lookup_code = p_objectType;
1023:
1024: CURSOR c_checkCustomSetup(p_setupId NUMBER) IS
1025: SELECT count(1)
1026: FROM ams_custom_setups_B a, ams_lookups b
1027: WHERE custom_setup_id = p_setupId
1028: AND b.lookup_type in ( 'AMS_METRIC_OBJECT_TYPE', 'AMS_ROLLUP_TYPE')
1029: AND b.lookup_code = a.object_type;
1030:

Line 1097: IF AMS_UTILITY_PVT.Check_Lookup_Exists('ams_lookups',

1093: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_LKP'||
1094: ': lookup_code = '|| p_metric_tpl_header_rec.ASSOCIATION_TYPE);
1095: END IF;
1096:
1097: IF AMS_UTILITY_PVT.Check_Lookup_Exists('ams_lookups',
1098: 'AMS_METRIC_TPL_ASSOC_TYPES',
1099: p_metric_tpl_header_rec.ASSOCIATION_TYPE) = FND_API.G_FALSE THEN
1100: Ams_Utility_Pvt.error_message(
1101: p_message_name => 'AMS_MTH_INVALID_ASSOC_TYPE');