procedure insert_header(p_push_date          in date,
                                p_source_serial      in varchar2,
                                p_source_start_date  in date,
                                p_source_end_date    in date
                                ) is

      id_temp number;

      begin
        -- check for errors
        if p_push_date is null
        then
          result_code := 9213;
          --raise_application_error(-RESULT_CODE, 'push_date cannot be null');
        elsif p_source_serial is null
        then
          result_code := 9333;
          --raise_application_error(-RESULT_CODE, 'source_serial cannot be null');


        end if;

        -- if there are no errors, do insert
        if result_code is null
        then
          -- fetch sequence number
          id_temp := header_seq.nextval;
          result_code:=0;

      open o_cur_results for
      select id_temp as id
      from dual;

/*insert into*/
        end if;



        commit;

      end;