Line 175: SELECT ahl_mel_cdl_headers_s.NEXTVAL INTO p_x_mel_cdl_header_rec.mel_cdl_header_id FROM DUAL;
171: p_x_mel_cdl_header_rec.status_code := 'DRAFT';
172: p_x_mel_cdl_header_rec.version_number := 1;
173: IF (p_x_mel_cdl_header_rec.mel_cdl_header_id IS NULL)
174: THEN 175: SELECT ahl_mel_cdl_headers_s.NEXTVAL INTO p_x_mel_cdl_header_rec.mel_cdl_header_id FROM DUAL; 176: END IF;
177:
178: -- Insert record into backend
179: INSERT INTO ahl_mel_cdl_headers