166: v_jtf_cal_shift_assign_s,
167: X_CALENDAR_ID,
168: X_SHIFT_SEQUENCE_NUMBER,
169: X_SHIFT_ID,
170: FND_GLOBAL.USER_ID,
171: sysdate,
172: FND_GLOBAL.USER_ID,
173: sysdate,
174: FND_GLOBAL.LOGIN_ID,
168: X_SHIFT_SEQUENCE_NUMBER,
169: X_SHIFT_ID,
170: FND_GLOBAL.USER_ID,
171: sysdate,
172: FND_GLOBAL.USER_ID,
173: sysdate,
174: FND_GLOBAL.LOGIN_ID,
175: X_ATTRIBUTE1,
176: X_ATTRIBUTE2,
170: FND_GLOBAL.USER_ID,
171: sysdate,
172: FND_GLOBAL.USER_ID,
173: sysdate,
174: FND_GLOBAL.LOGIN_ID,
175: X_ATTRIBUTE1,
176: X_ATTRIBUTE2,
177: X_ATTRIBUTE4,
178: X_ATTRIBUTE5,
419: ATTRIBUTE15 = X_ATTRIBUTE15,
420: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
421: CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID,
422: LAST_UPDATE_DATE = SYSDATE,
423: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
424: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
425: where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID;
426:
427: -- if (sql%notfound) then
420: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
421: CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID,
422: LAST_UPDATE_DATE = SYSDATE,
423: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
424: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
425: where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID;
426:
427: -- if (sql%notfound) then
428: -- raise no_data_found;