154: p_cal_asg_info.freight_org_id,
155: p_cal_asg_info.carrier_id,
156: p_cal_asg_info.carrier_site_id,
157: sysdate,
158: fnd_global.user_id,
159: sysdate,
160: fnd_global.user_id,
161: fnd_global.login_id,
162: p_cal_asg_info.ATTRIBUTE_CATEGORY,
156: p_cal_asg_info.carrier_site_id,
157: sysdate,
158: fnd_global.user_id,
159: sysdate,
160: fnd_global.user_id,
161: fnd_global.login_id,
162: p_cal_asg_info.ATTRIBUTE_CATEGORY,
163: p_cal_asg_info.ATTRIBUTE1,
164: p_cal_asg_info.ATTRIBUTE2,
157: sysdate,
158: fnd_global.user_id,
159: sysdate,
160: fnd_global.user_id,
161: fnd_global.login_id,
162: p_cal_asg_info.ATTRIBUTE_CATEGORY,
163: p_cal_asg_info.ATTRIBUTE1,
164: p_cal_asg_info.ATTRIBUTE2,
165: p_cal_asg_info.ATTRIBUTE3,
338: , ATTRIBUTE13 = p_cal_asg_info.ATTRIBUTE13
339: , ATTRIBUTE14 = p_cal_asg_info.ATTRIBUTE14
340: , ATTRIBUTE15 = p_cal_asg_info.ATTRIBUTE15
341: , LAST_UPDATE_DATE = sysdate
342: , LAST_UPDATED_BY = FND_GLOBAL.user_id
343: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
344: WHERE CALENDAR_ASSIGNMENT_ID = p_calendar_asgmt_id;
345:
346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
339: , ATTRIBUTE14 = p_cal_asg_info.ATTRIBUTE14
340: , ATTRIBUTE15 = p_cal_asg_info.ATTRIBUTE15
341: , LAST_UPDATE_DATE = sysdate
342: , LAST_UPDATED_BY = FND_GLOBAL.user_id
343: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
344: WHERE CALENDAR_ASSIGNMENT_ID = p_calendar_asgmt_id;
345:
346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;