98: X_CURRENT_FLAG,
99: X_INCLUDED_IN_SCORING,
100: NVL(X_RECORD_VERSION_NUMBER,1),
101: NVL(X_CREATION_DATE,sysdate),
102: NVL(X_CREATED_BY,fnd_global.user_id),
103: NVL(X_LAST_UPDATE_DATE,sysdate),
104: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
105: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
106: );
100: NVL(X_RECORD_VERSION_NUMBER,1),
101: NVL(X_CREATION_DATE,sysdate),
102: NVL(X_CREATED_BY,fnd_global.user_id),
103: NVL(X_LAST_UPDATE_DATE,sysdate),
104: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
105: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
106: );
107:
108: open c;
101: NVL(X_CREATION_DATE,sysdate),
102: NVL(X_CREATED_BY,fnd_global.user_id),
103: NVL(X_LAST_UPDATE_DATE,sysdate),
104: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
105: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
106: );
107:
108: open c;
109: fetch c into X_ROWID;
257: CURRENT_FLAG = X_CURRENT_FLAG,
258: INCLUDED_IN_SCORING = X_INCLUDED_IN_SCORING,
259: RECORD_VERSION_NUMBER = NVL(X_RECORD_VERSION_NUMBER,RECORD_VERSION_NUMBER+1),
260: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
261: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
262: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
263: where PERF_TXN_ID = X_PERF_TXN_ID
264: ;
265:
258: INCLUDED_IN_SCORING = X_INCLUDED_IN_SCORING,
259: RECORD_VERSION_NUMBER = NVL(X_RECORD_VERSION_NUMBER,RECORD_VERSION_NUMBER+1),
260: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
261: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
262: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
263: where PERF_TXN_ID = X_PERF_TXN_ID
264: ;
265:
266: if (sql%notfound) then