35: X_COMMENT_TEXT,
36: X_COMMENTED_BY,
37: X_COMMENT_DATE,
38: NVL(X_CREATION_DATE,sysdate),
39: NVL(X_CREATED_BY,fnd_global.user_id),
40: NVL(X_LAST_UPDATE_DATE,sysdate),
41: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
42: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
43:
37: X_COMMENT_DATE,
38: NVL(X_CREATION_DATE,sysdate),
39: NVL(X_CREATED_BY,fnd_global.user_id),
40: NVL(X_LAST_UPDATE_DATE,sysdate),
41: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
42: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
43:
44: open c;
45: fetch c into X_ROWID;
38: NVL(X_CREATION_DATE,sysdate),
39: NVL(X_CREATED_BY,fnd_global.user_id),
40: NVL(X_LAST_UPDATE_DATE,sysdate),
41: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
42: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
43:
44: open c;
45: fetch c into X_ROWID;
46: if (c%notfound) then
69: COMMENTED_BY = X_COMMENTED_BY,
70: COMMENT_DATE = X_COMMENT_DATE,
71: COMMENT_ID = X_COMMENT_ID,
72: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
73: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
74: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
75: where COMMENT_ID = X_COMMENT_ID
76: ;
77:
70: COMMENT_DATE = X_COMMENT_DATE,
71: COMMENT_ID = X_COMMENT_ID,
72: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
73: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
74: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
75: where COMMENT_ID = X_COMMENT_ID
76: ;
77:
78: if (sql%notfound) then