APPS.GMI_ITEM_PUB dependencies on GEM5_ITEM_ID_S

Line 179: SELECT gem5_item_id_s.nextval INTO l_item_id FROM dual;

175: END IF;
176: -- If no errors were found then proceed with the item create
177:
178: -- First get the surrogate key (item_id) for the item
179: SELECT gem5_item_id_s.nextval INTO l_item_id FROM dual;
180: IF (l_item_id <=0)
181: THEN
182: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
183: FND_MESSAGE.SET_TOKEN('SKEY','item_id');