DECLARE 
    CURSOR sel_ltd is 
        SELECT qrr.qrr_code qrr_code,qrr.qrr_l_desc,qrr.qrr_id rqq_id
        FROM co_req_role_cd qrr
        WHERE qrr.qrr_id IN (
            SELECT ltd.qrr_id 
            FROM lgs_todo ltd
            WHERE TODO_OWNER = :P56_user_id
            AND doneyesno = 0
        ) 
        ORDER BY 1,2;
BEGIN
    IF APEX_COLLECTION.CREATE_COLLECTION(p_collection_name => 'USER_ROLES') THEN
        FOR rec IN Sel_Ltd LOOP 
            APEX_COLLECTION.ADD_MEMBER(
                P_COLLECTION_NAME => 'USER_ROLES',
                P_C001 => rec.Qrr_code,
                P_C002 => rec.L_Desc,
                P_c003 => rec.Qrr_id
            );
        END LOOP;
    END IF;
END;