DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_CUST_REF_PKG dependencies on FND_GLOBAL

Line 61: ,Nvl(P_LAST_UPDATED_BY, FND_GLOBAL.USER_ID)

57: ,P_SITE_USE_ID
58: ,P_START_DATE
59: ,P_END_DATE
60: ,Nvl(P_LAST_UPDATE_DATE, SYSDATE)
61: ,Nvl(P_LAST_UPDATED_BY, FND_GLOBAL.USER_ID)
62: ,Nvl(P_CREATION_DATE, SYSDATE)
63: ,Nvl(P_CREATED_BY, FND_GLOBAL.USER_ID)
64: ,Nvl(P_LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID));
65:

Line 63: ,Nvl(P_CREATED_BY, FND_GLOBAL.USER_ID)

59: ,P_END_DATE
60: ,Nvl(P_LAST_UPDATE_DATE, SYSDATE)
61: ,Nvl(P_LAST_UPDATED_BY, FND_GLOBAL.USER_ID)
62: ,Nvl(P_CREATION_DATE, SYSDATE)
63: ,Nvl(P_CREATED_BY, FND_GLOBAL.USER_ID)
64: ,Nvl(P_LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID));
65:
66: OPEN C_CHECK_INSERT;
67: FETCH C_CHECK_INSERT INTO l_exists;

Line 64: ,Nvl(P_LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID));

60: ,Nvl(P_LAST_UPDATE_DATE, SYSDATE)
61: ,Nvl(P_LAST_UPDATED_BY, FND_GLOBAL.USER_ID)
62: ,Nvl(P_CREATION_DATE, SYSDATE)
63: ,Nvl(P_CREATED_BY, FND_GLOBAL.USER_ID)
64: ,Nvl(P_LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID));
65:
66: OPEN C_CHECK_INSERT;
67: FETCH C_CHECK_INSERT INTO l_exists;
68: IF (C_CHECK_INSERT%NOTFOUND) THEN

Line 173: ,LAST_UPDATED_BY = Nvl(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)

169: ,SITE_USE_ID = P_SITE_USE_ID
170: ,START_DATE = P_START_DATE
171: ,END_DATE = P_END_DATE
172: ,LAST_UPDATE_DATE = Nvl(P_LAST_UPDATE_DATE,SYSDATE)
173: ,LAST_UPDATED_BY = Nvl(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)
174: ,LAST_UPDATE_LOGIN = Nvl(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
175: WHERE PLN_INFO_ID = P_PLN_INFO_ID
176: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
177: AND ORGANIZATION_ID = P_ORGANIZATION_ID

Line 174: ,LAST_UPDATE_LOGIN = Nvl(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

170: ,START_DATE = P_START_DATE
171: ,END_DATE = P_END_DATE
172: ,LAST_UPDATE_DATE = Nvl(P_LAST_UPDATE_DATE,SYSDATE)
173: ,LAST_UPDATED_BY = Nvl(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID)
174: ,LAST_UPDATE_LOGIN = Nvl(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
175: WHERE PLN_INFO_ID = P_PLN_INFO_ID
176: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
177: AND ORGANIZATION_ID = P_ORGANIZATION_ID
178: AND RELATED_ITEM_ID = P_RELATED_ITEM_ID