233: ,p_safety_association_rec.ATTRIBUTE28
234: ,p_safety_association_rec.ATTRIBUTE29
235: ,p_safety_association_rec.ATTRIBUTE30
236: ,SYSDATE
237: ,FND_GLOBAL.user_id
238: ,SYSDATE
239: ,FND_GLOBAL.user_id
240: ,FND_GLOBAL.login_id);
241:
235: ,p_safety_association_rec.ATTRIBUTE30
236: ,SYSDATE
237: ,FND_GLOBAL.user_id
238: ,SYSDATE
239: ,FND_GLOBAL.user_id
240: ,FND_GLOBAL.login_id);
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: EXCEPTION
236: ,SYSDATE
237: ,FND_GLOBAL.user_id
238: ,SYSDATE
239: ,FND_GLOBAL.user_id
240: ,FND_GLOBAL.login_id);
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: EXCEPTION
244: WHEN OTHERS THEN
304: ,ATTRIBUTE28 =p_safety_association_rec.ATTRIBUTE28
305: ,ATTRIBUTE29 =p_safety_association_rec.ATTRIBUTE29
306: ,ATTRIBUTE30 =p_safety_association_rec.ATTRIBUTE30
307: ,LAST_UPDATE_DATE =SYSDATE
308: ,LAST_UPDATED_BY =FND_GLOBAL.user_id
309: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
310:
311: WHERE SAFETY_ASSOCIATION_ID=p_safety_association_rec.SAFETY_ASSOCIATION_ID
312: AND ASSOCIATION_TYPE=p_safety_association_rec.ASSOCIATION_TYPE;
305: ,ATTRIBUTE29 =p_safety_association_rec.ATTRIBUTE29
306: ,ATTRIBUTE30 =p_safety_association_rec.ATTRIBUTE30
307: ,LAST_UPDATE_DATE =SYSDATE
308: ,LAST_UPDATED_BY =FND_GLOBAL.user_id
309: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
310:
311: WHERE SAFETY_ASSOCIATION_ID=p_safety_association_rec.SAFETY_ASSOCIATION_ID
312: AND ASSOCIATION_TYPE=p_safety_association_rec.ASSOCIATION_TYPE;
313: