DBA Data[Home] [Help]

APPS.PA_PERF_RULES_PKG dependencies on FND_GLOBAL

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

62: X_END_DATE_ACTIVE,
63: X_SCORE_METHOD,
64: NVL(X_RECORD_VERSION_NUMBER,1),
65: NVL(X_CREATION_DATE,sysdate),
66: NVL(X_CREATED_BY,fnd_global.user_id),
67: NVL(X_LAST_UPDATE_DATE,sysdate),
68: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
69: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
70:

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

64: NVL(X_RECORD_VERSION_NUMBER,1),
65: NVL(X_CREATION_DATE,sysdate),
66: NVL(X_CREATED_BY,fnd_global.user_id),
67: NVL(X_LAST_UPDATE_DATE,sysdate),
68: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
69: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
70:
71: open c;
72: fetch c into X_ROWID;

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

65: NVL(X_CREATION_DATE,sysdate),
66: NVL(X_CREATED_BY,fnd_global.user_id),
67: NVL(X_LAST_UPDATE_DATE,sysdate),
68: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
69: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
70:
71: open c;
72: fetch c into X_ROWID;
73: if (c%notfound) then

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

196: SCORE_METHOD = X_SCORE_METHOD,
197: RULE_ID = X_RULE_ID,
198: RECORD_VERSION_NUMBER = NVL(X_RECORD_VERSION_NUMBER,RECORD_VERSION_NUMBER+1),
199: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
200: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
201: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
202: where RULE_ID = X_RULE_ID;
203:
204: if (sql%notfound) then

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

197: RULE_ID = X_RULE_ID,
198: RECORD_VERSION_NUMBER = NVL(X_RECORD_VERSION_NUMBER,RECORD_VERSION_NUMBER+1),
199: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
200: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
201: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
202: where RULE_ID = X_RULE_ID;
203:
204: if (sql%notfound) then
205: raise no_data_found;