160: IS
161: BEGIN
162: IF (AMS_DEBUG_HIGH_ON) THEN
163:
164: AMS_UTILITY_PVT.debug_message('Table Handler Update going to Update AMS_DM_TARGETS_B' );
165: END IF;
166: IF (AMS_DEBUG_HIGH_ON) THEN
167:
168: AMS_UTILITY_PVT.debug_message(p_target_id || ' ' || p_last_update_date || ' ' || p_last_updated_by);
164: AMS_UTILITY_PVT.debug_message('Table Handler Update going to Update AMS_DM_TARGETS_B' );
165: END IF;
166: IF (AMS_DEBUG_HIGH_ON) THEN
167:
168: AMS_UTILITY_PVT.debug_message(p_target_id || ' ' || p_last_update_date || ' ' || p_last_updated_by);
169: END IF;
170: IF (AMS_DEBUG_HIGH_ON) THEN
171:
172: AMS_UTILITY_PVT.debug_message(p_creation_date || ' ' || p_created_by || ' ' || p_last_update_login);
168: AMS_UTILITY_PVT.debug_message(p_target_id || ' ' || p_last_update_date || ' ' || p_last_updated_by);
169: END IF;
170: IF (AMS_DEBUG_HIGH_ON) THEN
171:
172: AMS_UTILITY_PVT.debug_message(p_creation_date || ' ' || p_created_by || ' ' || p_last_update_login);
173: END IF;
174: IF (AMS_DEBUG_HIGH_ON) THEN
175:
176: AMS_UTILITY_PVT.debug_message(p_object_version_number || ' ' || p_active_flag || ' ' || p_model_type);
172: AMS_UTILITY_PVT.debug_message(p_creation_date || ' ' || p_created_by || ' ' || p_last_update_login);
173: END IF;
174: IF (AMS_DEBUG_HIGH_ON) THEN
175:
176: AMS_UTILITY_PVT.debug_message(p_object_version_number || ' ' || p_active_flag || ' ' || p_model_type);
177: END IF;
178: IF (AMS_DEBUG_HIGH_ON) THEN
179:
180: AMS_UTILITY_PVT.debug_message(p_data_source_id || ' ' || p_source_field_id);
176: AMS_UTILITY_PVT.debug_message(p_object_version_number || ' ' || p_active_flag || ' ' || p_model_type);
177: END IF;
178: IF (AMS_DEBUG_HIGH_ON) THEN
179:
180: AMS_UTILITY_PVT.debug_message(p_data_source_id || ' ' || p_source_field_id);
181: END IF;
182: Update AMS_DM_TARGETS_B
183: SET
184: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
203: IF (AMS_DEBUG_HIGH_ON) THEN
204:
205:
206:
207: AMS_UTILITY_PVT.debug_message('Table Handler Update going to Update ams_dm_targets_tl' );
208:
209: END IF;
210:
211: -- update target name and description in TL table