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_SPECIFICATIONS_PVT dependencies on FND_GLOBAL

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

163: X_ATTRIBUTE28,
164: X_ATTRIBUTE29,
165: X_ATTRIBUTE30,
166: NVL(X_CREATION_DATE,SYSDATE),
167: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
168: NVL(X_LAST_UPDATE_DATE,SYSDATE),
169: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
170: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
171: );

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

165: X_ATTRIBUTE30,
166: NVL(X_CREATION_DATE,SYSDATE),
167: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
168: NVL(X_LAST_UPDATE_DATE,SYSDATE),
169: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
170: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
171: );
172:
173: INSERT INTO GMD_SPECIFICATIONS_TL (

Line 170: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

166: NVL(X_CREATION_DATE,SYSDATE),
167: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
168: NVL(X_LAST_UPDATE_DATE,SYSDATE),
169: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
170: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
171: );
172:
173: INSERT INTO GMD_SPECIFICATIONS_TL (
174: SPEC_ID,

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

183: ) SELECT
184: X_SPEC_ID,
185: X_SPEC_DESC,
186: NVL(X_CREATION_DATE,SYSDATE),
187: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
188: NVL(X_LAST_UPDATE_DATE,SYSDATE),
189: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
190: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
191: L.LANGUAGE_CODE,

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

185: X_SPEC_DESC,
186: NVL(X_CREATION_DATE,SYSDATE),
187: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
188: NVL(X_LAST_UPDATE_DATE,SYSDATE),
189: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
190: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
191: L.LANGUAGE_CODE,
192: USERENV('LANG')
193: FROM FND_LANGUAGES L

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

186: NVL(X_CREATION_DATE,SYSDATE),
187: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
188: NVL(X_LAST_UPDATE_DATE,SYSDATE),
189: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
190: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
191: L.LANGUAGE_CODE,
192: USERENV('LANG')
193: FROM FND_LANGUAGES L
194: WHERE L.INSTALLED_FLAG IN ('I', 'B')

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

527: ATTRIBUTE28 = X_ATTRIBUTE28,
528: ATTRIBUTE29 = X_ATTRIBUTE29,
529: ATTRIBUTE30 = X_ATTRIBUTE30,
530: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
531: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
532: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
533: WHERE SPEC_ID = X_SPEC_ID;
534:
535: IF (SQL%NOTFOUND) THEN

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

528: ATTRIBUTE29 = X_ATTRIBUTE29,
529: ATTRIBUTE30 = X_ATTRIBUTE30,
530: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
531: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
532: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
533: WHERE SPEC_ID = X_SPEC_ID;
534:
535: IF (SQL%NOTFOUND) THEN
536: RAISE NO_DATA_FOUND;

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

538:
539: UPDATE GMD_SPECIFICATIONS_TL SET
540: SPEC_DESC = X_SPEC_DESC,
541: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
542: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
543: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
544: SOURCE_LANG = USERENV('LANG')
545: WHERE SPEC_ID = X_SPEC_ID
546: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

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

539: UPDATE GMD_SPECIFICATIONS_TL SET
540: SPEC_DESC = X_SPEC_DESC,
541: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
542: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
543: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
544: SOURCE_LANG = USERENV('LANG')
545: WHERE SPEC_ID = X_SPEC_ID
546: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
547:

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

706: IF (p_spec_id IS NOT NULL) THEN
707: UPDATE gmd_specifications_b
708: SET delete_mark = 1,
709: last_update_date = NVL(p_last_update_date,SYSDATE),
710: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
711: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
712: WHERE spec_id = p_spec_id ;
713: IF SQL%NOTFOUND THEN
714: RAISE NO_DATA_FOUND ;

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

707: UPDATE gmd_specifications_b
708: SET delete_mark = 1,
709: last_update_date = NVL(p_last_update_date,SYSDATE),
710: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
711: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
712: WHERE spec_id = p_spec_id ;
713: IF SQL%NOTFOUND THEN
714: RAISE NO_DATA_FOUND ;
715: END IF;

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

716: ELSIF (p_spec_name IS NOT NULL and p_spec_vers IS NOT NULL) THEN
717: UPDATE gmd_specifications_b
718: SET delete_mark = 1,
719: last_update_date = NVL(p_last_update_date,SYSDATE),
720: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
721: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
722: WHERE spec_name = p_spec_name and spec_vers = p_spec_vers ;
723: IF SQL%NOTFOUND THEN
724: RAISE NO_DATA_FOUND ;

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

717: UPDATE gmd_specifications_b
718: SET delete_mark = 1,
719: last_update_date = NVL(p_last_update_date,SYSDATE),
720: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
721: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
722: WHERE spec_name = p_spec_name and spec_vers = p_spec_vers ;
723: IF SQL%NOTFOUND THEN
724: RAISE NO_DATA_FOUND ;
725: END IF;