DBA Data[Home] [Help]

APPS.GMD_QC_TEST_VALUES_PVT dependencies on FND_GLOBAL

Line 147: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),

143: X_ATTRIBUTE28,
144: X_ATTRIBUTE29,
145: X_ATTRIBUTE30,
146: NVL(X_CREATION_DATE,SYSDATE),
147: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
148: NVL(X_LAST_UPDATE_DATE,SYSDATE),
149: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
150: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
151: );

Line 149: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

145: X_ATTRIBUTE30,
146: NVL(X_CREATION_DATE,SYSDATE),
147: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
148: NVL(X_LAST_UPDATE_DATE,SYSDATE),
149: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
150: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
151: );
152:
153: insert into GMD_QC_TEST_VALUES_TL (

Line 150: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

146: NVL(X_CREATION_DATE,SYSDATE),
147: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
148: NVL(X_LAST_UPDATE_DATE,SYSDATE),
149: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
150: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
151: );
152:
153: insert into GMD_QC_TEST_VALUES_TL (
154: TEST_VALUE_ID,

Line 169: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),

165: X_TEST_VALUE_ID,
166: X_DISPLAY_LABEL_NUMERIC_RANGE,
167: X_TEST_VALUE_DESC,
168: NVL(X_CREATION_DATE,SYSDATE),
169: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
170: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
171: NVL(X_LAST_UPDATE_DATE,SYSDATE),
172: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
173: L.LANGUAGE_CODE,

Line 170: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

166: X_DISPLAY_LABEL_NUMERIC_RANGE,
167: X_TEST_VALUE_DESC,
168: NVL(X_CREATION_DATE,SYSDATE),
169: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
170: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
171: NVL(X_LAST_UPDATE_DATE,SYSDATE),
172: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
173: L.LANGUAGE_CODE,
174: userenv('LANG')

Line 172: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

168: NVL(X_CREATION_DATE,SYSDATE),
169: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
170: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
171: NVL(X_LAST_UPDATE_DATE,SYSDATE),
172: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
173: L.LANGUAGE_CODE,
174: userenv('LANG')
175: from FND_LANGUAGES L
176: where L.INSTALLED_FLAG in ('I', 'B')

Line 544: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

540: ATTRIBUTE28 = X_ATTRIBUTE28,
541: ATTRIBUTE29 = X_ATTRIBUTE29,
542: ATTRIBUTE30 = X_ATTRIBUTE30,
543: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
544: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
545: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
546: where TEST_VALUE_ID = X_TEST_VALUE_ID;
547:
548: if (sql%notfound) then

Line 545: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

541: ATTRIBUTE29 = X_ATTRIBUTE29,
542: ATTRIBUTE30 = X_ATTRIBUTE30,
543: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
544: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
545: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
546: where TEST_VALUE_ID = X_TEST_VALUE_ID;
547:
548: if (sql%notfound) then
549: raise no_data_found;