Line 1782: SELECT QA_COLLECTION_ID_S.NEXTVAL FROM DUAL;
1778:
1779: PROCEDURE GET_COLLECTION_ID (x_collection_id OUT NOCOPY NUMBER)
1780: IS
1781: CURSOR cid_cur IS 1782: SELECT QA_COLLECTION_ID_S.NEXTVAL FROM DUAL; 1783: BEGIN
1784: OPEN cid_cur;
1785: FETCH cid_cur INTO x_collection_id;
1786: CLOSE cid_cur;