DBA Data[Home] [Help]

APPS.PA_PERF_CMTS_PKG dependencies on FND_GLOBAL

Line 39: NVL(X_CREATED_BY,fnd_global.user_id),

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:

Line 41: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),

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;

Line 42: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));

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

Line 73: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),

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:

Line 74: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)

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