52: CLOSE c_collab;
53: END IF;
54: CLOSE c_collab;
55: -- new collab_id
56: SELECT cac_view_collab_details_s.nextval
57: INTO l_seqnum
58: FROM DUAL;
59:
60: CAC_VIEW_COLLAB_DETAILS_PKG.INSERT_ROW(
135: IF c_collab_update%NOTFOUND THEN
136: CLOSE c_collab_update;
137: -- insert here
138: -- new collab_id
139: SELECT cac_view_collab_details_s.nextval
140: INTO l_seqnum
141: FROM DUAL;
142: CAC_VIEW_COLLAB_DETAILS_PKG.INSERT_ROW(
143: X_ROWID => l_row_id,