DBA Data[Home] [Help]

APPS.PA_PERF_OBJECT_RULES_PKG dependencies on FND_GLOBAL

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

35: X_OBJECT_ID,
36: X_RULE_ID,
37: NVL(X_RECORD_VERSION_NUMBER,1), --Changed for Bug# 3812302
38: NVL(X_CREATION_DATE,sysdate),
39: NVL(X_CREATED_BY,fnd_global.user_id),
40: NVL(X_LAST_UPDATE_DATE,sysdate),
41: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
42: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
43:

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

37: NVL(X_RECORD_VERSION_NUMBER,1), --Changed for Bug# 3812302
38: NVL(X_CREATION_DATE,sysdate),
39: NVL(X_CREATED_BY,fnd_global.user_id),
40: NVL(X_LAST_UPDATE_DATE,sysdate),
41: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
42: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
43:
44: open c;
45: fetch c into X_ROWID;

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

38: NVL(X_CREATION_DATE,sysdate),
39: NVL(X_CREATED_BY,fnd_global.user_id),
40: NVL(X_LAST_UPDATE_DATE,sysdate),
41: NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
42: NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id));
43:
44: open c;
45: fetch c into X_ROWID;
46: if (c%notfound) then

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

149: RULE_ID = X_RULE_ID,
150: OBJECT_RULE_ID = X_OBJECT_RULE_ID,
151: RECORD_VERSION_NUMBER = DECODE(X_RECORD_VERSION_NUMBER,NULL,RECORD_VERSION_NUMBER+1,X_RECORD_VERSION_NUMBER+1), --Changed for Bug# 3812302
152: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
153: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
154: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
155: where OBJECT_RULE_ID = X_OBJECT_RULE_ID
156: ;
157:

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

150: OBJECT_RULE_ID = X_OBJECT_RULE_ID,
151: RECORD_VERSION_NUMBER = DECODE(X_RECORD_VERSION_NUMBER,NULL,RECORD_VERSION_NUMBER+1,X_RECORD_VERSION_NUMBER+1), --Changed for Bug# 3812302
152: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
153: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),
154: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,fnd_global.login_id)
155: where OBJECT_RULE_ID = X_OBJECT_RULE_ID
156: ;
157:
158: if (sql%notfound) then