DBA Data[Home] [Help]

APPS.CSP_ASL_PUB dependencies on DUAL

Line 205: SELECT CSP_USAGE_HEADERS_S1.NEXTVAL INTO l_header_id FROM DUAL;

201: ELSE
202: l_item_id := p_item_id ;
203: END IF;
204: IF l_item_id IS NOT NULL THEN
205: SELECT CSP_USAGE_HEADERS_S1.NEXTVAL INTO l_header_id FROM DUAL;
206: INSERT INTO CSP_USAGE_HEADERS (USAGE_HEADER_ID,INVENTORY_ITEM_ID,ORGANIZATION_ID,RECOMMENDED_MIN_QUANTITY,
207: RECOMMENDED_MAX_QUANTITY,EXTERNAL_DATA,PROCESS_STATUS,CREATED_BY,
208: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,HEADER_DATA_TYPE)
209: VALUES (l_header_id,l_item_id,l_organization_id, p_recommended_min,p_recommended_max,