305:
306: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
307: null;
308: else
309: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
310: INTO l_debrief_number
311: FROM dual;
312: end if;
313: ELSE
316: FROM dual;
317: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
318: null;
319: else
320: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
321: INTO l_debrief_number
322: FROM dual;
323: end if;
324: END IF;