DBA Data[Home] [Help]

APPS.GMD_SPEC_TESTS_PVT dependencies on FND_GLOBAL

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

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,

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

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,

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

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,

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

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,

Line 269: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_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,

Line 271: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_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),

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

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 ,

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

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 ,

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

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

Line 808: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_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);