239: X_ATTRIBUTE28,
240: X_ATTRIBUTE29,
241: X_ATTRIBUTE30,
242: NVL(X_CREATION_DATE,SYSDATE),
243: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
244: NVL(X_LAST_UPDATE_DATE,SYSDATE),
245: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
246: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
247: X_VIABILITY_DURATION,
241: X_ATTRIBUTE30,
242: NVL(X_CREATION_DATE,SYSDATE),
243: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
244: NVL(X_LAST_UPDATE_DATE,SYSDATE),
245: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
246: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
247: X_VIABILITY_DURATION,
248: X_TEST_EXPIRATION_DAYS,
249: X_TEST_EXPIRATION_HOURS,
242: NVL(X_CREATION_DATE,SYSDATE),
243: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
244: NVL(X_LAST_UPDATE_DATE,SYSDATE),
245: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
246: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
247: X_VIABILITY_DURATION,
248: X_TEST_EXPIRATION_DAYS,
249: X_TEST_EXPIRATION_HOURS,
250: X_TEST_EXPIRATION_MINUTES,
264: CREATION_DATE,
265: LANGUAGE,
266: SOURCE_LANG
267: ) select
268: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
269: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
270: NVL(X_LAST_UPDATE_DATE,SYSDATE),
271: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
272: X_SPEC_ID,
265: LANGUAGE,
266: SOURCE_LANG
267: ) select
268: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
269: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
270: NVL(X_LAST_UPDATE_DATE,SYSDATE),
271: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
272: X_SPEC_ID,
273: X_TEST_ID,
267: ) select
268: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
269: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
270: NVL(X_LAST_UPDATE_DATE,SYSDATE),
271: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
272: X_SPEC_ID,
273: X_TEST_ID,
274: X_TEST_DISPLAY,
275: NVL(X_CREATION_DATE,SYSDATE),
784: ATTRIBUTE28 = X_ATTRIBUTE28,
785: ATTRIBUTE29 = X_ATTRIBUTE29,
786: ATTRIBUTE30 = X_ATTRIBUTE30,
787: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
788: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
789: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
790: VIABILITY_DURATION = X_VIABILITY_DURATION ,
791: DAYS = X_TEST_EXPIRATION_DAYS ,
792: HOURS = X_TEST_EXPIRATION_HOURS ,
785: ATTRIBUTE29 = X_ATTRIBUTE29,
786: ATTRIBUTE30 = X_ATTRIBUTE30,
787: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
788: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
789: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
790: VIABILITY_DURATION = X_VIABILITY_DURATION ,
791: DAYS = X_TEST_EXPIRATION_DAYS ,
792: HOURS = X_TEST_EXPIRATION_HOURS ,
793: MINUTES = X_TEST_EXPIRATION_MINUTES ,
803:
804: update GMD_SPEC_TESTS_TL set
805: TEST_DISPLAY = X_TEST_DISPLAY,
806: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
807: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
808: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
809: SOURCE_LANG = userenv('LANG')
810: where SPEC_ID = X_SPEC_ID
811: and TEST_ID = X_TEST_ID
804: update GMD_SPEC_TESTS_TL set
805: TEST_DISPLAY = X_TEST_DISPLAY,
806: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
807: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
808: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
809: SOURCE_LANG = userenv('LANG')
810: where SPEC_ID = X_SPEC_ID
811: and TEST_ID = X_TEST_ID
812: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);