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: );
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 (
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,
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,
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')
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')
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
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;