126:
127: l_coll_id NUMBER;
128:
129: BEGIN
130: SELECT qa_collection_id_s.nextval INTO l_coll_id FROM dual;
131: RETURN l_coll_id;
132: END get_collection_id;
133:
134: ---------------------------------------------------
992: p_txn_header_id IN NUMBER) IS
993:
994: CURSOR C1 IS
995: SELECT qa_occurrence_s.nextval
996: FROM DUAL;
997:
998: CURSOR C2(c_collection_id NUMBER) IS
999: SELECT DISTINCT qpt.plan_id
1000: FROM qa_plan_transactions qpt