Line 176: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;
172: ) IS
173: CURSOR C IS SELECT rowid FROM gl_cons_flex_hierarchies
174:
175: WHERE segment_map_id = X_Segment_Map_Id; 176: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual; 177: BEGIN
178:
179: if (X_Segment_Map_Id is NULL) then
180: OPEN C2;