183: where MR_ACTION_ID = X_MR_ACTION_ID
184: AND object_version_number=x_object_version_number;
185:
186: if (sql%ROWCOUNT=0) then
187: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
188: FND_MSG_PUB.ADD;
189: else
190: update AHL_MR_ACTIONS_TL set
191: DESCRIPTION = X_DESCRIPTION,
206: delete from AHL_MR_ACTIONS_TL
207: where MR_ACTION_ID = X_MR_ACTION_ID;
208:
209: if (sql%ROWCOUNT=0) then
210: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
211: FND_MSG_PUB.ADD;
212: else
213: delete from AHL_MR_ACTIONS_B
214: where MR_ACTION_ID = X_MR_ACTION_ID;
212: else
213: delete from AHL_MR_ACTIONS_B
214: where MR_ACTION_ID = X_MR_ACTION_ID;
215: if (sql%ROWCOUNT=0) then
216: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
217: FND_MSG_PUB.ADD;
218: END IF;
219:
220: END IF;