Insert using a sequence in a nested query in Oracle Database

insert-seq-nested-query-oracle.sql

CREATE SEQUENCE cid_seq
START WITH 100
INCREMENT BY 1;

CREATE OR REPLACE FUNCTION get_next_cseq
RETURN NUMBER AS l_return NUMBER;
BEGIN
    SELECT cid_seq.NEXTVAL INTO l_return FROM DUAL;
    RETURN l_return;
END;
/

INSERT INTO
    orphans
(
    SELECT
        get_next_cseq() AS customer_id,
        name
    FROM
    (
        SELECT
            ...
    )
);