272: ,p_safety_establishment_rec.ATTRIBUTE28
273: ,p_safety_establishment_rec.ATTRIBUTE29
274: ,p_safety_establishment_rec.ATTRIBUTE30
275: ,SYSDATE
276: ,FND_GLOBAL.user_id
277: ,SYSDATE
278: ,FND_GLOBAL.user_id
279: ,FND_GLOBAL.login_id);
280:
274: ,p_safety_establishment_rec.ATTRIBUTE30
275: ,SYSDATE
276: ,FND_GLOBAL.user_id
277: ,SYSDATE
278: ,FND_GLOBAL.user_id
279: ,FND_GLOBAL.login_id);
280:
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282:
275: ,SYSDATE
276: ,FND_GLOBAL.user_id
277: ,SYSDATE
278: ,FND_GLOBAL.user_id
279: ,FND_GLOBAL.login_id);
280:
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282:
283:
352: ,ATTRIBUTE28 =p_safety_establishment_rec.ATTRIBUTE28
353: ,ATTRIBUTE29 =p_safety_establishment_rec.ATTRIBUTE29
354: ,ATTRIBUTE30 =p_safety_establishment_rec.ATTRIBUTE30
355: ,LAST_UPDATE_DATE =SYSDATE
356: ,LAST_UPDATED_BY =FND_GLOBAL.user_id
357: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
358: WHERE establishment_id = p_safety_establishment_rec.establishment_id
359: AND organization_id = p_safety_establishment_rec.organization_id;
360:
353: ,ATTRIBUTE29 =p_safety_establishment_rec.ATTRIBUTE29
354: ,ATTRIBUTE30 =p_safety_establishment_rec.ATTRIBUTE30
355: ,LAST_UPDATE_DATE =SYSDATE
356: ,LAST_UPDATED_BY =FND_GLOBAL.user_id
357: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
358: WHERE establishment_id = p_safety_establishment_rec.establishment_id
359: AND organization_id = p_safety_establishment_rec.organization_id;
360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS;