241: ,p_work_permit_header_rec.ATTRIBUTE29
242: ,p_work_permit_header_rec.ATTRIBUTE30
243: ,decode(p_work_permit_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_work_permit_header_rec.APPROVED_BY)
244: ,SYSDATE
245: ,FND_GLOBAL.user_id
246: ,SYSDATE
247: ,FND_GLOBAL.user_id
248: ,FND_GLOBAL.login_id);
249:
243: ,decode(p_work_permit_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_work_permit_header_rec.APPROVED_BY)
244: ,SYSDATE
245: ,FND_GLOBAL.user_id
246: ,SYSDATE
247: ,FND_GLOBAL.user_id
248: ,FND_GLOBAL.login_id);
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
244: ,SYSDATE
245: ,FND_GLOBAL.user_id
246: ,SYSDATE
247: ,FND_GLOBAL.user_id
248: ,FND_GLOBAL.login_id);
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252:
315: ,ATTRIBUTE28 =p_work_permit_header_rec.ATTRIBUTE28
316: ,ATTRIBUTE29 =p_work_permit_header_rec.ATTRIBUTE29
317: ,ATTRIBUTE30 =p_work_permit_header_rec.ATTRIBUTE30
318: ,LAST_UPDATE_DATE =SYSDATE
319: ,LAST_UPDATED_BY =FND_GLOBAL.user_id
320: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
321: WHERE permit_id = p_work_permit_header_rec.permit_id
322: AND organization_id = p_work_permit_header_rec.organization_id;
323:
316: ,ATTRIBUTE29 =p_work_permit_header_rec.ATTRIBUTE29
317: ,ATTRIBUTE30 =p_work_permit_header_rec.ATTRIBUTE30
318: ,LAST_UPDATE_DATE =SYSDATE
319: ,LAST_UPDATED_BY =FND_GLOBAL.user_id
320: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
321: WHERE permit_id = p_work_permit_header_rec.permit_id
322: AND organization_id = p_work_permit_header_rec.organization_id;
323:
324: x_return_status := FND_API.G_RET_STS_SUCCESS;