DBA Data[Home] [Help]

APPS.PA_PERF_KPA_SUMDET_PKG dependencies on FND_GLOBAL

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

77: X_IND4_SCORE,
78: X_IND5_COUNT,
79: X_IND5_SCORE,
80: NVL(X_CREATION_DATE,sysdate),
81: NVL(X_CREATED_BY,fnd_global.user_id),
82: NVL(X_LAST_UPDATE_DATE,sysdate),
83: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
84: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
85:

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

79: X_IND5_SCORE,
80: NVL(X_CREATION_DATE,sysdate),
81: NVL(X_CREATED_BY,fnd_global.user_id),
82: NVL(X_LAST_UPDATE_DATE,sysdate),
83: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
84: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
85:
86:
87: open c;

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

80: NVL(X_CREATION_DATE,sysdate),
81: NVL(X_CREATED_BY,fnd_global.user_id),
82: NVL(X_LAST_UPDATE_DATE,sysdate),
83: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
84: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
85:
86:
87: open c;
88: fetch c into X_ROWID;

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

140: IND4_SCORE = X_IND4_SCORE,
141: IND5_COUNT = X_IND5_COUNT,
142: IND5_SCORE = X_IND5_SCORE,
143: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
144: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
145: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
146: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
147: ;
148:

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

141: IND5_COUNT = X_IND5_COUNT,
142: IND5_SCORE = X_IND5_SCORE,
143: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
144: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
145: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
146: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
147: ;
148:
149: if (sql%notfound) then