DBA Data[Home] [Help]

APPS.PA_PERF_KPA_TRANS_PKG dependencies on FND_GLOBAL

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

27: values (
28: X_KPA_SUMMARY_DET_ID,
29: X_PERF_TXN_ID,
30: NVL(X_CREATION_DATE,sysdate),
31: NVL(X_CREATED_BY,fnd_global.user_id),
32: NVL(X_LAST_UPDATE_DATE,sysdate),
33: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
34: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
35:

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

29: X_PERF_TXN_ID,
30: NVL(X_CREATION_DATE,sysdate),
31: NVL(X_CREATED_BY,fnd_global.user_id),
32: NVL(X_LAST_UPDATE_DATE,sysdate),
33: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
34: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
35:
36:
37: open c;

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

30: NVL(X_CREATION_DATE,sysdate),
31: NVL(X_CREATED_BY,fnd_global.user_id),
32: NVL(X_LAST_UPDATE_DATE,sysdate),
33: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
34: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
35:
36:
37: open c;
38: fetch c into X_ROWID;

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

56: update PA_PERF_KPA_TRANS set
57: KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID,
58: PERF_TXN_ID = X_PERF_TXN_ID,
59: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
60: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
61: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
62: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
63: and PERF_TXN_ID = X_PERF_TXN_ID
64: ;

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

57: KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID,
58: PERF_TXN_ID = X_PERF_TXN_ID,
59: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
60: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
61: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
62: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
63: and PERF_TXN_ID = X_PERF_TXN_ID
64: ;
65: