DBA Data[Home] [Help]

APPS.PA_PERF_KPA_SUMMARY_PKG dependencies on FND_GLOBAL

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

113: X_KPA5_SCORE,
114: X_KPA5_THRES_FROM,
115: X_KPA5_THRES_TO,
116: NVL(X_CREATION_DATE,sysdate),
117: NVL(X_CREATED_BY,fnd_global.user_id),
118: NVL(X_LAST_UPDATE_DATE,sysdate),
119: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
120: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
121:

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

115: X_KPA5_THRES_TO,
116: NVL(X_CREATION_DATE,sysdate),
117: NVL(X_CREATED_BY,fnd_global.user_id),
118: NVL(X_LAST_UPDATE_DATE,sysdate),
119: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
120: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
121:
122: open c;
123: fetch c into X_ROWID;

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

116: NVL(X_CREATION_DATE,sysdate),
117: NVL(X_CREATED_BY,fnd_global.user_id),
118: NVL(X_LAST_UPDATE_DATE,sysdate),
119: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
120: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
121:
122: open c;
123: fetch c into X_ROWID;
124: if (c%notfound) then

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

200: KPA5_THRES_FROM = X_KPA5_THRES_FROM,
201: KPA5_THRES_TO = X_KPA5_THRES_FROM,
202: KPA_SUMMARY_ID = X_KPA_SUMMARY_ID,
203: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
204: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
205: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
206: where KPA_SUMMARY_ID = X_KPA_SUMMARY_ID
207: ;
208:

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

201: KPA5_THRES_TO = X_KPA5_THRES_FROM,
202: KPA_SUMMARY_ID = X_KPA_SUMMARY_ID,
203: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
204: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
205: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
206: where KPA_SUMMARY_ID = X_KPA_SUMMARY_ID
207: ;
208:
209: if (sql%notfound) then