DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_PLN_INFO_PKG dependencies on FND_GLOBAL

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

57: ,P_START_DATE
58: ,P_END_DATE
59: ,P_ALL_CUSTOMERS_FLAG
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_ALL_CUSTOMERS_FLAG
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: RETURNING PLN_INFO_ID INTO X_PLN_INFO_ID;
67:

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: RETURNING PLN_INFO_ID INTO X_PLN_INFO_ID;
67:
68: OPEN C_CHECK_INSERT;

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

169: ,START_DATE = P_START_DATE
170: ,END_DATE = P_END_DATE
171: ,ALL_CUSTOMERS_FLAG = P_ALL_CUSTOMERS_FLAG
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: ,END_DATE = P_END_DATE
171: ,ALL_CUSTOMERS_FLAG = P_ALL_CUSTOMERS_FLAG
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