Line 564: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;
560: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After validating Inputs ' );
561: END IF;
562:
563: IF ( p_x_collection_id IS NULL ) THEN 564: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL; 565:
566: IF G_DEBUG = 'Y' THEN
567: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Getting Collection ID ' );
568: END IF;