APPS.QA_RESULTS_API dependencies on QA_COLLECTION_ID_S

Line 106: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO x_collection_id FROM DUAL;

102: BEGIN
103: x_collection_id := p_collection_id;
104:
105: IF x_collection_id IS NULL THEN
106: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO x_collection_id FROM DUAL;
107: p_collection_id := x_collection_id;
108: END IF;
109:
110: -- Ankur: Following logic makes sure that if OCCURRENCE is an IN parameter