167:
168: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
169: END IF;
170:
171: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Insert_Row)
172: AMS_DM_TARGET_VALUES_B_PKG.Insert_Row(
173: px_target_value_id => l_dm_target_value_rec.TARGET_VALUE_ID,
174: p_last_update_date => SYSDATE,
175: p_last_updated_by => G_USER_ID,
168: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
169: END IF;
170:
171: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Insert_Row)
172: AMS_DM_TARGET_VALUES_B_PKG.Insert_Row(
173: px_target_value_id => l_dm_target_value_rec.TARGET_VALUE_ID,
174: p_last_update_date => SYSDATE,
175: p_last_updated_by => G_USER_ID,
176: p_creation_date => SYSDATE,
424:
425: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
426: END IF;
427:
428: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Update_Row)
429: AMS_DM_TARGET_VALUES_B_PKG.Update_Row(
430: p_target_value_id => l_tar_dm_target_value_rec.target_value_id,
431: p_last_update_date => SYSDATE,
432: p_last_updated_by => G_USER_ID,
425: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
426: END IF;
427:
428: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Update_Row)
429: AMS_DM_TARGET_VALUES_B_PKG.Update_Row(
430: p_target_value_id => l_tar_dm_target_value_rec.target_value_id,
431: p_last_update_date => SYSDATE,
432: p_last_updated_by => G_USER_ID,
433: p_last_update_login => G_LOGIN_ID,
651: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Before Delete: TARGET_ID = ' || l_target_id );
652:
653: END IF;
654:
655: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Delete_Row)
656: AMS_DM_TARGET_VALUES_B_PKG.Delete_Row(
657: p_TARGET_VALUE_ID => p_TARGET_VALUE_ID);
658:
659:
652:
653: END IF;
654:
655: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Delete_Row)
656: AMS_DM_TARGET_VALUES_B_PKG.Delete_Row(
657: p_TARGET_VALUE_ID => p_TARGET_VALUE_ID);
658:
659:
660: -- After successfully deleteing the target value, check if there are no more