DBA Data[Home] [Help]

APPS.PA_PERF_BZ_MEASURES_PKG dependencies on FND_GLOBAL

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

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

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

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

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

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

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

53: update PA_PERF_BZ_MEASURES set
54: BZ_EVENT_CODE = X_BZ_EVENT_CODE,
55: MEASURE_ID = X_MEASURE_ID,
56: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
57: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
58: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
59: where MEASURE_ID = X_MEASURE_ID
60: ;
61:

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

54: BZ_EVENT_CODE = X_BZ_EVENT_CODE,
55: MEASURE_ID = X_MEASURE_ID,
56: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
57: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
58: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
59: where MEASURE_ID = X_MEASURE_ID
60: ;
61:
62: if (sql%notfound) then