APPS.AMS_DM_TARGET_VALUE_PVT dependencies on AMS_DM_TARGETS_B

Line 203: update ams_dm_targets_b

199:
200: END IF;
201:
202: -- After successfully inserting the target value record, Set the target to Active
203: update ams_dm_targets_b
204: set active_flag = 'Y'
205: where target_id = l_dm_target_value_rec.target_id;
206:
207: -- Also enable the associated data source

Line 670: update ams_dm_targets_b

666:
667: IF l_no_of_target_values = 0 THEN
668:
669: -- Disable this target
670: update ams_dm_targets_b
671: set active_flag = 'N'
672: where target_id = l_target_id;
673:
674: -- Also disable the associated data source if it has no more active targets

Line 1065: 'ams_dm_targets_b',

1061:
1062: --------------------target_id---------------------------
1063: IF p_dm_target_value_rec.target_id <> FND_API.g_miss_num THEN
1064: IF AMS_Utility_PVT.check_fk_exists(
1065: 'ams_dm_targets_b',
1066: 'target_id',
1067: p_dm_target_value_rec.target_id
1068: ) = FND_API.g_false
1069: THEN

Line 1376: FROM ams_list_src_fields a, ams_dm_targets_b b

1372: -- Cursor to get the data type for the target field
1373: -- Added rosharma 28-Nov-2002
1374: CURSOR c_field_data_type (l_tgtId IN NUMBER) IS
1375: SELECT a.field_data_type
1376: FROM ams_list_src_fields a, ams_dm_targets_b b
1377: WHERE b.target_id = l_tgtId
1378: AND a.list_source_field_id = b.source_field_id;
1379:
1380: BEGIN