APPS.MTL_CROSS_REFERENCES_PKG dependencies on FND_GLOBAL

Line 125: ,NVL(P_CREATED_BY,FND_GLOBAL.USER_ID)

121: ,P_ATTRIBUTE14
122: ,P_ATTRIBUTE15
123: ,P_ATTRIBUTE_CATEGORY
124: ,NVL(P_CREATION_DATE,SYSDATE)
125: ,NVL(P_CREATED_BY,FND_GLOBAL.USER_ID)
126: ,NVL(P_LAST_UPDATE_DATE,SYSDATE)
127: ,NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)
128: ,NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
129: ,P_PROGRAM_APPLICATION_ID

Line 127: ,NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)

123: ,P_ATTRIBUTE_CATEGORY
124: ,NVL(P_CREATION_DATE,SYSDATE)
125: ,NVL(P_CREATED_BY,FND_GLOBAL.USER_ID)
126: ,NVL(P_LAST_UPDATE_DATE,SYSDATE)
127: ,NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)
128: ,NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
129: ,P_PROGRAM_APPLICATION_ID
130: ,P_PROGRAM_ID
131: ,P_PROGRAM_UPDATE_DATE)

Line 128: ,NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

124: ,NVL(P_CREATION_DATE,SYSDATE)
125: ,NVL(P_CREATED_BY,FND_GLOBAL.USER_ID)
126: ,NVL(P_LAST_UPDATE_DATE,SYSDATE)
127: ,NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)
128: ,NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
129: ,P_PROGRAM_APPLICATION_ID
130: ,P_PROGRAM_ID
131: ,P_PROGRAM_UPDATE_DATE)
132: RETURNING CROSS_REFERENCE_ID INTO X_CROSS_REFERENCE_ID ;

Line 145: NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

141: ,CROSS_REFERENCE_ID
142: ,LANGUAGE
143: ,SOURCE_LANG)
144: SELECT
145: NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
146: P_DESCRIPTION,
147: NVL(P_CREATION_DATE,SYSDATE),
148: NVL(P_CREATED_BY,FND_GLOBAL.USER_ID),
149: NVL(P_LAST_UPDATE_DATE,SYSDATE),

Line 148: NVL(P_CREATED_BY,FND_GLOBAL.USER_ID),

144: SELECT
145: NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
146: P_DESCRIPTION,
147: NVL(P_CREATION_DATE,SYSDATE),
148: NVL(P_CREATED_BY,FND_GLOBAL.USER_ID),
149: NVL(P_LAST_UPDATE_DATE,SYSDATE),
150: NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
151: X_CROSS_REFERENCE_ID,
152: L.LANGUAGE_CODE,

Line 150: NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

146: P_DESCRIPTION,
147: NVL(P_CREATION_DATE,SYSDATE),
148: NVL(P_CREATED_BY,FND_GLOBAL.USER_ID),
149: NVL(P_LAST_UPDATE_DATE,SYSDATE),
150: NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
151: X_CROSS_REFERENCE_ID,
152: L.LANGUAGE_CODE,
153: USERENV('LANG')
154: FROM FND_LANGUAGES L

Line 397: ,LAST_UPDATED_BY = NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)

393: ,ATTRIBUTE14 = P_ATTRIBUTE14
394: ,ATTRIBUTE15 = P_ATTRIBUTE15
395: ,ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY
396: ,LAST_UPDATE_DATE = NVL(P_LAST_UPDATE_DATE,SYSDATE)
397: ,LAST_UPDATED_BY = NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)
398: ,LAST_UPDATE_LOGIN = NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
399: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID
400: RETURNING OBJECT_VERSION_NUMBER INTO X_OBJECT_VERSION_NUMBER;
401:

Line 398: ,LAST_UPDATE_LOGIN = NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

394: ,ATTRIBUTE15 = P_ATTRIBUTE15
395: ,ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY
396: ,LAST_UPDATE_DATE = NVL(P_LAST_UPDATE_DATE,SYSDATE)
397: ,LAST_UPDATED_BY = NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)
398: ,LAST_UPDATE_LOGIN = NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
399: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID
400: RETURNING OBJECT_VERSION_NUMBER INTO X_OBJECT_VERSION_NUMBER;
401:
402: IF (SQL%NOTFOUND) THEN

Line 409: LAST_UPDATED_BY = NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),

405:
406: UPDATE MTL_CROSS_REFERENCES_TL
407: SET DESCRIPTION = P_DESCRIPTION,
408: LAST_UPDATE_DATE = NVL(P_LAST_UPDATE_DATE,SYSDATE),
409: LAST_UPDATED_BY = NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
410: LAST_UPDATE_LOGIN = NVL(P_LAST_UPDATED_BY,FND_GLOBAL.LOGIN_ID),
411: SOURCE_LANG = USERENV('LANG')
412: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID
413: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 410: LAST_UPDATE_LOGIN = NVL(P_LAST_UPDATED_BY,FND_GLOBAL.LOGIN_ID),

406: UPDATE MTL_CROSS_REFERENCES_TL
407: SET DESCRIPTION = P_DESCRIPTION,
408: LAST_UPDATE_DATE = NVL(P_LAST_UPDATE_DATE,SYSDATE),
409: LAST_UPDATED_BY = NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
410: LAST_UPDATE_LOGIN = NVL(P_LAST_UPDATED_BY,FND_GLOBAL.LOGIN_ID),
411: SOURCE_LANG = USERENV('LANG')
412: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID
413: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
414: