Line 554: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;
550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After validating Inputs ' );
551: END IF;
552:
553: IF ( p_x_collection_id IS NULL ) THEN 554: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL; 555:
556: IF G_DEBUG = 'Y' THEN
557: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Getting Collection ID ' );
558: END IF;