eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_TESTS_PVT dependencies on FND_GLOBAL

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

199: X_REPORT_PRECISION,
200: X_PRIORITY,
201: X_TEST_OPRN_ID,
202: NVL(X_CREATION_DATE,SYSDATE),
203: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
204: NVL(X_LAST_UPDATE_DATE,SYSDATE),
205: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
206: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
207: X_TEST_GROUP_ORDER

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

201: X_TEST_OPRN_ID,
202: NVL(X_CREATION_DATE,SYSDATE),
203: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
204: NVL(X_LAST_UPDATE_DATE,SYSDATE),
205: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
206: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
207: X_TEST_GROUP_ORDER
208: );
209:

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

202: NVL(X_CREATION_DATE,SYSDATE),
203: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
204: NVL(X_LAST_UPDATE_DATE,SYSDATE),
205: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
206: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
207: X_TEST_GROUP_ORDER
208: );
209:
210: insert into GMD_QC_TESTS_TL (

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

220: ) select
221: X_TEST_ID,
222: X_TEST_DESC,
223: NVL(X_CREATION_DATE,SYSDATE),
224: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
225: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
226: NVL(X_LAST_UPDATE_DATE,SYSDATE),
227: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
228: L.LANGUAGE_CODE,

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

221: X_TEST_ID,
222: X_TEST_DESC,
223: NVL(X_CREATION_DATE,SYSDATE),
224: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
225: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
226: NVL(X_LAST_UPDATE_DATE,SYSDATE),
227: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
228: L.LANGUAGE_CODE,
229: userenv('LANG')

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

223: NVL(X_CREATION_DATE,SYSDATE),
224: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
225: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
226: NVL(X_LAST_UPDATE_DATE,SYSDATE),
227: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
228: L.LANGUAGE_CODE,
229: userenv('LANG')
230: from FND_LANGUAGES L
231: where L.INSTALLED_FLAG in ('I', 'B')

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

719: REPORT_PRECISION = X_REPORT_PRECISION,
720: PRIORITY = X_PRIORITY,
721: TEST_OPRN_ID = X_TEST_OPRN_ID,
722: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
723: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
724: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
725: TEST_GROUP_ORDER = X_TEST_GROUP_ORDER
726: where TEST_ID = X_TEST_ID;
727:

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

720: PRIORITY = X_PRIORITY,
721: TEST_OPRN_ID = X_TEST_OPRN_ID,
722: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
723: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
724: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
725: TEST_GROUP_ORDER = X_TEST_GROUP_ORDER
726: where TEST_ID = X_TEST_ID;
727:
728: if (sql%notfound) then

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

731:
732: update GMD_QC_TESTS_TL set
733: TEST_DESC = X_TEST_DESC,
734: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
735: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
736: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
737: SOURCE_LANG = userenv('LANG')
738: where TEST_ID = X_TEST_ID
739: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

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

732: update GMD_QC_TESTS_TL set
733: TEST_DESC = X_TEST_DESC,
734: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
735: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
736: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
737: SOURCE_LANG = userenv('LANG')
738: where TEST_ID = X_TEST_ID
739: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
740:

Line 902: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),

898: IF (p_test_id IS NOT NULL) THEN
899: UPDATE gmd_qc_tests_b
900: SET delete_mark = 1,
901: last_update_date = NVL(p_last_update_date,SYSDATE),
902: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
903: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
904: WHERE test_id = p_test_id ;
905: IF SQL%NOTFOUND THEN
906: RAISE NO_DATA_FOUND ;

Line 903: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)

899: UPDATE gmd_qc_tests_b
900: SET delete_mark = 1,
901: last_update_date = NVL(p_last_update_date,SYSDATE),
902: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
903: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
904: WHERE test_id = p_test_id ;
905: IF SQL%NOTFOUND THEN
906: RAISE NO_DATA_FOUND ;
907: END IF;

Line 912: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),

908: ELSIF (p_test_code IS NOT NULL) THEN
909: UPDATE gmd_qc_tests_b
910: SET delete_mark = 1,
911: last_update_date = NVL(p_last_update_date,SYSDATE),
912: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
913: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
914: WHERE test_code = p_test_code ;
915: IF SQL%NOTFOUND THEN
916: RAISE NO_DATA_FOUND ;

Line 913: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)

909: UPDATE gmd_qc_tests_b
910: SET delete_mark = 1,
911: last_update_date = NVL(p_last_update_date,SYSDATE),
912: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
913: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
914: WHERE test_code = p_test_code ;
915: IF SQL%NOTFOUND THEN
916: RAISE NO_DATA_FOUND ;
917: END IF;