214: begin
215: update JTF_RS_TEAM_MEMBERS set
216: DELETE_FLAG = 'Y',
217: LAST_UPDATE_DATE = sysdate,
218: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
219: LAST_UPDATE_LOGIN = nvl(fnd_global.login_id,-1)
220: where TEAM_MEMBER_ID = X_TEAM_MEMBER_ID;
221:
222: if (sql%notfound) then
215: update JTF_RS_TEAM_MEMBERS set
216: DELETE_FLAG = 'Y',
217: LAST_UPDATE_DATE = sysdate,
218: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
219: LAST_UPDATE_LOGIN = nvl(fnd_global.login_id,-1)
220: where TEAM_MEMBER_ID = X_TEAM_MEMBER_ID;
221:
222: if (sql%notfound) then
223: raise no_data_found;